world server setup help

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

[les2212]

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

<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<loginserver>
<host>eqemulator.net</host>
<port>5999</port>
<account></account>
<password></password>

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

<database>
<host>127.0.01</host>
<port>3306</port>
<username>root</username>
<password>megamanX</password>
<db>peq</db>
</database>
</server> "

Sorry i didnt know how to put it in a code window. I followed the guide to the letter setting up pearl and sql. i noticed for pearl it opened i windows version that i couldnt figure out so i had to find the dos prompt version to install the files you had me install. no im not using the mini login yet. havent even mssed with it although it is in the folder.

[les2212]

will show both error logs also

-----------------------
[05.05. - 19:45:08] Starting Log: logs/eqemu_debug_world_3460.log
[05.05. - 19:45:08] [WORLD__INIT] Loading server configuration..
[05.05. - 19:45:08] [WORLD__INIT] Log settings loaded from log.ini
[05.05. - 19:45:08] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[05.05. - 19:45:08] [WORLD__INIT] Connecting to MySQL...
[05.05. - 19:45:08] [WORLD__INIT_ERR] Cannot continue without a database connection.

and
tarting Log: logs/eqemu_error_world_3460.log
[05.05. - 19:45:08] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[techguy84]

Ok, the buttons in the box where you type a post, at the end you will see a # sign. Highlight the text you want to put into a code box, and then click that little # to put code tags around it.

Anyhow, there is multiple formating issues in your config post, dont know if the forums are to blame, or if it looks like that actually in your file, but here is a exact look of what you should see.

<?xml version="1.0">
<server>
    <world>
        <shortname>WorldServ</shortname>
        <longname>Eversmack</longname>
               
    <!-- Only specify these two if you really think you need to. -->
        <!--<address>Serving Machines IP</address>-->
        <!--<localaddress>127.0.0.1</localaddress>-->
       
    <!-- Loginserver information.  -->
        <loginserver>
            <host>eqemulator.net</host>
            <port>5998</port>
            <account></account>
            <password></password>
        </loginserver>

        <!-- Sets the shared key used by zone/launcher to connect to world -->
        <key>some long random string</key>

        <!-- Enable and set the port for the HTTP service. -->
        <http port="9080" enabled="true" mimefile="mime.types" />
    </world>

    <!-- Database configuration, replaces db.ini. -->
    <database>
        <host>localhost</host>
        <port>3306</port>
        <username>root</username>
        <password>megamanX</password>
        <db>peq</db>
    </database>
</server>

Feel free to copy that as it is directly into your eqemu_config.xml file. Cut and Paste to prevent any errors. That is taliored to you so you should have to change anything,

Also, when you put your password in, did you capitalize the X in megamanX also. Did you do this when you ran the

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