errors left and right
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?
|
That gives me absolutely nothing to go by.. are you planning on fixing it yourself?
|
sorry
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.
|
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.
|
Quote:
|
yes i am running winmysqladmin in the background
|
"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. |
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. |
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)
|
thanks
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 |
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? |
so... how exactly do i resolve the problem? and yes i do run the winmysqladmin.exe in the background all the time..
|
try the steps in the topic called "Possible fix for 2006 error" hehe.
|
heh, sorry to bother you again, but that possible 2006 error fix didnt seem to work...
|
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 ;) ) |
good eyes stormgod.. that would probably be the problem hehe.. next time i'll look a lil more carefully.
|
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...
|
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
|
Quote:
Famous last words (of shawn319).. RTFM :) Quote:
|
All times are GMT -4. The time now is 11:52 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.