problems I have been having (copy of message from other foru

[veggita2099]

Ok I have been sitting here for the past hour and a half trying to get this to work. I have used that other server emulator and had no problems (other then the fact you can't do squat with the other one seems like). Anyways I have followed the readme file verbatem 3 times through and keep getting errors. I have the latest eqw.exe, latest eqemu, and latest mysql. I set the eq database up in mysql as the file said. I copied the db.sql to the mysql/bin folder, I copied the eqhost.txt file to the eq directory (the one for the local login, I did double check it). I have copiedthe spdat.eff file in the eqemu directory. Here is what the files look like. I did copy and not cut these, so I didn't delete any files in the process.

eqhost.txt (which is currently in my eq dir)
[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}
db.ini (which is currently in myeqemu dir)*I obviously didn't post my username/password, but I know they are right*

[Database]
host=localhost
user=username
password=password
database=eq

loginserver.ini (which is in my eqemu dir)
[LoginServer]
loginserver=localhost
worldname=Jimbo's Server
locked=false
account=
password=
worldaddress=localhost
loginport=5999

boot5zones.bat (in the eqemu dir)

REM:--------------Start-----------------------


@echo off
start zoneNT . 127.0.0.1 7995 127.0.0.1
start zoneNT . 127.0.0.1 7996 127.0.0.1
start zoneNT . 127.0.0.1 7997 127.0.0.1
start zoneNT . 127.0.0.1 7998 127.0.0.1
start zoneNT . 127.0.0.1 7999 127.0.0.1
exit
cls


REM:---------------END------------------------


Problem I get is when I run World.exe and Boot5zones.bat. I have the mysql running in the background (has the little traffic signal beside my clock)


When I run minilogin in says:

[loginconfig] block not found in loginserver.ini
server mode : standalone
Login Server Listening on port :5999

Then I run World.exe and it has a bunch of stuff but errors include
Access denied for user myusername
error #2006 my sql server has gone away
error in populatezones list
error in getguildranks...db query error

When I run Boot5zones.bat it gives basically the same errors as world.exe in every window. And If I go ahead adn try to go on eqw.exe it just reboots my computer.

My system is running Windows XP pro I have
amd atholon 1.8
512 megs ram
geforce 3 128megs of ram ti200
cable modem (don't think it should matter?)


So I think my system should be plenty big enough?

Anybody have any idea what I am doing wrong. Like I said I have followed the instructions to the word about 3 times in a row. I have double checked my username/password and I am typeing it in lowercase (which is how I created it). I copied all the files it told me to copy and ran everything from step 1 all the way through.

I was hopeing to set a server up for a friend of mine to join me on, but if I can't get it let me log in local Im not going to attempt that.

I do have a router for my internet connection, and I was told this probably is causeing a problem. Is there anyway useing this local or as a host with a router?

[Arcalyn]

Access denied for user myusername
error #2006 my sql server has gone away

TRY looking at the thread:
Possible fix for 2006 error in mysql

or maybe:

the username and PW for mysql are wrong

fix that first then work on other problems

goto c:\mysql

dbl click winmysqladmin.exe

select the TAB labeled my.ini Setup

scroll down to the bottom and

look at user ???
password ???

then insert those into your db.ini file for EQ emu

[veggita2099]

my username are right, and i am typing it in lowercase which is how it was made.

I looked at that fix for the 2006 error, and either I didn't do it right, or it didn't help

When I did it it didn't say nothing it just went to the next line? I typed it how it was showed in that thread also?

EDIT:
I went and did this useing the *.* instead of eq.* and it said something like Query OK 0 rows effected in 0.0 seconds. I did this last after I reinstalled everything so the setting should have stayed

Still when trying to do the localhost login I get the 2006 error. It lets me go ahead and log in, but the server is locked so bascially I can't do anything there.

I just reinstalled the eqemu AND mysql and started from step 1 and still same exact error!

[Lurker_005]

To make sure mysql is running open command.exe and run mysql. Leave it open, and then try loging in.

You mentioned copying db.sql to your mysql\bin dir, did you source it in?

[veggita2099]

I checked that sticky where you type mysql -u username -p

It asked for my password and I typed it in and it accepted it, so there shouldn't be no problems with that then right?

What do you mean by sourced it in? Do you mean where you open mysql and type:

use eq
source db.sql

When I go into the winmysql admin screen it shows the eq database and has a ton of differthing under it.

I tried once again to connect even though I got the same 2006 errors and it goes to the server screen but my server is locked. This is on LocalHost still.

[Lurker_005]

What happens if you try running just "mysql" without -u username -p

I am not sure this matters, but I don't need to use em, and I was wondering if you did.

[veggita2099]

if I just type mysql it says:

Welcome to mysql monitor. Commands end with ; or \g
your mysql id is 29 to server version ver 3.23.49-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

[Lurker_005]

Well it is definatly the emu not talking to mysql for some reason... perhaps reinstall both and try from the begining. Should take less than an hour...

/boggle

[veggita2099]

I just got done reinstalling Everquest (don't think it would matter but I did it anyways), eqemu, and mysql. I once again followed it through step by step. Same errors. I checked the 2006 fix section and ran the mysql -u username -p and the first time I did get a access error. So I applied the 2006 fix, reran the mysql -u username -p and it said welcome username blah blah blah.

But Same exact errors when I open Minilogin, world.exe and boot5zones.bat. Minilogin I guess is fine just I get that 2006 error and it can't load nothing. And if I try to go on to the server anyways the server is locked and of course I can't connect to it.

I do have the 192 ip address, but what should my ip matter IF I am useing localhost (and localhost is what I have it set up on). I have left MYSQL open, I left the Winmpsqladmin monitor open as well. I can't get rid of the router setup for the internet since we got 3 computer that must share the cable modem.

Once again all firewalls in winxp and within the router are shut off. I have closed all my other programs running in hopes it would help, but it has not.