How to set up Aura Kingdom Server on CentOS

[Hycker]

-Start the server
-try to log in
-DON'T SHUT DOWN THE SERVER AT THIS POINT
-Press ctrl+r in winscp while u are in any folder
-logs should appear
-profit

 

[Nozad]

-Start the server
-try to log in
-DON'T SHUT DOWN THE SERVER AT THIS POINT
-Press ctrl+r in winscp while u are in any folder
-logs should appear
-profit

you want test.log right?



WorldServer
test.log

1,2017/06/06 22:28:33,Setup.ini Load MaxCharacterNumber [12] 2,2017/06/06 22:28:33,Open Database Failed:hostaddr=127.0.0.1 user=postgres password='Zxcv1234' dbname=ffdb11



ZoneServer
test.log

286,2017/06/06 22:28:38,Open Database Failed:hostaddr=127.0.0.1 user=postgres password='Zxcv1234' dbname=ffdb11




loginserver
test.log

You must be registered to see links

 

[ferasn]

The logs tell the problem itself.
Worldserver and zone server are not connecting to the db.
Change ip in setup.ini to your centos vm ip and put the correct username and password.

Don't forget to edit setup.ini for ticketserver also, it's an important step for the server to work.

 

[Nozad]

The logs tell the problem itself.
Worldserver and zone server are not connecting to the db.
Change ip in setup.ini to your centos vm and put the correct username and password.

change all the ips right?
[Common]
GameDBIP=127.0.0.1
GameDB=ffdb11
GameDBUser=postgres
GameDBPassword=Zxcv1234
Language=X
Locate=US
LogFile=Test.log
AccountDBIP=127.0.0.1
AccountDBName=ffaccount
AccountDBUser=postgres
AccountDBPW=Zxcv1234
TicketServerIP=127.0.0.1
TicketServerPort=18624
BillingGatewayIP=127.0.0.1
BillingGatewayPort=5560
BillingGatewayPaymentIP=127.0.0.1
BillingGatewayPaymentPort=5560
BillingGatewayWorldIP=127.0.0.1
BillingGatewayWorldPort=5560
PlayerRoomWorldID=1010
PingAlive=1
CrossWorldID=1020
TerritoryWorldID=1020
ColosseumWorldID=1020
FightZoneWroldID=1020
MaintenanceDate=2
RankAward=1
NAT=0
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

 

[ferasn]

Yes and also in setup.ini in the gateawayserver

 

[Hycker]

Change 127.0.0.1 to localhost or to the ipv4 IP from eth0. To get that just run
ifconfig

 

[Nozad]

Yes and also in setup.ini in the gateawayserver

new thing happend with the same problem
worldserver
test.log

You must be registered to see links

Change 127.0.0.1 to localhost or to the ipv4 IP from eth0. To get that just run
ifconfig

yeah i did that bri but there is new logfile form WorldServer with error in it if you may take a look at it

 

[Hycker]

Your database is totally broken. Guess when u downloaded the files u didn't checked / care about sql errors. There is ownership regards to eperty in every file so u need u rewrite it then drop all ak database and recreate with the fixed one

 

[Nozad]

Your database is totally broken. Guess when u downloaded the files u didn't checked / care about sql errors. There is ownership regards to eperty in every file so u need u rewrite it then drop all ak database and recreate with the fixed one

sorry guys for this long talking i'v made but in a simple word what should i do now just give me steps like you did with log files

 

[Hycker]

Open any sql file what u downloaded with npp
Search for owner
Must be epery"something"
Search and replace
Search for eperty"something"
Replace with your psql username
Save and exit
Go to psql with ur favorite manager
Drop all AK related database
Recreate em
Import sql files what u made in 2, 3, and 4 step
If there is error drop databases again and do it via command line (tutorial given in first post)
Start your server

 

[Nozad]

Open any sql file what u downloaded with npp
Search for owner
Must be epery"something"
Search and replace
Search for eperty"something"
Replace with your psql username
Save and exit
Go to psql with ur favorite manager
Drop all AK related database
Recreate em
Import sql files what u made in 2, 3, and 4 step
If there is error drop databases again and do it via command line (tutorial given in first post)
Start your server

ddo you have any good database that will work without any problem ?

 

[Hycker]

U have to make it for yourseld

 

[Nozad]

U have to make it for yourseld

sorry lol i mean server files

 

[Hycker]

Lazy.... I'm out now. If u give up at the first time leave from ak section. That's not one click repack

 

[Nozad]

Lazy.... I'm out now. If u give up at the first time leave from ak section. That's not one click repack

no i will do it no matter what thank you i really really appreciate your help
thank you so much

 

[padilha22]

Does anyone have files without a bug? No bug in fishing or quest?

 

[ferasn]

here's a guide to setup server files and sql files to work with no issues

of course, this will NOT include how to use VM, setup CentOS, postgreSQL.
it's just to prepare your server files with your VM ip so you can upload it to your VM and start it with no connection issues

 

[Nozad]

the game worked good but i still have this little problem you will see it below

and could i make it work with ak.to client ?

 

[ferasn]

This is due to the client font is not installed on your OS, you can find the font files in the client (or unpacked client, i don't remember exactly).

And no, there's no way you can run ak.to client on these server files, but using genz modified client should be fine, it contains lv 80 content.

 

[Nozad]

This is due to the client font is not installed on your OS, you can find the font files in the client (or unpacked client, i don't remember exactly).

And no, there's no way you can run ak.to client on these server files, but using @genz modified client should be fine, it contains lv 80 content.

didnt work mate same issue but thank you any way ^_^