Mangos Windows Server Setup Guide

Stats Scanner · (#1 (**permalink**))

Some of the software you may need :

World Of Warcraft updated to latest mangos revision (check the link in next line for latest supported version)
Mangos, you can get all different versions HERE
The "ad.exe" map extractor tool HERE
The *.dbc extraction tool mpqe.exe (REQUIRES .NET FRAMEWORK)
You need latest recommended MySQL release.
you also need a MySQL editor of some sort, SQLyog is a very good free one.
Some compilations didnt include msvcr71.dll or msvcr71d.dll you can get those HERE

Installing MySql :

Launch the MySQL installation application.
When prompted, select "Typical" for setup type.
When prompted, select "Skip Sign-Up".
When install is complete you will be given the option to "Configure the MySQL Server Now". Make sure this is checked, then press finish.
When prompted, select "Standard Configuration"
When prompted, place a check in "Install as Windows Service" and "Launch the MySQL Server Automatically". Service name should be "MySQL"
When prompted select "Modify Security Settings". In the two empty dialog boxes, type in the password you wish to use for the MySQL root (aka Administrator) account. This is the most important account on MySQL and has full access to all databases and functionality. It's recommended you use a very strong password to prevent access to your MySQL server instance. (If you plan on administering your MySQL instance from a remote machine, then select "Enable root access from remote machines". If you don't know if you need this, then do not select it.)
Select execute to apply all of your configuration settings.

Installing SQLyog :

Launch SQLyog installation application.
Accept license agreement when prompted.
Install in default location when prompted. (You can install in an alternate directory if you prefer.)
When installation is complete, place a check in the box for "Run SQLyog 5.31".
When SQLyog launches you will be prompted to fill in the following.
- MySQL host address: Usually this will be "localhost" or the IP address of the server where your MySQL database is running.
- UserName: "root"
- Password: this is the password you selected in your MySQL installation for the root account (step #7 above).
- Database(s): "realmd;mangos"
- Leave other options to defaults.
Press Connect. This will connect you to your MySQL instance.
Once the interface opens, right-click on root@localhost in the left pane, and select "Create Database".
When prompted for a database name type "mangos".
Repeat steps 7 and 8 and type "realmd" for the second database.
Repeat steps 7 and 8 and type "characters" for the second database.

Installing Mangos Binaries :

Create a directory for your MaNGOS installation. For example: "C:\MaNGOS"

Extract all files from your downloaded binary to this MaNGOS directory.
- If you created your own binary copy all of the *.exe and *.dll files from your \bin\release directory into the MaNGOS directory.
- Make sure that the files mangosd.conf and realmd.conf are placed in this same directory. (Some binary compilations will have these files in an "extras" or "etc" folder.)
- If you've compiled your own binaries then you may need to copy the mangosd.conf.in and realmd.conf.in files from your "\src\mangosd" and "\src\realmd" directories. Rename them both by removing the ".in" portion of the file name.
- If you've downloaded your binary files, make sure it included two .dll files "libeay32.dll", and "libmySQL.dll" and that these are placed in your MaNGOS directory. If these were not included in the binary d/l check with the provider to see if they have these files in a seperate archive. If you compiled your own release, you will have these files in your release directory

Extracting the Map + dbc files :
These may need to be re extracted every client version change.

Place ad.exe into the client's root directory. ("C:\Program Files\World of Warcraft")
Create a subdirectory called 'maps'. ("C:\Program Files\World of Warcraft\maps") and one for dbc ("C:\Program Files\World of Warcraft\dbc")
Launch ad.exe. This will begin the extraction of map files. (This can take a long time depending on your system.) Go get some coffee or bawls or something to keep you awake.
When ad.exe has finished,... HEY YOU WAKE UP... ITS DONE... now.. copy the folders "C:\Program Files\World of Warcraft\maps" & "C:\Program Files\World of Warcraft\dbc" and place it in your ManGOS server directory ("C:\MaNGOS"). So you should now have a "C:\MaNGOS\maps" & "C:\MaNGOS\dbc" directory containing numerous (2400+) .map files and lots of .dbc files.
You may now safely delete the directory "C:\Program Files\World of Warcraft\maps".

Extracting Vmaps (optional and very resource intensive) :

Get the vmap extractor from HERE
Extract the above file somewhere maybe in your mangos folder
Double Click makevmaps_SIMPLE.bat. Depending on your system, this step may take quite some time so make sure there is still some coffee left or go get more.
- Alternately you could run "make vmaps.bat" instead, but additional prompts will come up in the process.
- As this process is improved upon, you may need to rebuild these files more than once. Pay attention to future release notes.
Move the vmaps directory into the root of the MaNGOS directory ("C:\MaNGOS\vmaps")

Inserting the Databses
Realmd (login accounts and realmlist) :

Connect to your MySQL server. (Follow steps 5 & 6 from Sqlyog install guide)
In the left pane, right-click on realmd and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
Browse to the "realmd.sql" file in your server directory. ("C:\MaNGOS\sql")
- If your database came with a realmd.sql use that one
Execute. This should only take a moment and you will get a message that it's complete.
Close Dialog.

Mangos (items & NPCs etc):

You can get one of the two biggest DB's :

The UDB official releases HERE
Project Silvermoon Databases HERE

Which ever you get is upto you.

Connect to your MySQL server. (Follow steps 5 & 6 from Sqlyog install guide)
In the left pane, right-click on mangos and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
Browse to the database file that you wish to load to create your database. (This will either be the basic mangos.sql from the binary downloads or a large full database from Silver's forum or another source.)
Execute. This will take quite some time depending on your system. At points it may seem like it's hung. LET IT RUN!
If you need to install any changesets/updates for you database, now is the time. Install them in order. Check with your DB site for more info.

Characters (info about characters, their inventory &spells & guilds & groups etc):

Your DB may come with a copy of the charcaters.sql or you may obtain one from the compile you downloaded.
Connect to your MySQL server. (Follow steps 5 & 6 from Sqlyog install guide)
In the left pane, right-click on characters and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
Browse to the database file that you wish to load to create your database. (This will either be the basic mangos.sql from the binary downloads or a large full database from UDB or Silvemoon.)

Configuring Realmlist DB :

Connect to your MySQL server. (Follow steps 5 & 6 from Sqlyog install guide)
Open the realmd branch in the left pane and select "realmlist".
At the bottom of SQLyog click on the "Table Data" tab.
Change the "name" field to your preferred realm name.
Goto KPs Network IP displayer - Display an IP...maybe your IP!!! and copy your IP shown. Change the ip in address column of realmlist table to the ip you just copied. this is the IP your players must connect to.

- Remember you must also open port 3724 and 8085 on your router. check HERE for guides with list of all well known routers.

Select the "Save Changes" button.

Configure Realmd.conf :

Open realmd.conf in notepad. It should be in your root server directory ("C:\MaNGOS).
Find "LoginDatabaseInfo =" Change it to "LoginDatabaseInfo = "127.0.0.1;3306;root;password;realmd".
Save and close file.
NOTE: password must be the same password used when you installed SQLyog earlier in this tutorial, and used again in the next part below..

Configure Mangosd.conf :

Open mangosd.conf in notepad. It should be in your root server directory ("C:\MaNGOS).
Find these lines and set as shown:
- DataDir = "."
- WorldDatabaseInfo = "127.0.0.1;3306;root;password;mangos"
- LoginDatabaseInfo = "127.0.0.1;3306;root;password;characters"
- LoginDatabaseInfo = "127.0.0.1;3306;root;password;realmd"
Edit whatever else comes to mind but I would suggest testing things out first before editing too much.