Log in

View Full Version : World.exe wont connect to MySQL Server O:


Xenerox
07-31-2014, 08:42 AM
Hello Again Apparently Axclassic didnt work out it was too buggy, so on my server pc i did a fresh install of windows 7 ultimate fully updated it took the firewall down and forwarded the ports needed for a EverQuest Server and i followed the Setup guide posted on the eqemulator website here, http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main , also the database im currently useing is from PEQ the daily releases he puts up on his forums , i installed all the needed software to compile the build and i have all of the quests and maps i even put the plugins where there supposed to go so im completely confused as to why world.exe wont connect to mysql when on the same pc i have the full version of navicat and it has no issues connecting to the db with the same info i put in my eqemu_config file any help concerning this issue will be greatly appreciated this is my Eqemu config - the personal info
<!--?xml version="1.0"-->
<server>
<world>
<shortname>Reborn.Tunare</shortname>
<longname>Tunare Reborn, A New Chapter (Custom-Classic) (Development)</longname>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>login.eqemulator.net</host>
<port>5998</port>
<account>Xenerox</account>
<password>xxxxxx</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 enabled="false" mimefile="mime.types" port="9080">
</http></tcp></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 high="7100" low="7000">
</ports></zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>xxxxxxx</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" initial="20000" interval="2000"> -->
</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>

and for the error the server continues to prompt
Cannot Connect To Mysql Useing "localhost"
The Server Cannot Continue Without Database Connection!
again any help with this will be greatly appreciated and thank you again for any support :D

vsab
07-31-2014, 08:50 AM
Try changing localhost to 127.0.0.1

Xenerox
07-31-2014, 08:54 AM
alright i changed the localhost to 127.0.0.1 and it saying it cant use that either

Xenerox
07-31-2014, 09:05 AM
[Debug] WORLD - You should add key>XXXX</key element in your world.exe config to prevent unathorized zone access but the world is up ty so much

Xenerox
07-31-2014, 09:09 AM
also when i try to connect to the server it gives me the same issue axclassic had connection from 10.0.0.7:53798 Unable to Identify Stream , No Match Found!

vsab
07-31-2014, 10:06 AM
Which client are you using- Titanium/RoF/Underfoot? And to be more specific, it should have a build date in the file here:-
C:\Program Files\Sony\EverQuest\Logs\dbg.txt
What is that?

(Obviously C:\Program Files\Sony\EverQuest\ may be different for you, depending on where you installed your client).

Xenerox
07-31-2014, 11:08 AM
hey its me again i fixed most of the issues im useing SoF being i have the discs, and im connected to the server now i must say the developers of the grand creation got their shit together this database is almost like live! tho im having an issue creating a guild on the server keeps saying Error putting charname into guild 1 which i just created. and the servers up and fully playable if you or anyone would like to come on and show me the ropes in how to use this great database it would be most appreciated:D