World.exe Will Not Load

[billhugh]

I am trying to start a server using minilogin on my local machine.

I have MySql Running
MiniLogin works fine
I have checked db.ini and loginserver.ini several times.

Here's the problem - when I try to run WORLD.EXE I get this:


[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[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
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10
characters.
[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
You may already be a winner... of the darwin award.
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone
away'
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10061'


I have tried tons of stuff. Even the mysql username and password thing to allow anyone access. It just doesn't work.

Any help would be great, this is very frustrating.

[samandhi]

DB Query Error #2006: MySQL server has gone away

That is your problem. You need to close down MySQL and open up windows explorer/my computer, and find the file my.ini in c:\windows. Delete it. Run winmysqladmin.exe from the MySQL/bin folder. This will allow you to put in whatever UN/PW you want... Then, open up a cmd prompt and type the following, replacing username with the one you used in winmysqladmin.exe, and password with the one from winmysqladmin.exe:

mysql -u root mysql
GRANT ALL PRIVILEGES ON *.* TO <your username>@localhost IDENTIFIED BY '<your password>' WITH GRANT OPTION;
quit

NOTE the ' key (apostrophe) has to enclose your password, but NOT your username..

[billhugh]

I went ahead and tried that and it's still giving me the same output? Is there another way to do all this? Maybe I have stuff in the wrong directories?

[Monrezz]

Delete my.ini in C:\Windows and then rerun mysqladmin.exe
Enter the username and password you have in your db.ini.

Run the sql samandhi said, but replace username and password with your username and password from db/my.ini.

[billhugh]

I tried that as well and it allowed me to reset my password for MYSQL but nothing changed. (I read it earlier from the 'One stop error list' post).

Is there an extremely detailed guide somewhere that would help me? Without having to compile anything that is.

Nothing seems to help?!? I actually had this running back in the day...I just don't see what I'm doing wrong. Am I supposed to have everything in certain directories for this to work??

Thanks

[Derision]

One possible cause for the problem you are getting is spaces or strange characters at the end of the lines in your db.ini. Check and delete any spaces, or alternatively delete it and type the contents back in manually (no cut or paste).

[billhugh]

I fixed the problem.

Before my db.ini file read:

[Database]
host=localhost (also tried 127.0.0.1)
user=eqemu
password=eqemu
database=eq
compression=off

I changed it to my actual IP Address:

[Database]
host=192.168.0.146
user=eqemu
password=eqemu
database=eq
compression=off

Now I'm getting some new errors...but's that's a whole other post .

Thanks for the help!!

[billhugh]

Where would I get 5.5 at ?!? An already compiled version.