UPDATED: Approved Akka's Repack Update 8-26-2015

[Huppy]

Originally Posted by Akkadius

No, the binaries from the update will automatically run eqemu_update.pl and download it if you don't have it. You need to drop the updated binaries as instructed into your server folder and this will occur on its own.

I actually did what the instructions said, I unzipped the whole .rar pack in to my eqemu server folder and let it overwrite all the executables. Then I run the world.exe and that's as far as I got. Is that what you mean ?

[Akkadius]

Originally Posted by Huppy

I actually did what the instructions said, I unzipped the whole .rar pack in to my eqemu server folder and let it overwrite all the executables. Then I run the world.exe and that's as far as I got. Is that what you mean ?

Your credentials in your eqemu_config.xml to your MySQL server are wrong, you need to fix it.

[Huppy]

Originally Posted by Akkadius

Your credentials in your eqemu_config.xml to your MySQL server are wrong, you need to fix it.

Ok, maybe I am misunderstanding something, as I already indicated the current old server I am running now is connecting to the DB from that same file eqemu_config.xml (user name root pass *****) for db login.
I have not changed that config file, I left it in the server folder when I put your world.exe file in there.
I've been running this older server for a few years now, just thought I would update and seen your repack and figured I would try it out.

[Akkadius]

Originally Posted by Huppy

Ok, maybe I am misunderstanding something, as I already indicated the current old server I am running now is connecting to the DB from that same file eqemu_config.xml (user name root pass *****) for db login.
I have not changed that config file, I left it in the server folder when I put your world.exe file in there.
I've been running this older server for a few years now, just thought I would update and seen your repack and figured I would try it out.

When world.exe says cannot continue without a MySQL server, its failing to login.

If you installed the repack it is installed MariaDB, another database engine on top of what you had. I would look into that.

[Jahosphat]

ok i ran the patch after updating successfully yay!.. i ran the bat to start the server.. and it launches the updated world.exe again... intended? it launches the 3 other command prompts, i changed my server name in the config but i don't see the server listed.. ill try it again when i get home.. anything im missing?

[epilz]

Have you forwarded the ports on your router? Akkas repack sets up your firewall exceptions, but you must forward the ports correctly on your router.

[Jahosphat]

when i ran the first runthrough i was able to see my server listed.. post patch i didn't see it, i changed the server name but didn't seem to help..

[epilz]

If you close all 4 windows, and manually run world.exe, do you see any errors?

[Jahosphat]

Originally Posted by epilz

If you close all 4 windows, and manually run world.exe, do you see any errors?

no it just goes through the options again to update.

[epilz]

is it prompting you for updates?

[Huppy]

Originally Posted by Akkadius

When world.exe says cannot continue without a MySQL server, its failing to login.

If you installed the repack it is installed MariaDB, another database engine on top of what you had. I would look into that.

Ok, after your last reply, concerning the MariaDB, I had to do some searching because I couldn't find anything related to that from what I found in the zip
file that I got from your link in post here:
http://wiki.eqemulator.org/l/wa/file...015-stable.rar
I was simply unzipping that in to my server folder, letting it overwrite.

But I found an .msi installer you have here:
http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Repack which shows content of the MariaDB. I'm about to install it and see what kind of trouble I can get in to

[Jahosphat]

this is what i get.....


Reading manifest...

Missing DB Update 9077 '2015_02_12_zone_gravity.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_12_zone_gravity.sql
Saved: db_update/2015_02_12_zone_gravity.sql
Missing DB Update 9076 '2015_02_04_average_coin.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_04_average_coin.sql
Saved: db_update/2015_02_04_average_coin.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_02_logsys_packet_logs_with_dump.sql
Saved: db_update/2015_02_02_logsys_packet_logs_with_dump.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_01_logsys_packet_logs.sql
Saved: db_update/2015_02_01_logsys_packet_logs.sql
Missing DB Update 9073 '2015_01_31_character_item_recast.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_31_character_item_recast.sql
Saved: db_update/2015_01_31_character_item_recast.sql
Missing DB Update 9072 '2015_01_30_merc_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_30_merc_attack_delay.sql
Saved: db_update/2015_01_30_merc_attack_delay.sql
Missing DB Update 9071 '2015_01_29_merc_stats_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_29_merc_stats_table_update.sql
Saved: db_update/2015_01_29_merc_stats_table_update.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_28_quest_debug_log_category.sql
Saved: db_update/2015_01_28_quest_debug_log_category.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_25_logsys_Mercenaries_category.sql
Saved: db_update/2015_01_25_logsys_Mercenaries_category.sql
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_15_logsys_categories_table.sql
Saved: db_update/2015_01_15_logsys_categories_table.sql
DB up to date with: 9067 - '2015_01_21_npc_types_update.sql'
Missing DB Update 9066 '2014_12_31_npc_types_default_values_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_31_npc_types_default_values_update.sql
Saved: db_update/2014_12_31_npc_types_default_values_update.sql
ERROR 1146 (42S02) at line 1: Table 'peq.vwmercnpctypes' doesn't exist
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_26_merc_weaponinfo_table_update.sql
Saved: db_update/2014_12_26_merc_weaponinfo_table_update.sql
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_24_npc_types_table_update.sql
Saved: db_update/2014_12_24_npc_types_table_update.sql
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_24_npc_types_update.sql
Saved: db_update/2014_12_24_npc_types_update.sql
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_15_multiple_table_updates.sql
Saved: db_update/2014_12_15_multiple_table_updates.sql
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_13_inventory_table_update.sql
Saved: db_update/2014_12_13_inventory_table_update.sql
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_09_items_table_update.sql
Saved: db_update/2014_12_09_items_table_update.sql
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_01_mercs_table_update.sql
Saved: db_update/2014_12_01_mercs_table_update.sql
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_11_26_InventoryTableUpdate.sql
Saved: db_update/2014_11_26_InventoryTableUpdate.sql
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
Missing DB Update 9055 '2014_10_30_special_abilities_null.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_30_special_abilities_null.sql
Saved: db_update/2014_10_30_special_abilities_null.sql
ERROR 1146 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
DB up to date with: 9050 - '2014_09_20_ban_messages.sql'
DB up to date with: 9048 - '2014_09_09_attack_delay.sql'
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'

URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_08_23_player_events_and_player_aa_rate_hourly .sql
Saved: db_update/2014_08_23_player_events_and_player_aa_rate_hourly .sql

Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
DB up to date with: 9044 - '2014_08_20_merchantlist_probability.sql'
DB up to date with: 9043 - '2014_08_18_spells_new_update.sql'
DB up to date with: 9042 - '2014_08_12_NPC_raid_targets.sql'
DB up to date with: 9041 - '2014_08_02_spells_new.sql'
DB up to date with: 9040 - '2014_07_10_npc_spells.sql'
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
DB up to date with: 9035 - '2014_04_27_AISpellEffects.sql'
DB up to date with: 9034 - '2014_04_25_spawn_events.sql'
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
DB up to date with: 9031 - '2014_04_10_No_Target_With_Hotkey.sql'
DB up to date with: 9030 - '2014_04_04_PhysicalResist.sql'
DB up to date with: 9028 - '2014_02_26_roambox_update.sql'
DB up to date with: 9027 - '2014_02_20_buff_update.sql'
DB up to date with: 9026 - '2014_02_13_spells_new_update.sql'
DB up to date with: 9025 - '2014_02_13_Rename_instance_lockout_tables.sql'
DB up to date with: 9022 - '2014_01_20_Weather.sql'
DB up to date with: 9020 - '2014_01_20_Not_Extendable.sql'
DB up to date with: 9018 - '2014_01_09_PreservePetSize.sql'
DB up to date with: 9017 - '2014_01_08_SpellsNewAdditions.sql'
DB up to date with: 9015 - '2013_12_26_MerchantList_Class_Required.sql'
DB up to date with: 9014 - '2013_11_18_AssistRadius.sql'
DB up to date with: 9012 - '2013_11_07_BaseData.sql'
DB up to date with: 9011 - '2013_10_31_Recipe_disabling.sql'
DB up to date with: 9009 - '2013_10_12_Merc_Special_Abilities.sql'
DB up to date with: 9008 - '2013_07_11_NPC_Special_Abilities.sql'
DB up to date with: 9007 - '2013_05_05_Item_Tick.sql'
DB up to date with: 9006 - '2013_05_05_Account_Flags.sql'
DB up to date with: 9005 - '2013_04_08_Salvage.sql'
DB up to date with: 9002 - '2013_03_1_Merc_Rules_and_Equipment.sql'
DB up to date with: 9001 - '2013_02_25_Impr_HT_LT.sql'
DB up to date with: 9000 - '2013_02_18_Merc_Rules_and_Tables.sql'
DB up to date with: 8000 - 'mercs.sql'

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Run pending REQUIRED updates... (2
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

[Akkadius]

Run 3 again as it instructs exactly in the first post

[Jahosphat]

same thing.. world.exe and is seeing a missing..

Also just went back and deleted everything rebooted, reinstalled the original pack..everything to the T... same results... maybe it's just not meant to be..

Keep getting this when running server.bat

Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
db_update_manifest.txt
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...

[mikepitts25]

Did you figure it out? I am wondering if you maybe forgot to update your system Path variable to include the location of the MariaDB/bin folder.