error 2006 need help - Page 2

Lurker_005 · #16 04-15-2002, 09:14 AM

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 · #17 04-15-2002, 09:21 AM

i installed it there

iceman984 · #18 04-15-2002, 10:49 AM

and i did all that

Lurker_005 · #19 04-15-2002, 12:20 PM

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 · #20 04-16-2002, 09:19 AM

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

iceman984 · #21 04-17-2002, 10:02 AM

aww cmon no more suggestions?:(

iceman984 · #22 04-19-2002, 06:02 AM

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 · #23 04-19-2002, 07:16 AM

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.

Code:

start minilogin
start world

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