EQ Admin error?

[Satransisu]

http://www.geocities.com/blackmudder420/eqadmin.JPG for screenshot.. paste into browser.. cant click on link cause geocities doesnt allow direct linking of images...

I put in my correct DB password/user name and my correct IP.. not sure of how to cure this problem..

[Maranwe]

It's the same problem as you are having with world.exe... the database isn't allowing the username and password combo to connect.

Try restarting everything...

remove databases, locate and delete my.ini, reboot, run winmysqladmin, remake userid and password, run mysql from a command line window (start, programs, accessories, command if you are using old style windows start menu on your XP theme setup, otherwise should be start, all programs, accessories, command) to recreate and re-source database data. Then exit mysql but leave the command window up and at the mysql\bin directory prompt and type "mysql.xex --user=root eq" where eq is the name of your EQEmu database you just created. With mysql running in the command window like that try the GRANT command again.

Maranwe

P.S. You might want to look into using EQAdmin Tool 4.6 rather than 4.0 as well but that won't help with this specific issuel.

[Satransisu]

So what your saying, is delete everything, and start over again?

[Satransisu]

Well I deleted it all, redid it.. got mob spawns and such to work.. but EQadmin still giving same error.. some special directory this has to be in? No idea what the deal is.. I know for a fact the database name is right, and username/pword.. and i got 4.6

[Maranwe]

OK, I'll tell you exactly, step-by-step, how I got mine to work and we'll go from there... I should note that I've been using version 4.4 developer release 1 with Dwarde's WorldData 1.1. beta 5 database.

Install and Patch EQ

Install EQEmu Patcher program to the EQ directory so that patcher.exe is in the same folder as eqgame.exe

Run EQEmu Patcher

Install MySQL (I'm using version 4.0)

Run WinMySQLAdmin.exe

Set up username and password (we'll use the examples of "username" and "password" for any point that the username and password otherwise need to be used).

Start MySQL Service (in XP this means right clicking on the winmysql icon in teh sys tray, selecting WinNT, and clicking on Start Service)

Close or Hide winmysqladmin so that the service is still running in teh background but the window isn't up anymore

copy all sql files and "items_44dr1.txt" to your MySQL\bin directory

Open a command line window

Use the "cd" (change directory) command to navigate to the MySQL\bin directory

Run mysql.exe

Enter the command: "create database eq;" (the semi-colon tells mysql that is the end of the command, "eq" can be replaced with pretty much anything you want the database to be called but "eq" works great because it's simple and short and doesn't require you have much of a memory or that you type ver much like I tend to)

Enter the command: "use eq;"

Enter the command: "source db.sql"

Enter the command: "source Reloaddb.sql"

Enter the command: "source items_44dr1.txt"

Enter the command: "source books.sql"

Enter the command: "INSERT INTO account SET name='eqemu', password='eqemu', status=200;" where "eqemu" can be replaced by the username and password you intend to use to connect to the minilogin authentication server program (the username and password you will use at the "connect" screen within EQ itself when trying to access the server select screen)

Enter the command: "exit" This will bring you back to the command prompt at the mysql\bin directory

Enter the command: "mysql.exe --user=root eq" where "eq" is the name of the database you created with the "create database" command just a minute ago... this will open up mysql again but with "root" user which gives you total access to all databases and tables

Enter the command: "GRANT ALL PRIVILEGES ON *.* TO username@127.0.0.1 IDENTIFIED BY 'password' WITH GRANT OPTION;" where username and password are the username and password you set up when you first launched WinMySQLAdmin

Enter the command: "exit" This will bring you back to the command prompt

Enter the command: "exit" again This will close the command line window (you can also click on teh "X" on the window)

Install EQEmu Admin Tool

Run EQEmu Admin Tool... you WILL get a couple of errors at this point, don't worry about them yet.

Once EQEmu Admin Tool is running click on the "Preferences" button at the bottum center of the program window

Change the EQ executables directory (if necessary) to point to the proper directory where eqgame.exe is located

Change the username and password fields to contain teh username and password you set up when you first launched WinMySQLAdmin

Change the database (if necessary) to match the database name you set up with mysql.exe's "create database" command

Change database host IP (if necessary) to 127.0.0.1

Click OK

At this point the EQEmu Admin Tool SHOULD properly connect to the database and load the data.

It should be noted that I've had trouble getting EQEmu Admin Tool to properly read database information using the databases I listed above and to get it to work properly I created database "eq2" and sourced the following files... db.sql from Emu version 4.3, items_44dr1.txt, books.sql... I did NOT source db.sql from version 4.4 dr 1, nor did I source reloaddb.sql. Once I did that and set EQEmu Admin Tool to connect to database "eq2" it worked fine.

Hope that info helps some.

Maranwe

[Torakk99]

Enter the command: "source items_44dr1.txt"
ok what is this, and is it a file (items_44dr1.txt)? If so where the heck do I get it lol, I need some details on this step and as much info about it as possible, like what it is,what it does and where do you get it hehe :) :) thanks so much gang


Merrywine the Great Took