Odd Boot5zones Error....

[Holy_Templar]

For the last couple of days now, i've been experiencing a list of errors when I try to load up the Boot5zones file. My world.exe file has no problems at all. I've tried just about every solution that was presented on this forum, including reinstalling MySQL and EQEmu files. Here is the error message:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.3-DR3
[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 zone names
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] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetNPCTypesCount query 'SELECT MAX(id), count(*) FROM npc_types' #2006:
MySQL server has gone away
Error: Database::LoadNPCTypes-ShareMem: GetNPCTypesCount() returned < 0
[Error] Loading npcs FAILED!
===============================
Runtime errors:

MySQL Error #2003 means you were unable to connect to the mysql server.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=2

Hit any key to exit

Now you're probably thinking that I didnt grant permission to myself, but in fact I did (redid it multiple times). I also have absolutely no white spaces in any files, and i've rewritten db.ini by hand multiple times (deleted old db.ini files). Here are the contents of my boot5zones.bat, db.ini and loginserver.ini files (they are in order as listed):

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_en.txt goto NOSPELL

start Zone.exe . 67.80.233.16 7995 67.80.233.16
start Zone.exe . 67.80.233.16 7996 67.80.233.16
start Zone.exe . 67.80.233.16 7997 67.80.233.16
start Zone.exe . 67.80.233.16 7998 67.80.233.16
start Zone.exe . 67.80.233.16 7999 67.80.233.16

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------------------------

# READ README.TXT!

[Database]
host=localhost
user=ajantiss
password=********
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.

### --- 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
loginport=5997
worldname=Battlegrounds
worldaddress=67.80.233.16
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

My other info is as follows:
OS: Windows XP
MySQL version: MySQLAdmin 4.0.17
EQEmu version: 0.5.3-DR3
Host Type: Public Server

I've tried my best not to pester those on this forum for help, but im to the point where I am just completely clueless as to the reason for this problem. Any help would be greatly appreciated.

[Monrezz]

Try,

mysql -u root eq
GRANT ALL PRIVILEGES ON eq.* TO ajantiss@localhost IDENTIFIED BY 'YourPassword' WITH GRANT OPTION;

Use the password found in your db.ini file.

Monrezz

[Holy_Templar]

Did that many many times already. Just to make sure, I just did it again. Same exact error message though.

[Shawn319]

Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away



This is your only error.


You need to get mysql working hehe.

[Monrezz]

Ctrl + Alt + Delete
Close mysql-nt.exe and winmysqladmin.exe.
Go into C:\Windows and delete my.ini.

Double click winmysqladmin.exe

Setup username/password.

Should fix.

[Holy_Templar]

Tried that 3 seperate times, each with different usernames and passwords, with changing the DB.ini and granting myself privileges each and every time.....same error message though.

I dont know whether this would cause any problems, but MySQL is reporting having both the 02.50 driver (I had removed it awhile ago) and the 03.51 driver (which is still installed). Another thing is that when this error started happening, was about the same time my computer wasnt allowing me to get past the EQ Login screen (gives me a message indicating I cant log into the server). The EQhost file is how it should be to run EQEmu. I had tried EQW and also remaking the shortcut with the patchme put into it, same result.

[Holy_Templar]

Well i've retried everything that was suggested, plus things i've tried in the past....resulting in the same error message.

[samandhi]

This might be off base, but I noticed you used your external (I assume) address in the load5zones.bat file.. This MIGHT or might not help, but if you are running the server all from the same comptuer, put in localhost or 127.0.0.1 in where your ip is, because if you have a firewall or nat issue, your zone is sending out then coming back into your computer via your external ip, as opposed to looking right on your own computer... Which brings me to the next possible cause.. Are you behind a router or firewall?

Also, one reason for not connecting to eqemu login server (possibly) is in your loginserver.ini you have only one loginserver listed. This COULD cause you some login problems, though I doubt it is causing your zone.exe problem. It should look something like this

# READ README.TXT 
[LoginServer] 
loginserver=eqlogin1.eqemulator.net 
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997 
worldname=Battlegrounds 
worldaddress=************* 
locked=false

Also download MySQL front or some gui for db and see if it can connect (just a test ) to your your db. And what is your world.exe saying during all this?

[Holy_Templar]

I have changed the ip to 127.0.0.1 (also tried localhost just for the heck of it) and it didnt make a difference. My firewall is down when doing anything EQEmu related, and im not on a router.

I tried readding (I had deleted the previous file in the hopes that reinstalling the files would help) the loginserver lines into the file, and it didnt make a difference. It still says cant connect to server, and if I try to press connect again, EQ crashes. EQ also crashes upon exiting the login screen and onto the main menu, essentially I have no control over the mouse and the program doesnt respond at all.

Here is what world.exe says:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26619, max id=68199
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: You need to get laid...
TCP listening on: 67.80.233.16:9000
World server listening on: 67.80.233.16:9000
Connected to LoginServer: eqlogin3.eqemulator.net:5997

Concerning MySQL-Front, exactly what server name am I supposed to have? Battlegrounds? Going on 5am here (13 straight hours of trying to fix this is not fun) , so perhaps this is laziness on my part for not looking this up....

[Holy_Templar]

Well after some more trouble shooting for MySQL, I tried these commands in the CMD window:


mysqladmin version
mysqladmin variables
mysqladmin -h `hostname` version variables
mysqladmin -h `hostname` --port=3306 version
mysqladmin -h 'ip for your host' version
mysqladmin --protocol=socket --socket=/tmp/mysql.sock version
telnet localhost 3306

I did them all in that order, and the messages for each are as follows.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Ajantiss>mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:\Documents and Settings\Ajantiss>mysqladmin variables
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:\Documents and Settings\Ajantiss>mysqladmin -h `hostname` version variables
mysqladmin: connect to server at '`hostname`' failed
error: 'Unknown MySQL Server Host '`hostname`' (11001)'
Check that mysqld is running on `hostname` and that the port is 3306.
You can check this by doing 'telnet `hostname` 3306'

C:\Documents and Settings\Ajantiss>mysqladmin -h `hostname` --port=3306 version
mysqladmin: connect to server at '`hostname`' failed
error: 'Unknown MySQL Server Host '`hostname`' (11001)'
Check that mysqld is running on `hostname` and that the port is 3306.
You can check this by doing 'telnet `hostname` 3306'

C:\Documents and Settings\Ajantiss>mysqladmin -h 'ip for your host' version
mysqladmin: connect to server at ''ip' failed
error: 'Unknown MySQL Server Host ''ip' (11001)'
Check that mysqld is running on 'ip and that the port is 3306.
You can check this by doing 'telnet 'ip 3306'

C:\Documents and Settings\Ajantiss>mysqladmin --protocol=socket --socket=/tmp/my
sql.sock version
mysqladmin: ERROR: unknown variable 'protocol=socket'

C:\Documents and Settings\Ajantiss>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306.
No connection could be made because the target machine actively refused it.

Any ideas? I really have no idea why the heck this is happening. Before this, my server was up and running near perfectly.

[samandhi]

No connection could be made because the target machine actively refused it.

There could be two things going on here.. One is that you did NOT get the permission set correctly somehow. My suggestions is to uninstall MySQL, and delete the my.ini file located in c:\windows, reboot your machine just to make sure the changes to the regristy took effect, then reinstall, and reboot again... Now run winmysqladmin.exe from the mysql\bin folder and put in your UN/PW.. Then install your db's and do your grant options...

The other suggestion comes from my days as a tech at a local ISP. Some firewalls act strangely. I have had casees where turning off the firewall did NOT get it done. To explain better; some firewalls, when you disable them it STILL doesnt work (whatever connection you are tryin to make ). This is because disabling it DOESNT open the ports, they are still closed, it just releases its hold on them. You might try and uninstall your firewall (just long enough to test this theory), and see where that takes you. I know this sounds silly, but trust me I have had MORE than a few businesses that have had this very problem. (Or you could try specifically opening those ports, then test them to make SURE the firewall has released them).

Concerning MySQL-Front, exactly what server name am I supposed to have?

Whatever you named your database, not your server name.

[Holy_Templar]

No need to use MySQL-Front, because everything is now working. I am guessing it was the firewall software that did it (did them both at the same time), rather than MySQL software. Thank you very much for the help/suggestions.