Stuck at world.exe :(

[Frienzied]

Ok! I searched for this everywhere and still no luck..Anyways I get mysql set up ok and everything blah blah then when I click on world.exe I get the follow in MS-DOS:


DB QUERY EEOR #2006:MySQL sever has gone away
Error in loadguilds query 'SELECT id, eqid, name, leader, ministatus, rank0title, rank1, rantktitle, rank2titles, rank3, rank3title, rank 4, rank4title, rank 5, rank5title from guilds' #2006:MySQL server has gone away
[status] Loading addon.ini..
[status]Loading EQ time of day..
Database 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 corpses from database
Liberating country that despises us...
TCP listening on: eqlogin1.eqemu.net:9000
World Server listening on: myip:9000
===================
Runtime errors:

MySQL error #1405 or #2001 means your mysql server rejected the username and password you presented it.
For more information on this error, visit http:www.eqemu.net/eqemuerror.php?id=1

Hit any key to exit
-
Any ideas how to fix this? Thanks in advance... :)

[ndnet]

Do a forum search for your error numbers.

A suggestion from a 30 second search: Make sure that the mysql task is running (CTRL-ALT-DEL and check running processes), if it isn't run winmysqladmin.exe in your \mysql\bin\ directory (a green stoplight icon appears in the systray)

[Richardo]

(Possibly) Your going to have to get the guilds.sql file... Then when you go into MsDos after you get the guild.sql file.. do the following...

c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u username -p eq
(then it will ask for your password)
then type
source guilds.sql;

I may be wrong, im not that sure...

[rmm99]

MySQL error #1405 or #2001 means your mysql server rejected the username and password you presented it.

Your are not using a proper user id / password pair. LOTS of threads here about that. Hard to find in a search, but it is a sticky - read down for the appropriate information. Otherwise visit mysql.com and read up on their permissions for mysql.

http://www.everquestserver.com/forums/viewtopic.php?t=2395

[Kgaul]

did you grant your username privileges in Mysql? if you don't know what i'm talking about then thats your prob...


Kgaul

[Frienzied]

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

[status]x12 loading a whole bunch of stuff nice and smooth then..
You may already be a winner... of the darwin award.
TCP listening on: 12.222.139.201:9000
World server listening on:12.222.139.201:9000
Connected to LoginServer:eqlogin1.eqemulator.net:5999
Login server responded with FatalError. Disabling reconnect.
Error message: 'incorrect version'
24.174.184.4: TCPConnection::RecvData<>: Error:10053
-
Anything I'm doing wrong? Thanks in advance! :)

[a_Guest03]

It would be a good idea to patch eq client to live again. Do a thorough file check to be sure that your files match exactly the files of eqlive. Do not run the eqemu patcher. When done patching eq client to live, update eqhosts.txt again.

[Trumpcard]

Youre connecting to the 0.4.4 logon server...

Use port 5997 if you're running the 0.5.0 server binaries...

[Frienzied]

Youre connecting to the 0.4.4 logon server...

Use port 5997 if you're running the 0.5.0 server binaries...

Ok I changed it to port 5997 and the same errors and I'm updated to live... still not working... :(

[a_Guest03]

Did you run a thorough file check or not?

[Frienzied]

Yes, I ran it.

[mattmeck]

Are you still getting the Guild errors when you start world?

What Binaries are you using the precompiled ones or ones you compiled yourself?


Are there any other errors when you run world or zone?

Have you tried Dropping the DB and redoing it?

What DB are you using?

Were there any errors when you sourced in the DB?

EDIT===Are you able to connect to any other servers?
Give us info!!!!

[Frienzied]

Are you still getting the Guild errors when you start world?

What Binaries are you using the precompiled ones or ones you compiled yourself?


Are there any other errors when you run world or zone?

Have you tried Dropping the DB and redoing it?

What DB are you using?

Were there any errors when you sourced in the DB?

EDIT===Are you able to connect to any other servers?
Give us info!!!!
Are you still getting the Guild errors when you start world? Nope :)

What Binaries are you using the precompiled ones or ones you compiled yourself? Precompiled.


Are there any other errors when you run world or zone? Only the error above.

Have you tried Dropping the DB and redoing it? Nope(will try)

What DB are you using? Don't know what you mean... the one that came with 5.0... I think

Were there any errors when you sourced in the DB? No.

Are you able to connect to any other servers? Yes I can connect to other servers :)

Just want to say thanks for your time everyone.

[jenniferrose]

i couldnt get the db/sql to work from the 5.0 zip either. but i did get the database from tcmyworld to work fine. check under worldbuilding 5.0 database update ect. get the latest alpha one and then the update file from 11-16-03 i think. good luck.

[Frienzied]

i couldnt get the db/sql to work from the 5.0 zip either. but i did get the database from tcmyworld to work fine. check under worldbuilding 5.0 database update ect. get the latest alpha one and then the update file from 11-16-03 i think. good luck.
Ok, I found it and I tried it. Still no go though. I might re-install EQ all over again and remove MYSQL and try again since I have a little bit more knowledge now. But I won't try until tomorrow. I need some sleep now, heh. Anyways if you have any ideas, I still have the problem. Thanks again! :D :)

[Astartae]

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?

[mattmeck]

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

http://www.everquestserver.com/forums/viewtopic.php?t=1169

Guess you must have missed it in your haste. :D

[rmm99]

Are you getting a denial trying to do the grant all privileges? If so, start mysql like this:
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]

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

[mattmeck]

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]

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]

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

:shock:

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:

[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

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

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

:shock:

[Frienzied]

Lol, what about me? ;)

[Astartae]

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

[mattmeck]

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]

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 :roll:

[Frienzied]

LOL, What about you? What did you do to fix this problem? :D
Hey! This is my post! Get your own!! Anyways, I'm just having the 'incorrect version' problem.

[jenniferrose]

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]

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]

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:

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.

[Frienzied]

Lol, I was just playing around. My problem is practically unfixable apparently. So I guess I'm withdrawing from starting my own server. :cry: PS... thank you all for your hard work :)

[Astartae]

OK, I wasn't sure by the way you posted that. Glad to hear it. So, do you know how you got rid of the 2006 error?

I'm still messing with everything. I've completely uninstalled mysql (including my.ini, the mysql folder and the registry settings) and reinstalled. And then resourced the db.sql that came with the win32 Eqemulator5.0.zip into a brand new eq database.

The db.ini and LoginServer are as correct as they could be. And the user name and password are correct.

One other thing, I am running mysql-3.23.58-win with MyODBC-3.51.06. Perhaps I need to download the newest versions available for this new version of EQEmu? Could this be causing the problem?

PS - I followed the guide that was given, just to be on the safe side, and that is EXACTLY the way I've been doing it. The only thing I'm not sure of now is mysql program itself. Maybe 5 was built to find the newer version of mysql (4?).

Any thoughts on this, anyone? :D

[Frienzied]

Here is how I fixed #2006: I tried Grant all privileges on eq.* to Daeroth@localhost with grant option;
Didn't work.
1. Start>run>cmd>dos - Then I did: cd mysql/bin
2.Then the path was: Mysql/bin
3.Mysql -u root mysql
Blah blah blah came up
4. Do Grant all privileges on *.* to name@localhost with grant option;
Just do that no 'eq.*' just *.* then that's it. That's what fixed it for me...I don't think i did anymore than that... but if that doesn't work tell me ;)

[Astartae]

Just tried that. Plenty of S&G's but no luck. I'm starting to think a sledgehammer is the answer... :twisted:

[rmm99]

Astartae - restate the current errors you're getting and your problem, i think it's lost in the shuffle. Also, what OS?

[Astartae]

I posted my world.exe, db.ini and LoginServer.ini data on page 2 as quotes. If you look there, you should find them. And I am on an XP Home Ed. using 512 mb ram and p4 with 1.4 ghz. I set up 4.3 and 4.4 servers with few problems and ran them until something in the eq folder decided to die. ;-)

Now, I am trying to set up the new 5 server and having trouble starting the world.exe file. I've set up db.ini and LoginServer.ini correctly. I've even hand typed them, just to make sure there are no strange invisible characters messing me up. I have mysql 3.23 running on my computer. A few people have mentioned having no problem running them (on Linux I think) but I'm currently downloading 4.0, just to try it out and see if I have any better luck with it. I also installed MyODBC 2.5 and 3.51 just so that it wouldn't show "not found" in that window. I probably didn't need to but I wanted to cover all my bases.

I've tried many different things to get world.exe to work. Most recently I've been trying changing the names of the ip address from my online ip addy (not a static ip) to localhost to 127.0.0.1 in the LoginServer.ini. That didn't make much difference. I also tried changing the ip addy in the db.ini and using the miniserver.exe. Putting localhost or 127.0.0.1 in the db.ini made no difference but when I put in my actual online ip address, I actually got a response between the miniserver.exe and the world.exe.

Here are the printouts:
world.exe:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[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
Assassinating people that whine about horses...done
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: Database Error: Lost connection, attempting to recover
....127.0.0.1:5999

DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone
away'

And here is the miniserver printout:

LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999
127.0.0.1:2656: TCPConnection::RecvData(): Error: 10054

That last line is printed out after I close the world.exe

I have a feeling that I'm forgetting some silly and easy little thing that is going to make me want to smack myself after I fix it. I just wish I'd find that things so I can get in the game finally...

[rmm99]

When you reinstall your MySQL make sure to delete the my.ini file in your windows directory. Try that reinstall and start over with the database.

[Astartae]

I did that actually. And flushed the registry and the mysql folder. And then did a reboot before I reinstalled mysql. I thought that would fix it but it didn't. Then I was very careful about setting up the eq database with the permissions exactly correct.

Do you think that some XP program could be messing with world.exe finding mysql? I thought that I turned all firewalls off (I don't care for them anyway) but maybe there is one on.

But I've tried this on the miniserver as well as the eqemu server with the same results.

[Astartae]

Also when I do the following command at a dos promt, I get this:

C:\Games\EverQ\EQ5 Win>world.exe flag Astartae 200
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
Account being GM Flagged:Astartae, Level: 200
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
database.SetGMFlag failed.

C:\Games\EverQ\EQ5 Win>

[Astartae]

After trying all of this I finally had the idea of changing the case of my username to all lower case. And wow! It worked! I just had a small database error (easy to fix) and presto the world.exe was running just like it should.

So it seems it was a username/password problem but the solution was easier than any of us where thinking. (Lol, isn't that often the case).

I wanted to thank all of you who helped and tried to help. I do appreciate it even if it doesn't get me anywhere. In this case it mostly helped to get me thinking in the right direction...

Edit - lol, now I'm getting that annoying 1017 error. Time to fix that too. ;-) Can't tell I'm happy about this, can you? :P :lol: :)