I have noticed that allot of people have problems setting up their MaNGOS Server successfully, Therefore I have decided to write a guide using an in depth step by step system with descriptions to help these people. Now a few things before we begin. This guide works 100% if you follow it exactly step by step as well as using the Tools provided with it. Before we start I would like to mention that with this guide I assume that you have general knowledge of computers and can manage your way around one as well as understand simple PC terms.
I will try and update this guide with the latest working builds as I have time. I am also busy working on the Lan Part of the guide as well as Account Creation Page.
!!! READ The EDIT NOTES at the End before you Continue !!!
So lets get started!
Index:
1). Setting up a Work Space.
2). Necessary Files and Tools.
3). Installing & Configuring MySQL 5.0 with Navicat.
4). Creating Directories & Files.
5). Setting up MaNGOS and Extracting Maps.
6). Creating the Server, Databases and Executing Batch Files.
7). Configuring MaNGOS and Testing Your Server.
8). Creating Accounts.
9). Updating Silver db Database.
10). The End.
1. Setting up a Work Space.
These are just a few odd steps that are not critically important but will help you to set up your server easily as well as follow the guide closely without any problems.
Create a Folder on your desktop and name it ?MangosTemp? Now minimize it so that we can use it later.
2. Necessary File and Tools.
Download all of the following files and place them inside your ?MangosTemp? folder. Now pay close attention to this as it might cause problems later on. I do not host the files my self so when you download a file to your ?MangosTemp? folder you will get a option to name it when you save it. I will provide the names to each download so that you won?t get confused if I refer to a file.
Microsoft .NET Framework Version 2.0 Redistributable Package (x86) ? This is a runtime used by Developer when coding programs. Installing it will improve over all performance of MaNGOS. While it might not be 100% necessary I Strongly recommend it.
DOWNLOAD -
MySQL 5.0 ? This is the Database you will be using for MaNGOS (You can download a newer version if available but this one is more than sufficient)
DONWLOAD -
Navicat Trial ? This is the GUi for MySQL (Note: This is just a 30 day trial)
DOWNLOAD -
Map Extractor ? This tool is pretty self explanatory, It extracts the WxW Maps
!!! IMPORTANT NOTE !!! This tool is not compatible with the 1.12.1 Client but it is the only thing that can currently extract the maps
DOWNLOAD -
SVN Tortoise ? This is a shell extension that allows you to update Database files by simply right clicking on the folder and entering the repository url for the update, patch or download
DOWNLOAD -
Confirm & Update WxW Client ? You have to update WxW to v1.12.1.5875 if it is not already updated. You can grab all the updates from FilePlanet whom host it for basically all the Language versions as well as options to grab the full patch or the incremental one. This requires a once off free registration but is well worth the effort.
MaNGOS Rev 2458 & ScriptDev 131 ? This is MaNGOS, This is why you want this guide:-P
Hint: Save this file as ?MaNGOS Rev 2458 & ScriptDev 131? in your ?MangosTemp? Folder
DBC 1.12.1 ? This is the DBC files for MaNGOS
Hint: Save this file as ?DBC 1.12.1 Full? in your ?MangosTemp? Folder
Silver DB 0.5.0 Full ? This is the Silver DataBase for MaNGOS that we are going to use.
Hint: Save this file as ?Silver DB 0.5.0 Full in your ?MangosTemp? Folder
Silver DB 0.5.1 SVN Patch ? This is the Silver DB Update Patch downloadable through SVN. You need SVN Tortoise for this.
This is a Repository URL so you cant download it now. I will show you later how this works.
This concludes all the files that you will need to continue. Once you have all these files in your ?MangosTemp? Folder we can continue.
3. Installing & Configuring MySQL 5.0 with Navicat.
Now we haveto install MySQL 5.0 and Navicat. Go to your ?MangosTemp? folder and select MySQL 5.0
Bellow is 11 Visual Steps if the ones in the guide is not clear.
[VISUAL INSTALLATION for MySQL 5.0]
1. Start the MySQL 5.0 and click next
2. Choose the ?Typical? Installation
3. Skip SignUp Registration
4. At the next screen Tick ?Configure the My SQL Server Now? and continue
5. Choose ?Standard Configuration? and continue
6. At the next screen Tick Install as Windows Service and Launch the MySQL Server automatically. In the drop down list just select the default MySQL and continue.
7. At the next screen Tick ?Modify Security Settings? Now this is another important part! Enter a strong password here for your Server and make sure you save this password exactly the way you enter it so that you can use it later inside MaNGOS. I will refer to this password as ?The Root Password? from now on. (If someone gets this password then they can basically take over your server) Now continue
8. At this screen you have to execute your server. If you have a firewall installed then it might block your server and result in it nor configuring properly. Take great care and make sure you give MySQL full access. When you are ready click on Execute
9. You should now have a screen where the 4 circles are ticked with blue ticks and a message like this:
Configuration File Created.
Windows service MySQL Installed.
Service Started Successfully.
Security Settings Applied.
Press [Finnish] to close Wizard.
And with that MySQL 5.0 is successfully installed and started. Go to your ?MangosTemp? Folder and locate the Navicat Trial Installer. Now run it and install Navicat Trial.
4. Creating Directories & Files.
Now we have to prep the Directories and get them ready.
So first of go to your computers Root Drive and create a new folder called ?mangos? in your root drive
(The Root hard drive is normaly the C drive in My Computer) either way you do this by going to:
Start > My Computer > Local Disk (C
New Folder > mangos
So now you have a folder called mangos on your root drive and it looks like this? ?C:\mangos?
Now go to ?MangosTemp? and locate and extract ?DBC 1.12.1 Full.zip? to C:\mangos
Inside ?C:\mangos? create two new folders. Name the one ?maps? and the other ?data? so that you have this:
?C:\mangos\data?
?C:\mangos\maps?
So now your have these three folders inside C:\mangos:
data
dbc
maps
Now go to your WxW Installation Directory and open the data folder. (Default Path is: C:\Program Files\WxW\Data) Inside the WxW Data folder locate and ?copy? the
following 4 files:
dbc.MPQ
patch.MPQ
patch-2.mpq
terrain.MPQ
and paste them inside C:\mangos\data
Inside C:\mangos\data rename the following files:
Rename ?patch-2.MPQ? to "patch-2.MPQX"
Rename ?terrain.MPQ? to "patch-2.MPQ"
5. Setting up MaNGOS and Extracting Maps.
Go to your ?MangosTemp? Folder and locate ?MaNGOS Rev 2458 & ScriptDev 131.rar? and extract it to your C:\mangos folder. Now go back to your ?MangosTemp? Folder and extract ?Map Extractor.rar? to your C:\mangos folder.
Inside C:\mangos create a new folder and call it ?DB? then go to ?MangosTemp? and locate and extract ?Silver DB 0.5.0 Full.rar? to C:\mangos\DB
Now this part is tricky and I cannot guarantee that it will work. Like I said earlier, the map extractor is not for 1.12.1 but we got to use it so let?s get on with it. Inside your C:\mangos folder will be a file called ?ad.exe? this is the map extractor so click on it and hit enter. It will open a command line console and start to extract the maps. This process takes a long time depending on your machine. It can take up to 20 minutes before it even looks like it is extracting anything so go grab a cup of tea or juice or whatever it is you consume in unhealthy doses like me:-P When you come back you might notice two errors in the window. They should look like mine in the picture bellow:
You can ignore these two errors and continue. When the map extractor is finished it will close by itself or show that it has completed successfully or?. Give nasty errors. If you get nasty errors you will have to download the maps. I don?t have a link for a full set of maps yet so ask around on the forum.
Go to your C:\mangos\maps folder and check how many maps you have. You should have 2352 maps. If not you will have to download them all like I said above.
6. Creating the Server, Databases and Executing Batch Files.
Now we have to create the server and execute the batch files for it. Start Navicat and follow these steps:
Create a new connection:=
1. File>New Connection
Connection Name: wow
Host Name/IP Adress: localhost
Port: 3306
Username: root
Password: ?Enter The Root Password Here? ? same one that u entered in MySQL 5.0
Make sure you have ticked the save password tickbox and press ok (check bellow for Visual Ref)
Now click on ?wow? to start it then: Right click in the left hand pane and select ?New database? from the list and name it ?mangos? Right click in the left hand pane again and select ?New database? from the list and name it ?realmd?
Now that we have the 2 databases we can execute the batch files to complete the database.
Right click on ?realmd? and then ?Execute Batch File?? browse to your C:\mangos\sql folder and select realmd.sql and execute it. When it is done it will tell you:
[MSG] Finished ? xxxxxxxx queries executed successfully.
Click close and right click on ?mangos? and then ?Execute Batch File?? browse to your C:\mangos\DB folder and select 050.sql and execute it. This takes a long time and is resource intence so leave your pc and make sure that screensaver don?t pop up. It takes between 20 ? 60 minutes. When it is done it will tel you:
[MSG] Finished ? xxxxxxxx queries executed successfully.
By now you should know how to Execute these batch files so,
Right click on ?mangos? and then ?Execute Batch File?? again.
Browse to ?C:\mangos\sql\updates? and locate and execute all of these:
(one at a time )
?2383_auctionhouse_item.sql?
?2418_quest_template.sql?
?2421_quest_template.sql?
?2424_gameobject_template.sql?
?2429_taxi.sql?
Remember to execute them into ?mangos? and not ?realmd?
7. Configuring MaNGOS and Testing Your Server.
We are almost done now so hold out! Go to your C:\mangos directory and open ?mangosd.conf? with wordpad. Loof for the following line: Tip: press ctrl+f in wordpad & notepad to search for single lines
DataDir = "@MANGOSD_DATA@"
and change it to
DataDir = "."
Then look for:
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
And change it to:
LoginDatabaseInfo = "127.0.0.1;3306;root;The Root Password;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root The Root Password;mangos"
Then save and close it and open:
?realmd.conf? with wordpad and change the following lines:
"127.0.0.1;3306;mangos;mangos;realmd"
To:
"127.0.0.1;3306;root;The Root Password;realmd"
Save and close.
Now go to your WoW Install Directory C:\Program Files\World of Warcraft and open:
?realmlist.wtf? with notepad and change ?set realmlist official blizzard server?
To:
set realmlist 127.0.0.1
Save and close it then open Navicat and click on ?realmd?
In the right hand pane double click on ?realmlist?
This is where you can change the name of your Realm to what ever you want it to be. For now just give it a name and close the window.
Finally we are done. Go to ?C:\mangos? and double click on:
?realmd.exe? and then on ?mangosd.exe? wait for ?mangosd.exe to load your server. When you hear you pc beep then it is done. Both these two windows should stay open by it self so just minimize them and???
Launch World Of Warcraft!
For now just use these details to test your server:
Login: administrator
Password: administrator
If you get a message ?Disconnected From Server? then you might have typed your Login or Pass wrong.
8. Creating Accounts.
So now your server is running and you would like to create your own decent personal account. Or some accounts for your friends. Right open Navicat and click on ?wow? then click on ?realmd? and double click on accounts in the right hand pane to open it. Now just follow the simple steps in the picture bellow.
9. Updating Silver db Database.
Now you want to update your Database with the latest revision to fix whatever bugs there is and to bring you that little bit closer to the blizz experience.
Go to your ?MangosTemp? folder and select and install ?SVN Tortoise? when it is done installing it will ask you to restart your PC. I suggest you restart as it has to be integrated into the windows shell.
Right so now you are back after your frisky restart. Browse to your C:\mangos folder and right click on the ?DB? folder. Then click on ?SVN checkout?? Now copy this url:
and paste it into the ?URL of repository? space of the window. And continue. If it tunes you something about the folder not being empty and what not just go ahead and tune it to update. When it is done open your C:\mangos\DB folder and you will see that it is now filled with files.
Now open Navicat, click on ?wow? and right click on ?mangos? then ?Execute Batch File?? and browse to C:\mangos\DB
Execute all the batch files in this folder one at a time EXCEPT FOR ?050.sql? Do not execute it again. Execute the files starting with numbers last. And in this order:
2418_quest_template.sql
2421_quest_template.sql
2424_gameobject_template.sql
2429_taxi.sql
It helps if your sort the files by name to execute them in the right order and to avoid errors.
And with this your Server is fully updated again and you are ready to play.
10. The End.
Thank You for using my guide to set up your server. Please bear in mind that MaNGOS is still in it?s alpha phase so you might get allot of problems in game, However the Dev Team behind MaNGOS is doing a great job with this project so you can except regular updates to fix the problems.
This document is Copyrighted! Please don?t copy, clone, shadow, cut & paste or use any devious means to steal it. This guide is for Hacking Source ONLY! And is not allowed to be posted on any other forums, or websites, ect. Please support Hacking Source by giving this link to your friends and ask them to please vote for Hacking Source to keep this community alive and strong with support.
Thank you for your Understanding.
Kind Regards.
The.Unforgiven1
[EDIT NOTES]
These are random issues that came up after I wrote this guide:
This guide works on 1.12.1 and is compatible with 1.12.2, however I have not tested it on 1.12.2 as I am running 1.12.1 for the sake of this guides support. I cannot guarentee it to work on 1.12.2 but the Revisions do support it.
I Also forgot to mention that you should back up your C:\mangos\maps folder if so that you can use it in the future without needing to extract the maps again.
Please back up your WoW Installation Directory if you have the space Incase something goes sideways.
I Fixed the map extractor link. It is now working again. Sorry about the inconvenience. The Lan setup will come soon, running a bit tight. Changed guide to rev 2458 & ScriptDev 131. I will add the anti cheat soon still checking if it is working. Have Fun
Tortoise Link Is Fixed Sorry about that. I am not updating the revisions onthis guide until I find a stable version for use Please stick to these until a Stable one emerge.
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
I am not taking credit over this guide!
I wont answer any question regarding it!
Original post by The.Unforgiven1 @T Hacking Source Forum
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////