Stuck at world.exe :( - Page 3

Frienzied · #31 11-25-2003, 01:07 PM

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 · #32 11-25-2003, 02:42 PM

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?

Frienzied · #33 11-25-2003, 02:51 PM

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 · #34 11-25-2003, 03:10 PM

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

rmm99 · #35 11-26-2003, 01:36 AM

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

Astartae · #36 11-27-2003, 12:08 AM

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:

Quote:

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

Quote:

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 · #37 11-27-2003, 02:44 AM

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 · #38 11-27-2003, 11:46 AM

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 · #39 11-28-2003, 07:17 AM

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

Quote:

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 · #40 11-28-2003, 12:24 PM

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: