[CentOS] Setting up your Aura Kingdom Server

[shadowafaf]

@genz @Pagefault404 Thanks for the answers.

[blacksystem]

Followed all 57 pages, still stuck at Zoneserver failed to connect, and cannot connect to server error.

All settings on IPs are correct, everything done, yet, still I can only login, but cannot enter any world.

Affected logs:

main client file

2017/01/08 14:52:59 [Desc]LoginServer IP: 192.168.2.5(192.168.2.5), Port 6543
 
2017/01/08 14:53:02 [Desc]WorldServer IP: 192.168.2.5, Port 5567
 
2017/01/08 14:53:03 [Desc]connect ErrCode[10035]

client error file

2017/01/08 17:45:18 [Desc][LOGIN] 
2017/01/08 17:45:21 [Desc][SELECT WORLD SERVER] 
2017/01/08 17:45:23 [Desc]Cannot Connect to WorldSever
 
2017/01/08 17:45:26 [Desc]Free CZone begin... 
2017/01/08 17:45:26 [Desc]Free CZone end...

Loginserver Test.log

    98,2017/01/08 12:45:19,[NE_CL_ServerLoginWorld.cc:61],[DEBUG] Account: [acc01] ignored verification, version and world state bcz connect from LAN

    99,2017/01/08 12:45:19,[NE_CL_ServerLoginWorld.cc:67],[DEBUG] [ 192.168.2.2:(null) ] Name = 'acc01'

   100,2017/01/08 12:45:19,[EVENT] Ticket 1, 0x202A8C0, 0x502A8C0, 0x15BF Sent
   101,2017/01/08 12:45:20,[EVENT] Update population of 2 servers.
   102,2017/01/08 12:45:23,TCP <0x8FDF90:12>: FillBuffer (192.168.2.2 recv 0)
   103,2017/01/08 12:45:23,TCP <0x8FDF90:12>: FillState = LP_READ_ERROR.
   104,2017/01/08 12:45:23,TCP <0x8FDF90:12>: (null) [192.168.2.2] lost link.
   105,2017/01/08 12:45:23,[Session.cc:149],Call Interface.Get (0x8F53A0)->Lost ()

   106,2017/01/08 12:45:23,EVAL(2.838564 secs): {Network I/O}
   107,2017/01/08 12:45:23,EVAL(2.838961 secs): {Main Loop}
   108,2017/01/08 12:45:23,Erase Socket 12
   109,2017/01/08 12:45:23,TCP <0x8FDF90:12>: connection real-closed.
   110,2017/01/08 12:45:23,SOCKET 12: closed.
   111,2017/01/08 12:45:23,Clean Session 0x8DB590

Database configurations

ffdb1 - serverstatus


ffaccount - worlds


Linux server IP configuration


All server files have been patched with AKTools v2 to 192.168.2.5

So, everything is setted correctly, yet Loginserver refusing to accept the connection, so the result is client cannot connect to world server and neither to the Zoneserver, and gets the error Connection to server failed (1).

Been 48h already brainstorming on the issue, if anyone there know a solution, an hand would be appreciated.

(I setted the files in past to another computer and all worked fine, I wanted to "resurrect" my project now, but it seems it won't get past that).

[fluxbox]

Followed all 57 pages, still stuck at Zoneserver failed to connect, and cannot connect to server error.

All settings on IPs are correct, everything done, yet, still I can only login, but cannot enter any world.

Affected logs:

main client file

2017/01/08 14:52:59 [Desc]LoginServer IP: 192.168.2.5(192.168.2.5), Port 6543
 
2017/01/08 14:53:02 [Desc]WorldServer IP: 192.168.2.5, Port 5567
 
2017/01/08 14:53:03 [Desc]connect ErrCode[10035]

client error file

2017/01/08 14:52:56 [Desc][LOGIN] 
2017/01/08 14:52:59 [Desc][SELECT WORLD SERVER] 
2017/01/08 14:53:03 [Desc]Cannot Connect to WorldSever
 
2017/01/08 14:53:06 [Desc]Free CZone begin... 
2017/01/08 14:53:06 [Desc]Free CZone end...

Zoneserver Test.log

   286,2017/01/08 11:51:24,[ZoneServerDB.cc:115],Connected to database [127.0.0.1].
   396,2017/01/08 11:51:24,Service OK
   398,2017/01/08 11:51:25,RSA size(n) = 256 size(e) = 2
   399,2017/01/08 11:51:25,RSA size(n) = 256 size(e) = 2
   400,2017/01/08 11:51:25,Server is rolling on TCP 0.0.0.0:18281888.
   401,2017/01/08 11:51:25,Server is rolling on TCP 0.0.0.0:18254592.
   402,2017/01/08 11:51:25,Server is rolling on TCP 127.0.0.1:20060.
   403,2017/01/08 11:51:25,Connect to 127.0.0.1<0x145AAD0:36>:18624.
   404,2017/01/08 11:51:25,TCP connection: 127.0.0.1:5567 Connection refused   405,2017/01/08 11:51:25,SOCKET 37: closed.

Terminal logs while connecting WorldServer & Zoneserver

    /root/srv/start: line 45:  2400 Floating point exception./WorldServer
[root@ak ~]# "GMCmd.ini" is loaded.
The file "GMCmdOnce.ini" is not found.
    50,2017/01/08 11:55:44,SOCKET 8: accepted by 6
    51,2017/01/08 11:55:44,TCP <0x95A8508:8>: connected from (null) [127.0.0.1].
    52,2017/01/08 11:55:44,Add New Epoll 8
    53,2017/01/08 11:55:44,TCP <0x95A8508:8>: (null) [127.0.0.1] recv error 104: Connection reset by peer
    54,2017/01/08 11:55:44,TCP <0x95A8508:8>: FillState = LP_READ_ERROR.
    55,2017/01/08 11:55:44,TCP <0x95A8508:8>: (null) [127.0.0.1] lost link.
    56,2017/01/08 11:55:44,[Session.cc:149],Call Interface.Get (0x95A4950)->Lost ()

    57,2017/01/08 11:55:44,Erase Socket 8
    58,2017/01/08 11:55:44,TCP <0x95A8508:8>: connection real-closed.
    59,2017/01/08 11:55:44,SOCKET 8: closed.
    60,2017/01/08 11:55:44,Clean Session 0x95A3B18

Database configurations

ffdb1 - serverstatus


ffaccount - worlds


Linux server IP configuration


All server files have been patched with AKTools v2 to 192.168.2.5

So, everything is setted correctly, yet Zoneserver refusing to connect to worldserver apparently, so the result is client cannot connect to world server, and gets the error Connection to server failed (1).

Been 48h already brainstorming on the issue, if anyone there know a solution, an hand would be appreciated.

(I setted the files in past to another computer and all worked fine, I wanted to "resurrect" my project now, but it seems it won't get past that).

Check the main.log (client-side) and post it here.

[blacksystem]

Check the main.log (client-side) and post it here.

Already did, see my edited post http://forum.ragezone.com/f938/cento...5/#post8740515

Everything already included

[fluxbox]

Already did, see my edited post http://forum.ragezone.com/f938/cento...5/#post8740515

Everything already included

Expected line after connecting to WorldServer IP should be ZoneServer IP.
I used to have the same issue and had to hex it from a "clean" bin file (hexed it more than once).

[blacksystem]

Expected line after connecting to WorldServer IP should be ZoneServer IP.
I used to have the same issue and had to hex it from a "clean" bin file (hexed it more than once).

Wait, what you mean by that?
Could you be more specific? Hex what and how?

About the expected lines, well, it can't connect to WorldServer, it won't get past LoginServer.
On server side there is no requests passed to worldserver neither zoneserver, it all ends in loginserver, which refuses/closes the connection or crashes the connection, as you can see by my loginserver.log on past post, no idea why that.

[Pagefault404]

"Could you be more specific? Hex what and how?"

The older clients had a hard IP address in their code. You had to take a hex editor and change this address to get it to connect to your server. I thought this was an old issue, but I guess there are still clients out there that require the zone server address to be hex edited.

If you check the first ten pages or so of this very post, you can see this issue being discussed. Follow the steps in those older posts and see if your client needs to have the address manually added.

[blacksystem]

The older clients had a hard IP address in their code. You had to take a hex editor and change this address to get it to connect to your server. I thought this was an old issue, but I guess there are still clients out there that require the zone server address to be hex edited.

If you check the first ten pages or so of this very post, you can see this issue being discussed. Follow the steps in those older posts and see if your client needs to have the address manually added.[/COLOR]

Well, I went, again, through all 57 pages, nothing found related that

EDIT

solved re-downloading files from first post.
Server files from genz release doesn't work.

However, I see some "starter" items given at character creation, which are erroneous, and random/gift boxes doesn't work, any idea on that?

[Trender]

So I can't run it on CentOS 7 or Ubuntu? Some people in the thread have said that yes you can. Also, anyone got the Client reuploaded?

[nasokha123]

Time to create a database user
14. Go back to SecureCRT and type

sudo -u postgres createuser --superuser <username>

to create a new PostGreSQL super user. It's not required as you can use the default user "postgres". It's up to you. Just make sure to set a password. Do so by typing

alter user <username> password '<password>';

. You must remember to use the ' in the password to let it know it's a string.

15. Now type

su postgres

then

psql

when the 'bash' comes.

16. Create the necessary databases and give them a name of your choice. To create a database type

create database <database name> encoding 'SQL_ASCII' template template0;

. You must end a PostGreSQL command with a ';' otherwise nothing will happen. To import a SQL first connect to the database by typing then .
Caution: You must have the encoding in order to make the database read chinese letters otherwise the server won't let you in. The encoding is case-sensitive as well so make sure you type it as shown. Template is making sure that you can use a custom template of the database creation. Template0 means custom. No further explanation from here.

17. Once done go to Navicat and open up the game- and login server database.
In the game server database find the 'serverstatus' table and edit the IP's to your server's. Do so as well with login server database's 'worlds' table.

18. Open up the start file and replace the paths accordingly so they match yours.

19. Start your server by typing

./start

and you're done!

sorry for this question ..I do not know what to do in this step.is there who can explain clearly

[shadowafaf]

Use @genz tutorial, it's the same but better organized.
http://forum.ragezone.com/f938/cento...ml#post8657409

[nasokha123]

wow.. thanks budy,,
One more question.if I could use a client of this website. to be a client in my server...

AuraKingdom - Private Server - AuraKingdom.to

and what should be edited in addition connect.ini
because I've tried and can not login.

and i can't find "iptable" in "/etc/sysconfig/iptables"


this all my setting


Serversetatus

https://dropbox.com/home/Screenshots...5+15.44.13.png

World

https://dropbox.com/home/Screenshots...5+15.44.18.png

Stup.ini

[Common]
GameDBIP=192.168.1.21
GameDB=FFDB1
GameDBUser=spiritking
GameDBPassword=antiroot
Language=X
Locate=TW
LogFile=Test.log
AccountDBIP=192.168.1.21
AccountDBName=FFAccount
AccountDBUser=spiritking
AccountDBPW=antiroot
TicketServerIP=192.168.1.21
TicketServerPort=18624
BillingGatewayIP=192.168.1.21
BillingGatewayPort=5560
BillingGatewayPaymentIP=192.168.1.21
BillingGatewayPaymentPort=5560
BillingGatewayWorldIP=192.168.1.21
BillingGatewayWorldPort=5560
PlayerRoomWorldID=1010
PingAlive=1
CrossWorldID=1020
TerritoryWorldID=1020
ColosseumWorldID=1020
FightZoneWroldID=1020
MaintenanceDate=2
RankAward=1
NAT=1
AchievementGroupCheck=0
MaxCharacterNumber=12


[MissionServer]
ReserveDeletedCharDays=90
DBAgentSavePeriod=20
MissionServerLogLevel=1
MissionServerAssert=0
GoldRange=10000.50000.100000.200000.500000.1000000.2000000.3000000.10000000.100000000
RecordGoldvalue=1000000


[WorldServer]
LoadServerStatus=1
WorldServerLogLevel=1
WorldServerAssert=0
FarmWorldID=0


[ZoneServer]
HeartBeat=1

[Common]AccountDBIP=192.168.1.21
AccountDBName=FFMember
AccountDBUser=spiritking
AccountDBPW=antiroot
BillingGatewayPort=5560
HttpServerPort=7878

BillingGatewayIP=192.168.1.21HttpServerPort=7878
MaxThreadNum=100
IDBillingURL=192.168.1.21/oauth2/oauth2_new.php
IDGameID=FFDB
IDChkPointThreadNum=5
IDBuyItemThreadNum=5
IDLoginThreadNum=10

TicketServerIP=192.168.1.21TicketServerPort=7777

i use server file from this guy

Credit from tuan565 forum.
https://drive.google.com/file/d/0B9K...ew?usp=sharing
Rarpass : tuan565

Download English client of Eperty123, change IP to : 192.168.1.99 in connect.ini and run ^^
P/s :
Login : root
Pass : antiroot
./ar ( run server)
./stop
ProsgreSQL :
User : spiritking
Pass : antiroot

this my connect setting and test client louncer.exe

https://www.dropbox.com/s/8inhkuzgsa...53.52.png?dl=0

[shadowafaf]

wow.. thanks budy,,
One more question.if I could use a client of this website. to be a client in my server...


and what should be edited in addition connect.ini
because I've tried and can not login.

and i can't find "iptable" in "/etc/sysconfig/iptables"


this all my setting


Serversetatus


World

Stup.ini

[Common]
GameDBIP=192.168.1.21
GameDB=FFDB1
GameDBUser=spiritking
GameDBPassword=antiroot
Language=X
Locate=TW
LogFile=Test.log
AccountDBIP=192.168.1.21
AccountDBName=FFAccount
AccountDBUser=spiritking
AccountDBPW=antiroot
TicketServerIP=192.168.1.21
TicketServerPort=18624
BillingGatewayIP=192.168.1.21
BillingGatewayPort=5560
BillingGatewayPaymentIP=192.168.1.21
BillingGatewayPaymentPort=5560
BillingGatewayWorldIP=192.168.1.21
BillingGatewayWorldPort=5560
PlayerRoomWorldID=1010
PingAlive=1
CrossWorldID=1020
TerritoryWorldID=1020
ColosseumWorldID=1020
FightZoneWroldID=1020
MaintenanceDate=2
RankAward=1
NAT=1
AchievementGroupCheck=0
MaxCharacterNumber=12


[MissionServer]
ReserveDeletedCharDays=90
DBAgentSavePeriod=20
MissionServerLogLevel=1
MissionServerAssert=0
GoldRange=10000.50000.100000.200000.500000.1000000.2000000.3000000.10000000.100000000
RecordGoldvalue=1000000


[WorldServer]
LoadServerStatus=1
WorldServerLogLevel=1
WorldServerAssert=0
FarmWorldID=0


[ZoneServer]
HeartBeat=1

[Common]AccountDBIP=192.168.1.21
AccountDBName=FFMember
AccountDBUser=spiritking
AccountDBPW=antiroot
BillingGatewayPort=5560
HttpServerPort=7878

BillingGatewayIP=192.168.1.21HttpServerPort=7878
MaxThreadNum=100
IDBillingURL=192.168.1.21/oauth2/oauth2_new.php
IDGameID=FFDB
IDChkPointThreadNum=5
IDBuyItemThreadNum=5
IDLoginThreadNum=10

TicketServerIP=192.168.1.21TicketServerPort=7777

i use server file from this guy



this my connect setting and test client louncer.exe

With regard to the launcher I do not know how to use Eperty's client, in connect.ini it is only necessary to edit the ip of the server but before connecting you need to edit iptables to open the server ports, iptables is / etc / sysconfig / Iptables if you are not finding it, just go back one level from the root directory to find all centos directories.

[nasokha123]

Thank you very much @

shadowafaf..

I'm very proud of your answers.
so the conclusion, I have to do is make iptable advance,,that is right?..
thanks for your hellp..

[padilha22]

Hello, I have several errors when I import the tables from the database. Why that?