Is this happening for everyone?

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

solid11 · #7 03-10-2006, 09:53 AM

Well changing that port seemed to work, but I think minilogin isn't working, because it stalls at the login screen after trying to log in. Well here is some logs from the boot up in case it helps others or you all might know what's going on.

<From minilogin startup>

Couldn't open the LoginServer.ini file.
Server mode: MiniLogin
Login server listening on port:5999
13407 New Server connection: 127.0.0.1 port: 19204
0: 65 72 61 74 01 00 00 00 | erat....
0: 00 00 00 00 53 75 6E 20 - 4D 61 72 20 20 35 20 30 | ....Sun Mar 5 0
16: 30 3A 34 35 3A 33 35 20 - 32 30 30 36 00 01 00 00 | 0:45:35 2006....
32: 00 | .
109047 New client from ip: 127.0.0.1 port: 1102
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0001 () Size=13]
00000: 00 02 00 00 00 00 00 00 - 00 00 00 08 00 | .............

Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 () Size=11]
00000: 00 03 00 00 00 00 00 00 - 00 00 00 | ...........

161250 New client from ip: 127.0.0.1 port: 1103
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0001 () Size=13]
00000: 00 02 00 00 00 00 00 00 - 00 00 00 08 00 | .............

Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 () Size=11]
00000: 00 03 00 00 00 00 00 00 - 00 00 00 | ...........

<From World.exe startup>

[Debug] Starting Log: logs/eqemu_debug_world_3788.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.6.5
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_3788.log
[Status] Using database 'luclin' at 127.0.0.1:3306
[Debug] [WORLD__INIT] Loading opcodes..
[Status] EMuShareMem loaded
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=46072
[Debug] [WORLD__INIT] Loading guild ranks..
[Debug] [WORLD__INIT] Loading guild link..
[Status] EMuShareMem loaded
[Status] Loading GuildList from database...
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Starting Log: logs/eqemu_error_world_3788.log
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Error] WorldDatabase::GetLauncherList: #1146: Table 'luclin.launcher' doesn't e
xist
[Debug] [WORLD__INIT] Reboot zone modes OFF
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Setting World to MiniLogin Server type
[Debug] [WORLD__LS] Connected to Loginserver: localhost:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1101
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1101
[Debug] [WORLD__ZONE] [1] Zone started with name . by launcher NONE
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use por
t 7000

<From Zone.exe startup>

[Debug] Starting Log: logs/eqemu_debug_zone_4080.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Log settings loaded from log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone_4080.log
[Status] Using database 'luclin' at 127.0.0.1:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.6.5
[Debug] [ZONE__INIT] Loading opcodes..
[Debug] [ZONE__INIT] Log settings loaded from ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
[Debug] [ZONE__INIT] Loading items
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading npc faction lists
[Status] EMuShareMem loaded
[Status] Loading NPC Faction Lists from database...
[Debug] [ZONE__INIT] Loading loot tables
[Status] Loading Loot tables from database...
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading guilds
[Debug] [ZONE__INIT] Loading guild list
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading factions
[Debug] [ZONE__INIT] Loading titles
[Debug] [ZONE__INIT] Loading AA effects
[Debug] [ZONE__INIT] Loading swarm spells
[Debug] [ZONE__INIT] Loading tributes
[Debug] [ZONE__INIT] Loading corpse timers
[Debug] [ZONE__INIT] Loading commands
Error in GetCommands query 'SELECT command,access from commands' #1146: Table 'l
uclin.commands' doesn't exist
[Debug] [ZONE__INIT] 181 commands loaded
[Debug] [ZONE__INIT] Loading embedded perl XS
[Debug] [ZONE__INIT] Loading quests
[Quest] Starting Log: logs/eqemu_quest_zone_4080.log
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0x43d2b40)
[Quest] Creating EQEmuIO=HASH(0x43da8fc)
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Debug] [ZONE__INIT] Entering sleep mode
[Debug] [NET__WORLD] Connected to World: localhost:9000
[Debug] [ZONE__WORLD] World indicated port 7000 for this zone.
[Debug] [ZONE__INIT] Starting EQ Network server on port 7000