errors left and right

[MrJohnHead2002]

when i attempt to start my own server using minilogin or with world.exe and the boot5zones, i get tons and tons of errors. I Basically get the word error on each line. and of course when i go to see if i can join my server it says LOCKED next to it. i followed the directions from the readme exactly but i cant seem to get away from these errors. what the heck should i do?

[Shawn319]

That gives me absolutely nothing to go by.. are you planning on fixing it yourself?

[MrJohnHead2002]

ok, when im running the World.exe file, im getting alot of errors that say DB query error, and error #2006 mysql server has gone away. loading guild ranks... DB query error, loading faction data... DB query has gone away. i also get a error saying acces denied for mysql and a failed to connect to database error. just a load of crappy error. i hope that explains it a little bit more.

[Everdude02]

Well if your server is saying locked, that may be an incorrect .exe file execution. Make sure you execute the files in the correct order. 1. Minilogin (If you're using it.) 2. World Server 3. 5 Zones. It will also say locked if you close the World Server, and rerun it while the zones are still running.

[Hardy]

error #2006 mysql server has gone away. loading guild ranks... DB query error, loading faction data... DB query has gone away. i also get a error saying acces denied for mysql and a failed to connect to database error

Are you running winmysqladmin in the backround?

[MrJohnHead2002]

yes i am running winmysqladmin in the background

[Shawn319]

"just a load of crappy errors" doesnt help much.. but the mysql has gone away error helps a little.

can you paste your db.ini (mask the password), loginserver.ini and boot5zones.bat.

also include what OS you are on and paste the error here.

[MrJohnHead2002]

my db.ini

[Database]
host=localhost
user=john
password=(masked)
database=eq

my loginserver.ini

[LoginServer]
loginserver=eqlogin.eqemu.net
worldname=John's Server of Greatness
locked=false
account=
password=
worldaddress=24.128.49.87
loginport=5999

my boot5zones.bat

REM:--------------Start-----------------------


@echo off
start zoneNT . 24.128.49.87 7995 127.0.0.1
start zoneNT . 24.128.49.87 7996 127.0.0.1
start zoneNT . 24.128.49.87 7997 127.0.0.1
start zoneNT . 24.128.49.87 7998 127.0.0.1
start zoneNT . 24.128.49.87 7999 127.0.0.1
exit
cls


REM:---------------END------------------------

i am using Windows XP

if you want me to paste all the errors on the command promp when i start up world.exe, and boot5zones.bat, i dont know how to copy and paste from a command promp sorry.

[Shawn319]

left click the small icon on the top left of window, goto Edit, click Mark. then highlight the text, then hit ENTER. now its on the clipboard (ready to paste)

[MrJohnHead2002]

my world.exe errors

LoginServer.ini read.
Failed to connect to database: Error: Access denied for user: 'john @localho
st' (Using password: YES)
Loading items...DB Query Error
Error #2006: MySQL server has gone away
Error in PopulateZoneLists query 'SELECT MAX(id) FROM items' #2006: MySQL server
has gone away
done.
Loading guild ranks...DB Query Error
Error #2006: MySQL server has gone away
Error in GetGuildRank query 'SELECT id, eqid, name, leader, rank0title, rank1, r
ank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5
title from guilds' #2006: MySQL server has gone away
done.
World server listening on: port 9000
Connected to LoginServer: eqlogin.eqemu.net:5999

my boot5zones.bat errors

Failed to connect to database: Error: Access denied for user: 'john @localho
st' (Using password: YES)
Loading items & NPCs...DB Query Error
Error #2006: MySQL server has gone away
Error in PopulateZoneLists query 'SELECT MAX(id) FROM items' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
Error in LoadNPCTypes query 'SELECT MAX(id) FROM npc_types' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...DB Query Error
Error #2006: MySQL server has gone away
Error in GetGuildRank query 'SELECT id, eqid, name, leader, rank0title, rank1, r
ank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5
title from guilds' #2006: MySQL server has gone away
done.
Loading faction data...DB Query Error
Error #2006: MySQL server has gone away
Error in LoadFactionData 'SELECT MAX(id) FROM faction_list' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
InitWorldServer failed
Entering sleep mode

[Shawn319]

Okay your problem is world.exe connecting to MySQL. btw why did you run the zones when u had errors in world.exe? never go on to the next file unless you dont have errors.

are you running winmysqladmin.exe in the backround?

[MrJohnHead2002]

so... how exactly do i resolve the problem? and yes i do run the winmysqladmin.exe in the background all the time..

[Shawn319]

try the steps in the topic called "Possible fix for 2006 error" hehe.

[MrJohnHead2002]

heh, sorry to bother you again, but that possible 2006 error fix didnt seem to work...

[stormgod]

seems that you had a space at the end of your mysql name : john @localhost should be john@localhost , verify your db.ini for a possible space at the end of your name


actually I tried with addind a space at the end of my mysqlusername and I got the same error so thats it , just remove the space.

(if a coder see that , could you add a trim to the name and password reading , it would remove some errors like that )