[GUIDE] How to make a MaNGOS Server

[Lulzi]

This guide is VERY detailed, and not recommended for people that know absolutely nothing about servers. This is more for people that know a little bit but want to learn more.

[REQUIERD SOFTWARE]
A Windows or Linux Operating System.

A copy of World of Warcraft.

A compiled binary of MaNGOS.

Pre-compiled here or learn to compile your own here.

The "ad.exe" map/DBC extractor.

MySQL

Any MySQL client. SQLyog Community Edition is free and very popular. (SQLyog is what I'll be using here.)

[INSTALLING SQL APPS]

Install MySQL

Launch the MySQL installation application. (Setup.exe)

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

Install SQLyog (or your preferred MySQL tool)

Launch SQLyog installation application. (SQLyog531.exe)

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

[SETUP MANGOS SERVER]

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" folder.)

If you've compiled your own binaries then 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.

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

[EXTRACT CLIENT FILES]

Place 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 "C:\World of Warcraft\DBC" place it in your ManGOS server directory ("C:\MaNGOS"). Note: Sometimes you must create the maps and DBC folder before running ad.exe

So you should now have a "C:\MaNGOS\maps" directory containing numerous (2400+) .map files.

You may now safely delete the directory "C:\World of Warcraft\maps

[INSTALLING THE DATABASE]

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")
Execute. This should only take a moment and you will get a message that it's complete.
Close Dialog.

***CRITICAL***
You have two options when loading the MaNGOS database. You can use a standard empty database that provides table structure and core components only, OR you can install a playable database that includes everything you would need to start playing immediately.

The baseline database is called "mangos.sql" and can be found in your server's "\sql" folder. This database has no NPCs, no monsters, no quests or other data. It ONLY provides the SQL table structure.

For a playable database you need to go to Silver's Database Site and download a FULL database that is compatible with your current MaNGOS binaries. After the downloaded file is extracted it should be at least 40MB and as large as 100MB.

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! When it's complete you will have all the data you need to run MaNGOS.
Close Dialog.

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

Its been a few monthes since I last worked with MaNGOS, so my apologies if anything here is incorrect. Feel free to correct me if needed.

I wrote this myself, but I should give credit to those that have written similar guides on different sites, since I used the same basic format.

[XinuX]

Copy-paste...
[Only registered and activated users can see links. ]
and several other places

[Lulzi]

Didn't copy paste it, and I don't see it on these forums. Get your facts straight please.

I should also add that if you took the time to compare the two, there are quite a few differences. I wrote this myself earlier, so...

[Kuiren]

Lol, almost exact copy + paste from the link provided by XinuX.

Please prove us wrong.

[Lulzi]

First of all, if I had copy pasted that it would look quite different. Secondly, it has a little more detail that I didn't take the time to explain, like vmaps and things like that. I tried to keep it a little bit simpler. If you think it looks close, its because I went with the basic format of making a MaNGOS guide.

Have I proved you wrong yet?

[XinuX]

Originally Posted by Lulzi

Didn't copy paste it, and I don't see it on these forums. Get your facts straight please.

I should also add that if you took the time to compare the two, there are quite a few differences. I wrote this myself earlier, so...

Seriously, don't try to defend yourself...

[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]

[Lulzi]

Um...Gratz...You found guides similar to mine because I used the same format...Also, show me where the guide is ON THIS WEBSITE.

[XinuX]

Originally Posted by Lulzi

First of all, if I had copy pasted that it would look quite different. Secondly, it has a little more detail that I didn't take the time to explain, like vmaps and things like that. I tried to keep it a little bit simpler. If you think it looks close, its because I went with the basic format of making a MaNGOS guide.

Have I proved you wrong yet?

The basic format of a mangos guide is to copy paste?
The other guides are identical to your guide.. how can you think people will believe you?

Originally Posted by Lulzi

Um...Gratz...You found guides similar to mine because I used the same format...Also, show me where the guide is ON THIS WEBSITE.

'used the same format'...?
THEY ARE EXACTLY THE SAME!
it doesn't matter if it isn't on mmowned, if you copy pasted it, say so, don't claim you wrote it.

[Lulzi]

WTF is with you and copy-paste? I'll say it slowly: I. Did. Not. Copy. Paste. This. Guide.

I made it myself, based off what I remembered from when I compiled my server, and did it as I was typing on my computer.

Now, can you please get out of my thread?

EDIT: Still waiting for you to show me where it is on MMOwned. <-- It would be considered a "Repost" if it was on MMOwned. We did not say this was a repost. We said it was a copy+paste.

-Kuiren

[Kuiren]

Compare them. You only added minor words.
I can keep going.

Plus, Mangos Windows Server Setup Guide « actually provided download links, unlike yours. How can someone follow a guide without the downloads? Lol.

[Lulzi]

I figured people were smart enough to use "Google" for their downloads. I'm not here to cater to every whim.

Also, they are similar, which I admit is a little incriminating, like how I used the same type of wording, but still.

[mindlessy]

this thread is brilliant on so many levels.

[XinuX]

Originally Posted by Lulzi

WTF is with you and copy-paste? I'll say it slowly: I. Did. Not. Copy. Paste. This. Guide.

I made it myself, based off what I remembered from when I compiled my server, and did it as I was typing on my computer.

Now, can you please get out of my thread?

EDIT: Still waiting for you to show me where it is on MMOwned.

Are you claiming that the fact that your text is identical with the other guides is a coincidence?

PS: It. Does. Not. Matter. If. It's. Not. Posted. On. MMowned. It's. The. Fact. That. You. Claim. You. Wrote. It. Yourself.

[Lulzi]

Originally Posted by mindlessy

this thread is brilliant on so many levels.

I just wish Kuiren/XinuX would shut up about it...I didn't copy-paste like some idiot troll, but I have no proof since I apparently couldn't have wrote a guide using similar wording and format because thats totally impossible in Kuiren's little world.

[Lulzi]

Originally Posted by XinuX

Are you claiming that the fact that your text is identical with the other guides is a coincidence?

PS: It. Does. Not. Matter. If. It's. Not. Posted. On. MMowned. It's. The. Fact. That. You. Claim. You. Wrote. It. Yourself.

I'll give them credit since my post is similar, but I swear I wrote this myself.