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 ... 3 4 5

Ben said Jul 9, 2009 at 4:25 pm

when i run mangosd.exe, i get “Wrong client version DBC file?” message followed by messages saying that there are more fields than should be in .dbc files.

Link to this comment Reply to this comment
Richard said May 27, 2009 at 6:41 pm

This post is awesome, nice work!

Link to this comment Reply to this comment
Kevin said Nov 2, 2008 at 5:07 am

I set up Repack Arcane-Fire as said, and i put the update from Oatman Bug fix to fix the error with the characters, but i’m still getting the character error.

Link to this comment Reply to this comment
Scott said Oct 12, 2008 at 10:19 pm

Hi I get MaNGOS realmd can not bind to 0.0.0.0:3306 when I try to run realmd and I get this when I try to run mangosd

World:Vmap config keys are :vmap.enableLOS,vmap.enableHeight,vmap.ignoremapids, vmap.ignorespellids
Check existing of map file ‘ C:\Program Files\World of Warcraft\World of Warcraft/maps’ or *.vmap/*vmdir files in C:\Program Files\World of Warcraft\World of Warcraft. Please place *.map/*.vmap/*.vmdir files in appropriate direcotires or correct the DataDIR value in the mangosd.conf file.

I think the MangosD problem is that it’s looking for C:\Program Files\World of Warcraft\World of Warcraft/maps when it should be a backlash email is st.louis26@hotmail.com please post on my problem thanks.

Link to this comment Reply to this comment
Connell said Oct 12, 2008 at 12:37 am

I get the same as Zafara except ihave just the one. Some required *.dbc files 1 from 55 not found or not compatible: C:\program files\world of warcraft \data\dbc\Spell.dbc wrong client version DBC file?
Just cant figure this out any help would be greatly appreciated,so close.

Link to this comment Reply to this comment
vchik said Oct 7, 2008 at 5:15 pm

TO: DanielRabin

I ran into the same problem. My password was set incorrectly. Make sure the password you put into mysql and the password in the mangosd.conf file is the same. Read the blurb at the beginning of the mangosd.conf file to figure it out. good luck. you also have to keep mangosd and realmd running while you launch wow.

Link to this comment Reply to this comment
DanielRablin said Sep 28, 2008 at 6:55 am

When I open mangosd.exe I get the same error I have seen on about 5 previous posts.

2008-09-28 09:52:55 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘root’@'localhost’ (using password: YES)

2008-09-28 09:52:55 ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos

I have configured the mangosd.conf file and added in the Data dir and I have also tried re-installing three times all to no avail. Can someone look into this problem because I know a lot of other people have it too.

Link to this comment Reply to this comment
AceofShadows said Sep 1, 2008 at 7:13 pm

same here as i open up mangosd.exe and it says;

World Database: 127.0.0.1;3036;myusername;mypassword;worlddb
Could not connect to MySQL database at 127.0.0.1: Can’t connect tp MySQL server on ‘127.0.0.1′ (10061)

Cannot connect to world database 127.0.0.1;3036;myusername;mypassword;worlddb

and when i open up realmd.exe:

Daemon PID: 3680

Database: 127.0.0.1;3036;myusername;mypassword;realmd
Could not connect to MySQL database 127.0.0.1: Can’t connect to MySQL server on ‘127.0.0.1′ (10061)

Cannot connect to database

I need serious help with this, any help will be greatly appreciated!

Link to this comment Reply to this comment
Bub311 said Aug 22, 2008 at 8:08 am

ok I need help whenever I try to run mangosd and realmd it sais unable to connect or whatever.
Cannot connect to database.\
Help plz?

Link to this comment Reply to this comment
Zafara said Aug 16, 2008 at 9:24 pm

Problem with Mangosd
Extracted dbc files multiple time

World Database: 127.0.0.1;3306;mangos;mangos;mangos
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Realm running as realm ID 1
Using unknown world database.
Using DataDir C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMan
gos4535/Data/
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is: C:/Documents and Settings/Zachary/Desktop/Private
Server/ReaperMangos4535/Data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Initialize data stores…
========================================= = 80%
Some required *.dbc files (7 from 38) not found or not compatible:
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/BattlemasterList.dbc (exist, but have 33 fields instead 32) Wrong client vers
ion DBC file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/ChrClasses.dbc (exist, but have 58 fields instead 24) Wrong client version DB
C file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/ChrRaces.dbc (exist, but have 69 fields instead 35) Wrong client version DBC
file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/CreatureDisplayInfo.dbc (exist, but have 14 fields instead 21) Wrong client v
ersion DBC file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/ItemExtendedCost.dbc (exist, but have 14 fields instead 13) Wrong client vers
ion DBC file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/Map.dbc (exist, but have 125 fields instead 123) Wrong client version DBC fil
e?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/Spell.dbc (exist, but have 216 fields instead 211) Wrong client version DBC f
ile?

Link to this comment Reply to this comment
Izzi said Aug 15, 2008 at 1:56 pm

I would like to know how to correct the ‘broken data’ in the characters table. If I knew that I would be completely okay! plz help me.

Link to this comment Reply to this comment
Narsin said Aug 12, 2008 at 3:06 am

I’m having an issue with reaper-x-mangos.exe. I’m using vista 64 bit and when i type in the path for my MySQL directory, it just closes and nothing else happens, am i missing something?

Link to this comment Reply to this comment
greenbox said Aug 9, 2008 at 7:00 pm

outadted=outdated

Link to this comment Reply to this comment
greenbox said Aug 9, 2008 at 6:57 pm

when i fished make my server then i runed my magosed.exe it says(you have outadted dbc files. please extract correct version from current using client)

Link to this comment Reply to this comment
Prevas said Aug 4, 2008 at 4:15 pm

@Jones

Thanks a lot m8, it did work and the server is running.

Link to this comment Reply to this comment
CopperM0E said Aug 4, 2008 at 7:09 am

Okay…I’m a n00b….found the fix…gonna try it…had the file on my hard drive allready, just hadn’t run it yet, didn’t think it would be the ‘fix’ to my problem. ..and I quote, from the website:

“Apply Bug Fix 1 if you are having problems with creature templates, etc.”

Conviently located at:
http://www.reaper-x.com/2008/08/01/reaper-x-ur1-arcane-fire-243/

Link to this comment Reply to this comment
CopperM0E said Aug 4, 2008 at 7:02 am

@ fox

Same exact problem here fox. To the letter. We have both obviously missed the same thing.

” Loading Creature templates…
Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql). “

Link to this comment Reply to this comment
Jones said Aug 3, 2008 at 4:46 pm

@Prevas
If you don’t have the config option, you’ll need to edit your config files manually, meaning that you open the .conf files with notepad, then change the password to your MySQL password.
I hope this helps, I don’t have enough patience for listing all options in the configs. :P

Link to this comment Reply to this comment
fox said Aug 3, 2008 at 8:07 am

Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
Loading Item Texts…
==================================================== 100%
>> Loaded 0 item pages

Loading Creature Model Based Info Data…
==================================================== 100%
>> Loaded 16891 creature model based info

Loading Equipment templates…
==================================================== 100%
>> Loaded 1874 equipment template

Loading Creature templates…
Error in creature_template table, probably sql file format was updated (there sh
ould be 65 fields in sql).

Link to this comment Reply to this comment
Prevas said Aug 1, 2008 at 5:03 pm

hi, I downloaded the repack but when I get to step 5 I cant find option 4 (mangos config editor), and when I try to run mangosd.exe and realmd.exe I get the same problem as jay that it cant connect to database… could you please help me?

Keep up the good work (Y)

Thanks,

Prevas

Link to this comment Reply to this comment
jay said Jul 12, 2008 at 1:12 am

i did everything from installing MySQL to running reaper mangos and everything goes fine until i run mangosd.exe and realmd.exe

when i run those two i get the same error on both “cannot connect to database” plz if anyone knows how to solve this educate me.. btw i’ve already tried the solution given to /beg

Link to this comment Reply to this comment
juiceman said Jun 5, 2008 at 11:48 pm

Tsuki, I’m havin the same issue. I recently upgraded nortin anitvirus, 2007 version let me do it just fine, but 2008 says its a trojan. I’ll check if theres something I can change in settings, but just letting everyone know.

Link to this comment Reply to this comment
esuvee said Jun 3, 2008 at 6:13 am

alright im having a problem with 5 once i get to the datadir path, i have DBC’s directory in my wow folder but it still cant find it. Help!

Link to this comment Reply to this comment
Zippy said May 28, 2008 at 10:39 am

That makes sense. Thanks!

Link to this comment Reply to this comment
Firane said May 27, 2008 at 11:06 am

@zippy
thats cuz the custom vendors are only for the PS DB which reaper conveniently didn’t include in the release

Link to this comment Reply to this comment
Zippy said May 27, 2008 at 9:46 am

First of all thanks so much for the outstanding program and guide!!!

I got everything to work (including playing the game) except for when I run reaper-x-mangos.bat and select option “[7] Installs the Optional GM Island Vendors!”

When I choose this option and enter the required info I get the “Matrix” screen followed by:
Error 1136 (21S01) at line 24: Column count doesn’t match value count at row 1

I’m using “mangos” for the MaNGOS/World database name, which I assume is correct, but I’m not sure.

Thanks for any help!

Link to this comment Reply to this comment
Chris said May 26, 2008 at 7:26 pm

Hi,

i have a problem installing everything there is no reaper-easy-mangos.exe or .bat in the folder can anyone help me plz i tryd useing one out of an older version but this didnt help, simply got some errors.

Many thnx in advance

Chris

Link to this comment Reply to this comment
Tsuki said May 24, 2008 at 3:45 am

I have tried installing the mangos 4 times now and avast keeps telling me it’s a trojan virus… Little help?

Link to this comment Reply to this comment
hammerseize said May 18, 2008 at 7:40 pm

Please help im on the verge of giving up. I cant find the reaper-x-mangos file in the reaper-easy-mangos file.

Link to this comment Reply to this comment
Naomi Wiflath said May 18, 2008 at 12:26 pm

Hey Reaper- guess who! I decided to take another crack at this, and I almsot had it! Only problem is Mangosd.exe crashes when it hits exactly 86% while initalizeing Data Stores. Happens every time, not sure what to do with this one!

Link to this comment Reply to this comment
Upgrade said May 16, 2008 at 12:43 am

any info on how to upgrade the server from 2.3.3 would be greatly appreciated. I have all the files necessary to make the server 2.4.2 but I’m not sure what to do with them as they came with no read me or instructions of any kind.

Roadmin.net FTL

Link to this comment Reply to this comment
Drizzt said May 14, 2008 at 9:25 pm

Isaa , From what I can see your DBC files arent the correct ones? Did you get your DBC files from the game after you updated? If not you should extract them from your updated WoW and then retry. If that doesnt work idk what will

Link to this comment Reply to this comment
Drizzt said May 13, 2008 at 9:55 pm

Chris: I think that your MySQL isn’t operational, have you tried restarting your computer? I was having that error for a bit. Other than that, maybe try reinstalling MySQL. Maybe you didnt set it up properly, set up your MySQL exactly as Reaper Says. I tried differently and it messed up like yours. Try reinstalling

Link to this comment Reply to this comment
Isaa said May 13, 2008 at 7:44 pm

Greetings,

Spent about 2 hours setting up SQL and going through the walkthrough on how to set this up, extracted all maps, vmaps and DBC put them in a folder, ran the reaper easy mangos program setup all databases. Ran mongosd.exe as it said to and get this

2008-05-13 20:40:09 Using configuration file mangosd.conf.
2008-05-13 20:40:09 MaNGOS daemon /0.10.0-SVN (Revision 5472) (Win32)
2008-05-13 20:40:09 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

2008-05-13 20:40:09 Daemon PID: 3668

2008-05-13 20:40:09 World Database: 127.0.0.1;3306;mangos;john2005;mangos
2008-05-13 20:40:09 MySQL client library: 5.0.51a
2008-05-13 20:40:09 MySQL server ver: 5.0.51b-community-nt
2008-05-13 20:40:09 Character Database: 127.0.0.1;3306;mangos;john2005;characters
2008-05-13 20:40:09 MySQL client library: 5.0.51a
2008-05-13 20:40:09 MySQL server ver: 5.0.51b-community-nt
2008-05-13 20:40:09 Login Database: 127.0.0.1;3306;mangos;john2005;realmd
2008-05-13 20:40:09 MySQL client library: 5.0.51a
2008-05-13 20:40:09 MySQL server ver: 5.0.51b-community-nt
2008-05-13 20:40:09 Realm running as realm ID 1
2008-05-13 20:40:09 Using PSDB X9 SD2 297
2008-05-13 20:40:09 Using DataDir D:\WOW/
2008-05-13 20:40:09 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-05-13 20:40:09 WORLD: VMap data directory is: D:\WOW/vmaps
2008-05-13 20:40:09 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-05-13 20:40:09
2008-05-13 20:40:09 Loading MaNGOS strings…
2008-05-13 20:40:09
2008-05-13 20:40:09 >> Loaded 460 MaNGOS strings
2008-05-13 20:40:09 Initialize data stores…
2008-05-13 20:40:09 ERROR:
Some required *.dbc files (6 from 51) not found or not compatible:
D:\WOW/dbc/BattlemasterList.dbc (exist, but have 33 fields instead 32) Wrong client version DBC file?
D:\WOW/dbc/ChrClasses.dbc (exist, but have 58 fields instead 24) Wrong client version DBC file?
D:\WOW/dbc/ChrRaces.dbc (exist, but have 69 fields instead 35) Wrong client version DBC file?
D:\WOW/dbc/CreatureDisplayInfo.dbc (exist, but have 14 fields instead 21) Wrong client version DBC file?
D:\WOW/dbc/Map.dbc (exist, but have 125 fields instead 123) Wrong client version DBC file?
D:\WOW/dbc/Spell.dbc (exist, but have 213 fields instead 211) Wrong client version DBC file?

Any help?

Kind Regards

-Isaa

Link to this comment Reply to this comment
7MM3 said May 11, 2008 at 6:29 am

you use winrar to extract those files… but where did you get yours? cause one of us got the wrong file then… cause mine came as a .exe

Link to this comment Reply to this comment
jrod said May 11, 2008 at 5:40 am

hwo do you install mangos itself… when i got it fromt he website provided it dl as a .rar file and you cant open it… plz help.

Link to this comment Reply to this comment
7MM3 said May 11, 2008 at 2:04 am

I tried to install this last night, and I got a few error messages, and some things didn’t look even remotely like this guide, so I winged it in a few parts, and that didn’t work, so I’m asking for help now… First problem is on step 4, my menu does not look anything like that, but I push 1 anyways, and then I get 2 options, Unified Database and Project Silvermoon, which should I choose, and after that(I picked UD), I get 5 error messages saying Unhandled Exception: Cannot Print Exception string because Exception.ToString failed.
and a popup saying RXFind has encountered and error and must close for each one.

Link to this comment Reply to this comment