Custom Search
WoW Mangos 4488, ScriptDev2 134 with Project Silvermoon DB Rev17
Posted by Reaper-X Sep 21 2007 3:29 am
I just compiled another Mangos revision and this time it is using Mangos SVN Revision 4488 with ScriptDev2 revision 134 (it’s clean compile without any other patch). As a note, i only tested on my own computer using World of Warcraft The Burning Crusade 2.1.3 enUS client, so if you’re using other client version i don’t know if it’s going to work or not with your wow tbc
The first file is to those who’s already have Mangos database installed and already configured, and don’t want to start all over again (i assume you already know on how to upgrade your mangos database) :) … so all you have to do is just importing the mangos core updates and the scriptdev2 sql into your database and you’re finished
Update : I just released the new Mangos 4505 with Scriptdev2 R136, so try using the new version instead :)
#1 – Mangos R4488 with ScriptDev2 R134 (DBC Extractor, VMaps Extractor and Map Extractor Included) (2.14MB)
While the second file, is to those who’s just want a fresh start or want to create their own private wow server for the first time (i know the pain of using slow internet connection to download large file). The only differences between this version with the above version is, this version include the Project Silvermoon Database Revision 17 (and all the necessary sql update already included too). So without further ado here are the steps :
#2 – Mangos R4488 with ScriptDev2 R134 and Full Database Dump (DBC Extractor, VMaps Extractor and Map Extractor Included) (9.98MB)
Update : To those who’s having problem on extracting the DBC files, i just uploaded mine (WoW-TBC-2.1.3–enUS DBC 2.85MB) … btw because i’m using the enUS client i’m not to sure if it’s going to with other region version, but it’s not hurt to try, right ?
Note : I assume you’ve configured and installed MySQL properly, if you want to know how to install MySQL, refer to my previous post about MySQL installation Guide for Windows
Note 2 : Adjust your World of Warcraft Game installation path accordingly
1. Extract the rar archive somewhere, for example C:\Mangos
2. Open Command Prompt
3. Execute these commands (must be in order) :
- cd C:\Mangos\reaper-eazy-mangos
- mysql -u root -p -v < drop_mysql.sql
- mysql -u root -p -v < create_mysql.sql
- mysql -u root -p -v -D realmd < realmd.sql
- mysql -u root -p -v -D mangos < rx-mangos-4488-silvermoon17-scriptdev134.sql
4. Copy the ad.exe from MapExtractor Directory into C:\Program Files\World of Warcraft
5. Create new folder called maps, and then run the ad.exe … and wait until this process finished (don’t interrupt it)
6. Copy all files inside VmapExtractAssembler into C:\Program Files\World of Warcraft and run the makevmaps_SIMPLE.bat … and wait again until it finished
7. Copy all files inside DBC Extractor into C:\Program Files\World of Warcraft\Data\enUS … and run the extract.bat … and wait until it finished
8. Move vmaps, maps, and dbc folder from your World of Warcraft installation path into C:\Mangos\data (create folder named data first)
9. Open Mangosd.conf using Wordpad … and then find this line :
DataDir = "@prefix@/share/mangos"
Change it to :
"C:\Mangos\data"
10. Open realmlist.wtf file from C:\Program Files\World of Warcraft using Notepad and change the :
set realmlist us.logon.worldofwarcraft.com
into
set realmlist 127.0.0.1
11. Run Mangosd.exe and Realmd.exe …
12. At the Mangosd window type these :
create myusername mypassword
setgm myusername 3
13. Run World of Warcraft … and then login using myusername as username, and mypassword as password
14. Done …
As a side note, if there’re many people downloading this … perhaps i’m going to simplify the steps in the future by creating batch file :)
And to those who prefer to see a detailed guide with images, feel free to look at my previous post about Creating WoW Private Server … enjoy ;)
And here’s for the list of Mangos GM Commands
P.S If i’m missing something just let me know about it
Trackbacks/Pingbacks
Leave a response
Connect with me
nothing helps :( and im using xp pro
reply
they both keep running and i can run commands at mangosd and they both doesn’t close.i think it may be firewall proplem?
Sry for bothering you.
# Adcox
Now this is really strange, my suggestions are :
1. Change the port used by mangos and realmd, the default realmd try to bind to port 3724 (realmd.conf) while mangos bind to 8085 (mangosd.conf) so try using other numbers first
2. If the above still not working, try disabling firewall, and run the mangosd and realmd process again
3. if the #2 still not working, try rebooting your computer, and after logged in into your computer, disable firewall and then try running mangos and realmd again
that’s it
btw what OS you’re using ?
# hesham
btw after the handshake process, does the mangosd process and / or realmd process close itself automatically ? or does both of them still running ?
reply
It seems to work propeply caus eit doesn’t give any error and that is the server log file:
2007-09-23 22:31:58 >> Loaded 8 battlegrounds
2007-09-23 22:31:58 Loading Transports…
2007-09-23 22:31:58
2007-09-23 22:31:58 >> Loaded 9 transports
2007-09-23 22:31:58 Deleting expired bans…
2007-09-23 22:31:58 Starting Game Event system…
2007-09-23 22:31:58 GameEvent 10 “Gurubashi Arena Call to Fight (Night) Added By CDWriter” started.
2007-09-23 22:31:58 GameEvent 5200 “Shattrath City -Alive- Added by CDWriter” started.
2007-09-23 22:31:58 WORLD: World initialized
2007-09-23 22:31:58
2007-09-23 22:31:58 mangosd process priority class set to HIGH
2007-09-23 22:31:58
2007-09-23 22:34:00 GameEvent 5200 “Shattrath City -Alive- Added by CDWriter” removed.
Then all everthing is allright but i keep disconnecting from my server.
nothing uses this ports…
okay then that mean mysql worked just fine because it can bind to port 3306
now you’ll need to see if there are any applications using port 3724 and 8085
try running the netstat /an once again
its still the same…
server log:
2007-09-23 21:03:27 >> Loaded 9 transports
2007-09-23 21:03:27 Deleting expired bans…
2007-09-23 21:03:27 Starting Game Event system…
2007-09-23 21:03:27 GameEvent 10 “Gurubashi Arena Call to Fight (Night) Added By CDWriter” started.
2007-09-23 21:03:27 GameEvent 5200 “Shattrath City -Alive- Added by CDWriter” started.
2007-09-23 21:03:27 WORLD: World initialized
2007-09-23 21:03:27 ERROR:MaNGOS cannot bind to port 8085
realmd.log:
2007-09-23 21:03:25 Using configuration file realmd.conf.
2007-09-23 21:03:25 MaNGOS realm daemon /0.8-SVN (Win32)
2007-09-23 21:03:25 to stop.
2007-09-23 21:03:25 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-23 21:03:25 Added realm “MaNGOS”.
2007-09-23 21:03:25 ERROR:MaNGOS realmd can not bind to port 3724
# Adcox
Now try running the mangosd.exe and realmd.exe, and if you still get the same error message (like mangos open and close itself automatically)
open the server.log to see what’s the error message ;)
# Zack
No problem Zack, and im glad to hear that you’ve fixed the problem :)
# Spamike
actually i fetch it from the ascentemu svn (previously named antrix) :P
here’s the svn info for ascent
[me@localhost svnapps]$ svn info ascentemu/
Path: ascentemu
URL: svn://emupedia.com/svn/ascent/trunk
Repository Root: svn://emupedia.com/svn/ascent
Where exactly does that DBC Extractor come from? I can see in the Mangos compile from the SVN Repository where I can get the ad.exe, as well as the vmaps bat files . . . but I can’t see where to get my own DBC Extractor. I know I can simply download somebody else’s DBC Extractor, but I would like to know where I can get my own from the SVN Repository.
Thanks
it vorks i tell you! thnx a bunch for help reaper…it really is a great guide
srry for wasting forum space
- Zack kicks himself in the butt -
nvm fixed that one lawl
mysql is startet an the port 3306 is listening… and now?
well now my mangosd ain’t workin
try it first just to make sure (don’t worry it just 2.85 MB) ;)
i have a britsh client i thought that meant i can’t use your uploaded ones
# Zack
if you’re having problem you can always get the extracted files directly ;) (that’s why i uploaded it)
# hesham
See the server.log so i know what is the source of the problem
reply
sry i was using wrong config file but i use ur config file and it is working without making details about the emulator.
And it does not give me any errors but i can’t connect to the server it say and the game logon screen handshaing auithicing and success and then dissconnecten from server
when i run MPQ-extractor it can find the first two but not the last one even though it is clearly placed in the folder
# Adcox
okay then try typing this from command prompt :
net start mysql
or
type services.msc from Windows Run command, and then search for mysql service entry, right click on it and choose start mysql
and lastly check using netstat if you can see port 3306 listening for incoming connection
# Thomas
see the Server.log file in your mangos directory, so you know what’s the source of the problem
# hesham
Thanks :) .. as for your question, did you see zepplin moving from some coordinate to other coordinat ? im pretty sure i’ve disabled so that mangos will only shows you a basic/error message only
btw which mangos version you’re using ?
# tacd
Well .. i’m from Jakarta, Indonesia in GMT+7 timezone :) .. to be honest, actually i really want to play on official server too (or at least the trial version so i can see what it looks like on official server, how many players, etc)
as for the how-to guides, well .. i love playing around with my computers (which mean, i love anything related to computers stuff) :D
I wonder reaper, where are you from? I read your country isnt listed, you’ve never played on a real server, yet you know SO much about wow, on[how-to-do] things… i just have to say, “well played”!
Hi really very nice guide.
I have all things as u said and every thing worked but when i logon at the game it says hanshaking ,succes, then it say disconnected from server what have i done wrong and i use engb client ver.,And something else when i cr8 the account it is to hard cause the mangosd keeps giving information about zepplin and ships and i can’t write the command. And thanks for help
k, i got it to work up until the point when u log onto the server where i gets to “logging onto game server” then it takes me back to the realm list, any idea’s?
Thanks :)
nope its not listed there…
# neo
thanks tacd ;)
# AdCox
Try running netstat /an and see if there’s port 3306 listed there :)
Neo,
Reaper-X has already answered that problem (i live in europe aswel).
Here’s what he posted::
# Pete
If you’re using enGB client, try open the extract.bat file inside DBC Extractor directory using Notepad / Wordpad, and then change these :
locale-enUS.MPQ
patch-enUS.MPQ
patch-enUS-2.MPQ
into
locale-enGB.MPQ
patch-enGB.MPQ
patch-enGB-2.MPQ
btw if it’s for work you, let me know about it, i’ll add it in the future :)
yes im admin on my pc… how can i check wich applications listen to wich port? or if any applications listen to these two ports?
Sorry for this 3 posts
i just changed the extract enUS all to enGB and it worked.
Now i did almost all steps.
mangosd.conf changed the line to “C:\Mangos\data”
now another problem -.-
when i open mangosd it keeps closing directly.
wwhat i am doing wrong?
realmd stays open but mangos keep closing
grrr the extract batch file will not extract patch-enGB-2.mpq
(it has done all three files before but won’t now)
This is what i do:
Copy all in DBC Extractor
In the WoW folder to Date – EnGB (There is no enUS so i think it must be enGB) Paste all
double click extract and that happens
Im stuck on step 7
when i double click extract it opens but it says:
Output Directory:
Fatal:Could not locateMPQ archive locale-enUS.mpq
Output Directory:
Fatal: Could not locate MPQ arcive path-enUS.mpq
Output Directory:
Fatal: Could not locate MPQ archive path-enUS-2.mpq
Reaper x
i know this is not the site to ask this but can you please make a guid that shows us how to set up the auction house bot. im having problems and all the sites i checked makes me more confused.
# Pete
Thanks :)
# Zemna
Ah, try running the ad.exe first to extract the maps and then run the vmaps extractor to get the maps
# Zack
If you’re looking to view your windows event log
you just need to type :
eventvwr.msc
from the run command :)
i know this is a pathetic question for me to be asking but where and how do i view system logs?
when ever i run magnosd it just opens and closes
this is the error that i got how do i fix it?
2007-09-23 21:52:35 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-23 21:52:35 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-23 21:52:35 Realm running as realm ID 1
2007-09-23 21:52:35 Using unknown world database.
2007-09-23 21:52:35 Using DataDir “C:\Mangos\Data”/
2007-09-23 21:52:35 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-23 21:52:35 WORLD: VMap data directory is: “C:\Mangos\Data”/vmaps
2007-09-23 21:52:35 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-23 21:52:35 ERROR:Check existing of map file ‘“C:\Mangos\Data”/maps/0004331.map’: not exist!
2007-09-23 21:52:35 ERROR:Correct *.map files not found in path ‘“C:\Mangos\Data”/maps’ or *.vmap/*vmdir files in ‘“C:\Mangos\Data”/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
Got it working, thanks for the help!
Keep up the good work,
Pete
# Byzan
well .. actually i do use quotes, but this wonderful software automatically transform it into curly quotes lol …
im going to encode it so it’ll show the correct quotes… done :DThanks for the info ;)
# Adcox
Ah it seems mangosd and realmd can’t bind to specified port .. hm .. thats strange. Did you run any other application that is listening on those ports ?
or … btw did you run it with administrator privilege ?
# Thomas
Ah your problem is mangos can’t connect to the mysql server, to fix it :
run the mysql server first
and to make sure that mysql already started and listening for incoming connection type :
netstat /an
from command prompt
and see if there’s something like this from the output of netstat
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
# Zack
Look at the Server.log file in your mangos directory to see what’s the source of the problem ;)
nope, in reply to reaper-x
was that in reply to me or someone else? if it is reply to me then i do not understand
In reply,
Realmd.log:
2007-09-22 20:43:10 Using configuration file realmd.conf.
2007-09-22 20:43:10 MaNGOS realm daemon /0.8-SVN (Win32)
2007-09-22 20:43:10 to stop.
2007-09-22 20:43:10 Database: 172.0.0.1;6112;mangos;mangos;realmd
2007-09-22 20:43:31 ERROR:Could not connect to MySQL database at 172.0.0.1: Can’t connect to MySQL server on ‘172.0.0.1′ (10060)
2007-09-22 20:43:31 ERROR:Cannot connect to database
Server.log:
2007-09-22 20:14:15 Using configuration file mangosd.conf.
2007-09-22 20:14:15 MaNGOS daemon /0.8-SVN (Win32)
2007-09-22 20:14:15 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-09-22 20:14:15 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-22 20:14:16 ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t connect to MySQL server on ‘127.0.0.1′ (10061)
2007-09-22 20:14:16 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
i got it all working up to where you log in…it goes to handshaking then stops and doesn’t do anything
Okay, so I followed this set up to the the nose, But I can’t seem to start the mangosd application and the realmd application, they just open then shut instantly. What gives. I had the old revision working before on my computer, but I had to reformat, now I’m using Vista any special thing I should know. Thanks it’s be appreciated.
No idea what to tell you, AdCox, about those issues… Sorry about that… Hopefully Reaper can help ya there ^^!
Quick question whats teh building folder in the world of warcraft folder for after you use vmaps simple batch file?
and the realmd.log:
2007-09-23 04:19:51 Using configuration file realmd.conf.
2007-09-23 04:19:51 MaNGOS realm daemon /0.8-SVN (Win32)
2007-09-23 04:19:51 to stop.
2007-09-23 04:19:51 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-23 04:19:51 Added realm “MaNGOS”.
2007-09-23 04:19:51 ERROR:MaNGOS realmd can not bind to port 3724
ok but now it says
2007-09-23 04:05:52 WORLD: World initialized
2007-09-23 04:05:52 ERROR:MaNGOS cannot bind to port 8085
…
Oh and umm.. since I cant edit the last comment I made.. It should look a bit different than that… something like…
# Data directory setting.
# Important: DirectDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Mangos\Data”
The direct link in quotes is wherever it is on your computer, though. Which I believe is where you said it was so there ya go, man! Just make sure thats the way it looks… Or just copy/paste that… And it should work. Screwed my server over to at first :|
Oh and umm… Reaper- You need to change that part on your Tutorial… It doesnt include the quotes around the replacement wording so it throws people off :\ I only figured it out because I read the actual file after it didn’t work the first time (I was just rushing through it, lol)
Take care!
Dude! I had that same problem! Its an easy fix… After you put in your direct path to the Data file in Mangos… Put quotation marks around it! So… something like… “C:\Mangos\Data” instead of just C:\Mangos\Data
Just make sure its in the right spot and you got it!
hi
i have this problem:
2007-09-23 02:53:47 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-23 02:53:47 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-23 02:53:47 Realm running as realm ID 1
2007-09-23 02:53:47 Using unknown world database.
2007-09-23 02:53:47 Using DataDir ./
2007-09-23 02:53:47 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-23 02:53:47 WORLD: VMap data directory is: ./vmaps
2007-09-23 02:53:47 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-23 02:53:47 ERROR:Check existing of map file ‘./maps/0004331.map’: not exist!
2007-09-23 02:53:47 ERROR:Correct *.map files not found in path ‘./maps’ or *.vmap/*vmdir files in ‘./vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
this is how the mangosd.conf locks like:
tant: DataDir needs to be quoted, as it is a string which may
# contain space characters.G:\mangos\Data# Logs directory set