Login issues on eqemu local server

Eboonysa · #1 03-12-2014, 09:49 AM

edit:

*facepalm*
Forgot to copy everything from patches folder
Didn't give me any errors anywhere so assumed everything was ok.

Copied over, now works like a charm.

Original issue (for anyone who is interested)

Hey people. Appreciate the time.

TLDR version:
I can log in to my loginserver but when i select server and click play, it hangs.

Details:
After some issues I was able to compile eqemu and set up my configs (I hope). I tried to follow the CMake guide along side the guide on github.
My problem seems to be server side, tried to use 2 clients(UF and Titan) both of which can log into the peq server.

Here are my configs and logs: (removed means .. i removed what was there)

eqemu_config.xml

Code:

<?xml version="1.0"?>
<server>
	<world>
		<shortname>farkzeqemu</shortname>
		<longname>What the Fark</longname>

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

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>127.0.0.1</host>
			<port>5998</port>
			<account>removed</account>
			<password>removed</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="127.0.0.1" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>removed (random string with uppercase/lowercase chars)</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>127.0.0.1</host>
		<port>7778</port>
	</chatserver>

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

	<zones>
		<defaultstatus>20</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>removed</username>
		<password>removed</password>
		<db>eqemu</db>
	</database>

	<qsdatabase>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>removed</username>
		<password>removed</password>
		<db>eqemu</db>
	</qsdatabase>

	<!-- 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><!-- yeah .. i know, i used lowercase in maps by accident so i changed here -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

eqemulogin.ini

Code:

[LoginServer]
loginserver=localhost
loginport=5998
DumpPacketsIn=false
DumpPacketsOut=false
Trace=true
DatabaseServerName=localhost
DatabaseCatalogName=eqemu
DatabaseUserName=removed
DatabaseUserPassword=removed
OPCodePathAndFileName=login_opcodes_sod.conf

my startup script :

Code:

ulimit -c unlimited
case "$1" in
	start)
		export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:.

		rm -rf logs/*.log
		chmod --recursive ugo+rwx quests

		#sleep 5
		echo Loading Shared Mem...
		./shared_memory > /dev/null 2>&1 &

		sleep 10
		echo Starting the Login Server...
		./loginserver zone > /dev/null 2>&1 &
		echo $! > loginserver.pid

		sleep 10
		echo Starting Chat and Mail Server...
		./ucs > /dev/null 2>&1 &
		echo $! > ucs.pid

		sleep 10
		echo Starting World Server...
		./world > /dev/null 2>&1 &
		echo $! > world.pid

		sleep 10
		echo Starting Query Server...
		./queryserv > /dev/null 2>&1 &
		echo $! > queryserv.pid

		sleep 10
		echo Starting the Zone Launcher...
		./eqlaunch zone > /dev/null 2>&1 &
		echo $! > eqlaunch.pid

		sleep 5
		echo The server is mostly ready... Give it a couple of minutes
		echo to load stuff from the database before the users start  logging in.
		;;
	stop)
		kill `cat world.pid`
		kill `cat queryserv.pid`
		kill `cat eqlaunch.pid`
		kill `cat loginserver.pid`
		kill `cat ucs.pid`
		rm -f *.pid
		echo All server components have been exited.
		;;
	restart|reload)
		$0 stop
		$0 start
		;;
	status)
		if [ -f world.pid ] && ps -p `cat world.pid` > /dev/null
		then
			echo -e World Server '\t\t'  [$(tput bold)$(tput setaf 2)UP$(tput sgr0)]
		else
			echo -e World Server '\t\t' [$(tput bold)$(tput setaf 1)DOWN$(tput sgr0)]
		fi
		if [ -f queryserv.pid ] && ps -p `cat queryserv.pid` > /dev/null
		then
			echo -e Query Server '\t\t' [$(tput bold)$(tput setaf 2)UP$(tput sgr0)]
		else
			echo -e Query Server '\t\t' [$(tput bold)$(tput setaf 1)DOWN$(tput sgr0)]
		fi
		if [ -f ucs.pid ] && ps -p `cat ucs.pid` > /dev/null
		then
			echo -e Chat and Mail Server '\t' [$(tput bold)$(tput setaf 2)UP$(tput sgr0)]
		else
			echo -e Chat and Mail Server '\t' [$(tput bold)$(tput setaf 1)DOWN$(tput sgr0)]
		fi
		if [ -f eqlaunch.pid ] && ps -p `cat eqlaunch.pid` > /dev/null
		then
			echo -e Zone Launcher '\t\t' [$(tput bold)$(tput setaf 2)UP$(tput sgr0)]
		else
			echo -e Zone Launcher '\t\t' [$(tput bold)$(tput setaf 1)DOWN$(tput sgr0)]
		fi
		if [ -f loginserver.pid ] && ps -p `cat loginserver.pid` > /dev/null
		then
			echo -e Login Server '\t\t' [$(tput bold)$(tput setaf 2)UP$(tput sgr0)]
		else
			echo -e Login Server '\t\t' [$(tput bold)$(tput setaf 1)DOWN$(tput sgr0)]
		fi
		;;
	help|*)
		printf "Usage: \n ./EQServer.sh [start|stop|reload|restart|status|help]"
		printf "\n\n"
		printf " start\t\tStarts the server components\n"
		printf " stop\t\tStops all the server components started by this script\n"
		printf " restart/reload\tRestarts the server\n"
		printf " status\t\tLists the status of the server components\n"
		printf " help\t\tDisplays this message\n"
		;;

	esac
exit 0

login.ini

Code:

[database]
host = localhost
port = 3306
db = eqemu
user = removed
password = removed
subsystem = MySQL

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

[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, my login log:

Code:

[Debug] [03.12.14 - 15:23:54] Logging System Init.
[Debug] [03.12.14 - 15:23:54] Config System Init.
[Debug] [03.12.14 - 15:23:54] MySQL Database Init.
[Debug] [03.12.14 - 15:23:54] Server Manager Initialize.
[Network] [03.12.14 - 15:23:54] ServerManager listening on port 5998
[Debug] [03.12.14 - 15:23:54] Client Manager Initialize.
[Network] [03.12.14 - 15:23:54] ClientManager listening on Titanium stream.
[Network] [03.12.14 - 15:23:54] ClientManager listening on SoD stream.
[Debug] [03.12.14 - 15:23:54] Server Started.
[Network] [03.12.14 - 15:24:15] New world server connection from 127.0.0.1:33472
[World] [03.12.14 - 15:24:15] Server What the Fark(farkzeqemu) successfully logged in.
[Network Trace] [03.12.14 - 15:24:15] ServerOP_LSAccountUpdate sent to world
[Network] [03.12.14 - 15:26:12] New SoD client connection from 10.0.0.5:64886
[Network] [03.12.14 - 15:26:12] Application packet received from client (size 14)
[Network] [03.12.14 - 15:26:12] Session ready received from client.
[Network] [03.12.14 - 15:26:13] Application packet received from client (size 36)
[Network] [03.12.14 - 15:26:13] Login received from client.
[Client] [03.12.14 - 15:26:13] User: removed
[Client] [03.12.14 - 15:26:13] Hash: b9b134231fc35db4a557d5e7cdfc64a342e18807
[Network] [03.12.14 - 15:26:13] Application packet received from client (size 12)
[Network] [03.12.14 - 15:26:13] Server list request received from client.
[Network] [03.12.14 - 15:26:14] Application packet received from client (size 16)
[Network] [03.12.14 - 15:26:14] Play received from client, server number 2 sequence 5.
[Network Trace] [03.12.14 - 15:26:14] User-To-World Response received.
[Client] [03.12.14 - 15:26:14] Trying to find client with user id of 2.
[Client] [03.12.14 - 15:26:14] Found client with user id of 2 and account name of hakonSK.
[Client] [03.12.14 - 15:26:14] Found sequence and play of 5 2
[Network Trace] [03.12.14 - 15:26:14] dumping packet of size 20
05 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
02 00 00 00                                        | ....
[Network Trace] [03.12.14 - 15:26:14] Sending play response with following data, allowed 1, sequence 5, server number 2, message 101
[Network Trace] [03.12.14 - 15:26:14] dumping packet of size 20
05 00 00 00 00 00 00 00 - 00 00 01 65 00 00 00 00  | ...........e....
02 00 00 00                                        | ....
[Network Trace] [03.12.14 - 15:26:14] Sending play response for hakonSK.
[Network Trace] [03.12.14 - 15:26:14] dumping packet of size 20
05 00 00 00 00 00 00 00 - 00 00 01 65 00 00 00 00  | ...........e....
02 00 00 00                                        | ....
[Network] [03.12.14 - 15:26:14] Client disconnected from the server, removing client.

I'm stumped, been fiddling around with the settings back and forth and googling/reading what I can about this issue but don't seem to find anything with quite the same issue.

I hope my database setup is fine (imported all using the provided .sql files) and set up both the tblWorldServerRegistration and tblLoginServerAccount to make sure I can log in and that the world can log in to the loginserver.

If you made it all the way through, thanks.

Farkz