world server setup help

techguy84 · #1 05-04-2007, 01:11 PM

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 · #2 05-05-2007, 11:35 AM

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 · #3 05-05-2007, 11:44 AM

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 · #4 05-05-2007, 01:22 PM

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.

Code:

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

Code:

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

les2212 · #5 05-05-2007, 02:08 PM

Exact same errors

techguy84 · #6 05-05-2007, 02:56 PM

Well, im kinda at a loss for words. I sent you a pm yesterday, did you get it. Might be a avenue you want to pursue.

les2212 · #7 05-07-2007, 08:46 AM

deleted everything, downloaded all the zips to a folder and followed your guide last night to a tee with even getting the older version of pearl, and im back to the original error. i figured id put as much info into this post to see if we're overlooking something.

operating system- windows xp home addition sp2
files used
ActivePerl-5.8.8.820-MSWin32-x86-274739
EQEmu-0.7.0-992
Maps.tar
new_maps
mysql-essential-5.0.37-win32
WinCvs2_0_2-4

Database - peqdb

for my config you will notice i only changed the password form original script and im sorry i have looked and i dont see the mark to add code for this post.

<?xml version="1.0">
<server>
<world>
<shortname>whatever</shortname>
<longname>Your server name</longname>






<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></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>

my start.bat
@echo off
start world.exe
cls
echo Wait for World to finish loading... Press Enter when done.
pause
start eqlaunch.exe zone
exit

and lastly the errors
---------------------------------------------
[05.07. - 04:51:57] Starting Log: logs/eqemu_debug_world_3040.log
[05.07. - 04:51:57] [WORLD__INIT] Loading server configuration..
[05.07. - 04:51:57] [WORLD__INIT] Log settings loaded from log.ini
[05.07. - 04:51:57] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[05.07. - 04:51:57] [WORLD__INIT] Connecting to MySQL...
[05.07. - 04:51:57] [WORLD__INIT_ERR] Cannot continue without a database connection.

---------------------------------------------
[05.07. - 04:51:57] Starting Log: logs/eqemu_error_world_3040.log
[05.07. - 04:51:57] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

at no point did i put eq in any of the script so im guessing it may be something in the peqdb i patched from wincvs.