Is this happening for everyone?

tallerin · #1 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 · #2 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** · #3 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 · #4 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 · #5 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** · #6 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.

tallerin · #7 03-10-2006, 06:12 AM

Quote:

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"

I don't think it matters were it is installed as long as you point the eqemu server to the right port Mysql is listening on it should connect to your DB.

Also as mentioned before by cavedude and I ( cavedude was more clear then i) use port 3306 not 5999 for your database. I changed the port on my .xml and i get the same error as you so i believe if that port was changed your world would connect to your Database.

Quote:

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?

This is my server startup sequence (note i don't use the launcher yet) minilogin world.exe zone.exe so i guess if you have the launcher set up to load say 20 static zones you would go minilogin World.exe Launcher.exe