Strange Login Server error

[Zouche]

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:

[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

<?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:

[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:

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

Oh, and eqhost:

[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!

[lerxst2112]

I'm guessing you mean this guide? http://www.eqemulator.org/forums/showthread.php?t=31783

That's the one I used as well when I initially set things up. Based on the error I suspect you missed a step in the "Setup PEQLoginDB DB and Logins" section.

Try repeating those steps and see if it helps. The error is probably because you don't have an entry in the tblWorldServerRegistration table, but you might be missing other stuff too.