world server setup help

[les2212]

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]

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

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....

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]

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

[techguy84]

In your original post, at the bottome under the databse information in the eqemu_config.xml file, the <port>3306</port> is right next to the <host> line.

If this is the same way that it appears in your xml file, I dont know if its the probelm, but <port> should be in a line of its own right below it. Like this (excerpt from my config file)

    <!-- Database configuration, replaces db.ini. -->
    <database>
        <host>127.0.0.1</host>
        <port>3306</port>
        <username>root</username>
        <password>Mypassword</password>
        <db>ax_classic</db>
    </database>

Also, what guide did you follow to set up your server. Try to follow the guide in my signature. It's simpler than having multiple Mysql accounts and its pretty much bug free now. Had serveral people get going on first try with it.

[les2212]

was already on a seperate line and im using this guide
http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5
from the looks of it, it is a sql problem right and not a router problem ?

[techguy84]

I dont remember putting in something that made reference to setting up a 'eq' account for mysql. I always use root until I get the hang of mysql, if your not used to using it. Try to to use the root username and the password that you put in when you ran the instance server configuration. By using root, I mean in your eqemu_config.xml file.

Also to note, as I got a pm about this. When you uninstall mysql, you have to also go and remove the files and the directory manualy. In this directory, is a mysql database for itself that contains password and user information. If you do not delete this, and everything else, you will have tons of trouble when reinstalling. So do this, and then remove all the files from your emulator directory. Start back from complete scratch, using only what Is said in my guide, that way you have cut out multiple varibles so it is easier to troubleshoot.

This is just a personal opinion, as you can continue to work at your current set up in hopes of getting it going if you want to.

I know that someone along the lines you strayed from my guide alone as you have the 'eq' username. I know this comes from a early stage 0.7.0 guide as well as older 0.6.x versions. Try to stick with one guide as going between them for any reason is going to cause issues because the writes of the guides use different versions to get the server going. The only guides I recommend used in conjuction with mine are listed in it, and thats the Play Guide at the top, and the minilogin guide at the bottom. With the minilogin guide there are some steps that are not required, and there are some steps that you have to cater to my guide. This is the reason that I suggest using the public login, as there is less varible to look at when there is a problem. Once you get one going with just the basics, you can explore other avenues.

Anyhow, enough with the opinions. Let me know how using the root username goes.

[les2212]

Yes I Deleted The Whole Mysql Folder When Uninstalling. Every One Of The 5 Times I Had To Do It. At No Time Did I Use Eq Or Input Anything Saying Eq But That Is The Error I Got Starting Off Wich Is Why I Granted Eq Access And Reset Its Password As Suggested By Another Member In This Forum Thread. I Am Going To Guess Its A Firewall Problem. I Have Seen Several Threads About This Issue And Noone Seems To Have A Clue How To Fix The Error. Your Suggestion Has Worked In The Past But Isnt Now.