Re: [HELP] persistent error
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.
Re: [HELP] persistent error
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
Re: [HELP] persistent error
run the command
cd <your pw folder path>\gamedbd
./gamedbd gamesys.conf
and paste output here.
Re: [HELP] persistent error
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
Code:
[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
Re: [HELP] persistent error
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
Re: [HELP] persistent error
Quote:
Originally Posted by
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.
Can you fix my database? Have only one character... :):