[TUT] Making a MaNGOS Server (Windows ONLY)

Guide last updated: February 1st 2010
-MaNGOS now supports 3.3.0A

What you will need:
-WoW client updated to 3.3.0A
-MySQL server community edition (download here)
-SQL client (a good one is SQLyog Community, available here; scroll down a bit on that page)
-GIT client (msysgit available here)
-Microsoft Visual C++ 2008 (Express Edition available here)

Getting the MaNGOS source files
-Install your GIT client if you haven't already
-Once installed, make a folder anywhere and call it whatever you want (this will be your MaNGOS source folder so you might want to call it "MaNGOS" or something)
-Right click your new folder and select "Git GUI Here"
-When the GIT GUI window comes up, click on "Clone Existing Repository"
-Another window should pop up
-In the "Source Location" field, type in:

Code:

git://github.com/mangos/mangos.git

-In the "Target Directory" field, type in the filepath of your folder (e.g. C:\MaNGOS)
-Click "Clone" and wait for it to finish
-Once it's done, close the GIT GUI

Compiling MaNGOS
-Open Visual C++ and in the menu bar at the top, click "Tools" then Options
-Click the "+" next to Projects and Solutions, then click VC++ Directories
-Make sure the drop down menu days "Executable Files"
-Click the open button near the right of the dialog window, and make sure the path is:

Code:

C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Bin

-Click the drop down menu and make sure it says "Include Files", then click open and make the path:

Code:

C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Include

-Click the drop down menu and make sure it says "Library Files", then click open and make the path:

Code:

C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Lib

-Go to your Mangos compile folder, then into the "win" folder
-Open the "VC80.sln" file, or for 2008 users "VC90.sln"
-Click "Build" in the menu and select "Configuration Manager"
-Click "Release" in the drop down box for "Active Solution Configuration"
-The "Active Solution Platform" should be set to "Win32"
-Then, click "Build" in the menu and select "Build Solution"
-If you get any errors, click "Build" in the menu and select "Clean Solution", then restart the compile
-Note: this WILL take a long time - You might get some warning messages...If you do, don't worry about it, it's normal

Installing MaNGOS
-Add all the .exe files, .dll files and .pdb files in the compile folder into your Mangos folder (Ctrl + F to find them)
-Go back into your MaNGOS source folder, then into the "src" folder, then into the "mangosd" folder
-Rename "mangosd.conf.dist" to "mangosd.conf"
-Go back into your MaNGOS source folder, then into the "src" folder, then into the "realmd" folder
-Rename "realmd.conf.dist" to "realmd.conf"

Exracting maps and DBC files
-Go back into your MaNGOS source folder, then into the "contrib" folder, then into the "extractor" folder
-Place the "ad.exe" application in your World of Warcraft folder
-Run it and wait for it to finish (can take a while)
-Make two new folders in your MaNGOS core folder (note: not your source folder, the core folder is where you put all the .dll, .exe (etc.) files), one called "maps" and one called "dbc"
-Copy the extracted dbc files into the dbc folder and the maps into the maps folder

Installing the MySQL server
-Run the setup file
-Choose "Typical" setup when asked
-When the installation is finished, you're going to be asked if you want to configure the server; make sure that's checked off

Configuring the MySQL server
-Choose "Standard Configuration" when asked
-Check off "Install as Windows Service" and "Launch MySQL Server Automatically" when asked (the name of the service should be "MySQL")
-Choose "Modify Security Settings" when asked
-Type in a password, make sure it's one you will remember (Note: Default server password is mangos, use that if you are not putting your server online for other players)
-If you plan on having a registration page on another machine, or plan on being able to access the database from another machine other than the one the databases are hosted on, check off "Enable Root Access from Remote Machines"

Setting up the databases
-Run SQLyog
-Click the "New Connection" button at the top of the connection window somewhere
-Name the connection anything you like
-Fill out the fields as indicated below:
MySQL Host Address: This is "127.0.0.1" or "localhost" for playing singleplayer or LAN; if you want to put your server online, put this as the IP or DNS of the server that MaNGOS is being hosted on.
Username: Type in "root".
Password: This is the password you set up when you installed the MySQL Community Server.
Database(s): Leave this blank for now.
-Click "Connect"

Adding Databases
-In the top left-hand side, right-click "root@(IP here)"
-Click "Create Database"
-For the database name type in "realmd"
-Do the same, except for two more databases named "mangos" and "characters"

Once that's done...

-Click "File" in the menu at the top of SQLyog
-Click "New Connection"
-This time in the databases field, type:

Code:

realmd;mangos;characters

-When SQLyog asks if you'd like to save the changes, choose yes
-Click "Connect"
-Now, in the left-hand database list, right-click "realmd" and click "Restore from SQL Dump"
-Click "Browse", and select your MaNGOS source folder, then go into the "sql" folder and select realmd.sql
-Click "Execute"

Once that's done...

-Right-click "characters" and select "Restore from SQL Dump"
-Click "Browse", and select the characters.sql in the same sql folder
-Click "Execute"

Once that's done...

-Go here to download the newest UDB database (contains all the world stuff)
-Make sure that your MaNGOS core is up-to-date with the database (check your core's revision number, then the compatible revision number within the file title of the UDB database)
-Download the latest UDB update packs here (if that link doesn't work, go here and find the updates folder in /trunk)

Updating your database with .sql batch files
-Open the .sql file you are going to use to update the database in Notepad
-Open SQLyog and connect to your server
-Select the database that is supposed to be updated
-In the textbox to the right of SQLyog at the top of the application (the query textbox), paste the contents of the .sql file
-Select all the text in the textbox, then press the play button in the toolbar at the top of SQLyog
-Parts of the application will become grayed, wait for the query to finish executing

Configuring MaNGOS
-Go into your Mangos folder
-Open mangosd.conf in Notepad
-Look for the part "DataDir ="
-Make sure it looks like the following:

Code:

Datadir="."

-Look for the following codes (and change them as necessary):

Code:

WorldDatabaseInfo = "[Server IP];3306;root;[SQL password];mangos"
LoginDatabaseInfo = "[Server IP];3306;root;[SQL password];realmd"
CharacterDatabaseInfo = "[Server IP];3306;root;[SQL password];characters"

-Save, exit
-Go back into your Mangos folder
-Open realmd.conf in Notepad
-Look for the following code (and change it as necessary):

Code:

LoginDatabaseInfo = "[Server IP];3306;root;[SQL password];realmd"

-Save, exit

Setting up your client for use with your server
-Go into the folder where you installed WoW
-Go into your "data" folder
-Go into your locale folder (it's going to be named something like "enUS", "enGB", "frFR", "deDE", etc.)
-Open realmlist.wtf in Notepad and change the contents to the following:

Code:

set realmlist [server IP]
set patchlist [server IP]

Running your server
-Go into your MaNGOS core folder
-Run mangosd.exe and realmd.exe
-Everything should work fine unless you did something wrong

Errors
-If you get an error that says something like "sql was probably updated" or "# fields, # missing", then you need to update your database and possibly your entire core
-If you get any map or dbc errors, make sure that the "datadir" field is set to "." (in mangos.conf) and that your dbc and map files are up-to-date with your client in your MaNGOS core folder

Creating Accounts Without a Registration Page
-Once everything in mangosd.exe has loaded, type-in the following (with some cores there is tons of text flooding the command prompt; not to worry, keep typing anyway, it doesn't matter) :

Creating the actual account

Code:

account create [username] [password]
Example: account create Phenomenon 123

Enabling expansions for a user

Code:

account set addon [username] [1 for TBC, 2 for TBC and WotLK]
Example: account set addon Phenomenon 2

Changing GM levels

Code:

account set gmlevel [username] [anything from 0 to 3, 3 being administrator, 0 being player]
Example: account set gmlevel Phenomenon 3

Congratulations! You're now ready to play on your very own private server.

 

Some pics would be nice. But seems easy enouph. Keep it up

 

add meh on msn blupig


[email protected]

 

Guide updated to 2.4.1.

 

Also thought i would let everyone know that if you cant quite follow all this there is a version which basically does everything for you called reaper mangos... If your stupid check that out on google.

 

Hey blupig, great tut. Just one question:

On step 1 with the SQLyog - done what it says, but when i press connect:

It comes up with

Error No. 20033
Can't connect to MySQL server on "localhost" (10061)

Any help would be great thanks
or msn me on [email protected] - or email: [email protected]

 

PM me with some screenshots.

 

Yeah, I realise I'm an idiot...But when I log into the server theres no NPC or Mobs...Help?

 

I am going to try this when i get home I always wanted to make my own server.

 

You most likely installed with the UDB database... download the project silvermoon one if you just want a quickly setup funserver style one with GM island etc...

for an easy to setup wow google reaper mangos.

it is all GUI basically

 

No, he didn't lol. Most MaNGOS servers are based on UDB, and work fine. He probably executed the blank database that comes with the binaries

 

Hey all, new here and hate to do this but I can't seem to find the answer anywhere else. Plus this is probably the best tut i've seen and the most up to date. The only thing that would make it really great is pics

My dilemma? ad.exe will not cooperate. It always stops at 41%. I've read a few threads on other forums regarding the issue but no concrete solutions. So I implore anyone on this forums, how do I fix that issue?

I've even tried using the Ascent ad.exe and tuts to no avail. I feel that neither Mangos of Ascent want me to get them to work lol.

 

One of your MPQ files might be different...Are you using the trial versions of WoW, or do not have the Burning Crusade by any chance?

 

Sorry for the late reply, but I was able to finally, after hours upon hours of frustration get it to work.

I found that the Core that I was using wasn't compatible with the DB that I was using since it was too old. So I downloaded the newest revision of the core and the newest supported 2.4.2 DB and it worked like a charm. Ok not exactly, it was still being a bitch when I tried configuring it for LAN connection, and then Internet connection.

But, after all that time I was finally able to get it to work. Now I just have to get familiarized with the software, DB, SQL tables and commands all over again and fix some of the world issues the DB has...like no working Weapon Master...

 

Also, please don't email me about this. I've gotten about 4 emails to [email protected] about this post.

 

Awesome TUT! This one is by far one of the best ive seen so far!

Now i have TBC, and a fresh install done on it and all the utilities, BUT im non patched and on dail up.... So my version is actually 2.3.0 And a 1 gig set of patches is impossable.

I am assuming if i get Mangos 0.9.0.tar , that that will work in the place of the mangos compilation you have for this TUT? or will i need ALL 9 of the Mangos files?

In addition i have Vista, and it comes with net.framework 3.0, i again assume that will be sufficient for this?

i will update my progress by editing this post, so others can see and learn from my experience as well... =)

from what i can see that is what this is about...

 

that is great is there anyone who would be like a mentor cause i wanna set one up?

 

The guide's been updated, a couple people have been having issues with game versions so I added a new binary compile.

 

Hi blupig. First of all I'd like to thank you for this excellent tutorial, it works PERFECT for me. I'm starting with Mangos now and it's been really helpful.

I'd like to ask you one question:

I would like to create a custom PvP server, kind of the Arena servers Blizzard has. That means no PvE at all, just BGs, Arenas and maybe some outdoor PvP to get some "points" which you would spend on new gear.

Is it possible to customize this installation to work the way I want? (Of course, I know C/C++ programming and SQL). And if so, any idea on where could I find more information about it? (I'm not asking you how, because I guess it must be quite complicated to be explained in a short tutorial)

Thank you very much again ^_^

 

If those points are custom items you plan on making as a currency for users to buy new gear from a vendor, you'd have to look into some heavy core editing. For the rest though, you can easily edit the database to allow what you want. If you need some help getting it started, feel free to PM me. Some BGs might not work, you there also might be the need to apply some C++ patch files and compiling your own core.