Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-08-2002, 08:41 PM
eltharin
Fire Beetle
 
Join Date: Jul 2002
Posts: 24
Default pb with word.exe or bootzone5

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



__________________
eltharin
frenchman
eltharindanselune@lycos.fr
Reply With Quote
  #2  
Old 07-09-2002, 12:04 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

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.
Reply With Quote
  #3  
Old 07-09-2002, 01:31 AM
eltharin
Fire Beetle
 
Join Date: Jul 2002
Posts: 24
Default

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

:(
__________________
eltharin
frenchman
eltharindanselune@lycos.fr
Reply With Quote
  #4  
Old 07-09-2002, 02:28 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

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;
Reply With Quote
  #5  
Old 07-09-2002, 02:34 AM
eltharin
Fire Beetle
 
Join Date: Jul 2002
Posts: 24
Default

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

__________________
eltharin
frenchman
eltharindanselune@lycos.fr
Reply With Quote
  #6  
Old 07-09-2002, 02:41 AM
eltharin
Fire Beetle
 
Join Date: Jul 2002
Posts: 24
Default

i when to do that but it always dont work :(
__________________
eltharin
frenchman
eltharindanselune@lycos.fr
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:56 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3