LoginServer is blank

[KodeKatt]

I run the login server on a different machine from the game server. Don't ask why, I'm not going to explain myself that's just how it is.

[Network] [04.30.11 - 23:08:48] New world server connection from 192.168.1.103:65393
[Network Error] [04.30.11 - 23:08:48] Handle_NewLSInfo error, remote address was null, defaulting to stream address 192.168.1.103.
[World] [04.30.11 - 23:08:48] Server Shadow of Luclin(sol) attempted to log in but account and password did not match the entry in the database.

I finally decided to try again to build a server. I can always get this far. I can NEVER seem to get this loginserver to work and I don't know how to make it work.

I really just need a guide that only deals with "EQEmu Login Server." I can log in from client to the login server, so this is not the issue. There's no game servers listed from the login server.


I have searched many times in the past. This is where I encounter errors at every single time I try to setup a server and all past searches and questions have never resolved the issue, except one time where my server-box shortly exploded right after and I lost it all.

[KodeKatt]

login.ini
---

[database]
host = 192.168.1.103
port = 3306
db = peq
user = peq
password = qwerty
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.112

[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

eqemu_config.xml
---

<?xml version="1.0">
<server>
	<world>
		<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
		<shortname>sol</shortname> 
		<longname>Shadow of Luclin</longname>

		<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
		<!-- <address>do.not.edit</address> -->
		<!-- <localaddress>do.not.edit</localaddress> -->

		<!-- Loginserver information.  DO NOT EDIT -->
		<loginserver>
			<host>192.168.1.112</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked DO NOT EDIT RIGHT NOW -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  DO NOT EDIT -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>lol,i_like_tuna</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.  DO NOT EDIT -->
	<chatserver>
		<host>localhost</host>
		<port>7779</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  DO NOT EDIT -->
	<mailserver>
		<host>localhost</host>
		<port>7779</port>
	</mailserver>
	
	<zones>
		<!-- The defaultstatus is what status the new toons will have on your server -->
		<defaultstatus>0</defaultstatus>

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

	<!-- Set username to root and password is your MySQL password and db to peq -->
	<database>
		<host>localhost</host>
		<port>3306</port>
		<username>peq</username>
		<password>qwerty</password>
		<db>peq</db>
	</database>

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

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

startserver.bat
---

@echo off
start world.exe
echo Waiting for the world to finish before starting zone and chat servers
ping -n 10 127.0.0.1 > nul
start chatserver.exe
start eqlaunch.exe zone
kix32 eqemuonline
exit

[KodeKatt]

C:\EQEmu>world
[Debug] Starting Log: logs/eqemu_debug_world_5392.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver 192.168.1.112:5998
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_5392.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=84588
[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..
[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] 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] [NET__IDENTIFY] Registered patch HoT
[Debug] [WORLD__LS] Connecting to login server: 192.168.1.112:5998
[Debug] [WORLD__LS] Connected to Loginserver: 192.168.1.112:5998

[Debug] [05.01.11 - 01:59:05] Logging System Init.
[Debug] [05.01.11 - 01:59:05] Config System Init.
[Debug] [05.01.11 - 01:59:05] MySQL Database Init.
[Debug] [05.01.11 - 01:59:05] Encryption Initialize.
[Debug] [05.01.11 - 01:59:05] Encryption Loaded Successfully.
[Debug] [05.01.11 - 01:59:05] Server Manager Initialize.
[Network] [05.01.11 - 01:59:05] ServerManager listening on port 5998
[Debug] [05.01.11 - 01:59:05] Client Manager Initialize.
[Network] [05.01.11 - 01:59:05] ClientManager listening on Titanium stream.
[Network] [05.01.11 - 01:59:05] ClientManager listening on SoD stream.
[Debug] [05.01.11 - 01:59:05] Server Started.
[Network] [05.01.11 - 02:01:41] New world server connection from 192.168.1.103:52448
[Network Error] [05.01.11 - 02:01:41] Handle_NewLSInfo error, remote address was null, defaulting to stream address 192.168.1.103.
[World] [05.01.11 - 02:01:41] Server Shadow of Luclin(sol) did not attempt to log in but this server requires a password.

[joligario]

Did you enter a username/password in your tblserveradminregistration? It must match your loginserver information in your eqemu config file.

EDIT: And your local network in login.ini should just end with the .1 instead of .112

[KodeKatt]

Originally Posted by joligario

Did you enter a username/password in your tblserveradminregistration? It must match your loginserver information in your eqemu config file.

Yes, I have created an account, no I didn't add the info, went off a guite that was explicit on don't change the values.. bleah.. there should be a guide specific of just setting up the login server, because every guide I've ever used in the past has left me with problems of the login server.

Adding a new account for the server and going to put in that info to the eqemu config.xml file, will post a reply of the results in a moment.

Originally Posted by joligario

EDIT: And your local network in login.ini should just end with the .1 instead of .112

changed now (though i don't think that's related to the problem)

[KodeKatt]

[World] [05.01.11 - 03:05:32] Server Shadow of Luclin(sol) attempted to log in
but account and password did not match the entry in the database.

No good.
Rejected by EQEmuLogin server.

[KodeKatt]

I think I got it now!

[greed80]

What was the fix? I am having the same issue.

[Melandril]

I am too...any help?

[farvinpop]

Me three! =(

[Melandril]

partial update...there were a number of configuration issues that were not spelled out. I don't think I fixed the problem, but I did manage to get a work around up and running =D (I hate c++)

1) there are about 3 tables that need to have server information
2) sometimes the password is encoded (don't think it's MD5...) and sometimes it's plain text (I only figured this out from reading the screen as it was crashing to see which was which)
3) the server configuration in eqemu_config for the World server needs to match on the short and long description entered into the DB for the login server
4) eqemu_config needs to have the localaddress set to your Login Server IP and the <login> section needs to have the username and password (unencrypted) for the Login Server (the one you need to enter into one of the server registration tables for the Login tables)
5) [My C++ workaround...] I recompiled the Login Server code and added a try-catch(char* e) statement to the Main method....this code might not actually be helping....but it worked in combination with everything else...so, if you're still stuck...try this. (The reason I hate C++ is that there is not CLR, and inorder to catch an exception, a specific and known exception must be in the catch statement...which leads me to believe this didn't work but was a coincidence, but I'm not looking this gift horse in the mouth)


I'll try to post again tonight with the specific tables; though, in the mean time, look at the names and columns for each of the Login Server and enter info with your best guess. If you read this before I update and find it didn't work, try to capture the error you're receiving and provide details on what you have done and what the error states =D