WoW Mangos 4488, ScriptDev2 134 with Project Silvermoon DB Rev17
By Reaper-X on Sep 21, 2007 in Freeware, Open Source, Quick Fix, Reaper Mangos, Software
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
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
Hmmm for some odd reason, I get an improper syntax on the first step with the drop_mysql, but the other 3 work, is it something I'm doing wrong? I'm starting from scratch with this version so I dunno if the drop is releated to an update or what not.
I get this error entering the drop_mysql.sql command~ BTW great guide bro, I've set up other servers using this guide and it was a sinch, but this stumps me :X
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear ''localhost'' at line 1
Im really sorry packaged the wrong drop_mysql.sql
to fix it you just need to open the drop_mysql.sql using Wordpad
and then delete everything except for these two lines :
DROP DATABASE IF EXISTS `mangos` ;
DROP DATABASE IF EXISTS `realmd` ;
I get stuck at step 12. I run mangosd.exe and realmd.exe, but I cannot figure out the prompt to create a username and password
Ah ... actually you just need to type at the mangosd window where it shows you something like this :
tele - Teleport player to location.
mangos>
and the result would be like this
mangos> create myusername mypassword
and then
mangos> setgm myusername 3
to get the highest level of game master known as Administrator :P
maybe I did something wrong. I noticed I had the same problem as prinnysquadleader and tried the fix, but it is still giving me the same error message.
Fixed, but I do not know what you mean by 'mangosd window'. Where will I find it?
figured it out. Had / instead of \ for the data dir. Don't laugh, very tired!
it's the window that launched after you run the mangosd.exe ;)
you'll see that there are two window after you execute / run the mangosd.exe and realmd.exe, now you just need to type inside that window :)
can this be done with SQLyog as i cant find the community edition its just gone poof.....
Of course, basically SQLYog is just a 3rd party application designed to perform mysql related task easier
but as a reminder, you'll need MySQL installed first in order for SQLYog to work ;)
as for mysql community edition gone from mysql .. im pretty sure you just didn't notice the link to the community edition release ;) because they just redesigned their web site
click here to mysql community edition (open source, freeware)
and grab the 42.4 MB version
ok wtf when i try to run the batch file eve AFTER ive done the maps and vmaps it says it cant work or sum shit like ?????
ok wait to explain this easier il just type the whole thing out....
The application failed to initialize properly (0x0000135), Click on OK to terminate the application
ive also tried an antrix server and an acsent but each time i get to that stage nothing at all.... also just to add ive been trying to start up the realmd. before everything finished (:P) just to see something.. but the screen quickly flashes on then dissapears is this normal and do i have to wait for everything to finish or is that a complete and utter problem.. sorry for the 3 posts in a row thing
First make sure you've .NET 2 Runtime from Microsoft installed on your computer (search microsoft.com website for NET Runtime)
as for mangos / ascent quickly flashes that's because you didn't configure it properly
make sure you've configured everything in mangosd.conf and realmd.conf
if you're using this distribution of mangos and you've extracted the DBC, Vmaps, and Maps correctly
you just need to edit the DATADIR into the correct path and you're done ;)
Great info !
Server work very well !
Only few questions: mobs appears "little" than official servers, and lev 1 yellow mobs around birth pg place (northshire, azuremyst isle, ecc) hits too strong than 1 level pg (240/250 pf per hit).
Have I wrong databases ? What can I do to fix this problem ?
Hey! I followed the instructions and everything seems to be working well- but I cannot connect to the server. I'll log in, and it will give me the "unable to connect" message.
Also, how would I allow others to connect to me?
Thanks!
Followed every step exactly, once i try to log on it just says unable to connect, any ideas? I'm fully patched but on enGB, think this could be the cause?
I did all the steps until I did the create_mysql.sql file where it says:
Error 1146 (42S02)at line 1: Table mysql.user does not exist.
Hi Reaper,
First of all, thank you very much for your excellent guide! I really enjoyed myself playing my own server of WoW classic. But now when i tried to upgrade to tbc, i have this problem on mangosd.exe
The log display:
2007-09-21 20:50:07 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-21 20:50:07 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-21 20:50:07 Realm running as realm ID 1
2007-09-21 20:50:07 Using unknown world database.
2007-09-21 20:50:07 Using DataDir C:\Mangos\data/
2007-09-21 20:50:07 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-21 20:50:07 WORLD: VMap data directory is: C:\Mangos\data/vmaps
2007-09-21 20:50:07 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-21 20:50:07 ERROR:Check existing of map file 'C:\Mangos\data/maps/5301243.map': not exist!
2007-09-21 20:50:07 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.
I followed your step by step using the 'Mangos R4488 with ScriptDev2 R134 and Full Database Dump'. I started from scratch again. I patch my WoW up until 2.1.3. I dont know where i went wrong. Please advice. Thanks!
I fixed my previous problem but now I see that my DBC files are outdated. So I tried to run the extractor and it gets to patch-enUS-2.MPQ then it says it could not be found, however I see the file in the folder. Thanks for helping.
no i mean it wont let me extract the dbc it just says this app i unable to start wtf?
ok this sux... i just wnt a server i can screw around on >.>
i have it as
DataDir = “D:\Mangos\data”
as i have it in D :S
Hello again! Ive tried changing around the realmlist, but it still cant connect to my main server. Is it my realmlist? Its set to 127.0.0.1
Ty :)
Hello i have a little problem with step 6. when i dothat step the Command Prompt start and then it works and works for a long time and now it says "Work complete. No errors." but there are still vmap files coming in to the vmaips folder... what is wrong?
# Teus
Well .. since i never played on official server i dont know much about it (i wish i could) ... but i'm pretty sure that i managed to find bugs on the project silvermoon database, you can always report it to their forums directly ;)
http://projectsilvermoon.net/index.php
Have I wrong databases ? What can I do to fix this problem ?
as for temporary fix, you can always edit the database directly by using your favorite MySQL Client ;)
# 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 :)
# JBon007
I believe you didn't extract the Maps files correctly, try running the Map Extractor, Vmaps Extractor, and DBC Extractor to fix it :)
# Noah
First you need to know which WoW version you're using, and then change the Patch-enUS into your WoW Region ;) .. for example look at my answer to Pete question
# Dylan
You need to get Microsoft .NET 2 Runtime installed in order to run DBC Extractor :)
Click here to get .NET 2 Runtime
and then run the dbc extractor again
# Naomi Wiflath
I need some information first to see why you can't connect to your server
so, open the Server.log file inside your mangos directory, and see what's the error message
btw just in case you didnt know, you need to keep the Mangosd.exe and Realmd.exe running in background when you want to connect to your own server ;)
# ANdreN
You just need to wait for the VMaps assembler to assembly the VMaps files :)
It worked, thanks! Looking forward to see more from you :)
I still can't get the DBC extractor to work. Ive tried changeing the filename and the filename in extract to the same thing but even that won't work. Could there be a problem with the extractor itself? Thanks for helping.
i found out why my maps are incomplete...i didn't the the \data\expansion in my WoW folder...any idea where can i get it? Thanks again!
# tacd
Thanks tacd :)
# Noah
I just uploaded the DBC file extracted from WoW 2.1.3 enUS client, try looking at the update part to get the link
# Jbon007
If you're looking for the extracted dbc files, see the update part ;)
Yeah- Im having an issue with the DBC extractor.
Everytime I go to run it, it says that it cannot find the file SFmpq file.. I am running vista so that could be part of the problem but I do not know what I can do to solve that problem... I hope you can help because so far, this has seemed like the most likely to work Emulator I've tried to use.
Thank you in advance for any help you could possibly give me! Great Tutorial! :)
# Byzan
Since i havent tried vista yet (perhaps later if lots of application im using now, has been supported to work with vista :P)
You could try downloading the extracted files instead (just uploaded it few hours ago), the link to download it can be found under the Mangos with database dump
as a side note,
If you get this error message when running the extract.bat :
Fatal: Could not locate SFmpq.dll
copy the SFmpq.dll into the same directory as the MPQE.exe ;)
Hi,
Firstly a great guide, but i got a problem.
Everything works up until i try to logon to the server: i just get "unable to connect" - and i've checked my realm list and it is set to 127.0.0.1. Besides that the server and realmd seem to start up fine :\
Any feed back would be greatly appreciated,
Thanks
Hey reaper i'm having an issue with trying to run the mangos and realmd.exe files on my end. Ive done every thing els correctly but thes files just open and shut off real quick.
I decided to run sqlyog and when i tried to run the bat file from that it says
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mangosmangos' at line 1
(0 ms taken)
Do I have to rienstall the whole thing or is there a way to get it to work correctly?
I love this guid! best one on the internet.
one question, does dual wield skill not work? cant get it to work by doing all the .learn all / .learn all_crafts, etc commands.
# Thomas
Could you tell me what's inside the Server.log and Realmd.log
# Seventh101
Could you tell me what you're trying to do when you get that message ?
from your description, it seems that you want to execute this sql query :
mangosmangos
# tacd
it's working (actually dual wield works since the old mangos version)
you just need to type :
.lookupspell dual wield
or
.lookupspell dual
to get the skill id
and then type :
.learn IDNUMBER
that's it :D
to see the screenshot look at my very first post about WoW
btw the screenshot was taken with mangos R3642 (which is the old version for WoW Classic only)
Aha! i kept on trying .lookupskill.... epic failure there! Thanks for your quick reply reaper. Got it working now woohoo.
Yeah... I just hit another issue for some reason or another! (Oh and thanks for that update! Still wouldn't work.. and I also had to run everything under Administrator mode to get it to work.. Dern read/write privelges with Vista! Its a pain sometimes...)
But everytime I open Mangosd, It opens then closes immediately... I have no idea whats up with this so I was wondering if you could help me out there! Up The realmd sets up perfectly fine.. And when I tried this on the whole.. Shadowhunter repack of Mangos, the code would boot up. But anyway! If you could help me out with this issue :\ (And it lasts for less than a second on activation so I cant tell ya anything that its saying! :\)
Thanks again!
# Byzan
Open and close immediately ? aah ... to see the error message, try opening the Server.log in your mangos directory
hmm i got dual wield skill to work but when i try to wield "http://wow.allakhazam.com/db/item.html?witem=32837&locale=enUS;source=live" (Warglaive of Azzinoth set) my rogue keeps on saying "i'll never be able to equip that". what am i doing wrong?
Hmm.. Alright then.. It has something about my file link being wrong for mangos as to where to find the "data" path... It has it as completely contrary to what I put in earlier.. Infact, its missing a good few words even! So umm.. how do I re-edit this to see the correct file path?
ok then! Well nevermind... I was stupid and forgot a quotation mark!!! Thanks for the help overall though! I just hope this works after all of this, lol. If it doesn't well.. EESH! This is gonna suck lol.
Nice Tutorial and awesome help though, regardless!
Err.... That last post didnt work right! But yeah.. Thanks for all the work!!! And the Help! And yeah!!! So now lets get those GM codes... heh... And GM LAND TIME!!! woo! Thanks so much man! This has been awesome.
nm works now
# tacd
ah lol actually i just tested it right away and no problem for me that's why it took a while to reply to your and bryzan comment lol
btw here's the link to the screenshot
and thanks for telling me about that weapon :P because well .. i know nothing about the wow game itself (this is why you should play on official server first in order to learn about the game itself) lol
# Bryzan
Cleaned up your uncompleted post ;)
btw glad you found the solution :D
Hey reaper. i rienstalled the entire thing and my server and it works perfectly now. pondering what i did wrong the last time but at least its working now.
that's great :) .. but im sure previously there's something wrong with the configuration or .. you didn't import the sql properly ;)
Just a question... is there any way to get past the raids holds on instances? I kinda wanna take on the world!! IE- Karazhan! :P But the raid issue is annoying... And WOW! The Spectral Swift Tiger looks awesome! You all should get one in your bags ;P
Thanks again!
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
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!
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!
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
...
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
Quick question whats teh building folder in the world of warcraft folder for after you use vmaps simple batch file?
No idea what to tell you, AdCox, about those issues... Sorry about that... Hopefully Reaper can help ya there ^^!
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.
i got it all working up to where you log in...it goes to handshaking then stops and doesn't do anything
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
was that in reply to me or someone else? if it is reply to me then i do not understand
nope, in reply to reaper-x
# 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 ;)
Got it working, thanks for the help!
Keep up the good work,
Pete
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.
i know this is a pathetic question for me to be asking but where and how do i view system logs?
# 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 :)
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.
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
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
grrr the extract batch file will not extract patch-enGB-2.mpq
(it has done all three files before but won't now)
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
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?
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 :)
# neo
thanks tacd ;)
# AdCox
Try running netstat /an and see if there's port 3306 listed there :)
nope its not listed there...
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 :)
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
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"!
# 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
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
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
# 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
i have a britsh client i thought that meant i can't use your uploaded ones
try it first just to make sure (don't worry it just 2.85 MB) ;)
well now my mangosd ain't workin
mysql is startet an the port 3306 is listening... and now?
nvm fixed that one lawl
srry for wasting forum space
- Zack kicks himself in the butt -
it vorks i tell you! thnx a bunch for help reaper...it really is a great guide
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
# 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
# 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 ;)
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
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
nothing uses this ports...
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.
# 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
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.
nothing helps :( and im using xp pro
Quick Question : I got everything up and running fine. No errors showing nothing. Best guide you or anyone has done.
Created my usual character to test with (Dwarf Warrior) and took the first Quest "Dwarven outfitters". Went to kill a wolf and before my first strike I was dead. Resurrected tried again same thing. Tried to hit a trogg same thing.
Can kill a boar though.
Any idea whats up with that and how to fix it?
found out the problem.. The troggs and wolves do not exist in the database.. got this db error..
2007-09-23 15:16:06 Quest 905 has `ReqSourceRef1` = 3 but `ReqItemId3` = 0 and `ReqSpellCast3` = 0, quest can't be done.
2007-09-23 15:16:06 Quest 6083 has `ReqCreatureOrGOId1` = 3107 but `SpecialFlags` not have set killOrCast flag bit, quest can be done without creature/go kill/cast!
2007-09-23 15:16:06 Quest 10087 has `ReqCreatureOrGOId1` = -33067 but gameobject 33067 doesn't exist, quest can't be done.
2007-09-23 15:16:06 Quest 10087 has `ReqCreatureOrGOId2` = -33068 but gameobject 33068 doesn't exist, quest can't be done.
2007-09-23 15:16:06 Quest 9386 has `ReqCreatureOrGOId1` = -181346 but gameobject 181346 doesn't exist, quest can't be done.
2007-09-23 15:16:06 Quest 9319 has `ReqCreatureOrGOId1` = -181346 but gameobject 181346 doesn't exist, quest can't be done.
2007-09-23 15:16:06 Table creature_questrelation: Quest 349 listed for entry 1449 not exist.
Plz help me
I feel that everyting is allright cause i have done everything as you said and i think that it is a tiny proplem that prevents me from logging on my server.
sry for bothering
Hi i just downloaded it and it's working great! i was just wondering if any1 know were could find a portal creator and an item creator. thanks
speaking of Ascent, i just registered there today, and i'm looking forward to their system. i've been a member of mangosproject, and i really like what they're doing (even though they're not the nicest bunch), but i'm looking forward to seeing Ascent's core.
thanks for the information, reaper.
redoing the data base did not solve the problem.. low level creatures have a misty blue haze above them and cannot be hit or they cause instant death.
any ideas reaper...
I decided to give Mangos a go as well. I got through the MySQL setup just fine (even found the community version without much work) as well as getting the server up and running (though right now for testing purposes I'm just looping it Home). However I'm having the same problem as others have mentioned above (example instant kill from low level critters doing about 254 dmg, and npc respawning is a no go as well). I can manually re-spawn areas, but was hoping the server would do it automatically. I've searched Google & Yahoo but only find similar situations. Anyone been able to get around these couple problems? Here is an excerpt from my DBErrors.log:
2007-09-24 00:56:13 Quest 905 has `ReqSourceRef1` = 3 but `ReqItemId3` = 0 and `ReqSpellCast3` = 0, quest can't be done.
2007-09-24 00:56:13 Quest 6083 has `ReqCreatureOrGOId1` = 3107 but `SpecialFlags` not have set killOrCast flag bit, quest can be done without creature/go kill/cast!
2007-09-24 00:56:13 Quest 10087 has `ReqCreatureOrGOId1` = -33067 but gameobject 33067 doesn't exist, quest can't be done.
2007-09-24 00:56:13 Quest 10087 has `ReqCreatureOrGOId2` = -33068 but gameobject 33068 doesn't exist, quest can't be done.
2007-09-24 00:56:13 Quest 9386 has `ReqCreatureOrGOId1` = -181346 but gameobject 181346 doesn't exist, quest can't be done.
2007-09-24 00:56:13 Quest 9319 has `ReqCreatureOrGOId1` = -181346 but gameobject 181346 doesn't exist, quest can't be done.
2007-09-24 00:56:13 Table creature_questrelation: Quest 349 listed for entry 1449 not exist.
Same as above I believe. On the bright side, Thanks so much for putting on the guide, Reaper. It certainly rox!
error with mangosd.exe heres log. i am using your dbc files and i hav tried reextracting the maps
2007-09-24 04:54:30 Using configuration file mangosd.conf.
2007-09-24 04:54:30 MaNGOS daemon /0.8-SVN (Win32)
2007-09-24 04:54:30 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-24 04:54:30 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-24 04:54:30 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-24 04:54:30 Realm running as realm ID 1
2007-09-24 04:54:30 Using unknown world database.
2007-09-24 04:54:30 Using DataDir C:\mangos\data/
2007-09-24 04:54:30 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-24 04:54:30 WORLD: VMap data directory is: C:\mangos\data/vmaps
2007-09-24 04:54:30 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-24 04:54:30 ERROR:Check existing of map file 'C:\mangos\data/maps/5301243.map': not exist!
2007-09-24 04:54:30 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.
# Adcox
Unfortunately that's the only possible way i know of, basically if you can't bind a program to specific port that's because there's another program using that port
and the only solution to fix it is, by closing that program that use the same port, or change it manually into another value
your best solution would be asking directly at the mangos project forum :) .. or at windows networking forum first
# hesham
Actually that's depend on your firewall and of course your firewall configuration :)
currently im using Ghostwall firewall to replace windows xp firewall and another one from my router (if you want to see my post about ghostwall, you can search this site)
# sunwolf and applejack
Well ... since it's related to database problem, the solution would be :
1. Editing the database manually (it's under the creature_template table)
2. Report it to the silvermoon project (im using their database) .. http://projectsilvermoon.net
3. Wait until the Rev18 came out :)
for example (taken from the database itself)
Kobold Vermin Min attack 155, max attack 208 .. while i don't really know if that's correct or not ... but you can always reduce it's value into something else :)
# Mike
Could you tell me, after you've extracted the map using ad.exe (vmaps extractor is for line of sight), can you find it manually by using the windows search function for that filename ?
because i can see those maps name just fine (and it gets extracted properly without any problem)
reply
oppps sry i was configiuring the port 8804 to 3306 at the mysql by wrong and that was the erorr sry dude it is great guide by the way this is my first time to make server all thanks go you and your very helpfull guide
ok i got it running on my brothers pc... but now i get connection failed when i try to connect.
there is no fire wall active and we are on a lan network.
i changed the realmd address like explained in the set up server for lan giude to 192.168.1.3 and my realmlist.wtf to set realmlist 192.168.1.3
hey i run ad.exe but it says 'This application has requested the Runtime to terminate it in a unusual way' why is this?
# hesham
No problem :) .. glad you've found the solution
# AdCox
are you trying to connect from the same computer where the server process (mangosd and realmd) ran ? or from another computer in the same network ?
another comp in the same net
Hey reaper,
I have the server up and running except the mobs are doing way to much damage, seeings a level 2 wolf from northshire abby is hitting a level 1 rogue for 255. I dropped the damage done to player by normal mobs to 0.1 but he is still hitting me for way to much any way to make them hit for a there normal 1-5 damage.
Thanks Jason
btw do you have icq reaper? maybe we can solve the problem then a bit faster :)
yes reaper i can find the files in windows search under "C:\mangos\data"
after all this how/or is it possible to play on the official world of warcraft game servers?
plz email me asap
lief3304@gmail.com
also is it possible to have this set up on my home network so some of my friends can play on it with me?
Ok I get to step 7 and run the extract.bat and it gives me an error: "To run this application you first must install one of the following version of the .NET framework: v2.0.50727
Contact your application publisher for instructions about obtaining the appropriate version of the .Net framework."
Ah ok, I saw the DBC Update you posted (must have overlooked it earlier >