Custom Search
Creating WoW Private Server the easier way (perhaps)
Posted by Reaper-X May 5 2007 12:27 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)
Or you can also look at the recent software section located at the footer section of this website to see the new update to my mangos release :)
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
Maybe my previous post about creating WoW private server is a little bit confusing for some people and that’s why i create another post on how to set up world of warcraft private server once again but this time … i promise it is not going to be confusing like before :D … and actually i should be thanking everyone who put comments on my previous post, because of their comments i was able to get new topics for my blog … hahaha
Okay and that’s all on the introduction part … now let’s start the guide, but before that please keep this in mind, this guide tested with 1.12.1 World of Warcraft Client (known as WoW Classic) non modified in any part and tested to work with Mangos Revision 3462, but this guide can also be used if you’re going to create The Burning Crusade server although you’ll need to get different database dump from someone else, and of course getting the newer mangos release :
Required Software
1. Mangos Revision 3462 : The mangos release is compiled by Maxi and this release also include the following patches :
- ScriptDev2 R34
- Honor 0.71
- MCH 1.5c
And just like i said to make thing easier, i upload this mangos release (just in case Maxi reading this, and he does not want me to upload his file here … let me know immediately so i can remove it … because i already forgot where i get his release) .. i think it is from his userbeam / beam something folder
2. Complete SDB with Changesets 156 : Because there’re problem for some people when importing each changeset, i decided to release the SDB used by me … and this SDB updated till changesets 156
But i also include, the create database, and realmd database to make thing even easier
3. MySQL : Essential program, the above 2 files can not be used if you dont have this installed :)
4. Map & DBC Extractor : This is tested to work with World of Warcraft Client version 1.12.1 and Mangos Revision 3459 and Revision 3462 only
But just as i said before, to make thing simpler. I’ve uploaded the DBC Files (maps not included because the file size is bigger than i thought, and my connection speed is nothing compared to all of you) .. and that means all you have to do is just using the ad.exe / map extractor to extract the WoW Maps
Mirror to download the above files if you’re having problem with Megaupload :
Complete SDB Dump for Mangos 3462 WoW ClassicMangos 3462 by MaxiWorld of Warcraft 1.12.1 DBC Files
Let’s Start
I assume you’ve already downloaded the required software and already installed it (for more in-depth WoW Mangos installation please refer to my previous post)
1. Install the MySQL Software and configure it accordingly, in this example MySQL installed in C:\MySQL and using the default root password which is blank
2. Extract the Complete Database file somewhere in your harddisk, and you’ll see there’re 3 files :
- create-database.sql
- realm-database-full.sql
- mangos-full-for-rev3462.sql
Run it by using this command (this time i make sure to use the default path instead of using command which is already set in environment variable path) from Start Menu => Run => cmd (this cmd can only be used in Windows XP) or command (Win9x) => and change to the extracted directory :)
- C:\MySQL\bin\mysql.exe -u root < create-database.sql
- C:\MySQL\bin\mysql.exe -u root -D realmd < realm-database-full.sql
- C:\MySQL\bin\mysql.exe -u root -D mangos < mangos-full-for-rev3462.sql
Note : The create database will also drop your realmd and mangos database if it is found .. i do this in order to make thing easier (how many times did i say this words in this post) lol
Yet another Note : Extract the database into the same path where your MySQL bin located, or if you already extracted it somewhere adjust the path like below for example :
C:\MySQL\bin\mysql.exe -u root < X:\where_SDB_extracted\create-database.sql
3. Put the downloaded DBC Directory somewhere, in this example C:\WoW\Data\DBC
4. Copy the ad.exe into your WoW installation directory also create directory called maps and run it .. and wait till finished and move the maps directory into C:\WoW\Data\maps
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
DataDir = “C:/WoW/Data”
If you’re using the example path given in this guide, you can use the above datadir configuration
6. Run the mangosd.exe and realmd.exe …. and you’re finished :D configuring the server
7.I’m sorry i forgot to write the last step in this post (thanks to GreekSoul). Now since you’ve finished configuring the server all you have to do now is configuring the client (WoW game) to connect to your server instead of using the default / official server. And it can be done by open the realmlist.wtf in your WoW Game directory and change the realmlist into 127.0.0.1 … and you’re all set
Common Question
I create this part thanks to all the commenters before … especially to metaltildea, PepsiG, Xtonic, luke, Venomz, etc
Q : hay me again it works but the CMD thing it says that the thing u wrote up dosnt exist on the second time
so it wont make the directory :(
A : If you tried to run the mysql command directly without setting it to use the env. variable path, you’ll get that error message … also CMD only work in Windows 2K (correct me if i’m wrong because i already forget about it) and Windows XP (guaranteed to work)
Q : I forget about the signs that dont let me post it.. ERROR 1045 (28000): Access denied for user `username @ localhost` (using password: NO)
A : That error message means, you’re trying to use wrong password for a username, username does not exist, etc .. but in this case, you’re trying to use non existent username (because it was an example)
Q : ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)
A : If you’re trying to use named pipe (this mysql feature only can only be used on NT series such as Windows XP) and you havent configured mysql to do so .. you’ll get that message … to fix it you just have to put below line into you my.ini file (do not forget to restart the mysql service after you done)
enable-named-pipe
Q : Can i import the official data from Blizzard server into my mangos server ?
A : The answer is no, because … blizzard is using different server software which is not available to public .. and no one have access to their server :P ..
Q : my add.exe wont run in my wow map
A : Did you create the maps folder first ? if you did not create it you’ll get an error message. Also you’ll need to run it in your root directory of your WoW installation directory
Q : I can’t run ad.exe or MPQE
A : Im sure there’re missing runtime in your windows system, try downloading and installing below 2 files first and see if it’s fixes the problem or not
- Microsoft .NET 2 Runtime
- Microsoft Visual C++ 2005 Redistributable Package
Q : ERROR 1264 at line 294: Out of range value adjusted for column ‘waittime’ at row 1
A : You’re trying to insert value higher than the allowed value specified in your mysql table … but in this case, this error message seems strange, because i have no problem importing the SDB files including it’s changesets … and that’s why i create this post and upload my database dump :)
Q : I want to be a GM in my mangos server
A : Look at the step #10 in my in-depth explanation on setting up mangos server (do not copy paste the text directly because it’ll give you error message) … and if you get other error message just leave comment here :)
Q : What are the GM Commands ?
A : After making your account to be a GM account, type this ingame .commands and you’ll see available commands to use
Q : My friends can’t connect to my server ?
A : Try checking your configuration especially at port configuration, and make sure there’s no conflict
Okay that’s all for now … i’ll be sure to update this post / create new post if i found something new from you :)
Trackbacks/Pingbacks
Connect with me
HI I made the server !!! :D I got and idea to use SQLyog and it works like a charm . If some one is having troble importing realmd.sql use SQLyog . Thanks alot gays for your help and specialy Reper-X and JeremiahMan TNX gays !
and some can some body tell me the teleport comands ( go origmar strongwindcity ) or were to see the coordinates ???
and one more thing were is GM Island ??? bye :D
# Everyone
I just finished creating the new guide (two part already finished) and this time with images (based on request) on almost every step and you can find it from :
- First part about mysql installation
- and the second part about configuring mangos itself
didnt do full comment so can u email me or something…… cause i really just want to host a lan server with my friends when we lan party. Furco3@yahoo.com
im plain out retarded or something, cause i do not get this at all…step 2 i have no idea what to type in cmd i try C:\MySQL\bin\mysql.exe -u root
uhm i have a private wow server and the npcs wont teach me how to wear mail is there n e way to get a round it if so u can email me at sin623@gmail.com
ok, so anyone know where i can install the newest version of mangos?
Hi
Ive read about PepsiG’s sullotion to how to stop the loop in the login phase, but it just dont seem to work for me?
anything else i can to to make it stop?
Woodrick
Hello
Well … first of all if you use sdb from this site for TBC server it wont work because you’ll need recent version of mangos TBC server
but that error message got nothing to do with mangos itself even for the recent version because the realmd database wasnt successfuly imported
to correct this you need to use this command (from command prompt) :
mysql -u root -p -v -D realmd < realm-database-full.sql
to import the realmd sql file into Realmd database
Oks but wath to do with realmd.exe .
Reaper-X I you can send me screen shots wath i need to do PLS email : big_bos_@abv.bg
PLZ SET ALL OF THIS FOR DOWNLOAD
Yea now that i know what version, I have been trying to find a link somewhere to show me where to download it, anyone know one?
ow ok i c yea V2.7? rite. Thankyou. Appreciate the help ;)
# Bigbos
Im in progress of creating new guide but this time with screenshot of all progress :)
as for TBC … basically the setup process is still the same as creating non TBC (setting up mysql, etc), with the only differences :
1. You need to get Mangos revision above 3462
2. You need to get SDB (Database) above 0.6.2
that’s it ;)
# maker103
Well .. if you’re running tbc server (mangos), try downloading their newest release with the latest SDB
HELP :( !!!
and some body know a TBC guide ??? link or some thing
hey, yea i saw you know alot about private servers lol, i hope u can help me for a little bit.
I made my own private server now, but it has many bugs.
I am wondering how do i fix things like, profession trainers not being able to train you or class trainers and things like that. Plus over that bug It wont even tell me how much money i have when I click on my backpack :( I have also seen many people put custom vendors and and so on…. Hope its possible to communicate with me somehow on this matter.
Btw sorry i am such a noob at this and stuff like that. I hope you can help me though.
hi man…. i was wondering do u have msn?
2007-06-25 18:47:33 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-25 18:47:33 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-06-25 18:47:33 ERROR:query ERROR: Table ‘realmd.realmlist’ doesn’t exist
2007-06-25 18:47:33 ERROR:No valid realms specified.
I HAVE 3 FAILS CompleteSDB156-Mangos3462.rar
and for 3 and 2 there is D-mangosd or some thing
this means import raght ??? I import first CREATE DATABASE – secound REALMD DATABASE – third MANGOS DATA BASE Is this corect
C:\MySQL\bin\mysql.exe -u root
# Bigbos
as i said before you didnt import the realmd sql, you need to import that file first or you wont be able to run the realmd process successfuly ;)
btw which database version you’re using and where did you get it ? i ask this because lots of people asking me via email that they’re using wow mangos downloaded from torrent and not downloaded it from mangos website or sdb website
as a note, mangos release already included the realmd sql that need to be imported although you’ll need the SDB for a fully working mangos server
that’s it ;)
OPs i didnt create a acount it say thath mysql is at difrent version or somnting help !!!
2007-06-24 19:49:53 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-24 19:49:53 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-06-24 19:49:53 ERROR:query ERROR: Table ‘realmd.realmlist’ doesn’t exist
2007-06-24 19:49:53 ERROR:No valid realms specified.
HELP I CREATED A ACOUNT BUT CANT START THE SERVER REALMS CLOUSES HELP
HELP my surver is done i cant create a acount wen i type in mangosd.exe they are ssome zepplin test and boots that keep coming back
and wen this types new line ???????
and also realmd.exe is clousing how to fix ???
See the screen shot with the datadir its corect ??? :|
thnx JeremiahMan
i hav updated game to 1.12.1 nw n tried to logging with created user name n password
i was able to pass from there successfully, after tat i gt to select realm n type of play i did tat too pass from there too
next comes to connect to server bt from there i cannot connect,
i chnged realmlist 127.0.0.1 to my lan ip still no hope, this hapend wen creatin server usin uwc 134 also,after doin evrythng correctly and at last joinin server does nt work, i dont knw wats wrong any help regardin this wud b really gud
thnx in advance
Josh Mash Make sure on your mangosd.conf you put the right directory
DataDir = “@MANGOSD_DATA@” Put where ever your Wow data dir is for example C:\world of warcraft\data And dont put the ” ” it will put them in for you when you reopen the mangosd.conf
Comment by ibbeywoox
You need to make sure your using all the files from here, Also make sure you have game version 1.12.1 It will not work if you dont have the right game version. Also you might want to uninstall Mysql and start from scratch before redoing.
Johnson Reinstall Mysql, and dont use a password when you set it up Make sure you delete the folder of mysql after you uninstall it, before you reinstall It.
It keeps saying “ACCESS DENIED” when I am entering the correct password and commands
JeremiahMan I send you screen shots check your email . :)
hi all n esp reaper X
the guide has been of real gud help for me,i tend to do all the steps told by the guide bt i end in nt able to loggin, the error unable to validate the game, the thing here is i hav been tryin to create a server usin uwc 134 bt didnt succeed with it,
did a search n found this guide,
i did evrythng as it says,
i’m usin sdb 062 full n fix n sdb set from 141-156
bt the version of the game is 1.9.2 n i did a hack patch of 1.9.2 also so tat i cud try usin uwc 134 version,
i’m tryin to use the game in lan,
i hav a wifi router n if there is a different settin for wifi cud u pls mail me or explain it in here,
by the way this is my 1st time creatin server or any kinda database,if this helps i’, usin windows vista ultimate
thnks in advance
Yo, im having the same prob as paladin way up their ^. my application files do also close after about 2 seconds and i just wondered wot id done wrong?
btw for all that want/need it. i have an updated database for 2.1.1 very few bugs but there’re still some. :\
email:
xearokk@yahoo.com
also Take a few srcreen shots of you typing in mysql commands inside the cmd line
Hmmm… To better help you out ,Send me a screen shot (Right click on my computer go to explore, Then go to where ever Mangosd.conf is and then open it up and send me a screen shot of the whole screen Jeremy@alliancelaser.net
2007-06-21 16:50:11 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-06-21 16:50:11 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-21 16:50:11 Realm running as realm ID 1
2007-06-21 16:50:11 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = ‘1′
2007-06-21 16:50:11 ERROR:SQL ERROR: Table ‘realmd.account’ doesn’t exist
2007-06-21 16:50:11 Using DataDir @MANGOSD_DATA@/
2007-06-21 16:50:11 ERROR:Check existing of map file ‘@MANGOSD_DATA@/maps/0004331.map’: not exist!
2007-06-21 16:50:11 ERROR:Correct *.map files not found in path ‘@MANGOSD_DATA@/maps’. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
I maked the server again , see the erors
oks will try
BigBos Try uninstalling Mysql and getting ride of The Db files and mangos ( START FROM SCRATCH) you should have some luck doing that.
LOOK REAPER I AM A IDIOT :p I DONT UNDERSTAND WATH TO DO !!!
WATH MEANS ( IMPORT ) ??? AND HOW TO (adjusting the database name from the mangosd.conf) ??? CAN YOU EXPLANE PLS
:d :D :d ;d
OKS I WILL TRAY :)
First of all i’d like to say many thanks to jeremiah for helping me :)
and sorry i cant reply yesterday because of blackout and lots of thunder near where i live :(
# BIGBOS (comment 198)
that error message means :
you didnt import the realmd database into your sql, or if you’re using different database name for the realmd, try adjusting the database name from the mangosd.conf
and thats why it says the mangosd process cant find realmd database
# Xearo
if you intend to create public server or want to make registration page so your friends can register to your wow server, you need to install PHP with Apache
and then to make thing simpler, you can download simple registration page for mangos (i think there’s a good one at mangos website, although i havent tested it)
Reaper HELP !!! :)
Hey reaper. I got the server up and running for 2.1.1 =) But now i can’t figure out how to make more accounts for other to play -_-
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-noinstall-5.0.41-win32.zip/from/http://mysql.online.bg/
enjoy ;)
When I Try to Extract MySQL there is an Error i think i download a Wrong one. Can you send me a Link to MySQL Windows XP Setup ?
nop I checked Datadir is corect