Question: Updating from repack to New sources

[Bandor]

First off let me start by saying I currently run a server using the repack and have done alot of editing. So I have plenty of backups and have them in my new server file ready to be sourced in or whatever lol.

My problem however is I have been following the guide on the wiki and have had no trouble aside from actually running the sql server via XAMPP or the straight up mysql download, both say mariah db is using port 3306 so they can't connect. So attempting to work around and login to sql via cmd it tells me access denied no matter what password ive used.

So my question is how do I go about fixing this problem so I can create/source my db? Would my best bet be to completely remove everything (aside from backups and installers obviously) and start from scratch or is there a simple fix to this that I am failing to realize?

[vsab]

What did you change in your database setup? If you were compiling from source to get the latest server binaries you needn't have altered your database- just copy the .exe files over the ones the were installed by the repack.

[Bandor]

Haven't added/removed anything from my existing database. I had made it to the part on the guide that I would create a new database and source it to my new server folders. Which .exe files do I need to copy over? Files like world/zone or something else?

[vsab]

The easiest answer is all of the ones in the bin folder (world.exe, zone.exe, ucs.exe and so on. I normally copy all files, as that includes the debug files which helps me debug things when I'm developing). If you keep your eqemuconfig file the same (e.g. don't overwrite it), the first time you run world.exe it will run Akkadius' automatic database upgrade script and.. automatically upgrade your database. It's pretty slick, but make sure you read the options properly- the first time you run option 3 (upgrade) it works out what needs to be done, you then need to select option 3 again to actually apply them.

[Bandor]

So did what you said,though I could not find a bin folder on the repack So I just coppied all files from repack to new folder,Now when attempting to run world.exe I get the error

Error Loading Items: EQEmu exception <SharedDatabase> blah blah bah, line <741> Could not load items because items_mmf->Size<> !=size

[Bandor]

Didnt change anything simply waited a couple minutes,now when I run world.exe it opens a blank command window and nothing further happens

[vsab]

The files in the "Shared" folder have to match the specific server version as the format changes from time to time. Just delete all the files in the "Shared" folder- they will be rebuilt by running the new version of the shared_memory.exe program.

Since you have copied the repack files into your new folder (presumably it has the quests, maps etc folders as well as your config files). You would only need to update the newly compiled exe files.

The "bin" folder I mentioned was the "bin" folder where you compiled the newest source. e.g. C:\EQ\Source\Build\Bin\Debug in step 4 e) of the windows setup guide. When you do your compile the newest version of the EqEmu server (it's actually several programs) will be put there.

You would take the newly compiled shared_memory.exe, eqlaunch.exe, queryserv.exe, ucs.exe, world.exe and zone.exe from the C:\EQ\Source\Build\Bin\Debug folder and then copy into the new server folder.

[Bandor]

So did exactly as you said and got it going ran option 3 two times with no problems and got this back


Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9044 - '2014_08_20_merchantlist_probability.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9043 - '2014_08_18_spells_new_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9042 - '2014_08_12_NPC_raid_targets.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9041 - '2014_08_02_spells_new.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9040 - '2014_07_10_npc_spells.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9035 - '2014_04_27_AISpellEffects.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9034 - '2014_04_25_spawn_events.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9031 - '2014_04_10_No_Target_With_Hotkey.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9030 - '2014_04_04_PhysicalResist.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9028 - '2014_02_26_roambox_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9027 - '2014_02_20_buff_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9026 - '2014_02_13_spells_new_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9025 - '2014_02_13_Rename_instance_lockout_tables.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9022 - '2014_01_20_Weather.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9020 - '2014_01_20_Not_Extendable.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9018 - '2014_01_09_PreservePetSize.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9017 - '2014_01_08_SpellsNewAdditions.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9015 - '2013_12_26_MerchantList_Class_Required.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9014 - '2013_11_18_AssistRadius.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9012 - '2013_11_07_BaseData.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9011 - '2013_10_31_Recipe_disabling.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9009 - '2013_10_12_Merc_Special_Abilities.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9008 - '2013_07_11_NPC_Special_Abilities.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9007 - '2013_05_05_Item_Tick.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9006 - '2013_05_05_Account_Flags.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9005 - '2013_04_08_Salvage.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9002 - '2013_03_1_Merc_Rules_and_Equipment.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9001 - '2013_02_25_Impr_HT_LT.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9000 - '2013_02_18_Merc_Rules_and_Tables.sql'
Warning: Using a password on the command line interface can be insecure.
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... (18)
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

> 3
Running Update: 9045 - 2014_08_23_Complete_QueryServ_Table_Structures.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9046 - 2014_08_23_player_events_and_player_aa_rate_hourly .sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9051 - 2014_10_11_RaidMOTD.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9052 - 2014_10_13_RaidLeadership.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9053 - 2014_10_18_group_mentor.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9054 - 2014_10_19_raid_group_mentor.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9055 - 2014_10_30_special_abilities_null.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9056 - 2014_11_08_RaidMembers.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9057 - 2014_11_13_spells_new_updates.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9058 - 2014_11_26_InventoryTableUpdate.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9059 - 2014_12_01_mercs_table_update.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9060 - 2014_12_09_items_table_update.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9061 - 2014_12_13_inventory_table_update.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9062 - 2014_12_15_multiple_table_updates.sql
Warning: Using a password on the command line interface can be insecure.
ERROR 1060 (42S21) at line 16: Duplicate column name 'aug_6'
Warning: Using a password on the command line interface can be insecure.
Running Update: 9063 - 2014_12_24_npc_types_update.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9064 - 2014_12_24_npc_types_table_update.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Running Update: 9065 - 2014_12_26_merc_weaponinfo_table_update.sql
Warning: Using a password on the command line interface can be insecure.
ERROR 1051 (42S02) at line 2: Unknown table 'vwmercnpctypes'
Warning: Using a password on the command line interface can be insecure.
Running Update: 9066 - 2014_12_31_npc_types_default_values_update.sql
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Reading manifest...

Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9065 - '2014_12_26_merc_weaponinfo_table_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9064 - '2014_12_24_npc_types_table_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9063 - '2014_12_24_npc_types_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9062 - '2014_12_15_multiple_table_updates.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9061 - '2014_12_13_inventory_table_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9060 - '2014_12_09_items_table_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9059 - '2014_12_01_mercs_table_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9058 - '2014_11_26_InventoryTableUpdate.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9057 - '2014_11_13_spells_new_updates.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9056 - '2014_11_08_RaidMembers.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9054 - '2014_10_19_raid_group_mentor.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9053 - '2014_10_18_group_mentor.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9052 - '2014_10_13_RaidLeadership.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9051 - '2014_10_11_RaidMOTD.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9050 - '2014_09_20_ban_messages.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9048 - '2014_09_09_attack_delay.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9046 - '2014_08_23_player_events_and_player_aa_rate_hourl y.s
ql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9045 - '2014_08_23_Complete_QueryServ_Table_Structures.sq l'

Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9044 - '2014_08_20_merchantlist_probability.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9043 - '2014_08_18_spells_new_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9042 - '2014_08_12_NPC_raid_targets.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9041 - '2014_08_02_spells_new.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9040 - '2014_07_10_npc_spells.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9035 - '2014_04_27_AISpellEffects.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9034 - '2014_04_25_spawn_events.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9031 - '2014_04_10_No_Target_With_Hotkey.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9030 - '2014_04_04_PhysicalResist.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9028 - '2014_02_26_roambox_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9027 - '2014_02_20_buff_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9026 - '2014_02_13_spells_new_update.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9025 - '2014_02_13_Rename_instance_lockout_tables.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9022 - '2014_01_20_Weather.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9020 - '2014_01_20_Not_Extendable.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9018 - '2014_01_09_PreservePetSize.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9017 - '2014_01_08_SpellsNewAdditions.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9015 - '2013_12_26_MerchantList_Class_Required.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9014 - '2013_11_18_AssistRadius.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9012 - '2013_11_07_BaseData.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9011 - '2013_10_31_Recipe_disabling.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9009 - '2013_10_12_Merc_Special_Abilities.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9008 - '2013_07_11_NPC_Special_Abilities.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9007 - '2013_05_05_Item_Tick.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9006 - '2013_05_05_Account_Flags.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9005 - '2013_04_08_Salvage.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9002 - '2013_03_1_Merc_Rules_and_Equipment.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9001 - '2013_02_25_Impr_HT_LT.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 9000 - '2013_02_18_Merc_Rules_and_Tables.sql'
Warning: Using a password on the command line interface can be insecure.
DB up to date with: 8000 - 'mercs.sql'

No updates need to be run...
Setting Database to Binary Version (9066) if not already...

Warning: Using a password on the command line interface can be insecure.
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) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
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

> 1
Performing database backup....
Warning: Using a password on the command line interface can be insecure.

Todays Date: 01-14-2015
Database is peq
Backup Directory: backups
Directory currently exists... Adding files to it...

Backing up Database peq...

--- CMD ---
mysqldump -uroot -p"*******" peq > "backups\peq 01-14-2015.sql"
---------------------------------------

Backup DONE... DB Backup File Size '213735672' (203.83 MiB)

Final file located: backups\
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) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
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

> 0
[Error] Error Loading Items: EQEmu Exception (Shared Memory) in C:\EQ - ANW\Sour
ce\common\memory_mapped_file.cpp at line (112): Could not open the file to find
the existing file size.
[Error] Error loading skill caps: EQEmu Exception (Shared Memory) in C:\EQ - ANW
\Source\common\memory_mapped_file.cpp at line (112): Could not open the file to
find the existing file size.




Are the errors when going to exit something to be concerned with?

[Error] Error Loading Items: EQEmu Exception (Shared Memory) in C:\EQ - ANW\Sour
ce\common\memory_mapped_file.cpp at line (112): Could not open the file to find
the existing file size.
[Error] Error loading skill caps: EQEmu Exception (Shared Memory) in C:\EQ - ANW
\Source\common\memory_mapped_file.cpp at line (112): Could not open the file to
find the existing file size.

[vsab]

Is there a folder called "Shared" in the folder that world.exe etc are in? If not, create the folder.

[Bandor]

Yes,and it rebuilt it after I deleted everything in it as you suggested.

[Bandor]

Attempted to launch,made it to character selection and Couldnt log in,kept saying the zones were unavailable,and items appeared to be missing from characters.

[Bandor]

Scratch that last post I can now get in game and see items,appears I loaded wrong server on accident lmao

[Bandor]

So far from what I can tell those 2 errors were no cause for alarm everything seems to be functioning perfectly upon first glances. Ty very much for being so helpful/patient with me Vsab you have just my respect if that counts for anything lol

[vsab]

Are you using a Startup.bat or similar to launch the server?

What's the output from world.exe? Do you have any zone.exe instances running?

Are you able to log into your database either using command line or a tool like HeidiSQL?

[Bandor]

Using t_start_server just like I did with repack


World.exe

[Status] Using database 'peq' at 127.0.0.1:3306
Pulling down automatic database upgrade script...

No update necessary
Perl Version is 5.12.3
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
================================================== ==========
EQEmu: Automatic Database Upgrade Check
================================================== ==========
Operating System is: MSWin32
(Windows) MySQL is in system path
Path = C:\xampp\mysql\bin/mysql
================================================== ==========
Binary Database Version: (9066)
Local Database Version: (9066)

Database up to Date: Continuing World Bootup...
================================================== ==========



Logging in fine via Heidi and EoC as far as I can tell thus far everything is cool.

[vsab]

Glad you're sorted, maybe I'll pop into your server one day when I get a new home PC!

[Bandor]

One problem ive noticed is that it takes forever to get into server. If nobody is playing I will sit there and try to log in over and over and over while being plagued by the message 'that zone is unavailable' any way of fixing this? As long as people are playing it lets you get right in,but when zones sleep it seems they just dont want to wake up lol

[Akkadius]

Add more zones to your launcher table in the database, sounds like all processes are asssigned to something currently.

This takes affect the next time you run eqlaunch which is ran from the startup script.

[Bandor]

Opened up a couple extra ports (7200-7600) and am no longer having issues. It appears world was listening for closed ports,soon as I opened these ports I was able to log in and have had no more problems.