Configuring Mangos for TBC Server or WoW Classic Server – Setting up Private WoW Server

Please check the new version on how to create wow private server for better version. Besides the new guide list everything in a single page for easier reading

This is the second part of the Creating your own World of Warcraft Server using Mangos

  1. The First part is all about Installing and Configuring MySQL on your Windows Machine
  2. The Second part is about Configuring the WoW Mangos itself
  3. The Third part is all about Setting up Private WOW Server for Lan Party
  4. 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 too
  • SDB 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 Repository
  • Latest 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 :

  1. Compiled Mangos Revision 3462 for Win32 / Windows by Maxis
  2. Compatible SDB Full Dump for Mangos 3462 with Changesets 156
  3. 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 :

Wow server directory structure

  1. The daemon directory is where you should extract the mangos program itself
  2. The data directory is where you should put the extracted maps and dbc folder (soon you’ll know about this process)
  3. 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

  1. Copy the ad.exe into your WoW Game directory (usually C:\Program Files\World of Warcraft)
  2. Create folder called maps
  3. Run the ad.exe and wait until its finished
  4. Move the maps folder into C:\WoW\data (if you’re using the same directory structure like me)

Extracting maps

After you’ve finished extracting maps now it is the time you use DBC Extractor … and here’s the step to use it

  1. Extract the MPQE.exe (and it’s dll if available) into your WoW Game Data directory (C:\Program Files\World of Warcraft\Data)
  2. 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
  3. Run the shortcut and wait until it finished
  4. Rename the DBFilesClient folder into DBC
  5. 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

Creating Shortcut

and then the shortcut properties

Properties of Shortcut to DBC Extractor

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

  1. Extract the SQL files from my mangos sql dump into C:\WoW\SDB (if you follow my directory structure)
  2. Open Command Prompt
  3. Run the sql query from the command prompt (look image below for an example on how to use the query)

Command to use to import the mangos sql files

and here’s what it’ll looks like when it’s finished

SQL Import Process 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 :

  1. Extract the SDB Full Dump for Mangos Revision 3900 into C:\WoW\SDB
  2. Extract the Mangos Program / Archive into C:\WoW\Daemon\Mangos
  3. Go into C:\WoW\Daemon\Mangos\SQL
  4. Copy the create_mysql.sql and realmd.sql into C:\WoW\SDB
  5. Open the Command Prompt
  6. 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

  1. mysql -u root -p -v < create_mysql.sql
  2. mysql -u root -p -v -D realmd < realmd.sql
  3. 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 :

  1. Go into C:\WoW\Daemon\Mangos
  2. Open the mangosd.conf using wordpad (you can not edit it using notepad, because it is using Unix Line Break)
  3. Change the datadir into C:\WoW\data
  4. Save it

Now here’s some screenshot of the mangos configuration file editing process :

Editing mangosd.conf

Inside mangosd.conf

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 :

  1. Run the realmd.exe (C:\WoW\daemon\mangos\realmd.exe)
  2. Run the mangosd.exe (C:\WoW\daemon\mangos\mangosd.exe)
  3. 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 :

Realmd process launched

Mangosd process launched

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 124
  • SDB 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

Damn i'm looks great

Another Screenshot

Comment?

Note: Comment may not appear right away.

771 comments on “Configuring Mangos for TBC Server or WoW Classic Server – Setting up Private WoW Server

  1. r4zor, for one, how can anyone help when they don’t know what you’re trying to do in the command prompt… an account? motd? what?

    ——————————————

    shadow make sure you have the right map extractor, and patch the client to what the server supports, then run the extractor.
    here is 2.1.x
    http://filebeam.com/da2c29d42a14ca81a4e4c18c8f51f4b5

    —————————————–

    bejoy it sounds like your configuration, or you aren’t running realmd… your magos conf should be set to 127.0.0.1 if you’re playing on the same machine you’re hosting, otherwise if it’s on your lan, you’ll need to go into the database using SQLyog and goto realmd database and to realmlist, and in the tables, add a second realm name, call it whatever you want, add the IP adress of the host computer, and set you realmlist.wtf to use (set realmlist 127.0.0.1 if you’re playing on the hsot machine)
    set realmlist 192.168.x.x or your wan ip from whatsmyip.net
    set patchlist 192.168.x.x or ”

    ———————————————

    Nick, make sure that mysql instance is running and you’ve created the realmd and mangos database using the guide that reaper-x made.
    otherwise it’s your realmd.conf configuration.

  2. What do i put up in the cmd prompt cause I dont know and I go up to a certain point and it doesnt let me type any more. im running the wow classic things that u put up plz help!

  3. Still getting 0004331.map does not exist error. I even deleted and reinstalled both classic and TBC and repatched it up to 2.1.1.6739, do I need to repatch to 2.1.2? Before I started my game was patched to the last WoW patch.

  4. I am Stuck at “Unable to connect” I keep my Internet Online , User MySQL 5 (40 MB), Mangos 4431 with ScriptDev2 124 , SDB 0.7.3 with Changesets 208 , WoW TBC 2.1.3.
    Pls Anyone Help

  5. brynjarg | Sep 17, 2007 | Links to this comments | Reply

    A little update I goggled that error and saw it had something to do with .NET Framework. Downloaded it, got rid of that error, but instead, command prompt window opens up and closes.

    0———————————————0

    for the mpqe.exe you need to create a shortcut with

    “C:\Program Files\World of Warcraft\Data\enUS\MPQE.exe” /p locale-enUS.MPQ DBFilesClient\*.dbc

    as the target for the shortcut, make sure the all the dbc extractor files are in the enUS folder

  6. brynjarg

    Yes you put all the files into the enXX folder, insted of running the shortcut. I clicked on my enUS command scripted (guessing it depends on region) and I ran the program for me. Creating the needed file.

  7. also getting this

    2007-09-17 06:47:23 Using configuration file mangosd.conf.
    2007-09-17 06:47:23 MaNGOS daemon /0.7-SVN (Win32)
    2007-09-17 06:47:23 to stop.

    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM http://www.mangosproject.org
    MMMMMM

    2007-09-17 06:47:23 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-09-17 06:47:24 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@’localhost’ (using password: YES)

    2007-09-17 06:47:24 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos

  8. Help! i did your easy way thingy and i get this every time i open mangosd.exe or realmd.exe! what am i doing wrong??

    2007-09-16 19:09:59 Using configuration file realmd.conf.
    2007-09-16 19:09:59 MaNGOS realm daemon /0.7-SVN (Win32)
    2007-09-16 19:09:59 to stop.

    2007-09-16 19:09:59 Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-09-16 19:09:59 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@’localhost’ (using password: YES)

    2007-09-16 19:09:59 ERROR:Cannot connect to database

  9. A little update I goggled that error and saw it had something to do with .NET Framework. Downloaded it, got rid of that error, but instead, command prompt window opens up and closes.

  10. Okay, I feel like i’ve followed your guide carefully, step by step but I keep getting the same error “The application failed to initialize properly (0xc0000135) click on OK to terminate the application”

    I get this when I try to open the MPQE.exe shortcut wich i placed in “C:\Program Files\World of Warcraft\Data” along with the dll file and MPQE.exe

    What I’m wondering if there is a version conflict here. I’m using the mangos version(Mangos 4431 with ScriptDev2 124) you posted in the UPDATE section along with “SDB 0.7.3 with Changesets 208” But I downloaded “ad.exe” from the links at the top of this page.. Do i need a newer version of ad.exe? I got that part to work.. managed to run it and throw the “maps” folder to “C:\Program Files\World of Warcraft\Data”

    Also another question I got regarding what is inside the “DBC Extractor” folder.. there is the MPQE.exe, a dll file, then there is “enUS” bat file along with a readme file wich says “put the files in C:\Program Files\World of Warcraft\Data\enUS” Would that be “enGB” folder or whatever”enXX” based on region. This just creates confusion imo, would be nice if you could clear this up.

    One more thing, I’m running on a 2.1.3 version of WoW and the screenshot you post from your data folder doesn’t even get close to match mine, you got way more .MPQ files than me it seems..

    Other than that this seems like a very nice guide props for making it.

    Thanks in advance

    brynjarg

  11. I did all your told steps correctly. (I Think)
    I use TBC 2.1.3 ,Mangos mangos 4431 that came with your project package ,MySql 5(40+ MB ).
    I cant connect to Mangos
    What should i do??
    Which Programs (Files) do need to keep open except for Wow.exe???
    Thank you

  12. ok i keep getting an error saying that there should be 137 lines and the something is probally updated can someone please help i really want to do this and i am so new at it
    email me plz or respond here [email protected]

  13. 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

  14. Ok i’ve been at this forever and now im really confused with all these programs and files, can someone please!please! make me an GM account on their TBC private server! Please! /cry

  15. # Sebastian

    Try running my own compiled version of mangos (it’s not using Debug information)

    Ok, but can i still have a TBC server?

  16. I can’t connect to my own server after making a charcter. My game verison is TBC 2.1.3

    I am using mangos 4431 that came with your project package.

    Yes I understand how setup mangos and its DB, yes I know how to create test accounts. I just can’t figure out why it won’t connect.

    Everything is set at 127.0.0.1;3306
    Now in my Realmd and mangos they both a section that reads “realm port” and “world port” both are different is that problem?

  17. I scraped everything for the 5th time and this time I got everything working…well except for ther fact that I can’t connect to my own server after making a charcter. My game verison is TBC 2.1.3

    I am using mangos 4431 that came with your project package.

    Yes I understand how setup mangos and its DB, yes I know how to create test accounts. I just can’t figure out why it won’t connect.

    Everything is set at 127.0.0.1;3306
    Now in my Realmd and mangos they both a section that reads “realm port” and “world port” both are different is that problem?