Connect to Gamedb Failed

[worwick]

I install all the files and followed the setup instructions to the "T". Acutually did it several times. I changed all the 127.0.0.1 to MyIpAddress. Everything seems to start up until I get this error.

err Gdeliveryd: Connect to GameDB Failed.

I double checked to make sure the ip address was correct to my server and it is.

I checked the gamesys.conf under GameDbD and I don't see anything wrong.

I have no idea what else to look at.

Thank you.

Here is the gamesys.conf.

[GameDBServer]
zoneid=1
aid=1
type = tcp
port = 29400
address = xx.xx.xx.xx
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 1048576
obuffermax = 1048576
tcp_nodelay = 0
listen_backlog = 10
accumulate = 16777216

[LogclientClient]
type = udp
port = 11100
address = xx.xx.xx.xx
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 16384
obuffermax = 1048576
accumulate = 1048576

[LogclientTcpClient]
type = tcp
port = 11101
address = xx.xx.xx.xx
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 16384
obuffermax = 1048576
accumulate = 1048576

[storage]
homedir = dbhome/
datadir = dbdata/
logdir = dblogs/
backupdir = backup/
cachesize = 16777216
errpfx = Storage
checkpoint_interval = 60
backup_lockfile = /tmp/.lockgamedbd
quit_lockfile = /tmp/.quitgamedbd
compress = 1

[storagewdb]
homedir = dbhomewdb/
datadir = dbdata/
logdir = dblogs/
backupdir = backup/
checkpoint_interval = 60
times_incbackup = 1
tables = auction,city,equipment,friends,messages,status,user,clsconfig,factioninfo,inventory,rolename,storehouse,userfaction,base,config,factionname,mailbox,sellpoint,task,translog,waitdel,gtask,order,shoplog
cache_high_default = 8000
cache_low_default = 7500
base_cache_high = 50000
base_cache_low = 45000
status_cache_high = 50000
status_cache_low = 45000
equipment_cache_high= 50000
equipment_cache_low = 45000
inventory_cache_high= 50000
inventory_cache_low = 45000
backup_lockfile = /tmp/.lockgamedbd
quit_lockfile = /tmp/.quitgamedbd

[gamedbd]
noimportclsconfig = 0

[ThreadPool]
threads = (0,1)(1,15)(****1)(****1)
max_queuesize = 1048576
prior_strict = 1

#½Ç«λÖÓÓϷ·þÎƶԦ¹Øµ
[GameServerRegion]
#ID = Region[left,right,top,bottom]
IDs = 1
1 = -100000,100000,100000,-100000

[Role]
delete_timeout = 604800
;delete_timeout = 60

#¸÷°ҵµijõÅ¢
#ְҵµÄD£¬´Ó¿ªʼ£¬´Îò
[OCCUPATION]
occupations = SWORDSMAN,MAGE,MONK,HAG,ORGE,GENIE,ARCHER,ANGEL

[GENERAL]

#ÈÀսʿ
[SWORDSMAN]
race = 0
posx = 332
posy = 241
posz = 3068
money = 0

hp = 60
mp = 20
vitality = 20
energy = 5
strength = 15
agility = 10

attack_speed = 14
hp_gen = 3
mp_gen = 1
walk_speed = 1.5
run_speed = 3.0
swim_speed = 2.2
flight_speed = 3.0
move_speed = 1

vit_hp = 4
eng_mp = 2
lvlup_hp = 5
lvlup_mp = 3
lvlup_dmg = 1
lvlup_magic = 0
lvlup_defense = 1

#ÈÀ·¨ʦ
[MAGE]
race = 0
posx = 332
posy = 241
posz = 3068
money = 0

hp = 30
mp = 50
vitality = 10
energy = 20
strength = 10
agility = 10

attack_speed = 20
hp_gen = 1
mp_gen = 3
walk_speed = 1.3
run_speed = 2.7
swim_speed = 2
flight_speed = 2.7
move_speed = 0.9

vit_hp = 2
eng_mp = 4
lvlup_hp = 3
lvlup_mp = 5
lvlup_dmg = 1/2
lvlup_magic = 1
lvlup_defense = 1/2

#ÈÀɮÂ
[MONK]
race = 0
posx = 332
posy = 241
posz = 3068
money = 0

hp = 40
mp = 40
vitality = 15
energy = 15
strength = 10
agility = 10

attack_speed = 16
hp_gen = 2
mp_gen = 2
walk_speed = 1.4
run_speed = 2.9
swim_speed = 2.1
flight_speed = 2.9
move_speed = 1

vit_hp = 3
eng_mp = 3
lvlup_hp = 4
lvlup_mp = 4
lvlup_dmg = 1
lvlup_magic = 0
lvlup_defense = 1

#Ѿ«
[HAG]
race = 1
posx = 332
posy = 241
posz = 3068
money = 0

hp = 50
mp = 30
vitality = 15
energy = 15
strength = 15
agility = 5

attack_speed = 16
hp_gen = 2
mp_gen = 2
walk_speed = 1.5
run_speed = 3.1
swim_speed = 2.3
flight_speed = 3.1
move_speed = 1.1

vit_hp = 3
eng_mp = 3
lvlup_hp = 4
lvlup_mp = 4
lvlup_dmg = 1
lvlup_magic = 0
lvlup_defense = 1

#ÑÊ
[ORGE]
race = 2
posx = 332
posy = 241
posz = 3068
money = 0

hp = 65
mp = 15
vitality = 25
energy = 5
strength = 15
agility = 5

attack_speed = 14
hp_gen = 6
mp_gen = 2
walk_speed = 1.4
run_speed = 2.8
swim_speed = 2
flight_speed = 2.8
move_speed = 0.9

vit_hp = 4
eng_mp = 2
lvlup_hp = 5
lvlup_mp = 3
lvlup_dmg = 1
lvlup_magic = 0
lvlup_defense = 1

#÷
[GENIE]
race = 3
posx = 332
posy = 241
posz = 3068
money = 0

hp = 25
mp = 55
vitality = 8
energy = 22
strength = 5
agility = 15

attack_speed = 20
hp_gen = 1
mp_gen = 3
walk_speed = 1.6
run_speed = 3.3
swim_speed = 2.4
flight_speed = 3.3
move_speed = 1.2

vit_hp = 2
eng_mp = 4
lvlup_hp = 2
lvlup_mp = 6
lvlup_dmg = 1/2
lvlup_magic = 1
lvlup_defense = 1/2

#Óâ
[ARCHER]
race = 4
posx = 332
posy = 241
posz = 3068
money = 0

hp = 30
mp = 50
vitality = 15
energy = 15
strength = 10
agility = 10

attack_speed = 14
hp_gen = 2
mp_gen = 2
walk_speed = 1.4
run_speed = 2.8
swim_speed = 2.0
flight_speed = 2.8
move_speed = 0.9

vit_hp = 3
eng_mp = 3
lvlup_hp = 4
lvlup_mp = 4
lvlup_dmg = 1
lvlup_magic = 0
lvlup_defense = 1

#ÓÁ
[ANGEL]
race = 5
posx = 332
posy = 241
posz = 3068
money = 0

hp = 30
mp = 50
vitality = 10
energy = 25
strength = 5
agility = 10

attack_speed = 20
hp_gen = 1
mp_gen = 3
walk_speed = 1.4
run_speed = 2.8
swim_speed = 2.0
flight_speed = 2.8
move_speed = 0.9

vit_hp = 2
eng_mp = 4
lvlup_hp = 3
lvlup_mp = 5
lvlup_dmg = 1/2
lvlup_magic = 1
lvlup_defense = 1/2

[MentaL]

[kidkmaleao]

I install all the files and followed the setup instructions to the "T". Acutually did it several times. I changed all the 127.0.0.1 to MyIpAddress. Everything seems to start up until I get this error.

err Gdeliveryd: Connect to GameDB Failed.

I double checked to make sure the ip address was correct to my server and it is.

I checked the gamesys.conf under GameDbD and I don't see anything wrong.

I have no idea what else to look at.

Thank you.

Here is the gamesys.conf.

[GameDBServer]
zoneid=1
aid=1
type = tcp
port = 29400
address = xx.xx.xx.xx <-- Try Change to 127.0.0.1
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 1048576
obuffermax = 1048576
tcp_nodelay = 0
listen_backlog = 10
accumulate = 16777216

All lines: address = xx.xx.xx.xx
should be replaced by address = 127.0.0.1

Or most common, the Server´s Static IP (192.168.0.10 or 192.168.0.51,etc,etc)

Good Luck

[worwick]

If I change them to 127.0.0.1, I get way more errors. The xx.xx.xx.xx stands for my static IP Address. The only one I left unchanged was the 0.0.0.0 address as the instructions said not to change those.

Any other suggestions?

Thank you.

[kidkmaleao]

If I change them to 127.0.0.1, I get way more errors. The xx.xx.xx.xx stands for my static IP Address. The only one I left unchanged was the 0.0.0.0 address as the instructions said not to change those.

Any other suggestions?

Thank you.

So I suggest a checklist of all the configuration files that make changes to the server IPs!

They are:

\PWServer\gacd\gamesys.conf

\PWServer\gamed\gmserver.conf
\PWServer\gamed\gs.conf
\PWServer\gamed\gs_rollback.conf

\PWServer\gamedb\cashstat.conf
\PWServer\gamedb\gamesys.conf

\PWServer\gdeliveryd\gamesys.conf

\PWServer\gfactiond\gamesys.conf

\PWServer\glinkd\gamesys.conf

\PWServer\logservice\logservice.conf

\PWServer\uniquenamed\gamesys.conf

And finally ... those responsible for headaches, since few know they exist and need to be changed also:

\etc\authd.conf
\etc\gmopgen.xml
\etc\GMserver.conf
\etc\iweb.conf
\etc\table.xml

Now I think the thing goes!

Good luck!!

[worwick]

I will double check them all again. What about the ones that have 0.0.0.0.

Thanks again

[kidkmaleao]

I will double check them all again. What about the ones that have 0.0.0.0.

Thanks again

There is a legend that if you change them, the world explodes!
Ps: Any server works with them there, pointing to 0.0.0.0. Leave them alone!

[worwick]

Thank you.

[rbb138]

it may be that you have a corrupt character database:
to check for this run the command:

(presuming your serverpack in under /PWServer/

cd /PWServer/gamedbd
./gamedbd gamesys.conf

if you get "failed to initialize storage facility" u got a corrupt database which is easily fixable but ill move onto that if thats the case.

[worwick]

This is what i did and it looked fine, but just keeps looping the last part.

root@Dynasty:~/PWServer/gamedbd# ./gamedbd gamesys.conf
info : Begin import clsconfig ...
info : ClsConfig Imported .
info : InitGameDB, Role delete time is 604800.
Base id =5459751057896767488
info : InitGameDB, acquire region(id=1),[l=-100000.0,r=100000.0,t=100000.0,b=-100000.0].
info : Init GameDB successfully.
TRACE : init SellDataImage. maxSellID=0,rolenum=0
info : program started with 18 threads.
info : logclient: OnAddSession
info : logclienttcp: OnAbortSession
info : logclienttcp: OnAbortSession
info : logclienttcp: OnAbortSession
info : logclienttcp: OnAbortSession
info : logclienttcp: OnAbortSession
TRACE : checkpoint begin.
TRACE : checkpoint end.

[worwick]

I went through the start.sh and added pauses to see if I could find where the problem my be coming in at.

Everything said DONE! as it went through each step. Starting GAMEDBD said "Init GameDB successfully".

When it got to the Starting Main World", it keeps doing a trace. Like:

TRACE: checkpoint begin
TRACE: checkpoint end
TRACE: gdeliveryserver::statusannounce,online=0,fakemax=6000, load=0,attrib=268435456

Is this normal?

[worwick]

Stiil not sure if it is running correctly. But I don't have any errors when I run start.sh

Only thing I did was edit the start.sh and added some more seconds to sleep so I could watch each section load.

Now it shows the trace begin/ed thingy. I think its polling information about how many is logged in and all. Just not sure.

Thanks again for you help.