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 ;) )

[Shawn319]

good eyes stormgod.. that would probably be the problem hehe.. next time i'll look a lil more carefully.

[MrJohnHead2002]

yep, i finally got it to work, thank you very much stormgod. the only other thing i need help with is making myself the serverop. how exactly would i go about doing that...

[stormgod]

there is one way by lanching the world.exe with some parameters forgot which ones , the second one use eqadmin or eee and flag your account with 200 status

[Shawn319]

there is one way by lanching the world.exe with some parameters forgot which ones , the second one use eqadmin or eee and flag your account with 200 status


Famous last words (of shawn319).. RTFM :)


From the readme

**Tip: If you want to flag your account, click Start, Run and type "command" without
the quotes and hit enter (or open the dos prompt your own way).

Type "cd c:\eqemu" without the quotes and hit enter.

Type "world.exe flag accountname 200" without the quotes and hit enter.


Replace accountname with the account name you made at http://www.eqemu.org/login
Replace 200 with whatever status you want (see list below)


Status Listing: 0= Normal, 10= PU, 80= Quest Troupe, 100= GM, 101= GM-Events, 150= LGM, 200= ServerOP
(ServerOP has all commands)