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
I cannot get this to work at all. I’m stuck at the step where you tell it to:
C:\MySQL\bin\mysql.exe -u root
where do i get wow version client 1.12.1 ??? plzzz, plzzz help !!! i downloaded all what i need to make an server but i still need wow 1.12.1!!! anyone help me, huh ?
Johnathan, this is either a firewall issue or a player issue when it comes to connecting.
Firewall: Make sure people can cannot TO your computer
Player: They can simply click cancel and try again. It’s literally that simple.
As for your Bloodelf and Draenei make sure your server is running Burning Crusade and that their accounts are set for TBC.
Ryan, to answer your question, most people will not create servers that are up and trying to gain population here (from my knowledge, neither Jeremiah nor ReaperX have a full-time-server but i could be wrong and plus: GM status is usually only given to people the main GM knows they can trust 100%
hey guys caould i join one of ur servers and be a gm i have tryed to make my own but i just cant do it plz. thanks for reading this message^^
Players can’t connect to my server , they keep stuck with ‘Connected’ , they know what realm i have … but can’t connect…
Also, I cant’ make a bloodelf nor a draenei on their account :D please help me m8
And as if i didn’t add enough to say, should i be correct on the post above everything works but the ad.exe
Debug Error!
Program: C:\Program Files\WoW\ad.exe
THis application has requested the Runtime to terminate it in an unusual way. Please contact the application’s support team for more infomation.
Well i got everything ok. the only thing left is when i type the thing into the cmd
the -u root thing.
it just moves to the next line and the name of the window changes to:
C:\Windows\system32\cmd.exe -mysql.exe -u root
then it goes to the next line down from the -u root command and has an underscore… i cannot type anything at all. only thing i can do is close it. does that mean it worked, if so why was that important?
# Jeremiah
Thank you very much for helping me Jeremiah … i really appreciate it :D
Sorry for late reply, because my body hasnt fully recovered because of Vertigo (Dizziness) :(
# Xearo
Put it in your wow game directory and dont forget to create folder / directory called maps first or you’l get an error message
# KoolT4
Actually you dont need hacked / cracked copy, all you need is just set up mangos server, edit the realmlist table ip address to use your lan ip and then configure each client to connect to the ip server used on the realmlist table :)
# paladin112
Paladin if the mangos / realmd process as soon as you started it, try looking at the server.log in your mangos directory
-=+Update+=-
I know i’ve asked 1000000 questions bear with me almost done.
where exactly do you put the ad.exe?
WOW!, the cmd took the command finally. is it supposed to just sit there and move to the next line?
Ex:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql.exe -u root
Do other people have to have thier own copy or can everyone just copy the hacked version to be able to play on a LAN private server
i cant create an private server. mangosd and realmd close in 1 sec. cant create account on sql. just nothing what i need works
http://www.wowstatus.net/serverlist_c_up.php go here paladin if you want to get on an open server. Pretty self explanotory
can’t one of you just make an server where u let everybody be an GM. that should be much fun :).
if one of u is creating one, plz let me join.
;)
Hey Context That’s because your using the wrong version of mangos. That version works for only 1.12.1 WoW Classic version If you want to run TBC 2.1.1 You need to get a diffrent version of mangos , Maps.(ad.exe) and The Sdb files. you can find them here http://www.mangosproject.org
Ok, after reading all of this, and messing around with my setup, I have mangos running (i can see it moving the zeps and boats and things of that nature), and realmd starts up fine.
The problem that I’m having is I cannot log in. As ambiguous as that is, all it tells me is that the version i am running cannot be validated. I am using Mangos v3462 and Running WoW BC 2.1.1.
I’m n00bish enough with SQL, but not too n00bish to figure out from reading all the posts and searching thousands of other forums that I need to have at least Mangos v3463 or later to support TBC. I am confident enough that I can figure it out from there, but I cannot find >= v3463 alone. I’d rather not download the unecessary 280mb packages available. I just need a link to where I can d’load the version of Mangos that supports TBC. Please help!
Jeremiah do you have yours setup? is there a way to send it to me or at least screen shot it so i know what it looks like?
email em: xearokk@yahoo.com
ps: i know you’re at work respond asap.
Now it’s saying system cannot find the file specified after i typed in command. prehaps i miss did a step?
MySQL —> Local Disk C:\
All the files —>My documents
Leaving work now Be back at 7 Am In morning
Is your using Vista Xearo befor opening the cmd Right click on it and run as Administrator
Oh yea to change the command Type this in the cmd window CD C:\
Are you using SDB files from this forum for black storm? If you are I belive they are only designed for Mangos I dont know to much about black storm But, Ill do some research on it.
Jeremiah i’m using something called BlackStorm V1 (which literally just does the exact same thing just does it automatically) It uses only one cmd. should I just manually do it? If so, the cmd from windows always starts off in
C:\Documents and Settings\Xearo\>
everytime i type commands from above it just says that’s not a valid command.
Paladin did you open the 3 sql files with the Sql.exe from your command prompt
If you want to talk on aim my name is weedseednine
magnosd and realmd close in 1 sec. thats not good. and when i create and account on sql it give like 4000 errors.
Darkspw TBC will work with a newer version of mangos. Scroll up on the forum it will tell you how to do it.
Xearo – Hmm are both programs open (The mangos Cmd Window, And the Realm CmdWindow. Both need to stay open while you play. If they are open what username and password are you using. Try using gamemaster for the username and gamemaster for the password let me know
!
Hey. Thanks for the help by the way. But one last thing.
Everytime i try to connect using my info it simply disconnects me. i check the cmd and it says it connected and approved but then disconnect me.
I was wonder on how to build a private lan server for wow and i can across your site here and i was wondering if TBC exp would work with this.
ATTN: If you dont want to go through the steps of setting up an account on mangos, on your log in screen then for user name type in Gamemaster
and Gamemaster for your password. Once you create your charcter Type in .gmon and you will become a Gm. Once Gm is turned on you can type .com to see a list of commands you can do.
If you need any help with anything email me Jeremy@alliancelaser.net
Xearo IF your having trouble with your command just put in>>>>> CD C:\ (where ever you have mysql installed)>>>>> EX: C:\Program files\mysql\mysql 5.0\bin
Or if you have mysql set up to run in command just type in mysql. If your running vista I prefere you do it like this though C:\Program files\mysql\mysql 5.0\bin
Hi, this is amazing content, I was wondering if this could be set up on a web host server over the internet where my friends and I could play by logging in from anywhere?
I am not very PC literate and and was wondering if you could please help me out with setting it up for me, I could even pay you $100 for the effort, I know its not much but its what I can afford at the moment.
Please let me know, Thanks.
Thanks :-)
Sorry for late reply .. because … well … forget about it :D
# Paladin
As long as you have the sql, etc you just need to execute the queries and configure it accordingly and you’re done :)
# chad
well for 10 people i guess standard machine can handle it without problem (but if its for me, i already has 1GB ram)
for more info you should take a look at Jeremiah post ;)
# Xearo
Edit the realmlist.wtf (in WoW game directory) so it’ll connect to your server (put 127.0.0.1 as the server ip)
connect to it?
-=+Update+=-
I now have my server running but how do –>I
YO ho! Great setup btw but I’m having trouble with my cmd. it always start off at:
C:\Documents and Settings\Xearo>
So no commands work cus it thinks everything’s in Documents and Settings.
I’ve tried using MySQL’s command but after i type the pw it accepts it but just sits there and i can’t type anything else.
Hey Chad Im running it off my pc. My pc is costum built and its running off asus Motherboard
2.8 Pentuim 4 Hyperthread n6600 AGP 8x 256 Mb video card 1 Gig of DDR 400 Kingston Hyperx Ram with a seagate 80 Gig Harddrive. You should be fine if you can play wow. If you want your friends to connect and play with you, youll probly need a fast connection, and a bit more ram than I have. Good luck If you plan on setting up the server
Great info! I was just curious as to the server specs you are running it on?
Are there any guidelines on what I would need for a machine to run this server with no more than 10 users on it at a time?
Cheers, chad
so u wanna create a server for me?
# JeremiahMan
Hello Jeremiah :)
Try looking at the server.log or maybe you could send the server.log to my email address ? my email address can be found on my about page ;)
OK, I had the right version of it but I had the mangosd config file set to the wrong path I had it set to C:\Wow\data and I reset it to C:\World of warcraft\data and now I dont get the error message, But the Mangosd.exe opens and closes real quick to. ( I think this is causing me not being able to get to the char select screen) I seen you wright in an earlier post about asking if the config was set up right What should the config for mangosd look like. If you could post it that would be great (For WoW Version 1.12.1)
I’ve also notice if I dont set up the sql right that the realmd.exe wont open up. the realmd .exe is opening up and staying open for me now But do you know any Idea why the mongosd isnt working? If you can email me Jeremy@alliancelaser.net that would be great.
# Paladin
Im sorry if only i have good connection then there’s no problem for me to create server too :)
# Bryan0226
Are you sure the mangosd.conf and realmd.conf is in the same directory where mangosd.exe and realmd.exe can be found ?
# Tesmai
Actually if you dont set environment variable for mysql, you need to use full path in order to use mysql. Like this for an example :
Mysql not set in env. path :
C:\mysql\bin\mysql.exe -u username -p
Mysql in env. path :
mysql -u username -p
thats it :)
# JeremiahMan
Ah … if you get that error message that means the maps you’ve extracted isnt compatible with the current mangos you’re using
if you use TBC client you need to get the latest ad.exe from Mangos svn repository to extract maps :)
but if you’re not using TBC client then you can use the ad.exe from here (its the old version of ad.exe)
Hey I got everything to work but when I open the mangosd It closes real quick, I took a Quick screen shot of it befor it closed and it had a error message OF (Cant Find map 004313 ( I think it is this Number IM at a Diffrent computer right now) . Also when I open wow I can log in, but when I get to the Realm Selection Every time I try to Enter the realm It keeps bringing me back to the Realm Selection Screen.
The last thing is You say
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
Wait. I ran through again, and the first Answer on your FAQ “If you tried to run the mysql command directly without setting it to use the env. variable path, you’ll get that error message” Makes no sense. So, explain that and I’m good.
Ok, I’ve done everything as you’ve said, but when I open mangosd.exe or realmd.exe from /C:WoW/Mangos They close right after. Are they supposed to do that because whenever I try it it says “Disconected from server.”
whenever i try to start the realmd and mangosd things, it says that they don’t exist and it also says that make sure the .conf file is in the same folder as the program which it is… ive been working on this for a long time and im stuck at this part ;( pls help
ty
denniskerstma@hotmail.com is my e-mail
cant u make an server and an gm account on that server for me? just send an e-mail to me and i send u the name and pass i would like.
should be fun if u could ;)
# UKmania
Actually even if you have TBC installed you can run TBC server too, but you’ll need to get newer version of Mangos and the database itself of course (try visiting their page) because the version posted in this page can only be used on wow classic only (and its my database dump)
Ok, I am a complete noob on this, do i need to reinstall WoW and patch it to 1.12.1 or where ever i need to go. I tried from the beginning and im just plain confused. I am new to this. So im begging for pro help. If you get this please help me :) Im not sure where to extract etc, I have TBC installed so im guessing nuke that. and start over.
This is the bit im stuck at:
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