very frustarated, what am I doing wrong?

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

[Shawn319]

Do you have winmysqladmin.exe running in the backround? if not then try running it and trying again.. if you do, then follow the steps on using the GRANT command in mysql ( http://www.eqemu.net/forums/showthre...;threadid=1169 )

[EmuSharky]

REM:--------------Start-----------------------
@echo off
start zoneNT . localhost 7995 127.0.0.1
start zoneNT . localhost 7996 127.0.0.1
start zoneNT . localhost 7997 127.0.0.1
start zoneNT . localhost 7998 127.0.0.1
start zoneNT . localhost 7999 127.0.0.1
exit
cls
REM:---------------END------------------------

Hrmm, Try something like that -- Or Some variation of it. It should work.


-Sharky
EDIT: Typo

[veggita2099]

I did try changeing the 127 ip to the localhost in that file during those attempts and it didn't help any. I have gotten itt o connect to other people's clients but its just not much fun when you don't have complete control :(

I am gonna try shawns idea see if that helps any. I do have that running when I try this though

EDIT:

What do I need to fill in?

What is someid@localhost and what is somepass is that my username and password? like if the username was bigbob and pass was pop would it say


mysql>GRANT ALL PRIVILEGES ON eq.* TO bigpbob@localhost
IDENTIFIED BY 'pop' WITH GRANT OPTION;

or, the less secure but more useful technique that will allow you to log on with that user name from any machine.

mysql> GRANT ALL PRIVILEGES ON eq.* TO someid@"%"
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

[Lurker_005]

mysql>GRANT ALL PRIVILEGES ON eq.* TO bigpbob@localhost
IDENTIFIED BY 'pop' WITH GRANT OPTION;

Yep, change bigpbob to your db.ini username and pop to you db.ini password

You can also use '%'@localhost <-- gives anyone on that computer access as long as password matches
*.* instead of eq.* to give access to all databases
and '%' instead of 'pop' to let any password work

Mix and match the above 3 as you see fit, but actually use a user and password if others will be accessing the server.

[veggita2099]

ok I typed that in the mysql and it don't seem to have done anything. Im sorry I know I look stupid but I have never fooled with any of this before. I am not a hacker or a coder nor a programmer.

I don't know if it gave me access or not

EDIT:

Apparently not since I got the exact same error

[veggita2099]

well now I am getting a error 1064 and it says there is a error with line one of GRANT ALL PRIVILEGES ON eq.* TO bigpbob@localhost
IDENTIFIED BY 'pop' WITH GRANT OPTION;

of course I am useing my real username and password for this. It is 2 lines right? And I do type it exactly how it is showed above (minus of course useing my username and password) don't I? I tried this with 1 and 2 lines and it either does nothing at all or gives this error.

[veggita2099]

I do have a dsl router for my internet connection, but the firewall is down on it, and always has been. Could the router be causeing problems? It shouldn't matter for local login though should it?

[Shawn319]

Okay well your first problem (and the most major one) is that you posted this is the wrong forum.



Second, the router probably is the cause of it.