Creating WoW Private Server the easier way (perhaps)

Please check the new version on how to create wow private server for better version. Besides the new guide list everything in a single page for easier reading

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 :

  1. Installing MySQL
  2. Setting up the Mangos
  3. Just in case you want to create lan party
  4. 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 Classic
  • Mangos 3462 by Maxi
  • World 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 :)

  1. C:\MySQL\bin\mysql.exe -u root < create-database.sql
  2. C:\MySQL\bin\mysql.exe -u root -D realmd < realm-database-full.sql
  3. 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 :)

Comment?

Note: Comment may not appear right away.

459 comments on “Creating WoW Private Server the easier way (perhaps)

  1. #Jon & Anteaus03

    Try looking at the second part of my new guide … and if you’re looking a tested mangos revision including it’s download link, look at the update part

    as for anteaus problem

    that error message was caused because you didn’t import the sql file properly

    # Tailee

    Could you tell me which wow server version you’re trying to create ? the TBC or classic server ?

  2. Help With the SDB156 Mangos3462 file Pls.
    I am able to download the file. Just that it has errors when its complete.If Anyone could post a proper link to the File i`d be really grateful. Thank you.

  3. Okay. After resolving many problems I have run into one more that I require some help with.

    Okay when I run my Mangos.exe I get these errors. (And no it has noting to do with maps)

    Error List
    ————-
    2007-09-11 19:55:53 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-09-11 19:55:53 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-09-11 19:55:53 Realm running as realm ID 1
    2007-09-11 19:55:53 Using DataDir ./
    2007-09-11 19:55:53 WORLD: VMap support included. LineOfSight:0, getHeight:0
    2007-09-11 19:55:53 WORLD: VMap data directory is: ./vmaps
    2007-09-11 19:55:53 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    2007-09-11 19:55:53 ERROR:SQL: UPDATE `character` SET `online` = 0
    2007-09-11 19:55:53 ERROR:SQL ERROR: Table ‘mangos.character’ doesn’t exist
    2007-09-11 19:55:53 Initialize data stores…
    2007-09-11 19:55:53 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = ‘1’
    2007-09-11 19:55:53 ERROR:SQL ERROR: Table ‘mangos.corpse’ doesn’t exist
    2007-09-11 19:55:53
    2007-09-11 19:55:53 >> Loaded 37 data stores
    2007-09-11 19:55:53
    2007-09-11 19:55:53 Using Autodetected DBC Locale (0).

    2007-09-11 19:55:53 Cleaning up instances…
    2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.creature_respawn’ doesn’t exist
    2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.gameobject_respawn’ doesn’t exist
    2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.character_instance’ doesn’t exist
    2007-09-11 19:55:53 ERROR:SQL: SELECT `id` FROM `instance`
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.instance’ doesn’t exist
    2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1189554953)
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.instance’ doesn’t exist
    2007-09-11 19:55:53
    2007-09-11 19:55:53 >> Initialized 0 instances, deleted 0 old instances
    2007-09-11 19:55:53 Packing instances…
    2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` 0
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.character_instance’ doesn’t exist
    2007-09-11 19:55:53
    2007-09-11 19:55:53 >> Instance numbers remapped, next instance id is 1
    2007-09-11 19:55:53 Loading Game Object Templates…
    2007-09-11 19:55:53 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
    2007-09-11 19:55:53 ERROR:query ERROR: Table ‘mangos.gameobject_template’ doesn’t exist
    2007-09-11 19:55:53 ERROR:Error loading `gameobject_template` table (not exist?)

  4. hey reaper, i have been trying to make the server and i have succefully installed mysql, but im stuck in the mangos part, it seems like the link to the first requirement to make a BC server, any way you can help me?????

  5. wow, this is supose to be easy lol i think this website is pretty good but, HARD to anderstand to many tings to do if there is some1 that anderstanded everything and has set the full ting well could u msg me on my email: [email protected] to help me out whit all this. ty very much

  6. Dear, Reaper..

    i’m trying to make a private server.. but it totaly isn’t working out…i was wondering if you could help me trough Crossloop? ( that is an program, so you can log on in my computer )
    and do it on my computer.. i also would pay you for it if it is very hard , and if it takes very long… please contact me over : [email protected]

    Sincerely,
    Wouter

  7. 2007-09-05 22:03:13 Using configuration file mangosd.conf.
    2007-09-05 22:03:13 MaNGOS daemon /0.8-SVN (Win32)
    2007-09-05 22:03:13 to stop.

    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM http://www.mangosproject.org
    MMMMMM

    2007-09-05 22:03:13 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-09-05 22:03:13 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-09-05 22:03:13 Realm running as realm ID 1
    2007-09-05 22:03:13 Using DataDir C:\WoW\data/
    2007-09-05 22:03:13 WORLD: VMap support included. LineOfSight:0, getHeight:0
    2007-09-05 22:03:13 WORLD: VMap data directory is: C:\WoW\data/vmaps
    2007-09-05 22:03:13 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    2007-09-05 22:03:13 Initialize data stores…
    2007-09-05 22:03:13 ERROR:
    Some required *.dbc files (1 from 37) not found or not compatible:
    C:\WoW\data/dbc/TaxiPathNode.dbc (exist, but have 9 fields instead 11) Wrong client version DBC file?

    Can you please help with with this problem i am running “mangos version 4368 and database version 4344” yet when i come to load the server it always comes up with i am missing specific files

  8. …BTW, I used the admin account and it works, able to login i and create characters…

    NM, i think i understand….The realm I’m creating the accounts for probably isn’t in the realm list. makes sense.

    /headdesk ;)

  9. I’ll check that too.

    BTW, I used the admin account and it works, able to login i and create characters. However, i can create the user/account in mangos but it wont allow me to log in with that user name password.
    Thoughts.

  10. ive got mangos and gone through all the setup stuff put in my ip and all that and when it come to logging in a log in it trys to connect then says it is unable to connect to server wat do i do to fix it?

  11. # Mike

    Thanks Mike, and about your question, it can be caused by several things like :

    1. You havent changed the realmlist used into your own server ip address

    2. Database is not properly imported / loaded

    3. and more

    but as for now, i’d suggest you to look into the realmlist.wtf file inside your wow game directory

    # Sleeperx

    Didnt work for you anymore since upgrade ? try looking at the realmlist.wtf file, to see if it’s using your mangos ip address or wow official ip address

  12. Im having to create servername and characters through the runmangos window……it worked once for me but then i installed BC and it didnt work anymore….got any ideas?? did i do something wrong?

  13. Reaper-x,

    Nice guide, the screen shot helped alot.

    However I have followed it Everything works as it should (best that i can tell), but when i try log into the client it says:

    the information you have supplied is incorrect……please contact your administrator… lost password or login.

    this is at the client screen, BTW.

    Got some good ideas from the prev. posts to check for errors but any other help would be appreciated.thanks

  14. # jackh

    did you use your GM Account when typing .commands ?

    # Sebastian

    A good explanation about URI can be found here :

    http://www.webopedia.com/TERM/U/URI.html

    # Sleeperx

    Are you sure you’re using the correct password ? or try creating new account with GM Level

    # Aaeon

    Actually the process for creating TBC server is just the same, with the exception when creating TBC server you need to download the newer revision of Mangos and SDB from the respective website :)

  15. hey i have everything running fine but when i log into WOW with my GM name it says that it is an invalid name or password. what do i need to do?

  16. I’m wondering if there is a way to make this work with newer versions of WoW. Unless I’m missreading this, it only works with v1.12.