Upgrading old Underfoot Server

[Uleat]

https://github.com/EQEmu/Server/blob...qemu_update.pl

But (BUT,) you will need to have a recent binary to execute the db update portion - world.exe is called to determine the required db_version.


Not sure if it will actually run without the updated world binary..but, if so, you can at least get the other stuff updated.

[Warking]

Wow, you guys have been busy since I first built the server 5ish years ago. I am very impressed by the update script. Going through and updating everything. I'll let you know how it turns out.

Thanks, greatly apretiated. I will have to get back to scripting to contribute back to the group.

[Warking]

Just went through all the updates on the updater and looks good in the eqemu file directory. I now just need to update the .sql tables. Note to self- don't use navicat for executing the queries (IE: peqbeta_2015-08-12-02_01.sql), takes too long...


Oh, and would there need to be any updates to the server start batch file:

@echo off
Echo Starting EQEmuLoginServer
c:
cd C:\eqemu
start eqemuloginserver.exe
echo
echo

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit

What does magelo.sql do for me?

[Warking]

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

[Warking]

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:

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

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

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

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

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...

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

[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

[Uleat]

Some people put a shared_memory.exe call in their script to make sure that it's up-to-date every time.

You should at least make sure that it's run once..you may need to create the sub-folder '\..\shared\' in your server directory, if it doesn't exist.

(It does need to be run whenever there are changes to database entries or, especially, when there are changes in pertinent structure sizes in the code.)


Are you using 32-bit or 64-bit binaries?

[Warking]

I added the shared folder and the shared_memory.exe in the startup script. I should be using x64 binaries but the C++ runtime is calling for x32 so it might be x32 on a 64bit server. there a way to call up an output to show binary bit?

The one thing I noticed was there are new loginDB tables under the base PEQ DB. Do we not use a seperate DB for account logins anymore? Because last login is not populating in any login tables but the account is able to login initially... I do not see the server listed and eqlaunch.exe screen is blank.

Wassn't there some table in PEQ where I need to update the name of the server and login info? Like in rule_values or something? Since I overwrote the entire DB? Something is not calling the correct login DB and Server...

[Warking]

I just found multiple login server entries in the PEQ DB

login_server_accounts.

And

tblloginserveraccounts


It looks like when it works it is reading from the login_server_accounts and not the older peqlogindb or the PEQ DB > tblloginserveraccounts

I dont care if I have to copy the tables over for account logins. I just need to get is working for one. whereever the login tables are... then copy over the accounts....

Is this a normal occurance? I must be missing some setting somewhere

[jpyou127]

Just tossing out a quick suggestion. If you have the ability to spin up a windows VM, you could download and install Akka's new windows installer and then have a working server to check your DB against. It might make it a bit easier to have one to compare to.

As for the login server on this new server to compare to, you can do the steps presented on Akka's wiki to get that going. Or he may have added that option to install the login server I am not sure to his auto windows install.

To answer your above question, all you need to do is rename your login.ini referenced tables to the ones that match in the database.


Celestial

[Warking]

ok... so after I determined that the login tables were different I copied the table entries

From --- To
peqlogindb>tblloginserveraccounts --To-- PEQ>login_server_accounts

peqlogindb>tblserveradminregistration --To-- PEQ>loginserver_server_admin_registration

peqlogindb>tblserverlisttype --To-- PEQ>lloginserver_server_list_type

peqlogindb>tblworldserverregistration --To-- PEQ>loginserver_world_server_registration

Then... I noticed that world.exe would not load unless 127.0.0.1 instead of localhost was in the eqemu_conf file. So I changed that as well. Again still using the the older EQEMUloginserver.exe

Then updated the start script:

@echo off
Echo Starting EQEmuLoginServer
c:
cd C:\eqemu
echo
shared_memory.exe
echo
start eqemuloginserver.exe
echo
start world.exe
echo waiting for the world to finish before starting zone...
ping -n 10 127.0.0.1 > nul
start queryserv.exe
start ucs.exe
start eqlaunch.exe zone
exit

I was now able to see the eqlaunch.exe change to sleeping. and have the below output on the server windows. BUT When trying to login to a zone (tutorialb) the eqclient just crashes. When trying to enter crescent reach as well with a new toon EQ crashes.

Nothing notable in the log file but I see the below in world.exe when trying to zone in:

[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] Loading skill caps..
[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:52963
[World Server] New TCP connection from 127.0.0.1:52965
[World Server] New TCP connection from 127.0.0.1:52967
[World Server] New connection from 192.168.1.162:51104
[World Server] Checking inbound connection 192.168.1.162 against BannedIPs table
[World Server] Connection 192.168.1.162 PASSED banned IPs check. Processing connection.
[World Server] New TCP connection from 127.0.0.1:52969
[World Server] New TCP connection from 127.0.0.1:52971
[World Server] New TCP connection from 127.0.0.1:52973
[World Server] New connection from 192.168.1.162:51108
[World Server] Checking inbound connection 192.168.1.162 against BannedIPs table
[World Server] Connection 192.168.1.162 PASSED banned IPs check. Processing connection.
No start_zones entry in database, using defaults

but there is a start_zones table

************************************************** **

Thanks, I might try to spin up another VM to compare as well. I can get to character create now so that is a plus... can't zone in

[jpyou127]

Do you have any zones set to startup, even just a bunch of dynamic zones?

Your script is calling this "start eqlaunch.exe zone", So there should be in the table "LAUNCHER" an and the first column should have an entry called "ZONE" and the other column a number (the heading of the second column is dynamics). Make sure there is a number in there. By default its usually 5. That will allow you to zone into at least 5 zones simultaniously (multiple players in different zones).

In the table "Launcher zones" you can specify zones to launch statically.


Celestial

[Warking]

My Launcher Table:

Name        dynamics
PEQ          40
zome         5

my launcher_zones table:

NULL

I have a start_zones table that is fully populated

[Uleat]

I don't think there's a requirement to put the login server tables in a separate db..mine works just fine in the same db.

All (4) of my login server tables are prefixed with 'tbl'

[Warking]

Thanks all for the assistance. I got it working where I can login to the game. Was missing some file updates that prevented me from getting into the game.

What is the best way to verify that RoF along with all associated is working properly? My first guess is to make the GM character and #level and mess aroundl; but was wondering if there was any neat validation tool that someone developed since I've been away.