pb with word.exe or bootzone5

[eltharin]

Hi all,
i had all installed eqw,etc.. and configured as the read me txt, mysql eq database created, login and password.
when i lunch eqgame.exe patchme no pb i can play (but i am often disconned with different servers and i have a big lag)

but i have this message error when i lunch

word.exe

loginserver.ini read.
failed to connect to database: error: can t connect to mysql server on localhost' (10061)

error in getvariable query ' select value from variables where varname like 'holdzones' ' #2006: mysql server has gone away

loading zone names & items...error in loadzonenames query 'select max(zoneidnumber) from zone' #2006: mysql server has gone away

error in populatezonelists query' select max(id) from items' #2006: mysql server has gone away
done.
loading guild ranks...error in getguildrank query ' select id, eqid, name, leader, rank0title, rank1, rank1title, rank2, etc.....
world server listening on: port 9000
connected to loginserver: eqlogin2.eqemu.org:5999
login server responded with fatalerror. disabling reconnect.
error message: 'unanemed servers not allowed to connect to full login servers'

and with boot5zones.bat

db query error
error #2006: mysql server has gone away
error in loadnpctypes query' select max(id) from npc_types' #2006 : mysql server has gone away
db query error
spells loaded from ' spdat.eff'.
SAME MESSAGE THAT WORD.EXE
worldserver connect: connecting to the server failed. error: 10061

My config is a celeron 633 with 190Mo, windows Me, eqemu 3.4

my config boot5zones:

@echo off
start zone9x . 127.0.0.1 7995 127.0.0.1
start zone9x . 127.0.0.1 7996 127.0.0.1
start zone9x . 127.0.0.1 7997 127.0.0.1
start zone9x . 127.0.0.1 7998 127.0.0.1
start zone9x . 127.0.0.1 7999 127.0.0.1
exit

my db.ini


[Database]
host=localhost
user=my name
password=my pass
database=eq


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left as localhost unless mysql is
### --- on a differant computer than world.exe.

my eqhost

[Registration Servers]
{
"eqlogin1.eqemu.org:5999"
"eqlogin2.gotfrags.com:5999"
}
[Login Servers]
{
"eqlogin1.eqemu.org:5999"
"eqlogin2.eqemu.org:5999"
"eqlogin3.gotfrags.com:5999"

My loginserver

[LoginServer]
loginserver=eqlogin1.eqemu.org
loginserver2=eqlogin2.eqemu.org
loginserver3=eqlogin3.gotfrags.com
loginport=5999
loginport2=5999
loginport3=5999
worldname=Unnamed server
locked=false
account=
password=
worldaddress=127.0.0.1

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

could you help me pls?
thanks for your futur help )
sorry for my english i am french



:rolleyes:

[Trumpcard]

First, change your server name from 'Unnamed Server'

My guess would be that your mysql database isn't running.

Try this to see if it's working.

Click on the start button, select run. Type 'cmd'

cd C:\mysql\bin
mysql

if it goes to mysql> try this
use mysql;
select * from account;

verify some data comes back.

If something comes back, the problem is somewhere else. If this doesnt work, you need to reinstall mysql.

[eltharin]

thks for your help,
i did that's but i had this message:
ERROR 1146: table 'mysql.account' doesnt exist

:(

[Trumpcard]

Did you source in the db.sql file?

do a 'show tables' and see what tables are there...

I think you need to do the following (after copying db.sql to the bin directory)

mysql>drop database eq;
mysql>create database eq;
mysql>source db.sql;

[eltharin]

yes, when i lunch winmysqladmin i see path EQ with differents path 'account,altadv_vars, etc.....
My db.sql goes to eqemu.0.3.4-win32.exe

:confused:

[eltharin]

i when to do that but it always dont work :(