Reaper Mangos Installation / Upgrade Guide

To make things easier for me to update Reaper Mangos in the future without the need to write the installation guide each time there’s a new release, i’ve decided to a separate post explaining on how to install Reaper Mangos … but please note that guide is specifically designed to those who wants to install Reaper Mangos from scratch (not upgrading) or in other words, fresh installation, because in order to upgrade you just need to execute the batch file in the upgrade folder inside reaper-eazy-mangos directory

Once again, if you’re going to upgrade your Reaper Mangos installation, make sure you’re using 1 version below the current release or you’ll lose all of your character data (unless you’ve created a backup before) and other customization made by yourself. So without further ado here goes the guide

Requirements :

1. MySQL Community Edition (Free) … as for the installation guide, you can read my previous post on how to install MySQL on Windows

Important: Grab the version 5.0 setup.exe version instead of 5.1 or 6.0 because the 5.1 series is still in Release Candidate stage while the 6.0 version is still at early alpha stage and not recommended for production use

2. World of Warcraft Client (supported version changed on each release)

3. Reaper Mangos itself

p.s the image itself might be outdated but the process is still the same :)

Fresh Installation :

Once again, please Note : Fresh installation will overwrite your database which means everything will be from fresh

1. First you’ll need to install MySQL

2. And the next step would be extracting Maps, DBC and VMaps from your World of Warcraft installation … (Maps and DBC are required in order for mangos to run, while VMaps are optional)

3. Run the reaper-x-mangos.exe inside the reaper-eazy-mangos folder, and you’ll get something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)

MySQL installation directory

If you’re didn’t write the correct path, you can be sure that you’ll get an error message at the next step

4. Now you just need to choose option number 1 to install the database as shown below, and when prompted for your mysql root password, don’t forget to write the correct password … :)

Mangos Database Installation

And one more thing, when you see something like in The Matrix movie (well … that’s how people called it) :) , you just need to wait until it finished and don’t interrupt the process

5. After finished with the database installation, now you need to choose option number 4 (required, unless you know how to edit the mangosd.conf manually) to adjust the datadir and adjust the exp rate, and drop rate (although the most important thing is your datadir path

Editing Mangosd.conf

6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …

Replace :

set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com

With :

set realmlist 127.0.0.1

and then save it and close realmlist.wtf file

7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account

Creating account in mangos

Btw if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :

create username password

to create the account, and then to allow your account to access The Burning Crusade Expansion pack (like BloodElf) you need to type :

setbc username 1

and finally :

setgm username (1–3)
for example setgm myusername 3

to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)

Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.exe to adjust it :)

Upgrading Reaper Mangos :

Make sure to backup your Characters data before upgrading

Upgrading Reaper Mangos can be done by simply running the reaper-x-upgrade.bat in Upgrade folder in reaper-eazy-mangos directory

But please note, that if you’re still using 2 version below the current release, the upgrade process is not going to be completed successfully (i’ve been trying to make sure that the upgrade process can be used by any version but it’s seems that there’s no easy way to accomplish this, but if you got a suggestion on how to process this, just let me know about it)

Note : You don’t need to worry about your custom stuff being overwritten by the upgrade process, because unlike before this time it’s only upgrade the necessary stuff only and not going to overwrite your custom stuff (but i assume that you’re using high id numbers for your custom stuff)

Finally i’d suggest you to check out the GM Commands List because there are some changes made at the GM Commands especially at the lookup command (and of course i’ll always update the GM Commands List whenever there are new command available for you to use, or there are previous command that is being replaced with new commands)

Comments Navigation « Previous 1 2 3 4 5 Next »

Badboss said Feb 28, 2008 at 3:10 am

i have a problem…
i can only create one char… if i create 2 or one of my friends login my char desapear and we cant create another…

im running windows vista sql 6.0

Link to this comment Reply to this comment
Psamtik said Feb 27, 2008 at 10:04 pm

but now I have(had) the server running, but after dying at a boss in SSC, I cannot rezz, so I tried to .ressurect, but I kinda ressurected but then died again, then mangosd crash when loading character corpses, and everytime I try to start it it crashes again. I tried getting a new mangosd but it didn’t work. How do I delete/fix/move characters?

Link to this comment Reply to this comment
jay said Feb 27, 2008 at 12:53 pm

Hey I need help!!!. I jave installed and reinstalled mangos several time. I have even gone as far as doing my whole system just to make sure every thing was strate. I have every thing done no errors it seems to be running. then when I try to connect it can’t I have changed my ip addres port # and I can get as far a authenticating and it stops.
I have gone from ip 127.0.0.1 to 192.168.1.100:3306 or 8805 and I get the best respons from port 3306 please help I don’t know where I have messed up or what I need to change. I have followed you instuctions to the letter I even printed them out.

Link to this comment Reply to this comment
Mod said Feb 27, 2008 at 8:47 am

I’m still having problems with mangosd.exe. It didn’t connect before, but now i get it to work by changing the database on the CONF File to Mangos on LoginDatabaseInfo, WorldDatabaseInfo, and CharacterDatabaseInfo so they all say “127.0.0.1;3306;username;password;Mangos”, but now i get to:

Loading Auctions…
SQL: SELECT ‘itemguid’,'item_template’ FROM ‘auctionhouse’
query ERROR: Table ‘mangos.auctionhouse’ doesn’t exist
SQL: SELECT COUNT FROM ‘auctionhouse’
query ERROR: Table ‘mangos.auctionhouse’ doesn’t exist

can anyone help?

Link to this comment Reply to this comment
troy said Feb 26, 2008 at 1:46 pm

hey mate good guide tho i am having alot of trouble working out mangos like where do i find the installation file i have looked all over this site and cant find plz get back to me throuhg my email

Link to this comment Reply to this comment
Edan said Feb 26, 2008 at 11:53 am

Hi reaper,
I cant find the reaper-x-mangos.bat inside the reaper-eazy-mangos folder for reaper mango 5225 version, please advice, thanks…

Link to this comment Reply to this comment
ReeT said Feb 26, 2008 at 11:11 am

hi i cant get my DBC files to work plz help .. when im going to locate my DataDir it cant finde my DBC files . and i have put maps, vmaps and DBS in same folder but when i try to locate that map it says ”The system cannot find the path specified. DBC directory dos not existe” and as i sed map, vmap and DBC are in the same folder

Link to this comment Reply to this comment
Mod said Feb 26, 2008 at 8:44 am

-turwon
i got that too and where you have aiden, i changed it to mangos and it connected but now it’s telling me i have an outdated DBC

Link to this comment Reply to this comment
turwon said Feb 25, 2008 at 7:31 pm

NM sorry, I got it. Thanx again reaper

Link to this comment Reply to this comment
turwon said Feb 25, 2008 at 7:22 pm

Reaper, Good work!

I need a little help. Sorry if I missed the answer.

Mangos 5225
SQL 5.0

I followed the instructions step by step. No errors until I run..

mangosd and realmd

I cannot connect.

World Database: 127.0.0.1;3306;root;gibbs;aiden

It says unknown DB aiden

Any ideas on whats wrong?

Link to this comment Reply to this comment
Mod said Feb 25, 2008 at 2:48 pm

ok i got the mangosd.exe to go a little farther, but now it says i have an outdated DBC file, how do i get the most recent one?

as for the realmd.exe, it says “No valid realms specified.”

Link to this comment Reply to this comment
Mod said Feb 25, 2008 at 4:03 am

i got the same problem as Frank. On step 7 when i start mangosd.exe and realmd.exe, neither can connect. Everything before that worked though

Link to this comment Reply to this comment
Mitch said Feb 24, 2008 at 10:19 am

mmmk… fixed another problem i was having… now i can get to the realm list, but can’t get to the create a character part, I may have missed through the posts, but if someone could point me in the right direction?

Link to this comment Reply to this comment
Mitch said Feb 24, 2008 at 8:35 am

“ERROR 1064 at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near’s world’, ’sddress’ = ‘127.0.0.1′ WHERE ‘ id’ = 1 LIMIT 1; SELECT * FROM ‘realmli’ at line 1″ i’m not sure what this means, can anyone help?

Link to this comment Reply to this comment
Reaper-X said Feb 22, 2008 at 5:33 am

# Edan

You can always look for the new release from the homepage directly ( http://www.reaper-x.com ) or you can also take a look at the footer section or you can also browse through the reaper mangos archive

Link to this comment Reply to this comment
Edan said Feb 22, 2008 at 1:39 am

Dear Reaper,
Thanks for advice on the mysql installation.
Now i have some problem. where can i download the reaper mango 5225 software? hope you are able to provide me the link, thanks once again… ed

Link to this comment Reply to this comment
Reaper-X said Feb 21, 2008 at 11:20 pm

# Kenneth and Pheen

from that error message it seems that you didn’t choose to upgrade the database, try using reaper-x-mangos.exe and then choose to upgrade the database :)

# /beg

Are you using Reaper Mangos 5225 ? if so … i’m guessing that you choose to write your own username when asked at the fresh installation steps and the solution to it :

1. Leave blank when prompted to use root as the username and continue with fresh installation

2. When asked whether you want to create separate username for mangos, answer Y and it’ll create separate username for mangos automatically

# David Bentley

Yes, actually you can just ignore it :) .. because the current release (if you choose to use UDB as the database instead of PSDB) still not using the new EventAI, but on the next version there’ll be eventai too for UDB, just wait for it ;)

Link to this comment Reply to this comment
/beg said Feb 21, 2008 at 10:59 pm

i am getting a msg

“Could not connect to MySQL database at 127.0.0.1: acces denied for user ´jepe ´@´localhost´

cannot connect to database.” ???

Link to this comment Reply to this comment
tobbe said Feb 21, 2008 at 8:50 am

I got one error “Could not connect to MySQL database at 127.0.0.1: can´t connect to MySQL server on 127.0.0.1″ what´s wrong? thx for help=)

Link to this comment Reply to this comment
Kenneth said Feb 21, 2008 at 5:23 am

Im having same problem here :

—————————————————–
Loading MaNGOS strings…
SQL: SELECT `entry`,`content_default` FROM `mangos_string`
query ERROR: Table ‘mangos.mangos_string’ doesn’t exist
[**************************************************] 100%
>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.

macos/FastLock.h:73: failed assertion `false’
Abort trap
logout
—————————————————–

I also have been at this for a hole day, still nothing…..i can’t find the solution to this problem.

Been using Mangos on my old PC with no problems….this error is on my Mac using “Mangos 5235″ with Maps,DBC, Vmaps and everything downloaded via the program !

PLEASE HELP REAPER !!!!!!

Link to this comment Reply to this comment
Pheen said Feb 21, 2008 at 1:42 am

SQL: SELECT ‘entry’,'content_default’ FROM ‘mangos_string’ query ERROR: Table ‘wow private server.mangos_string’ doesn’t exist ==================================100% >> Loaded 0 mangos strings. DB table ‘mangos_string’ is empty. Cannot continue

I am also having this problem, Did it not import this table with the rest of them? I do see atleast what looks like the other tables in ..\MySQL\MySQL Server 5.0\data\mangos

I’ve tried for several hours to fix it, searching for it, didn’t turn up much.

Please Help :(

Link to this comment Reply to this comment
David Bentley said Feb 20, 2008 at 9:16 pm

Great job… easy to follow and set up.
I have been stymied a bit by a Warning the from the server…

SD2 :WARNING >> Loaded 0 Localized_Texts. DB table ‘Localized_Texts’ is empty

and
SD2: WARNING >> Loaded 0 EventAI_Scripts. DB table ‘Event_AI_Scripts’ is empty.

This does not seem to make the server not work but it is puzzling. is this a normal message ? or should I look for problems.

Link to this comment Reply to this comment
Kenneth said Feb 19, 2008 at 1:08 am

During my setup, I first met the problem Tomcat and nikor noticed above, and when I fixed that problem I got a new error message:

Loading MaNGOS strings…
SQL: SELECT ‘entry’,'content_default’ FROM ‘mangos_string’
query ERROR: Table ‘wow private server.mangos_string’ doesn’t exist
==================================100%
>> Loaded 0 mangos strings. DB table ‘mangos_string’ is empty. Cannot continue.

What should I do to fix this problem?

Link to this comment Reply to this comment
Tom said Feb 18, 2008 at 4:43 am

heeeeeeeeeeeeeeeelp me please im going through a real stressful time and i need this to take my mind off it but when i try to run mangosd it stops and says
2008-02-17 21:40:05 ERROR:Map file ‘C:/wow/data/maps/0004331.map’ is non-compatible version (outdated?). Please, create new using ad.exe program.
2008-02-17 21:40:05 ERROR:Correct *.map files not found in path ‘C:/wow/data/maps’ or *.vmap/*vmdir files in ‘C:/wow/data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

Link to this comment Reply to this comment
Tom said Feb 18, 2008 at 4:12 am

download mySQL 6.0 it works

Link to this comment Reply to this comment
rolo said Feb 17, 2008 at 5:17 pm

#johaan

i have the same problem…in fact when anyone tries to make a character from any connection on any account they can’t see it on the character list

Link to this comment Reply to this comment
Cloudless said Feb 17, 2008 at 4:02 am

Thx again :D
I just changed my OS from win xp to Vista and after 2-3 hour i have at last installed the private server.
Respect to your work with mangos.

Link to this comment Reply to this comment
Azshand said Feb 17, 2008 at 2:30 am

how do u install v 5225 on a linux box i looked in the readme and there was was no installation guide that shows for linux server

Link to this comment Reply to this comment
Mitch said Feb 16, 2008 at 6:53 pm

I think it may have something to do with realmd.exe. I can’t type in it, and it also doesn’t seem to do anything when i run it. How long should it take to complete?

Link to this comment Reply to this comment
Mitch said Feb 16, 2008 at 6:29 am

i’m also using reaper mangos 5116

Link to this comment Reply to this comment
Mitch said Feb 16, 2008 at 6:28 am

i click connect… it says unable to connect… how do I fix this problem… I have WoW 2.3.3 and mysql 5.0.51. i’m on vista and got around the “side-by-side” error for the mysql. but i can’t connect to play.

Link to this comment Reply to this comment
Mitch said Feb 16, 2008 at 5:26 am

alright, so i figured out how to fix that side-by-side error, now how do i actually get into it to play?

Link to this comment Reply to this comment
Frank said Feb 15, 2008 at 11:32 pm

I did all the things listed, but when im done and have to start realmd.exe and mangosd.exe they both give an error: Cannot connect to world database. What can i do about this

Link to this comment Reply to this comment
Johaan said Feb 14, 2008 at 4:22 pm

Hey guys, first thing I want to say awsome job. I never thought I’d be able to look at the BT bosses face to face but thanks to you I can die now :p.

The only thing that’s giving me a problem is the fact that I can’t create a 2nd toon for some reason. As soon as I do, or as soon as a friend joins my server, my character screen stays blank and I can’t see nor select any characters. Neither can my friends. Only after I delete all accounts and start over, can I see 1 toon. And as soon as I create a 2nd they dissapear again.

They exist because if I click on change realm, it tells me that my realm has X number of toons on it. But I can neither see nor select any toons.

I’ve tried searching 2 days for a fix but so far I’ve only read about 1 guy with a similar problem on a different forum with no luck.

Thanks for any info you can give me. BTW The game doesn’t give me an error message of any kind which is what I found odd.

Link to this comment Reply to this comment
Logan said Feb 14, 2008 at 6:36 am

when i run mangosd exe it says that my DCB files are outdated and i need to extract the current ones from client but as far as i can tell they are up to date as shown above how do i fix this problem?

Link to this comment Reply to this comment
Steve said Feb 14, 2008 at 4:30 am

DBC error

You have _outdated_ DBC files. Please extract correct versions from current using client.
_______________________________________________

I Have tried everything, patch up to date, runnin on windows xp, got new version of mangos 5116, re extracted DBC files adn matrixed again with correct file path. Plz help, it’s got me confused.

Link to this comment Reply to this comment
dennis said Feb 9, 2008 at 10:43 am

can some1 help me with this

Link to this comment Reply to this comment
dennis said Feb 9, 2008 at 10:43 am

SELECT 1 FROM `account` WHERE `username`=’root’
query ERROR: Table ‘realmd.account’ doesn’t exist
SQL: INSERT INTO `account`(`username`,`I`,`joindate`) VALUES(’root’,SHA1(CONCAT(UPPER(’root’),’:',UPPER(’root’))),NOW())
SQL ERROR: Table ‘realmd.account’ doesn’t exist
SQL: INSERT INTO `realmcharacters` (`realmid`, `acctid`, `numchars`) SELECT `realmlist`.`id`, `account`.`id`, 0 FROM `account`, `realmlist` WHERE `account`.`id` NOT IN (SELECT `acctid` FROM `realmcharacters`)
SQL ERROR: Table ‘realmd.account’ doesn’t exist

Link to this comment Reply to this comment
PiroX said Feb 8, 2008 at 1:53 pm

http://www.reaper-x.com/2007/10/10/wow-mangos-map-vmaps-and-dbc-extraction-guide/

Link to this comment Reply to this comment
Vaughn said Feb 8, 2008 at 1:58 am

I guess no one cares, but, I took the following actions to see if this would help.

Steven, on a higher post, told people how to fix #5. I figured, hell why not give it a try. So I did and now I can’t turn mangos or realmd on at ALL. So I’m going to reverse that crap, and beg for help with step #7. I cannot get realmd or mangos to allow me to even type on them. Perhaps its because I have no idea where the dbc files are?

Maybe someone can list the exact dbc files I need to put in D:\WoW\Data

Link to this comment Reply to this comment
PiroX said Feb 7, 2008 at 10:57 pm

I am using the lastest version of the Reaper Mangos(5116)

Link to this comment Reply to this comment
PiroX said Feb 7, 2008 at 10:56 pm

Hey, someone can help me?
When I run mangosd.exe, it says that my ‘item_template’ has some problems and it may be outdated. What I do to fix that?

Link to this comment Reply to this comment
Vaughn said Feb 7, 2008 at 12:57 pm

@ my old post, I need help with #7+ if someone can help.

Link to this comment Reply to this comment
Vaughn said Feb 7, 2008 at 12:51 pm

Well heres my problem, the Mangosd.exe has this, and will not do anything but this…

Incorrect DataDir value in mangosd.conf or ALL required *.dbc files not found by path: D:\WoW\Data/dbc.

Now, Im a bit lost..Im using the version which works with 2.3.3 so can someone please help?..
And if you can comment back asap tha would be good..im having GF problems..and i need this to take my mind off it.

Link to this comment Reply to this comment
Tomcat said Feb 6, 2008 at 11:52 pm

Ok, so i finaly created an account, but when i wanted to start playing, it said it was an invallid version, so i updated, when i restarted mangosd.exe, it gave me an error: “Error in ‘item_template’ table, probably sql file format was updated (there should be 141 fields in sql).”
I know it is updated, i just did that, but how do i fix it?

Link to this comment Reply to this comment
Frank J said Feb 6, 2008 at 6:52 am

Travis:…..

The recent WoW installation does not contain any maps, the maps are actually stored in the users account on the Blizzard server, as are the characters and most of the realm details.

Therefore it is NOT, and will NEVER be possible to run a successful private WoW server, unless a Blizzard employee can be bribed to obtain their server software, prepackaged, ready to work out-of-the-box, with only the ip addresse(s) to be changed.

Link to this comment Reply to this comment
Travis said Feb 6, 2008 at 6:51 am

@Tomcat

WewT! That worked! Thanks for the help!

Link to this comment Reply to this comment
Tomcat said Feb 6, 2008 at 6:48 am

@ Travis

you don’t have to place it there, you have to place it in the root of your game, in your case “C:\Program Files\World of Warcraft” and not in data.

Link to this comment Reply to this comment
Travis said Feb 6, 2008 at 6:31 am

@ Tomcat

I tried to make maps again by running extract-map.bat in the
C:\Program Files\World of Warcraft\data\enUS
it is still not putting any files in the Maps folder. Not sure what else to do.

Link to this comment Reply to this comment
Tomcat said Feb 6, 2008 at 6:22 am

@ Travis

Yes you should have files in there, if they have gone missing, make new ones by running the MapExtractor program again.

Link to this comment Reply to this comment