Stuck at world.exe :( - Page 2

Astartae · #16 11-25-2003, 06:19 AM

Hey there,

I'm having the same problem: "Error #2006:MySQL sever has gone away." So many people get this problem, I wonder why there isn't a sticky on it yet!

Anyway, I did countles searches on the forum and followed every suggestion. I tried the GRANT ALL PRIVILEGES thing. I tried redoing my ini files with no spaces. I tried redoing the eq database (I've tried the one that came with the 0.5 zip and the 0.5 moving database). Ad Naseum.

I am running out of ideas and searching this site isn't giving me any further help. Anyone who recently fixed this care to tell me what they did that finally worked?

#17 11-25-2003, 06:45 AM

There is a sticky for it thats been a sticky for a long wile now.

http://www.everquestserver.com/forum...pic.php?t=1169

Guess you must have missed it in your haste.

rmm99 · #18 11-25-2003, 07:05 AM

Are you getting a denial trying to do the grant all privileges? If so, start mysql like this:

Code:

mysql -u root -p

hit enter when it asks for password. Then run that grant command again. Let me know if that was the issue, I put it in the guide i'm writing and don't want it to be wrong right out the gate =b

Astartae · #19 11-25-2003, 07:25 AM

Actually mattmeck, I read it but forgot it was a sticky, lol. It didn't help either unfortunately. I'll try that suggestion from rmm99 and post what happened.

Update: tried all that (-u root -p, then grant privileges) and had no difference. My error looks the same as the world.exe quoted above by the original poster.

If it helps, the grant privileges worked fine (OK message).

#20 11-25-2003, 07:41 AM

Are you sure you have the same name / password in the DB.ini file in your Binary folder? should look like this

[Database]
host=localhost
user=mattmeck
password=*******
database=eq
compression=off

This is mentioned in a lot of other post but not in this one yet. Also Check for white space after the name / password

Astartae · #21 11-25-2003, 08:06 AM

Yes, I did all that in db.ini with the mysql user/password. I also rewrote it by hand to make sure nothing odd (invisible characters) might be causing the problem. I also had to download and install odbc for mysql. I thought all of that would fix the problem but no luck.

And right now, I'm just trying to get connected to the main online server network rather than something funny like minserver.

Astartae · #22 11-25-2003, 08:13 AM

And just so there is no confusion, here is my world.exe printout:

Quote:

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[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
Warning: Pants may change during online play.
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1: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

LoginServer.ini:

Quote:

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Astartae's
worldaddress=127.0.0.1
account=
password=
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5997
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

DB.ini

Quote:

[Database]
host=localhost
user=********
password=********
database=eq
compression=off

I'm on a Windows XP with P4 1.4 Gh and 512 mb ram.

Frienzied · #23 11-25-2003, 08:39 AM

Lol, what about me?

Astartae · #24 11-25-2003, 08:42 AM

LOL, What about you? What did you do to fix this problem?

#25 11-25-2003, 08:43 AM

All i can say is you peeps are doing somthing wrong or not doing somthing. Check out the Mysql web site and read the guide they have to granting permitions. It may be quicker for you to do it, then to wait on other people to do it for you, cause at this point thats what people are going to have to do to help you.

Astartae · #26 11-25-2003, 08:46 AM

So, what you are saying is that everything looks right to you and you have no other suggestions?

Well, I guess I'll try searching the mysql site again then. Thanks

Frienzied · #27 11-25-2003, 09:06 AM

Quote:

Originally Posted by Astartae

LOL, What about you? What did you do to fix this problem?

Hey! This is my post! Get your own!! Anyways, I'm just having the 'incorrect version' problem.

jenniferrose · #28 11-25-2003, 09:15 AM

just a suggestion, do you have the right name and password in the db.ini file, also is it directed to the right database name.

good luck

arkaria · #29 11-25-2003, 09:19 AM

All you need to get a server going is here in this old guide.

Some steps might be outdated. But it's all you need.
http://www.eqemu.net/Guide.htm

Astartae · #30 11-25-2003, 11:33 AM

Jeeze, sorry, Frienzied (need to chill?) didn't know you took "your post" so seriously. Thought that we all actually shared posts, on this thing called a forum, with the intention of learning something. And since we were both having the same problem, rather than start a "new post" on the same subject, I thought I'd save space and perhaps combine all our efforts in one post, one place. But if I'd known you'd get so defensive about it I would have posted my own post and hoped for even one response. You must admit that this post has garnered a few responses since I added my posts to it.

And yes, I saw this:

Quote:

Ok, I no longer have the #2006 error!! But where another problem is fixed another problem arises! ~ thanks everyone!

My question to you was, what exactly did you do to fix the error 2006? Do you remember the process?

And wasn't it the intention of your post to find an answer to this problem rather than have people, including you, keep getting it?

jenniferrose - I think I do, but I'll double check everything. Currently I'm reinstalling mysql and the db's - just to make sure it isn't those that's causing this problem.

Thanks, akaria, I'll go thru that guide and see if I can follow it. Hope it is what I need!

- I will post my results (in a seperate post if need be) after I do all this - probably later tonight.