world server setup help

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

[Balkon]

Les, I'mhaving the same exact problem, and I think I finally got passed it, but when you do, you will recieve another error that does the same thing. I hope you get it working man, nothing has worked for me, thanks all for helping guys but I guess ima have to try to figure it out on my own. I thought it was my firewall too, but I have enabled the ports on my router, shut my router firewall off, shut my computer windows firewall off, the works, still the same outcome. What I did to get passed that error was I got the administration tool, went into setup variables, then security, and check marked use old passwords, restarted my server, and then the World server still wouldent start, but it was a new error, which you can see on my thread. I hope that helps you a little, also is there an earlier version of EQ emu that runs for the old crappy EQ classic version? I dont want anything fancy, just an oridinary Everquest world that me and my friends can have fun with, but all I have is EQ trilogy, EQ classic, and EQ Titanium. So if there is a trilogy version or classic EQ emu thats easier to set up? I'd like too do that if anyone knows of it.

[techguy84]

Les, can you post your eqemu config file once again. Put it in code quotes. Also, what version of Mysql/Emulator and what database are you running.

Also, what did you do when you install mysql, as far as the instance server config. Did you select Support for UTF8, turn off strict mode ect...

Are you using the minilogin. Or just trying to make your server go on public.