2 days in still no server. Looking for some tips please.

arcadius · #1 08-26-2012, 07:55 PM

I have been following mostly this guide (http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ), though at some point I have probably read close to a dozen slightly different ones. I finally managed to get a copy of perl 5.10. so I no longer get dll errors when I run the server start bat. However, my loginserver crashes right away. I would really appreciate any assistance offered here. I have spent hours and hours trying to get this to work. I have recently acquired some decommed gear from work. One of the few perks of working in IT. I have a Dell Poweredge 2950 II with Quad Xeon 3.0 , 16 GB of RAM, OS Drive is 4 x 15K SAS drives in RAID 5 and data is a 2TB RAID 1 mirror. The server has redundant power supplies, 10 x GigE nics ( I was going to use it as a massive enterprise vyatta router for fun at one point, then changed my mind--hence 10 Gigabit nics). I have spares of everything in a closet, memory, cpu, power supplies, etc. I would eventually like to make this available to the public, possibly even engage some outside admins if anyone is interested since I don't know what I am doing. I would first like to get it up and running and play with a bit on my LAN and then I can put it out in the DMZ. I don't know that my internet connection can support a public server. I have a 30/1 so the upload is going to be a problem I assume.

Anyway, enough history and intent

Here is what I see in the Windows Event log when the loginserver crashes:

Faulting application name: EQEmuLoginServer.exe, version: 0.0.0.0, time stamp: 0x4d03c97f
Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x4ec49b8f
Exception code: 0xc0000005
Fault offset: 0x00038dc9
Faulting process id: 0x5ec
Faulting application start time: 0x01cd83e26d06ffdd
Faulting application path: D:\EQEmu-Rev2098\EQEmuLoginServer.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: ab0d7b87-efd5-11e1-8361-001c23be0836

Below is the output from the command windows when I launch server:

WORLD.exe

Failed to open log file: logs/eqemu_debug_world_3396.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Warning: Unable to read log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver 192.168.0.11:5998
[Debug] [WORLD__INIT] Connecting to MySQL...
Failed to open log file: logs/eqemu_world_3396.log
[Status] Using database 'peq' at localhost:3306
[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 raids..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=92475
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading EQ time of day..
Failed to open log file: logs/eqemu_error_world_3396.log
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Loading adventures...
[Debug] [WORLD__INIT] Purging expired instances
[Debug] [WORLD__INIT] Loading char create info...
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Underfoot
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:49307
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:49307
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:49309
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:49309
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zone
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7000
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:49311
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:49311
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zone
[Debug] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use port 7001
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:49313
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:49313
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zone
[Debug] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use port 7002
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:49315
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:49315
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_04 by launcher zone
[Debug] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use port 7003
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:49317
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:49317
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zone
[Debug] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use port 7004
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.11:5998
[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.11:5998 TCPConnection::Connect(): connec
() failed. Error: 10061

EQLAUNCH.exe

Failed to open log file: logs/eqemu_debug_3452.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1:9000 failed: TCPConnection::Connect():
failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_01
[Debug] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_02
[Debug] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_03
[Debug] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_04
[Debug] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_05
[Debug] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.

So it's clear that the 10061 on the cannot connect to LS server are to be expected because it crashes as soon as I launch the world, so that makes sense. Now I just need to figure out why the LS exe keeps crashing.

Thanks in advance!

arcadius · #2 08-26-2012, 09:56 PM

Been trying to figure this out a bit more. I can get the LS server to start and stay started, but as soon as I start world.exe, it connects to the ls server fine, then the ls server immediately crashes....not sure if that helps.

lerxst2112 · #3 08-26-2012, 10:07 PM

First, create a logs directory in your server directory so that you can see any logs that are produced.

Did you compile your own login server or download one from somewhere?
Did you create the necessary tables for the loginserver in your database? I skimmed that guide and it did seem to have those steps.

Not necessarily important at this point, but did you apply all of the database updates that were newer that the database you started with?

You'll most likely need to post your config file as well as any log from the login server once you create the directory so it can write them.

arcadius · #4 08-27-2012, 09:15 AM

Thank-you for the response.

I downloaded the compiled binaries and login server from here: http://code.google.com/p/projecteqemu/downloads/list I used Rev2098. I did not
I did not see any database updates available there.

I did do every step in that guide. I went through it like three times.

Here is the output from the loginserver log:

[Debug] [08.27.12 - 08:52:20] Logging System Init.
[Debug] [08.27.12 - 08:52:20] Config System Init.
[Debug] [08.27.12 - 08:52:20] MySQL Database Init.
[Database] [08.27.12 - 08:52:20] Failed to connect to MySQL database.
[Debug] [08.27.12 - 08:52:20] Encryption Initialize.
[Debug] [08.27.12 - 08:52:20] Encryption Loaded Successfully.
[Debug] [08.27.12 - 08:52:20] Server Manager Initialize.
[Network] [08.27.12 - 08:52:20] ServerManager listening on port 5998
[Debug] [08.27.12 - 08:52:20] Client Manager Initialize.
[Network] [08.27.12 - 08:52:20] ClientManager listening on Titanium stream.
[Network] [08.27.12 - 08:52:20] ClientManager listening on SoD stream.
[Debug] [08.27.12 - 08:52:20] Server Started.
[Network] [08.27.12 - 08:52:28] New world server connection from 192.168.0.11:49465

So it seems it cannot connect to sql for some reason...food for thought.

Here are my config files:

eqemu_config.xml
++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++++++

<?xml version="1.0"?>
<server>
<world>
<shortname>ISENGARD</shortname>
<longname>pe2950</longname>


<address>192.168.0.11</address>
<localaddress>192.168.0.11</localaddress>


<loginserver>
<host>192.168.0.11</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>


<key>make up some random string of characters here</key>


<http port="9080" enable="true" mimefile="mime.types"/>
</world>


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>PASSWORD</password>
<db>peq</db>
</database>
</server>

eqemulogin.ini
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++

Port=5998
DumpPacketsIn=true
DumpPacketsOut=true
Trace=false
DatabaseServerName=localhost
DatabaseCatalogName=PEQLoginDB
DatabaseUserName=root
DatabaseUserPassword=PASSWORD
OPCodePathAndFileName=login_opcodes.conf

arcadius · #5 08-27-2012, 01:12 PM

Also, I had to use Mysql 5.1.65 I tried installing 5.0.82 but on my Win2k8 ENT R2 server it keeps failing on start service. I can cancel it and then go back and select db reconfig (or something like that), and it will start the service, but then fails at the final security step. I'll keep plugging away at trying to get an earlier version of mysql going as I have reached the end of my rope with 5.1

arcadius · #6 08-27-2012, 01:28 PM

Ok, well I hope the issue isn't the installed version of mysql. I cannot get 5.0.82 to install on 2K8. It will fail at service startup during the final phase of install--despite the fact that the service starts fine. When you do a reconfig from the wizard, it starts the service fine, but then fails at applying the security settings. Arg!!!

EDIT: Managed to get 5.0.82 installed thanks to this website. It allowed me to start the server with a txt file that forced a root password thereby correcting the issue caused by the faulty windows installer. Now 5.0.82 is running fine on my server. Now to see if it makes a whit of difference for my emu install

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

EDIT2: Well, went through all that and redid the db sourcing, etc..and the LS server still won't connect to MySQL database. It doesn't really log anything too useful:

g] [08.27.12 - 14:12:18] Logging System Init.
[Debug] [08.27.12 - 14:12:18] Config System Init.
[Debug] [08.27.12 - 14:12:18] MySQL Database Init.
[Database] [08.27.12 - 14:12:18] Failed to connect to MySQL database.
[Debug] [08.27.12 - 14:12:18] Encryption Initialize.
[Debug] [08.27.12 - 14:12:18] Encryption Loaded Successfully.
[Debug] [08.27.12 - 14:12:18] Server Manager Initialize.
[Network] [08.27.12 - 14:12:18] ServerManager listening on port 5998
[Debug] [08.27.12 - 14:12:18] Client Manager Initialize.
[Network] [08.27.12 - 14:12:18] ClientManager listening on Titanium stream.
[Network] [08.27.12 - 14:12:18] ClientManager listening on SoD stream.
[Debug] [08.27.12 - 14:12:18] Server Started.

lerxst2112 · #7 08-27-2012, 02:10 PM

If you're using eqemuloginserver.exe you need a file named login.ini that should look like this:

Code:

[database]
host = 127.0.0.1
port = 3306
db = peqlogindb
user = root
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = TRUE
dump_packets_out = TRUE
listen_port = 5998
local_network = 127.0.0.1

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

arcadius · #8 08-27-2012, 02:41 PM

Thanks again for the tip, question though: the guide does not mention that file, but it does make sense, and the only place I see it is in the extracted eqemuloginserver folder. But the guide doesn't say to do anything with that other than copy over the eqemuloginserver.exe..not mention of anything else that extracted with the LS download...?

That did it! Thanks a bunch! Or at least I think that did it. For the first time so far I have a connected LS server and when I launch world.exe it connects to the LS server and does not immediately crash it. I cannot test client connections yet as I am doing this all remotely from work, so launching an client would be very awkward on a remote admin type connection. But it looks to be about as far as I have ever gotten so far. Very happy about that.

Though I do notice in the LS running window something that makes me think maybe I am not completely ready for client connections. At the bottom it mentions my server tried to login but did not provide a password...?

D:\EQEmuServer-Rev2098>EQEmuLoginServer.exe
[Debug] [08.27.12 - 14:51:57] Logging System Init.
[Debug] [08.27.12 - 14:51:57] Config System Init.
[Debug] [08.27.12 - 14:51:57] MySQL Database Init.
[Debug] [08.27.12 - 14:51:57] Encryption Initialize.
[Debug] [08.27.12 - 14:51:57] Encryption Loaded Successfully.
[Debug] [08.27.12 - 14:51:57] Server Manager Initialize.
[Network] [08.27.12 - 14:51:57] ServerManager listening on port 5998
[Debug] [08.27.12 - 14:51:57] Client Manager Initialize.
[Network] [08.27.12 - 14:51:57] ClientManager listening on Titanium stream.
[Network] [08.27.12 - 14:51:57] ClientManager listening on SoD stream.
[Debug] [08.27.12 - 14:51:57] Server Started.
[Network] [08.27.12 - 14:53:59] New world server connection from 192.168.0.11:49219
[World] [08.27.12 - 14:53:59] Server Arcadius Private EQ(APEQ) did not attempt to log in but this server requires a password.

Is this going to be a problem?

EDIT: Nevermind, I figured this one out. Needed to edit the admin username and password to reflect what was in the tblserveradminregistration table in the peqlogindb.

Whew, been quite a little journey, but things are looking okay right now. Sucks that I cannot confirm until I get home, but this is great.

Thanks very much for your tips lerx!