[CentOS] Setting up your Aura Kingdom Server

[Roderik Cleays]

i don't know exactly what's happening i used tuan565's thingy but i have the same problem like siraizek
i'm quiet noob in this so if there's any help u can give me, then i'd be grateful :)
also i can't get past step 9 (i mean i'm stuck on it)
i litarly tried anything XD
i keep having "conection timed out"

- - - Updated - - -

i mean like if u could do every little step with a screenshot i'd be gratefull, if it still doesn't work then i guess i'm unlucky :p.

- - - Updated - - -

also do i need to put the server files in the client? as in in its folder?

[Siraizek]

Someone can help me create a user in navicat because you do not understand what they put on page 19, only give the code but do not say how, please help.

with images or explaining how to create the user

[Alin1337]

Someone can help me create a user in navicat because you do not understand what they put on page 19, only give the code but do not say how, please help.

with images or explaining how to create the user

Use default postgres user, you just need to change its password:
sudo -u postgres psql
ALTER USER "postgres" WITH PASSWORD 'new_password';
\q

If that doesn't work , follow this : Bad Request

[flashpec3ooo]

hello friends,
can we please get a new updated virtualbox image with all recent updates? this was suposed to be a easy setup, but with all the extra files and different methods i´ve lost my sight.. its so confusing.. i really hope the master will do his magic and make the people happy.

[Siraizek]

I mean create a user for AK but navicat and I do not understand what on page 19, not only the steps.

So I mention page 19 is where are the codes but not how to get them in navicat

[flashpec3ooo]

i have ingame login working, but i cant connect to chennel 1 or 2. connection faild !

..anyway, i will make it one day,.. thanks for making all this possible!

[Siraizek]

How to create user and password in navicat for the Aura kingdom

Need steps

Imgur: The most awesome images on the Internet

[genz]

Hi guys, everything seems to work fine for me! But I encountered 2 problems:

1. The character's EXP does not increase when I completed the missions or defeated monsters.
2. I cannot enter the cave in mission "Defeate Keda ..."

Seems I've missed something, please help me to fix these problems!



Never mind, I've fixed it, there is something wrong with config.ini when I change language from chinese to english.

[Valmor Silva]

mine files works fine !! and the missions too

[alfieo]

Valmor, can you share the files you are using?

[DJThunder]

Hello,

i try to start the Aura Kingdom Server on CentOS, but how i make this with the path, the server didnt work, because he can't find the setup.ini or the binaries. how i must make the path in the start file that all works fine?

I hope someone can help me with this Problem.

Greetz

DJThunder

[genz]

Server files: Aura Server Files

--> The server files same as Eperty123's files, I just reorganize the files to fit my tutorial.

Client files: Eperty's client

Step by step tutorials - Rewrite of Eperty's tutorial

TOOL REQUIREMENTS

VMWare Workstation / VirtualBox
7-Zip
Navicat
Notepad++
SecureCRT
WinSCP

Use google to find the tool.

INSTALL CENTOS

1. Start up Virtual Box or VMWare

2. Install CentOS 6.8 x64 Minimal

3. Login to CentOS, then type

ifup eth0
ifconfig

to get server IP address

WORKING WITH POSTGRESQL

4. Start SecureCRT and connect to your server with the IP.

To paste in SecureCRT use Shift + Insert.

5. Install PostGreSQL

yum install http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
yum install postgresql93-server postgresql93-contrib

6. Start WinSCP and connect to your server with the IP, then navigate to your "root" directory.

7. Extract "Aura Server Files" & upload "hxsy" folder to "root" directory.

8. Make sure to give it a permission of 777, type this in SecureCRT

chmod 777 /root -R

9. Goto SecureCRT and start PostGreSQL

service postgresql-9.3 initdb
service postgresql-9.3 start

10. Change password of user "postgres" (Ex: xxxxxxxx)

sudo -u postgres psql -c "ALTER user postgres WITH password 'xxxxxxxx';"

11. Connect to user "postgres"

su postgres
psql

12. Create all database

create database ffaccount encoding 'UTF8' template template0;
create database ffdb1 encoding 'UTF8' template template0;
create database ffmember encoding 'UTF8' template template0;
create database itemmall encoding 'UTF8' template template0;

13. Import SQL to database

\c ffaccount
\i '/root/hxsy/SQL/FFAccount.sql';
\c ffdb1
\i '/root/hxsy/SQL/FFDB1.sql';
\c ffmember
\i '/root/hxsy/SQL/FFMember.sql';
\c itemmall
\i '/root/hxsy/SQL/Itemmall.sql';

14. Disconnect user "postgres"

\q
exit

EDIT SOME FILES WITH WINSCP

15. Goto WinSCP, navigate to /var/lib/pgsql/9.3/data

16. Open "pga_hba.conf" and edit

.....
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             0.0.0.0/0            md5
# IPv6 local connections:
host    all             all             ::1/128                 ident
.....

17. Open "postgresql.conf" and edit

.....
listen_addresses = '*'
.....

18. Navigate to /etc/sysconfig/iptables, open "iptables" and edit

.....
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT

-A INPUT -m state --state NEW -m tcp -p tcp --dport 6543 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5567 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5568 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10021 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10022 -j ACCEPT

-A INPUT -j REJECT --reject-with icmp-host-prohibited
.....

19. Goto SecureCRT, and type

service iptables reload

CREATE ACCOUNT IN DATABASE

20. Start Navicat and connect to your Database

21. Goto ff_member -> tb_user -> Query -> New Query

INSERT INTO tb_user (mid, password, pwd) VALUES ('test', 'test', '098f6bcd4621d373cade4e832627b4f6')

pwd is MD5 of your password

22. Goto ff_account -> accounts -> Query -> New Query

INSERT INTO accounts (username, password) VALUES ('test', 'test')

CHANGE SERVER IP ADDRESS

23. In Navicat, goto ff_account -> worlds, change IP "192.168.198.129" to your server IP

24. Goto ff_db1 -> serverstatus, change IP "192.168.198.129" to your server IP

25. In WinSCP, navigate to "hsxy" folder, open all files "setup.ini", find and replace "192.168.198.129" to your server IP

26. Find and replace DB password "xxxxxxxx" to your DB password

27. In client, open connect.ini, change IP "192.168.198.129" to your server IP

28. Patch your server files LoginServer, MissionServer, TicketServer, WorldServer, ZoneServer with AKTools

START SERVER

29. To start server, goto SecureCRT, and type

/root/hxsy/start

Everything done!!!

EXTRA TUTORIALS

- To stop server, goto SecureCRT, and type

/root/hxsy/stop

- To use AKTools, copy all server files to "Fix" folder, open AKTools, enter your server IP -> Convert -> Hex Files

- To extract .pkg files in client, goto AuraExtractor, open quickbms, choose "quickbms.bms", then choose pkg.idx in Client\pkg

.....

[Aeoris]

Awesome guide, bro, but...

I've received a System Error when loggen in with test in game.
I've changed IPs in DB, connect.ini, setup.ini, server bins...

Here's GatewayServer Log: http://pastebin.com/GH5GrrQR

NOTE: Fixed. Just Navicat/ffmember/tb_user/idnum to 1

Now new error:


WorldServer Error:

11159,2016/06/30 12:09:42,[EVENT] == [END of INITIAL DATA LOADING.....] ============================================================ 11160,2016/06/30 12:09:42,Service OK
11161,2016/06/30 12:09:42,Service OK
11162,2016/06/30 12:09:42,RSA size(n) = 256 size(e) = 2
11163,2016/06/30 12:09:42,RSA size(n) = 256 size(e) = 2
11164,2016/06/30 12:09:42,Cannot assign requested address SERVER_IP:5567
11165,2016/06/30 12:09:42,SOCKET 14: closed.
11166,2016/06/30 12:09:42,[SJFramework.cc:111],ERROR: #Network# CSJFramework::InitNetwork -- Network Initial Error.

[genz]

Now new error:

.....

WorldServer Error:

Are you sure that you entered a REAL IP instead of "SERVER_IP" text ???

[Aeoris]

Of course

Files working for Dedicated Server? I use a external IP to make the server multiplayer.