Custom Search
Reaper MaNGOS 5931 with ScriptDev 412|Server Compatible With 2.4.2 (UDB ONLY!)
Posted by Oatman May 22 2008 7:02 am
PLEASE DO NOT USE THE FRESH INSTALL TOOL IT IS BROKEN IN THIS RELEASE. IF YOU WANT TO BE ABLE TO USE THIS RELEASE DOWNLOAD THE 5472 RELEASE AND THEN USE THE UPGRADE TOOL IN THIS RELEASE. THE PROBLEM IS I FORGOT TO INCLUDE SOME SQL AND PEOPLE ARE GETTING CREATURE.ADDON ERRORS AND ALOT OF VARIOUS SQL ERRORS. I APPOLOGIZE SINCERELY.
NOTE: THIS IS SAFE HOWEVER IF YOU ARE USING THE UPGRADE TOOL! SO IF YOUR UPGRADING FROM THE PREVIOUS RELEASE IT WILL WORK ITS JUST THE FRESH INSTALL THAT IS BUGGED UP!
Sorry Included an Old Map Extractor Heres the Updated Link!
https://mangos.svn.sourceforge.net/svnroot/mangos/trunk/contrib/map_extractor/ad.exe
Well looks like its FINALLY TIME for another Reaper MaNGOS Release so that you all can get your servers updated with the latest features and to use the new 2.4.2 client. I spent a couple of hours getting this release ready and I think I finally have gotten it right.
Also as a Side-Note PSDB is NOT included in this release due to the fact that their organization at their site is horrible and they are unclear on how to upgrade from an older database. So you guys will have to get Reaper to tell me or a PSDB Dev to instruct me on how to upgrade or else you guys will not have a PSDB Database.
New Features:
- Don’t even ask! There is so many bug fixes/new features its not even funny. It would take me hours to type it all up because of how much has been added since the last release!
About Oatman:
Btw just to let you all know my name is Jared (Oatman) and I am good partners with Reaper and I help him release some of the WoW Releases! For all of you that have been wondering Reaper has just made a move from his previous city and sometime during that move he visited a doctor and he has a medical condition referred to as Vertigo. Some of you may be aware of this while others are not. Feel free to search Google for what it is. I would like to advise you that he is ok but his doctor told him to stay away from the computer for the time being.
REQUIREMENTS:
1. MySQL Database and the Guide on how to Install MySQL
2. World of Warcraft Client version 2.4.2
3. Updated DBC’s, VMAP’s, and MAPS Updated for 2.4.2!
DBC’s are already included as part of this release!
4. Reaper-Mangos Server :Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | File Beam Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | Rapidshare Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | Mega UploadReaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | Media Fire
Fresh Install:
Important Note : Fresh installation will overwrite your database
1. First you’ll need to install MySQL
2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
(You can safely ignore the Patch-2, or any not found xxx-2 message)–This only happens if your extracting from patch 2.4.0
3. Run the reaper-x-mangos.bat inside the reaper-x-mangos folder, and you’ll see 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) ;)
4. Selection Option 1 by pressing “1&Prime on the keyboard and pressing enter.
Note: This will wipe out any previous versions of WoW you have in your database.
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
By the way, 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
setgm username 1-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)
8. Finally if you have Burning Crusade client installed and want to be able to create Burning Crusade specific character, all you have to do is just type :
setbc username 1
to enable burning crusade expansion for your account :)
Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.bat to adjust it :)
Upgrading from 5472 Release:
1. Re-extract vmaps, maps and dbc because this version no longer supports the old World of Warcraft 2.3.3 installation and only supports the new 2.4.2
2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos. Next I recommend opening the batch file and backing up your character data. This is optional though.
3. Open the Folder called “Upgrade” and run reaper-x-upgrade.bat.
4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located.
5. Then make sure that you are upgrading from the latest previous version or else you WILL corrupt your database and possibly lose your character data.
Guide on how to Edit Mangos.Conf
Thanks for the Mangosd.conf edit guide Jeremy!
First off make sure that you have your MySQL running before doing anything.
You need to go back into the reaper folder (C:\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos)
And run the batch file called reaper-x-mangos, there is an option there to setup your LAN or IP for use, This new batch file does correctly setup your DB to the IP you enter in this batch file. Once you’ve done that, if you haven’t gone back in to edit the config files in your reaper folder mentioned above, you need to do that, there is a section in there with this.
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”
This is an example of waht it may look like. You need to change this to the path where you put your data folder with the maps, vmaps, and dbc’s.
Second, …
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database – use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database – use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;characters”
Above, you need to change the MANGO;MANGOS to your root DB name, likey it’s just root, and YOUR batabase (DB) password (you should know this)
YOU DO NOT CHANGE THE IP’S here or in the realmd file, ONLY THROUGH THAT BATCH FILE, i mentioned above. (that file does it for you)
Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.
Hope you enjoy this release if you have any questions feel free to post them as a comment below!
Trackbacks/Pingbacks
Leave a response
Connect with me
i get an MySQL “-D” requires an arguement error on installing
problem with that is too big creature spawn guids
ERROR:creature guid overflow!!Cant Continue. Shutin down server.
ERROR:creature guid overflow!!Cant Continue. Shutin down server.
ERROR:creature guid overflow!!Cant Continue. Shutin down server.
ERROR:creature guid overflow!!Cant Continue. Shutin down server.
hello, I have tried to set up the mangos server with this guide but when I get to the part where I can start the emu it gives me this message
Databas: 127.0.0.1;3306;root;mangos;realmd
Could not connect to MySQL database at 127.0.0.1: Access denied for use ‘root@
Cannot connect to databas
What did I do wrong? can you please help me,
Nice guide btw.
Yours Sincerely,
I was playing on my friend’s private server with the Mangos 2.4.2, and I’ve noticed that all enemies aggro through any wall or building as if it wasn’t even there. Was just wondering if this has always been like this, or if it is a bug that needs to be dealt with?
Just my 2 cents and great job on everything Reaper.
hey man it is my first installation to the wow server i want it to be compatible with 2.4.2
please can you helpme from A to Z i am a begennir and the mangos forum is not helpfull @ all i read 2 hour i did not understand a think please help me as soon as possible
I’ve been using the 5116 version due to upgrade and character problems. I am finally trying to upgrade to the 5939 version however I can only get it to upgrade through the 5742 series in steps. Once I try to upgrade to 5931 I get the broken data in Character “data” field. I’ve done a search and haven’t found how to fix this. I can log in and create new characters but can not use any old characters.
I did a straight upgrade and didn’t use the full install at all. I’ve spent about 14 hours between two days going through everything I can think of. Reverting to old version full/install upgrades and even comlete uninstalled and redid Mysql to delete any possible errors.
I’m at a loss but would really like to use the 2.4.2 WOW and get up to 5939 reaper mangos server. Any help or suggestions will be greatly appreciated by me and both my kids.
I can not seem to make mysql run. When I type mysql -u root -p mangos and after enter my password, I am shown connect to the db. However, when I run mangosdb.exe, it says can not connect to the database. Anybody can point me to the right direction? Note that I am on a single computer (no server). Thanks for helping a noob!
I have an idea, If you ever get chosen to access their BETA of Wrath of Lich King you could maybe create your own Reaper Mangos version of it.. now that’d be cool you’d get so many downloads from it, and a hell lot of site reviews. :D
For those that receive:
Loading game object templates…
Error in game object_template tables, probably sql file format was updated (there should be 33 fields in sql).
I found that it was me mistyping or not filling out the installation/update questions. I was assuming it auto filled the defaults into it but it does not. Once I filled them in manually all was well!
I talking about these questions:
(All you need to do is type what the most likely name is or your custom name if you did it differently)
What is your MySQL database USERNAME ? (Most likely “root”)
What is your database PASSWORD ?
What is your World/Mangos Database Name ? (Most likely “mangos”)
What is your Characters Database Name ? (Most likely “characters”)
What is your Realmd Database Name ? (Most likely “realmd”)
What is your ScriptDev2 Database Name ? (Most likely “ScriptDev2″)
Hi Reaper, i have been using your releases like four or five months now, thank you a lot for them n_n.
Well here is the issue, I put the last one to work but there is a lot of gm commands that aren’t included, like addgo, addspw or flymode. I dedicate to study the game models and without those commands im stuck.
If you can tell me what im doing wrong i will apreciate it.
ps, being a gm kinda is all about cheating, so if you know how to add gear that has been added to a post-2.4 patch but is not yet live, please do share :)
how do i add the brutal gladiator set? i used the .lookup item command and it says no item found..
OUT OF DATE!!! REPLACED WITH 5953
Anyone else find the updated custom vendors SQL files?
@ nilrem,
Sorry for the delay. I figured out your problem (I hope. I’m going to look stupid if this isn’t it). First, my assumption is you are running the server on a separate computer from the one that you actually want to play on. Second assumption is that in your database under realmd/realmlist you have the IP set to 127.0.0.1. If this is correct, then what your CLIENT computer is trying to do is go to the 127 IP address (loopback) and connect to the server. See the problem there? in the realmlist portion of the database change the IP address to whatever IP address the server actually is on the network (Example: 192.168.0.150), save, then restart both the realm and game servers. Then try reconnecting. That should fix your problem. Let me know if that works or not.
-Dopey
i got a problem when i start up the mangos.exe it goes fine then it tells me
Loading Items…
Error in item_template table, probably sql file format was updated (there should be 140 fields in sql)
i think i need help
I am looking into the “creature guid overflow” error. I dont know how I missed that. Thanks
#Tyrael
and anyone with “Creature guid overflow!!” issues
Great! Things work again. Many thanks for your help. :D
Because I was impatient and did not wait for your reply I did it a little differently, so I detailed the steps in the forum:
http://forums.reaper-x.com/topic/mangos-shuts-down?replies=11#post-5121
@ wowman
probably you have the “creature guid overflow” error check your server.log file in your reaper-x folder and see if you have that error, cause it looks like you have it…
oh yah this is what my realmd file looks like
LoginDatabaseInfo = “127.0.0.1;3306;root;*****;realmd”
LogsDir = “logs”
MaxPingTime = 30
RealmServerPort = 3724
BindIP = “0.0.0.0″
PidFile = “”
LogLevel = 0
LogTime = 0
LogFile = “Realmd.log”
LogTimestamp = 0
LogFileLevel = 0
LogColors = “”
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
i am having dificulties getting my server to work on anything but my own computer (posibly my lan to but i only have 1 PC) i am trying to get this to work through my DNS server, i go into the “reaper-x-mangos” file and do the settup there to change my address were the server is to ******.no-ip.biz and change the file in the wow directory to this also, i can log onto my server but when it trys to log into the game server it can see it but fails to connect. but i am still loged in just not into the realm server. plz help
@Phen
Fresh install of this release (that means overwrite the last version) and then do the update
InDigital,
i got to login but it only shows ‘authenticating’ and stuck there.
#Tyrael
Awesome!
When you say ‘fresh install’, do you mean of the previous pack or of this one?
To fix the error:
“Creature guid overflow”
i follow this steps:
1. backup your characters data
2. do a fresh install
3. if you get the “creatures” error (probably you are gonna get it) do an update
4. restore your characters data
this works for me.
sorry for my bad english ;p
I just got it to work! woot.
i had to use the DBC included in the mangos folder, cause the extractor didnt want to be nice to me.
i probably messed up a couple steps cause i had to do some tweaking, but it works great!
thanks to OATMAN AND REAPER!!!!
_.-._ CAN SOMEONE PLEASE UPLOAD THE MAPS AND VMAPS EXTRACTED FROM 2.4.2 _.-._
Oatman I am still having problems with the server shutting down. Any ideas??
@ nilrem,
Sorry for the delay. I figured out your problem (I hope. I’m going to look stupid if this isn’t it). First, my assumption is you are running the server on a seperate computer from the one that you actually want to play on. Second assumption is that in your database under realmd/realmlist you have the IP set to 127.0.0.1. If this is correct, then what your CLIENT computer is trying to do is go to the 127 IP address (loopback) and connect to the server. See the problem there? in the realmlist porion of the database change the IP address to whatever IP address the server actually is on the network (Example: 192.168.0.150), save, then restart both the realm and game servers. Then try reconnecting. That should fix your problem. Lemme know if that works or not.
-Dopey
THANK YOU INDIGITAL!!! I’ve been trying to tell everyone this and they didn’t seem to understand. The fresh install is broken and the only way to do a fresh is by getting the old release and upgrading to the new release. So yep your on the right track. :D
#About UK
Yea I didn’t add UK support for the extractors -my bad- I’ll have two versions supported next time ;)
Also the DBC’s ARE included BUT they are only for the US English Game Client. I’ll fix the extractors to work with UK in the next release.
Oh and the next version of UDB has been released so later tonight I’ll get right on the next release. Sorry I can’t at the moment but the problem is that I am at my cousins house and they have all this Norton crap and are so strict with their comptuer I cannot do anything.
great job jared, one problem though the .addspw command doesn’t work… any ideas?
newly
I suggest you to:
0. erase any previous databases from SQL server
1. install new UDB from v5472
2. update UDB from new v5931
if you do this then there will not be this error and server will work.
mangosd stops here:
Loading Creature Data…
SQL: SELECT creature.guid, id, map, modelid,equipment_id, position_x, position_y
, position_z, orientation, spawntimesecs, spawndist, currentwaypoint,curhealth,
curmana, DeathState, MovementType, spawnMask, event FROM creature LEFT OUTER JOI
N game_event_creature ON creature.guid = game_event_creature.guid
query ERROR: Unknown column ’spawnMask’ in ‘field list’
==================================================== 100%
>> Loaded 0 creature. DB table `creature` is empty.
Loading Creature Addon Data…
Error in creature_template_addon table, probably sql file format was updated (th
ere should be 8 fields in sql).
Any idea?
Actualy i would like to invite everyone to make channel #reaper-x on my own server irc.vaic.lv (stable 24/7) and there you can make this discussion in realtime..
Hi,
I ve upgraded my mangos to this latest version successfully.. But many of the spells that were working in the previous version stopped working now (for ex. Divine favor of my holy paladin isnt working for Holy light now). Is it that i need to install any other scripts to make them work ?
if someone could test the dbc extractor on a uk game client id loveyou forever mabey if you get it to work you could post the uk(gb)dbc online you will be my hero
I understand :)
wowman :)
It’s not actualy like you said :) But i already make server to work.. Yes i can program and i have my A.I. project. WoW sometimes is just a plae to relax and that is a reason i set up this server but i am not sure to do something on my own if i sow already lots of different wow mangos repacks where things work different. And you know this set up take a time. I dont want to waste it.
ok. looks like it takes about 40 minutes on my machine. but i get this error:
ERROR 1136 (21S01) at line 187: Column count doesn’t match value count at row 1
what does that mean?
yeah but can you use those with uk game
I stand corrected the dbc files are included
anybody have trouble with the dbc extraction?
im using a uk game and i cant get the thing to run it keeps crashing anyone got any ideas??
is it just my copy or is the file broken?,if so can i then use the dbc included with this release or is that only for us game client?