kjkrum

tl;dr: If anyone has any guesses as to what records in the OFFICIAL database might be crashing mangosd, I'd love to hear them. As I stated, I'm using only the minimal DB that comes with MaNGOS itself. So I am asking whoever made it. What was that about listening to what people are saying? But as it happens, immediately after bitching you out, inspiration hit me and I fixed the problem myself. It's like when you think of the answer to a question right after posting it, only better. For the record: I changed the races in playercreateinfo_spell, playercreateinfo_action, and playercreateinfo_item to invalid values. Now I can create and log into at least some (maybe all) of the race/class combinations I couldn't before. I'm going to add things back in until I find out what's making it crash. The reason I'm not using UDB is because I intend to change everything that can be changed without modifying the client. E.g., "Acolyte's Robe" #23322 becomes "Draenei Priest Robe". IMO (IANAL), this completely sidesteps any copyright issues. I believe a minimal working database can and should be distributed with MaNGOS.

Then stop closing my original "one thread." You've done it twice now. Also, asking different, highly specific questions != "multiple posting of the same repeated things". Right... with NO EXPLANATION WHATSOEVER. "This is a DB issue. Try XYZ." == helpful. "This is a DB issue. We're too cool to care about DB issues." == not helpful. Especially when you then lock the thread. I figured it out, though. Public servers are not officially supported, but everyone knows that's what everyone is using MaNGOS for. And the world of private WoW servers is a fiercely competitive one, with everyone fighting for users. So everyone holds their cards close to their chest. Drop the charade. You're not here to help.

Well, let me put it this way... I've been using open-source software for about ten years. OSS is certainly not known for its consistent operation or thorough documentation. But this project is by far the biggest clusterf--- I have ever seen. If I ever get it working, I'm going to fork it.

What, so more people can handwave me because UDB is officially unsupported? Seems kind of silly if MaNGOS really cannot function without unsupported third-party addons. So by definition, any working installation is unsupported. No wonder people are so unhelpful around here.

I've partially answered my own question. Race/class combinations are not restricted by the client when loaded by the server. Only character creation is restricted. If you add new combinations to mangos.playercreateinfo and mangos.player_levelstats, you can then change the race/class of an existing character, and the client will accept it. I made a gnome priest. If you change a toon's class in characters.characters while the toon is logged in, something changes it back when you log out. Perhaps that can be prevented. But if nothing else, players should be able to change their class via some Web interface. So... gnomes have healers now. This means war. Race war!

I now have build 10400, with a fresh database creating using the included scripts. Same problem. A few patterns are emerging: no humans can be created. No hunters of any race can be created. What do hunters and humans have in common?

I downloaded mangos from here: http://github.com/mangos/mangos/tarball/v0.16 Built it using MSVC10. No compile errors. No SD2 or UDB - I just want a bare bones server. Extracted the dbc and maps, making sure to use the new ad.exe I just created. Copied them to the correct locations. Copied the realmd.conf and mangosd.conf to the correct locations. Executed the scripts in /sql: create_mysql.sql, characters.sql into characters db, mangos.sql into mangos db, realmd.sql into realmd db. realmd starts ok. mangosd says this: I did not get that error with version 0.16-dev2. Using client version 12340 with both.

I'm pretty sure my DB is installed correctly. It's just a matter of sourcing the files in /sql into the appropriate databases, right?

Humans: no humans can be created. mangosd always crashes. Night Elves: DKs can be created and logged into. Wars can be created, but not logged into. Hunters, rogues, and druids cannot be created. Strangest of all, attempting to create a priest does not produce a crash or error, but it does not create the character. Furthermore, classes that normally can be created then exhibit the same behavior until mangosd is restarted. I'm done screwing around with this until somebody comes up with a useful suggestion.

With the stock mangos, it seems that if I can create a character, I can log into it. I just tested all Draenei classes. Everything works except hunters. Attempting to make a hunter crashes mangosd every time. More testing to follow.

I rebuilt mangos completely stock without SD2 and set up a new db without UDB. Still having the same problem. This might have something to do with it... tons of errors like this in Server.log: In the default minimal database that comes with mangos, the item numbers are all wrong. For example, "Squire's Pants" should be entry 23477, not entry 44. (Edit: There are multiple items called "Squire's Pants", and one of them is indeed item 44. Those are given to Human paladins. There are different Squire's Pants given to, e.g., Dwarf and Draenei paladins. And most of those entries are missing from a stock mangos.)

10401 seems to be the newest one on git. (And 10381 is the newest one available as a zip/tgz.) http://github.com/mangos/mangos Edit: hm, I guess somebody told me wrong. 12340 is the client build number, huh? So I do have the latest mangos. Which sucks, because it still doesn't work...

I'm trying to figure out why I can't create any characters unless I change the races in playercreateinfo_spell to invalid values, and I can't log into some races even after doing that. Running out of ideas... just double checking the client compatibility.

Well, I got UDB 392 installed, including the patches that came with mangos itself. I still cannot reliably create any race/class combination unless I renumber all the races in playercreateinfo_spell, and I still cannot log into humans. Any suggestions? I don't see anything on the console or in the error logs that points to anything in particular.

I think it's because I don't have UDB installed. The core playercreateinfo_spell refers to spells that aren't scripted... if that's the right terminology. When I did this: update playercreateinfo_spell set race = race + 100; I could create any character without problems. However, many of them crashed the server when I attempted to log into them. For example, I cannot log into any humans. But I can always log into gnomes and dwarves. I think maybe the humans are in invalid locations. The newest UDB I can find is version 0.12 (388) for mangos build 9539. Is there a newer version somewhere?

I downloaded the core source from git and the SD2 source from svn and built it according to the instructions on the forums. (Which, incidentally, are not very clear about how to incorporate SD2 or the database updates. If I wasn't an experienced programmer, I wouldn't have made it this far.) Creating any character and class combination almost always causes mangosd to crash. Once I successfully made a blood elf priest and was able to log in. Once I made a draenei hunter, but mangosd crashed when I tried to log in. Those successes were not repeatable. Edit: compiling with MSVC 2010 on WinXP.

I've got the core compiled with SD2 (I think), and all the database updates loaded. The server starts up fine, but it almost always crashes when I create a character. I don't even know where to begin troubleshooting.

Forum search is currently returning unrelated threads containing none of my keywords, making it rather useless.

Normally, in PvP areas like Gurubashi Arena, you cannot attack members of your party. What controls who you cannot attack? Could it be extended to, say, your guild, or your race?