Custom Search
Reaper Mangos 4651, ScriptDev2 151 with Project Silvermoon and Unified Database
Posted by Reaper-X Oct 29 2007 10:26 pm
Time for another Mangos release again :D … and this time, instead of creating one mangos release, i have decided to also release my other compiled mangos release which is using Auction House Bot and Jail Patch that is designed to those who love to try out something new in their mangos server or in other words, a more experienced mangos user :)
but let’s keep that aside shall we ? because i’m going to write that one on that post release and in this post i’m only going to give you some intruction on how to get your private wow server running using the pure / clean compiled mangos without any additional patches included
As a note this release uses Project Silvermoon Database Revision 18.5 (Not updated except for the core update) and Unified Database 0.8.1 Revision 325 (Updated) and only work with WoW 2.2.3 Client and tested with WoW 2.2.3 with TBC Expansion Pack installed, so if you’re not using TBC expansion pack, you’ll need to disable the expansion pack in mangosd.conf in order to work with your WoW 2.2.3 :)
Just like before, here are the steps :
Requirements :
1. MySQL and it’s guide on how to install it properly
2. Mangos with Database
Update: Reaper Mangos 4703 has been released
Reaper Mangos 4651 with Scriptdev2 151 Dual Database Reaper Mangos 4651 with Scriptdev2 151 Dual Database | 14.4 MB | Rapidshare 14.4 MB | RapidshareReaper Mangos 4651 with Scriptdev2 151 Dual Database Reaper Mangos 4651 with Scriptdev2 151 Dual Database | 14.4 MB | Megaupload
Optional (if you don’t have these installed already) :
- .NET Runtime – For maximum compatibility with any programs in the future, i recommend you to install .NET Runtime 1.1, .NET Runtime 2.0 and .NET Runtime 3.0 (and don’t forget to read the requirements over at Microsoft website) ;)
Mangos Fresh Install :
Important Note : Below steps is designed to those who are installing mangos for the first time or upgrading from Reaper Mangos 4629, if you’re upgrading from 4602 and below you’ll need to upgrade the character table and realmd first using the menu provided on reaper eazy mangos
Not too Important Note : The screenshots used below is not updated but the installation process is still the same of course :) and oh one more thing, i assume that you’ve extracted the self extracting archive ;)
1. Extract the DBC Files, Maps, and VMaps from your world of warcraft client
2. Run the reaper-x-mangos.bat inside the reaper-eazy-mangos directory / folder, and you’ll be see something like this, and then all you have to do is just write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)
3. Now you just need to choose option number 1 to install the database as shown on below image, and when prompted for your mysql root password, don’t forget to write the correct password … and then when prompted to choose the database, feel free to choose the Project Silvermoon database or Unified Database so you can compare it :)
4. After finished with the database installation, now you need to choose option number 4 (required or else you’ll see the mangosd.exe close immediately when you run it) to adjust the datadir and adjust the exp rate, and drop rate :)
5. Now after finished with all the above process, you’ll need to go inside your World of Warcraft installation directory (for example C:\Program Files\World of Warcraft) and then open the realmlist.wtf using notepad and …
replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
with :
set realmlist 127.0.0.1
save it and close realmlist.wtf file
6. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating username of course :D by typing create username password inside the mangosd window as shown on below image as an example … followed by typing setbc username 1 … so you can choose Blood Elv and Draenei
lastly you just need to type setgm username 3 so you’ll have the GM Power, and … done !!! congrats … now all you have to do is just login using the username you’ve created before ;)
Upgrading from 4629 Release / switching between silvermoon database and unified database :
1. Choose to backup your character first
2. Choose to install the new database
3. Choose the restore option to restore your character and … done :D
Note : Since i don’t really know how many people are still using my old release :( , i assume that most people already upgraded into my previous 4629 release
and here’s my character screenshot
And just in case you didn’t see my previous post, here’s a screenshot of my character riding Nether Drake (note: this is taken using the Unified Database)
and fishing :P
Related Links :
MySQL Installation
Mangos Commands for GM
Setting up Private WOW Server for LAN or Internet
Installing Apache Web Server for Mangos Registration Page
Trackbacks/Pingbacks
Leave a response
Connect with me
lol yeah i shut my comp off by using the shutdown option in the start menu and i leave my comp for about 5 mins then go back on, and i leave it for about 3 or 4 mins (cuz im making a sandwich lol) and it still comes up with those errors (see up above for detail) you have any idea why? thanks adamkuntz_1@hotmail.com
Btw, A handy tip for people.
When you start your computer give windows the time to start up, especially MySQL needs time to load.
Wait for a few minutes, don’t click mangosd.exe immediately after the desktop appears, because it may not be ready yet.
omfgder,
“holding the power button”
Never ever turn your computer off like that, especially when your running something unsuperior to vista, like Windows-ME.
Windows must have its time to write away all his precached data.
ok i think i might have a solution
this morning i was late for school when i was playing so i shut my computer off by holding the power button and usually when i do that the programs that are running when i try and run em again they dont work but if you have any solutions to my problem up above (about 4 comments up) email me at adamkuntz_1@hotmail.com thanks
Yes I have: set realmlist 127.0.0.1
do I need any /’s or anything
I wanna get it going and i’ve been working on it for 9 days
Also, if I have it a public one what do I use for that?
# Checkmate
Thanks for the info :) btw do you mean the freeforall loot patch to fix the recent database changes that is introduced in mangos 4695 ?
# Jake
Did you change the realmlist.wtf to point to 127.0.0.1 ? or your public ip if you want to run public server
have you started the mysql service ? and if you already started it … did you use different port for the mysql process ? (default 3306)
to check whether you have installed mysql and mysql service is running :
1. open command prompt
2. type netstat /an
and look for this entry :
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
or look for another port that is using 330x (just in case you have mysql installed previously in different directory and install another mysql into another directory without cleaning up the previous installation or adjusting it)
Note : you can only see mysql listening for incoming connection if you enable it (which is by default especially if you follow my mysql installation guide)
OK guys 1-st thx for the deat things that you are doing. I’m a first timer for creating a mangos server and this night i devoted 5 hours to do it and i think i’ve gone some where. everything is done as you said reaper-x but one small problem continues- the problem that alex had and antar had. when i start the mangosd i says that i cannnot connect to the MySQL DB. i know you guys posted replyes to such problems but i spend an eternity trying to see the replies and the problems of the ppl here but coulnd not (sry:(() so i ask you if you have time to post the sollution to this problem one more time thx alot guys and cya.
No accounts I create work, and it seems as if it is still connected to Blizzard, do I put my own IP in? If so how do I do that on Vista? Or is there something else to put in. Plz tell me soon!! I really want to get it going soon so my friends can play!!
just a heads up, a group loot patch is out.
wtf now it comes up with this error my server was working last night and this morning now it comes up with these errors :(
2007-11-06 12:21:52 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-11-06 12:21:52 MySQL client library: 5.0.45
2007-11-06 12:21:52 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-11-06 12:21:52 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
and now realmd errors
2007-11-06 12:21:47 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-11-06 12:21:47 MySQL client library: 5.0.45
2007-11-06 12:21:47 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-11-06 12:21:47 ERROR:Cannot connect to database
its gay please help me
adamkuntz_1@hotmail.com
shouldn’t*
Oh okay, thanks for quick reply and explanation. No, it is fine lol. I will wait for the full and upadted release. Lol, should even be making such reaquest, should wait patiently for it seeing as you don’t really have to through all the effort, but yet you do, and thank you for that.
does having vista have anything to do with it
Reaper, I just want to thank you so much! I’ve been trying to get this program working for the entire weekend and now I have it! Thanks for all the help and making this possible.
IT LIVES THX REAPER-X
you rule =P
Didn’t realize no images posting http://i17.photobucket.com/albums/b99/vinzone/Mangosd.jpg
OK, so I get to the part where I am suppose to run mangosd.exe and realmd.exe and when I open mangosd.exe I get this [IMG]http://i17.photobucket.com/albums/b99/vinzone/Mangosd.jpg[/IMG]
When I try to login to WoW I get an “unable to connect” error. I realize there must be some slight mistake I made when inputting information, but I have pioured over this guide for at least 30 minutes and I am unable to find any point at which I made an error. My ode idea would be whether I should place my own IP where “127.0.0.1″ is, but I’ve tried that and it doesn’t seem to work. Any ideas on where I may have gone astray?
I am running Reaper Mangos 4651 the straight up mix (w/o jail or AH bot) and have noticed some strange behavior, and wanted to run it by you all. I have created a server, and everything went smoothly (thanks to the awesome guide / files) until the other day, I had changed the cross faction chat / group / trade options to allow, and invoked a shutdown to have mangos load those options. Now when I load the mangosd.exe it loads and doesn’t report any errors, but no longer does it list the mangos commands, nor does it let me type anything into that terminal window either, is this behavior normal, or is there something that I need to do to be able to type in mangos commands at the server in the terminal window? Incidently, everything else seems to be running fine, it is just a bit of an annoyance to not be able to issue commands from the server terminal window.
Thank you for any information anyone may have.
thanks guys it works now and everyone listen to reaper and siegelink lolz ty guys and cya
=( i wish you would have answered my post…i lost all my custom vendors after doing the update. is there a way that when i update again i dont have to set up my vendors all over?
Jake,
You must create a different account then your original. Also for security reasons!
did you create the account whit the mangosd.exe? and else try another 1 I did that too causee I got the same whit some …
But anyone knows why I can’t duel? cause i tried to duel whit a friend but it didn’t work :s
I have another problem now, I created my account which just happens to be the same as one that was on blizz server but when i try to log in it says i have used up my play time, even after i set the realmlist to 127.0.0.1. Plz help
hey thanks siegelink i thought i had wasted 2 days trying to figure something out that didnt turn out to be an arubix cube lol so im just getting my maps now ill post back on here with more errors (if there is any)
thanks!
adamkuntz_1@hotmail.com
Hello Reaper,
Thank you for the answer, but could you tell me pls where should I put my id? Witch file has these
item.m2-s and display id’s defined??
i thought i can find this in ItemDisplayInfo.dbc
file but unfortunately most of the file content is coded.. I dont know how to edit it :(
Thank you so much.
When I install the database (either one), it says it will take a while and then it says “press any key to continue…” so I press any key and then all this stuff happens really fast. lol It looks like the matrix is eating my computer. I thought this was an error before and Ctrl + C ‘ed it lol. Didn’t know that was supposed to happen. mangosd is working perfectly now.
Just one little problem when I start WoW. When trying to login using the username/password I created in step 6, WoW says I put in the wrong stuff. I changed the realmlist.wtf as in step 5.
Thanks for the help and keep up the great work.
here is the maps folder :)
http://depositfiles.com/files/2268737
but i wanna play with tbc maps too :(
thx anyway :(
# genera
actually if vmap is not working for you, you can always disable it by editing mangosd.conf
by changing these lines :
vmap.enableLOS = 1
vmap.enableHeight = 1
into
vmap.enableLOS = 0
vmap.enableHeight = 0
# superman
try running the reaper-x-mangos.bat and choose option #1 to install the database
btw if you get an error message when installing the database, i’m sure that’s what caused the gameobject_template table is not get updated :)
# t00th_ach3
Actually i have prepared the 4695 to be released today but since i just saw that there’ll be another update to WoW Client (probably to 2.3.0), i decided to postponed it :) .. beside since there’s no changes made to the database (since there’s no new release from UDB and PSDB) the only thing changed is in the mangos core itself and the scriptdev2
but i can always release it if you want
everything works only the Vmap extractor :s,
if it is only that, and i could get the maps on my pc, i would be able to run the emu
Please Help. Almost done with everything: extracted dbc, maps, vmaps, and changed realmlist.wtf, did all the reaper-x-mangos.bat stuff and am able to run realmd but when I run mangosd I get the following error:
2007-11-05 01:15:57 ERROR:Error loading `gameobject_template` table (not exist?)
…actually I get a bunch of errors but it stops after that one and I don’t want to spam with all the errors :P. Thanks in advance and this guide totally rocks!
Oo Gief updated mangos release plx!
Enrique,
pls read my comment on saintslayer about 8 post’s up.
genera,
I hate to break it to you, but if your computer is not able to coop with the extraction of these file’s you probarly can’t run the emulator anyway.
I,m sorry
plz upload the Vmap folder :(
plz help i egt this error
2007-11-04 21:21:21 Using configuration file mangosd.conf.
2007-11-04 21:21:21 MaNGOS daemon /Reaper-X 4651 SD2-151 0.9.0-SVN Mod AH-BOT 5.4 + JailPatch http://www.reaper-x.com (Win32)
2007-11-04 21:21:21 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-11-04 21:21:21 World Database: 127.0.0.1;3306;mangosmod;mangosmod;mangosmod
2007-11-04 21:21:21 MySQL client library: 5.0.45
2007-11-04 21:21:21 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangosmod’@'localhost’ (using password: YES)
2007-11-04 21:21:21 ERROR:Cannot connect to world database 127.0.0.1;3306;mangosmod;mangosmod;mangosmod
put it in the data/enUS or w/e version u got
lol i figured it out it was in the wrong dir
thxs anyway
NVM I have 4,425 .MDX and .WMO files, I think I need to run the vmap assembler but it closes the second I open it, is there some special place I need to put it?
I have the 3299 files but they are all WMO and MDX files and the mangosd file needs .vmap or .vmdir, also can anyone help me with the .map thing where it thinks the .map files are bad.
i tried deleting the map folder and redoing it but same thing happened
and my wow is up to date and everything but it still gives me the error
http://img90.imageshack.us/img90/7518/14755280sq9.png
i put the extractor in the World of Warcraft/data/enUS
what am i doing wrong?
confused,
Mate, I don’t know what to tell yeh
Q:Can someone tell me how to make one?
A:Yes I can, Begin reading from the top of this page.
Im new to Wow i just dinged to 69 and i wana take a break to make a private server. I don’t really know how to make a server because i don’t play alot, can somone tell me how to make one?
SaintSlayer,
For you and other people.
Read the installation guide carrefully from the “top”of the page, after that read the faq and then read the post’s and there must be a solution to your problems in those, if not then you can always post and then describe your problem in detail.
okay your problem,
Either your error has to do with administrator right’s and/or user account control.
Or MySQL is not working anymore.
Jake,
12 vmap files is not enough you must have 3299 files.
omfgder,
Your version of WoW must be: 2.2.3.7359
Just patch it to that version. and re-extract the maps.
Hey thanks this is the best but one problem
everything works (except my server lol) but here are the errors in the server Log
2007-11-04 17:50:19 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-11-04 17:50:19 MySQL client library: 5.0.45
2007-11-04 17:50:19 MySQL server: 5.0.45-community-nt
2007-11-04 17:50:19 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-11-04 17:50:19 MySQL client library: 5.0.45
2007-11-04 17:50:19 MySQL server: 5.0.45-community-nt
2007-11-04 17:50:19 Realm running as realm ID 1
2007-11-04 17:50:19 Using Rev 19 PSDB.
2007-11-04 17:50:19 Using DataDir J:\WoW\data/
2007-11-04 17:50:19 WORLD: VMap support included. LineOfSight:1, getHeight:1
2007-11-04 17:50:19 WORLD: VMap data directory is: J:\WoW\data/vmaps
2007-11-04 17:50:19 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-11-04 17:50:19 Initialize data stores…
2007-11-04 17:50:20 ERROR:
You have _outdated_ DBC files. Please extract correct versions from current using client.
im using WoW version 2.1.3.6898
E-mail me
adamkuntz_1@hotmail.com
thanks, good guide!
vfoolio,
Check if the .MPQ files are really in your data directory.
If they are not then:
Log in to WoW (Just type any name and password) and auto update.
Or do it manually by clicking the paches in the root of WoW.
You need to delete the maps folder in your WoW dc then try it again
whenever i run extract-map.exe in root install folder it gives me this
http://img90.imageshack.us/img90/7518/14755280sq9.png
can somoen help me plz? its seems like its try to extract the enGB version but my version is enUS. how do i change this?