Custom Search
Configuring Mangos for TBC Server or WoW Classic Server – Setting up Private WoW Server
Posted by Reaper-X Jun 28 2007 6:07 pm
Update : You can browse this site software category if you’re looking for my mangos release or my custom mangos release … btw i’d suggest you to get my mangos release first because it has been tested with WoW 2.2.3 and will be updated frequently (even easier than anything written on this old post because i already include everything you need to run your own wow private server except for mysql program of course)
Or you can also look at the recent software section located at the footer section of this website to see the new update to my mangos release :)
This is the second part of the Creating your own World of Warcraft Server using Mangos
- The First part is all about Installing and Configuring MySQL on your Windows Machine
- The Second part is about Configuring the WoW Mangos itself
- The Third part is all about Setting up Private WOW Server for Lan Party
- The Fourth part is all about Installing and Setting up Apache Webserver with PHP
Okay and before i start i’d like to warn you first especially to those who’s using Dial Up Connection because there are a lot of images used here and the previous mysql installation guide although i’ve optimized it further
Without further ado … here’s the guide ;)
Requirements :
If you’re planning on creating :
– The Burning Crusade Server :
Compiled Mangos Revision 3900 or above for Win32 / Windows (the latest revision compatible with latest SDB at the time i wrote this post) but feel free to upgrade it later if you want but do not forget to update the SDB tooSDB Full Dump by Ozay Turay (to make thing simpler) that is compatible with Mangos Revision 3900+Latest Ad.exe to extract map from Mangos SVN RepositoryLatest DBC Extractor
Okay i’ve decided to upload my own compiled mangos to make thing easier, for more info see this new post
Btw … the installing mysql part is still the same … so if you need information on how to install mysql refer to the part 1
Note : Since most people who compiled Mangos for Win32 already included DBC and Map Extractor in their release you should use that one first. And unfortunately i can not give direct link to the files so you must try it by yourself and judge which version is the best for you :)
Btw some people prefer (especially to those who’s using high speed internet access – not me of course –) to download the extracted maps and dbc from somewhere rather than extracting it directly so if you are using the same high speed connection you might like to use this option
– World of Warcraft Classic Server :
- Compiled Mangos Revision 3462 for Win32 / Windows by Maxis
- Compatible SDB Full Dump for Mangos 3462 with Changesets 156
- Compatible Map and DBC Extractor
That’s it … unfortunately since it is using the old mangos revision you’ll notice more bugs compared to latest / newest version for TBC … and since i dont have TBC Client installed, i can only give you a how to guide to configure your mangos server based on my experience when doing remote assistance to someone who asked for help via MSN
Btw if you’re going to create WoW Classic server you can use my extracted DBC Files
Side Note : Basically since there are no differences on creating WoW TBC Server and WoW Classic Server the only thing you should change is just the filename … don’t worry if you don’t understand what i’m talking about right now, soon you’ll know about it :)
Creating Directory Structure :
Okay i assume you’ve finished downloading all the required stuff and now its the time to configure your mangos. But before that you need to extract the required files first into your harddrive and organize it before starting to configure mangos (although this step optional but i think organized directory structure looks better but that is just my own opinion)
Look at the image below for a good explanation about this :
- The daemon directory is where you should extract the mangos program itself
- The data directory is where you should put the extracted maps and dbc folder (soon you’ll know about this process)
- The SDB is just a temporary directory to be used when importing the SQL Files
Extracting Maps and DBC Files from World of Warcraft Game :
Now this is when the ad.exe and dbc extractor came. But first we are going to use the ad.exe. And here’s the step
- Copy the ad.exe into your WoW Game directory (usually C:\Program Files\World of Warcraft)
- Create folder called maps
- Run the ad.exe and wait until its finished
- Move the maps folder into C:\WoW\data (if you’re using the same directory structure like me)
After you’ve finished extracting maps now it is the time you use DBC Extractor … and here’s the step to use it
- Extract the MPQE.exe (and it’s dll if available) into your WoW Game Data directory (C:\Program Files\World of Warcraft\Data)
- Create shortcut to the MPQE, right click on it and choose properties and adjust it’s target into “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc
- Run the shortcut and wait until it finished
- Rename the DBFilesClient folder into DBC
- Move the DBC folder into C:\WoW\data (if you’re using the same directory structure like me)
If you want a more detailed explanation look at the screenshot below
and then the shortcut properties
Importing the SDB Files :
Okay we have finished extracting the maps and dbc files required for mangos, now we need to import the database first before you can run mangos program
and here’s the summary on how it done :
If you’re going to create WoW Classic Server
- Extract the SQL files from my mangos sql dump into C:\WoW\SDB (if you follow my directory structure)
- Open Command Prompt
- Run the sql query from the command prompt (look image below for an example on how to use the query)
and here’s what it’ll looks like when it’s finished
Note : Because some people prefer to see the importing process (some say it’s like Matrix .. lol), i decided to use -v (verbose) switch but if you prefer not to see it you can safely remove the -v switch
If you’re going to create TBC Server
Here’s the summary on how it’s done :
- Extract the SDB Full Dump for Mangos Revision 3900 into C:\WoW\SDB
- Extract the Mangos Program / Archive into C:\WoW\Daemon\Mangos
- Go into C:\WoW\Daemon\Mangos\SQL
- Copy the create_mysql.sql and realmd.sql into C:\WoW\SDB
- Open the Command Prompt
- Execute the same query as above but adjust the filename first
An example on how to execute the query is like below (you must do this in order) and using the same path as the above image
- mysql -u root -p -v < create_mysql.sql
- mysql -u root -p -v -D realmd < realmd.sql
- mysql -u root -p -v -D mangos < the_filename_used_on_sql_dump_from_e_turray.sql
And that’s it you’re finished importing the database required :)
Editing Mangos Configuration :
You’ve finished extracting maps, dbc and already imported the database required but now what else ? of course you need to edit the mangosd.conf file itself
Now here’s the summary on how it is done :
- Go into C:\WoW\Daemon\Mangos
- Open the mangosd.conf using wordpad (you can not edit it using notepad, because it is using Unix Line Break)
- Change the datadir into C:\WoW\data
- Save it
Now here’s some screenshot of the mangos configuration file editing process :
Make sure everything is working as it should :
Now you’ve done almost everyting required to make your own wow private server … now before started playing it you need to make sure that everything is okay before starting to connect to your own server
Here’s how it is done :
- Run the realmd.exe (C:\WoW\daemon\mangos\realmd.exe)
- Run the mangosd.exe (C:\WoW\daemon\mangos\mangosd.exe)
- See if one of the above process close itself automatically or not. If one of the process close itself automatically after launched that means there’s something wrong with your configuration try restarting the configuring process from the beginning
And now here’s the screenshot if your mangosd and realmd process is working as it should :
The last step for configuring mangos and wow, editing the Realmlist used by WoW to connect :
After everything is okay, now there’s one more thing left for you to do … which is editing the realmlist.wtf file inside your WoW Game directory (C:\Program Files\World of Warcraft\realmlist.wtf) using your favorite text editor. You can use notepad or wordpad to do this
The default realmlist.wtf file should be like this :
set realmlist us.logon.worldofwarcraft.com
and then change it into
set realmlist 127.0.0.1
Creating Test Account for yourself :
Okay now you’ve created and set up everything but there’s still one more thing left and that is creating a test account with normal player status for yourself. And this process is really simple actually all you have to do is just typing this on the mangosd window (above image)
create desired_username desired_password
Okay that’s it you just created a test account that can be used to connect to your own wow server. If you get error message and / or stuck at realm loop i’m sure there’s something wrong with your configuration or you’re not using compatible mangos / wow client
That’s all for this part … stay tune for the next part ;)
As a side note, this is the first time i’m using lots of images on my guides and i’m looking forward to your opinion about this (tell me if you like it this way or would you prefer text with few screenshot or images) :)
Update :
To those who’s still having problem with Mangos like finding the correct mangos version,etc. I’ve decided to upload my own compiled Mangos Revision 4431 with Scriptdev2 241, and also included DBC Extractor (Thanks to XLayer for his DBC Extractor) and VMaps Extractor. And also mirrored the SDB 0.7.3 with Changesets 208 from http://opensvn.csie.org/NewSDB
And here’s the file :
Mangos 4431 with ScriptDev2 124SDB 0.7.3 with Changesets 208
Another Update : See my new post about new Mangos 4488 Update with Silvermoon Database … and tested with WoW 2.1.3 Client … just look at the screenshot below
All you have to do (i assume you’ve completed all of the steps involving mysql installation, and also already extract the DBC and VMaps files) is just :
1. Import / Overwrite the database with this new SDB (if you want the easiest way to start all over again from the Importing SDB step, you can execute the create-database.sql inside my Mangos 4431 archive (in reaper-sql directory) using this command :
mysql -u root -p < create-database.sql
mysql -u root -p -D mangos < SDB_0.7.3_Changeset_208_Rev1.sql
mysql -u root -p -D mangos < reaper4431.sql
Note : Make sure you’re in the same directory as the create-database.sql and the SDB_0.7.3.sql when executing that command
2. And then the next step is, importing the sql files inside the scriptdev2-sql directory (2 files) like below example (must be in order) :
mysql -u root -p -D mangos < scriptdev_full.sql
mysql -u root -p -D mangos < scriptdev_additional_req.sql
And you’re done :)
Perhaps the above might sound confusing for some people, so if you need help just leave comment here
Here’s a screenshot taken using Mangos 4488 Scriptdev2 134
Trackbacks/Pingbacks
Leave a response
Connect with me
What I can’t figure from the error message is if its looking for a map and not finding it or if its found a map that isn’t supposed to be there…
as*
i keep getting an unable to validate game version when i try to get on my server. i used the same stuff ass valery did. what version do i need?
Yea, I’ve done everything exactly the way it was to be done, word for word. The maps and DBC folders are both in the data folder inside my own created WoW folder that is right under my C:\ drives nose.
The links you just posted are the exact things I used to do the process.
Now lets see… I have 4423 items that were extracted to my C:\WOW\Data/maps folder. Does that number look wrong? I extracted twice, both came out that way.
Thanks in advance for any responses.
@ valery
thanks a lot =) with your mangos i managed to get it to work, altough i can’t connect due to my game version being 2.1.3
anyone know any method of getting 2.1.3 without getting some Gbs of blizz updates? my WoW dvd is pretty old >_
Reposting so it’s easier for people to find.
I recommend everyone to patch your WoW to 2.1.2
MANGOS 4067
http://rapidshare.com/files/42204097/MaNGOSRev4067_ScriptDev2Rev69.rar
DBC FILES FOR WOW VERSION 2.1.2
http://rapidshare.com/files/38852051/DBCFiles2.1.2.rar
SDB FILES FOR MANGOS 4067
http://e-turay.com/files/MaNGOS/SDB/SDBFull-202-4067.rar
my advice for all is to set up a 2.1.2 server, and grab those three files (Mangos 4067, SDB dump 4067, and the DBC files for 2.1.2), all with links posted by Valery above. you can find a map extracter on the internet for 2.1.3 which worked fine for me. take all of that and follow this guide and it will work w/out a hitch.
i encountered so many problems trying to set up a 2.1.3 simply because there were lots of incompatibility issues with different mangos versions and sdb dumps. but Reaper set up this guide for you, and Valery linked all the files you need (minus the map extractor). The version you’ll be running is just a hair under the current 2.1.3.
just my advice
Anybody help!
with above subject
Valery
Thanks for the help.
Next Quistion and im sorry for the idiosy becouse if work with other programs before must i extrack all the files in the .sql folder which i copyd to sdb folder and must i extract the mangosd.sql file or the SDBFull-202-4067.sql
thanks a lot i found this guide easy to follow
and it just stretched my abillity i have tried many in the past and this one works a treat i also think that the pictures are a good improvment and they should be used becuase it tells me im on the right path
Although.. I’m not sure if that Mangos version works with 2.0.12
I’d either update your game version to 2.1.2 or download a Mangos that is compatible with 2.0.12 – you’ll also need to download SDB + DBC files that are compatible with 2.0.12
Draco,
I assume they will :)
Terox,
Apparently you’re having the same problem as Mord? So you should also check if you have put the Maps folder in the correct Data folder, not the one of the WoW game itself, but the one where you also had to put the DBC files in this tutorial.
Valery
Can i use your mangos ver 4067 with 2.0.12engb and will your dbc / SDB files still work. with it please help. [I'm still new to this program]
Hi, i’m having a problem running mangosd.exe on the step where you are supposed to see if everything is ok. I ran realmd.exe and it worked fine but mangosd.exe gives me this error when i run it:
2007-07-23 05:03:05 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-07-23 05:03:05 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-23 05:03:05 Realm running as realm ID 1
2007-07-23 05:03:05 Using DataDir C:\Games\World of Warcraft\Data/
2007-07-23 05:03:05 WORLD: VMap support included. LineOfSight:1, getHeight:0
2007-07-23 05:03:05 WORLD: VMap data directory is: C:\Games\World of Warcraft\Data/vmaps
2007-07-23 05:03:05 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-23 05:03:05 ERROR:Could not load vmap file ‘C:\Games\World of Warcraft\Data/vmaps/000_43_31.vmdir’
2007-07-23 05:03:05 ERROR:Correct *.map files not found in path ‘C:\Games\World of Warcraft\Data/maps’ or *.vmap/*vmdir files in ‘C:\Games\World of Warcraft\Data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
I am using Mangos version 4153. Can you please help me!!!
Glad it worked out for you, Benz!
@ Mord
Have you placed the map folder into the data folder you created in this tutorial? You know, the folder where you also put the DBC files in.
Fist i whant to say thank you
now lets get back to the proble im trying to set up a wow TBC 2.0.8 enGB server i’ve done the Mysql installation it works i’ve extracted the mpq files i get realmd to start but when mangos starts it give me the error maps is outdated or it gives me “item error found 12 expected 32″ this is just a example of one of this tipes of error’s it gives me. what version of mangos must i use and where can i get a SDB full update for that server. the right ad.exe for the server and the sql extractor needed for that server. please help o yes at this moment i’m using mangos 3306
Ok, I tried using Valery’s stuff and everything worked better, but I got a map error when starting mangos. Realmd started fine and did not close. Mangos closed immediately and gave me this error in the log:
2007-07-23 01:42:34 Using DataDir C:\WOW\Data/
2007-07-23 01:42:34 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-07-23 01:42:34 WORLD: VMap data directory is: C:\WOW\Data/vmaps
2007-07-23 01:42:34 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-23 01:42:34 ERROR:Check existing of map file ‘C:\WOW\Data/maps/0004331.map’: not exist!
2007-07-23 01:42:34 ERROR:Correct *.map files not found in path ‘C:\WOW\Data/maps’ or *.vmap/*vmdir files in ‘C:\WOW\Data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
How do I find this map or fix the problem period.
i keep getting ERROR:Error in `creature_template` table, probably sql file format was updated (there should be 65 fields in sql). when i run mangosd
. . . nevermind, i see it now in the /help list when you’re in mangos. i understand now.
k, it’s up and running. thanks again, valery. i noticed somebody told you to go thru mangos and enter “setbc yourcharname 1″. is this because those connecting to your server w/ accounts are not given access to TBC stuff?
for the_filename_used_on_sql_dump_from_e_turray.sql what should i put
mysql -u root -p -v -D mangos
great guide, im having some trouble can u help, for mysql -u root -p -v -D mangos
Ugh, everything works up to mangos where I create the user login…any command I put in mangos crashes it.
Using 4135 and SDBFull-203-4123
So close :/
thanks, valery. i got the correct mangos. i’ll give it a whirl.
last week i had a WoW 1.12.1 server going, and a few of us were playing it. . . . then i realized that the talent tree went up to 31 point talents instead of 41. . . . and i realized i needed to do a 2.x.x version of WoW. . . on well.
i’ll try those DBC files you linked, too, as soon as i’m able to download from that site again (i guess there’s a download limit to those without accounts, ha ha).
thanks again.
your mysql may not be working properly then mord, try to reinstall it.
i’m trying with your files now valery =) thanks a lot, praying that will work with 2.1.3 D:
I’m sorry Mord, I can’t help you with that error :(
No one can help me here? My firewall is turned off and I can enter the mysql command line client just fine. Still, I get this error when starting realmd and mangos. Help 8(
2007-07-22 05:31:39 ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t create TCP/IP socket (10050)
2007-07-22 05:31:39 ERROR:Cannot connect to database
Oh and Anarki, be sure to also use the SDB file I gave you the link to. The one on Silver’s site may be the latest one, but remember that your SDB files have to be the same version as your MaNGoS, in this case 4067 (Game version 2.1.2)
@ Benz
I’m terribly sorry, I posted the wrong link. This one should have the sql folder in it: http://rapidshare.com/files/42204097/MaNGOSRev4067_ScriptDev2Rev69.rar
And yes, my version is 2.1.2
@ Anarki
Maybe you have the incorrect DBC files, if you’re using my mangos version and SDB, then here are the DBC files for 2.1.2: http://rapidshare.com/files/38852051/DBCFiles2.1.2.rar
The link to the correct mangos with SQL folder is http://rapidshare.com/files/42204097/MaNGOSRev4067_ScriptDev2Rev69.rar
Hopefully it will work for you two.
@ valery
i got your mangos version, but as i couldn’t make it without a SQL folder, i got the latest sdb from silver’s site, but i’m still getting the same error =( could it be from the DBC?
Valery,
I am looking at that version of Mangos, but I don’t see a “sql” folder in there that has a create_mysql.sql file and realmd.sql file that you’re suppose to copy over into the other SDB folder that you’ve created. (i’m still following reaper’s guide as best as i can).
Is there a way to bypass that step?
And are you setting your TBC server to version 2.1.2?
Oh, by the way,
Does anyone have the SQL file for the Tier 6 sets? Or aren’t they available for MaNGoS servers yet?
Also, is there a way to get the Warglaives of Azzinoth that Illidan wears? and then I don’t mean the WoA that are already in the game, but the green ones – http://www.wowhead.com/?screenshot=view&3.32837#26189
If someone can’t help me out with these questions, I fully understand. I’ve been looking all over the internet myself.
@ Anon
it is the sql file from the SDB dump lol.
@ anarki
Your mangos and SDB must be the same version.. I’m using mangos 4067 and SDB 4067
Mangos 4067 – http://filebeam.com/15a6ee4e3ca39870476eb4959c66b8f4
SDB dump 4067 – http://e-turay.com/files/MaNGOS/SDB/SDBFull-202-4067.rar
the_filename_used_on_sql_dump_from_e_turray.sql
Ok, for the third time i write this now… damn server deleting my entire posts…
WHERE THE HELL AM I SUPPOSED TO FIND THIS E_TURRAY SQL FILE? basically… i have no idea where to find this or where to point the command to.
“mysql -u root -p -v -D mangos
mysql -u root -p -v -D mangos
Everything was going fine, but now I’m getting this error when I get to your “Make sure everything is working as it should” step….and its not…
2007-07-22 05:31:39 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-22 05:31:39 ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t create TCP/IP socket (10050)
2007-07-22 05:31:39 ERROR:Cannot connect to database
stuck on step 2, i extracted MPQE.exe and its dll into wow/data folder, then i created a shortcut and changed its porameters, when i run it to extract it tells me “The application failed to initialize properly… ” after i read these i got the idea that i don’t have dbc.mpq file in my data folder and tried to change the shortcuts parameters, same deal when i try to run it, so i am guessing it’s not the file that is missing but MPQE.exe fault, any thoughts?
I’m having same problem as King:
error in ‘item_template’ table, probably sql file format was updated(there should be 132 fields in sql)
i’m using mangos 4134, with SDB 4051 and the DBC you provided.
My game version is 2.1.3(too updated?) -> if so, is there a way to make it 2.1.2?
Thank you so much Chris! You really helped me out.
val, you need to go through mangos and type “setbc yourcharname 1″. that will set you up for tbc expansion. the game dosent think your account is approved for it.
nevermind, apparently only the ones in orgrimmar & sen’jin village dont work =)
Oh, and is anyone else having problems with the Riding Skill instructors? o_o;
I can’t talk to them and typing “.learn skill_id” doesnt work either – it doesnt even say it’s not a comment, it just..doesn’t do anything.
Sorry for all the questions. xD”
Yeah, Chrisb, I finally realized that and patched it up to 2.1.2 and it’s working perfectly fine now :D
the only prob I have now is that it says TBC isnt installed but I did follow the guide for setting up a TBC server and I do have it installed so I dont see what the problem is? O_o
mangos-files.de is also a good place for Mangos version
the Can not validate game version is because your sdb and/or mangos version dont mesh with the game version, one i can tell you for sure works is version 4096 for version 2.1.2 you can get both mangos and sdb versions for links above
k i have done evrything u wanted me to do to get this server running but it says failed to italize 0xc0150002 ??
I don’t know i think i missed something
I thank you for taking your time to reply to my question, Elliot, but unfortunately upgrading WoW to 2.1.0 doesn’t work out for me. :( I dunno, I’m going to try some more things and hopefully it’ll work out.