Custom Search
Mangos 4577, ScriptDev2 140 with PSDB and UDB work with WoW 2.1.3 to 2.2.3
Posted by Reaper-X Oct 10 2007 2:25 am
Another WoW Mangos Release, and this time the WoW Client Supported is from WoW 2.1.3 into 2.2.3, but please note that currently the Mangos team still hasn’t fully support the 2.2.x client yet so you might see various opcodes related message being displayed on your mangosd window. Though it doesn’t really affect the gameplay itself, because i have tested this release with the newly released WoW 2.2.3 and … so far everything is working (unless it’s database related of course)
Anothing thing to note is, if you get various database related error message such as Item (Entry: xxxx) have wrong (not-existed) spell in spellid_1 … and so on when you run the mangosd.exe process, you can just safely ignore that message … because i also get that message but still the mangosd server process is still up and running and i can play just fine ;) … and no … mangosd process isn’t crash even when i talked to city guard in various place :P
As a lasy note, this new release contain two database from Project Silvermoon and Unified Database so you can switch between those two database freely and decided it by yourself which database is good for you
Screenshot taken using Silvermoon DB
Okay and here are the steps …
Requirements :
Update : Mangos 4602 has been released :)
- MySQL (required in order for Mangos to work)
Mangos 4577 ScriptDev2 Rev 140 with Project Silvermoon 18 and Unified Database 0.7.5 | 14.1MB | RapidshareMangos 4577 ScriptDev2 Rev 140 with Project Silvermoon 18 and Unified Database 0.7.5 | 14.1MB | Megaupload
Fresh Installation :
1. Extracting VMaps, Maps, DBC and configuring it (to make thing easier, i’ve created a separate guide for it)
2. Extract the self extracting 7–zip archive somewhere, or you can choose to extract it in current directory. And you’ll get ReaperMangos4577 Folder
3. Go inside the reaper-eazy-mangos directory and then run the reaper-x-mangos.bat , and you’ll be prompted with this screen :
All you have to do is just write the full path into your MySQL bin directory (where mysql.exe can be found)
Note : The above step is important, if you don’t write the correct path you’ll get problem later
4. Now you just need to choose option number 1 (Install), and insert your mysql root password when prompted)
5. Now you need to configure which database you’re going to use in your Mangos Installation, in this release i have included Project Silvermoon Database and Unified Database. In below example, i choose the Unified database
As a side note, you don’t need to worry about choosing the correct database because you can always switch it later even if you already created your character with full set equipment. I choose to include 2 database so you can pick which one perform best for you
6. When you’ve finished the above process, now you just need to choose option number 4 to configure your mangos installation
If you follow my previous post about the Maps, VMaps and DBC extraction guide … you can just simply write C:\wow\data when prompted for your data directory. As for the rest (adjusting the rate) i think it’s self explained :)
7. Go to your WoW installation directory and open the realmlist.wtf file
and change the realmlist into using this one :
set realmlist 127.0.0.1
8. Run mangosd.exe and realmd.exe
9. Create new account as shown like below image for an example :
10. Done :)
Switching Database or Upgrading :
1. Run reaper-x-mangos.bat and then choose to backup your character
2. Now choose the first option (Install / Upgrade) and continue with the step until you get back to the main menu
3. Choose the third option (Restore Backup) and you’re done with switching / upgrading database
To those who’s upgrading from my previous release
4. Choose the fourth option (Mangos Config Editor) to adjust your datadirectory, and if you already configured your server to be accessible from LAN then you’ll also need to choose the fifth option to adjust your realmlist again
Here’s a screenshot taken using Unified Database (and yep i almost die there even with Custom Weapon that gives all stats plus 1000 bonus) :P
Related Link :
Official Project Related Link :
- Official Forum of Project Silvermoon
- Official Forum of Unified Database (Previously called SDB before merged with MoDB)
Of course the above already tested with WoW 2.2.3 enUS Client :)
Forgot to tell you this, but just in case you want to try my character that is usually shown on my screenshots, i also included my backup character for you to use :) … all you have to do right after installing the database, just choose the restore backup option
Note: If you choose to restore my character backup directly you’ll lose all your character data
The username to login using my test character is Reaper and password is reaper .. enjoy ;)
Trackbacks/Pingbacks
Leave a response
Connect with me
I need help when i do
.goxyz -2128.12 -1005.89 132.213 169
thats to ED
i cant get in it my server crash how can i fix this and go in ED?
I’ve got the same problem as Koolcole..
Hey there i am getting an error trying to run Realmd.exe or mangosd.exe
Realmd.log
2007-10-15 03:49:23 Using configuration file realmd.conf.
2007-10-15 03:49:23 MaNGOS realm daemon /Reaper-X R4577 0.8-SVN http://www.reaper-x.com (Win32)
2007-10-15 03:49:23 to stop.
2007-10-15 03:49:23 Database: 127.0.0.1;3306;root;root;realmd
2007-10-15 03:49:23 ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t create TCP/IP socket (10050)
2007-10-15 03:49:23 ERROR:Cannot connect to database
Server.log
2007-10-15 03:49:54 Using configuration file mangosd.conf.
2007-10-15 03:49:54 MaNGOS daemon /Reaper-X R4577 0.8-SVN http://www.reaper-x.com (Win32)
2007-10-15 03:49:54 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
Reaper-X R4577 SD2-140 http://www.reaper-x.com
2007-10-15 03:49:54 World Database: 127.0.0.1;3306;root;root;mangos
2007-10-15 03:49:54 ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t create TCP/IP socket (10050)
2007-10-15 03:49:54 ERROR:Cannot connect to world database 127.0.0.1;3306;root;root;mangos
Any help thanks
-Emerged
hi i have a problem when i log me on i come to the realmlist but i cant enter in the server
d: YES)
Can u help me ??
I have a problem when i put my mySQL bin path and my password it says ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using passwor
in mangosd and realmd that is
I have changed some stuff around, but now it just says cannot access database…why would it do this?
One more thing. When I use an older Mangos.exe it loads completely but ingame it is unable to validte game version. I have 2.2.3.
When I use your new one I get an error in ‘item_template’ table, probably sql format was updated (there should be 138 fields in sql)
Mangos also says the following: SQL: SELECT ‘version’FROM ‘db_version’LIMIT 1 query ERROR: Table ‘mangos.db_version’doesn’t exist
I got so far that i could run mangos.exe and all other things were set up.
But where I did not have any problems before now I get the following message when Mangos is loading items. Message says: Error in ‘item_template’ table, probably sql format was updated (there should be 138 fields in sql). What should I do now?
When I extract the vmaps using “makevmaps_SIMPLE.bat” it only extracts maps starting with 000 and not with 001 as required by mangosd:
“Cound not find vmap file “001_33_39.vmdir”"
Ok I’ve done everything right (I hope). This is my first time using mangos and when I go to start the realmd.exe and mangosd.exe files they give me errors saying the program is missing MSVCR71.dll. Is there a core program I need to download and install an update to it or is there something wrong with my extraction process?
# warriorccc0
if you’re looking for the mangos database name (if you’re not changing anything), you can use this info :
db name = mangos or realmd
user = mangos
password = mangos
that’s the default that came with mangos :)
# Cyrrus
You need to use the same realmlist ip address, for example if your public ip 123.456 then you’ll need to change the realmlist to 123.456
if your friend still having problem with it, i’d suggest you to change the realmd port into something else (default 3724) ;)
# WaLshy
Unfortunately not all bosses have been scripted :(
# NiceAsap
I havent tried using the wow-v weapon creator so i can’t give any more info about it (im using the manual way to add custom items) :(
# Jason
Unfortunately that’s database related, perhaps udb team prefer not to include it by default :)
Its good, but im trying to get quince to work (google it if needed, its a tool to edit the database to add custom items and stuff) well im not sure how to get it working it asks for the database name, the username and pass and I can’t seem to get it to work, if you can email me with what Im supposed to enter then ill thank you. my email is mr.noise@hotmail.com
my freind can log in to his account but when he clicks on the realm it cant log in to it, it just reverts him back to the realmlist. any ideas?
How to I make bosses work? They are just auto atking. Do I need to activate something? Ive tried both databases and none work with bosses.
Please help me!!!!
Didn’t know where else to put this, but here we go:
Everything worked out PERFECTLY. Everything works as it should, my friends could connect (through hamachi, my own choice), the server hasn’t crashed at all. Great work, Reaper-X :)
But then I started adding custom items (created at http://www.wow-v.com). Thought it was awesome, added a few more, and then something happened, some sort of error occured. While I was starting up mangosd.exe, this message came up, right after “loading items”:
“This aplication has requested the Runtime to terminate it in an unusual way. Please contact the application’s support team for more information.”
I Don’t have any idea of how to fix it -anyone got some advice?! I am using Navicat 8.0 to configure MySQL.
well, i had plenty of free memory, and how do you re import the database?
I’m using the patch 2.2.3 european version btw. :)
Hey Reaper-X. I just followed your guides on how-to setup the server, however when i try to run Mangosd.exe I got an error and it crashes at 20% loaded or something, screenshot here: http://img509.imageshack.us/my.php?image=unavngivettg3.jpg
hey Reaper-x, this is an awesome guide, but when i open up mangosd and realmd, it says access is denied for mangos@localhost and cannot access database or something like that, any idea how i can get these programs to work? i cant type anything in there, so i cant make an account
I’m trying to create a custom weapon, but when I open any item_template folder all that comes up are random letters and symbols.
Check existing of map file ‘C:\wow\data/maps/0004331.map’: not exist!
Correct *.map files not found in path ‘C:\wow\data/maps’ or *.vmap/*vmdir files
in ‘C:\wow\data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate d
irectories or correct the DataDir value in the mangosd.conf file.
I also have troubles with this error, i redid the staps of this part like 40 times and i still gives this annoying error.
Reaper,
I was wondering why not all databases have the NPCs at GM Island? It makes it easier when wanting gear instead of having to do the .additem or .additemset
Love the builds Reaper, but has anyone created the “Sword of A Thousands Truths” from south park?
No prob B
Raz in the PSDB 18,5 (if your using it) are mods still overpowered as in 18, and are gold drops still messed up ‘as every monster of same type drops the exact amount money’???
PLZ HEKP !!!
4th stage of installation and it only says when I but my pas (tryed many times the pas)
ERROR 2003 : Can’t connect to mySQL server on ‘localhost’
ok wow lol i figured it out…thanks alot Magnus!
ummm? help?
May I ask a question, how to active the scriptdev2
effect, why I ask is because most of the boss seems only auto-melee instead of casting a single magic spell except Onyxia. Thx
# Balron
The “i” column was used to stored your character password, and btw could you tell me from which revision of mangos you’re trying to upgrade your mangos core ?
It is an older version rev 3879 (very old), also not a build you made (hence where some of the problems may be). I am able to create any new account without issue and can access the server. However I must change the password field to I for this to work. I am also able to see all the restored data from old mangos but when i log in it just hangs. In realmd i can see it has accepted a connection but nothing else. Any new account accepts a connection and authenticates. Sorry for the long post.
# jordavious
unfortunately that’s because mangos doesn’t support the 2.2.x version yet :)
as for psdb, it seems their website still down (tested with various online ping tool)
for example siteuptime.com (try checking their domainname using siteuptime and you’ll see their website didn’t even respond to a ping)
# Siggy
If you still get that error message even after waiting for more than 20 minutes while loading mangos, i’d suggest you to import the database once again
and if it’s still stuck at the same part, i’d suggest you to check your free memory (mangos use 128MB, and Realmd 3MB when started) and close any background application
# metaltildea
actually i’m in progress on compiling the 4590 .. though it’s not going to be released (i think it’d be best to wait until mangos reached 46xx lol) ;)
I always like testing your revisions i just noticed 4588 came out are you going to make another repack out of it? :)
#RazMaTaz
where do you get the 18.5 silvermoon db… i tried to go on the forum but i got a timeout from the website…
could you put a link or something…
Thanks !
does anyone have a link or knows where i can get project silvermoon rev 18.5, project silvermoons site has been down for a few days now
and thank you for all of your help Reaper-X
18.5 psdb is working with pet food.
update, if i use wow ver 2.2.3 the channels dont work, but if i use 2.1.3 the channels do work, but that still doesnt really help with the problem.
sorry for all the posts but that last post was supposed to be read:
to be more specific, once you /leave xxxxx, you can’t /join xxxxx. the only way that i have been able to even kind of fix this problem, is deleting my account then remaking it.
thank you,
jordavious
to be more specific, once you /leave xxxxx, you can /join xxxxx. the only way that i have been able to even kind of fix this problem, is deleting my account then remaking it.
thank you,
jordavious
one more question, after 2 days of testing the new setup, my testers finally realized that the standard chat channels are not working (general, lookingforgroup, etc….). i am using Mangos 4577 ScriptDev2 Rev 140 with Project Silvermoon 18. guild chat, party chat, and whispers are all working, but the other channels arnt, off hand would you know if this is a db issue or a core issue. i would really like to fix this problem
thank you
jordavious
ok, so im a moron . . . i simply had to reinstall MySQL because my former tries were messing me up, but now im having a different problem :(
when i run mangosd.exe it stops doing anything at
“Loading Item Random Enchantments Table . . .”
Going on hour 7 now . . . what do i do?
# Phen
Phen, yes unfortunately if you have made custom stuff (weapon, etc) it’ll be deleted automatically :( because it’s database related (as for mangos you dont have to worry about it)
but actually i have anticipated that too :)
for example if you’re using my previous 4535 release, all you have to do is just import each sql update file that has any core number above 4535 which is located in originalsql/mangos4577 directory :)
# LordBelial
You can change it by editing the mangosd.conf especially at this line :
PlayerLimit = 100
the above is the default value included, and if your friend having problem to connect to your server, that mean you didn’t configure your Realmlist IP address properly (and if you’re using / behind router, you also need to set up some port forwarding first)
# Taniwha
Could you tell me are you trying to connect to your server from another computer or the same computer as the server process ?
# elliott
i assume you have configured apache with php in your computer, so all you have to do is just put that registration page in your apache document root directory (to configure the registration page, you’ll need to read the readme file included with that template of course)
yeah i hae no clue how to get a regestration to work
btw your a legend
PLZ need to know how to change max user, my friends cant access from their pc’s, everything works perfect as i can log in no problem
Hey Reaper, nice work.
Can you give me some guidance??? Everything seems to load correctly and I can authenticate, but can’t access the game server. Any help much appreciated.
nvm to last comment, how to i change the max users?????? btw server works perfectly
So I can still upgrade from one of your previous packs to this without danger when I am using the 2.1.3 client? (I just don’t want to add issues I did not already have.)
I wonder how switching the databases will work, too. Do you think this will delete my custom items? (I backed them up anyway, so I can re-import, but I am interested.)
I assume upgrading the MaNGOS version will delete all the .tele locations I added, yes?
Sorry for all these questions, and thank you!
# Siggy
Could you tell me which mysql version you’re using ? i’ve tried on both Windows x86 using Mysql 5.0.45 series, Linux x86 5.0.22 and 5.0.45 and it worked just fine :)
# jp
Try make sure that mysql service has been started (look under process list tab via task manager), and has been configured properly
# jordavious
Unfortunately i don’t have the 18.5 yet (it seems that PSDB site down and it has been 3 days)
# Balron
The “i” column was used to stored your character password, and btw could you tell me from which revision of mangos you’re trying to upgrade your mangos core ?