EQEmulator Forums
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   #2003 Error (Boot5zones.bat) (https://www.eqemulator.org/forums/showthread.php?t=11557)

Mrfolx 01-25-2004 09:29 AM
#2003 Error (Boot5zones.bat)
 
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/vie...highlight=2003

http://www.eqemulator.net/forums/vie...highlight=2003

http://www.eqemulator.net/forums/vie...highlight=2003

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

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

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
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=
Quote:
# 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

Quote:
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..

Quote:
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 01-25-2004 09:36 AM
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 01-25-2004 09:37 AM
would use zone.exe not the debug version..also check your grant statement so the emu can connect to your DB

Mrfolx 01-25-2004 09:39 AM
Alright, dumb mistake but what do I put in between the * *?

Quote:
grant all privileges on *.* to yourmysqlusernamehere@localhost identified by 'yourmysqlpasswordhere' with grant option;
the topic did'nt say

wize_one 01-25-2004 09:43 AM
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 01-25-2004 09:47 AM
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 01-25-2004 09:49 AM
let it like it is.

Mrfolx 01-25-2004 09:51 AM
Ok, it said..

Quote:
Query OK, 0 rows affected <0.03 sec>
What do I do next?

mattmeck 01-25-2004 09:55 AM
see if it fixxed it =)

Mrfolx 01-25-2004 09:57 AM
ok, I closed mysql and im still getting #2003

wize_one 01-25-2004 09:57 AM
useing zone.exe now or still the zonedebug.exe read b4 someone had probs with the debug version

Mrfolx 01-25-2004 10:11 AM
I have the zone.exe file... read what?

mattmeck 01-25-2004 10:17 AM
Quote:
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 01-25-2004 10:23 AM
change your boot5zones.bat from
Quote:
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

Quote:
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 01-25-2004 10:26 AM
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 :?


All times are GMT -4. The time now is 05:38 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.