Windows Server Repack (EQEmu Akka's PEQ Repack)

[Stabones]

Originally Posted by Uleat

Hopefully, markus can assist..I don't recall seeing much of your problem/setup.


I know Akkadius keeps the repack current..so, an actual issue there is least plausible.

Make sure that your server folder has the rof/rof2.conf files.

Double-check that your RoF client is either the 'Dec 10 2012 17:35:44' or 'May 10 2013 23:30:08' build (verifiable in the client's log file.)

If you downloaded the recent steam client and it is not the 'May 10' version, please post back (someone recently mention something about
a check-box for newer content..though, I have not verified this.)

I checked my client and it's May 10 so we are good there.

I did notice that I don't seem to have a rof/rof2.conf file. Maybe Akka's Repack doesn't support RoF?

Many thanks to everyone's help so far.

[Stabones]

Originally Posted by Stabones

I checked my client and it's May 10 so we are good there.

I did notice that I don't seem to have a rof/rof2.conf file. Maybe Akka's Repack doesn't support RoF?

Many thanks to everyone's help so far.

EDIT: Thought it had been fixed, but RoF still not connecting.

[Uleat]

I'll be the first to admit that I don't know much about Akkadius's repack...

If you didn't find either *.conf file, then it may not be setup by default to run RoF+ clients..someone else will have to verify that.


As far as whether those *.conf files are registered in the repack, check this file in your local repository:
https://github.com/EQEmu/Server/blob...es/patches.cpp

Both functions need to have the StructStrategy method calls for the client that you are attempting to use.

If they are not present, you should be able to add them, recompile and then copy over the new binary files to the
repack's server directory.

As this now makes your content 'custom,' I don't know how updates to the repack are handled and you may need to ask
some more questions.


IF they are present in your local copy, then there are still some other issues that need to be addressed..but, we need to
first determine if those methods are being called.

[Stabones]

markusdabrave tried Titanium, UF, and RoF. Titanium and UF worked. RoF did not.

Maybe I'll just need to compile myself.

[markusdabrave]

We haven't successfully resolved Stabones issue but we did make some progress. Looks like a router reboot fixed some stuff but not all. Currently

- Titanium Client works
- UF Client works
- ROF Client hangs after server selection.

DBG Log Below:

[Sun Apr 19 20:36:11 2015]00031:Initializing client variables.
[Sun Apr 19 20:36:11 2015]00032:Parsing INI file .\VoiceChat.ini
[Sun Apr 19 20:36:11 2015]00033:INI file .\VoiceChat.ini loaded.
[Sun Apr 19 20:36:11 2015]00034:Loading spell effects.
[Sun Apr 19 20:36:11 2015]00035:Initializing display structures.
[Sun Apr 19 20:36:12 2015]00036:Sound Manager loaded 3245 filenames from soundassets.txt.
[Sun Apr 19 20:36:12 2015]00037:Voice Manager loaded 12 macros from VoiceData.txt.
[Sun Apr 19 20:36:12 2015]00038:Parsing INI file .\defaults.ini
[Sun Apr 19 20:36:12 2015]00039:INI file .\defaults.ini loaded.
[Sun Apr 19 20:36:12 2015]00040:Memory mode defaulted to Balanced
[Sun Apr 19 20:36:12 2015]00041:Networking: using port [59293].
[Sun Apr 19 20:36:12 2015]00042:Networking: Connection Established [1]
[Sun Apr 19 20:36:12 2015]00043:WorldAuthenticate: Initiating Login.

Prior to reboot, I was being dropped back to the login after:

00639:*** WorldAuthenticate.  Error connecting to :9000 [client:DisconnectReasonConnectFail,server:DisconnectReasonNone]

Confirmed Expansions is set to 16383 in Variables table.

At this point I'm stumped. Any suggestions?

Edit: Maybe a dumb question and probably should have been asked earlier - but did you do the below update?
http://www.eqemulator.org/forums/showthread.php?t=39317

[Stabones]

Alright so I manually downloaded and added patch_RoF2.conf.

I can log in now but of course I ran Akka's update script and it screwed up my server(not a big deal since I haven't made any progress on it).

From what I can see, patch_RoF2.conf was not included in Akka's initial install nor the most recent update.

When I try to run the latest update, which is found here(http://www.eqemulator.org/forums/showthread.php?t=39317), I get an error about mysql's mysqldump not being found, which makes sense because Akka's uses MariaDB. What I don't understand is why his update would try and call MySql when he doesn't use with his distro.

        Enter numbered option and press enter...

> 1
Performing database backup....
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

[Akkadius]

It calls MySQL in the script to interact with the database.

You need to make sure that your operating system has it set in the system path.

I've made instructions for this before:

http://www.eqemulator.org/forums/sho...4&postcount=13

[markusdabrave]

I learned the hard way - read the entire thread

[Stabones]

Originally Posted by Akkadius

It calls MySQL in the script to interact with the database.

You need to make sure that your operating system has it set in the system path.

I've made instructions for this before:

http://www.eqemulator.org/forums/sho...4&postcount=13

Thank you. I am sorry I didn't see that. I have been doing a lot of reading to find answers to different problems and eventually you stop reading entire threads.

Hopefully that can make its way into a Wiki somewhere if it hasn't already!

Thanks again Akk!

[SoltanHeatwave]

Also make sure the C:\program files\mariadb 10.0\bin precedes the C:\program files\mariadb 10.0\ statement. Otherwise the search will stop in the C:\program files\mariadb 10.0\ folder and will not search the \bin folder. At that point it will error out. Old DOS trick and problem. The repack installs both path statements, but it doesn't install the \bin statement first. Well, it didn't in my installation.

[Akkadius]

Originally Posted by markusdabrave

I learned the hard way - read the entire thread

It's the only major thing not in the repack.

It's a hell of a lot better than the alternative, doing it all from scratch having no clue what you're doing.

Even if you do know what you're doing, people get hung up on many stupid things.

The repack is definitely a massive time saver.

I really don't feel like spending 10 hours going through and getting everything just weeded out just right and tested on several platforms to change one small thing to build another repack.

[SoltanHeatwave]

I think the Repack is great. Vsab brought the variable solution to me.

I was just letting everyone know that if they do have this problem to check the path statement to make sure the \bin precedes the other mariadb path statement. You shouldn't have to change it not even implying that you should.

I just wanted anyone who is running into this problem and don't have any xp in the old dos path environment to know what to look for.

The correction is a simple one.

Just add \bin to the first mariadb path statement and delete it from the other one.

Takes longer to find it in the path than to correct it.

[Qwan]

Hello...

I have a fresh install using Titanium client. I can launch the server just fine, get the four console windows as expected. When I try running the client, I can't see any servers and login fails. Anyone have a clue as to what may be the problem?

[karekiz03]

I got it up and running, but when I restarted the installer tried to re-install on bootup. Anyway to kill the installer from launching on restart?

Running Windows 7 64-bit

*Edit: Fixed it, was problem with corrupted registry on startup. Used Fixit to fix the registry.

[MillerT]

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[World Server] Starting HTTP world service...
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\Program Files\MariaDB 10.0\bin/mysql
================================================== ==========
Binary Database Version: (9077)
Local Database Version: ()

Retrieving latest database manifest...
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/db_upda
te_manifest.txt)
o Saved: (db_update/db_update_manifest.txt)
You have missing database updates, type 1 or 2 to backup your database before ru
nning them as recommended...

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Check and stage pending REQUIRED Database updates
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 3
Reading manifest...

ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_02_logsys_packet_logs_with_dump.sql)
o Saved: (db_update/2015_02_02_logsys_packet_logs_with_dump.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_01_logsys_packet_logs.sql)
o Saved: (db_update/2015_02_01_logsys_packet_logs.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_28_quest_debug_log_category.sql)
o Saved: (db_update/2015_01_28_quest_debug_log_category.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_25_logsys_Mercenaries_category.sql)
o Saved: (db_update/2015_01_25_logsys_Mercenaries_category.sql)

ERROR 1932 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist in engine
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_19_raid_group_mentor.sql)
o Saved: (db_update/2014_10_19_raid_group_mentor.sql)

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Run pending REQUIRED updates... (5)
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 3
Running Update: 9054 - 2014_10_19_raid_group_mentor.sql
ERROR 1932 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist in engine
ERROR 1932 (42S02) at line 2: Table 'peq.raid_leaders' doesn't exist in engine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9069 - 2015_01_25_logsys_Mercenaries_category.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9070 - 2015_01_28_quest_debug_log_category.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9074 - 2015_02_01_logsys_packet_logs.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 2: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 3: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9075 - 2015_02_02_logsys_packet_logs_with_dump.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 2: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Reading manifest...

ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_02_logsys_packet_logs_with_dump.sql)
o Saved: (db_update/2015_02_02_logsys_packet_logs_with_dump.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_01_logsys_packet_logs.sql)
o Saved: (db_update/2015_02_01_logsys_packet_logs.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist in engine
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_19_raid_group_mentor.sql)
o Saved: (db_update/2014_10_19_raid_group_mentor.sql)

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Run pending REQUIRED updates... (5)
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...