Is this happening for everyone?

solid11 · #1 03-09-2006, 03:05 PM

Thanks for those links ylosh. I transferred my .ini settings to the xml file but it says it needs to connect to a database/mysql, but my settings are right, or the same anyway as my old .ini files. Here they are, and trying to use minilogon also btw.

<?xml version="1.0">
<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>






<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>






<tcp ip="localhost" port="9000" telnet="disable"/>


<key>some long random string</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>127.0.0.1</host>
<port>5999</port>
<username>myname</username>
<password>mypw</password>
<db>luclin</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Here is the error log...

---------------------------------------------
[03.09. - 22:00:55] Starting Log: logs/eqemu_error_world_4024.log
[03.09. - 22:00:55] Failed to connect to database: Error: #2003: Can't connect to MySQL server on '127.0.0.1' (10061)

---------------------------------------------
[03.09. - 22:00:54] Starting Log: logs/eqemu_debug_world_4024.log
[03.09. - 22:00:54] [WORLD__INIT] Loading server configuration..
[03.09. - 22:00:54] [WORLD__INIT] Log settings loaded from log.ini
[03.09. - 22:00:54] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.6.5
[03.09. - 22:00:54] [WORLD__INIT] Connecting to MySQL...
[03.09. - 22:00:55] [WORLD__INIT_ERR] Cannot continue without a database connection.

Thanks for the help guys.

tallerin · #2 03-09-2006, 03:35 PM

you need to specify the world address

change this 
to this <address>localhost</address>

you have to remove  so it works right

also try putting the DB port back to 3306 not 5999

those are the only 2 things i saw different in your file from mine and mine works great with these 2 settings

solid11 · #3 03-09-2006, 07:17 PM

I tried the changes you suggested but it still says it cannot continue without a database connection(as the error log says above) even though i can access the DB easily with navicat or mysql front, which tells me the grant options are fine in the DB. There is something wrong in the xml is the only thing i can think of. Also, with this new setup, is the start up routine world.exe, eqlaunch.exe, zone.exe? Is that right? and where does minilogin come into play now? I like the fact that all the .ini files are combined now, just figuring out how to do the initial configuration is the problem, thanks all.

**cavedude** · #4 03-10-2006, 12:51 AM

Trying using the local IP instead of 127.0.0.1. As long as the user and pass are OK you should be cool.

TheClaus · #5 03-10-2006, 01:46 AM

Another way to test is to try and log into the db from a command prompt.

That would be the following.

mysql -u username -p dbname

It will then prompt you for a password. Put that password in and if you can get in then it is something else with the XML file.

solid11 · #6 03-10-2006, 03:28 AM

First, TheClaus, yes I was able to log into the DB fine from a command prompt. Second, Cave, local IP as in what? Using "localhost" or 192.168.1.100? or something else? Where are you saying to put this? In world? loginserver? ect... I really figured if you have 127.0.0.1 or localhost or what ever on your original .ini files the dev's wouldn't have changed it when they combined them in this xml file.
I have condensed my xml file for ease of view purposes for the moment. Here is what I have that keeps telling me that it's not connecting to the DB so far, and for everything else you don't see assume it is default that comes with the xml.full file because I haven't touched it from what I posted above.

Also, this new setup doesn't assume you have mysql installed on "C:\mysql" does it? When trying to make the connection? Because I have it installed on my second drive as "F:\Mysql"

<?xml version="1.0">
<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>


<address>localhost</address>
<localaddress>192.168.1.100</localaddress>


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


<database>
<host>127.0.0.1</host>
<port>5999</port>
<username>MYUSERNAME</username>
<password>MYPASSWORD</password>
<db>eq</db>
</database>

**cavedude** · #7 03-10-2006, 04:36 AM

Change the db port to default which is 3306, you are using 5999 which is the minilogin server port. So basically, change this:

<database>
<host>127.0.0.1</host>
<port>5999</port>
<username>MYUSERNAME</username>
<password>MYPASSWORD</password>
<db>eq</db>
</database>

To this:

<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>MYUSERNAME</username>
<password>MYPASSWORD</password>
<db>eq</db>
</database>

That's your problem. However, if it still doesn't work, change 127.0.0.1 to 192.168.1.100 or whatever your local IP is.