Upgrading old Underfoot Server

Warking · #1 01-29-2016, 02:42 AM

Delete. re-run worked if anyone already read this post

Warking · #2 01-29-2016, 03:59 AM

ok everything is updated but now having connection / start issues. I did not change eqemu_config or the eqemuloginserver.exe from before when it did work successfully with the client.

When trying to login I am getting that the eqemuloginserver stopped working. after that world.exe stays up but then eqlaunch.exe is just hanging there.

Looking at the logs it doesn't look like a good connection is being made with the DB? again - using older eqemuloginserver

Below is the login server logs:

Code:

[Debug] [01.29.16 - 03:55:39] Logging System Init.
[Debug] [01.29.16 - 03:55:39] Config System Init.
[Debug] [01.29.16 - 03:55:39] MySQL Database Init.
[Database] [01.29.16 - 03:55:40] Failed to connect to MySQL database.
[Debug] [01.29.16 - 03:55:40] Encryption Initialize.
[Debug] [01.29.16 - 03:55:40] Encryption Loaded Successfully.
[Debug] [01.29.16 - 03:55:40] Server Manager Initialize.
[Network] [01.29.16 - 03:55:40] ServerManager listening on port 5999
[Debug] [01.29.16 - 03:55:40] Client Manager Initialize.
[Network] [01.29.16 - 03:55:40] ClientManager listening on Titanium stream.
[Network] [01.29.16 - 03:55:40] ClientManager listening on SoD stream.
[Debug] [01.29.16 - 03:55:40] Server Started.
[Network] [01.29.16 - 03:57:02] New SoD client connection from 192.168.1.162:51280
[Network] [01.29.16 - 03:57:02] Application packet recieved from client (size 14)
[Network] [01.29.16 - 03:57:02] Session ready recieved from client.
[Network] [01.29.16 - 03:57:02] Application packet recieved from client (size 28)
[Network] [01.29.16 - 03:57:02] Login recieved from client.
[Client] [01.29.16 - 03:57:02] User: ken1
[Client] [01.29.16 - 03:57:02] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00

Wondering if i need to rebuild the login server? I have a seperate DB for the peqlogindb

I noticed the logs are saying SoD connection but im using RoF/2 client..

--
I tried cutting out the old files and running the eqemu_update option 13 for loginserver but it is not pulling in a new eqemu_config.xml

So I tried just updating the login.ini file and was able to login but since no eqemu_config.xml I was not able to see the server... but It looks like it created a user account... but the user account was already in the the old peglogindb. I hope I will not lose all the login accounts?

Code:

[Login Server] Logging System Init.
[Login Server] Config System Init.
[Login Server] MySQL Database Init.
[Login Server] Encryption Initialize.
[Login Server] Encryption Loaded Successfully.
[Login Server] Server Manager Initialize.
[Login Server] ServerManager listening on port 5999
[Login Server] Client Manager Initialize.
[Login Server] ClientManager listening on Titanium stream.
[Login Server] ClientManager listening on SoD stream.
[Login Server] Server Started.
[Login Server] New SoD client connection from 192.168.1.162:50046
[Login Server] Application packet received from client (size 14)
[Login Server] Session ready received from client.
[Login Server] Application packet received from client (size 28)
[Login Server] Login received from client.
[Error] Mysql query returned no result: SELECT LoginServerID, AccountPassword FROM logins
r_accounts WHERE AccountName = 'ken1'
[Error] User ken1 does not exist in the database, so we created it...
[Login Server] Application packet received from client (size 12)
[Login Server] Server list request received from client.
[Login Server] Client disconnected from the server, removing client.

EQ Launch remains a black screen. There is something wrong with the login server and it pointing to the correct login DB and seeing the server...

Code:

[Debug] [01.29.16 - 04:20:26] Logging System Init.
[Debug] [01.29.16 - 04:20:26] Config System Init.
[Debug] [01.29.16 - 04:20:26] MySQL Database Init.
[Debug] [01.29.16 - 04:20:26] Encryption Initialize.
[Debug] [01.29.16 - 04:20:26] Encryption Loaded Successfully.
[Debug] [01.29.16 - 04:20:26] Server Manager Initialize.
[Network] [01.29.16 - 04:20:26] ServerManager listening on port 5999
[Debug] [01.29.16 - 04:20:26] Client Manager Initialize.
[Network] [01.29.16 - 04:20:26] ClientManager listening on Titanium stream.
[Network] [01.29.16 - 04:20:26] ClientManager listening on SoD stream.
[Debug] [01.29.16 - 04:20:26] Server Started.
[Network] [01.29.16 - 04:20:35] New world server connection from 192.168.1.131:50181
[Database] [01.29.16 - 04:20:35] Mysql query returned no result: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerLongName = 'The Everquest Afterlife, Dragons of Doom' AND WSR.ServerShortName = 'eqafdod'
[World] [01.29.16 - 04:20:35] Server The Everquest Afterlife, Dragons of Doom(eqafdod) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Network] [01.29.16 - 04:21:37] New SoD client connection from 192.168.1.162:61960
[Network] [01.29.16 - 04:21:37] Application packet recieved from client (size 14)
[Network] [01.29.16 - 04:21:37] Session ready recieved from client.
[Network] [01.29.16 - 04:21:37] Application packet recieved from client (size 28)
[Network] [01.29.16 - 04:21:37] Login recieved from client.
[Client] [01.29.16 - 04:21:37] User: ken2
[Client] [01.29.16 - 04:21:37] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00
[Database] [01.29.16 - 04:21:37] Mysql query returned no result: SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName = 'ken2'
[Client Error] [01.29.16 - 04:21:37] Error logging in, user ken2 does not exist in the database.
[Network] [01.29.16 - 04:21:45] Client disconnected from the server, removing client.
[Network] [01.29.16 - 04:21:45] New SoD client connection from 192.168.1.162:61961
[Network] [01.29.16 - 04:21:45] Application packet recieved from client (size 14)
[Network] [01.29.16 - 04:21:45] Session ready recieved from client.
[Network] [01.29.16 - 04:21:45] Application packet recieved from client (size 28)
[Network] [01.29.16 - 04:21:45] Login recieved from client.
[Client] [01.29.16 - 04:21:45] User: ken3
[Client] [01.29.16 - 04:21:45] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00
[Database] [01.29.16 - 04:21:45] Mysql query returned no result: SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName = 'ken3'
[Client Error] [01.29.16 - 04:21:45] Error logging in, user ken3 does not exist in the database.
[Network] [01.29.16 - 04:21:53] Client disconnected from the server, removing client.
[Network] [01.29.16 - 04:21:53] New SoD client connection from 192.168.1.162:61962
[Network] [01.29.16 - 04:21:53] Application packet recieved from client (size 14)
[Network] [01.29.16 - 04:21:53] Session ready recieved from client.
[Network] [01.29.16 - 04:21:53] Application packet recieved from client (size 28)
[Network] [01.29.16 - 04:21:53] Login recieved from client.
[Client] [01.29.16 - 04:21:53] User: ken1
[Client] [01.29.16 - 04:21:53] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00
[Network] [01.29.16 - 04:21:53] Application packet recieved from client (size 12)
[Network] [01.29.16 - 04:21:53] Server list request recieved from client.
[Network] [01.29.16 - 04:21:58] Client disconnected from the server, removing client.
[Network] [01.29.16 - 04:22:04] World server disconnected from the server, removing server and freeing connection.

from world.exe:

Code:

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver ucdataeq01:5999
[World Server] Connecting to MySQL...
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.4
============================================================
           EQEmu: Automatic Upgrade Check
============================================================
        (Windows) MySQL is in system path
        Path = C:\mysql\bin/mysql
============================================================
        Binary Revision / Local: (9091 / 1000)
You have missing database updates, type 1 or 2 to backup your database before running them as recomm
ended...

============================================================
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
============================================================
 1) [Backup Database] :: (Saves to Backups folder)
 2) [Backup Database Compressed] :: (Saves to Backups folder)
 3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
 4) [EQEmu DB Bots Schema] Check for Bot REQUIRED database updates... (Must have bots enabled)
 5) [OPCodes] :: Download latest opcodes for each EQ Client
 6) [Maps] :: Download latest map and water files
 7) [Plugins (Perl)] :: Download latest Perl plugins
 8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
 9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
 10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This overwrites existing da
ta)
 11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrites existing .exe's,
includes .dll's)
 12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
 13) [Windows Server Loginserver Setup] :: Download and install Windows Loginserver
 14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries and removes them
 19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to normal state
 20) [Update the updater] Force update this script (Redownload)
 0) Exit

 Enter numbered option and press enter...

> 0
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Clearing inventory snapshots..
[World Server] Loading items..
[World Server] Error: Could not load item data. But ignoring
[World Server] Loading skill caps..
[World Server] Error: Could not load skill cap data. But ignoring
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes OFF
[World Server] Deleted 0 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
[World Server] New TCP connection from 127.0.0.1:50197

Warking · #3 01-29-2016, 05:56 AM

Something is preventing the login server and server db from linking... or eqlaunch.exe from running... unless I have a bad start .bat file. ?

eqemu_config.xml - Only working with old eqemuloginserver.exe. This is what worked with underfoot build with no issues...

Code:

<?xml version="1.0">
<server>
	<world>
		<shortname>eqafdod</shortname>
		<longname>The Everquest Afterlife, Dragons of Doom</longname>

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

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

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

		<!-- <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>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</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>xxxxxxxx</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>xxxxxxxxx</host>
		<port>7779</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>localhost</host>
		<port>3306</port>
		<username>root</username>
		<password>xxxxxxxx</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>

below is the login.ini file that works with loginserver.exe from the eqemu_update.pl

Code:

[database]
host = 127.0.0.1
port = 3306
db = peq
user = root
password = xxxxxxxxx
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 = 5999
local_network = 192.168.1.
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type