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?