#2003 Error (Boot5zones.bat)

[Mrfolx]

Alrighty, Iv got everything ready to run my server and as it opens the 5 windows after loading the zones, it gives me a "MySQL Error #2003 means you were unable to connect to the mysql server. For information ect. ect. ect... I went to search, found the following and provided no help for my situation.. possible I could get further assistance please :)

http://www.eqemulator.net/forums/viewtopic.php?t=11836&highlight=2003

http://www.eqemulator.net/forums/viewtopic.php?t=10989&highlight=2003

http://www.eqemulator.net/forums/viewtopic.php?t=8757&highlight=2003

There are absolutely no spaces in my ini's nor in the Boot5Zones.bat...

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 ZoneDebug.exe freportw. 24.162.26.61 7995 127.0.0.1
start ZoneDebug.exe arena. 24.162.26.61 7996 127.0.0.1
start ZoneDebug.exe nexus. 24.162.26.61 7997 127.0.0.1
start ZoneDebug.exe bazaar. 24.162.26.61 7998 127.0.0.1
start ZoneDebug.exe freportn. 24.162.26.61 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------------------------


### --- 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
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Zebuxoruk
worldaddress=24.162.26.61
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

# READ README.TXT!

[Database]
host=localhost
user=user
password=password
database=eq
timestamp=4-9-2002 1640


### --- This file tells world.exe what computer mySQL is on. Host should
###

Anything im not doing right perhaps? I do have the spells_en.txt file with boot5zones.exe also...
This is my error Message when I try to boot up

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[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: 24.162.26.61:9000
World server listening on: 24.162.26.61:9000
===============================
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

Is there a reason why it cannot connect to my DB? I have the newest DB from Sourceforge, something im not doing right..

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away

Im not sure why it cannot connect
Also, I do not have mysql_nt running in the background, that just gives me another error and I took the advice from another topic not to have that open. Is there something im doing wrong in MySql, should I be running a server in mysql?

[mattmeck]

you didnt grant yourself permition to use it :shock:

do a search for granting permition or the error #, there is many many ways to fix this error but some work for some people and others for other people. Just keep trying all you see till you find the one that works for you.

[wize_one]

would use zone.exe not the debug version..also check your grant statement so the emu can connect to your DB

[Mrfolx]

Alright, dumb mistake but what do I put in between the * *?

grant all privileges on *.* to yourmysqlusernamehere@localhost identified by 'yourmysqlpasswordhere' with grant option;

the topic did'nt say

[wize_one]

from dos
change dir to your mysql dir

then

mysql -u root mysql
grant all privileges on *.* to username@localhost identified by 'password' with grant option;

change the username to the name you have for mysql and password to the password...leave the ticks in

[Mrfolx]

I dont use my login to eqemu, correct? I use the one I signed in for
WinMySQLadmin correct? sorry to say again but what do I put in between the *.* in

grant all privileges on *.* to yourmysqlusernamehere@localhost identified by 'yourmysqlpasswordhere' with grant option;

Do I use Localhost?

[mattmeck]

let it like it is.

[Mrfolx]

Ok, it said..

Query OK, 0 rows affected <0.03 sec>

What do I do next?

[mattmeck]

see if it fixxed it =)

[Mrfolx]

ok, I closed mysql and im still getting #2003

[wize_one]

useing zone.exe now or still the zonedebug.exe read b4 someone had probs with the debug version

[Mrfolx]

I have the zone.exe file... read what?

[mattmeck]

start ZoneDebug.exe freportw. 24.162.26.61 7995 127.0.0.1
start ZoneDebug.exe arena. 24.162.26.61 7996 127.0.0.1
start ZoneDebug.exe nexus. 24.162.26.61 7997 127.0.0.1
start ZoneDebug.exe bazaar. 24.162.26.61 7998 127.0.0.1
start ZoneDebug.exe freportn. 24.162.26.61 7999 127.0.0.1

you are using a ZONEDEBUG version of the zones file, Also there is newer binaries so you may want to take this time to get the new binaries that dont use that debug.

[wize_one]

change your boot5zones.bat from

start ZoneDebug.exe freportw. 24.162.26.61 7995 127.0.0.1
start ZoneDebug.exe arena. 24.162.26.61 7996 127.0.0.1
start ZoneDebug.exe nexus. 24.162.26.61 7997 127.0.0.1
start ZoneDebug.exe bazaar. 24.162.26.61 7998 127.0.0.1
start ZoneDebug.exe freportn. 24.162.26.61 7999 127.0.0.1

to


start Zone.exe freportw. 24.162.26.61 7995 127.0.0.1
start Zone.exe arena. 24.162.26.61 7996 127.0.0.1
start Zone.exe nexus. 24.162.26.61 7997 127.0.0.1
start Zone.exe bazaar. 24.162.26.61 7998 127.0.0.1
start Zone.exe freportn. 24.162.26.61 7999 127.0.0.1


see if that works..if not just move up to the new dr3 and start from scratch

[Mrfolx]

Aye I did that, I changed the zone thing, still got the connection problem, if I had it zonedebug still it wouldnt have even let me boot up and would have closed the windows real fast.. hmm move to dr3.. could you point to me where to get that? sorry, im lousy :?

[mattmeck]

hmm move to dr3.. could you point to me where to get that? sorry, im lousy

Have you checked the big sticky titled NEWEST BINARIES (yes its all in caps) in the gereral support forum?

[wize_one]

what matt said..hehe

[Mrfolx]

oki doke, ;p thanks, hopefully ill be out of your hair for an hour :) thanks matt and wiz

[erb2k]

Ok I'm having the exact same error on bootup as MrFox only when I try to run mysql -u root mysql, it sends me to the dirrectory that mysql is in instead of running the mysql proggy :-(

Anyone know about this?

erb2k

[valaerosilantix]

ok, I had this trouble for a short time before I realized that SQL is case sensitive


check your db.ini file

make sure the name and password is exact (case sensitive)

Trouble should go away

That error simply means it cant find your database

[mikenune]

ok, I had this trouble for a short time before I realized that SQL is case sensitive
MySQL is only as case sensitive as the OS it's on. If you're running Windows then you don't need to worry about having the correct case. If you're running the MySQL server on Linux then you do.

Query OK, 0 rows affected <0.03 sec>
If it said that 0 rows were affected (which it did) then it never added your user. I've run into that myself. For some reason it wouldn't create users for me through the command line. I would suggest using a program similar to PHPMyAdmin (only if you have a web server on that computer too) or MySQL-Front to create the user.

Or, if you wanna try it again then use the syntax below (just run the first line if your database is on the same computer as World.exe and Zone.exe).

GRANT ALL on [database].* to '[username]'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;
GRANT ALL on [database].* to '[username]'@'%' IDENTIFIED BY '[password]' WITH GRANT OPTION;
Just be sure to replace the bold text with your database name, username, and password.

[lordaltay2]

Remove the "." infront of zone name the period.

[Razukan]

i typed in
mysql>GRANT ALL on eq to (user)@localhost IDENTIFIED BY (Password)WITH GRANT OPTION;

and he gave me that Error:

Error:1064 You have an error in Your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(Password) WITH GRANT OPTION' at line 1

anyone can help me???!!! :P :P :P

[mikenune]

Your password needs to be in quotes. Doesn't matter if it's double or single though.

[Razukan]

IT WORKS!!!!! IM SO HAPPYYY!!!!!! :P :P :P