Database connection issue

[zack221]

Hi just wondering if anyone out there could help me with this problem i am recieving. When i start my start.bat file nothing i happens one screen just flashes then closes the other just says:

Wait for world to finish loading. . . Press enter when done.
Press any key to continue. . .

then i just get a blank screen when i press a key.
i checked my log's in the Eqemu folder and this is what i get:

EQemu_debug_world_2308:
---------------------------------------------
[10.18. - 19:49:46] Starting Log: logs/eqemu_debug_world_2308.log
[10.18. - 19:49:46] [WORLD__INIT] Loading server configuration..
[10.18. - 19:49:46] [WORLD__INIT] Log settings loaded from log.ini
[10.18. - 19:49:46] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[10.18. - 19:49:46] [WORLD__INIT] Connecting to MySQL...
[10.18. - 19:49:46] [WORLD__INIT_ERR] Cannot continue without a database connection.

---------------------------------------------
[10.18. - 19:52:46] Starting Log: logs/eqemu_error_world_3296.log
[10.18. - 19:52:46] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Any help with this problem will be greatly appreciated

Thanks

[Theeper]

Can you post the contents your eqemu_config.xml file here please ?

And what version of mysql are you using ?

[FlitTastic]

This sounds like the same exact problem im having, judging by the description he gave. I didnt know about checking the log file, but here is what mine says:

[10.18. - 16:21:43] Starting Log: logs/eqemu_debug_world_3924.log
[10.18. - 16:21:43] [WORLD__INIT] Loading server configuration..
[10.18. - 16:21:43] [WORLD__INIT_ERR] Loading server configuration failed.

Also, the version of Mysql is 5.0.45

The contents of my eqemu_config.xml file:

<?xml version="1.0">
<server>
<world>
<shortname>Marr</shortname>
<longname>Oasis Revisited</longname>

<!-- Only specify these two if you really think you need to. -->
<address>10.1.1.51</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 configureation, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>*******</password>
<db>peq</db>
</database>
</server>

Thanks in advance

[Theeper]

Is your config file in the same directory as world.exe ?

[FlitTastic]

yes, it is.

[FlitTastic]

here is the pic of a screenshot of my eqemulator file:

[FlitTastic]

Ok, I found the problem was that both config files have to have the same information in them, not just the .xml file. Would probably save ALOT of headaches if that was mentioned in the guide, and save literally hours of searching on the forums (I found the answer buried in a post after days of searching, and begging for help). I now have another problem with the zoneserver not working, but ill continue some more days of searching posts until I find the answer there. lol. Thank you to everyone that tried to help, it is, as always, very appreciated.

[zack221]

<?xml version="1.0">
<server>
<world>
<shortname>Euro</shortname>
<longname>customn in dev</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>192.168.1.2</address> -->
<!-- <localaddress>127.0.0.1</localaddress> -->

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

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- 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. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

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

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>


Thats my eqemu_config.xml file and im using MySQL version 5.0.37

[zooilogical]

had this problem solved it by going back to cmd prompt after you source the db in mysql you need to do this line before you exit

set password for ‘root’@’localhost’ = OLD_PASSWORD(‘newpwd’);


Change NEWPWD to your password that you used in the Instance Configuration Wizard, and be sure to leave the quotes in there.
Now you can close the Command Prompt.