Pulling hair out.. no servers listed

[dburg30]

Having the no servers listed. Server sees the login, sees requesting the server list, but it never seems to make it. Havent ever seen a server pop up.. Logs dont show any errors. Have tried pre-compiled server and also compiled my own. Dont have any idea where to even start. This is on a titanium setup, locally, so shouldnt be any issues with firewall / ports.

Have started and restarted client over and over since some people said it shows up for them when they restart it. Just inst happening..

Any ideas where to even start?

[dburg30]

OK.. so.. I guess if you want your server to actually activate you have to enter that account / password in the .xml cofig file.. Never saw that listed anywhere or I missed it lol.. Anywho, have a LAN server up and running!!!

[chaosflame]

Can you give some more detail on how you solved this? I'm having a similar problem, but adding my login info in the .xml doesnt fix it. Maybe I put it in the wrong place? Talk about pulling hair out...

[c0ncrete]

If you're using the EQEmuLoginServer, the values in the AccountName and AccountPassword columns of the table tblserveradminregistration must match the <account> and <password> entries in the <loginserver> section of your eqemu_config.xml for your world server to be listed by EQEmuLoginServer.

[Huppy]

This my xml file. EXACTLY how it is, line for line, for my lan server.
I only changed one thing for this post, which is the database password.
Since my Lan server has been working, I have NEVER changed this file.

<?xml version="1.0">
<server>
	<world>
		<shortname>huppys</shortname>
		<longname>Huppys Little Norrath</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<address>192.168.1.100</address>
		<!-- <localaddress>70.61.222.38</localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>192.168.1.100</host>
			<port>5999</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>hujbyg6ygkbm7b7b</key>
		
		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types"/>
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>192.168.1.100</host>
		<port>10234</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>192.168.1.100</host>
		<port>10234</port>
	</mailserver>

	<zones>
		<defaultstatus>0</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>xxxxxx</password>
		<db>peq</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

[Huppy]

And this is my login.ini file

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

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = TRUE
trace = FALSE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5999
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 this is my eqemulogin.ini file:

[LoginServer]
loginserver=192.168.1.100
loginport=5999
DumpPacketsIn=false
DumpPacketsOut=false
Trace=false
DatabaseServerName=localhost
DatabaseCatalogName=peqlogindb
DatabaseUserName=root
DatabaseUserPassword=xxxxx
OPCodePathAndFileName=login_opcodes_sod.conf

[chaosflame]

The way I solved it was just by deleting my PEQ database and starting over with a new PEQDB folder. Must have made an error in my mysql configuration the first time around or something.

[Capheus]

Ok so here is my eqemu_config.xml

<?xml version="1.0"?>
<server>
<world>
<shortname>myworld</shortname>
<longname>myworld long name</longname>

<!-- address has to be specified for minilogin to work -->
<address>192.168.1.101</address>
<localaddress>192.168.1.101</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>192.168.1.101</host>
<port>5999</port>
<account>Nightworker8</account>
<password>Password</password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>blehblahblehblee</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>
<db>peq1667</db>
</database>
</server>

so like c0ncrete was saying to make it work I would need to setup my tblserveradminregistration found in the local database as such:

INSERT INTO `tblserveradminregistration` (`ServerAdminID`, `AccountName`, `AccountPassword`, `FirstName`, `LastName`, `Email`, `RegistrationDate`, `RegistrationIPAddr`) VALUES (2, 'Nightworker8', 'Password', 'J', 'c', 'j@j.COM', '2010-09-04 06:24:59', '192.168.1.101');

For my eqemulogin.ini, I would set it up like this (change your opcodes file to whatever version of EQ you are running, I am using Titanium here):

Port=5999
DumpPacketsIn=true
DumpPacketsOut=true
Trace=true
DatabaseServerName=localhost
DatabaseCatalogName=local
DatabaseUserName=root
DatabaseUserPassword=****
OPCodePathAndFileName=login_opcodes.conf

And eqhost.txt:

[LoginServer]
Host=192.168.1.101:5999

I don't think login.ini does anything, unless it was included recently.

[Huppy]

Originally Posted by Capheus

I don't think login.ini does anything, unless it was included recently.

The login.ini is included with the EQEmuLoginServer binary download from here:

http://code.google.com/p/projecteqemu/downloads/list

From DEC 11th, 2010 (EQEmuLoginServer.rar)

It also allows both port logins (5998 for Titanium and 5999 for SoD+)