| Zouche |
12-23-2010 07:11 AM |
Strange Login Server error
Hey there, I followed Kavren's setup sticky as closely as possible, using the compiled system instead of compiling my own, and modifying the eqemu_config, login, and eqemulogin files as seemed appropriate. I can get my client to connect... kinda.
On the Login Server window, I'm getting the following message -- and, apologies in advance for a lengthy post:
Quote:
[Debug] [12.23.10 - 05:52:06] Server Started.
[Network] [12.23.10 - 05:52:13] New world server connection from 127.0.0.1:54482
[Network Error] [12.23.10 - 05:52:13] Handle_NewLSInfo error, remote address was null, defaulting to stream address 127.0.0.1.
[Database] [12.23.10 - 05:52:13] Mysql query failed: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerLongName = 'Personal Everquest' AND WSR.ServerShortName = 'Home'
[World] [12.23.10 - 05:52:13] Server Personal Everquest(Home) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Database] [12.23.10 - 05:52:13] Mysql query failed: SELECT max(ServerID) FROM tblWorldServerRegistration
[Database] [12.23.10 - 05:52:13] Mysql query failed: UPDATE tblWorldServerRegist
ration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where ServerID = 0
|
Here are my config files:
eqemu_config
Quote:
<?xml version="1.0"?>
<server>
<world>
<shortname>Home</shortname>
<longname>Personal Everquest</longname>
<!-- address has to be specified for minilogin to work ->
<address>localhost</address>
<localaddress>192.168.1.101</localaddress>
<!-- Loginserver information. -->
<loginserver>
<host>localhost</host>
<port>5998</port>
<account>root</account>
<password>password removed</password>
</loginserver>
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>162af2346124j38615asdfawefih</key>
<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>
<!-- Database configuration, replaces db.ini -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>password removed</password>
<db>peq</db>
</database>
</server>
|
login:
Quote:
[database]
host = localhost
port = 3306
db = peq
user = root
password = password removed
subsystem = MySQL
[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.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
|
and finally, eqemulogin:
Quote:
Port=5998
DumpPacketsIn=true
DumpPacketsOut=true
Trace=true
DatabaseServerName=localhost
DatabaseCatalogName=PEQLoginDB
DatabaseUserName=root
DatabaseUserPassword=password removed
OPCodePathAndFileName=login_opcodes.conf
|
Oh, and eqhost:
Quote:
[LoginServer]
Host=192.168.1.101:5998
|
The EQ client connects; however, I can't get the server list to populate after submitting my username/password.
Any thoughts or suggestions? I'm using EQEmu Rev 1771 w/bots, perl 5.10,
mysql 5.5.8, if any of that makes a difference.
I'm simply trying to get this to be a one-machine setup - server on my desktop, login and play on the same desktop. I'm not interested in opening this server up to anybody else.
Thanks in advance! |