Custom Search
How to Configure MaNGOS the World of Warcraft Emulator
Posted by Reaper-X Apr 19 2007 5:05 pm
Update : You can browse this site software category if you’re looking for my mangos release or my custom mangos release … btw i’d suggest you to get my mangos release first because it has been tested with WoW 2.2.3 and will be updated frequently (even easier than anything written on this old post because i already include everything you need to run your own wow private server except for mysql program of course)
This is the old version of my WoW Private Server Guide, the new version that gives you a detailed step (with images) can be found at below links :
- Installing MySQL
- Setting up the Mangos
- Just in case you want to create lan party
- Setting up the webserver to put registration page
It’s been a while since the last time i post something to my blog and that’s because i’ve been playing World of Warcraft in various private / public server, from WowScape, WowFusion, b3ckswow, etc (i’m switching various server because some of them always disconnect me a lot) …
But let’s keep that aside shall we ? because this time i’ll post a guide on how to setup your own world of warcraft private server using MaNGOS (i’m sure there are many other WoW Emulator out there, but i choose this one instead)
And as a note, currently i’m using the World of Warcraft classic version (1.12.1) and this guide might or might not be useful for you if you’re trying to setup TBC (The Burning Crusade) server
So here’s the step …
Update :
If you find this guide a little bit confusing, maybe you should try reading my new guide on how to create wow private server the easier way .. also to those who’s keep getting SQL error or want the easiest way of importing the sql, i already uploaded my mangos sdb (updated till changeset 156) and already tested to work with Mangos Rev3462
You can find all of the files required (including mangos itself) in my new post .. so be sure to check it out too ;)
Required Software :
- MySQL : This is important because MaNGOS use MySQL as it’s database and currently i’m running the 5.0.xx version
- MaNGOS : Without this you can not run a private server of course but do not forget to get the binary files instead of the source files unless you have Microsoft Visual Studio 2003 ++ installed and want to compile it by yourself (currently i only have MSVC 6 so there’s no way i can compile it, and the Visual Studio 2005 Express version is to large for me to download it)
- Map Extractor (both of them included) :
- Ad.exe : This is used to extract maps files from your World of Warcraft files
- MPQE : This is used to create DBC files which is extracted from WoW games data too
- SDB : This is the database used by MaNGOS and to make your private server playable of course this is a must. And the one you must download first is SDB FULL 0.6.2 including it’s hotfix and it’s update (you must register first)
Note : You can get binary release of Mangos from Mangos-Files.de
New Update :
Im sorry previously i did not upload the changeset 141 till 156 files because i thought everyone can find the changesets files easily (also i do not know if the SDB team allowed me to put that thing here) … but to make thing easier (and that’s the purpose) .. i decided to upload the changesets file here (if it’s not allowed i’ll removed it immediately) :
- SDB Changeset 1.4.1 – 1.5.6 Files for Mangos Revision below or equal to 3462
You must run the sql files in order (eg 141, 142, 143, and so on) and the step to execute this sql script is described in step 5
Optional Software :
- MySQL Client such as Phpmyadmin, etc (although in this example i did not tell you how to use those mysql client) so feel free to use mysql client or not
Special Note :
- If you get an error message saying the maps files is outdated or anything similar to that message from the Mangos Log, that means the Ad.exe you’re using is incompatible (i have experienced this) and i’m pretty sure the Ad.exe you’re using is for the Burning Crusade client so try getting the old version a little bit
- Im currently using Mangos Revision 3459, because the later revision from 3463 and above did not work for me (i have tested it) and i’m sure it was caused because i do not have TBC installed
- Im currently using SDB 0.6.2 and updated till changeset 1.5.6
- And as a reminder, i’m using World of Warcraft Client version 1.12.1
Let’s begin …
I assume you’ve downloaded all the required software and now as for the next step :
Note : If you did not set up password for the root account of your mysql database the default password is blank .. but in this example i’ll write username as username and password as password :P
1. Install MySQL and do not forget to enable InnoDB when prompted also check to make sure MySQL is in the Environment Variable Path … and activate the mysql service if you havent do so or if it is not started yet and you’re done installing MySQL
Note : Setting up environment variable for mysql is necessary to make thing easier, because you can execute it from any location
2. Extract the mangos program you’ve downloaded into your desired location for example, C:\WoW\Mangos
3. Open the Run command (Start -> Run) and type cmd and press enter and you’ll see command prompt window
4. Now type this in the command prompt :
- cd /d C:\WoW\Mangos\sql
- mysql -u username -p -v < create_mysql.sql
- mysql -u username -p -v -D realmd < realmd.sql
Note : Feel free to adjust database name to your liking but in this example i only show you the easiest way of doing it
5. Extract the SDB Full 0.6.2 file, SDB 0.6.2 Hotfix, and SDB Update into desired location, for example C:\WoW\SDB and type this in the command prompt :
- cd /d C:\WoW\SDB
- mysql -u username -p -v -D mangos < SDB_0.6.2_FULL_DB.sql
- mysql -u username -p -v -D mangos < SDB_0.6.2_FULL_DB_HotFix.sql
- and continue with the update by typing the same command with the exception you must change the filename after “<” character
Note : You must update the database according to it’s version number (0.6.2 Full database equal to changelog / revision 1.4.0) so the update you must get is 1.4.1 and above .. as an addition, it might take a while before the full database imported so you can take a break while doing so
And now you’re done setting up database for MaNGOS … and feel free to delete the extracted sdb file
6. Copy the ad.exe into your WoW game directory, for example C:\Program Files\World of Warcraft. And create maps directory in there and run the ad.exe .. and yet another break time :) .. and when this process finished move the maps directory into your desired location, for example C:\WoW\data\maps
7. Now you’ll need to copy MPQE you’ve downloaded earlier into WoW games data directory, for example C:\Program files\World of Warcraft\Data. And now open command prompt again and type this :
- cd /d C:\Program Files\World of Warcraft\Data
- MPQE /p dbc.MPQ DBFilesClient\*.dbc
You’ll see another directory created called MPQOUT inside the data directory. Now go open that directory and rename the DBFilesClient directory to DBC, and move it into C:\WoW\Data\DBC for example
Congratulation, now you’ve finished setting up the data required for mangos
8. Now for the last step you’ll need to open the mangosd.conf inside the mangos directory and edit below lines :
- Change the DataDir = “@MANGOSD_DATA@” into your data location inside the quotes, in this example it would be like this “C:\WoW\data”
Now you’ve finished configuring Mangos and it’s database completely, as for the next step .. try running the mangosd.exe and realmd.exe and see if you can run it without problem or not .. if there’s no problem you can go to the next step (you do not need to close the realmd process and mangosd process)
9. Go to your World of Warcraft game directory and open the realmlist.wtf file using notepad or other text editor program .. and edit it like below :
- set realmlist 127.0.0.1
Now you’ve finished configuring WoW to used your mangos server
10. Now you can connect to your own server, if you want to create new user account you can do so by typing create username password from the mangosd window (it’ll create normal user account). But if you want to create GM account you can do so by typing this from normal command line (type cmd in the run command) and type below lines :
- mysql -u username -p
- USE `realmd`;
- INSERT INTO `account` VALUES (NULL, 'username', 'password', '3', NULL, NULL, NULL, '', CURRENT_TIMESTAMP, '0', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0');
- quit
To get commands for your GM account, you can type : .commands at the chat window inside the game
That’s it you’re finished configuring Mangos and WoW to be played locally :) and here’s some screenshot (please don’t laugh on my equipment because i dont know anything about good items or equipment in WoW and that’s why i choose to play it locally first to learn about WoW) :)
Updated Screenshot :
Trackbacks/Pingbacks
Connect with me
# David
i believe the mangosproject forum have the answer for your question :)
# Johnny
Unfortunately register page doesnt come with mangos by default. But you can of course create it using PHP
or you could also use a simple registration page from Mangos-files.de (look under misc file section)
# pk-kyo
What file you’re looking for pk-kyo ?
i couldnt find the files from mangos, can u find the link for me please?
yo i have done the exact things said but i dont have the sername/address page regerster page etc..that was supposedto come with mangos?
Is there somewhere I can find the details for the character tables data field? Thanks in Advance
# pk-kyo
ah, because you have TBC installed, you’ll need to get newer ad.exe (you can get it from mangosproject forum). The ad.exe in this post can only be used on wow classic 1.12.1 (tested)
# Johnny
well .. if you’re using wow classic you can use the map extractor from here :)
ehh? where did u get the older version of ad.exe?
need help please, i cant use the extractor..says runetime error, and i have BC installed.
i updated the runtime( did download the newer one version) but it still not working, do u think i can use another extractor to make it work?
# Ghost
Actually the steps to make your server public is already explained above your last comment here :)
As for changing the server name basically its just the same like making your server public but this time you just need to change the server name instead of changing the ip address
btw are you using other 3rd party mysql client or not ? if you’re not using 3rd party mysql client i’ll give you the command to change your server name here :)
# Jake
Im sorry if your comments being cut off but i can guess that you’re trying to post forbidden words here and that’s why your comments being cut off :(
btw could you tell me what is the error message you get when you run that command ?
# Ed
did you change the realmlist.wtf in your WoW installation directory into 127.0.0.1 ?
Hey, umm for some reason it keeps sending me to someone elses server. Do you now why?
Thanks!
…why are my comments being cut off?
I am having a problem with step 4 too, but mine is after i put in (C:\MySQL\bin\mysql.exe -u root -D realmd
I am having a problem with step 4 too, but mine is after i put in (mysql -u username -p -v
Thanks Reaper, I finally did figure it out through some trial and error hehe. Everything is good and I was able to make my gm account and login and everything.
My last question is this.. How can I customize the name of the server and how do my friends connect to my private server?
Thanks a ton.
# Ghost
Actually you must type it in new Command Prompt window not the mangosd window :)
# LebaneZ
btw. Do you know REALLY fast server that i could play one? except WoWscape, and WoW-sexy.com ? A 1000mbit server with many players or something like that? Cause me and my friend wanna play together, and the server were playing on now is lagging ping = 100.
Um .. actually i’ve never seen Private / Unofficial wow server with lots of players. Most of the time, i only see 45 – 90 players only. And if i have to compare it with various Ragnarok Online private server that has more than 1000 players online well .. 45 – 90 is still considered low by me lol
Btw if you want to create public server, all you have to do is just edit the realmd database (in this case maybe you should try using MySQL Client such SQLYog or phpmyadmin)
but i never tried using SQLYog though so i cant give you anymore comment about it lol .. but if you just want to use command line here’s the command (someone ask this to me via email previously while this guide age is still 1 day lol and it seems he’s doing fine with his server) ;)
- open command prompt and type :
- mysql -u root
- USE `realmd`;
- UPDATE `realmlist` SET `name` = ‘Your Wow Server Name’, `address` = ‘Your Lan IP Address’ WHERE `id` =1 LIMIT 1 ;
- quit
btw i assume that you havent changed the default root account password and you’re using the same database name as i described here :)
# Yfae
Can u try and host a BC server? I tried it and failed :o if u know how it is done send guide to my e-mail? thanks
Hm .. if i have to host it for public by myself … i cant do it because … i dont have the money to get a dedicated server lol … and if using my internet connection speed, im 100% sure you’ll experience real LAG connection (ping at least 10000 miliseconds) lol
I’m having a problem with all of step 10…
When I type the command to make a GM account into the mangosd window it just gives me an error about mysql….
Hey people, I need some help. I get the 0004331.map problem, it says it doesn’t exist :/ Where can i get that file so my server would work?
Can u try and host a BC server? I tried it and failed :o if u know how it is done send guide to my e-mail? thanks
I dont get a s*** what you talking about reaper-x could you explain in a more detailed way ? :D
btw. Do you know REALLY fast server that i could play one? except WoWscape, and WoW-sexy.com ? A 1000mbit server with many players or something like that? Cause me and my friend wanna play together, and the server were playing on now is lagging ping = 100.
# LebaneZ
Glad it work for you Lebanez :)
and of course its possible to make your server public (LAN only or totally public)
all you have to do is just edit the realmlist table in realmd database (realmd -> realmlist) using sql command or if you prefer to use MySQL Client you can use that too. And set it to your LAN IP Address if you just want to make it accessible from LAN only
or if you want to make it public, you must register with Dynamic DNS Service such as sitelutions, no-ip, dyndns, etc
and set the ip address into your dynamic dns address and configure the realmlist.wtf in your wow directory to use that address or IP
and you’re all set :D
# Dhaka2
Actually there’s no big differences between setting up WoW Classic server and TBC server ;)
all you have to do is download the latest ad.exe , latest MPQE to extract DBC files, Mangos Binary Revision 3463 (3478 recommended), and SDB 0.6.3 (or perhaps SDB 0.6.2 + Hotfix + all changesets available)
Hey, i was looking to make a burning crusade private server, and i havnt ever made a server before and im no expert on computers either lol, can u explain how 2 make a burning crusade priv server for me please?
Hello Reaper-x !!
I did it all, and the server is working fine, THANKS !
My question is just, is it possible to play more than one player on the server? i mean like, can my friend from some other place login on my server and play with me ?
If its a yes, please explain in detailed way – Sorry for bothering !
Ps. It would be cool, if you could contact me by mail.
Best Regards Lebanez xD
# KillMega
glad you found the problem, btw if you’re using TBC client you must get newer ad.exe (perhaps the new MPQE too) .. but if you’re using the WoW 1.12.1 version you can use all of the above files listed here (except for maps, because its too big for me to upload it)
# Dave
Actually im thinking about creating video too but i dont know if i should do it or not, because im sure the resulting video filesize would be big (the fastest upload speed is just 8 kBps)
so im thinking on creating screenshot later, btw could you tell me which step isnt working for you ?
or if you prefer to chat with me directly, i can do it too .. but take a look at my timezone first by clicking here
Never mind, I found the problem. The ad.exe was an old out dated version.
#
Comment by Syl • United States
104 May 4, 2007, 1:05 pm |
Thanks reaper, turns out it wasn’t being enabled under services, tweaked it and it’s running properly now. New problem has came up though. Terrain.mpq and dbc.mpq are both missing so ad will not work, and crashes immediately. Any workarounds for this?
Hey, I am getting the same Terrain.mpq and dbc.mpq problem as him. My game runs perfectly fine, but i cant seem to find these files. Please help if you can.
It doesn’t work for me :’(
Could you create a video of you makeing one and post it here please.
None of it works for me :’(
# Primez
If the error message says it cant find the mangosd.conf , you can extract it again from the mangos revision you’ve downloaded :)
# PepsiG
Glad you can finally able to make your own server (btw if you’re planning to make public server be sure to invite me too) ;)
# Robby
Did you create the mangos database first (by running the create_mysql script)) ? because if you didnt created it first you wont be able to continue
as an addition, if you feel this guide is to confusing, i’ve already posted an another one, which is a lot easier than this one
I’ve got a bit of a problem. I used your guide to get a server running.. Kind of, I used yours and another one.. but, I had my server running last night, everything was working.. Had items, NPCs, quests.. Everything, then I was messing around upgrading to TBC, but when I run the mangosd.exe, the window closes uber fast, but I was able to screenshot an error saying ‘cannot find mangosd.conf’… Any ideas?
On mine it says ERROR 1049 :Unknown Database ‘mangos’ any ideas?
Reaper-X,
I got it now! Yay! Ok, so fo all those of you who are having problems getting your server up on LAN or internet here is what you need to do. As Reaper-X just stated, leave the mangosd.conf and realmd.conf to at 127.0.0.1 instead of changing the IP to your server’s IP.
Then download SQLyog Community Edition 5.30 (Stable) from http://www.webyog.com/en/downloads.php
(The reason you want Community Edition is that it is free and requires no sign in)
Next, Install SQLyog and connect using the following variables: MySQL Host Address ‘localhost’, username ‘root’ and use the same password you set up for ‘root’ in MySQL. Then click connect. [Disclaimer: It has been several days since I installed SQLyog so the login variables may need more info, but once you get in and see mangos and realmd databases on the right under 'root@localhost' you can proceed with this next part which I know works because I just did it yesterday] You should then see some databases such as mangos and realmd. Expand realmd and right-click ‘realmlist’ and select ‘View Data’. Then you should see the server name and IP (probably 127.0.0.1) in the bottom-most right-hand box. Change the server name to whaterver you want, and change the IP to your server IP and check the box. Then make sure you right click the Name box and select ‘Save Changes’ and do the same for the ‘Address’ box. Then close SQLyog and make sure your router is forwarding the necessary ports and you will no longer get the “realmslist loop error” where you select the realm and it brings you back to your realms list.
Thanks again for everyones help! Now that I have a stable server up on my LAN I will try and get started on a TBC version on one of my other (many) computers. Reaper, do you plan on setting up a guide for TBC server? If so let me know and I will help contribute as I troubleshoot my way into setting one up :)
Thanks again to Reaper-X and his excellent guides (and uploads of changesets especially!) and, and to all of you who commented and helped clarify the small details. You helped bring WoW back to those of us who cannot get internet service because we are living in a rural area.
-PepsiG
I tried to change the “127.0.0.1″ in mangosd and realmd to the IP of my server computer but then mangosd and realmd would not run.
ah actually you shouldn’t change the 127.0.0.1 in mangosd and realmd.conf because it’s the IP address (which is a Loopback address) of your own MySQL server
Btw try changing the address back into 127.0.0.1 and try running the Wow again, and if you get the same problem try posting the log :)
Reaper-X,
So I have it up and running, and I opened my ports on my router and I can sign in as a newly created username. But then it gives me the server selection screen (only choice is Reaper-X server) and I select it and click OK. The problem is it just goes right back to the server select screen.
I tried to change the “127.0.0.1″ in mangosd and realmd to the IP of my server computer but then mangosd and realmd would not run.
Any thoughts on what to do?
ok thanks. 1 more small problem now, all the city guards will not give me directions. it just says unknown rather than listing all the things it normally would. and i really appreciate the help
Okay i’ve finished creating the new guide which is more friendlier than this one (hopefully)
# metaltidea
nope still the same with the changesets.
and i got the register page up but when some1 trys to register they get this error
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I’ve tried doing what there website says and setting mysql to work with old passwords but it was to no avail i got the same error if you would like to see the php code let me know
If you get auth error because your client doesnt support new mysql auth try adding this in your my.ini files in your mysql install dir
old-passwords
and dont forget to restart the mysql service by using this command :
1. net stop mysql
2. net start mysql
As for the sql error, dont worry soon i’ll upload the complete database and including anything else required except for maps (because the filesize is really big and my internet connection speed especially the upload speed is slow)
# thomas
did you create the maps directory first before launching the ad.exe ? if you didnt create it first you’ll get that error message ;)
# PepsiG and other that is experiencing sql error
Soon i’ll upload the complete database, DBC files, and the Mangos Server itself (R3462) to make thing easier :)
Just wait for my new post about it ;)
# nord
If your friend can give you a database dump of his mangos server of course you can import it
Reaper-X,
The error I got when I ran 155.sql was:
ERROR 1264 at line 294: Out of range value adjusted for column ‘waittime’ at row 1.
Any idea why I got that error?
I ran all the previous changelogs in order and had no errors until 155.sql, and even 156.sql ran without error after 155.sql errored out.
thanks again!
PepsiG
oklol i might be getting annoying now so lol i figured that before post out butnow theres an even bigger problem
my add.exe wont run in my wow map
-> microsoft visual c++ debugg library
program D program files wow data add.exe
this application has requested to terminate the runtime in an unusual way
shutdown – retry – ignore
ok nvm i figured out i put in root kk lolz
eum but i kinda got another error now i like started step 5 and then i realised i was working on my C:/ instead of D :S and well i cacelled it and now step 5 sais it alrdy excist or smth like that
ERROR 1045 : acces denied for user username @ localhost etc..
what do i do really?
thx already
also when others try to get on to the server it puts them in a realm loop and they cant get on, any idea why?
ok someone i know has a mangos wow server set up, and i have a character on that server. i just set my own server up and was wondering if i could transfer my character from his server to mine. very nice guide by the way.
sorry if this is a dumb question but i was just wondering how i could add some npc’s and a portal i want players to be able to go to gm island and have a elite shop there i already got my guard speek to work (lemme know if u want the scripts) but i cant seem to figure out how to make a portal or a new npc in game
nope still the same with the changesets.
and i got the register page up but when some1 trys to register they get this error
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I’ve tried doing what there website says and setting mysql to work with old passwords but it was to no avail i got the same error if you would like to see the php code let me know
Terrain.mpq and dbc.mpq are missing ? are you sure ? because if those files are missing im sure WoW cant be launched … try looking for both filename directly in your WoW Installation Directory\Data
Thanks reaper, turns out it wasn’t being enabled under services, tweaked it and it’s running properly now. New problem has came up though. Terrain.mpq and dbc.mpq are both missing so ad will not work, and crashes immediately. Any workarounds for this?
# metaltildea
hmm i have PHP 5 and the registration page from magos but I cant seem to figure out how to get apache running or which file to download as the apache site downloads are all in FTP instead of HTTP with no real explanation on how to use it
aah the one you must download is the apache HTTPD server, if the only mirror you get is from FTP, dont worry because basically its just the same (although using different protocol)
as for installing apache, i think it’d be very long if i have to write it here but you can try installing it normally like any other program. And when you’ve finished installing apache try open your browser and type this in the address bar :
http://127.0.0.1 or http://localhost
if you can see it, that means apache succesfully installed on your system
as for integrating php into apache in windows, there are two ways to integrate it
first by loading the php module into apache or run php as cgi
but i’d suggest you to try installing apache first and see if its working and can be accessed or not ;)
o ya i almost forgot i redownloaded the changesets and tried importing them again and got the same error but the game works fine without it
Hm .. that’s strange because i didnt get any errors message at all .. maybe you should try dropping all of the table in the realmd and mangos database first and then reimport it again
as a note, your best bet is to make sure the error message isnt appearing because there will be problem later
# Syl
ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)
Error I get when trying to use the mysql -u username -p -v
Ah .. that problem was caused because you’re trying to use named pipe (this option only available in windows nt series or windows xp) and you havent configured / enabled it in your mysql configuration
to fix the problem try adding below line into the my.ini file in your mysql installation directory
enable-named-pipe
put it inside the [mysqld] section of my.ini
try it first and see if it’s fixed the other error or not
# Yomtom
This is probably a question I missed while skimming over the other comments, and if it was answered I apologize in advance. I’m not very knowledgable on how this works but if I begin taking these steps to make my own mess-around server will I still have access to Blizzard’s official ones? Or would I need to re-update my WoW to their current version as opposed to the 1.12.1 version you use.
basically what makes the differences between accessing the blizzard server and private server is the location of wow server listed in realmlist.wtf in your wow game directory (although im sure its more complex than what im thinking now) .. and thats why you should keep backup copy of your old realmlist / default realmlist (actually if you forget the default realmlist i can tell you the address or just run the patcher)
other than that if you update your wow installation to the latest one im sure there’ll be incompatibilities with mangos .. but maybe i think it best for you to ask this question in mangos forum since most people there already familiar with this kind of stuff :)
This is probably a question I missed while skimming over the other comments, and if it was answered I apologize in advance. I’m not very knowledgable on how this works but if I begin taking these steps to make my own mess-around server will I still have access to Blizzard’s official ones? Or would I need to re-update my WoW to their current version as opposed to the 1.12.1 version you use.
Sorry if this makes little sense, I’m not too good at explaining
create_mysql.sql command. Looked through all 10 pages and didn’t see anything that looked related to my problem, and I couldn’t find anything in MySQL manual. Anyone have the same problem or know how to resolve it? (sorry about the double post, but it cut off and wouldn’t let me edit >.>)