How to Configure MaNGOS the World of Warcraft Emulator
By Reaper-X on Apr 19, 2007 in Emulators, Games, Guide, MMORPG, Tutorials, Video Games
Update : You can browse this site software category if you’re looking for my mangos release or my custom mangos release … btw i’d suggest you to get my mangos release first because it has been tested with WoW 2.2.3 and will be updated frequently (even easier than anything written on this old post because i already include everything you need to run your own wow private server except for mysql program of course)
This is the old version of my WoW Private Server Guide, the new version that gives you a detailed step (with images) can be found at below links :
- Installing MySQL
- Setting up the Mangos
- Just in case you want to create lan party
- Setting up the webserver to put registration page
It’s been a while since the last time i post something to my blog and that’s because i’ve been playing World of Warcraft in various private / public server, from WowScape, WowFusion, b3ckswow, etc (i’m switching various server because some of them always disconnect me a lot) …
But let’s keep that aside shall we ? because this time i’ll post a guide on how to setup your own world of warcraft private server using MaNGOS (i’m sure there are many other WoW Emulator out there, but i choose this one instead)
And as a note, currently i’m using the World of Warcraft classic version (1.12.1) and this guide might or might not be useful for you if you’re trying to setup TBC (The Burning Crusade) server
So here’s the step …
Update :
If you find this guide a little bit confusing, maybe you should try reading my new guide on how to create wow private server the easier way .. also to those who’s keep getting SQL error or want the easiest way of importing the sql, i already uploaded my mangos sdb (updated till changeset 156) and already tested to work with Mangos Rev3462
You can find all of the files required (including mangos itself) in my new post .. so be sure to check it out too ;)
Required Software :
- MySQL : This is important because MaNGOS use MySQL as it’s database and currently i’m running the 5.0.xx version
- MaNGOS : Without this you can not run a private server of course but do not forget to get the binary files instead of the source files unless you have Microsoft Visual Studio 2003 ++ installed and want to compile it by yourself (currently i only have MSVC 6 so there’s no way i can compile it, and the Visual Studio 2005 Express version is to large for me to download it)
- Map Extractor (both of them included) :
- Ad.exe : This is used to extract maps files from your World of Warcraft files
- MPQE : This is used to create DBC files which is extracted from WoW games data too
- SDB : This is the database used by MaNGOS and to make your private server playable of course this is a must. And the one you must download first is SDB FULL 0.6.2 including it’s hotfix and it’s update (you must register first)
Note : You can get binary release of Mangos from Mangos-Files.de
New Update :
Im sorry previously i did not upload the changeset 141 till 156 files because i thought everyone can find the changesets files easily (also i do not know if the SDB team allowed me to put that thing here) … but to make thing easier (and that’s the purpose) .. i decided to upload the changesets file here (if it’s not allowed i’ll removed it immediately) :
- SDB Changeset 1.4.1 – 1.5.6 Files for Mangos Revision below or equal to 3462
You must run the sql files in order (eg 141, 142, 143, and so on) and the step to execute this sql script is described in step 5
Optional Software :
- MySQL Client such as Phpmyadmin, etc (although in this example i did not tell you how to use those mysql client) so feel free to use mysql client or not
Special Note :
- If you get an error message saying the maps files is outdated or anything similar to that message from the Mangos Log, that means the Ad.exe you’re using is incompatible (i have experienced this) and i’m pretty sure the Ad.exe you’re using is for the Burning Crusade client so try getting the old version a little bit
- Im currently using Mangos Revision 3459, because the later revision from 3463 and above did not work for me (i have tested it) and i’m sure it was caused because i do not have TBC installed
- Im currently using SDB 0.6.2 and updated till changeset 1.5.6
- And as a reminder, i’m using World of Warcraft Client version 1.12.1
Let’s begin …
I assume you’ve downloaded all the required software and now as for the next step :
Note : If you did not set up password for the root account of your mysql database the default password is blank .. but in this example i’ll write username as username and password as password :P
1. Install MySQL and do not forget to enable InnoDB when prompted also check to make sure MySQL is in the Environment Variable Path … and activate the mysql service if you havent do so or if it is not started yet and you’re done installing MySQL
Note : Setting up environment variable for mysql is necessary to make thing easier, because you can execute it from any location
2. Extract the mangos program you’ve downloaded into your desired location for example, C:\WoW\Mangos
3. Open the Run command (Start -> Run) and type cmd and press enter and you’ll see command prompt window
4. Now type this in the command prompt :
- cd /d C:\WoW\Mangos\sql
- mysql -u username -p -v < create_mysql.sql
- mysql -u username -p -v -D realmd < realmd.sql
Note : Feel free to adjust database name to your liking but in this example i only show you the easiest way of doing it
5. Extract the SDB Full 0.6.2 file, SDB 0.6.2 Hotfix, and SDB Update into desired location, for example C:\WoW\SDB and type this in the command prompt :
- cd /d C:\WoW\SDB
- mysql -u username -p -v -D mangos < SDB_0.6.2_FULL_DB.sql
- mysql -u username -p -v -D mangos < SDB_0.6.2_FULL_DB_HotFix.sql
- and continue with the update by typing the same command with the exception you must change the filename after “<” character
Note : You must update the database according to it’s version number (0.6.2 Full database equal to changelog / revision 1.4.0) so the update you must get is 1.4.1 and above .. as an addition, it might take a while before the full database imported so you can take a break while doing so
And now you’re done setting up database for MaNGOS … and feel free to delete the extracted sdb file
6. Copy the ad.exe into your WoW game directory, for example C:\Program Files\World of Warcraft. And create maps directory in there and run the ad.exe .. and yet another break time :) .. and when this process finished move the maps directory into your desired location, for example C:\WoW\data\maps
7. Now you’ll need to copy MPQE you’ve downloaded earlier into WoW games data directory, for example C:\Program files\World of Warcraft\Data. And now open command prompt again and type this :
- cd /d C:\Program Files\World of Warcraft\Data
- MPQE /p dbc.MPQ DBFilesClient\*.dbc
You’ll see another directory created called MPQOUT inside the data directory. Now go open that directory and rename the DBFilesClient directory to DBC, and move it into C:\WoW\Data\DBC for example
Congratulation, now you’ve finished setting up the data required for mangos
8. Now for the last step you’ll need to open the mangosd.conf inside the mangos directory and edit below lines :
- Change the DataDir = “@MANGOSD_DATA@” into your data location inside the quotes, in this example it would be like this “C:\WoW\data”
Now you’ve finished configuring Mangos and it’s database completely, as for the next step .. try running the mangosd.exe and realmd.exe and see if you can run it without problem or not .. if there’s no problem you can go to the next step (you do not need to close the realmd process and mangosd process)
9. Go to your World of Warcraft game directory and open the realmlist.wtf file using notepad or other text editor program .. and edit it like below :
- set realmlist 127.0.0.1
Now you’ve finished configuring WoW to used your mangos server
10. Now you can connect to your own server, if you want to create new user account you can do so by typing create username password from the mangosd window (it’ll create normal user account). But if you want to create GM account you can do so by typing this from normal command line (type cmd in the run command) and type below lines :
- mysql -u username -p
- USE `realmd`;
- INSERT INTO `account` VALUES (NULL, 'username', 'password', '3', NULL, NULL, NULL, '', CURRENT_TIMESTAMP, '0', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0');
- quit
To get commands for your GM account, you can type : .commands at the chat window inside the game
That’s it you’re finished configuring Mangos and WoW to be played locally :) and here’s some screenshot (please don’t laugh on my equipment because i dont know anything about good items or equipment in WoW and that’s why i choose to play it locally first to learn about WoW) :)
Updated Screenshot :
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
Can i make my own server free? will other be in it if want? can u send me a email and tell me how to make it?morganblodgett@msn.com
You are the crack. Thank you man :D
# Canna
Your welcome :)
# Morgan
1. Can i make my own server free?
Yes ..
2. will other be in it if want?
well that’s depend on how you promote your server of course :D but to answer your question yes
3. can u send me a email and tell me how to make it?
Erm .. actually you’re already reading ;)
Nice guide. Thx :-)
Hmmm..nice info..may be if have a time I will try it. But, I’m not a gamers..or very bad gamers :P
I have make New Mangos server (Mangos Revision 3459) and my WoW Version is 1.12.1. When i try to login its says “unable to validate game version” what is the problem? could anyone help me? thx :-)
This may sound weird, but i’m stuck at the 4 step. I put cd /d C:\WoW\Mangos\sql in the cmd, but it allways appears “The filename, the volume label syntax or the direcory name is incorrect” and ” The system cannot find the path specified. I tried various ways of writting it, but none worked.
thanks in advance
Edit:
I’m using cd /d D:\WoW\Mangos\sql
But the error is the same. If any1 as managed to crate the server I would apreciate the help. My msn mail is anidrosan@msn.com in case anyone can help me.
I don’t know what the “cd /d” part means, otherwise I could try to solve it.
Thanks in advance.
You must use your mangos directory. i.e. : Your mangos directory is E:\Mangos, use cd /d e:\mangos. If your mangos directory is C:\wow\mangos, use cd /d c:\wow\mangos. Etc…
I have done has you said, in the cmd now appears D:\WoW\Mangos (I used the cd /d D:\WoW\Mangos\ without the slq).
But I still dind’t understand the 4 step. Can you please help me by messenger? thanks.
# Dasti
I have make New Mangos server (Mangos Revision 3459) and my WoW Version is 1.12.1. When i try to login its says “unable to validate game version” what is the problem? could anyone help me? thx
hm .. that’s strange .. did you use another patch to your wow installation ?
try reinstalling world of warcraft (fresh install, mine was 1.0 version ), and download the 1.12.0 patch (400 mb++) and install the 1.12.1 patch (3 mb++) .. btw that’s what i done to my wow installation and it worked fine ;)
# Xtonic
What windows version you’re using ? winxp or win9x ?
if you’re using win9x (or non win xp system) try this command instead :
cd D:\WoW\Mangos
or without /d option
Im using Windows XP. I managed to enter the path, but now the only error i get is in the 2nd part when it says mysql is not recognized as an internal, external command etc..
aah ic .. then the problem is because mysql havent been configured in your environment variable path
the solution is try this :
1. Open System properties (if you’re using windows Keyboard press CTRL+PAUSE/BREAK)
2. Open the Environment Variables
3. In the system Path add below line (if you’re running mysql 5 the default path would look something like this or adjust it to your mysql bin path) :
- Variable Name = Path
- Variable Value = C:\Program Files\MySQL\MySQL Server 5.0\bin
please note insert that value after anything else (im sure there’re other value there)
that’s it now you can run mysql command from anywhere :)
aah forget to tell you this, there is other alternative if you dont want to set mysql into your env. path
try using this command line instead if you dont want to use env. path (for example like below):
X:\Where MySQl Directory Located\bin\mysql.exe -u username -p -v < create_mysql.sql
Thanks, I have managed to do it, now he is asking the password, it’s the MySQL.com account password or other ?
Ah of course not (to be honest i dont register myself at mysql.com) lol .. because it ask you for the root password (if you just installed mysql recently)
try using mysql -u root followed by the other options used in this page :)
Thanks, worked perfectly, I now managed to go into 5 step.
Do you know where i can downlod the update? i just have the Hotfix and the full version.
ChCan i use f.e Changeset 162 or I have to choose an update that has compatibility with my Mangos (how do I see mangos version) ?
thanks
fortunately i still have the address from my download manager lol
btw here’s the address :
e-turay.com/files/MaNGOS/SDB/Archive/0.6.3/
get the changeset from 141 until 156 only .. if you only own WoW classic version (non burning crusade update)
forgot to put this lol
to see mangos version, you can see it from the revision number but to make thing easier :
mangos revision below / < 3463 support wow classic while >= 3463 support burning crusade and cant be used on wow classic only (for example like myself)
I’m having a little trouble finding the mangosd.exe and realmd.exe files. don’t know where to look.
thanks
By the way, i’m using mangos 0.6, couldn’t find the 0.5 version. Don’t know if matters.
Yay, i have managed to create the server. Just one problem, there are no NPC’s, do you know how to put them ?
Im sorry for late reply because i just got back from outside .. lol
and to answer your question :
- By the way, i’m using mangos 0.6, couldn’t find the 0.5 version. Don’t know if matters.
Well .. actually what’s important is it’s version / revision number. And i’d suggest you to use the revision 3462 or below (3462 is better of course) if you only have WoW classic installed and use the SDB until changeset 156
- Yay, i have managed to create the server. Just one problem, there are no NPC’s, do you know how to put them ?
No NPC ? are you sure you’ve imported the full database (SDB) correctly ? and did you apply the hotfix and the updates ?
because the NPC are already included in the full database :) .. that is if you’re using the SDB package
Yes, the NPCs are available, must have happened something worng during the first time.
Everything is okay, so i don’t know the revision number of my Mangos :D
Do you know how can i change the game parameters? like HP or other stuff? in which file are those things written?
Thanks ;)
glad it works fine for you :)
btw to know which version of mangos you’re using try typing version at the mangosd process (command)
as for editing the database directly using notepad or other text editor is not possible because the database was stored in mysql database format but you dont have to worry about it because there are two ways to edit your character info :
1. Edit the data stored in the mysql database using MySQL Client program to make thing easier and not using the command line like in this example (but it’s not recommended unless you know about mysql)
2. Using the GM commands (recommended) and to get all available gm commands try typing :
.commands
at the chat window in game
for example to modify your character Talent Point :
.modify tp (number)
although the effect is temporary because the value recalculated each time you log in
as a side note, im using mangos 0.7 SVN (R3462 and not plan to upgrade or to switch it in the near future unless i get the TBC client) lol .. by Maxi
I am currently running this and it works great. I have a quick question about the DOS box that is up while the server is running though…
What is the syntax to send a message using the DOS box as opposed to using the in-game .announce command? If I am not playing and want to warn others about a reboot for example, it woul dbe handy to simply type it in the DOS box.
Thanks for your efforts BTW!
Is it me or does any1 else have a problem whith the riding instructors, because i can’t learn riding skill. When I click in a instructor no box appears.
The rest is just PERFECT!! Great Job you have done here ;) congratiolations.
when i write MPQE /p dbc.MPQ DBFilesClient\*.dbc it says that dbc.MPQ and DBFilesClient.dbc doesnt exist :S..anyone know whats wrong?? srry for my bad english
Besides the doubt I have with the riding skill can you answer about how can I change the ip adress of the Mangos server i.e 123.0.0.0 to a name, like WoW server or something.
Thanks
# Glyn (Zaphod) Evans
You can use broadcast your message command from the mangosd window :)
# Xtonic - Riding skill problem
I guess you want to learn the raptor riding skill (because i experience it too) when creating horde orc character. The only problem i have is because my character is in battle mode and that’s why i cant talk to raptor trainer
other than that, you might also found problem at later time when doing orc quest at crossroad .. and the only solution so far i have found is :
by typing .gmon to temporarily disable monster from attacking your character (although there’re no nearby monster) and it does the trick for me :)
or the other way around you can learn the skill by typing .learn skill_id (i prefer not to use this for the first time because i want to learn about WoW system) lol
# Xtonic - Using DNS
Although i havent tried it yet (because i dont want to open specific port used by mangos in my computer) .. but maybe you can try signing up into Dynamic DNS Server so you can assign dns to your computer ip address
and thsi is often used when you try to create web server on your computer that is accessible from outside world (internet)
a good dynamic dns service i’ve tried is from Sitelutions (i already assign one address to my computer but i cant give the address to public using my own domain name) :)
# Skarre
Dont worry my english is bad as well .. lol .. btw does the file actually exist in your WoW data directory ?
try looking for those two files using Windows Explorer and see if you can find them
or are you using burning crusade client ?
(also .. if you want i can send you the DBC file) because its not that big - 1.60 MB compressed :)
I can’t find the Item Sets only, any other item works fine. Are the dungeons working on your server ?
Thanks
I wnat that a computer in my network can access to the server, how can i do it ? is any way I can make it enter by opening a port in my router or is something diferent ?
Thanks :)
Thank you! That is the one yes!
something weird is happening now, when I click on realmd.exe the window pops up but immediatly disapears, disabling the server.
Sorry, the window that pops up is the mangosd, not the realmd.
Just to correct the sentence above.
Thanks.
The error in the Server text appears:
2007-04-25 18:55:46 ERROR:Check existing of map file ‘127.0.0.1/maps/0004331.map’: not exist!
2007-04-25 18:55:46 ERROR:Correct *.map files not found in path ‘127.0.0.1/maps’. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
Man. u said
cd /d C:\WoW\SDB
mysql -u username -p -v -D mangos
# danne
yes .. the /d option used to automatically switch into the target directory from anywhere, but i forgot if this option exist in windows 2000 and below or not (this is what i always use in windows xp because it’s pretty handy) for example :
- you’re at D:\ and want to switch into C:\WoW and instead of typing C: && cd Wow you can use cd /d c:\wow :)
# Xtonic
Yep everything worked fine and i dont see any major problem at all except for minor glitch :)
as for you error, i experience it because i was running the ad.exe for TBC client which is incompatible for my wow classic client and im sure you’re having the same problem too
because i cant find 04331 map either in my computer so i can assume you’re using different version
btw which version (the revision number) of mangos you’ve downloaded into your computer ?
I wnat that a computer in my network can access to the server, how can i do it ? is any way I can make it enter by opening a port in my router or is something diferent ?
first you must edit the realmlist table in realmd database and set it to your dns name or ip address
and configure wow client to connect to your dns name .. that’s it
but in order for other computer to connect to your computer you configure your router to portforward automatically (this is for internet)
as for lan … just edit the realmlist and set wow client to use that lan ip address
I can’t find the Item Sets only, any other item works fine. Are the dungeons working on your server ?
Thanks
item set ? it works fine for me :) .. if you see the screenshot my character was using Dreadnaugh or something item set
I have managed to fix the map error, I can login, but when I login i cant enter in the realm, it appears logging in and then the window of the realm appears again and again. I’m trying to fix that now, any help would be welcome :D
thanks
I just want my server to be available for Lan use, my 2 computers only. But I can’t do that, the realmlist files in D:\MySQL\data\realmd are all with squares, can’t read it, but I don’t know if it’s there I must change something.
But for now my first priority is to set up the realm, because I can’t enter it :P
hm .. i think there’s a misconfiguration somewhere try checking the realmd and mangosd configuration file
as for server available for lan, try editing the realmlist table in the realmd database and set it into your lan ip address .. but i’d suggest you to use mysql client such as phpmyadmin to make thing easier to edit mysql database entry in the future
Yes, I’m cheking that, but I can’t see where can be the problem, can you please post your conf of realmd and mangosd ? I might have something wrong, but don’t know what parameter.
Thanks.
Hi. Great guide. I have managed to create the server but I can’t make a GM acc. I write these things:
mysql -u username -p
USE `realmd`;
INSERT INTO `account` VALUES (NULL, ‘username‘, ‘password‘, ‘3′, NULL, NULL, NULL, ”, CURRENT_TIMESTAMP, ‘0′, ‘127.0.0.1′, ‘0′, ‘0′, ‘0000-00-00 00:00:00′, ‘0′);
quit
But when I try to connect it won’t recognize me. Are there any other way to add a GM account?
It’s hard to take my doubts here, so I’m trying to do all over again.
This time an error appears in step 4.
In the last line when I type
mysql -u root -p -v -D realmd
mysql -u root -p -v -D realmd
I get an error saying uknown database ‘realmd’
Fixed that :D sorry about all the other posts, my browser gone nuts.
Can you just explain me detailed how to make 2 lan computers acces the same realm ? thanks.
When im at step 4 and i want to do that code
mysql -u username -p -v
Sorry,
I mean when i want to do
mysql -u username -p -v
it tells me im not authorized and i need a password.
But in fact i did not set a password, could you tell me what command line i need to enter to make it work?
And i had a server on WoWeMu and it wouldnt let people connect to me when i used my DNS as realmlist.
Anything else then just change the realmlist?
what line to do for the create mysql.sql?
i got no password and username = username
thnks,
*srry for triple posting..
Im sorry about my last post..
It just says acces denied user@localhost
how do i fix that?
Did u create a password on root when instaling MySQL ?
Are you putting -u username -p -v try -u root -p -v etc.. and when asks for your password insert it, if you didin’t choose one, type blank.
Microsoft Windows XP [versie 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>cd /d C:\WoW\Mangos\sql
C:\WoW\Mangos\sql>mysql -u username -p -v mysql -u username -p -v
I forget about the signs that dont let me post it..
ERROR 1045 (28000): Access denied for user ‘username’@'localhost’ (using passwor
d: NO)
okay for you guys that cant get in because of the error this is why, you dont have an account with the info your trying to log into your server with probably, mangos servers come with 4 accounts automatically, Administrator, Gamemaster, Moderator, and Player, all of them have that (the name said above), as their username and password, i hope this helps you guys GL
hay umm my map ad thingy isnt extracting emm it keeps coming up with a debug error watever it is could u email me a one that works?
hay me again it works but the CMD thing it says that the thing u wrote up dosnt exist on the second time
so it wont make the directory :’(
I can’t seem to get the MPQE to work.. it always gives me the error that “the application failed to initialize properly”
Could you send me the file that it creates?
Great instructions you have here by the way!
Thanks!
Ok, so I found the 1.12.1 DBC files extracted through another site, but I error out on mangosd.. It errors at Loading Creature Template and says “Error in ‘creature)template’ table, probably sql file format was updated .”
I was careful to make sure I only patched the full 1.12.0 patch and the 1.12.1 patch, and I used Mangos 3459. I used MySql Essential 5.0.37-Win32. Any ideas as to what could have gone wrong?
Thanks,
PepsiG
Ok, tried again with MySQL 5.0.37-Win32 and doing a complete install and rerunning everything. Still getting same errors at Loading Creature Template and says “Error in ‘creature)template’ table, probably sql file format was updated .”
Could it be the DBC files I downloaded were bad? If you could please send me the file anyways, I will try it and see if that fixes my problem.
Thanks!
Every time I run the ad.exe on step 6 I get a debug error, i have the Maps directory in there, ad.exe is in the WoW directory, but it still debug’s on me. Anyone got a solution?
# Luke
hay me again it works but the CMD thing it says that the thing u wrote up dosnt exist on the second time
so it wont make the directory :’(
Which one ? the cd /d or cmd ? if you’re using win9x try to use command instead of cmd
# PepsiG
Did you use another database ? or which sdb version you’re using ? because the only supported SDB for Mangos client below 3463 is SDB FUll 0.6.2 with fix and patches until Changeset 156
As for your mysql installation im sure it’s already worked fine :)
# PepsiG and WurthSkidder7
im sure there are missing runtime for your system. And because im not the one who compiled ad.exe i dont know which runtime to be exact .. but to make sure your system can run various program without problem (even for new program) try downloading below files from Microsoft site :
- Microsoft .NET 2 Runtime
- Microsoft Visual C++ 2005 Redistributable Package
Try downloading the above two files and install them into your system first :) and see if it worked for you or not
Reaper-X
I used sdb full 0.6.2 and hotfix, but I used the ones available for download as of yesterday, so unless the hotfix was updated recently that should not do it, right?
I had to download the DBC files for 1.12.1 from an independent site because I could not get the MPQE program to work. I will try adding those files tonight and see if that lets me run MPQE and fixes my DBC/mangosd problems.
Thanks for the quick response!
Reaper-X,
Thanks, that did the trick for MPQE. However, I think I may have figured out what was causing my probelm.. I only have changeset 140. How do I upgrade to 156? Do I have to do all changesets between the two (i.e. 140 to 141 then 142, 143, 144, etc..)?
And how do I install the changesets? Are they just .sql files I save to a directory? If so, which directory?
Thanks!
I am getting this error when I try to run mangosd.exe
2007-04-30 18:15:44 Loading Game Object Templates…
2007-04-30 18:15:44 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).
Can anyone help me?
Metalidea,
That is the same (type) of error I am getting. Are you at changeset 140? or did you update your changeset? If you did not update your SDB changeset above 140 that is probably part of the reason you are getting that error..
I am currently trying to figure out how to update the changeset, but so far no luck.
I tried to update I updated to changest set 208 i think it was the oldest version but still have the same problem
How do you update the changesets?
I have no idea I was wondering the same thing and where to get 140
aah im sorry i have updated this post and upload the changesets 141 till 156 file here :) .. you can find it above the optional software
# PepsiG, metaltildea, and other that is experiencing error message saying sql format was updated
How do you update the changesets?
To update the changeset you can execute the sql files using the same command described at step 5
# metaltildea
actually changeset 140 already included in SDB 0.6.2 Full :)
i updated all the changesets to 1.4.0 but I still get the same error how can I check the gameobject template table? So hopefully I can find out what’s wrong
putting the C:\ thing in worked but when typing in the next one:
mysql -u….. saying there is no command for mysql
when i type that into command, do i type something else first?
Hi
well, when i write “mysql -u username -p -v
“mysql -u username -p -v
it says it cant find the file when i type in the create_mysql.sql part in the cmd..
whats wrong? i use TBC client, is that it?
sry for the other post’s.. it got messy
i am on step 4 and i had just entered mysql -u username -p -v
Erik,
I think you are making the same mistake I did.. I kept typing “username” and it did not work.. try using “root” in place of “username” i.e.
mysql -u root -p -v ….. etc etc etc ….
The default username for MySql 5.0 is root I believe, at least it was for me when I set a password.
G’luck and hope that helps!
Reaper-X,
Thanks for all the great help and time and effort you put into this!
erik,
try using root instead of username.. that is what I did…
i found a repack that works fine but it is a very old version revision 2891 is there anyway i could update it to work with this version because I still seem to get the object table error no matter what I try
Reaper-X,
I got it up and running! You rock, my friend! I _really_ appreciate all you have done to help the community.. My wife and I moved to a new place with no internet services available and I have been dying to play!.. We are still paying our subscription fees so I dont feel that I am hurting Bliz. Now we can play on a private LAN server until a viable internet solution comes along. (Now I will see if I can figure out how to run it on a Lan without an actual internet connection.. I am thinking of setting the IP of the server computer to a set number and using that same IP for the set realmlist setting)
Is there a way to “recreate” our characters that we have out on Bliz servers so we don’t need to start from scratch?
I had an error when running 155.sql, but it still let me run 156.sql and the server still loads. Any thought on what could have went wrong or how it will impact my server stability?
Thanks for all you help!
I’m having a problem getting ad.exe to work. i get a c++ error but the entire box is blank. should I try getting the newest version of ad.exe?
So as I have been playtesting the server I noticed that in the Gnome starting area there are no frostmane whelps in the cave that holds Griknar the Cold like there is on live servers, in addition to blood pact from imp not working. Are there ways to fix these server-side or is it just a symptom of MaNGOS? I am fine whith it as is, just thought I would see what I can do to work out glitches..
If this is something I should be discussing on a MaNGOS board just let me know..
# Silent or other experiencing the same problem
mysql -u….. saying there is no command for mysql
if you get that message, that means mysql you havent configured mysql bin in your environment path .. newer mysql version can automatically set your environment variable path for you (if you didnt unchecked it when installing mysql)
i’ve wrote about this environmental path few pages back (try looking for it)
but just in case you dont want to use environment var path, you can also use :
C:\Where MySQL Located\Bin\mysql -u root -p .. and followed by the other commands used instead
# metaltildea
i found a repack that works fine but it is a very old version revision 2891 is there anyway i could update it to work with this version because I still seem to get the object table error no matter what I try
if you havent setting up mangos before, i’d suggest you to use the Revision 3462 or at least 3459 instead combined with SDB 0.6.2 + hotfix + changesets 141 till 156
and you can get 3459 from mangos-files.de, while 3462 version can be found from (sorry forgot the url) .. lol ..
if you want me to upload the mangos 3462 i can upload it for you
# guy smiley
I’m having a problem getting ad.exe to work. i get a c++ error but the entire box is blank. should I try getting the newest version of ad.exe?
if you get runtime error try updating your VC runtime, here’s my previous comment about this
# PepsiG
I got it up and running! You rock, my friend! I _really_ appreciate all you have done to help the community.. My wife and I moved to a new place with no internet services available and I have been dying to play!.. We are still paying our subscription fees so I dont feel that I am hurting Bliz. Now we can play on a private LAN server until a viable internet solution comes along. (Now I will see if I can figure out how to run it on a Lan without an actual internet connection.. I am thinking of setting the IP of the server computer to a set number and using that same IP for the set realmlist setting)
Your welcome and im glad you can make it work too :)
Is there a way to “recreate” our characters that we have out on Bliz servers so we don’t need to start from scratch?
I had an error when running 155.sql, but it still let me run 156.sql and the server still loads. Any thought on what could have went wrong or how it will impact my server stability?
Error message ? could you post the error message here ? because i just tested it now without problem
As for data from Blizzard, it is not possible .. because im sure the data saved in official server are differents than the emulator version but the most important thing is no one can touch the blizzard data :P
to make thing easier, you can increase the exp rate by editing the mangosd.conf file in mangos directory and set the exp and drop rates to your liking although setting the drop rate higher than 10 (i only test in 1, 5, 10, 100, and 1000 int) may result in problem with quest item not being dropped by the monster
as for the exp you can adjust it freely
as for getting individual item or item set, you can try this command :
.lookupitem
.lookupitemset
and to add it into your inventory use this command :
.additem
.additemset
maybe i should create new post about mangos gm commands .. hahaha
# PepsiG
So as I have been playtesting the server I noticed that in the Gnome starting area there are no frostmane whelps in the cave that holds Griknar the Cold like there is on live servers, in addition to blood pact from imp not working. Are there ways to fix these server-side or is it just a symptom of MaNGOS? I am fine whith it as is, just thought I would see what I can do to work out glitches..
Hm .. i dont know much about it since i only played as Tauren warrior, human mage, and orc warrior .. and i never played on the official server lol (beside until now, im still learning about wow) ..
a good example of this case is, once time i try using the gm commands to have all spells and skills for my tauren warrior character
and i saw there’s a DnD Spell or something that can transform you into animal … i clicked on it .. and OMG .. i change into a cat !!!
Since i know nothing about WoW .. and i cant return / dont know how to return my original form .. i decided to create new character lol
Maybe you can tell me more about WoW ingame (as an addition i still dont know what is the main differences between PVP Realm and Normal Realm except for killing player) :P
So yeah when I goto cmd to type all that stuff in for a GM account after i type USE `realmd`;
it says database changed then i type the rest in and doesn’t do anything. Me want to be a GM…. :(
# Marx
Erm .. did you copy paste the text from here ? if you copy paste the text from here it’ll not work, you must type it manually
as a note, if you sure you dont get any error message after typing the last command in this guide
when ingame try typing this to check if you’re a GM or not :
.commands (with the leading dot)
Forget to tell you all, if you didnt receive reply from me here .. that’s because its quite hard to organize every comments here (well .. i think you can see it by yourself because if there are more than 4 comments / question posted by various people at the same day, sometime i get lost on which comment i should answer first .. and the last page of course getting the answer first)
so maybe you could also try registering at my forum and create a new thread, so i can organize it better :)
i got it working thanks for the guide it helped me alot tho i wasnt able to use the command prompt so i used SQLyog instead and it worked fine thanks again though i am having the no npc’s/enemy’s issue now
this is the error for changeset 155
Error Code: 1007 - Can’t create database ‘mangos’; database exists
Query:
INSERT INTO creature_movement (id, point, position_x, position_y, position_z, waittime) VALUES
(13227,1,-35.2957,-856.803,58.6749,300000),
(13227,2,-53.158,-844.649,56.383,0),
(13227,3,-44.0005,-827.207,57.1427,0),
(13227,4,-18.2736,-800.485,58.8641,0),
(13227,5,-21.6932,-761.019,62.1732,0),
(13227,6,-20.8296,-715.951,69.6253,0),
(13227,7,-45.4663,-717.097,68.5534,0),
(13227,8,-69.9465,-717.17,68.0095,0),
(13227,9,-111.882,-715.131,65.2042,0),
(13227,10,-160.847,-716.369,63.8877,0),
(13227,11,-202.517,-721.034,62.5292,0),
(13227,12,-255.076,-714.971,58.9229,0),
(13227,13,-289.298,-697.333,57.4972,0),
(13227,14,-325.209,-678.925,54.5757,300000),
(13227,15,-353.291,-665.55,55.5599,0),
(13227,16,-410.316,-668.459,54.5015,0),
(13227,17,-425.468,-626.073,54.501,0),
(13227,18,-436.086,-584.159,53.582,0),
(13227,19,-469.96,-575.385,48.5198,0),
(13227,20,-513.753,-563.037,41.3057,0),
(13227,21,-549.795,-564.794,35.6348,0),
(13227,22,-598.321,-576.173,31.6066,0),
(13227,23,-639.927,-562.344,26.6961,0),
(13227,24,-689.715,-548.91,28.2971,300000),
(13250,1,-35.2957,-856.803,58.6749,300000),
(13250,2,-53.158,-844.649,56.383,0),
(13250,3,-44.0005,-827.207,57.1427,0),
(13250,4,-18.2736,-800.485,58.8641,0),
(13250,5,-21.6932,-761.019,62.1732,0),
(13250,6,-20.8296,-715.951,69.6253,0),
(13250,7,-45.4663,-717.097,68.5534,0),
(13250,8,-69.9465,-717.17,68.0095,0),
(13250,9,-111.882,-715.131,65.2042,0),
(13250,10,-160.847,-716.369,63.8877,0),
(13250,11,-202.517,-721.034,62.5292,0),
(13250,12,-255.076,-714.971,58.9229,0),
(13250,13,-289.298,-697.333,57.4972,0),
(13250,14,-325.209,-678.925,54.5757,300000),
(13250,15,-353.291,-665.55,55.5599,0),
(13250,16,-410.316,-668.459,54.5015,0),
(13250,17,-425.468,-626.073,54.501,0),
(13250,18,-436.086,-584.159,53.582,0),
(13250,19,-469.96,-575.385,48.5198,0),
(13250,20,-513.753,-563.037,41.3057,0),
(13250,21,-549.795,-564.794,35.6348,0),
(13250,22,-598.321,-576.173,31.6066,0),
(13250,23,-639.927,-562.344,26.6961,0),
(13250,24,-689.715,-548.91,28.2971,300000)
Error occured at:2007-05-02 15:06:39
Line no.:342
Error Code: 1264 - Out of range value adjusted for column ‘waittime’ at row 1
sorry for so many posts just wondering if anyone new how to make a registration page or had a link for a guide on how to make 1 (great guide by the way reaper thanks again)
# metaltildea
Thanks and im glad it could work for you too :)
btw as for the error message, i just take a look at the changeset 155 sql file and i didnt saw the sql command used to create new database
im sure you imported the wrong file, because all the changeset file only updating the table created by the full SDB and it’s hotfix .. and if the table cant be found, of course it wont updating
maybe you should re-import the whole sql start from 0.62 Full -> Hotfix -> Changeset 141, 142, 143, 144, and so on and see if you get the same error message or not ;)
sorry for so many posts just wondering if anyone new how to make a registration page or had a link for a guide on how to make 1 (great guide by the way reaper thanks again)
Dont worry about it, because comments form are made for something like this
as for registration page, if you want the simple way, mangos-files.de already created it (look under misc files section)
but in order to use it, you must already set up apache HTTPD server with PHP installed on your computer
hmm i have PHP 5 and the registration page from magos but I cant seem to figure out how to get apache running or which file to download as the apache site downloads are all in FTP instead of HTTP with no real explanation on how to use it
o ya i almost forgot i redownloaded the changesets and tried importing them again and got the same error but the game works fine without it
ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)
Error I get when trying to use the mysql -u username -p -v
create_mysql.sql command. Looked through all 10 pages and didn’t see anything that looked related to my problem, and I couldn’t find anything in MySQL manual. Anyone have the same problem or know how to resolve it? (sorry about the double post, but it cut off and wouldn’t let me edit >.>)
This is probably a question I missed while skimming over the other comments, and if it was answered I apologize in advance. I’m not very knowledgable on how this works but if I begin taking these steps to make my own mess-around server will I still have access to Blizzard’s official ones? Or would I need to re-update my WoW to their current version as opposed to the 1.12.1 version you use.
Sorry if this makes little sense, I’m not too good at explaining
# metaltildea
hmm i have PHP 5 and the registration page from magos but I cant seem to figure out how to get apache running or which file to download as the apache site downloads are all in FTP instead of HTTP with no real explanation on how to use it
aah the one you must download is the apache HTTPD server, if the only mirror you get is from FTP, dont worry because basically its just the same (although using different protocol)
as for installing apache, i think it’d be very long if i have to write it here but you can try installing it normally like any other program. And when you’ve finished installing apache try open your browser and type this in the address bar :
http://127.0.0.1 or http://localhost
if you can see it, that means apache succesfully installed on your system
as for integrating php into apache in windows, there are two ways to integrate it
first by loading the php module into apache or run php as cgi
but i’d suggest you to try installing apache first and see if its working and can be accessed or not ;)
o ya i almost forgot i redownloaded the changesets and tried importing them again and got the same error but the game works fine without it
Hm .. that’s strange because i didnt get any errors message at all .. maybe you should try dropping all of the table in the realmd and mangos database first and then reimport it again
as a note, your best bet is to make sure the error message isnt appearing because there will be problem later
# Syl
ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)
Error I get when trying to use the mysql -u username -p -v
Ah .. that problem was caused because you’re trying to use named pipe (this option only available in windows nt series or windows xp) and you havent configured / enabled it in your mysql configuration
to fix the problem try adding below line into the my.ini file in your mysql installation directory
enable-named-pipe
put it inside the [mysqld] section of my.ini
try it first and see if it’s fixed the other error or not
# Yomtom
This is probably a question I missed while skimming over the other comments, and if it was answered I apologize in advance. I’m not very knowledgable on how this works but if I begin taking these steps to make my own mess-around server will I still have access to Blizzard’s official ones? Or would I need to re-update my WoW to their current version as opposed to the 1.12.1 version you use.
basically what makes the differences between accessing the blizzard server and private server is the location of wow server listed in realmlist.wtf in your wow game directory (although im sure its more complex than what im thinking now) .. and thats why you should keep backup copy of your old realmlist / default realmlist (actually if you forget the default realmlist i can tell you the address or just run the patcher)
other than that if you update your wow installation to the latest one im sure there’ll be incompatibilities with mangos .. but maybe i think it best for you to ask this question in mangos forum since most people there already familiar with this kind of stuff :)
Thanks reaper, turns out it wasn’t being enabled under services, tweaked it and it’s running properly now. New problem has came up though. Terrain.mpq and dbc.mpq are both missing so ad will not work, and crashes immediately. Any workarounds for this?
Terrain.mpq and dbc.mpq are missing ? are you sure ? because if those files are missing im sure WoW cant be launched … try looking for both filename directly in your WoW Installation Directory\Data
nope still the same with the changesets.
and i got the register page up but when some1 trys to register they get this error
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I’ve tried doing what there website says and setting mysql to work with old passwords but it was to no avail i got the same error if you would like to see the php code let me know
sorry if this is a dumb question but i was just wondering how i could add some npc’s and a portal i want players to be able to go to gm island and have a elite shop there i already got my guard speek to work (lemme know if u want the scripts) but i cant seem to figure out how to make a portal or a new npc in game
ok someone i know has a mangos wow server set up, and i have a character on that server. i just set my own server up and was wondering if i could transfer my character from his server to mine. very nice guide by the way.
also when others try to get on to the server it puts them in a realm loop and they cant get on, any idea why?
ERROR 1045 : acces denied for user username @ localhost etc..
what do i do really?
thx already
ok nvm i figured out i put in root kk lolz
eum but i kinda got another error now i like started step 5 and then i realised i was working on my C:/ instead of D :S and well i cacelled it and now step 5 sais it alrdy excist or smth like that
oklol i might be getting annoying now so lol i figured that before post out butnow theres an even bigger problem
my add.exe wont run in my wow map
-> microsoft visual c++ debugg library
program D program files wow data add.exe
this application has requested to terminate the runtime in an unusual way
shutdown - retry - ignore
Reaper-X,
The error I got when I ran 155.sql was:
ERROR 1264 at line 294: Out of range value adjusted for column ‘waittime’ at row 1.
Any idea why I got that error?
I ran all the previous changelogs in order and had no errors until 155.sql, and even 156.sql ran without error after 155.sql errored out.
thanks again!
PepsiG