Reaper Mangos 4703 - Easy WoW Mangos Private Server
By Reaper-X on Nov 11, 2007 in Reaper Mangos, Software
Time for another Mangos release and as the title said, this is a clean compiled version of Mangos 4703 (without any custom patches) with Scriptdev2 Revision 156 and Unified Database 0.8.1 with Changesets 326 applied. Although you can also download the small version (minus the Unified Database), that perhaps might be useful to those who prefer to update their mangos core manually :)
- http://www.reaper-x.com/category/computer/software/reaper-mangos-mod/
- http://www.reaper-x.com/category/computer/software/reaper-mangos/
While Reaper Mangos Mod 4703 (the custom version) can be found at that link (Note: if you’re not familiar enough with Mangos i’d suggest you to get this one instead)
So here are the steps :
Requirements :
1. Working MySQL Installation (if you have MySQL Installed automatically from another Repack, i’d suggest you to completely remove it unless you know how to configure it)
2. World of Warcraft Client version 2.2.3 with TBC Expansion Pack installed (because that’s what i’m using right now, so if you don’t have TBC installed and not using the latest 2.2.3 version, i can’t really help you)
3. Mangos Server :
UPDATE : Reaper Mangos 4875 has been released
IMPORTANT : If you’re upgrading from my 4651, you should download this updated batch file and overwrite the reaper-x-mangos.bat inside reaper-eazy-mangos directory with this one, btw i’d suggest you to get this one even if you’re not upgrading
Reaper Mangos 4703 SD2 156 UDB FULL | 9.40 MB | RapidshareReaper Mangos 4703 SD2 156 UDB FULL| 9.40 MB | Megaupload
Update : It seems that some people love the custom GM Island Vendor made by Silvermoon Project, so i decided to convert it so you can use it on this 4703 Release, but as a side note because there is specific item that only exists on the Silvermoon Database, if you see message on the Mangosd Window saying that some item can’t be found, you don’t need to worry about it (it doesn’t affect your gameplay)
Download GM Island NPC Custom Vendor (you just need to run the batch file included)
For advanced users only :
Optional :
This section is optional to those who want to create a public server
4. You need to know how to setup port forwarding from your router first, and also configure your firewall to allow the port specified in Mangosd.conf and Realmd.conf (if you use DSL Connection, you’ll need to know how to setup port forwarding first or else your friend won’t be able to connect to your server)
Also please read the Mangos FAQ too
Fresh Installation Steps :
1. Installing MySQL on Windows XP 32 Bit (you’ll need to have mysql installed first)
2. Extract DBC, Maps and VMaps from your World of Warcraft Client
3. Run the reaper-x-mangos.bat inside the reaper-eazy-mangos directory / folder, and you’ll see something like this, and now 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) ;)
4. 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 … :)
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 :)
6. 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
7. 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
finally 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 ;)
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 Reaper Mangos 4651 :
First of all i’m really sorry that since there are many changes made to the database structure itself in Mangos, i can’t write instruction on how to upgrade your server from any version below 4651 (or it’ll be a very long post and i know that you don’t really want to read a long post) :P
So to those who are still using Mangos revision below 4651, you can contact me directly if you need help :)
and here are the step to those who are using Reaper Mangos 4651
1. Backup any custom data you’ve created before (such as custom vendors, custom weapon, custom armor, etc) using your mysql client … (i’m sure those who are creating their own custom stuff already have their own mysql client ready to be used) … but remember though if you’ve created custom vendor just make sure that it is compatible with this mangos version ;)
2. run reaper-x-mangos.bat inside the reaper-eazy-mangos directory and then choose option 99 to begin the upgrade process … and wait until it finished
3. Choose option 4 to reconfigure your mangosd.conf and no, don’t use the previous mangosd.conf because it has been changed
4. Done :)
Here’s some screenshot :
Riding Chocobo or Pecopeco perhaps :P
Blackfang Tarantula
Related Links :
Complete Mangos GM Commands
Creating Public WOW Server
Creating 2 Realmd in Mangos
Apache Web server Installation Guide
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
very cool, does anyone have a link so you can see what the fixes are?
i can always paste the changelog here ... but since it'll be long i decided not to paste it here :P
as for the UDB changelog you can see it directly at udbforums.org ;)
great, but the thing i want to ask is when i load the mangosd.exe, there is error happening in the characters database because the characters database is empty, but it is works in 4651.
nice guil,but i m stuck 7. about to create the username and account,The problem is i cant even type a word in that black box.And the black box didnt show any GM command like urs,but its show succesful connect to MySQL.PLs help me out...thx
# solixes
are you doing a fresh installation or upgrade ? and btw are you trying to type in the mangosd window or the realmd window ? because you're not allowed to input anything in realmd window :)
# justin
i assume that you're trying to upgrade, btw did you choose the option to upgrade ?
IMPORTANT NOTE: Don't run the upgrade function twice or you'll lose your character data completely
btw just to be safe, make sure to backup first using reaper-x-mangos.bat and when asked if you're using 4664 version and above ... answer no
or can i do the Fresh Installation and then restore back the character data ?
since there are many changes in the character database structure i don't recommend it :(
btw if you allow me to connect to your computer via remote assistance, i can help you directly :)
you can send me the remote assistance invitation to my email address that can be found in my about page at the top of this website
ei that peco2 mount thingy is that a custom mount or.. its on the database.. whats the id.. i wanna try it.. thanks.. i hope you could right a guide for restoring our old database.. huhuhu.. :(.... nyc work man.. gud.. luck..
ah lol actually it's called Raven Lord (i called it Chocobo at first because it looks to me that thing is just like Chocobo from Final Fantasy or Peco Peco from Ragnarok Online) :P and you don't need to worry it's in the database actually, just search for raven and eventually you'll get the ID ;)
as for restoring database, actually as long as you have the backup file, i can help you restoring the backup file :)
sure i have but my remote thinggy wont work on my pc.. weve tried that already but it wont work :(...
probably that was caused by firewall blocking remote access or try looking at the System Properties under Remote tab to see whether you have remote assistance disabled there ;)
Control Panel -> System -> Remote
I m doing the fresh installation with reaper mangos 4703.Everything is work but just only the create username and password wont allowed me to type in the Mangosd window.Ok,maybe i m doing something wrong,pls tell me how to do now,thx..:)
are you sure you're focusing on the correct window ? i have tested 3 times now .. and i can type just fine into the mangosd window
because mangosd window allow you to type anything into that ;)
ok then,i already delete all the things and redo again,MySQL,MaNGOS.will try it again now.
Ok,i had reinstall mySQL.but not i had facing the Connection Problem.Cos is always show out "Access Denied for "loot"@localhost".and the Execute can Start service but not apply security setting.what is the problem?
are you using your administrator account ? or account that has administrator privilege ?
also based from your description it seems that you're trying to access your mysql user as loot (which i can guess that is non existent)
the default user account for mysql is root :)
Most of the mobs dont give loot anymore, still a nice improvement (mounts work for me since this patch) :D thx
OK i upgraded, and i does not work what so ever! everytime i load mangosd it always resorts to the 127.0.0.1, but i am using my ip, not that one. i keep changing mangos but it dose not accept it. I keep getting this message: 'mysql' is not reconized as an internam or external command, operable program or batch file. 3 times in a row. what is going on?
Hello!
I'm having some issues with running mangosd.exe, I'm getting the error Data Base out of Date:
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
MySQL client library: 5.0.45
MySQL server: 5.0.45-community-nt
Realm running as realm ID 1
Using UDB 0.8.1 (326) with SD2 calls rev.156
Using DataDir C:\Mangos\data/
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is: C:\Mangos\data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeig
s, vmap.ignoreSpellIds
Initialize data stores...
==================================================== 100%
You have _outdated_ DBC files. Please extract correct versions from current using client.
All files have been extract, MYSQL is installed properly (as far as I can tell). Any suggestions would greatly be appreciated! Kudos! ^_^
My mistake, overlooked the client version #. Excellent program, please keep up the awesome work ^_^.
when i try to extract the dbc files it says failed to intialize properly what do i do
NVM it is .net right i need to up grade .net
i have a problem, i updated to 4703 and i DID have 1651 (or the most recent w/e number it is)
and every thing went fine, but then when i run mangosd it says: "Loading Game Object Templates...
SQL: SELECT MAX(`entry`) FROM `gameobject_template`
query ERROR: Table 'mangos.gameobject_template' doesn't
Error loading `gameobject_template` table (not exist?) so, i dont know what to do, and also when i had 1651 i was able to open up wow, log in, but i could not loginto the server. please help
Im running Mangosd.exe and realmd.exe but both say "Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos"@"Localhost" (using password: yes}
Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
how do i fix this?
#Shadelow
if you are using vista, try to right click on both and go properties-compatibility-run this program in compatibility for: Windows XP (Service Pack 2), and then to open it, right click it and hit run as administrater, if your not using vista, wait for reaper XD
well i just tryed to reinstall it from scratch and and now i ge an error saying that the password is invalid even though i completely uninstalled it.
ya im using XP
ok,i had done all the setting for MySQL,Mangosd 4703.(1st time install,and already use [99] to upgrade my).and my realm.exe is work,but still the same problem...is my Mangosd .exe is word,is showed me AUTOCOMMIT SUCCESSFUL SET TO 0
REALM RUNNING as realm id 1
and bla bla bla
etc.......but it still didint show me the GM Command in the window like KICK<BAN and etc....and i cant even type in my Mongosd.exe....Pls help.ok i see he showed me (check existing of map file '@prefix/shard/mangosd/map/0004331.map': not exist,and asking me to correct map file...what should i do now?if i can complete the map thing so i cant type anything in that Mangosd.exe black box?
you have a problem with your map extraction...
try extracting the maps again.. but this time, wait for the message "it's done" before closing the map extractor window...
MAP extracting takes time..
hope this helps.... and check your client version, should be 2.2.3
# solixes
Are you upgrading ? if so .. please wait i'm going to upload the updated batch file because i have made a big mistake ...
once again i'm really sorry for this
UPDATE: Download the updated batch file, or there's a high chance you'll lose your character data if you didn't backup your database first
YESSSSSSS,i m successful to log in my own personal provate account!Thx alot dude,but now how to create a GM account?lol,Since i had use CREATE to make an account,but that is not the GM account?may i know how to create a GM account?
Ok Reaper,i need some help here,not much lol.ok,done the GM acocunt,and the next step is how to get the item code for and the mount Chocobo and other mount?
aah you can use .lookupitem itemname to get the id
p.s look at the related links to see the gm command ;)
Ohok,thx alot ;).But now i cant connect to internet to let my friend connect to my server,i was stuck at .cos is always show error.
and i already register and account in dyndns.com.and add the bew host name and my IP in the host window.The problem now i cant even connect for myself lol.how?
Ok,at last,i just want to know how to make it Public i means let my friend can connect to my server,i used my ip (whatismyip) for my realmlist.exe,but it wont wont,i cant even connect for myself..roft..already register a host in DynDNS and make my host name...really dont know what should i do now...i m dump cos i really dont know about the internet setting...pls help..
Hi Reaper,
Am I able to add objects through my character on private server (mangos 4703)?
if so what command would i use?
my second question is what software would be suitable for designing 3D objects for WoW?
and last, how do i save newly made 3D objects onto my object data
regards Fungo
hey. really nice guide… <3 it!! but i have a problem… my enchants doesnt work… and i dont know why… i just click “enchant” and it does nothing… with mats / rod / all needed… and still not working.. any tips? thanks
# Brinuz
Did you click on the equipment / item you want to enchant after clicking the enchanting spell ?
# Fungo
I'd suggest you to pay a visit to mangosproject.org forum directly :)
# solixes
Have you configured your router to port forward first ? try visiting portforward.com if you're looking for help on setting up your router :)
yeap... i know how to work.. i got retail :> im doing everything right... it just work First enchant in all server... and never more..after that one (first)
can anyone tell me how to adjust the drop rate of quest item because it seems that the drop rate now is too low....
ok im at the point where u need to extract the maps but mangos cant find the file they are located in what do i need to do?
# Brinuz
Just tested it again and it works fine .. btw here's what im doing (although it is using gm status but i don't use my gm power except for the commands listed below) and here are what im doing to test it :
1. Create new character (blood elv because it looks cool) :P
2. type :
.levelup 69 to be a level 70 char with just the default starting equip
.money 9000000 (9M money) to learn the enchanting skill without gm power
.goc id 3345 (teleport to Godan, to learn enchanting in ogrimmar)
.addi xxx (to add random bracer)
and learn everything from Godan to a journeyman Enchanter level only
3. Add required item to enchant boots and weapon , and bracer
4. Enchant all of them ... without any problem :)
# justin
Drop rate of quest item ? actually quest item drop rate is 100%
# Shadelow
could you tell me what is the filename ? or perhaps the error message ?
hey reaper... found whats the problem..
i started like you said... (without gm power) and after 300/300 with all enchants learned (for lvl 300 enchant) it got ****ed up... what i mean... is that there is a enchant that is bugged... and make this happen.. wich i found what it was (for me) and it is: Charged Scale Of Onyxia... when i learn that enchant... i get that bug.. and cant enchant anything... you can try and test your self... (well for me thats the problem)
just tested it and it seems that if you have Charged Scale Of Onyxia in your enchanting skill, you won't be able to enchant your item :(
as a work around ...
type :
.unlearn 22434
yeap.. i allready solved that "little" problem.. thanks for tips :>
BTW -- this is about the Realmlist.wtf file -- you DONT have to replace everything with set realmlist "ip", your normal realmlist should look somewhat like
set realmlist eu.logon.worldofwarcraft.com
set patchlist eu.version.worldofwarcraft.com
Now, your told to replace it all -- You can also do it like this :
//set realmlist eu.logon.worldofwarcraft.com
//set patchlist eu.version.worldofwarcraft.com
set realmlist "ip"
I cant explain why, all i know is that the file doesnt make that readed, so now you dont have to backup ur file / know the realmlist + patchlist thingys, you can just remove the // and place // @ set realmlist "ip", now you can easily switch between your own server and other servers (Other private or the real one:)) (For some ppl it might be set realmlist us.logon.worldofwarcraft.com
blablabla:P
Thought some ppl might like this :)
i have a problem, i updated to 4703 and i DID have 1651 (or the most recent w/e number it is)
and every thing went fine, but then when i run mangosd it says: “Loading Game Object Templates…
SQL: SELECT MAX(`entry`) FROM `gameobject_template`
query ERROR: Table ‘mangos.gameobject_template’ doesn’t
Error loading `gameobject_template` table (not exist?) so, i dont know what to do, and also when i had 1651 i was able to open up wow, log in, but i could not loginto the server. please help
100% ?? but i can only got 4/10 quest items after hunting more than 20 creatures...
Hi reaper-x!
First of all, you are doing a really great job with this.
and now my Problem:
The previous 4651 release(which worked great thank you!) was installed on my computer.
I tried the upgrade option (99) for the 4703 release, everything went after plan, I tried to run it and realmd.exe worked just fine, but mangosd.exe couldn't connect to the characters database, and low and behold I look @ my database and a database characters was no there.
After finding this out I decided to nuke everything, reinstalled all of MySQL and followed all the instructions for a fresh install. It worked very good, no errors and the database characters was also created. I created new accounts and they all seem to be able to log in, and it works awesome.
my server worked over the internet, I played with some friends, and after this update, they try to connect with they're new accounts and they can't connect. I can connect just fine with they're accounts locally, but they can't connect externally outside of the network.
I tried a lot of things and nothing seems to work. I configurated the realm inside the with a dynamic IP address from No-IP service(witch worked fine before this update) and I configurated everything to be exactly to be the same as before, I can connect, but my friends can't.
I'm all out of ideas, would it be to much to ask for a little advice on how to fix this problem? Thank you very much for everything! you are awesome, and I hope you are able to keep up the great work you have been doing until now.
Thank you
-Death Scythe
Reaper,
I got it working, I had to uninstall everything, delete all SQL folders, and run a reg. cleaner to get rid of the registry. Then i started it all from scratch. It sucked, but I didn't know what else to do. Hope this upgrade is beter than the last. Still love your guides, With out them, i still wouldn't be able to get it up and running. Keep up the Great work.
Vile
Thank you so much man, this is all happen alot =)
buuut, I'm having trouble with the fresh install
i press 1...enter password... than it comes up with
'mysql' is not recognized as an internal or external command, operable program or batch file...
also is 127.0.0.1 supposed to be my IP, or just that?
reaper the mangos are great got them working
after a couple of goofs on my part
was wondering about the silvermoon to undercity portal not working right and also how to populate gmisland all the mangos i have found dont have any venders on the island did i do something wrong
thanks again for your hard work
vcain
Ya, bout that last comment... solved it =)
but seriously it is SO awesome i found u man
btw, i don't have anything in the vmaps folder... which is bad
the mangos.exe ain't finding any of the files, and than i can't go further by typin in the box
1.Do i know how to set all the character skill to make to stronger like change the character attack power,change the character stat,for example the player can hitted the damage more that 10kup.i m trying to use but its cant,only can set up the hp or other.
2.May i know how to set the boss skill to make the boss without the spell when we fight him?
3.some of my skill are missing,like rogue POISON,trying to use but it wont work...
pls help
# Colin
ah it seems your gameobject_template table in mysql database get corrupted, i'd suggest you to backup your character first (if you already created backup before, move the previous backup first to another directory) .. and then reinstall the database again
# justin
Probably that's one got messed up after the recent changes at the item database since the freeforall got introduced, btw did you set the drop rate to 100 or more ? because it'll cause some problem with quest item not dropped if you set it to high (the safe value is 10 or below)
# Death Scythe
Did you previously change the realmd port to another value ? (default is 3724)
or as a test purpose, make sure that the realmd and mangos process already running then go to this page :
https://www.grc.com/x/ne.dll?bh0bkyd2
and see whether port 3724 (or other port specified in your realmd.conf) is stealthed or not :)
# vcain
Unfortunately the NPC at GM island is custom made by Silvermoon database :( .. and since this one use UDB as it's database (because there hasn't been any update on silvermoon database) you won't find it ... unless you duplicate the creature used on the silvermoon database and move it over to this database
btw .. forgot to tell you this, if you don't mind having message about creature equip something being displayed (because im just doing a quick and dirty database dump) :P .. i can upload the ported GM Island npc from silvermoon so you can use it on UDB :)
UPDATE: you can download the GM Island npc now .. but don't forget that if you're upgrading you should also download the updated batch file too ;)
# The Dude
Did you wait for the vmaps extraction to complete ? (it's quite long actually to wait before it finished)
# solixes
1. Actually in order to do that, you'll need to create your own custom weapon (i'm currently working on writing this) :)
2. disabling boss skill ? you can do that by editing the database directly and remove the script for that boss name
3. probably it's not finished yet :)
Is this release compatible with Patch 2.3 that was released today? Or can we expect another Mangos release here, soon enough? ;)
hey, i keep getting this error message
c:\mangos\data/dbc/ItemExtendedCost.dbc (exist, but have 14 fields instead 13) Wrong client version DBC file?
any suggesions?
ChrisM,
It does not mather if they release a version of mangos for 2.3 because not even everything for 2.2 is still implemented.
If you by accident patched it up to 2.3, you can use this link but I can't garantee if it still works:
http://www.reaper-x.com/2007/09/29/how-to-revert-to-previous-wow-patch/
I just e-mailed you with this problem probelm.
But i fixed my realmd.exe back to the way it was i remembered how i changed the port 3724 to 6060. anyway..
I didnt see the updated bat untill after i did the upgrade, do you think thats why its trying to access my database with the username mangos? I just cant get it to connect, will i have to run the update again?
I cant afford to loose my characer data =(
If you could email me back Brybam@gmail.com i would appreciate it so much, i was hopeing you could just remotely connect to see what i'm talking about that would really really be awesome.
I just dont know where to go to get it to use root and use my password.
last update i did from you i didnt have this problem =(
Siegelink,
I do not wish to revert to a previous patch--I was hoping that I could play on my private server with all of the new 2.3 implementations. While I appreciate your help, I look forward to some commentary from Reaper-X, himself.
ok so reader, since i never made any chars because i had just finished installing 4651 when the new one came out, i should just run reaper-x-mangos.bat and select option number 1?
oops lol, * reaper
Yes will there be an update for the 2.3 patch that was released if not is there a way to make the server allow users with 2.3 patch on the server just not have any of the 2.3 features cause I would like to play on the private server and on real wow and i dont have enough hdd space to make 2 copies of wow and not update one. Great work on the server im using 4651
QUESTIONS FOR PATCH 2.3.0:
It is released, it released today for US and GB. Both of part 2 were done and so was the finishing files to install patch 2.3.0. I assure you that it is live. Now, how long will it take mangos??? I think a good week becasue of the guild banks unless they decide to skip this issue.
having problems with the teleport orb in undercity and silvermoon i enabled tbc and it wont teleport you to one or the other it just sends you 10 feet behind the orb how can i fix it
When I try to run both realmd.exe and mangosd.exe they both say This application has failed to start because MSVCR71.dll was not found. Re-insalling the application may fix this problem.
Thanks for the tip, this might sound extremely unintelligent, but what would I do if it is stealth ed? is that good or bad? how would I be able to change it?
Thank you
-Death Scythe
Ok forget the first comment, I found my windows disk and installed .net 1.1, now when I start mangosd.exe it appears and dissappears right away, and realmd.exe says
"
Using configuration file realmd.conf.
MaNGOS realm daemon / Reaper Mangos 4703 SD2 156 0.9.0-SVN http://www.reaper-x.c
om
to stop.
Database: 127.0.0.1;3306;mangos;mangos;realmd
MySQL client library: 5.0.45
Could not connect to MySQL Database at 127.0.0.1: Can't connect to MySQL server
on '127.0.0.1'
Cannot connect to database
"
Sorry - I am sure this gets asked a lot - But is there a webpage that lists the changes made to the database? Like which tables are altered etc?
I ask because I have been looking to change a lot of the specific data in some of the table (such as drop rates for quest items, as well as adding descriptions for many of the items.
However if each update would require that much of the database if wiped I would obviously be wasting my time doing so.
Thanks folks.
# Colin
Now that's the first time ever i saw someone misstype Reaper to Reader rofl :P
As for your question, yes .. all you have to do is just choose option 1 and do the rest of fresh installation steps :D
# simon
sure you can always get the update from here
as for listing each value, you can see the sql file directly :)
btw i think for the next release i'm going to use update method so it doesn't overwrite anything you've created before ;)
# Taellon
Have you installed Mysql first ? and make sure that it's already running ?
as for mangos close itself automatically, try running option #4 in reaper-x-mangos.bat to create the mangosd.conf
# Death Scythe
No worries beside there's no such thing as extremely unintelligent question ;) .. btw actually stealthed or not accessible might be good if you've configured your firewall to block access to that port (which mean your firewall works)
but if you're going to run mangosd in default port (3724) and you see it's stealthed, of course your friends won't be able to connect to your server
as a side note, actually if you allow WoW Client to download update in the background, it's using the same port too (blizzard update is using Peer to peer network like Torrent) and it use 3724 as it's port which cause conflict with your realmd port configuration
to fix it :
1. open realmd.conf and change port 3724 into another value
2. ask your players, to change their realmlist.wtf file to :
set realmlist YOUR_SERVER_IP_OR_DNS:REALMD_PORT
that's it :)
# vcain
You'll need to edit the database directly :)
# Jared, William, or other who just updated to Patch 2.3.0
Unfortunately, this time you'll need to wait for mangos to fully support it because some of the client files are changed and in this case it's the dbc file (ItemExtendedCost.dbc from 13 Column to 14 Column)
As a side note, actually i have tried to made some changes so i can bypass that error message when reading the dbc file ... and although it works and i was able to login and select my character, but right after i choose my character the WoW process crash to desktop and ask me to send the error report (obviously i'm not going to send it) :P .. and this happen even with just a newly created character
So i guess the only solution for now are :
If you're playing on official server too :
- Create a duplicate copy of your entire WoW game installation directory
- Set the realmlist.wtf in one of the new directory you've created to the official server address
- And revert the copy on another directory to WoW 2.2.3
for more info on how to roll back wow patch :
http://www.reaper-x.com/2007/09/29/how-to-revert-to-previous-wow-patch/
# ChrisM
Unfortunately even if i was able to allow you to login to 2.3.0 server, it's still need some database update too :)
RE: btw i think for the next release i’m going to use update method so it doesn’t overwrite anything you’ve created before ;)
ooh - great news.
Alright. Thank you -- I guess I will check back for more updates, here soon enough (I hope).
Have a good one; and thanks again, for everything! (Great guide...)
Does the "Gurubashi Arena booty run" event work in this?
And please make a guide how to add custom portals :D
hm...just update patch to 2.3.0....i cant connect to the server anymore....what should i do and update my mangosd?
The first boss of Karazhan is bugged.
and the event in karazhan where you get 'onstage' doesnt work =p (like with the big bad wolf &nd so)
Hey reaper i'd really appreciate it if you could take a look at this http://i36.photobucket.com/albums/e31/bamabam/Photo266.jpg
I get that every time i start up mangos.exe i did nothing different than the list time i upgraded, i did backup, upgrade, restore and now it's doing this it looks like it's trying to log on with the username mangos, i have no idea how to fix this. If you could help me that would be a real lifesaver, my servers been down for a day now im gonna loose players =(
hey reaper the new patch is out ^^
will you release another version of mangos for us please?=P
ty ^^
PS: us=we XD
Ok I'm getting tired of this dump command not working. First of all I never had a problem with installing and setting up my server with Mangos 4651.
Since I didn't have any problems I thought I'd transfer the characters one at a time from one server to another, same as "jumping". I typed writedump and loaddump like you said to on the Mangos 4651 thread but it says "Unknown Command".
I gave up on trying to jump my chars and thought that the dump command might work after this update to 4703. So when I go to backup my characters with the backup option in your batch file it says " 'mysqldump'is not recognized as an internal or external command, operable program or batch file." Why does everything else work for me but not the dump commands?
If I could find out this problem it would help me solve my "Jumping" problem and my problem with backing up my characters. Thanks.
Ok... I changed my IP from LAN IP to the loop-back IP and now the batch file can recognixe the mysqldump command... but now it give me error 1044.
Saying "Access denied for user 'mangos'@'localhost' to database 'characters' when selecting the database" and the it follows with:
--Connecting to localhost...
--Retrieving table structure for table account...
--Sending SELECT query...
--Retriving rows...
--Retriving table structure for table account_banned...
--Sending SELECT query...
--Retriving rows...
--Retriving table structure for table ip_banned...
--Sending SELECT query...
--Retriving rows...
--Retriving table structure for table localization...
--Sending SELECT query...
--Retriving rows...
--Retriving table structure for table realmcharacters...
--Sending SELECT query...
--Retriving rows...
--Retriving table structure for table realmlist...
--Sending SELECT query...
--Retriving rows...
--Disconnecting from local host...
Done
So... pretty much to save my characters all i have to do is copy the files for account, account_banned, ip_banned, localization, reamlcharacters, and realmlist? I know where to go to get to those files... but isn't there more to it than just that to save the characters?
What this batch file just did is went through realmd and grabbed those files... doesn't it have to go through mangos to grab the character and pet info as well?
Well I hope to here from you soon Reaper... hope you can tell my why I'm getting that error and if I'm right about the copying files to save my characters part. Thanks.
Sorry for the triple post... it seems like i solve my problems shortly after I post them on you thread lol.
I used your batch file from your Mangos 4651 to backup my characters and it worked! But for some reason when I tried it with your Mangos 4703 batch file it couldn't find it the first time and the second time it gave me an error.
So just ignore my first two posts above since I already solved it and answered all of my own questions on my own lol, but thanks anyways. :)
says Error: Table 'realmd.realmlist' doesnt exist when i load up realmd.exe the other one works mangos.exe
help please
# Zenn
No problem actually ;) .. as for the 4651 and 4703, actually the backup file in 4703 is called backup-char instead of backup-db, btw actually you just need to use the reaper-x-mangos.bat included in 4703 (it's better if you get the updated batch file especially if you're going to upgrade)
as for writedump actually it should be called writepdump and loadpdump but i think it's a lot better to dump the character table manually (though the above two command also does the same thing as well with the only differences it dumps the data only) :)
# Neirti
Are you doing fresh installation ? if so .. try choose the first option to reinstall the database again :)
# bamabam
Did you get the updated batch file and overwrite the old one included with 4703 ? because it's important to get the updated batch file especially if you're upgrading
# Elem
Unfortunately the 2.3.0 is still not supported yet but when it's already supported of course i'm going to release the next update :)
the only solution for now is only to roll back to previous 2.2.3 patch ;)
2007-11-14 15:52:54 Using configuration file realmd.conf.
2007-11-14 15:52:54 MaNGOS realm daemon / Reaper Mangos 4703 SD2 156 0.9.0-SVN http://www.reaper-x.com (Win32)
2007-11-14 15:52:54 to stop.
2007-11-14 15:52:54 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-11-14 15:52:54 MySQL client library: 5.0.45
2007-11-14 15:52:54 MySQL server: 4.1.22-community-nt
2007-11-14 15:52:54 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone`,`allowedSecurityLevel`,`population` FROM `realmlist` WHERE `color` != '3' ORDER BY `name`
2007-11-14 15:52:54 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2007-11-14 15:52:54 ERROR:No valid realms specified.
still getting it :(
lol, ya im special like that, randomly add letters...lol reader...
Ok,in my router to forward port has port start and port end,so i need to use port start at 3724,port end at 8085?or just use 3724 on start and end port?2nd question is for my firewall setting,in my fire wall exception i already edit port for WOW and port number 3724 to allowed the other connection to connect to my server,so do i need to set another edit port for 8085 WOW in my firewall setting?As lke i lsaid previous i can connect to my game well,but my friend is stuck at the realm,he cant log in to realm,but he can access to username and password,but after log in just stuck at the realm…cant creater character…keep jumping out the realmlist,what should i do now?thx for the help :)
ok, perhaps one of my very last and maybe simplest questions...
i just downloaded the patch for 2.2.3
and i did all of this before, so would that effect everything?? would i have to re-download the maps, etc..? if so please let me know =)
ah my bad 2.3... if you've solved that problem, been looking at previous replies and wondering if they workd n stuff
Oh yea,and what is Local Ip address?Cos the port forwarding is required LOCAL IP ADDRESS,so is my Lan IP,Public IP or Router IP?Atm i am using Lan IP(192.168.1.1)for the Local IP address column..isit correct?
lol, yet another problem, whenever i run wow.exe using my real as realmlist, i get "unable to validate game version" error message but when i run any other realmlist, it works...what should i do? reinstall the mangos maybe?
no =( i used the old one, i didn't noticed there was a new one untill after i started hving problems then read this article closer =( thanks for responding to my email, i got the realmd.exe working right cuz i fixed the port, problem but im still having the error when i load mangos.
since i've downloaded the new bat, im going to back, update again then restore, and pray i dont loose my char data. Though the reason im taking this gamble is because i used minimanager to make a sql file of all the accounts created and char info, so i guess if it screwes up i can load it with minimanager...thats IF the new mangos has the same tables. /crosses-fingers
Id just wait for you to get on msn but our time zones are so different lol Eastern USA here.
i duno why i typed it like that...i mean im goign to just backup, update again, then restore the char data again (all using the updated bat file). and hope i didnt loose anything
#Reaper-x
Thanks for pointing out the p in writepdump and loadpdump I didn't see that lol, I must have overlooked it.
I tried backing up my characters using the 4703 batch file but it was giving me an error... but I found the 4651 batch file to work for me lol.
So what I did was I backed up my characters using the 4651 batch file, then I updated mangos to 4703 using the 4703 batch file, and then I went back to the 4651 batch file and reloaded my characters. :)
I think that works the same way... at least I hope it does cause the 4703 batch file kept giving me errors when I tried to backup my characters.
well, i used the new batch file and i updated successfully.
but, now when i log in with any account it does work, but there are no characters.
I logged into navicat and i see there is a new database slot so i took all the old data and copied it form my mangos databse to this new character database, now characters appear. But once i log in they have no bag in their bags slots and have no gear. I check to make sure i copied them right and i did. =/ sucks i duno what do do becides tell ppl on my server sorry lol.
# Reaper-X
Ok now I have a new question for you since you found out my last problem lol.
As a reminder of my last problem I left the p out of writepdump and loadpdump. I've messed with it a bit but it's giving me an empty file named Program on my C drive. I created a test character called Pala and the GUID is 9. Could you give me an example of what I should be doing using this info so I know what to do. Thanks.
Reaper,
Thanks for publishing these howto's. I'm looking to make some machinima with my cousins and brother.
So far no problems. Well, I had two problems.
The first was when I first ran mangosd it said it could not connect to my sql server; but I think that was because I changed my sql port to TCP 156 from default 3306 because I misread your post.
Next problem was that I had WoW 2.3. So I'm reverting atm to 2.2.3
Anyways, thanks for the detailed instructions on hosting a private WoW server. It is appreciated, and I'd give you a tip but you don't have paypal setup in that way I'm sure.
# Neirti
Are you doing fresh installation ? if so try reinstalling it again, because it seems the realmlist table is not properly created :)
# Error!
Actually that's depend, if you have extracted the maps, vmaps, and dbc files from wow 2.2.3 .. and put it in different directory, then you don't need to re-extract it anymore
but if you just extracted all the data files from wow 2.3.0 .. then you need to re-extract it again
btw .. if it's for me, i always keep all the data files extracted from previous version especially if there's a major upgrade going on (such as from 2.2.x series to 2.3.x or 2.1.x to 2.2.x) because you'll never know if the new data format is compatible or not ;)
# solixes
Ah your lan ip is the ip address used on your lan card to connect to your router, for example :
Router : 192.168.1.1
LAN Card connected to router : 192.168.1.2
Public IP : 123.123.123.123
that mean you need to write 192.168.1.2 as your lan ip address in your router port forwarding configuration page :)
# Colin
Ah it seems that you just recently upgrade your wow version into 2.3.0 and currently it's still not supported yet :( the only solution for now is to revert to 2.2.3 :)
# bamabam
If you still have the backup file and don't mind sending me the backup, you can send it to my email address and i'll convert it for you :)
# Zenn
Based from your description, you just need to type
writepdump outputfilename 9
and if you type the above command you'll get a filename called outputfilename in your mangosd directory where mangosd.exe can be found
as for the restoring, actually you need to know your account id first (you can look for your id in realmd database under accou