PDA

View Full Version : World.exe and Boot5Zones Problems


Echoes
10-31-2004, 07:58 AM
Now i'm getting error 2005, too many signals on mysql server, plz post answer thx. Boot5zone Says [Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-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 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
[Error] LoadEMuShareMemDLL::Load() failed to load library 'EMuShareMem'. Error=
126
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
[Status] Loading npc faction lists
[Error] LoadEMuShareMemDLL::Load() failed to load library 'EMuShareMem'. Error=
126
[Error] Loading npcs faction lists FAILED!
===============================
Runtime errors:

MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=3

Hit any key to exit
World.exe Says Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-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] Clearing groups..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Unable to clear groups: #2006: MySQL server 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
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10
characters.
[Error] [ChatChannelServer] block not found in ./LoginServer.ini
[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..
Couldn't open './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
You may already be a winner... of the darwin award.
TCP listening on: 67.164.67.38:9000
World server listening on: 67.164.67.38:9000
===============================
Runtime errors:

MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=3

Hit any key to exit

mattmeck
10-31-2004, 08:54 AM
2) In C:\mysql\bin, run mysql.exe

Type into the window:

Code:
GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;



Replace Username with the username you selected above, and Password with the password you selected above.

It should say something like:
Code:
Query OK, 1 Rows Affected, 0.0sec


Note: If you get an error when typing the grant all privileges line:

1) Make SURE you copied the line of code EXACTLY as written and changed username/password. (you need the ''s(apostrophes) around the password. 'example' not "example" or example.)

2) Try opening a command prompt. Type:

Code:
CD C:\mysql\bin


then type

Code:
mysql -u root mysql


And proceed to type the grant all privileges command again.

Echoes
10-31-2004, 09:05 AM
Error 1045, access denied for user: '@localhost' <using password: NO>

Derision
10-31-2004, 09:50 AM
Error 1045, access denied for user: '@localhost' <using password: NO>

If you are getting that error when doing the GRANT command, run mysql like this:

C:\mysql\bin> mysql -u root

and then type in the GRANT commands.

Echoes
10-31-2004, 10:20 AM
I put that in then the GRANT stuff, i got another error but i think im getting closer. 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 'C:\mysql\bin> mysql -u root GRANT ALL PRIVILEGES ON *.* TO (username) mysql>

mattmeck
10-31-2004, 10:37 AM
Code:
CD C:\mysql\bin


then type

Code:
mysql -u root mysql


And proceed to type the grant all privileges command again.

NOT

mysql -u root GRANT ALL PRIVILEGES ON *.* TO (username)

Also

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

Make sure its exactly like that with the proper username and pasword with the pasword in the quotes like it showes

Echoes
10-31-2004, 10:49 AM
Ok, that worked! :D thank you for helping me there. But when i hit Boot5zone i still get a "there are too many connections on the server and it is overloaded.

Echoes
10-31-2004, 02:07 PM
i thought it would help so i installed the PEQ Kunark db, still get same problem with 2005 "the mysql servers are too busy".