How to Configure MaNGOS the World of Warcraft Emulator
By Reaper-X on Apr 19, 2007 in Emulators, Guide, MMORPG, Misc. Games, 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
Facebook
Last.fm
Twitter
YouTube
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
# metaltidea
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
If you get auth error because your client doesnt support new mysql auth try adding this in your my.ini files in your mysql install dir
old-passwords
and dont forget to restart the mysql service by using this command :
1. net stop mysql
2. net start mysql
As for the sql error, dont worry soon i'll upload the complete database and including anything else required except for maps (because the filesize is really big and my internet connection speed especially the upload speed is slow)
# thomas
did you create the maps directory first before launching the ad.exe ? if you didnt create it first you'll get that error message ;)
# PepsiG and other that is experiencing sql error
Soon i'll upload the complete database, DBC files, and the Mangos Server itself (R3462) to make thing easier :)
Just wait for my new post about it ;)
# nord
If your friend can give you a database dump of his mangos server of course you can import it
Okay i've finished creating the new guide which is more friendlier than this one (hopefully)
ok thanks. 1 more small problem now, all the city guards will not give me directions. it just says unknown rather than listing all the things it normally would. and i really appreciate the help
Reaper-X,
So I have it up and running, and I opened my ports on my router and I can sign in as a newly created username. But then it gives me the server selection screen (only choice is Reaper-X server) and I select it and click OK. The problem is it just goes right back to the server select screen.
I tried to change the "127.0.0.1" in mangosd and realmd to the IP of my server computer but then mangosd and realmd would not run.
Any thoughts on what to do?
I tried to change the “127.0.0.1″ in mangosd and realmd to the IP of my server computer but then mangosd and realmd would not run.
ah actually you shouldn't change the 127.0.0.1 in mangosd and realmd.conf because it's the IP address (which is a Loopback address) of your own MySQL server
Btw try changing the address back into 127.0.0.1 and try running the Wow again, and if you get the same problem try posting the log :)
Reaper-X,
I got it now! Yay! Ok, so fo all those of you who are having problems getting your server up on LAN or internet here is what you need to do. As Reaper-X just stated, leave the mangosd.conf and realmd.conf to at 127.0.0.1 instead of changing the IP to your server's IP.
Then download SQLyog Community Edition 5.30 (Stable) from http://www.webyog.com/en/downloads.php
(The reason you want Community Edition is that it is free and requires no sign in)
Next, Install SQLyog and connect using the following variables: MySQL Host Address 'localhost', username 'root' and use the same password you set up for 'root' in MySQL. Then click connect. [Disclaimer: It has been several days since I installed SQLyog so the login variables may need more info, but once you get in and see mangos and realmd databases on the right under 'root@localhost' you can proceed with this next part which I know works because I just did it yesterday] You should then see some databases such as mangos and realmd. Expand realmd and right-click 'realmlist' and select 'View Data'. Then you should see the server name and IP (probably 127.0.0.1) in the bottom-most right-hand box. Change the server name to whaterver you want, and change the IP to your server IP and check the box. Then make sure you right click the Name box and select 'Save Changes' and do the same for the 'Address' box. Then close SQLyog and make sure your router is forwarding the necessary ports and you will no longer get the "realmslist loop error" where you select the realm and it brings you back to your realms list.
Thanks again for everyones help! Now that I have a stable server up on my LAN I will try and get started on a TBC version on one of my other (many) computers. Reaper, do you plan on setting up a guide for TBC server? If so let me know and I will help contribute as I troubleshoot my way into setting one up :)
Thanks again to Reaper-X and his excellent guides (and uploads of changesets especially!) and, and to all of you who commented and helped clarify the small details. You helped bring WoW back to those of us who cannot get internet service because we are living in a rural area.
-PepsiG
On mine it says ERROR 1049 :Unknown Database 'mangos' any ideas?
I've got a bit of a problem. I used your guide to get a server running.. Kind of, I used yours and another one.. but, I had my server running last night, everything was working.. Had items, NPCs, quests.. Everything, then I was messing around upgrading to TBC, but when I run the mangosd.exe, the window closes uber fast, but I was able to screenshot an error saying 'cannot find mangosd.conf'... Any ideas?
# PepsiG
Glad you can finally able to make your own server (btw if you're planning to make public server be sure to invite me too) ;)
# Robby
Did you create the mangos database first (by running the create_mysql script)) ? because if you didnt created it first you wont be able to continue
as an addition, if you feel this guide is to confusing, i've already posted an another one, which is a lot easier than this one
# Primez
If the error message says it cant find the mangosd.conf , you can extract it again from the mangos revision you've downloaded :)
It doesn't work for me :'(
Could you create a video of you makeing one and post it here please.
None of it works for me :'(
#
Comment by Syl • United States
104 May 4, 2007, 1:05 pm |
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?
Hey, I am getting the same Terrain.mpq and dbc.mpq problem as him. My game runs perfectly fine, but i cant seem to find these files. Please help if you can.
Never mind, I found the problem. The ad.exe was an old out dated version.
# KillMega
glad you found the problem, btw if you're using TBC client you must get newer ad.exe (perhaps the new MPQE too) .. but if you're using the WoW 1.12.1 version you can use all of the above files listed here (except for maps, because its too big for me to upload it)
# Dave
Actually im thinking about creating video too but i dont know if i should do it or not, because im sure the resulting video filesize would be big (the fastest upload speed is just 8 kBps)
so im thinking on creating screenshot later, btw could you tell me which step isnt working for you ?
or if you prefer to chat with me directly, i can do it too .. but take a look at my timezone first by clicking here
Hello Reaper-x !!
I did it all, and the server is working fine, THANKS !
My question is just, is it possible to play more than one player on the server? i mean like, can my friend from some other place login on my server and play with me ?
If its a yes, please explain in detailed way - Sorry for bothering !
Ps. It would be cool, if you could contact me by mail.
Best Regards Lebanez xD
Hey, i was looking to make a burning crusade private server, and i havnt ever made a server before and im no expert on computers either lol, can u explain how 2 make a burning crusade priv server for me please?
# LebaneZ
Glad it work for you Lebanez :)
and of course its possible to make your server public (LAN only or totally public)
all you have to do is just edit the realmlist table in realmd database (realmd -> realmlist) using sql command or if you prefer to use MySQL Client you can use that too. And set it to your LAN IP Address if you just want to make it accessible from LAN only
or if you want to make it public, you must register with Dynamic DNS Service such as sitelutions, no-ip, dyndns, etc
and set the ip address into your dynamic dns address and configure the realmlist.wtf in your wow directory to use that address or IP
and you're all set :D
# Dhaka2
Actually there's no big differences between setting up WoW Classic server and TBC server ;)
all you have to do is download the latest ad.exe , latest MPQE to extract DBC files, Mangos Binary Revision 3463 (3478 recommended), and SDB 0.6.3 (or perhaps SDB 0.6.2 + Hotfix + all changesets available)
I dont get a s*** what you talking about reaper-x could you explain in a more detailed way ? :D
btw. Do you know REALLY fast server that i could play one? except WoWscape, and WoW-sexy.com ? A 1000mbit server with many players or something like that? Cause me and my friend wanna play together, and the server were playing on now is lagging ping = 100.
Can u try and host a BC server? I tried it and failed :o if u know how it is done send guide to my e-mail? thanks
Hey people, I need some help. I get the 0004331.map problem, it says it doesn't exist :/ Where can i get that file so my server would work?
I'm having a problem with all of step 10...
When I type the command to make a GM account into the mangosd window it just gives me an error about mysql....
# Ghost
Actually you must type it in new Command Prompt window not the mangosd window :)
# LebaneZ
btw. Do you know REALLY fast server that i could play one? except WoWscape, and WoW-sexy.com ? A 1000mbit server with many players or something like that? Cause me and my friend wanna play together, and the server were playing on now is lagging ping = 100.
Um .. actually i've never seen Private / Unofficial wow server with lots of players. Most of the time, i only see 45 - 90 players only. And if i have to compare it with various Ragnarok Online private server that has more than 1000 players online well .. 45 - 90 is still considered low by me lol
Btw if you want to create public server, all you have to do is just edit the realmd database (in this case maybe you should try using MySQL Client such SQLYog or phpmyadmin)
but i never tried using SQLYog though so i cant give you anymore comment about it lol .. but if you just want to use command line here's the command (someone ask this to me via email previously while this guide age is still 1 day lol and it seems he's doing fine with his server) ;)
- open command prompt and type :
- mysql -u root
- USE `realmd`;
- UPDATE `realmlist` SET `name` = 'Your Wow Server Name', `address` = 'Your Lan IP Address' WHERE `id` =1 LIMIT 1 ;
- quit
btw i assume that you havent changed the default root account password and you're using the same database name as i described here :)
# Yfae
Can u try and host a BC server? I tried it and failed :o if u know how it is done send guide to my e-mail? thanks
Hm .. if i have to host it for public by myself ... i cant do it because ... i dont have the money to get a dedicated server lol ... and if using my internet connection speed, im 100% sure you'll experience real LAG connection (ping at least 10000 miliseconds) lol
Thanks Reaper, I finally did figure it out through some trial and error hehe. Everything is good and I was able to make my gm account and login and everything.
My last question is this.. How can I customize the name of the server and how do my friends connect to my private server?
Thanks a ton.
I am having a problem with step 4 too, but mine is after i put in (mysql -u username -p -v
I am having a problem with step 4 too, but mine is after i put in (C:\MySQL\bin\mysql.exe -u root -D realmd
...why are my comments being cut off?
Hey, umm for some reason it keeps sending me to someone elses server. Do you now why?
Thanks!
# Jake
Im sorry if your comments being cut off but i can guess that you're trying to post forbidden words here and that's why your comments being cut off :(
btw could you tell me what is the error message you get when you run that command ?
# Ed
did you change the realmlist.wtf in your WoW installation directory into 127.0.0.1 ?
# Ghost
Actually the steps to make your server public is already explained above your last comment here :)
As for changing the server name basically its just the same like making your server public but this time you just need to change the server name instead of changing the ip address
btw are you using other 3rd party mysql client or not ? if you're not using 3rd party mysql client i'll give you the command to change your server name here :)
i updated the runtime( did download the newer one version) but it still not working, do u think i can use another extractor to make it work?
need help please, i cant use the extractor..says runetime error, and i have BC installed.
ehh? where did u get the older version of ad.exe?
# pk-kyo
ah, because you have TBC installed, you'll need to get newer ad.exe (you can get it from mangosproject forum). The ad.exe in this post can only be used on wow classic 1.12.1 (tested)
# Johnny
well .. if you're using wow classic you can use the map extractor from here :)
Is there somewhere I can find the details for the character tables data field? Thanks in Advance
yo i have done the exact things said but i dont have the sername/address page regerster page etc..that was supposedto come with mangos?
i couldnt find the files from mangos, can u find the link for me please?
# David
i believe the mangosproject forum have the answer for your question :)
# Johnny
Unfortunately register page doesnt come with mangos by default. But you can of course create it using PHP
or you could also use a simple registration page from Mangos-files.de (look under misc file section)
# pk-kyo
What file you're looking for pk-kyo ?
My comment got cut-off- Here it is again
When other people try to connect to my server, they login successfully, but when they try to select a realm it just brings them back to the select a realm screen. The stuff in realmlist.wtf is correct, my router is fine (Dmzed) and I tried modifying the IP in the sql from 127.0.0.1 to my public ip. None of these fixes worked.
umm how do I fix this error?
I've tried about 4 different guides and i always get stuck on this... LOL!
2007-05-13 19:29:20 Using configuration file mangosd.conf.
2007-05-13 19:29:20 MaNGOS daemon /0.7-SVN (Win32)
2007-05-13 19:29:20 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-05-13 19:29:20 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-05-13 19:29:21 Connected to MySQL database at 127.0.0.1
2007-05-13 19:29:21 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-05-13 19:29:21 Connected to MySQL database at 127.0.0.1
2007-05-13 19:29:21 Realm running as realm ID 1
2007-05-13 19:29:21 Using DataDir ./
2007-05-13 19:29:21 ERROR:Check existing of map file './maps/0004331.map': not exist!
2007-05-13 19:29:21 ERROR:Correct *.map files not found in path './maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
Hey man. Nice work with the guide firstoff. It has helped me make a server and I'm getting excited to try to find instances such as Naxxramas and Molten Core.
But I have a problem . It regards GM accounts. I did what was required to make one using the said method and it did not allow me to log in so I scrolled down to see if people had the same problems and a guy did so you told him to manually type it in , which I did but still nothing.
Any idea?
Hi reaper: ive got a problem were my promp box wont show up when i start the mangos.exe? its show up 1sec the disapears then it shows up again after 10secs etc?
Please help me out on this one or if anyone else knows whats cousing my problem feel free to add me on msn: playableplayer@Hotmail.com
were can i get the MANGOS FULL PACKAGE
what were can i get MANGOS FULL PACKAGE
so i can make it....
I'm trying to get my friends on the server, but when they trying to connect it disconnects them immediately.
I've had them try my IP in the realmlist.wtf file, aswell as 127.0.0.1
I don't understand -_-
Sorry to post again, but another problem is when I type the following
- open command prompt and type :
- mysql -u root
- USE `realmd`;
- UPDATE `realmlist` SET `name` = ‘Your Wow Server Name’, `address` = ‘Your Lan IP Address’ WHERE `id` =1 LIMIT 1 ;
- quit
When I get the to UPDATE part, I type in
UPDATE 'realmlist' SET 'name' = 'Example', 'address' = '123.456.7.89' WHERE 'id' =1 LIMIT1 ;
Am I doing something wrong?
It gets Error 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 (what I typed above)
# Carom
Ah .. im sure you didnt type it correctly, and for your information (and others) :
` = backtick / tilde (~) key
' = single quote / double quote key
I’m trying to get my friends on the server, but when they trying to connect it disconnects them immediately.
I’ve had them try my IP in the realmlist.wtf file, aswell as 127.0.0.1
Did you changed the ip address in realmlist table to match your public ip (internet or lan ip, thats depend on where your friend located ... in your lan or outside lan)? and do you have firewall software enabled
and can you login to your wow server locally without problem ?
# Luis
Erm ... what do you mean by full package ? by default there's no such thing as mangos complete package. You'll have to download each required file separately :)
# nicca
Im sure there's something wrong with your configuration. Check the server log
# Cager
Did you get sql error message when you type it ? and if you did try typing it again using this info
` = backtick / tilde (~) key
' = single quote / double quote key
# Xantra
That error was caused because you didnt set the correct path to your .map files
try adjusting the path as described in this guide :)
# Nincb123
Have you tried disabling DMZ and use normal portwarding instead ? and if you have firewall software installed try disabling it first (testing purpose)
yes, im new to this so when it says this for example mysql -u username -p -v
I amhaving a problem with my server. I setup my account and is shows up on my Navicat and my Mangos but when I go to login it says my information is correct. Reamllist is set at 127.0.0.1. When I type info in the mangos server commands it tells me "Onlin users 0 . It appears that I cna have a maximum of 0 people on my server, do you know how I can fix this? The magsnos config says max 100.
i am new to this stuff, i dont know much, when it says mysql -u username -p -v
Hi what username do i use for the all the stuff for example "mysql -u username -p -v
# danny & isaac
ah you just changed the username into root if you dont change anything when installing and you dont need to use -p switch because the default root password is blank (which is very insecure)
the final command would be :
mysql -u root :)
Reaper, could you give me the set realmlist thing so i can join you on the server. Oh and is there anything like .add _________?
Alright, heh, I'm pretty sure I typed it right this time.
But now, It accepts the command, but gives me a 1054 Error, Which is :
Unknown Column 'Yumz' in 'field list'
Yumz is what I'm trying to name the server(lol)
Also, Yes, I can connect to my own server.
Also,
# Carom
Maybe you should take a look at my previous 2 comments located here and type it to make sure the column number are same :)
# John
Reaper, could you give me the set realmlist thing so i can join you on the server. Oh and is there anything like .add _________?
Im sorry but i dont have public server because my internet connection speed is nothing compared to all of you (40 kBps down / 8 kBps up)
as for .add command, i guess you try to add item ?
then you should try typing this :
.lookupitem (any_item_name)
.additem (item_id_returned_from_lookup)
that's it
as for itemset,
.lookupitemset
.additemset
Last question(hopefully..)
I can get it to change the address now,finally.
Now I just need to know how I can get my friends to connect.
I've had them try set realmlist 123.45.67.890(my IP)
And it just says disconnected as soon as they try to log on.
Also, I've tried using a host/redirect at no-ip.com, It also doesn't work. Unless I should be using a different host type, I have it set on the default DNA Host (A).
Oh, and I have port 8085 opened up
# Carom
Have you configured your router to port forward the port used by mangos ?
this is the most important step, because if you dont forward the port used by mangos in your router, no one can access your server ;)
i made a server and it works...only thing i dont know is how to fix the map exploring bug and how to connect to server as GM
If someone knows the solution to my problem plz contact me on my email
rabbit@net.hr
I'm pretty sure I have it forwarded, but I'll check when I get back later.
All they have to do is set my IP in the .wtf file correct?
Alright, I definately have 3306 and 8085 Forwarded.
Also, When I configure Realmd to use my public IP, I myself cannot connect, but if I have it use the local one, I can. (Which is what I've been doing)
Should I be able to put in my Public IP in realmlist.wtf and be able to connect to it?
I've seriously tried everything I can think of.
Oh, and when I go to No-IP.com, and they show my Current IP, that is the public one, correct? Or is the 192.168.x.xxx it? I'm pretty sure that one is local though
Another post .>
:( It didn't post...
Well, when I run Realmd, Is the database supposed to be 127.0.0.1;3306;mangos;mangos;realmd
Or should the IP I set be in place of 127.0.0.1?
Sorry for all the questions... I just want want to get my friends on here :|
hey, there any other way to get a SQL? cuz i dont have a credit card or bank account yet (17) any1? if you could upload and email it to me that would be sick too: chaos_link00@yahoo.com
thx in advance
o also to my above post: i am trying to make the server for 2.0.12 if any 1 knows a different guide. atm im just trying to set one of to try and get the gist of it
# Carom
Also, When I configure Realmd to use my public IP, I myself cannot connect, but if I have it use the local one, I can. (Which is what I’ve been doing)
Well ... actually if you want to connect to your own server that is using your public ip, you'll need to do another step :) as described below
Note : if you never do these step, make sure to backup the hosts file located in C:\Windows\System32\Driver\etc
1. Open the Windows\System32\Drivers\etc\hosts using notepad or other text editor
2. And you'll see something like this :
127.0.0.1 localhost
directly below that lines add your LAN IP (the one used to connect to your router) like below for an example :
192.168.xxx.xxx your-no-ip-address
Thats all
It didn’t post…
Well, when I run Realmd, Is the database supposed to be 127.0.0.1;3306;mangos;mangos;realmd
Or should the IP I set be in place of 127.0.0.1?
Yes ... unless you install the mysql in another computer :)
Should I be able to put in my Public IP in realmlist.wtf and be able to connect to it?
Yes ... after you do the above step that is involving hosts file editing :)
Oh, and when I go to No-IP.com, and they show my Current IP, that is the public one, correct? Or is the 192.168.x.xxx it? I’m pretty sure that one is local though
No-ip shows your public ip :) .. as for 192.168. yes .. that is the local
# Chaos Aurion
o also to my above post: i am trying to make the server for 2.0.12 if any 1 knows a different guide. atm im just trying to set one of to try and get the gist of it
Actually setting up TBC server is just the same like this, with the only exception you must get the latest release instead of the old release :)
hi, made a server with your guide and i wanted to make a new one
but the new one i can't login, it stays at "connected" after i login and when i click on cancel it goes to realm select screen, i select the realm and then it goes to the character screen and says connected for the rest of the time
thank you so very much!
Hello bjam :)
Are you trying to create wow server that can be accessed from the internet or else ?
because there're differences between creating server for local only and internet :)
Actually, it was a IP conflict problem. Still DMZed
Thanks
Hi Reaper-X,
thanks for the guide but .... my english is not very good ^^ and i am a noob
it would be easier if u cold upload a folder(perhaps on a Torrent site) where you have already done all the steps so we just have to copy the things an play the game ^^
it would help me a lot when you could do this
thx....
yo if i do the following up there, will ilose the current account i hav eon WOW
i just want to try out a GM i dont want to lose my account on WOW
ok when i run the ad.exe an error pops up and says that it can find the terrian.mpq and when i look neither can I
Is there a link that i can download the terrain.mpq or sumthing
ok I did some research about it and I have a maps folder in my C:\Program Files\World of Warcraft and there were 2 dowloads posted on the site that i downloaded. It still doesnt work. I think that it might be that i have TBC and need a newer version of ad.exe but where can i get it?
Very Nice info here. I am thinking of making priv server but I Still play on bliz servers. Is it possible to have a normal WoW (with BC expansion) and the private version at the same time? Im afraid to just try anyway because I dont want to mess anything up with my current normal WoW setup.
Thank You.
Im sorry for late reply everyone, because my old computer has finally rest in peace, and today i just bought a new replacement for it
# Nincb123
glad you found the solution :)
# West
Although that is possible, but since i dont have WOW TBC installed i think its pretty useless ... btw if you have WoW TBC installed on planning to create server for it, just add me on msn :)
# Ryann
Well ... of course not, because you can change the realmserver (realmlist.wtf in WoW install directory) anytime you wish to go back playing on official server ... ;)
# warcom9292
Hello warcom ... if you want to get the latest ad.exe (if you're using TBC client or to other who's running TBC client)
download the ad.exe for TBC client from :
mangos.svn.sourceforge.net/svnroot/mangos/trunk/contrib/map_extractor/
get the ad.exe only ;)
i want to play with my friend on my own server but when my friend try to connect he see Unable to connect but when i put my IP in my realmlist.wtf all work good i have change all in realmd.conf and mangos.conf to i have put my ip and all work good for me but when my friend try to connect its not workin... idk what i can do now
can i use this even though i have the game, and i have the BC expansion, or will it screw my expansion upp ??
if it does can u send me a link to where i can find a BC one
thank you man
how i configure my port forward? i dont know wherre i have to go plz some1 help meee
i have a modem router and i cant see port forward or anything but i have Enable DMZ with this Host IP address: ............
its maybe my NETWORK i have to configure but how??
ps: this post its for the last post my friend cant connect
# Duke
Port forwarding depend on your router :( ... and im sure your router is different than mine
# ryann
if you use TBC you'll need to get new version of ad.exe, mangos, and its sdb :)
btw get Mangos R3540 and SDB 0.6.4 FULL and you're done .. but if you want the latest version, you should get the latest changeset for SDB and then download mangos revision that is supported by that changeset
Hey,
The link you placed to get SDB is a forum site in which I signed up for, But I don't know where in this site to download it, can you help?
...Actually I am having problems with the SDB in general, so instead could you link me the files I need for SDB, I'm a bit confuzed :)
Thanks
but how i configure my network for let my friend play on my server i have put my window fire wall off al protection off idk what i can do
Hello. I created the server succesfully and all but now what does a friend of mine have to type in the realmlist.wtf when he's on the
-LAN
-internet
I noticed you said something about that so please tell me(detailed).Help appreciated.
what port i have to open for my server
"192.168.2.30;3306;root;******;realmd_bc"
3306 ?
so i put TCP [3305] and UPD [3307] ?
# Steve
Sure ... btw here's link to SDB 0.6.4 (can only be used for WoW TBC client only)
- Rapidshare
-Megaupload
- Sendspace
# Duke
If your using Static IP, the next thing you should do is just configure the wow mangos to use that ip address (in realm.realmlist database)
or you could also use dynamic dns provider, and use it too
# Sold Out
have you changed the realmlist ip address to match the server ip address (i mean the realmlist in mysql database)
# Duke
No you just need to forward 3724 and 8085
The realmlist is 127.0.0.1. I'm also running the server on the same computer, but I don't know where do I get the server ip. When my friend wants to login, the game recognises te server, but then it keep saying "loging in to game server"(or someting like that) ,then it takes him to the realm selection list, he clicks on the only one and it says "loging in to game server" and the all ower again. But his computer sees the server.
"Sure … btw here’s link to SDB 0.6.4 (can only be used for WoW TBC client only)"
Do I only need SDB for Burning Crusade?
Because I'm not using TBC for my private server.
If that's the case I have another problem (I thought it was SDB related)
# Sold Out (dunno why but i always laugh when typing your nick) :P
Ah .. try setting the IP address into your public IP. To see your public ip address, you can use various website that offer ip detection such as whatismyip.com
I’m also running the server on the same computer
If you run the server on the same computer, you must edit your windows HOSTS file to use your lan address (not ip address displayed on whatismyip.com)
if you want to a detailed step on how to edit host file try searching this post or my other wow post for HOSTS file (use your browser search function) :)
# Steve
Do I only need SDB for Burning Crusade?
Because I’m not using TBC for my private server.
If that’s the case I have another problem (I thought it was SDB related)
If you dont use TBC client (WoW Classic Client), you must use the files listed in my other wow post :)
or if you prefer to download from official site make sure you're downloading :
- Mangos revision below 3463
- SDB 0.6.2 Updated to changeset 1.5.6
thats it
Can you just tell me when you are on your msn? It is reaper.x@hotmail.com right?
yep thats my msn address :) ... as for the time ... try looking for "Jakarta Time" using Google and you'll see my current time
I have a magos server and i want to make portals to custom areas...wat i have to do??Cuz i dont know wat to do...pls answer me!..email me at dark_revan_1@yahoo.com pls!
hi, my server works, but i'm not gm. how can i do it?
i run this command
* 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 i'm not gm....
Ok so when are you on it?
Realy good guide so far, But I get stuck at making an account, when i open up the mangosd.exe I just get this error mesage and then it automaticaly closes so i dont get the chance to put in the username and password stuff. Here is the error mesage
2007-05-29 02:33:12 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-05-29 02:33:12 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-05-29 02:33:12 Realm running as realm ID 1
2007-05-29 02:33:12 Using DataDir C:\WoW\Data/
2007-05-29 02:33:12 Initialize data stores...
2007-05-29 02:33:12
2007-05-29 02:33:12 >> Loaded 28 data stores
2007-05-29 02:33:12
2007-05-29 02:33:12 Cleaning up instances...
2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
2007-05-29 02:33:12 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
2007-05-29 02:33:12 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-05-29 02:33:12 ERROR:SQL: SELECT `id` FROM `instance`
2007-05-29 02:33:12 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1180377192)
2007-05-29 02:33:12 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-05-29 02:33:12
2007-05-29 02:33:12 >> Initialized 0 instances, deleted 0 old instances
2007-05-29 02:33:12 Packing instances...
2007-05-29 02:33:12
2007-05-29 02:33:12 >> Instance numbers remapped, next instance id is 1
2007-05-29 02:33:12 Loading Game Object Templates...
2007-05-29 02:33:12 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-05-29 02:33:12 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-05-29 02:33:12 ERROR:Error loading `gameobject_template` table (not exist?)
I am kind of confused as to what to do, and many apologys if this question has already been answered in a different way somewhere elce
I can only talk to you through a mesenger. If I'd tell it here it would put you out of business.
i have cable modem service installed... Please tell me how to configure my server so my other online friend of same ISP and from different ISPs or different Public IP could join me. ( i m not talking about LAN configuration )..
Please Help me....
# Sold Out
Lol ... i thought few days ago i was talking to you via MSN, anyway im currently online right now (when i posted this comment)
# Farhan Ashraf
You just need to change the realmlist table in realmd database to use your public ip / dynamic dns address
and then configure the wow to use it ;)
# No One In Particular
Try re-importing the whole mangos sql
# WoW Fan
Which mangos version you use ? mangos for the WoW Classic or for WoW TBC ? also did you get any error messages when trying to login ?
We've got maNGOS set up and we can log into the server.
We've made a GM account with the software and successfully logged in.
We can't type any GM commands into the window. We type them into the chat window and enter it, but nothing happens. There is no error message or anything.
We want to be able to run our own private server being level whatever with anything we want, but GM accounts don't work!
PLEASE email me with any information you can give us!!
Thanks,
Peter and Jake
Hey, my friend keeps getting this error:
"The application failed to initialize properly (0xc0150002). Click on OK to terminate the application." Buttons: OK
when he starts up Mangos or Realmd, any suggestions?
Where can I find updates at this core...for exemple honor doesn't work and so on.....pls help me.I mean database Update.....especialy honor if u can .......Pls help me
# Peter and Jake
Did you get error message when running the sql command ?
# Ryan
Get the Microsoft Runtime Update
# Daredevil
Which mangos core you're using ? btw if you're running TBC server, you should try visiting the SDB forum :)
Hey,
I managed to get the server running fine and im playing the game. The only problem is that it is extreemly buggy while im playing it. The main bugs im finding is that stuff keeps on falling through the floor (im guessing to 0 altitude or sumthing cos they seem to be the same level) the other problem is that any pet i get is realy glitchy (eg never moves) also quite a few quests cant be completed for sum reason.
Is this normal for private servers?
Thanks again Reaper-X lol this is the first time I have played WoW in English cos in China we get locked out of all the English worlds.
p.s. Sorry about the long posts but dus any1 kno if it is hard to play burning crusade on mangos and if so then how?
Many thanks
I need help, every time i enter
mysql -u username -p -v Acess Denied for user "username @localhost" using password:YEs
and i just don't know what to do, this doesn't make sense since i'm the admin on the computer
a little correction every time i enter mysql -u username -p -v
# No One In Particular
Since i havent tried the latest mangos (Mangos for TBC) i cant say much about it, but yes on 3462 i get the same problem
any1 kno if it is hard to play burning crusade on mangos and if so then how?
Actually its not that hard, but thats depend :)
# utopia
Did you use root as the username ? or did you use your windows username ?
because mysql by default is not using your windows username :)
Me again,
wat url can i get the latest Mangos files from 4 TBC. Currently i have 3463 but i may as well try and find a newer version.
lol sorry for the inconvenience but i havnt got a clue where to download them from.
one more thing, im vaguely considering puting a TBC server on the internet wen i get it working fine. any help would be apreciated, and rewarded by being able to play on there lol
Lol sry me again,
I'v been working on my server but now im confused, I still have all the old files from the normal WoW server on my comp but i have dumped them all from the mysql server. i have the "SDB_0.6.4_FULL.sql" file, its about 130MB. The things i cant find is the updated versions of the files you gave in the "CompleteSDB156-Mangos3462.rar". do i still need them for the Mangos3463?
# No One In Particular
Lol ... no you dont need to worry about reward lol
btw to get the latest mangos compiled for win32 try checking the mangos website under install and config (or something since i dont remember the exact forum name)
as for updated database, you can get full Database dump (0.6.4 combined with latest changeset from SDB website) ;)
arg, lol sry to be anoying, i think im nearly done... im still trying to get it to work for TBC im kind of doing what i can with random files that i find from places and puting them together. first i make the databases wid the create_mysql.sql in the sql file in the mangos folder. then i put the SDB_0.6.4_FULL.sql into the mangos database using command prompt.
Then i add the mangos.sql file from the sql file in the mangos directory, into the mangos database using command prompt again. and then i put the realmd.sql into the realmd database and then the rev170.sql from the forum into the mangos database.
then i make a character and then go into the game. it then says that my coppy cant be validated. i took your advice from way above and then i tried it with all the TBC updates. so im not sure if it is that. I guess the problem is me gettin the files from all over the net or sumthing. do u have any ideas how 2 fix, i have gone thru making the mysql servers a few times but using the above method so it wasnt a typo.
lol i promice that this will be my last question. tyvm for all of ur help
# No One In Particular
Hahaha ... dont worry about it (and sorry for late reply) ... btw if you get invalid game or corrupt when trying to connect to your wow tbc server make sure your WoW TBC Client is version 2.0.12 (if you try to connect to TBC server using Classic client you'll get that message, and i've tried this)
site to get SDB FULL 0.6.2 is kind of dead at the moment... :(
PLS HELP ME !!! How to create acount normal from mangosd.exe ???
I treid to open it but it clouses . Tell me how to create a acount PLS ???
I tink I didnt make step 5 corect . I opened the file with notepad and copy DataDir = “C:/WoW/Data” below . I dad corect ??? PLS help me were I goed rong !!! email me : big_bos_@abv.bg
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
DataDir = “C:/WoW/Data”
If you’re using the example path given in this guide, you can use the above datadir configuration
I am waiting :P HELP my realm exe works and the surver works fine PLS help I cant play :(
And oter thing pls more simple I am a BIG NOOB at making servers :)
10x in advance
U made step 2 to add data base and now my realmd. exe closes :( PLS HELP SOON HELP
it was working :( email me or anser me PLS : big_bos_@abv.bg
I tink I didnt make step 5 corect . I opened the file with notepad and copy DataDir = “C:/WoW/Data” below . I dad corect ??? PLS help me were I goed rong !!! email me : big_bos_@abv.bg
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
U made step 2 to add data base and now my realmd. exe closes :( PLS HELP SOON HELP
it was working :( email me or anser me PLS : big_bos_@abv.bg
I'm stuck at the password. It keeps saying Access denied when I put a password or not. What do I do?
# DarkM
did you specify the username ? (use root)
# BIGBOS
Realmd / mangosd process closed itself automatically could be caused by :
- Cant connect to database / mysql server (you must configure mangos to use mysql)
- incorrect configuration (basically this is already explained why mangos process close itself) :P
I got a mail that if a remake the server it will work but doesnt . :( sory but can tou be more ...
I dont know ... prеciseve PLS . I am a NooB !!!
hello, when i say something, in chat, yell, trade and so on, then it dont appears, that means I CANT TALK TO PPL :S whatt shall ido??
Hey Reaper,
I'm having a bit of a problem getting this server up.
when it comes to logging in (using internal loopback address) I get connecting and disconnected stright away.
If I use the DHCP assinged address for the server I get a little further; it prompts me with the reallist when selecting the realm it keeps looping saying logging into server and then displaying realm list again.
Did you come accross anything like this setting this up?
HOW DO I MAKE MY OWN WOW SERVER!!! plz
# Druzz
if you experience realm loop, there're few thing you should take a look at first :
1. Check the realmd.realmlist (realmd database under realmlist table) and make sure you're using the same ip address there
2. If you're not using loopback address (try stick to loopback first), then you need to set your ip address into the Windows hosts file
3. or try reimporting everything (mysql) and see if there's something strange came in your server.log
# tobi
Well you can follow this guide although if you're going to create tbc server you need to make few adjustments :)
Thanks Reaper, but its still stuck in a loop.
I re-imported everything, server log does not show anything out of order.
apart from this "Quest 3647 has `RequiredSkill` = 20219 but skill 20219 doesn't exist, quest can't be done."
used loopback address and connects disconnects instantly.
put dhcp address for server in clients realmlist.wtf and still gets stuck in loop with or without hosts file edit
any ideas if there is something else in the DB I can change? as it appears the server is broadcasting the game just failing to write/access to the DB to create chars
I know next to nothing about c++ and DB's so I am probablys very very wrong
btw could you tell me which mangos revision you're using ? did you get it from torrent or the official site of mangos (previously someone using wow mangos from torrent and having the same problem like you)
but when i told him to switch to official mangos release and download the compatible SDB (official) it works just fine
Hey reaper,
I got it from your other thread
http://www.megaupload.com/?d=WAL8PNMA
Could you point to the Url for the other relase?
thx for the info but some stuff is messed up when i callect money it do not go to my bag so can u help me
Hi, i'm really new to all this private server thing. Was wondering if you all could help me, i really wanna run my own WoW BC server.
I'd like to know what files/programs i need to download, what i need to do, how to setup... everything.
Latest version if possible!
Thanks!!!
# Leonidas
well you need mysql 5 (currently the latest stable now), mangos and sdb .. thats it
as for mangos and sdb, latest version is not always good especially in this case (unless you know what you're doing)
so instead of getting the latest version of mangos, try checking if the mangos version you're going to use already supported by sdb
the guide is great it work immediatly the only problem is how can my friends connect to my server?
tnx in adnvance
luke
Umm lucky
i think you can use Hamachi You can download at http://www.hamachi.cc/download/list.php
and yeah it connects lan games so if u all have that u should all beable 2 connect
HELP my surver is done i cant create a acount wen i type in mangosd.exe they are ssome zepplin test and boots that keep coming back
and wen this types new line ???????
and also realmd.exe is clousing how to fix ???
HELP I CREATED A ACOUNT BUT CANT START THE SERVER REALMS CLOUSES HELP
2007-06-24 19:49:53 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-24 19:49:53 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-06-24 19:49:53 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2007-06-24 19:49:53 ERROR:No valid realms specified.
OPs i didnt create a acount it say thath mysql is at difrent version or somnting help !!!
the guide was fine tnx.. the only problem was that i couldnt do it public could u help me plz?
public ? im sorry but i dont understand your question. could you be more specific ?
Hey Im getting this error any help with fixing it
Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).
you wont comment on this page anymore ;( Ow well thanx for the help anyways i guess.
(Not sure if i understand the message you are saying (no more paged comments by Reaper X)
If its true, good job and thankyou for helping everyone with their problems, anyway i can help u?
just mail me at an email address i made up with a name i got from yellow pages, (you all seem smart enough to do something illegal, HaHa not sure just to be on safe side, well yea my e-mailaddress is agronala@hotmail.com
# Cirque
aah it seems you're using database from somewhere that is incompatible with the mangos version you're using
for example, you've downloaded mangos (latest version) and you tried using my database from here you'll get that error message because the number of column used (sql) are different
# maker103
no ... actually i always try my best to respond to everyone :)
as for paged comments, back then comments are displayed 10 / page and i decided to not using paged comments anymore because by displaying all the comments on one page you can easily search using the browser search function
thats it ;)
Ok well thanks for helping people likem e out.
Yea I saw you know alot about private servers lol, i hope u can help me for a little bit.
I made my own private server now, but it has many bugs.
I am wondering how do i fix things like, profession trainers not being able to train you or class trainers and things like that. Plus over that bug It wont even tell me how much money i have when I click on my backpack I have also seen many people put custom vendors and and so on…. Hope its possible to communicate with me somehow on this matter.
Btw sorry i am such a noob at this and stuff like that. I hope you can help me though.
Not sure if I posted this before.
I tried to create a Mangos server several times and never got it to work, one error after another.
I found your tutorial and had it up and running in a half hour!
Thank you!
Sup its stab here. im confused about d/l MaNGOS X_x... Can you tell me?
# Everyone
I just finished creating the new guide (two part already finished) and this time with images (based on request) on almost every step and you can find it from :
- First part about mysql installation
- and the second part about configuring mangos itself
http://www.reaper-x.com/2007/06/28/configuring-mangos-for-tbc-server-or-wow-classic-server-setting-up-private-wow-server/
I see you created a new guide nice :D TBC wath version IS it 2.0.12 ???
Hi, could you perhaps tell me what version of mangos and sdb i need.
Your tutorial is for 1.12.1 and when i make a fresh install of my wow it is already version 2.0.0.6080
Nevermind. Saw a link to the 2.0.12 version and just updated my own.
Thanks for the tutorial.
Hi guys, im running a 2.1.1 mangos server anyway myne is working great, but i want to know where or how i can get a sign up page for other to join me, i dont want to use the mangos server.... BTW to create faster acount wait until server is loading and type Create Username password Gmlevel 3
# Bigbos
yes its tested for TBC 2.0.12 only (because most people who's allowed me to use their pc via remote assistance are using this)
# Anthony
hii anthony, thanks for the tips .. as for registration page, i believe you could get one simple registration page from mangos-files.de under misc files section
Reaper my server is runing and I am plying but wen my friends try to connect they cant connect to the realm ??? How to fix ? :D
i am getting an unable to validate Game version i am using the the burning crusade expansion with all the updates and now am on the 2.1.2 patch how do i fix this?
ok nvm that last post by me i got past that and now am getting to the realm list and when i select my realm it just boots me back to the list any way to fix this and how do i do it?
Hey guys im having a problem when getting into server controls, i click the apache/cpl or whatever it is and then the computer reboots. any idea!?
Oh and btw, i did get into server and play once, made 2 characters
Ok its not just the server...any time i get into the dos box my computer reboots now!
Hey reaper! this guide is suppahh! anyway, I have a friend who's trying to setup his own server but unfortunately, we cant download some of the files in megauploads due to slot limitations... do you have other mirrors where we can get it? thanks so much!
I got my server up and running but i cant find out how to Create accounts and upload the webpage for people out side to create a account on or where the site even is....when i go to local host and it goes to the mangos page it wants me to long in for some reason not reconizing im the Admin....also i go told to go to realmd accounts and there is 4 accounts there but it wont tell me there psswrd only there lvl(admin,gm,player)please tell me how to create accounts and where the webpage is to vreate public accounts :) thanks bro fuken awsome post
Ah actually this is the old version since some people requested i wrote guide with images, well i wrote the new version, you can see it directly from the homepage :)
I really want to create a private server for just my friends and I, but the MySQL has to be bought, correct? Or am I missing something? Because I can't buy it.
ok, ive gotten as far as setting up the public server stuff but when i try logging on using my dns address i get a error in wow that says "unable to contact realm sever"
hi i have already made a private server it wasnt extremely difficult i soloed a doomwalker it took me about two hours um the one thing i cant figure out how to make it so my friends can play on my server it would be awesome if i could get an email on the subject zachlaflair28@yahoo.com
Man... in the datadir change pay A lot of attention!!!!
Its not double (") its single!(') or it'll not work!
I made my private server, but i noticed i have no clothes, and im fully nakid!! Then an npc came up behind me and started humping me.. WTF?!
hi i already have a peivate mangos server (its 2.0.10) but i have some huge bugs i can even speak wisp etc :P can u tell me how i fix that all? plz :)
private*
Man, how do I change the name of the server from Reaper-x To My name?
mine keeps loading the zepplins continuously any idea why (the first time i have started mangosd)
# Killclean
I believe i already explained it, if you cant find it in this post try looking at my new wow guide :)
# mitchell0987
if you didnt change anything related to debug message in your mangosd.conf, then it'll display almost every message (including unimportant messages)
I Got it!
Tnx
Hello,
Thanks to this wonderful blog I was able to bring up a Mangos server, I have a problem though.
The engine appear to be up and running (on the console I see the ships moving from Kalimdor to EK)
Im able to authenticate but I cannot log in to server (Mangos default realm)
Im using MAngos 0.8 4096
with SDBFull-203-4123
I had to reload creature_template and creature_loot_template from another sql dump because of an error on mangus.exe (65 fields expected and they was 66 on table)
all the firewalls are down and port 3724 responds correctly to telnet
Database users grants are given (full)
I even tried to use root (same problem)
any suggestion?
Thanks
Im using WoW Client 2.1.3
Reaper how to open up my routher port ??? So other
can enter the server . They can enter the server but not the realm and I like to make a some custom ajustmets how to do that like shops and other ???
I run my own server now. Is there any way to update it to the patch that is currently running on the regular game?
I have noticed that some of the original game is misisng some things and in Outland only half of Hellfire Pennensula has npc's where as the rest of outland doesn't excluding Shattrath city. Also all of the instances in hellfire are empty.
Another issue is that when fighting npc's none of them use spells at all. For example Onyxia doesn't use any of her spells as well as all other raid bosses which make the game far to easy to be half done.
If there is a way to update my private server I would like to know.
Thanks!
i am stuck on step 4. b. when i enter the second line of code i get an error
'mysql' is not recognized as an internal or external command... bla bla blah..
when i press ctl+pause/break nothing happens, i have mysql 5 installed but i dont know anything about it, this is my first time using it.
fabes253@gmail.com = email
tha_fable@yahoo.com = yahoo
fable@auphanclan.com = msn
fabes021 = aim
please someone help me!
please help!
Thanks for everything....my gamecard expired so i had no way to play. I have a problem...when you catch a boat towetlands from darkshore the bot freezes before the splash screen and if i jump off the boat and i freefall through the map. any way to fix this?
i like cant get the commands to work even tho i make a gm account through the mangos program, on that website. only commando that works is gmon and off, makes me invincible and thats wrong
when i use speed command, or mount i get stuck..... why????
the reason you boats get stuck is your mangos is running the correctly, its in your sdb youll need one that runs it, really your mangos should have updtated cordinates running on it all the time of where the boats have moved to, also jordan you can update your wow you just need to make sure your mangos and sdb are both 2.1.3 compatiable (most current at this time) to work other wise you get "uanble to validate game version"
Chris, make sure on mangos type "setgm yourcharname 6" 6 is the highest gm and lets you get all gm commands. also if you type .command in game youll get you whole list.
hope that helps
My friend has a server and all the new charaters start with no skills at all. when you log off you lose your talent build and your skills how do we fix this?
You need to downloud V-maps it will fix your problem with the instants i don't know where i found it but will let you know! (somewere on the mangosproject site.
Has anyone had a "Fatal execution engine error."
MPQE.exe - Common Language Runtime Debugging Services
Application has generated an exception that could not be handled.
Process id=0xc3c(3132), Thread id=0xc82(3204).
The process and thread numbers change everytime i retry it. This happens everytime i get to the second part of step#7. Please someone help me, i have no idea what is going on.
Well ive been thinking maybe my MPQE file is out of date, any idea where i can get the newest one??
My server is working perfectly... apart from the Dark Portal... it's not working -.- i can't go through it... anyone help?
When I run ad.exe I get an error saying error opening patch-2.MPQ or somthing like that but ad.exe keeps running is this a problem? if it is how do I get patch-2.MPQ? ty I am really stuck on this!
I'm having a similar problem to this, as well:
2007-05-29 02:33:12 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-05-29 02:33:12 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-05-29 02:33:12 Realm running as realm ID 1
2007-05-29 02:33:12 Using DataDir C:\WoW\Data/
2007-05-29 02:33:12 Initialize data stores…
2007-05-29 02:33:12
2007-05-29 02:33:12 >> Loaded 28 data stores
2007-05-29 02:33:12
2007-05-29 02:33:12 Cleaning up instances…
2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.creature_respawn’ doesn’t exist
2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.gameobject_respawn’ doesn’t exist
2007-05-29 02:33:12 ERROR:SQL: SELECT `id` FROM `instance`
2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.instance’ doesn’t exist
2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1180377192)
2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.instance’ doesn’t exist
2007-05-29 02:33:12
2007-05-29 02:33:12 >> Initialized 0 instances, deleted 0 old instances
2007-05-29 02:33:12 Packing instances…
2007-05-29 02:33:12
2007-05-29 02:33:12 >> Instance numbers remapped, next instance id is 1
2007-05-29 02:33:12 Loading Game Object Templates…
2007-05-29 02:33:12 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.gameobject_template’ doesn’t exist
2007-05-29 02:33:12 ERROR:Error loading `gameobject_template` table (not exist?)
I WANNA HOST A SERVER, 100 mbp and fast internet, :)
i changed my realmlist source thing to a private server and i forgot to save the original, so what is the original source thing? sorry I know this isn't what this story is about, but i don't really know where else to ask=(
lol ... nah dont worry about it :)
here's the original US WoW realmlist
us.logon.worldofwarcraft.com
HOW THE HELL DO I MAKE THIS SERVER PUBLIC FOR EVERYONE TO PLAY ON ??? IVE TRIED EVERYTHING IM SOOOO MAD !!!!
my msn is swift-strike@hotmail.com please tell me how to fix my problem .
Is anyone else haveing Problems with the Hunter class not being able to Revive Pet and Feed Pet. Also with warlock not being able to pruchase grimores for their pets and able to get thier Other pets like VW SC FH please if anyone knows what the tag numbers for the hunter spells please email me to let me know. jerry_hampton@hotmail.com
WILL U MAKE ME A PRIVATE SERVER PLZ
WILL U MAKE ME A PRIVATE SERVER PLZ?
I am looking for a good GM command compilation. Mainly the command to raise professions to max level and to raise the riding skill to max level. Thanks for your time.
If you get an answer to this question, please let me know. I'm trying to find the same thing.
hi,
i was wondering if you know how i can do something so that when people chat on my irc server from my website what they say shows on the game server(mangos).
Thankyou
unfortunately no :(
Hello reaper
do you mind helping me? ok i got mangos all set up and everything i am able to play on it but is there any way that you can update it so there arnt a 100000000 bugs? such as when i put a money command in it works i can buy stuff but it says i dont have any money and anotherthing is most of the commands dont works
Do anyone knows how i am getting rid of the bugs in the game? made a GM account and tried att the commands..yea its good everything is so cool!
BUT class skills are buged ..cant ware any other weapons. warrior cant ware plate...priest cant ware staff nither, rogue can stealth bug gets buged in stealth and cant move the char..
Most thing in the game are buged! and how do i put up my realm so other can play? plz if anyone knows this issues plz contact me OneWinged_KnightAngel@hotmail.com
For some reason, i cant chat on my server, i cant talk on general, trade chat, etc...whats wrong?
Check the X-Repack. Amazing!!!
http://elementsunited.myforum.ro/
Hello I'm trying to set up my own private server is this server good? "DJ Executable Mangos Server"
If not??? My client is 2.0 enUS is this compatible with your Mangos.
Please Reply Thanks
Do i really have to use Mysql, because i just don't like Mysql or any of the php programs...
yes, you'll need mysql. because that's where mangos read the data (skills, player, etc)
Hi,
I finish the above procedure, but when i run mangosd.exe, at first all seems ok and then display showw lines like these:
TEST Ship moved to -1209.486938 -4533.784180 0.000000
Feathermoon Ferry moved to -5121.050293 3185.962646 0.000000
Proudmoore's Treasure moved to -4263.525391 -4823.310547 0.000000
TEST Ship moved to -1312.261719 -4778.081543 0.000000
Proudmoore's Treasure moved to -4201.202637 -4718.658203 0.000000
Zeppelin - Orgrimmar to Undercity moved to 2731.303467 1577.617310 145.945023
Feathermoon Ferry moved to -5130.470215 3471.471436 0.000000
Proudmoore's Treasure moved to -4100.875488 -4692.390137 0.000000
TEST Ship moved to -1448.969604 -4947.816895 0.000000
Feathermoon Ferry moved to -5089.303711 3705.992188 0.000000
TEST Ship moved to -1652.698853 -5107.111816 0.000000
TEST Ship moved to -14366.628906 1302.032959 0.000000
Feathermoon Ferry moved to -5009.833496 3853.381592 0.000000
Zeppelin - Orgrimmar to Undercity moved to 2318.575439 1226.515869 153.362000
Proudmoore's Treasure moved to -4016.389893 -4740.588379 0.000000
Feathermoon Ferry moved to -4880.222168 3939.895752 0.000000
TEST Ship moved to -14338.303711 1081.086792 0.000000
Feathermoon Ferry moved to -4693.104980 3962.071289 0.000000
Zeppelin - Orgrimmar to Undercity moved to 2123.634033 1023.386597 153.473007
TEST Ship moved to -14366.722656 867.312866 0.000000
What is that???
If i run realmd.exe all seems OK..
I want Antrix Emu or Mangos Emu or Ascent EMu plss i need one who can give me contact me on adress mail shark_blondu1492@yahoo.com Thank YOU
ummmmm i cant get the lets begin side to work im not sure how to do it if you can plz plz plz email me at spidertedder@yahoo.com thank you
When I try running Mangosd.exe it runs and auto-closes, so I look in the log file and it says:
ERROR:Realm ID not defined in configuration file
I tried setting the Realm ID to a list of different things, including the server IP and the numerical values that represent each type of server (1 for Normal, 4 for PVP, as listed in the mangosd conf file) but nothing is working, I keep getting that error.
Aside from that, a helpful and well written guide.
hit me up on AOLIM as m0nk31sl4y3r or I'll keep checking the boards to see if there's a response.
Thanks, D
also, when I try the MPQE step it gives me an error in the command prompt saying
Fatal: Could not locate MPQ archive dbc.MPQ DBFilesClient\*.dbc
D
varithos@gmail.com
Ive set up my own mangos server right,now at a lan i was playing with friends and i came far so i used the writepdump command to save my character and saved it in my server folder,how do i use the loadpdump command to load that account again so i can play with it? plzzz help
Hi,
Do you know any IRC script that can change the channel`s topic to the server status for example:
World: .:ONLINE:. Realmd .:Online:.
Thankyou
that mean, mangos is working ... you can prevent mangos from showing debug information by changing the debug value in mangosd.conf :)
use this syntax :
loadpdump filename account
Thanks for your reply!!
I have another question.. I have setup Mangos in a virtual machine (VMWare) and when i try to connect from my PC, i login correctly and i find the reaper but then it cannot continue to fix my character!!!
Any idea???
you can get Ascentemu at http://www.ascentemu.com :)
hm .. i dont really understand about the "fix my character" part . But i guess you're having problem with realm loop or something ? is that correct ?
Hi,
Sorry to repeat but i really need help !!
Do you know any IRC script that can change the channel`s topic to the server status for example:
World: .:ONLINE:. Realmd .:Online:.
Thankyou
erm .. no .. but i think it's better to search for it in mangos forum
Can i run this on a mac plz email hugh.hage@talktalk.net
Reaper, I have installed mangos and I can login and play in the world, but there are no monsters or npcs. I am using mangos 3462, sdb 0.6.2 with changesets 1.5.6 and I am using wow classic 1.12.1. Is something wrong with my versions or something??
since i dont have mac, im not to sure if it's going to work on mac or not :(
i've only tested it so far on windows and linux (Centos)
did you get error message when importing the database ?
Greetings nice work reaper.
im still stuck whit my boat i dont use any sdb and changeset but my server work bt the boat still stuck sometime dunno what to do.
which sdb and mangos version you're using ?
PLZ WHO CAN HELPS ME HOWI CAN DONE MY WOW SERVER WOW TBC MANGOS SERVER OK?????? PLZ WHO CAN HELPS ME PLZZZZZZZZZZ IF ADNYBODY CANS WRITE HERE [PLZ NOW PLZ
2@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@2
can somebody please give me a web link to site where i can download a WoW emu that uses patch 2.1.3 BC
and doesnt need internet connection or anything. and that i can make me wat ever level i want and have wat ever i want
i'd suggest you to download the emulator first (mangos, ascent, etc), configure it ... and you're done :)
Hey Reaper,
Awesome walkthru man, Im gettin started now DLing all this stuff. In Iraq atm, so its gonna take me a couple days. Trying to get a server up and running that we can all share over here. Will let ya know how it goes.
btw, I did have one question:
Is this compatible with TBC expansion?
im stuck at step 4 at this part (mysql -u username -p -v
pleassssse reaper email me the 0004331.map file,mine is outdated or something,please email to scyn@webmail.co.za
my server is working perfect my friends can get on and everything but there are no npcs :S how do i fix this?
k, been doing alot of reading for the TBC server, tried a few out yesterday (spent all day working on it), and still cant get a working TBC server up. Gonna try getting a 1.12 one up and work from there. Will post what I find.
David,
sounds like you didnt set up the core SDB first then do the change_sets.... same problem I ran into earlier
Hmmm.... having a hard time finding the SDB 0.6.2 DL, anyone know where to go?
I do have a copy of 0.6.2 SDB on my HDD, just let me know if you want me to upload it for you :)
outdate ? try using the new ad.exe to extract the maps first .. btw which mangos version you're trying to set up ?
for tbc expansion, you can see my new guide :)
I cant seem to get the Mangosd.exe and the realmd.exe (or whatever) to run, the two just flash on ther screen and that is it, also the ad.exe file keeps poping up with a debug error? plez can some one help!!!
Hey reaper if it helps im using the MAD server setup on youtube, but i heard you where like a genius so, i can get into the server and see MaNGOS on the realm list, but no matter how much i click "OKAY" it just says Logging into game server and then goes back to realm list
HEEEEEELLLLLLLLLLPPPPPPP
Hi,
sometime ago I posted here and asked how to make a link between an irc channel and the game so when someone chats in a channel in the game it shows in a channel on the irc server....and you said you didn't have any ideas. Well then i kept looking and i found something and i thought maybe you would like me to tell you how and what you need....but first i`m asking you if you want me to...i will wait for your reply ;)
Hello ppl i realy need your help to find a MaNGOS Emulator i have searcged for ages and only find guides from older versions of wow
i dont know what to do if those guides also can handle 2.1.3 ? well if u know something plz tell me i need you
Thanks Spiderpig
DUDE THAT AWESOME
hey, euhmm where do i download these programmes cau?se if i click on the link's i get weird websites and can't find the programme itself:S
bye
can u upload MPQE and SDB Changeset 1.4.1 – 1.5.6 on other sites such as rapidshare cuz i had problems downloading on megaupload. i really appriciate your help.
here's the individual changeset in 1 archive :
http://rapidshare.com/files/54156862/Changeset141-156.rar
while here's the full sdb dump (above changeset already included)
http://rapidshare.com/files/32190487/CompleteSDB156-Mangos3462.rar
i'm still having problems with rapidshare they said that i'm already download the file but nothing. can u upload in other sites or send it to me by email privatemaxzz@yahoo.com i really aprreciate it. i really really want to make this server done thx
were shall i get the mangos server.msi pls send me the link......
When I run mangosd.exe, it just closes right away. I have the lastest version of WoW and the burning crusade is installed. Realmd.exe works, everything else works, but mangosd.exe just closes right away.
DOTCONF++: file 'C:\Mangos\mangosd.conf', line 31: unterminated quote Could not find configuration file mangosd.conf.
Mangosd.conf is in fact in my Mangos folder, so what the hell? Everything is up to date, what's going on here? Reaper please help me. Thanks.
Hey when I type in the cd /d C:\WoW\ thing on cmd it doesn't work for me
2007-09-10 00:03:00 SQL ERROR: Unknown column 'pending_honor' in 'field list'
how do I fix?
2007-09-10 00:03:00 SQL ERROR: Unknown column 'pending_honor' in 'field list'
I forgot to mention it comes up as I click "Accept" in the character creation, I used SDB 4434, and MaNGOS 4423 ScriptDev2 120 aswell as 2.1.3 map extractor... maybe I used wrong ones?
hi great guide, failed at the start, downloads are hard to find, so i found a different guide and made a antrix server and its set up but everytime i log in it got *connecting* then to *anthenticating* now =\ *DISCONNECTED*, can u help me log in please =D or email me at dj_moonlight@hotmail.co.uk
omg, got big headache while got my server working, but still don't understand how to add GM account ?
# Jeff
look at the new wow mangos configuration especially at the update part, because i've uploaded my own compiled mangos version and also mirrored SDB which is tested to work with that mangos version :)
# Jordan
Unfortunately i havent tried antrix yet .. but just in case you want to try out Mangos 4431 look the new guide part 2 at the update section
# Mc
take a look at my previous comment :)
Seem to be a problem with the SDB156 Mangos3462 file .If anyone could kindly post the link to download the (working) SDB156 Mangos3462 file. Pls Help.
Thanks alotz.
i'm still unable to download from rapidshare. it says "download session invalid". can u plz upload MPQE and SDB Changeset 1.4.1 – 1.5.6 on other sites many thx
after setting it up, is there a way to update it to a more recent patch?! (1.1*-2.1*) to get BT, T6, MercGlad, ect
or perhaps a link, thx in advance
GAWD, sry for the spam : / been drinkin a lil bit and keep forgettin what page im on, anyway thx in advance
Ok i manage to get under the mangos pre made admin account. I tried adding my own account it wouldn't make it...and I typed in the scripted provided here. Also while i'm under the admin account...I see no npcs, some words are not shown, some items I can't right click on. At the beginning selection screen for creating characters. I can't select the Drenai nor blood elfs. Is there another file I need to up load to mangos to fix this problems?
I'm really sorry but i have to close the comment here to reduce the server load :( ... and if you want to continue the discussion feel free to use the forums