world server setup help

les2212 · #1 04-23-2007, 01:29 PM

okay i am lousy with sql. i followed the wiki as best i could and fresh installed everything 4 times to try and always got the same result. when i try and log onto world i get this.

[04.23. - 17:30:33] Starting Log: logs/eqemu_error_zone_3776.log
[04.23. - 17:30:33] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

this is my Config.xml and ill tell ya right now im really confuced on this part still.

<?xml version="1.0">
<server>
<world>
<shortname>Eversmack</shortname>
<longname></longname>






<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account>root</account>
<password>megamanX</password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>


<database>
<host>localhost</host> <port>3306</port>
<username>root</username>
<password>megamanX</password>
<db>peq</db> </database>

</server>

techguy84 · #2 04-23-2007, 04:10 PM

Code:

<!-- Loginserver information. -->
<loginserver>
        <host>eqemulator.net</host> 
        <port>5998</port>
        <account>root</account>
        <password>megamanX</password>
</loginserver>

Remove your username and password here, just leave them blank.

Now run this command in mysql

Code:

set password for 'root'@'localhost' = OLD_PASSWORD('Newpassword');

Also, if you followed my guide, I forgot a step in the original guide so here it is.

Copy your spell_en.txt and spell_us.txt files out of your Everquest Directory to you EQEMU directory. This will fix a Zone.exe crash error.

substituting Newpassword for your password. Leave the ' marks in it also.

HnathBST · #3 04-24-2007, 06:58 AM

It appears that somewhere you have set the username eq for your database...

more then likely it is in your minilogin.ini

just check in there and see what the username and password is. you can change it or you can add that user to ur data base.

personally I have seperate users because its a little bit more secure that way

EQ - has all access to my everquest database.

to set this open up a command prompt:
and type

Code:

mysql -u root -p

then your screen should look like this:

Code:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.37-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

then type:

Code:

grant all privileges on ax_peq to eq@'%';

note: my database is named ax_peq
then to change the password:

Code:

set password for eq@'%'=password('eq');

and of course subsitute username and password where applicable.
to test exit mysql and try logging in with eq (mysql -u eq -p) and entering the password.

--hnath

les2212 · #4 04-24-2007, 12:56 PM

thank you hnath, that took care of that error. i made sure to add the 2 files also tech. now i have run into a problem many have had with the 1251 error, i have read thru the forums after doing the search and tried there remedy but didnt get any change. should i uninstall mysql 5.0 and go to 4.1 ? last i see thats available. one thing i also notice , the start ms dos promt script. after world fails to load. the next command is:
Wait for World to finish loading... Press Enter when done.

that commands just comes up that wait isnt a valid command and it has me hit any key and tries to open eqlaunch immediatly.

techguy84 · #5 04-24-2007, 03:50 PM

the line that says Wait for World to Finish should actually have a echo in front of it. If the guide is missing that I will fix it, but it should read

Code:

echo Wait for World to Finish Loading.... Press Enter when its Done!!

Or whatever you want it to say, the echo tells dos that its a text line to display, not a command to run.

The 1251 is where of course, world cant connect to the database. My suggestion is to try one of these two steps.

1. Run this....

Code:

Set Password For 'eq'@'localhost' = OLD_PASSWORD('newpwd')

and substitute of course newpwd for your eq mysql user passowrd. Any time you make a account for mysql, and using a program that is not built for Mysql 5, but instead 4, liek the emu, you have to use this command to set the password format to the old version of Mysql.

2. try using the root username and the passowrd you assigned it when you ran the Mysql Server Instance Configuration Wizard. Also, make sure that when you did this (ran the wizard), you still disable strict mode, and add Best Support for Multilingualism or UTF8 for short.

After that run that set password command from my other post. Here is the reason

EqEmu is built for Mysql 4.0 and Mysql 5 uses new password formats. Running that command makes your password compliant for older programs (EqEmu)

Dont think that Mysql 4.1 works, but I could be wrong, it was a off release that not too many people messed with. When 5 come out, there were several reasons to make the switch so people took the time to learn what needed to be done to make it work with the Emulator.

Anyhow, try these two things and see how they work out.

les2212 · #6 04-25-2007, 02:21 PM

have tried and also
Set Password For 'eq'@'localhost' = OLD_PASSWORD('newpwd')
Set Password For 'peq'@'localhost' = OLD_PASSWORD('newpwd')
Set Password For 'root'@'localhost' = OLD_PASSWORD('newpwd')

just to make sure but still gettting the same code 1251 about the authentication and upgrading sql. I uninstalled and retried the whole thing over and im at the same place with the same error.

also to earlier on the check. i tried opening the eq@ in mysql and the password is not what i have set. apperantly that has something to do with the files i have downloaded altohugh i dont see how cause i took them from the links in the guide