error 2006 need help

[iceman984]

made this a few times.... please post here or send me a icq usernames rogue922

[Shawn319]

much better :) i deleted it cause you kept posting it in the wrong forum hehe.. what exactly is the error? i dont have a huge list showing what error #'s are hehe. also post your loginserver.ini, boot5zones.bat, eqhost.txt and what OS you are on.

[iceman984]

heh i was wondering what happend to it then it clicked so i posted it here aaaannnyway here gos...

loginserver.ini read.
failed to connect to database: errot: accsess denied for user: 'xxxx@localhost' (
useing password: yes)
loading items...db query error
error #2006: mysql server has gone away
error in populatezonelists query ' select max(id) from items' #2006: mysql server has gone away
done.
loading guild ranks...db query error
error #2006: mysql server has gone away
error in getguildrank query 'select id, eqid, name, leader, rank0title, rank1, ranktitle, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5 ,rank5title from guilds' #2006 mysql server has gone away
done.
world server listening on: port 9000
loginserver connect: connecting to the server failed. error:10061

that was world.exe heres boot5zones.bat

db query error
error #2006: mysql server has gone away
error in loadnpctypes query 'select max<id> from npc_types' #2006: mysql server has gone away
db query error
error #2006: mysql server has gone away
done.
error #2006: mysql server has gone away
done.
spells loaded from 'spdat.eff'.
loading guild ranks...db query error
error #2006: mysql server has gone away
error in getguildrank query 'select id, eqid, name, leader, rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5title from guids' #2006: mysql server has gone away
done.
loading faction data...db query error
error #2006 mysql server has gone away
db query error
error #2006: mysql server has gone away
done.
worldserver connect: connecting to the server failed error:10061
entering sleep mode

that was with the 9x version of it im useing windows me

heres loginserver.txt

### --- This file tells world.exe what loginserver to connect to.
### --- do not add an account and password unless a EQEmu Dev member has created an account for you.
### --- adding an account and password only grants the server a green name and is not needed.

# READ README.TXT

[LoginServer]
loginserver=localhost
worldname=verant sux
locked=false
account=
password=
worldaddress=(im not telling you guys it lol) but yes i did put in my real one
loginport=5997

[Shawn319]

First, this means your not using the correct login/password in db.ini (you need to use the winmysqladmin l/p), second.. your loginport in loginserver.ini needs to be 5999 (it is 5997 now, where the hell did you get this number from??)

[Shawn319]

by the way (this is from whos online list everyone can see)

iceman984 Viewing Thread ahhhhhhhhhhh!! 10:37 PM BV2-24.207.194.9.charter-stl.com


nice dns there.

[iceman984]

:o :eek: :rolleyes: :D ok lol its 5999 now.. musta typed it wrong

[iceman984]

still got same error:mad:

[Shawn319]

this is your only problem: "failed to connect to database: errot: accsess denied for user: 'xxxx@localhost' "

Aside from the typo you made (errot lol) (try copy/paste next time).. the problem has to do with you connecting to the mysql DB. try running winmysqladmin.exe (keeping it open) and then trying again.. if that doesnt work try changing host=localhost to say host=127.0.0.1

[iceman984]

still gives error

[iceman984]

did both things you suggested

[iceman984]

ok uh i messed around with mysql and got it to grant me all privilges lets see what happens

[Shawn319]

That somteimes helps too. most people dont need to do it though.

[iceman984]

ok im trying agian

[iceman984]

uh ok servers up on the list.... but it says that i gotta run patch when i try to get on it... help...

[iceman984]

:mad: "if i die two more will eagerly jump and take my place" that seems a good referance to whats happening to me... ok theres no more 2006 error but heres whats up now... (yes there are now 2 more errors)

1.without useing minilogin i get it all ready the stuff says exactly what it says it should in the readme so when i get in eq and try to connect it says that i need to repatch....

2.with minilogin i can connect get to the charecter creation screen and when it makes the computer and attempts to add him to the charecter list after a minute or two it still hasint been added and i go ld:mad: im pissed:mad:

[Lurker_005]

Here are the requirements for eqemu to talk to mysql:
1. mysql is running (usually this is a service running in the background)
2. you created a username and login with winmysqladmin
3. you created a database and sourced the db.sql file into it
4. you put the username, password, ip address (127.0.0.1) and database name in db.ini
That should do it.

use world.exe flag eqemu 200 as a mysql conection test.


Something that comes to mind about the mysql install. If you installed to somewhere BESIDES the default c:/mysql there is some configuring you need to do. Read the Mysql documents/readme/web page. Or just reinstall to the default directory.

[iceman984]

i installed it there

[iceman984]

and i did all that

[Lurker_005]

What did it say when you ran the following from a dos prompt?
world flag eqemu 200
or
world adduser eqemu eqemu 200


copy and paste the results here.
It wouldn't hurt to copy and paste your db.ini, and your current loginserver.ini you can put xxxxx to replace your passwords/usernames

[iceman984]

login server read.
useing database 'eq' at localhost
account being gm flagged:eqemu, level: 200
account flagged: username='eqemu', status 200

[iceman984]

aww cmon no more suggestions?:(

[iceman984]

still doesint work and though ethernal quest works now its got less commands.... and it doesint work so good (cant even melle attack!)

[Lurker_005]

Ok, looks like you have mysql running and the emu can connect to the DB. Start your server again, and cut and paste the results again.

Also just to minimize any variations, try adding this to the boot5zones file you use.

start minilogin
start world

boot5zones.... will then run minilogin, world, and the zones for you in the propper order.