Xenithar

I want to update this topic. H0zen gave me a patch to try and a detailed testing guide. After applying the patch, everything appears to work now. Every test in his guide passed. This was a code fix, not a database fix.

Okay, everything in the database is correct, so this isn't as simple as I had hoped. I attached a picture of the rotated cars for reference. Not sure what is going on here, but maybe it has something to do with MaNGOS <-> client communication or the way the model gets loaded. Another problem I noticed is that only one tram loads. Last time the tram closest to the portals was running. After restarting mangosd it was the one further away from them. May be related but I am not sure. The database matches historically correct settings, so I am not sure yet.

Now that I think about it, I believe the tram was rotated 90deg also. Time to break out dBeaver! Thank you, H0zen.

Okay, so my friends and I have been bug-hunting. We found that the Deeprun Tram appears to have both trams on one track and only one is visible to players, but it's not the same one for all players. This makes it impossible to board or, should you glitch on, exit the trams. In addition, one of the elevators and doors for UC is rotated about 90deg out. I am sure this is in the database and I can fix/test/PR it, but where? These are not transports so they're not in there, but where are they?

Okay, for some reason either I did not transfer the gomodels directory to the server, or it failed to transfer. H0zen was helping me try to figure things out and I realized the directory was not there. Copying it over resolved the issue.

I've attached the GPS info you requested. I hopped onto the boat at Booty Bay and got the info while on the boat, as requested.

I use the latest from github. Last build was a week ago. I just made the changes to my config and restarted the server. I'll get the requested info shortly. As for more info, you get onto a ship/zep when it is docked. It carries you away but then the ship/zep is removed from the game world, your character drops back to the world instead of teleporting.

So this is a bug that needs squashing, not a misconfiguration on my end?

Got a strange one I've been trying to resolve today. Transports (ships/zeppelins) will disappear and leave the players to fall into the ocean. I'm not seeing any errors in the console window or in the logs. No warnings. I mean I get a lot of spam about being asked to load an already loaded navmesh tile, but I don't believe that is the issue. I've dug through the configs and found nothing that should be stopping these things from carrying passengers. Is this a known issue or have I mucked up something?

Are those Windows servers? I installed Devuan (barebones, shell-only install) on a Dell EMC PowerEdge T140 and my high on the diff has been 11ms. In addition, the server starts in under two seconds. I mean it's absolutely crazy. The T140 has an x8 PCI-E NVME RAID controller in it. I have two 256GB PCI-E 3.0 NVME SSDs in RAID1 in there. The OS and MaNGOS binaries live there. It also has a Dell PERC H730P RAID controller attached to four 500GB SAS disks (HDDs) in RAID10. This is only for the database. It is mounted with things that make ext4 commit changes instantly. The H730P has a battery backup on it. It also has 32GB of ECC DDR4 in it. The OS and MaNGOS only use around 1.8GiB of RAM though. What I have noticed though, is that lower diff times seem to drastically affect ping. 0-11ms keeps my client ping at 20~30ms. 80ms of diff shoots it up to 80+ on the client. That's what had me wondering. Also, the T140 is far weaker than my R820 or R540 servers. The only difference is that the 2U servers run Windows Server 2022 and the T140 now runs Devuan, and it does a FAR better job despite inferior hardware. So I only have a few remaining questions. Is the diff a measurement in milliseconds of how long it took to update the world on a single iteration? In other words, the config says 100ms and it takes 105ms so diff shows 5ms? I don't remember this from the last build I did before covid, the loss of a business, a kid, and all the other "fun" things that happened. Also, the MaNGOS server only seems to use two cores on this server also, and only up to 20% usage on each core. Is it possible with the current build to split the world loop in some way to take advantage of multiple cores? The R820 and R540 both have 40 cores and 80 threads. The T140 is 6 cores and 12 threads. Still, if I could better use the hardware, it would be nice. Maybe a world loop for Kalimdor and a second one for Eastern? *EDIT* One off-topic question. I have used the GUI extractor and got dbc, gomodels, maps, and mmaps, but no vmaps. Do we sue vmaps any more? I have googled and looked around here but cannot find anything about them not being removed.

Okay, I've been working on this for three days now and I am no closer to solving it beyond saying that something is broken on the Windows build. I run zero in a Server 2022 VM hosted by Hyper-V on Server 2022 on the actual system. The system has four E5-4650v2 Xeons (10-core, 20-thread each). The VM has 32GiB of RAM and four six cores. Running realmd and mangosd ONLY on the VM. The issue is latency. I get, on gigabit LAN, 80ms on average. Friends outside the LAN who normally ping sub-100 to other game servers, get 500+. The server has four gig Ethernet connections and dual SFP+ (25Gbps) connections. My WAN is only 1Gbps both ways. I first gave the map update four threads instead of two. Then six. No change. Then I saw that the diff being reported was 130~160ms. I set the map update frequency to 150 instead of 100. Now it jumps around 20~60ms. Pings are increased. I set it to 250ms and it still deviates 0~60ms. Again, two threads or six threads makes no difference. This indicates to me that something is broken somewhere. The entire time the server is struggling the cores it is running on are between 5% and 8% usage, so we're not pegging out the CPU. It is using less than 4GiB of RAM. Nothing is stressed. For reference, the VM sits on a RAID10 array of four 1.2TB SAS-12 disks. No bottlenecking. Here is where it gets fun. If I build zero on my old Linux server, the one Jesus signed back in the day (E3-something, 2012 era, 16GiB RAM, single disk), it runs fine. In other words, the RC car from Radio Shack running on C batteries is absolutely demolishing a formula 1 car. All I can figure is that the Windows build is very broken somehow. The physical hardware is not being stressed in any way, it's like MaNGOS just refuses to use more than one thread or something in Windows. Is this the case? I have a Dell EMC T140 with hardware RAID I can put Artix Linux on and host from, but I'd rather have it on the big server. Am I overlooking something or is the Windows build bugged in some way?

I figured it out. If you change RealmZone to 2, which SHOULD be English, it shows German. In fact, many of the options show German. Setting it to development (1) works fine. I can even set the DBC locale and that works, but anything aside from 1 in RealmZone means you speak German. I currently have RealmZone set to 1 and I can set my DBC to 0 or 255 and it shows English, as it should.

I have been away from this for too long. I feel like I am overlooking something simple. Either way, I have blown four hours and cannot figure out what is going on. If I connect my client to my ancient server from pre-2020, it shows English and everything is fine. When I change realmlist.wtf to point to the brand-new server (clean install, nothing carried over) it asks me to select a realm, but only has German for the language. I've checked everything and reinstalled twice. No errors or warnings. The client is 1.12.1 enGB (I can NOT find an enUS client) and I extracted the mmaps, vmaps, gomodels, and dbc from it. Server and realmd start fine. It just wants to force me to German. In troubleshooting, I have tried to force enUS as follows in mangosd.conf. GameType = 1 RealmZone = 2 DBC.Locale = 0 In addition, I have verified that the timezone in the realmd database is set to "United States" (2, IIRC). So everything is forcing enUS, but I cannot select English. Any ideas? I'm probably missing something obvious. Oh, both the hypervisor and VM the server runs in are set to eastern US time.

Is the character configuration data stored in the "playerbytes" and/or "playerbytes2" column(s)? I would like to make a blank, fresh version of my existing characters in another database on the new server I am setting up. All I want is for their display attributes (selected heads, bodies, horns, whatever) to be identical. I figure I'll create an identical character (race, gender, class) and copy the correct data over so they look the same. I'm not interested in copying anything else. Possible, or waste of time?

That did it. Clean install with no errors or warnings. Now I get to dig into the configuration files, do the map extraction, and all of the other fun things.

I'm at work right now, will try in a bit. I'm going to wipe the database server clean and do everything fresh again. I will update as soon as I have done so.

I'm trying to get back into MaNGOS. I'm looking to get back to coding, but I need to catch up a bit. I used one of the prebuilt binaries and ran the batch-file in the databases folder to setup a clean server on a brand new database server. Setup is as follows. Dell R820 (40c/80t, 1TB of ECC RAM, 16 SAS SSD drives across two H710 PERC RAID controllers) is the base. I run Windows Server 2022 on it with only Hyper-V installed. It is NOT domain-joined and uses different credentials than domain admin, creating an "air-gap" for security. All VMs are also Windows Server 2022 and are domain-joined. I run MariaDB (the latest version) on a brand-new VM with the short hostname "sv01" and the long one hidden to protect my domain name. A VM with the hostname "WOW01" is going to run Zero, One, and Two. It currently has six cores and 32GiB of RAM assigned, but I can go to much, much more if needed. I log into the VM as a normal domain user, not an admin. This is also for security reasons. I downloaded the latest build from GitHub (September 2nd, IIRC), extracted the contents of the zip, and ran the batch file in the databases folder to setup my databases. I have granted root access only from localhost and from the FQDN of the WoW VM. After gathering my info, it created and populated the world database. Then it tried to do the character database and I got this. Not sure what happened here. Clean install of official Microsoft Windows Server 2022 on the host and all VMs. I installed MariaDB just before trying this, so the database is brand-new and nothing exists yet. Is this an error overlooked in the SQL or was I supposed to do something else prior to running the installation batch file? I couldn't find any real guides on the prebuilt stuff. I am using prebuilt because I will be developing on a different Dell EMC server (T140, also has RAID and all, but smaller) that will be running Artix Linux. It will use the same DB server. I just wanted to get it up and going beforehand. So where should I begin?

No. I dumped MySQL years ago due to security and performance issues and switched to MariaDB. My MariaDB install was originally managed by MySQL Workbench. Been using DBeaver ever since. I might give it a whirl, but I am asking my members to vote on either doing this massive upgrade or just starting fresh on the current build.

I have an issue I'm trying to work around. This server is ancient. It runs MariaDB 5.6. I cannot use mariadb-dump in DBeaver to dump the databases to my rig. I can dump them on the server, but it's virtualized inside of XenServer. I've spent an hour trying to get mount to mount one of my Windows shares and it is plagued by the "Host is offline" bug. Can't mount the share no matter what version of SMB is specified. This means no easy access to my dumps. Pain in the rear! I mean, it was turned off for nearly a decade. Would it be easier to work on SQL or something that I can run to bring it forward while I work out the issue with SMB? The new server (Dell R820) will likely be running Server 2022 and Hyper-V with 2022 VMs. SQLServer for the DB.

Sorry for the delay in my response. I came down with something heavy on the first. Fever, nausea, congestion, the whole nine yards. I can get up and move today but I'm still fighting an on/off fever. I can get you actual data if you need it.

So what is involved in this? I am thinking export each account and associated character, pet, inventory, bank, etc. Setup the new stuff and either import or modify the exported SQL to add or remove columns as needed, then import.

The world database. 21 1 0 revision_refactor 21 1 1 Fix Dire Maul creature spawn Fix rare creatures spawn in Dire Maul arena 21 1 2 Fix startup errors 21 1 3 strings for new gobj commands strings for new gobj commands: state, lootstate 21 1 4 delete doubled MC runes delete doubled molten core rune spawns 21 1 5 remove doubled lothos gossip delete doubled gossip_menu_option for the teleport to molten core 21 1 6 list_aura_command core adds another parameter to be printed out: aura stack number 21 1 7 remove_unused_tables remove_unused_tables - pvpstats_battlegrounds.and players 21 1 8 update_dbdocs_entries update_dbdocs_entries - for recently changed tables 21 1 9 Backports part2 Second Set of Backports 21 1 10 Clean up server startup Clean up server startup 21 1 11 Fix last startup errors server - fix last startup errors 21 1 12 clearcasting_proc Strings for added gobj commands: state, lootstate 21 1 13 item_template_dbdocs_update New subtables added, and Notes and field comments added to the item_template table 21 1 14 Presence_of_Mind Better proc condition for mages Presence of Mind 21 1 15 Improved_Sap Rogue - Improved Sap 21 1 16 improved_trap_radius improved_trap_radius 21 1 17 Warlock_Shadow_Vulnerability Warlock Shadow Vulnerability: proc on shadow dmg 21 1 18 enchanted_moonstalker enchanted_moonstalker_cloak 21 1 19 SD3_Updates Updates to SD3 21 1 20 No_XP_Rate Set NO_XP_ON_KILL Flag for Flesh Eating Worm, Anvilrage Reservist, Rotting Worm 21 1 21 dbdocs update for custom_texts New subtables added, and Notes and field comments added to the custom_texts table, plus corrections made to 2 item_template submodule tables 21 1 22 dbdocs updates Added New subtables and replace missing subtable 21 1 23 dbdocs updates Updates made to dbdocs table, subtables, and fields 21 1 24 dbdocs updates New subtables added, Notes and field comments added, up to and including the quest_template table 21 1 25 dbdocs updates New subtables added, Notes and field comments added. Updates and fixes completed at this point for the World database. 21 1 26 quest_level_fixes Corrected the minimum and maximum level values for multiple quests. 21 2 1 Added disables table Added disables table. 21 2 2 NPC 10578 gossip fix NPC 10578 gossip fix 21 2 3 NPC 15213 event_ai fix Add missing spells 9672, 11831, 12058 and 13339 21 3 1 Fix paladin SoR Update the wrong version of SoR at char creation 21 3 2 Fix Random MMGen Scripts Update the wrong values for SCRIPT_COMMAND_MOVEMENT 21 4 1 Refactor areatrigger_teleport Implement condition system AT 21 4 2 many, many updates many, many updates 21 5 1 creature_template addition Add 2 extra model fields in creature_template 21 5 2 BG template addition Prevent exiting starting area in BG 21 5 3 BRD_Ring_Of_Law BRD Ring Of Law fix 21 5 4 MC_Updates a variety of fixes for MC 21 5 5 mass updates mass updates and fixes 21 5 6 quest Items of Power nonzero trap radius allows the chest to spawn 21 5 7 Adjust Fireball spell Adjust Low-level spells cast by high-level players 21 6 1 ticket_commands_update GM_ticket_commands_update 21 7 1 dbscripts_refactor dbscripts_refactor 21 7 2 Forsaken Courier drop fix Quest: Hint of a new plague fix 21 7 3 Creature curhealth fix Creature:Some Curhealth error fix 21 8 1 warden_refactor warden_refactor 21 8 2 Paladin Spell bonus fix Paladin Spell bonus fix 21 9 1 warden_keys_adjust warden_keys_adjust 21 10 1 warden_table_redone warden_table_redone_including_check_grouping 21 10 2 Morbent_Fel_fix Weakened_Morbent_Fel_fix 21 10 3 startup_error_fixes fix_several_startup_errors 21 11 1 quest_relations modify_quest_relations_tables 21 11 2 dbdocs_cleanup_pt1 dbdocs_cleanup_pt1_db_scripts 21 11 3 additional_warden additional_warden_updates 21 11 4 warden_dbdocs warden_dbdocs_updates 21 11 5 relations_cleanup remove_old_relations_tables 21 11 6 dbdocs_quest_relations dbdocs_quest_relations 21 11 7 fix_bg_buffs fix_battleground_buffs 21 11 8 various_fixes various_fixed 21 11 9 start up fixes server start up fixes 21 11 10 frostwhisper door fix Door of the Ras Frostwhisper room 21 11 11 fix various issues Fix various issues on the tracker 21 11 12 fix quest 1222 Fix quest 1222 - stinkys escape 21 11 13 Blackrock fixes Some Blackrock fixes and Fixed quest 2936 21 11 14 Fixed req. of PvP items Fixed faction requirements of PvP items 21 11 15 Taelan_fixes Fixed missing Taelan waypoint 21 11 16 Warlord Krom'zar_fixes Fixed stats for Warlord Krom'zar 21 11 17 Warlord Krom'zar_weapon_fix Fixed weapon for Warlord Krom'zar 21 11 18 loot_table_fixes Fixed Loot Table for several bosses 21 11 19 respawn_time_fixes Fixed Loot Table for several bosses 21 11 20 dragonkin_eggs_fixes dragonkin_eggs_fixes 21 11 21 fuelwood_quests_fixes fuelwood repeatable quests 21 11 22 felwood_quests_fixes felwood repeatable quests 21 11 23 dungeon_boss_dmg_fix Fix damage of instance bosses 21 11 24 fix_dungeon_boss_control Fix control of instance bosses 21 11 25 quest_item_drop_fixes quest_item_drop_fixes 21 11 26 improved_fixes improved_fixes 21 11 27 dbdocs_update_dbscripts dbdocs_update_dbscripts 21 11 28 creature_update creature_update 21 11 29 Rare_drops_fix Rare_drops_fix 21 11 30 BOE_Drop_Chance BOE_Drop_Chance 21 11 31 Fix_SD3_Texts Fix_SD3_Texts 21 11 32 Various_fixes_and_reverts Various_fixes_and_reverts 21 11 33 dragonkin_eggs_fixes dragonkin_eggs_fixes 21 11 34 Adjust_Onyxia_and_Reg_Windsor Adjust_Onyxia_and_Reginald_Windsor 21 11 35 [DBDOCS] Updated some fields [DBDOCS] Updated some field descriptions 21 11 36 Adjust_Demon_Portal_Time Adjust_Demon_Portal_Time 21 11 37 Quest_4224_Update Quest_4224_Update 21 11 38 Update_Quests_4001_and_4342 Update_Quests_4001_and_4342 21 11 39 Homing_robots_speed Homing_robots_speed 21 11 40 Fixed_quests_4736_and_4739 Fixed_quests_4736_and_4739 21 11 41 Fix_Quest_2986 Fix_Quest_2986 21 11 42 Fix_Kroshius Fix_Kroshius 21 11 43 various_quest_fixes various_quest_fixes 21 11 44 Quest 27469 Quest 27469 Friends on The Other Side 21 11 45 Update_DBScript_Type Update_DBScript_Type 21 11 46 Grimm Guzzler Grimm Guzzler updates from cmangos 21 11 47 Remove field from dbDocs Remove unused field from dbDocs Subtable table And for the characters. 21 1 0 revision_refactor 21 2 0 Honor Counting Fix the counting of honor 21 2 1 Characters dbdocs update Characters database dbdocs update to the fields and new tables added 21 3 1 Fix SoR paladin Remove Judgement spell and wrong version of SoR 21 4 1 match_client_limits match_client_limits 21 5 1 characters_pvpstats characters_pvpstats

The database version info is as follows. MariaDB [realms]> SELECT * FROM db_version; +---------+-----------+---------+--------------------------+------------------------------------------------------------------------------------------+ | version | structure | content | description | comment | +---------+-----------+---------+--------------------------+------------------------------------------------------------------------------------------+ | 21 | 1 | 0 | revision_refactor | | | 21 | 1 | 1 | dbdocs update | Added some dbdocs updates | | 21 | 1 | 2 | dbdocs update | Filled in some fields and added missing subtables back, as they had dropped out somehow. | | 21 | 1 | 3 | Remove field from dbDocs | Remove unused field from dbDocs Subtable table | +---------+-----------+---------+--------------------------+------------------------------------------------------------------------------------------+ I am running this server as zero, classic, vanilla, whatever you want to call it. We have twelve active accounts and thirty characters. I cannot figure out where to find the hash, but I have logs dating back to 2016. Thanks for the help and guidance.

Okay, so I had a kid and my server was physically off for eight years. Luckily, a new CR2032 battery in the motherboard was all that it needed. Everything fired up and we're right where we left off. That said, I probably have a million or so updates to do. Not sure I want to try bringing my ancient box forward because I don't believe that it will be easy. That said, the other option is what I am leaning towards. New box, build current server, import old characters/accounts/etc. I purchased a new Dell R820 system (Four Xeons, 40 cores, 80 threads, 512GB ECC RAM, two H730 PERC RAID cards and 16 SAS drives for them) that should run MaNGOS loaded without a hitch. I want to migrate to this box anyway, so how difficult would it be to export my custom teleport locations, accounts, characters, etc on the old box and import them onto an up-to-date MaNGOS server? I am assuming that this would be semi-involved also due to possible DB changes.

I worked on it (specifically the mage) before my child was born. I had the mage doing some basic stuff well. Attacking ranged, frost nova and blink when close, and repeating, but it was far from finished, and then there's the other classes. I will be resuming work once my daughter is a tad older and isn't so needy. Right now I am strapped for time, and I do miss working on MaNGOS.