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: ok lol its 5999 now.. musta typed it wrong

[iceman984]

still got same error

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

"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 im pissed