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