[Guide] How to make a Mangos server.

[The God Father]

Required
- Windows operating system.
- Copy of the client, updated to 2.4.3 ONLY.
- A compiled binary of MaNGOS.
- The "ad.exe" map extractor tool
- A *.dbc extraction tool mpqe.exe and Net Framework
- MySql Community Server
- WinMPQ and Vb4Run.exe Run-Time
- SqlYog


Install SQL Applications

Install MySql
- Launch the MySQL installation application. (Setup.exe)
- When prompted, select "Typical" for setup type. If 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". If you think you may want to execute commands from the command line (ie database updates), place a check in "Include Bin Directory in Windows PATH".
- 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.

Install SqlYog
- Launch the MySQL installation application. (Setup.exe)
- When prompted, select "Typical" for setup type. If 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". If you think you may want to execute commands from the command line (ie database updates), place a check in "Include Bin Directory in Windows PATH".
- 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.


Setup MaNGOS Server Directory
- Create a directory for your MaNGOS installation. For example: "C:\MaNGOS"
- Copy all files from your compiled binary to this MaNGOS directory.
- 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.
- You will 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.
- Make sure to included two .dll files "libeay32.dll", and "libmySQL.dll" and that these are placed in your MaNGOS directory. You will have these files in your release directory.


Extract Client .dbc and map Files

Extract map files
- lace ad.exe into the client's root directory. ("C:\World of Warcraft")
- Create a subdirectory called 'maps'. ("C:\World of Warcraft\maps")
- Launch ad.exe. This will begin the extraction of map files. (This can take a long time depending on your system.)
- When ad.exe has finished, copy the folder "C:\World of Warcraft\maps" and place it in your ManGOS server directory ("C:\MaNGOS"). So you should now have a "C:\MaNGOS\maps" directory containing numerous (3400+) .map files.
- You may now safely delete the directory "C:\World of Warcraft\maps".

Extract *.dbc files (command line version)
- Create a directory for your .dbc files in the MaNGOS server directory. ("C:\MaNGOS\dbc")
- Make sure mpqe is somewhere in your PATH
- Open up your dos command window. (Start->Run, type "cmd" then enter.)
- Change your directory to "C:\World of Warcraft\data\enUS". (type cd "C:\World of Warcraft\data\enUS")
- Type in the following:

mpqe /p locale-enUS.MPQ DBFilesClient*.dbc

- mpqe will now extract the dbc files to a new directory in your client's data\lang directory called ...\enUS\MPQOUT\DBFilesClient. ("C:\World of Warcraft\data\enUS\MPQOUT\DBFilesClient") You should see it reference three files: "patch-enUS-2.MPQ", "patch-enUS.MPQ", and "locale-enUS.MPQ".
- When mpqe has completed, copy the content all of the .dbc files from the output directory listed in the previous step to your server's dbc directory. ("C:\MaNGOS\dbc") You should have 176 .dbc files.
- You may now delete the client output directory ("C:\World of Warcraft\data\MPQOUT") if you wish.

Extract *.dbc files (GUI version)
- Create a directory for your .dbc files in the MaNGOS server directory. ("C:\MaNGOS\dbc")
- Open WinMPQ
- Click "File > Open"
- Browse to "...\World of Warcraft\data\enUS" or "...\World of Warcraft\data\enGB"
- Open "locale-enUS.MPQ"
- Click "MPQ > Extract" and choose ("...\World of Warcraft\data\enU")
- When it finishes, repeat for "patch-enUS.MPQ", and "patch-enUS-2.MPQ"
- Browse to "...\World of Warcraft\data\enUS\DBFilesClient" and move all these files into "C:\MaNGOS\dbc"


Build the Vmap Files
- Vmaps are being utilized to assist with "Line of Sight" issues. Gather up these 6 files, and place them in "C:\MaNGOS\Vmap".
- Find the batch file"makevmaps_SIMPLE.bat" ("C:\MaNGOS\Vmap")
- Double Click. Depending on your system, this step may take quite some time. Alternately you could run "make vmaps.bat" instead, but additional prompts will come up in the process. You may need to rebuild these files more than once. Pay attention to future release notes.
- Move the "C:\MaNGOS\Vmap\vmaps\" directory into the root of the MaNGOS directory ("C:\MaNGOS\vmaps")


Install the Databases

Realmd Database
- 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 Database
- 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.
- When these are complete you will have all the data you need to run MaNGOS.


Configure MaNGOS

Setup your realm
- 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. It CANNOT be the default "MaNGOS".
- For now leave the address to "localhost" or "127.0.0.1". (This will be the same address that your clients must set in their realmlist.wtf files to connect.)
- 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.

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:[list]
- DataDir = "."
- WorldDatabaseInfo = "127.0.0.1;3306;root;[password];mangos"
- LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
- CharacterDatabaseInfo = "127.0.0.1;3306;root;[password];characters"
- Save and close file.

Credits:
Mangosproject
n3013

[unknown1234]

Very nice guide, possible to get a link for ad.exe and MaNGoS binary download?

[tehspook]

are ther any custom vendors on this server??

[The God Father]

No there aint.

[Ollox]

Nice one n3013.