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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-21-2004, 02:36 AM
Brood
Fire Beetle
 
Join Date: Nov 2002
Posts: 21
Default Error 2006, please help

I get error 2006 with both world.exe and boot5zones. This is what it looks like:

Quote:
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Liberating a country that despises us...
TCP listening on: myno-ipaddress.no-ip.info:9000
World server listening on: myno-ipaddress.no-ip.info:9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1

Hit any key to exit
Now, if it was just a usual error 2006 it would be fine, however, I have a certain un/pw for mysql, and one for this forum. Both of them I have done the grant option thing with, and I have checked and rechecked every time that my winmysqladmin has been up and running all the time, as well as the no-ip program, and the link is up and running. It started when I uninstalled mysql and put it in the proper directory, c:/mysql. I took the MW055_alpha02 database, said:

c:/mysql/bin mysql -u root mysql
Grant all privileges.. my mysql un/pw etc.;
create database eq;
use eq;
source MW055_alpha02.sql;
And it did the correct thing. It created the eq database. Then I made the loginserver.ini look like this:

Quote:
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver=eqlogin2.eqemulator.net
loginserver=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=my servername
worldaddress=myno-ipaddress.no-ip.info
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
Furthermore my db.ini looked like this:

Quote:
# READ README.TXT!

[Database]
host=localhost
user=MySQLuser (and believe me, I've checked and rechecked that it was this)
password=MySQLpassword (same as above)
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.
And my boot5zones:

Quote:
REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . myno-ipaddressno-ip.info 7995 127.0.0.1
start zone . myno-ipaddressno-ip.info 7996 127.0.0.1
start zone . myno-ipaddressno-ip.info 7997 127.0.0.1
start zone . myno-ipaddressno-ip.info 7998 127.0.0.1
start zone . myno-ipaddressno-ip.info 7999 127.0.0.1
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------
As I've said, it all started after uninstalling Mysql and reinstalling it on c: drive. I did this in order to change my un/pw, that was by mistake the same as the eqemu forum one. I did as a guide told me to do here, uninstall mysql, reboot computer, reinstall, reboot, start up winmysqladmin and give un/pw. I then picked a different one, altered db.ini to say the new ones, and gave "grant option.." th
Reply With Quote
 

Thread Tools
Display Modes

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 04:07 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