[HELP] persistent error

[thebigba]

./startcryingandcomplainingandbeggingforhelp.sh

gamedb is having a problem.

gdelivery cannot connect to it..

i have noticed, though i have no idea how to fix it,( i been trying for a week with different server setups) , that the gamedb process isn't starting or it start and stops i don't know which.

I have xampp installed , I used phpmyadmin to add dbo.sql to my dbo database. Xampp has full security password on all options.

I noticed that table.xml uses a jdbc connector, was not sure if that came with xampp for linux so I downloaded the libmysql-java and it installed though i'm not sure how to use it since it seems
gamedb cannot access my databse.

when I start the service everything seems to work ok, but gamedb shows

importing clsconfig but never seems to finish importing just goes to the next step, i try to look at logs for explantions as to whats happening but it dosn't show me.

i know many people have had a gdelivery gamedb problem but the only answers i have found is check your ip's , and paths, and i assure you have done that many times all the ip's in the configs have been changed to my lan-ip with the exception of the ones that were set at 0.0.0.0.

all the paths have been corrected to suitable settings.

i can connect to iweb abd pwadmin just fine and they are connecting to my database. so why isn't the game?

is there somewhere else in the game files that i should enter my mysql user name and password other than table.xml?

when i ./stop.sh the only process thats not already running is gamedb :no process found.

can some please help me kill this error?

[MentaL]

[rbb138]

ok, first off mysql databases are not used by gamedbd.

gamedbd uses compressed internal files as databases, and their path can be found in your gamedbd's gamesys.conf

check this file for any problems like: IP issues, port mis-matches, does the path to the databases exist?, does the current database have executable permissions on it?
(your database is stored under \<some path>\dbwhomedb\dbdata\)

also, you might want to check the startup output for clues.
if you see any "failed to initalize" etc message, then you have a corrupt database which i can fix for you.

its obvious your gamedbd isnt actualy starting (hence the output on the ./shop.sh) so its looking more likely as a database storage problem or a corrupt database.

[thebigba]

thanks for replying, i changed the paths to the database information.
was originally at dbf/home (which did not exist) and dbf/homewdb.
didn't seem to solve the problem though.

as there are no errors other than
err:gdelivery : : connect to gamedb failed

[rbb138]

run the command
cd <your pw folder path>\gamedbd
./gamedbd gamesys.conf

and paste output here.

[thebigba]

root@perfect-desktop:/PWServer/gamedbd# ./gamedbd gamesys.conf
info : Begin import clsconfig ...
Illegal instruction
root@perfect-desktop:/PWServer/gamedbd#


EDIT: this is my gamesysconfig filefor gamedbd

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

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

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

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

[storagewdb]
homedir			=	/PWServer/gamedbd/dbhomewdb
datadir			=	dbdata
logdir			=	dblogs
backupdir		=	/PWServer/gamedbd/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

[thebigba]

eh think i found the problem, seems i have a shit processor that doesnt support sse2. well i guess i try a colinux version on my play computer and see if i can play and run server from the same computer

[Liza Deco]

ok, first off mysql databases are not used by gamedbd.

gamedbd uses compressed internal files as databases, and their path can be found in your gamedbd's gamesys.conf

check this file for any problems like: IP issues, port mis-matches, does the path to the databases exist?, does the current database have executable permissions on it?
(your database is stored under \<some path>\dbwhomedb\dbdata\)

also, you might want to check the startup output for clues.
if you see any "failed to initalize" etc message, then you have a corrupt database which i can fix for you.

its obvious your gamedbd isnt actualy starting (hence the output on the ./shop.sh) so its looking more likely as a database storage problem or a corrupt database.

Can you fix my database? Have only one character...