Configuring Mangos for TBC Server or WoW Classic Server - Setting up Private WoW Server
By Reaper-X on Jun 28, 2007 in Emulators, Guide, Linux, Software, Tutorials, Video Games, Windows
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)
Or you can also look at the recent software section located at the footer section of this website to see the new update to my mangos release :)
This is the second part of the Creating your own World of Warcraft Server using Mangos
- The First part is all about Installing and Configuring MySQL on your Windows Machine
- The Second part is about Configuring the WoW Mangos itself
- The Third part is all about Setting up Private WOW Server for Lan Party
- The Fourth part is all about Installing and Setting up Apache Webserver with PHP
Okay and before i start i’d like to warn you first especially to those who’s using Dial Up Connection because there are a lot of images used here and the previous mysql installation guide although i’ve optimized it further
Without further ado … here’s the guide ;)
Requirements :
If you’re planning on creating :
– The Burning Crusade Server :
Compiled Mangos Revision 3900 or above for Win32 / Windows (the latest revision compatible with latest SDB at the time i wrote this post) but feel free to upgrade it later if you want but do not forget to update the SDB tooSDB Full Dump by Ozay Turay (to make thing simpler) that is compatible with Mangos Revision 3900+Latest Ad.exe to extract map from Mangos SVN RepositoryLatest DBC Extractor
Okay i've decided to upload my own compiled mangos to make thing easier, for more info see this new post
Btw ... the installing mysql part is still the same ... so if you need information on how to install mysql refer to the part 1
Note : Since most people who compiled Mangos for Win32 already included DBC and Map Extractor in their release you should use that one first. And unfortunately i can not give direct link to the files so you must try it by yourself and judge which version is the best for you :)
Btw some people prefer (especially to those who’s using high speed internet access – not me of course –) to download the extracted maps and dbc from somewhere rather than extracting it directly so if you are using the same high speed connection you might like to use this option
– World of Warcraft Classic Server :
- Compiled Mangos Revision 3462 for Win32 / Windows by Maxis
- Compatible SDB Full Dump for Mangos 3462 with Changesets 156
- Compatible Map and DBC Extractor
That’s it … unfortunately since it is using the old mangos revision you’ll notice more bugs compared to latest / newest version for TBC … and since i dont have TBC Client installed, i can only give you a how to guide to configure your mangos server based on my experience when doing remote assistance to someone who asked for help via MSN
Btw if you’re going to create WoW Classic server you can use my extracted DBC Files
Side Note : Basically since there are no differences on creating WoW TBC Server and WoW Classic Server the only thing you should change is just the filename … don’t worry if you don’t understand what i'm talking about right now, soon you’ll know about it :)
Creating Directory Structure :
Okay i assume you’ve finished downloading all the required stuff and now its the time to configure your mangos. But before that you need to extract the required files first into your harddrive and organize it before starting to configure mangos (although this step optional but i think organized directory structure looks better but that is just my own opinion)
Look at the image below for a good explanation about this :
- The daemon directory is where you should extract the mangos program itself
- The data directory is where you should put the extracted maps and dbc folder (soon you’ll know about this process)
- The SDB is just a temporary directory to be used when importing the SQL Files
Extracting Maps and DBC Files from World of Warcraft Game :
Now this is when the ad.exe and dbc extractor came. But first we are going to use the ad.exe. And here’s the step
- Copy the ad.exe into your WoW Game directory (usually C:\Program Files\World of Warcraft)
- Create folder called maps
- Run the ad.exe and wait until its finished
- Move the maps folder into C:\WoW\data (if you’re using the same directory structure like me)
After you’ve finished extracting maps now it is the time you use DBC Extractor … and here’s the step to use it
- Extract the MPQE.exe (and it’s dll if available) into your WoW Game Data directory (C:\Program Files\World of Warcraft\Data)
- Create shortcut to the MPQE, right click on it and choose properties and adjust it’s target into "C:\Program Files\World of Warcraft\Data\MPQE.exe" /p dbc.MPQ DBFilesClient\*.dbc
- Run the shortcut and wait until it finished
- Rename the DBFilesClient folder into DBC
- Move the DBC folder into C:\WoW\data (if you’re using the same directory structure like me)
If you want a more detailed explanation look at the screenshot below
and then the shortcut properties
Importing the SDB Files :
Okay we have finished extracting the maps and dbc files required for mangos, now we need to import the database first before you can run mangos program
and here’s the summary on how it done :
If you’re going to create WoW Classic Server
- Extract the SQL files from my mangos sql dump into C:\WoW\SDB (if you follow my directory structure)
- Open Command Prompt
- Run the sql query from the command prompt (look image below for an example on how to use the query)
and here’s what it’ll looks like when it’s finished
Note : Because some people prefer to see the importing process (some say it’s like Matrix .. lol), i decided to use -v (verbose) switch but if you prefer not to see it you can safely remove the -v switch
If you’re going to create TBC Server
Here’s the summary on how it’s done :
- Extract the SDB Full Dump for Mangos Revision 3900 into C:\WoW\SDB
- Extract the Mangos Program / Archive into C:\WoW\Daemon\Mangos
- Go into C:\WoW\Daemon\Mangos\SQL
- Copy the create_mysql.sql and realmd.sql into C:\WoW\SDB
- Open the Command Prompt
- Execute the same query as above but adjust the filename first
An example on how to execute the query is like below (you must do this in order) and using the same path as the above image
- mysql -u root -p -v < create_mysql.sql
- mysql -u root -p -v -D realmd < realmd.sql
- mysql -u root -p -v -D mangos < the_filename_used_on_sql_dump_from_e_turray.sql
And that’s it you’re finished importing the database required :)
Editing Mangos Configuration :
You’ve finished extracting maps, dbc and already imported the database required but now what else ? of course you need to edit the mangosd.conf file itself
Now here’s the summary on how it is done :
- Go into C:\WoW\Daemon\Mangos
- Open the mangosd.conf using wordpad (you can not edit it using notepad, because it is using Unix Line Break)
- Change the datadir into C:\WoW\data
- Save it
Now here’s some screenshot of the mangos configuration file editing process :
Make sure everything is working as it should :
Now you’ve done almost everyting required to make your own wow private server … now before started playing it you need to make sure that everything is okay before starting to connect to your own server
Here’s how it is done :
- Run the realmd.exe (C:\WoW\daemon\mangos\realmd.exe)
- Run the mangosd.exe (C:\WoW\daemon\mangos\mangosd.exe)
- See if one of the above process close itself automatically or not. If one of the process close itself automatically after launched that means there’s something wrong with your configuration try restarting the configuring process from the beginning
And now here’s the screenshot if your mangosd and realmd process is working as it should :
The last step for configuring mangos and wow, editing the Realmlist used by WoW to connect :
After everything is okay, now there’s one more thing left for you to do … which is editing the realmlist.wtf file inside your WoW Game directory (C:\Program Files\World of Warcraft\realmlist.wtf) using your favorite text editor. You can use notepad or wordpad to do this
The default realmlist.wtf file should be like this :
set realmlist us.logon.worldofwarcraft.com
and then change it into
set realmlist 127.0.0.1
Creating Test Account for yourself :
Okay now you’ve created and set up everything but there’s still one more thing left and that is creating a test account with normal player status for yourself. And this process is really simple actually all you have to do is just typing this on the mangosd window (above image)
create desired_username desired_password
Okay that’s it you just created a test account that can be used to connect to your own wow server. If you get error message and / or stuck at realm loop i'm sure there’s something wrong with your configuration or you’re not using compatible mangos / wow client
That’s all for this part … stay tune for the next part ;)
As a side note, this is the first time i'm using lots of images on my guides and i'm looking forward to your opinion about this (tell me if you like it this way or would you prefer text with few screenshot or images) :)
Update :
To those who’s still having problem with Mangos like finding the correct mangos version,etc. I’ve decided to upload my own compiled Mangos Revision 4431 with Scriptdev2 241, and also included DBC Extractor (Thanks to XLayer for his DBC Extractor) and VMaps Extractor. And also mirrored the SDB 0.7.3 with Changesets 208 from http://opensvn.csie.org/NewSDB
And here’s the file :
Mangos 4431 with ScriptDev2 124SDB 0.7.3 with Changesets 208
Another Update : See my new post about new Mangos 4488 Update with Silvermoon Database ... and tested with WoW 2.1.3 Client ... just look at the screenshot below
All you have to do (i assume you’ve completed all of the steps involving mysql installation, and also already extract the DBC and VMaps files) is just :
1. Import / Overwrite the database with this new SDB (if you want the easiest way to start all over again from the Importing SDB step, you can execute the create-database.sql inside my Mangos 4431 archive (in reaper-sql directory) using this command :
mysql -u root -p < create-database.sql
mysql -u root -p -D mangos < SDB_0.7.3_Changeset_208_Rev1.sql
mysql -u root -p -D mangos < reaper4431.sql
Note : Make sure you’re in the same directory as the create-database.sql and the SDB_0.7.3.sql when executing that command
2. And then the next step is, importing the sql files inside the scriptdev2-sql directory (2 files) like below example (must be in order) :
mysql -u root -p -D mangos < scriptdev_full.sql
mysql -u root -p -D mangos < scriptdev_additional_req.sql
And you’re done :)
Perhaps the above might sound confusing for some people, so if you need help just leave comment here
Here's a screenshot taken using Mangos 4488 Scriptdev2 134
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
Nice guide mate. Good work
hei, i got a problem. Can you help me?
I have set up my mangos and everything seems to be working. Mangosd.exe and realmd.exe load without errors, but when i open my WoW and try to connect to it any account (the ones that i created or given ones) it goes through everything till "connected" waits there 30 secs and gives me "disconnected" ... mangosd and realmd don't show me any mistakes so i don't know what to do. Help me if you can.
Thanks in advance.
# Woodrick
thank you very much for your kind comments :)
# Player
Well first of all i need to know which mangos revision you're running (and did you get it from torrent or mangos website), and database also what WOW version you're running ? is it the 2.0.12 (TBC) or 1.12.1 (Classic)
Well i have to say, it's a really nice guide. keep and the good work, and the screens help alot, so keep em to :). I've made a fuctional classic WoW server with your other guide.
But now, the MPQE part doesn't work, i put the MPQE.exe in the Data folder of WoW (along with the .dll) and make a shortcut and so on, but when i run the shortcut it just says "dbc.mpq not found".
Hope you can help here.
at the :If you’re going to create WoW Classic Server
1. Extract the SQL files from my mangos sql dump into C:\WoW\SDB (if you follow my directory structure)
2. Open Command Prompt
3. Run the sql query from the command prompt (look image below for an example on how to use the query)
I just press enter when it says "Enter password:"
but the second time the "Enter password:" i hit enter again then i get the "ERROR 1045 (28000): Access denied for user '-p'@'localhost' (using password: NO)
then it just sends me back to "C:\WoW\SDB>"
plz help !!!
im really sorry i uploaded the wrong image (but now i've fixed it) :(
to fix it just use -u root at the last part
Same problem as Ax above, it came up saying "Could no locate MPQ archive dbc.MPQ"
hey i got it to work. but evey time someone trys to join my realm it wont let them join
any ideas why
edit: they can login and see the realm but cant join it
Everything seems to work, except when I try to talk to an NPC, it plays the sound of them talking but doesn't give me a window.
Closer inspection shows that combat works, but looting corpses doesn't.
Works now. I may have been being an idiot and using the wrong button before (pretty sure I tried it, though).
SQL ERROR: Unknown colum 'I' in 'field list'
Got through all the errors, finally got it to work, and when I goto create it gives me this error -roll eyes-
New question: Which file do I need to edit to change the realm name from ReaperX? I can't find it in realmd.conf or mangosd.conf and I don't know where else to look.
Hiyah! great guide I've got my server working wonderfully, except when I try to make a GM account I get an error,... this is what I enter at the command prompt ( it is a TBC server, and is working, except for this GM thing )
C:\>mysql -u root -p
Enter password: **********
mysql> USE 'realmd';
Database changed
mysql> INSERT INTO `account` VALUES (NULL, '*My username*', '*My Password*', '3', NULL, NULL, NULL, '', CURRENT_TIMESTAMP, '0', '127.0.0.1', '0', '0', '0000-00-00 00:00:00
', '0','1');
ERROR 1265 (01000): Data truncated for column 'failed_logins' at row 1
mysql>
Thanks in advanced! ^_^
# Poss
Could you tell me which database version you're using ? also did you get that error message when importing the Mangos SDB file or something else
# Mikeh
You can change it from the dabatase using this command :
1. mysql -u root -p
2. use realmd
3. update `realmlist` set `name` = 'My Server' where `id` = 1;
4. quit
# Cara
I've tried reproducing that error message by running the same query and i found nothing because it works just fine
could you tell me which mysql version you're using ?
or you can also try reimporting the realmd sql (drop the previous table first but please note, you're going to lose the previous data)
I'm using MySQL server v.5.0.41, and I still can't get that to work, but I found another way,
from the mangos command line screen, you can type
setgm accountname 3
seems simpler to me and it worked like a charm....
I cant seem to find this
When I use the shourtcut MPQE a cmd window only shows for less then a second and I cant seem to find the DBFilesClient
#ReaperX: Thanks!
#Cara: I think between the NULLs and CURRENT_TIMESTAMP, that's supposed to be two single quotes, not a double quote. But I agree, it's easier to do it from the mangos console.
I got the same problem as Ajx
When i run MPQE.exe shortcut
it pops up less then a second then its gone
i cant find any of the DBFilesClient folder.
Im pretty sure its just a small thing im doing wrong, but i cant seem to find it :(
and thanks for tutorial :)
the mangos link is broken. would you mind stickin another one up there so i can grab that mangos program?
thanks a bunch! :)
I got so close,then i realized the compiled mangos revision 3900 link no longer works! can i get a new link please? so far this has been awesome,if i can get my own server up,it will be dedicated to you.
When im running ad.exe this error comes up:
Debug Error!
Program: D:\Spel\World of Warcraft\Maps\ad.exe
This application has requested the runtime to terminate in an unusual way. Please contact the applcation's support team for more information.
(Press Retry to debug the application)
If i press retry whole thing just shuts down
Waiting for answer :) Thanks in advance
I don't seem to have either .exe file, someone help... got the file from https://svn.mangosproject.org/trac/MaNGOS/wiki/MaNGOSDownload
I downloaded it off another link, have to re-set it up now, got the .exe files now...
Doesn't work. I'm getting errors when I try to make the SDB.
2007-07-05 02:02:57 World Database: 127.0.0.1;3306;root;[password];mangos
2007-07-05 02:02:57 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-07-05 02:02:57 ERROR:Cannot connect to world database 127.0.0.1;3306;root;[password];mangos
---
2007-07-05 02:02:53 Verbinde zur Datenbank: 127.0.0.1;3306;root;[password];realmd
2007-07-05 02:02:53 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-07-05 02:02:53 ERROR:Cannot connect to database
# Elliot
i believe that error message was caused because you're using incorrect root password so the only solution is you must use the correct root password
and about the .exe file. Which version you're using ? and where did you get it ?
# Ryan
I just double checked every link and i cant find the broken link you've mentioned ? perhaps its just temporary downtime
# David
From your comments, i can see that you're trying to run the ad.exe in / under the maps folder, try moving the ad.exe from the maps folder into the root directory of your world of warcraft installation
for example
D:\program files\world of warcraft\ad.exe
but don't forget that you must already created the
D:\program files\world of warcraft\maps
directory ;)
For the record, the images are EXTREMELY helpful.
OK I've setup my server, and I can use it and everything is wonderful... now I'm trying to get my boyfriend to connect to my server (over the internet not LAN )
I setup a dyndns , and used the address in the realmlist.wtf for him, set my PC as the DMZ, and created an account for him, he is able to connect and log in , but when it gets to the character selection screen ( I logged in and made a character for him ) it just takes him back to the realm selection screen , and keeps doing that, ... any ideas?
I can't get it to work... I am using the correct password. Any chance you could talk to me on msn? (cruelblue@gmail.com)
I made the whole istallation and made an account,but when I try to log in it gets to "Handshaking" ..and that's all,it freezes there. HOW can I fix this problem?
Is it possible to wipe the entire thing and start over? I think I know whats causing my problem...
Damnit, MPQE.exe keeps saying dbc.MPQ not found! Weird...
I just downloaded the actual sdb.sql instead of using MPQE.exe, can't remember where though...
Wait! If you want to create a TBC server, shouldn't you use expansion.MPQ instead of dbc.MPQ?
'Cause there is no dbc.MPQ inside my Data dir...
Take a look at my Data dir: http://img149.imageshack.us/img149/6947/naamloosxv6.jpg
How do I reinstall mysql? I need to start over, and the bloody thing won't leave me alone. (ERROR 1045)
Ok, just looked on the Internet. It seems that all of the .MPQ files are compressed by TBC to two big MPQ's: expansion.MPQ and common.MPQ. Any idea what to do with those things?
I just noticed a file called mysqlaccess.conf inside my mysql install, will that help with anything?
awww, someone help. I've already made my own custom set of uber armor and I want to use it... what timezone are you in Reaper-X? (I'm GMT) I want to speak to you on msn...
Right, time to delete mysql from program files and the registry. wish me luck.
crap. now I'm getting this:
The filename, directory name, or volume label syntax is incorrect.
I did a few tests, and it goes all the way down to C:\ with this message. HOW CAN C:\ NOT BE THERE? stupid computer.
YOu have quite a big conversation here :P and do you know something about my problem ?
The mangos folder might be corrupt, or it might be a bug with mangos, or its your computer acting up when you run WoW. thats what I think.
Aha! I was typing /r instead of /d in the command propt for some reason. silly me. :P
Crap. Error 1045, (look further up the comments)
then after that I get Error 1049
Unknown database
When i run the MPQE shortcut, I don't notice anything happen. Where does the DBFilesClient folder come from? Is this supposed to be extracted by running the MPQE.exe? I can't seem to locate this folder, unless im missing something.
Any help would be nice, thanks :)
I might just try Antrix, it looks a lot easier...
Still, Reaper-X try to talk to me on msn at some point. I still want to talk to ya! :)
Ok, I take it back, I had a look on forums, and I think I'll stay with mangos, I just need it to work :P
How do I wipe my db and start from scratch? lol, its trying to load my first db.
here i took a screenshot http://www.imageupload.com/out.php/i8730_error.JPG
sorry when I try to extract the map I kept getting this http://www.imageupload.com/out.php/i8730_error.JPG
please help, thank you
I am also getting the error that dbc.mpq is not found at the Step to use MPQE.EXE.
I think the problem is I am trying to do this with the WoW 2.1.0 client, Your guide does not say which version to use but everywhere else I look the latest version to use is 2.0.12 ONLY.
Please let us know.
Thanks
The guide is ONLY for 2.0.12
And Juzzy put the ad.exe into C:\Program Files\World of Warcraft and NOT in C:\Program Files\World of Warcraft\Maps
I think that will solve the problem with the error.
Urgh... downloading 2.0.12 of mangos.
If you gonna set a Mangos TBC serv then the game version have to be 2.0.12
I got it working but my root user doesnt have the right permissions apparently
...this is quite annoying.
Access denied for user 'root'@'localhost' (using password: YES)
the .exe files won't start and I find this in their logs. whats happening? (Everythings right, ie: password)
# Zak
I made the whole istallation and made an account,but when I try to log in it gets to “Handshaking” ..and that’s all,it freezes there. HOW can I fix this problem?
Which mangos and sdb revision and you're using ?
# Elliot
To make sure you're using the correct password, try typing this from the command line :
mysql -u root -p
and then enter your password
if you're using the correct password you'll get this message
Welcome to the MySQL monitor. blablabla
OK I removed and installed from scratch, when I upgrade to TBC the file dbc.MPQ is removed.
Please advise?
ok... getting further but still stuck. At the last steps.
I used:
"C:\Program Files\World of Warcraft\Data\enUS\MPQE.exe" /p locale-enUS.MPQ DBFilesClient\*.dbc
copied the map, the .sql files I found were create_mysql.sql, realmd.sql and mangos.sql. those went fine...
problem is I run mangosd.exe and it crashes, I get "ERROR:... table is empty!" errors.
can I email you the error log file?
Check this:
DBC files
Client database files store various things like area names. They have a uniform structure, where they can include a collection of data records having data fields of various types. The original files are found in dbc.mpq. The newest ones are in patch.mpq as
DBFilesClient\*.dbc
Since (I guess) Burning Crusade, the *.dbc files are now in the "World of Warcraft Folder\Data\{local}\" directory.
Original files are in the base-{local}.MPQ. Newest are in patch-{local} files.
For english client, {local} is enGB, for french it's in frFR, German in deDE, etc.
Doesn't help, It is the right password. I can log into mysql but when I run Mangos.exe or Realmd.exe I find this error in the logs.
2007-07-06 10:06:40 Verbinde zur Datenbank: 127.0.0.1;3306;root;[password];realmd
2007-07-06 10:06:40 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-07-06 10:06:40 ERROR:Cannot connect to database
ok you probably hate me by now...
I got it running on BOX A. BOX A is my "file Server". I can connect, login, play from BOX A.
But I want to play from BOX B (which I loaded WoW client 2.0.12 on, I connect. It lets me login, but it loops the realm selection screen. If I cancel it, it takes me to the character screen but no characters load and all options are grey except "Back" and "Change Realm"
Any help?
I've got past the dbc.MPQ affair, but now the damn MySQL command isn't working, it says something about "MySQL isn't recognized as a program or service"... :S?
#Reaper-X
I am with MaNGOS4002+ScriptDev2rev62+MCH_nosave+VMAPSRELEASE and SDBFull 197 V2 Updated database.
I turn On the server and it goes perfectly.
But when i try to log in it just stays on "Handshaking"...
WHat should I do?
P.S:SRy for bad english.
Fixed, the install file was corrupt and ZoneAlarm was interrupting the MySQL Security settings...
ok I found the issue,
in Part 1 you tell it to not allow user 'root' to be used remotely. then when you configure the .conf files you are using the login for 'root'
you will need to make a new login, give it access to the realmd and mangos databases and use that username/password in order for it to work remotely.
Its working now, had [ ] at the ends of the password... but now I get an error with the MaNGOS-GUI.exe, it says it wants a configuration editor.exe, any ideas?
Ok, nevermind, I can't seem to retrieve the realms. any ideas?
On step 1 i can't find MySQL Community Edition. Where is it?
When i attempt to extract the dbc files from the data folder the command window comes up for a split second before disapearing. I searched my computer for the folder it should of been extracted to "DBFilesClient" but it doesn't exist. WTF I say...
# Elliot
Mangos-Gui ? did you use any other program to edit the mangosd.conf ? if so try editing manually (btw this is my preferred method) :)
# To everyone who want the easiest way to get WoW DBC Files for TBC
you can look at this page
you just need to download it and you're done :)
# thejoester
you will need to make a new login, give it access to the realmd and mangos databases and use that username/password in order for it to work remotely.
yes ... actually if you import the realmd sql files from mangos, you already created new account to be used specifically on mangos database and realmd database
as an addition, if you run the mysql server on the same computer you dont need to give remote access beside most people prefer to use database (including various website) on localhost for security purpose :)
# Jake
you can get mysql community edition from :
http://dev.mysql.com/
when i was testing to make sure that i had configured the mangosd.conf file right, the realmd worked and stayed up, but when i tryed to use the mangosd, it would pop up for a second, then it would close. what should i do?
ok, i figured it out, so scratch the last comment, but now i have another problem. When i try to log in with my realm, it says that it cant validate the game version. It says it either might be corrupt or another program is interfearing with it. What should i do and what part of the program is messed up?
does having multiple versions of SDB dumps and mangos do anything to using the server? now i cant connect at all. it says cant connect once im in WoW and it has buttons to show help and a button to go back. Now i dont know what to do with it. I dont know what to change or what to delete or what to replace.
When I start doing the checks to make sure everything is ok. like the mangosd.exe I got a error that says
This application has failed to start becuase LIBEAY32.Dll was not found. Re-installing the application may fix this problem
It might be becuase I couldent figure out how to put
mysql -u root -p -v -D mangos
didnt say my last line sorry.
mysql -u root -p -v -D mangos
the_filename_used_on_sql_dump_from_e_turray.sql
Ok all is fine, no errors at all, until i go to log in to get on my server. It tells me that it is unable to connect right from the get. I figured that it was some kind of install error so i reinstalled everything however nothing changed.
i used both the sdb 4029 and mango 4029
i trying to get TBC on
and everything I got i got from a link on your page. And i didn't touch n/e thing i didn't have to
oo and i used the mysql 6.0 could that be the problem?
When running the shortcut to MPQE with the correctly adjusted target I get "The application failed to initialize properly (0xc0000135). Click on OK to terminate the application." I followed everything to the letter so far, can you please recommend a solution?
ok, im stumped, i followed the guide everything was fine till the end when you need to connect to the server when i start mangosd.exe and realmd.exe both create a log saying "ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)"
id appreciate any help
I'm sorry that i'm answering so late. I fixed the problem the same day... after an hour or two and forgot about the post really sorry :D )... the problem was connected with my database, i didn't upgrade it :D. Added few addons and everything went fine. Anyway, thanks for trying to help me :D.
Good luck.
All working, I can log onto the server and add items etc, can't edit my database though, and I need to set it up as a local so my brother can join on another computer.
Kirt what you do is you put the name of the SDB dump you used and just put a .sql on the end of it, you dont actually use the_filename_used_on_sql_dump_from_e_turray.sql. For mine it was mysql -u root -p -v -D mangos
I have the same problem as Ajx and zat, When i try to run my shortcut to MPQE.exe the command promt pops up for less than a second and then the command prompt just shuts down. Neither i can't find the DBFilesClient folder. At this step i really doesn't know how to do :S, i think i need a little bit of help here.. Also, when i install MaNGOS server, i don't really know what too write in the "Enter MySQL information" step. Help.
I found to resolve this I had to move the MPQE.EXE into the /data/enUS/ folder and used the command
“C:\Program Files\World of Warcraft\Data\enUS\MPQE.exe” /p locale-enUS.MPQ DBFilesClient\*.dbc
because the dbc.MPQ file does not exist and it was renamed/merged with locale-enUS in the C:\program files\World of Warcraft\Data\enUS folder.
ok i fixed my problem with a new version of mangos. and a diffrent sql dump file (tried about 10 to find a working one, most you gotta make sure to add updates before entering) anyways my server comes up now but i guess im to high a version in wow. anyway to get delete a version without uninstalling and doing it all over again?
thanx
When in the CMD menu for mangosd, and I've gotten it to all work, when i type in the command to find the three already made users, how do I find out the passwords to the accounts?
hey dude this guide is awesome but im stuck on the configureing part for TBC i cant firgure out how from keeping realmd.exe and mangosd.exe from closing well mangosd is the only one that closes i looked at the error and it says this 2007-07-11 04:41:20 SQL ERROR: Table 'mangos.character' doesn't exist
2007-07-11 04:42:23 SQL: UPDATE `character` SET `online` = 0
2007-07-11 04:42:23 SQL ERROR: Table 'mangos.character' doesn't exist
oh and im sorry i f2007-07-11 04:58:13 SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'orgot it says this too
2007-07-11 04:58:13 SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
# Shadowstorm138
I believe you didnt imported the mangos database dump correctly :) because mangos can't find the character table in the mangos database (mysql)
# Chrisb
Perhaps it is possible, but i havent tried it yet. But if you know about the registry used by WoW im sure that will do the trick (btw i always use this because i often reinstalling windows from clean ghost image), and to make the game installed previously in another drive worked with the clean install of windows, i just need to reimport the registry keys used by the game
# thejoester
thank you for the tip joester ;)
ok i got it, i just reinstalled wow, but on my other drive, also keeps me from havin to switch realm list. Thanx for makin this guide. works like a dream, and the fact that you help out after wards is even better, thanx alot
thanks a bunch man but i have a question what should i do to make sure i imported everything right? which steps should i redo thx in advance :)
Hi!
I've got this problem while running the mangosd.exe checking if everythings alright. When I start the mangosd it shuts itself down and when I check the server .txt document it says the map-files are outdated and that they couldn't find them. What can I do to fix this?
and thanks for a very nice tutorial!
i look in the server notpad and it says this 2007-07-11 13:42:36 ERROR:SQL: UPDATE `character` SET `online` = 0
2007-07-11 13:42:36 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2007-07-11 13:42:36 Initialize data stores...
2007-07-11 13:42:36 ERROR:
Some required *.dbc files (19 from 35) not found or not compatible:
C:\Program Files\private world of warcraft server\Data/dbc/AreaTable.dbc (exist, but have 35 fields instead 27) Wrong client version DBC file?
C:\Program Files\private world of warcraft server\Data/dbc/BattlemasterList.dbc (exist, but have 32 fields instead 24) Wrong client version DBC file?
Hi! (again)
Now I seem to have fixed the problem concerning the maps by repairing my 1.12.1 version of WoW and extracting them with ad once again but now instead 7 of my .dbc-files are marked as incompatible, I extracted them with mpqediten32 instead of MPQE. Is this the reason that they aren't working or can you think of another?
thanks once again
reaper-x i was wondering wat to do to get htis ad.exe thing i have no idea wat it is or how to get ima noob when it comes to computers and configuring things im just good at playin them so if u could get back to me at T_Bone717@comcast.net
Excellent work.
Thanks so much for taking the time to do this.
i wanted to create my own TBC server but having trouble with starting it
I always get message "ERROR 2006 (HY000) at line 753: MySql server has gone away" in command prompt
Please post if any one knows what am i doing wrong
I forgot to mention that i have version 2.0.12 installed and i was trying with different Mangos servers but without any luck
ok i'm not sure if ne one can help me but it would be great. everything is working (all the pre test mangosd.exe and realmd.exe and the mysql)and the pics were outstanding but when i go to log in to wow i get a message saying i was unable to connect and i have tried everything do i need to be connect to ne thing other then mangosd.exe to start the server and if so what? i'm trying to get TBC and i used 6.0 mysql and mangos 4089 and SDBFull 4067 with the latest dbc download. If i could get some help I would be trilled.
oo and shadowstorm go back and get the new DBC download from his link on july 7 i think they updated it or something but i was getting the same error till i reinstalled the 2.1.3 and it quit with the error but then i ran into this. good luck
I have mangos 4085 running. I am able to log on and play but I am noticing some issues like it says TBC is not installed but i am using SDBFull-202-4067 dump during the setup of the server which was linked under the TBC setup section. any suggestions?
Does the classical version REQUIRE you to have v1.12.x or does it matter?(as long as it's NOT TBC?)
[THIS IS FOR CLASSIC SETUP]
When I go to change to Shortcut to MPQE's target to: “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc
it says "The name "C:\Program' specified in the target box is not valid..."
What am I doing wrong?>
lol sry but ignore my last comments...it is 3:57 AM here and I've been working on this since 11:30 pm>
well its 6:00 am and all i need to do is update WoW=) then try and login hehe...wanna say WONDERFUL to to ya man=) awesomest thing ever...lol
was wondering if I can use my IP as realmlist and just play by myself as GM? (and how do i make GM account?
Ok, for those having problems with MPQE, go to google and look up WINMPQ. Use this to open the enUS versions of the patchs. Start with locale-enUS, extract those files, then extract the ones from patch-enUS and extract to the same folder as the locale and then do the same with patch-enUS-2. If you do it in that order, all the database items should be correct.
Err, i meant to post this in my last comment, but i've been getting an error whenever i check anything that has to do with character stats. So like, when i hit C in game to check equipment it disconnects me. it says something about an access violation. Same happens with honor and reputation.
Small problem, I got my server working fine except the HTTP/PHP thing.
I cannot create any new accounts. I type "create test new" and I get this: User test with password new NOT created (probably sql file format was updated).
I have SQLyog and managed to log on to the database in question. There still isn't a user named test but I have noticed that there isn't a field in the table for password, unless is the one I have named "I" because it is encrypted.
Is there something in my realmd that should be there but isnt?
Edit: I did some experiements, I can change the GM Level (Mangos), delete accounts (Mangos), and add accounts (SQLyog, no password). I still cannot create them within Mangos. I think the password field is missing, but I dont know the how the field is setup for it. Can someone look at their realmd and tell me the setting for the table?
Hey Reaper, when i try to do the CMD part (SQL Query) it come up 'cannot find file' or somthin like that. can you plz help? or anyone else, got any suggestions? it would be greatly appriciated.
hey,
i keep having a problem, i followed your guide and when i put MPQe into the data folder, nothing happens, a command prompt thingy opens and then it closes, can anyone help me? because the next step is "Rename the DBFilesClient folder into DBC " i dont get that part. please help me,
thank you
I've gotten as far as checking mangosd.exe and realmd.exe files in your "Making sure everythign is working" section. They both stay open for maybe 1 second, then they close by themselves. Then two log files open up and say the following:
server log says -
2007-07-15 22:23:20 ERROR:Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
2007-07-15 22:23:20 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
realmd log says -
2007-07-15 22:23:17 ERROR:Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
2007-07-15 22:23:17 ERROR:Cannot connect to database
And that's about as far as I can get. Any help would be appreciated! Thanks!
I got to the step to create the shortcut to MPQE and change the Target except when I do change the target to “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc it says that the target isn't valid and I should check to see if it exists. Please help cause I have no clue.
i get to the part to copy shortcut MPQE and i change the target to C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc but all it does is pop up for a sec and nothing happens.
I tried putting it in the data/enUS folder as well and nothing. Am i missing somthing here?
THANK YOU SOOO MUCH REAPER!!
i figured out my problem!
YOU ROCCK!
Man, I need to ask you a Question....
Which Archives I hav to replace , or what do I Have To Download to update My server to the lateste version?
hey thanks for the guide,
but i'm having a problem plz help me!!
when i run mangosd it works ok then it stops at "loading items....it says error in itemtable probably sql file format was updated (there should be 132 fields in sql)
i cant get passed, that! can you plz help!
i downloaded the dbc files from the link you posted because i couldnt get mpq to work. im trying to make the private server on tbc, my wow is in german, maybe there is a problem with the dbc files and the fact that my wow is in german?!?!
thanks!! plz help!
. . . to answer my own questions, my problems with the MySql error 10061 seemed to stem from ports set by MySql and Mangos/Reaper not coordinating. I forwarded 3306 in my router settings for MySql, and Mangos/Reaper configs are set to port 3307 (which the my.ini file of MySql says it is "listening for"). After coordinated all of this, I now have both realmd.exe and mangosd.exe humming along and it matches the images that Reaper has posted.
So for anybody else who hits the MySql 10061 error, it seems to be a communication issue between MySql and Mangos.
hi when ever i run the mangosd.exe it gets stuck on race 10 class 2 level 1 does not have status data. it worked ok the other day, can you please help me. thanks
Hey, my friend recently got his MaNGOS server up and running the other day. However, when playing the game, it seems that the base character stats are very low for level 70 characters. I noticed when going from level 60 to 70 you don't get the correct amount of health. For instance, on a Tauren warrior you get like 100 health from 61-62. When in game it's around 200 or so. My base health at 70 was only like 3k. In my real subscription game, my base health at 61 is 3k. Do the clients need to have 2.0.12 only installed. Is this due to the fact that I have 2.1.3 along with everyone else on the server.
Any help appreciated. Thanks.
Loading Spell Proc Event conditions...
ERROR:Error in `spell_proc_event` table, probably sql file format was updated (there should be 7 fields in sql).
Any idea whats causing this?
sorry i didnt post this before but this is what my spell_proc_event sql looks like
REPLACE INTO `spell_proc_event` VALUES (1120, 0, 0, 0, 0, 4, 0);
REPLACE INTO `spell_proc_event` VALUES (8288, 0, 0, 0, 0, 4, 0);
REPLACE INTO `spell_proc_event` VALUES (8289, 0, 0, 0, 0, 4, 0);
REPLACE INTO `spell_proc_event` VALUES (11675, 0, 0, 0, 0, 4, 0);
REPLACE INTO `spell_proc_event` VALUES (27217, 0, 0, 0, 0, 4, 0);
REPLACE INTO `spell_proc_event` VALUES (24932, 0, 0, 0, 0, 4096, 0);
REPLACE INTO `spell_proc_event` VALUES (31641, 0, 0, 0, 0, 524290, 0);
REPLACE INTO `spell_proc_event` VALUES (31642, 0, 0, 0, 0, 524290, 0);
well there is multiple spell proc event sql files so that doesnt really help
When i run the 2 files, mangosd.exe and realmd.exe i just get this message in the mangosd.exe window:
2007-07-17 23:30:15 Using configuration file mangosd.conf.
2007-07-17 23:30:15 MaNGOS daemon /0.8-SVN (Win32)
2007-07-17 23:30:15 to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2007-07-17 23:30:15 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-07-17 23:30:15 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-17 23:30:15 Realm running as realm ID 1
2007-07-17 23:30:15 Using DataDir E:\Spill/
2007-07-17 23:30:15 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-07-17 23:30:15 WORLD: VMap data directory is: E:\Spill/vmaps
2007-07-17 23:30:15 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-17 23:30:15 ERROR:Check existing of map file 'E:\Spill/maps/0004331.map': not exist!
2007-07-17 23:30:15 ERROR:Correct *.map files not found in path 'E:\Spill/maps' or *.vmap/*vmdir files in 'E:\Spill/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
Any idea whats wrong?
Ok, just ignore my last post, ill try to make a classic WoW server instead, can i make a classic if i got tbc installed? cuz its says that one of the map files "is non-compatible version (outdated?)" the map file name is 0004331.map:)
thx
When i run ad.exe I get an error http://s79.photobucket.com/albums/j145/dahmer45/?action=view¤t=wowpserror.jpg
I'm using the files for a classic server. Any ideas?
# Adsoe
Unfortunately no, you'll get Client, protocol or something error message if you tried that
# dahmer45
Did you put the ad.exe into the root of your WoW directory ? and did you create maps directory first ?
2007-07-18 18:50:32 Using configuration file mangosd.conf.
2007-07-18 18:50:32 MaNGOS daemon /0.7-SVN (Win32)
2007-07-18 18:50:32 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-07-18 18:50:32 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-07-18 18:50:32 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-18 18:50:32 Realm running as realm ID 1
2007-07-18 18:50:32 Using DataDir C:\WoW\data/
2007-07-18 18:50:32 Initialize data stores...
2007-07-18 18:50:32 ERROR:
Some required *.dbc files (6 from 28) not found or not compatible:
C:\WoW\data/dbc/AreaTable.dbc (exist, but have 21 fields instead 25) Wrong client version DBC file?
C:\WoW\data/dbc/ChrClasses.dbc (exist, but have 16 fields instead 17) Wrong client version DBC file?
C:\WoW\data/dbc/ItemSet.dbc (exist, but have 84 fields instead 45) Wrong client version DBC file?
C:\WoW\data/dbc/Map.dbc (exist, but have 41 fields instead 42) Wrong client version DBC file?
C:\WoW\data/dbc/Spell.dbc (exist, but have 170 fields instead 173) Wrong client version DBC file?
C:\WoW\data/dbc/TaxiNodes.dbc (exist, but have 14 fields instead 16) Wrong client version DBC file?
On my mangosd.exe and realmd.exe they keep gettinf apllication errors and i dont know why, could you help me plz?
Do u know a way that i can get the classic files without uninstall tbc?
2007-07-18 22:07:32 Using configuration file mangosd.conf.
2007-07-18 22:07:32 MaNGOS daemon /0.8-SVN (Win32)
2007-07-18 22:07:32 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-07-18 22:07:32 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-07-18 22:07:32 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-18 22:07:32 Realm running as realm ID 1
2007-07-18 22:07:32 Using DataDir C:\WoW\data2/
2007-07-18 22:07:32 ERROR:SQL: UPDATE `character` SET `online` = 0
2007-07-18 22:07:32 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2007-07-18 22:07:32 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-07-18 22:07:32 WORLD: VMap data directory is: C:\WoW\data2/vmaps
2007-07-18 22:07:32 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-18 22:07:32 Initialize data stores...
2007-07-18 22:07:32 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2007-07-18 22:07:32 ERROR:SQL ERROR: Table 'mangos.corpse' doesn't exist
2007-07-18 22:07:34
2007-07-18 22:07:34 >> Loaded 35 data stores
2007-07-18 22:07:34
2007-07-18 22:07:34 Using Autodetected DBC Locale (0).
2007-07-18 22:07:34 Cleaning up instances...
2007-07-18 22:07:34 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-07-18 22:07:34 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-07-18 22:07:34 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-07-18 22:07:34 ERROR:SQL: SELECT `id` FROM `instance`
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-07-18 22:07:34 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` > 1184760454)
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-07-18 22:07:34
2007-07-18 22:07:34 >> Initialized 0 instances, deleted 0 old instances
2007-07-18 22:07:34 Packing instances...
2007-07-18 22:07:34 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` 0
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-07-18 22:07:34
2007-07-18 22:07:34 >> Instance numbers remapped, next instance id is 1
2007-07-18 22:07:34 Loading Game Object Templates...
2007-07-18 22:07:34 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-07-18 22:07:34 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-07-18 22:07:34 ERROR:Error loading `gameobject_template` table (not exist?)
HOw can i fix?
i renamed my data to data2 btw
"I got to the step to create the shortcut to MPQE and change the Target except when I do change the target to “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc it says that the target isn’t valid and I should check to see if it exists. Please help cause I have no clue."
Hey J
the reason you're having that problem is this:
basically, you entered your data one text-box too low. Make sure you're putting those parameters into the "Target" textbox and not the one below it.
Yeh, its in the root folder with maps created first.
I have everything working great until I get to the realmlist. I hit join realm and it dosen't let me join. How do I fix this!!!
OK, i fixed my last problem. and the two command windows that you open (when u launch mangosd.exe and realmd.exe ) they dont close bythem selfs (so its going good so far) but when i go to login (in WoW) i comes up 'unable to determine the version of the game you are using... blah blah blah. wat have i done wrong?
if it helps i had the same problem as J so i just downloaded reapers DBC files, could that be the problem? Plz if u know how to fix this problem dont hesitate to pst me an answer.
ok mine is working fine up ot when i run mangos it just keeps testign the ships, and mine only gets up to handshaking
can u used a copyed over version or does it need ot be properly installed?
hey
thanks for creating this guide, it's awesome but you forgot one thing;
when changing the mangosd.CONF and realmd.CONF you also have to change the following:
For mangosd.conf:
LoginDatabaseInfo = "127.0.0.1;3306;root;YOURMYSQLPASSWORD;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;YOURMYSQLPASSWORD;mangos"
for realmd.conf:
LoginDatabaseInfo = "127.0.0.1;3306;root;YOURMYSQLPASSWORD;realmd; "
i didnt change this at first and thus it didnt work for me but now it does
Hey I need help. I got a server working fine (per mangos logs) but for the life of me cannot get a client to connect properly. i get through authenticating to an error that it cant tell which version i have. i see the attempt to connect in the sql logs although it just says attempting to connect. my account registration page also works with it. just no client software. =(
Oi, I still have a problem though; everything's working fine, and then I mean everything, until I login; it gaves me the "Unable to validate game version" error. Any way to solve this? I'm using the 2.0.12 patch and I believe that's required right?
Valery, I got the same error, I updated to 2.1.0 and it worked, don't ask me why, but it does.
Ok, If you get a "Cannot verify version..." then update to 2.1.0 It fixed it for me and it DOES work! :)
I thank you for taking your time to reply to my question, Elliot, but unfortunately upgrading WoW to 2.1.0 doesn't work out for me. :( I dunno, I'm going to try some more things and hopefully it'll work out.
k i have done evrything u wanted me to do to get this server running but it says failed to italize 0xc0150002 ??
I don't know i think i missed something
the Can not validate game version is because your sdb and/or mangos version dont mesh with the game version, one i can tell you for sure works is version 4096 for version 2.1.2 you can get both mangos and sdb versions for links above
mangos-files.de is also a good place for Mangos version
Yeah, Chrisb, I finally realized that and patched it up to 2.1.2 and it's working perfectly fine now :D
the only prob I have now is that it says TBC isnt installed but I did follow the guide for setting up a TBC server and I do have it installed so I dont see what the problem is? O_o
Oh, and is anyone else having problems with the Riding Skill instructors? o_o;
I can't talk to them and typing ".learn skill_id" doesnt work either - it doesnt even say it's not a comment, it just..doesn't do anything.
Sorry for all the questions. xD''
nevermind, apparently only the ones in orgrimmar & sen'jin village dont work =)
val, you need to go through mangos and type "setbc yourcharname 1". that will set you up for tbc expansion. the game dosent think your account is approved for it.
Thank you so much Chris! You really helped me out.
I'm having same problem as King:
error in 'item_template' table, probably sql file format was updated(there should be 132 fields in sql)
i'm using mangos 4134, with SDB 4051 and the DBC you provided.
My game version is 2.1.3(too updated?) -> if so, is there a way to make it 2.1.2?
stuck on step 2, i extracted MPQE.exe and its dll into wow/data folder, then i created a shortcut and changed its porameters, when i run it to extract it tells me "The application failed to initialize properly... " after i read these i got the idea that i don't have dbc.mpq file in my data folder and tried to change the shortcuts parameters, same deal when i try to run it, so i am guessing it's not the file that is missing but MPQE.exe fault, any thoughts?
Everything was going fine, but now I'm getting this error when I get to your "Make sure everything is working as it should" step....and its not...
2007-07-22 05:31:39 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-22 05:31:39 ERROR:Could not connect to MySQL database at 127.0.0.1: Can't create TCP/IP socket (10050)
2007-07-22 05:31:39 ERROR:Cannot connect to database
mysql -u root -p -v -D mangos
"mysql -u root -p -v -D mangos
the_filename_used_on_sql_dump_from_e_turray.sql
Ok, for the third time i write this now... damn server deleting my entire posts...
WHERE THE HELL AM I SUPPOSED TO FIND THIS E_TURRAY SQL FILE? basically... i have no idea where to find this or where to point the command to.
@ Anon
it is the sql file from the SDB dump lol.
@ anarki
Your mangos and SDB must be the same version.. I'm using mangos 4067 and SDB 4067
Mangos 4067 - http://filebeam.com/15a6ee4e3ca39870476eb4959c66b8f4
SDB dump 4067 - http://e-turay.com/files/MaNGOS/SDB/SDBFull-202-4067.rar
Oh, by the way,
Does anyone have the SQL file for the Tier 6 sets? Or aren't they available for MaNGoS servers yet?
Also, is there a way to get the Warglaives of Azzinoth that Illidan wears? and then I don't mean the WoA that are already in the game, but the green ones - http://www.wowhead.com/?screenshot=view&3.32837#26189
If someone can't help me out with these questions, I fully understand. I've been looking all over the internet myself.
Valery,
I am looking at that version of Mangos, but I don't see a "sql" folder in there that has a create_mysql.sql file and realmd.sql file that you're suppose to copy over into the other SDB folder that you've created. (i'm still following reaper's guide as best as i can).
Is there a way to bypass that step?
And are you setting your TBC server to version 2.1.2?
@ valery
i got your mangos version, but as i couldn't make it without a SQL folder, i got the latest sdb from silver's site, but i'm still getting the same error =( could it be from the DBC?
@ Benz
I'm terribly sorry, I posted the wrong link. This one should have the sql folder in it: http://rapidshare.com/files/42204097/MaNGOSRev4067_ScriptDev2Rev69.rar
And yes, my version is 2.1.2
@ Anarki
Maybe you have the incorrect DBC files, if you're using my mangos version and SDB, then here are the DBC files for 2.1.2: http://rapidshare.com/files/38852051/DBCFiles2.1.2.rar
The link to the correct mangos with SQL folder is http://rapidshare.com/files/42204097/MaNGOSRev4067_ScriptDev2Rev69.rar
Hopefully it will work for you two.
Oh and Anarki, be sure to also use the SDB file I gave you the link to. The one on Silver's site may be the latest one, but remember that your SDB files have to be the same version as your MaNGoS, in this case 4067 (Game version 2.1.2)
No one can help me here? My firewall is turned off and I can enter the mysql command line client just fine. Still, I get this error when starting realmd and mangos. Help 8(
2007-07-22 05:31:39 ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t create TCP/IP socket (10050)
2007-07-22 05:31:39 ERROR:Cannot connect to database
I'm sorry Mord, I can't help you with that error :(
your mysql may not be working properly then mord, try to reinstall it.
i'm trying with your files now valery =) thanks a lot, praying that will work with 2.1.3 D:
thanks, valery. i got the correct mangos. i'll give it a whirl.
last week i had a WoW 1.12.1 server going, and a few of us were playing it. . . . then i realized that the talent tree went up to 31 point talents instead of 41. . . . and i realized i needed to do a 2.x.x version of WoW. . . on well.
i'll try those DBC files you linked, too, as soon as i'm able to download from that site again (i guess there's a download limit to those without accounts, ha ha).
thanks again.
Ugh, everything works up to mangos where I create the user login...any command I put in mangos crashes it.
Using 4135 and SDBFull-203-4123
So close :/
great guide, im having some trouble can u help, for mysql -u root -p -v -D mangos
mysql -u root -p -v -D mangos
for the_filename_used_on_sql_dump_from_e_turray.sql what should i put
k, it's up and running. thanks again, valery. i noticed somebody told you to go thru mangos and enter "setbc yourcharname 1". is this because those connecting to your server w/ accounts are not given access to TBC stuff?
. . . nevermind, i see it now in the /help list when you're in mangos. i understand now.
i keep getting ERROR:Error in `creature_template` table, probably sql file format was updated (there should be 65 fields in sql). when i run mangosd
Ok, I tried using Valery's stuff and everything worked better, but I got a map error when starting mangos. Realmd started fine and did not close. Mangos closed immediately and gave me this error in the log:
2007-07-23 01:42:34 Using DataDir C:\WOW\Data/
2007-07-23 01:42:34 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-07-23 01:42:34 WORLD: VMap data directory is: C:\WOW\Data/vmaps
2007-07-23 01:42:34 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-23 01:42:34 ERROR:Check existing of map file 'C:\WOW\Data/maps/0004331.map': not exist!
2007-07-23 01:42:34 ERROR:Correct *.map files not found in path 'C:\WOW\Data/maps' or *.vmap/*vmdir files in 'C:\WOW\Data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
How do I find this map or fix the problem period.
Fist i whant to say thank you
now lets get back to the proble im trying to set up a wow TBC 2.0.8 enGB server i've done the Mysql installation it works i've extracted the mpq files i get realmd to start but when mangos starts it give me the error maps is outdated or it gives me "item error found 12 expected 32" this is just a example of one of this tipes of error's it gives me. what version of mangos must i use and where can i get a SDB full update for that server. the right ad.exe for the server and the sql extractor needed for that server. please help o yes at this moment i'm using mangos 3306
Glad it worked out for you, Benz!
@ Mord
Have you placed the map folder into the data folder you created in this tutorial? You know, the folder where you also put the DBC files in.
Hi, i'm having a problem running mangosd.exe on the step where you are supposed to see if everything is ok. I ran realmd.exe and it worked fine but mangosd.exe gives me this error when i run it:
2007-07-23 05:03:05 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-07-23 05:03:05 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-07-23 05:03:05 Realm running as realm ID 1
2007-07-23 05:03:05 Using DataDir C:\Games\World of Warcraft\Data/
2007-07-23 05:03:05 WORLD: VMap support included. LineOfSight:1, getHeight:0
2007-07-23 05:03:05 WORLD: VMap data directory is: C:\Games\World of Warcraft\Data/vmaps
2007-07-23 05:03:05 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-07-23 05:03:05 ERROR:Could not load vmap file 'C:\Games\World of Warcraft\Data/vmaps/000_43_31.vmdir'
2007-07-23 05:03:05 ERROR:Correct *.map files not found in path 'C:\Games\World of Warcraft\Data/maps' or *.vmap/*vmdir files in 'C:\Games\World of Warcraft\Data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
I am using Mangos version 4153. Can you please help me!!!
Valery
Can i use your mangos ver 4067 with 2.0.12engb and will your dbc / SDB files still work. with it please help. [I'm still new to this program]
Terox,
Apparently you're having the same problem as Mord? So you should also check if you have put the Maps folder in the correct Data folder, not the one of the WoW game itself, but the one where you also had to put the DBC files in this tutorial.
Draco,
I assume they will :)
Although.. I'm not sure if that Mangos version works with 2.0.12
I'd either update your game version to 2.1.2 or download a Mangos that is compatible with 2.0.12 - you'll also need to download SDB + DBC files that are compatible with 2.0.12
thanks a lot i found this guide easy to follow
and it just stretched my abillity i have tried many in the past and this one works a treat i also think that the pictures are a good improvment and they should be used becuase it tells me im on the right path
Valery
Thanks for the help.
Next Quistion and im sorry for the idiosy becouse if work with other programs before must i extrack all the files in the .sql folder which i copyd to sdb folder and must i extract the mangosd.sql file or the SDBFull-202-4067.sql
Anybody help!
with above subject
my advice for all is to set up a 2.1.2 server, and grab those three files (Mangos 4067, SDB dump 4067, and the DBC files for 2.1.2), all with links posted by Valery above. you can find a map extracter on the internet for 2.1.3 which worked fine for me. take all of that and follow this guide and it will work w/out a hitch.
i encountered so many problems trying to set up a 2.1.3 simply because there were lots of incompatibility issues with different mangos versions and sdb dumps. but Reaper set up this guide for you, and Valery linked all the files you need (minus the map extractor). The version you'll be running is just a hair under the current 2.1.3.
just my advice
Reposting so it's easier for people to find.
I recommend everyone to patch your WoW to 2.1.2
MANGOS 4067
http://rapidshare.com/files/42204097/MaNGOSRev4067_ScriptDev2Rev69.rar
DBC FILES FOR WOW VERSION 2.1.2
http://rapidshare.com/files/38852051/DBCFiles2.1.2.rar
SDB FILES FOR MANGOS 4067
http://e-turay.com/files/MaNGOS/SDB/SDBFull-202-4067.rar
@ valery
thanks a lot =) with your mangos i managed to get it to work, altough i can't connect due to my game version being 2.1.3
anyone know any method of getting 2.1.3 without getting some Gbs of blizz updates? my WoW dvd is pretty old >_
Yea, I've done everything exactly the way it was to be done, word for word. The maps and DBC folders are both in the data folder inside my own created WoW folder that is right under my C:\ drives nose.
The links you just posted are the exact things I used to do the process.
Now lets see... I have 4423 items that were extracted to my C:\WOW\Data/maps folder. Does that number look wrong? I extracted twice, both came out that way.
Thanks in advance for any responses.
i keep getting an unable to validate game version when i try to get on my server. i used the same stuff ass valery did. what version do i need?
as*
What I can't figure from the error message is if its looking for a map and not finding it or if its found a map that isn't supposed to be there...
0004331.map’ is the exact same one that Adsoe's setup was saying it couldn't find and it seems to be the same thing for Terox, but written differently with .vmdir. So....guffah!!!
I think I found the problem...and feel really stupid for it o.O
Argh...no now i'm getting this error:
2007-07-23 14:18:24 ERROR:Could not load vmap file 'C:\WOW\Data/vmaps/000_43_31.vmdir'
2007-07-23 14:18:24 ERROR:Correct *.map files not found in path 'C:\WOW\Data/maps' or *.vmap/*vmdir files in 'C:\WOW\Data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
same thing just Terox's problem now. I got the maps, now its not finding the vmaps???
Ok, excuse the constant updates. I should have just waited until I tried a couple of things before posting the problem. But anyway, its working. Just got to set up my realm.
pxritaly:
You usually get this error when you're using the wrong WoW patch with the wrong version of Mangos/DBC/SDB. At least, that's what happened to me..
Mord:
So it's working now? That's awesome. :D
Everything has worked so far in the server setup and i can run realmd.exe with no errors. i run mangosd.exe and it loads everything fine. However, when i try to create a test character i get a microsoft error report screen and then mangosd quits.
Any suggestions?
update: before it quits, mangosd.exe gives me this error:
Error in my_thread_global_end: 10 threads didn't exit
okay.... so i replaced mangosd.exe with a different version and now it works. but now theres a different problem.
I can connect to the server using an account i created. I made a character but now whenever i try to enter the game world i get disconnected and mangosd.exe gives me this:
[MCH] ***********************
[MCH] SERVER CRASHED !!!
[MCH] ***********************
[MCH] Starting MaNGOS Crash Handler 1.5c ( No Save )
[MCH] TRYING TO DISABLE LOG ...
LogLevel is 0
[MCH] TRYING TO SAVE ACCOUNTS
Skip Save player: Calina
[MCH] FINISHED SAVING ACCOUNTS
[MCH] MCH FINISHED: ABORTING ...
Error in my_thread_global_end(): 9 threads didn't exit
What did you do to make it work Mord?
Nevermind, I figured it out. I had my dbc files in the World of Warcraft data folder and not the one I created. Thanks Valery :)
Alright, it seems that the server is working - mangosd.exe and realmd.exe both work fine. I can run mangosd.exe and create a new account but when I try to log into wow it just says 'unable to connect'. I set the server up to be TBC i'm using all the files that Valery told us to download for TBC. Also I can't figure out how to make a gm account. I looked at Reaper-x's old guide and did everything he says to do but after I enter:
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');
the input line just changes to "> and anything I type does nothing. I don't know if this means I created the account but I doubt it.
-Your help is much appreciated :)
Oh I forgot to mention that my wow version is 2.1.3 I don't know if that has anything to do with it.
ok lol, sry for all the posts. I just realized that I need realmd.exe running too, not just mangos.exe. But now the error I get at the logon screen is:
Unable to validate game version. This may be caused by file corruption or the interference of another program.
what do i need for a 2.1.3 server?
I'm interested in that too. If anyone tried working with a 2.1.3 working Mangos version and the corosponding files and you got it to work, please post your links. I tried a mangos version that was supposed to work with 2.1.3, but it didn't. However, I also didn't really know what I was doing at the time and I do now....so yea. I might try it again, but if you got something like Mangos 4134 (or whatever) to work, I beg you to tell me : )
valery
thank you updated and it works i'f used a map extractor i found on the mangos site.
here is a question how do you set up a gm acount in mangos. what do i need to type in for it to work.
Draco
first create a regular account
create
then type
setgm
I am wondering when i place the dbc shortcut and stuff like that the target i put (I think the one u told me) sends me to Presario C: ?? I dont think it needs to be like that? can you please help me?
I put the target as
C:\ Program Files\World of Warcraft\Data\MPQE.exe /p dbc.MPQ DBFilesClient\*.dbc
Now did i mess up somewhere?
terox, if you did the links that valery set up its for 2.1.2 and if your running 2.1.3 it will not work you need diffrent version of mangos (or update the one you have) and new sdb at least 4119 to get 2.1.3 to work, mine is working but has some weird problems but forthe most part works just fine, if you like ill see if i can get links to all the stuff for 2.1.3 and repost later.
Maker, if your doing tbc you need to change the dbc.mpq to expansion.mpq
also make sure when you setgm that you put a number behind your name 3-6 is the level 6 is the highest with abilities to edit in game npc's
Problems with my server (using Mangos 4067 and the respective files) v. 2.1.2:
Mobs will sometimes aggro and fall through the world or rise upwards. Especially in instances.
Many GM commands do not work, such as the .kill or .learnskill commands. What files do the commands come from?
The scale of some bosses is off and none of the bosses in the entire world use their special attacks (e.g. various phases in the fight do not trigger).
Anyone else having these problems? Anyone fixed them?
hey ok i worked all day on this. =P and everything is working find except for the MPQE.exe thing.
when i run it a command prompt pops up, then goes away really fast. i dont even have time to read what its saying. this happened to me before for another game when i was trying to install it i think. but i re-downloaded it and that works fine
-but thats gettign off subject.
and because i cant run MPQE.exe, and extract the DBC files, i get error messages saying that things aren't installed; im pretty sure that this is the only thing that isnt working =/
here are the command prompts when i run mangosd.exe and realmd.exe:
[IMG]http://i69.photobucket.com/albums/i74/seanathan_2006/untitled-3.jpg[/IMG]
[IMG]http://i69.photobucket.com/albums/i74/seanathan_2006/realmd.jpg[/IMG]
And i get this (not every) but the majority of the time when i run mangosd.exe
ill try downloading a different DBC extractor =/ ive been looking for one for hours. but if u could help me out id greatly appriciate it
-sean
oh and you can email me @ haveaniceday22093@comcast.net
and here are my Log Files
Server:
2003-07-24 23:47:49 Using configuration file mangosd.conf.
2003-07-24 23:47:49 MaNGOS daemon /0.8-SVN (Win32)
2003-07-24 23:47:49 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
2003-07-24 23:47:49 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2003-07-24 23:47:49 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2003-07-24 23:47:49 Realm running as realm ID 1
2003-07-24 23:47:49 Using DataDir C:\WoW\data/
2003-07-24 23:47:49 WORLD: VMap support included. LineOfSight:0, getHeight:0
2003-07-24 23:47:49 WORLD: VMap data directory is: C:\WoW\data/vmaps
2003-07-24 23:47:49 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2003-07-24 23:47:49 Initialize data stores...
2003-07-24 23:47:49 ERROR:
Incorrect DataDir value in mangosd.conf or ALL required *.dbc files (35) not found by path: C:\WoW\data/dbc
Realmd:
2003-07-24 23:45:34 Using configuration file realmd.conf.
2003-07-24 23:45:34 MaNGOS realm daemon /0.8-SVN (Win32)
2003-07-24 23:45:34 to stop.
2003-07-24 23:45:34 Database: 127.0.0.1;3306;mangos;mangos;realmd
2003-07-24 23:45:34 Added realm "MaNGOS".
2003-07-24 23:45:34 realmd process priority class set to HIGH
2003-07-24 23:45:34
2003-07-24 23:47:34 Halting process...
EDIT:
my new Server log file:
2003-07-25 00:04:51 Using configuration file mangosd.conf.
2003-07-25 00:04:51 MaNGOS daemon /0.8-SVN (Win32)
2003-07-25 00:04:51 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
2003-07-25 00:04:51 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2003-07-25 00:04:51 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2003-07-25 00:04:51 Realm running as realm ID 1
2003-07-25 00:04:51 Using DataDir C:\WoW\data/
2003-07-25 00:04:51 WORLD: VMap support included. LineOfSight:0, getHeight:0
2003-07-25 00:04:51 WORLD: VMap data directory is: C:\WoW\data/vmaps
2003-07-25 00:04:51 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2003-07-25 00:04:51 Initialize data stores...
2003-07-25 00:04:51 ERROR:SQL: UPDATE `character` SET `online` = 0
2003-07-25 00:04:51 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2003-07-25 00:04:51 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2003-07-25 00:04:51 ERROR:SQL ERROR: Table 'mangos.corpse' doesn't exist
2003-07-25 00:04:51 ERROR:
Incorrect DataDir value in mangosd.conf or ALL required *.dbc files (35) not found by path: C:\WoW\data/dbc
http://i69.photobucket.com/albums/i74/seanathan_2006/untitled-3.jpg
http://i69.photobucket.com/albums/i74/seanathan_2006/realmd.jpg
http://i69.photobucket.com/albums/i74/seanathan_2006/gay.jpg
sorry i just realised that the [IMG] 's didnt work =/
DBErrors:
2003-07-24 23:35:25 SQL: UPDATE `character` SET `online` = 0
2003-07-24 23:35:25 SQL ERROR: Table 'mangos.character' doesn't exist
2003-07-24 23:42:40 SQL: UPDATE `character` SET `online` = 0
2003-07-24 23:42:40 SQL ERROR: Table 'mangos.character' doesn't exist
2003-07-24 23:42:40 SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2003-07-24 23:42:40 SQL ERROR: Table 'mangos.corpse' doesn't exist
2003-07-25 00:00:29 SQL: UPDATE `character` SET `online` = 0
2003-07-25 00:00:29 SQL ERROR: Table 'mangos.character' doesn't exist
2003-07-25 00:00:29 SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2003-07-25 00:00:29 SQL ERROR: Table 'mangos.corpse' doesn't exist
2003-07-25 00:04:51 SQL: UPDATE `character` SET `online` = 0
2003-07-25 00:04:51 SQL ERROR: Table 'mangos.character' doesn't exist
2003-07-25 00:04:51 SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2003-07-25 00:04:51 SQL ERROR: Table 'mangos.corpse' doesn't exist
Sorry for all the posts,i just want to provide you with as much information as possible so u can help me out =P
Valery
Thanks again.
My next problem is when i try to to connect to the server from another computer i get connected but when it gets to select realm it just keeps on looping it does'nt whant to get where you can create caracter.
PLEASE help anybody.
Hey, ive got this setup and working for TBC but i was wondering is there any more upto date databases ? im missing certain NPC's and items from V2.1.3 aswell as alot of random mobs are spawning in places they shouldnt :/ also stats dont seem to be applyed/calculated correctly from gear.. this is with "SDBFull-203-4123.rar" from 1 of the links in your guide
@ Draco,
Mine is doing the same thing. My server is set up on one of my computers, and the mangos and realmd exe files run just fine. I can create accounts, etc. I forwarded ports 3724, 8085 and 3306 (for my mysql) to the server computer.
And TBC game is installed onto another computer. I can log in and see my server on the list, but when I click to connect to it, I see the window saying "Logging into server," but then a few seconds later it loops me back to the server list screen. . . . and I can click my server only to be brought back to that same screen. . .
Anybody have a resolution to this?
. . . . evidently my and Draco's problem is commonly referred to as a realmlist loop.
realmd.txt
2003-07-25 09:23:19 Using configuration file realmd.conf.
2003-07-25 09:23:19 MaNGOS realm daemon /0.8-SVN (Win32)
2003-07-25 09:23:19 to stop.
2003-07-25 09:23:19 Database: 127.0.0.1;3306;mangos;mangos;realmd
Server.txt
2003-07-25 09:15:12 Using configuration file mangosd.conf.
2003-07-25 09:15:12 MaNGOS daemon /0.8-SVN (Win32)
2003-07-25 09:15:12 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
2003-07-25 09:15:12 World Database: 127.0.0.1;3306;mangos;mangos;mangos
ok so i decided to just make a classic server like you , and everyhting worked out fine, but i had to copy the maps to the new folder and i guess theyre all there. im nto gettign any more error messages, although, i am getting those 2 thing when i run relamd.exe and mangosd.exe. they're not errors but nothing else is loading =/ my AIM screenname is BAKERBOARDSROK93 so if im on it and we havent solved this problem by then, then could you IM me(i saw that u said u were talking to someone on MSN, my msn isnt working right now, so i hope you have AIM =/)
Awesome guide, 10/10 , zomg :D
And keep screens, helps alot
Draco
have you followed the steps of the third part of this guide, "Setting up WoW Server for LAN"? if you have then Im afraid I dont know how to fix that..
By the way, does anyone know how to add Tier 6 to your own server? I found several files on the internet but none worked or either were for Antrix Servers... Is it even possible for mangos servers?
Draco,
I have a 2.1.2 server set up on two different computers, and I was having this realm list looping on it. I read a guide on how to remedy it on another part of this Reaper-X guide, by a guy named PepsiG. It involved using SQLyog, and it was a simple process. In the end, it got rid of my looping, and I was able to log in. . . . funny how it only happened to one of my two computers . . . *scratches head*
anyhow, I'll go back and search for the link, and I'll post it.
go to the following link, and look about 1/2 way down the comments list. it's by a guy named PepsiG, and the comment was posted on May 6th.
http://www.reaper-x.com/2007/04/19/how-to-configure-mangos-the-world-of-warcraft-emulator/
good luck, bud. it worked for me, so i'm sure it will work for you.
Thank's Benz
Been playing a few times and notice that the NPC's in the dungeon's when you are attacing them they just disapear or fly into the air or disapear under ground how can i fix this any ideas i'm running mangos 4067
I have the same problem and I'm trying to find a working SDB and Mangos combination that will fix it...however, everyone seems to be saying that everything for all of the versions of SDB and Mangos work like a dream with little errors. However, when you can't do an instance because the mobs fly off or the bosses fail to trigger events/phases/specials, it makes for a very lame game that is unplayable in my opinion.
Anyway, I'm trying to find something that works. If anyone does before me, please post the links. Thanks.
Yes please post the link here. it will be apreaseated. or if ther is a code that needs to be entered
I'm having the exact same problem as you guys. O_o
Quite stupid, as it only happens when I have "GM Mode" turned off.
Or changed
What is "GM Mode?"
???
Mine is doing it even when Gm is on
Yea mine does it when GM mode is on too. And GM mode is when you can do almost anything, Spamike (although many of the commands don't seem to work). You grant GM powers to players or yourself by entering the mangos command prompt and typing setgm AccountName 2 (or 3 is admin). Though I did try 2 for my friend and he couldn't execute commands so maybe 3 is GM and 4 is admin even though the setgm command lists only the values 0-3.
Anyway, this is great, dont get me wrong. I appreciate the private server stuff, but it is disappointing at the moment. I know there must be working Mangos and SDB's out there with working instances or the famous ones wouldnt be so famous....right???
I suggest that those of you who are disappointed with the versions you've downloaded try different combinations. If we all do, surely someone will find a working one...unless it doesnt exist lol.
Had a 2.08 version of Mangos but Blood Elves and outland had no missions and creatures, so there must be a way how we can fix this bug we just need to find the right update for this mangos version
Sorry!!!
i ment to say that the version of 2.0.8 instances was working the NPC's wasn't flying around or disapearing the only thing that wasn't working was the misions for the two new races and the outworld the rest was fine so what i'm saying is I know it is out there whe just need to find it.
Great guide, you're awesome!
Well, I might just set up an Antrix server. I know most private servers use Antrix, and everything just works better with it. It's more updated aswell and Black Temple works, I believe.
In Mangos BT doesn't work (ofcourse there's a way to change that, dunno how though)....
Yea but how do you get the source for it
Hello, the guide work perfectly except for one thing, when i try to use the MPQE extractor it tell "Application Error The application doesn't be able to start coorrectly (0xc0000135). Click OK to stop the application"
Do you have any idea??
Hey there. I can't figure this guide out. If someone else out there figured this out, or if Reaper-X sees this, please send me an e-mail, or add me to MSN so I can get a walkthrough. I also don't know what to patch my WoW to in order for this to work, and I can't get every file required. Some of the links are broken. My E-mail is ERietdyk@hotmail.com. Add me to MSN or e-mail me if you can help me for a few hours while I get this set up.
Hey reaperX how do you get the 1.21.0 patch for the Original WoW server?
Is there a way to change the reputation that is given? :o
Hello, its me again. now i have the vmaps but im still blocked at the mpqe things. when i open realmd.exe and mangosd.exe it tell in mangosd -> Error loading 'gameobject_template' table (not exist?)
can someone help me?
I am trying to run WoW: TBC so what would i put instead of “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc because that doesnt work
thanks for any help from anyone
Lunar, i got the same problem. I perfectly wrote that and it still dont work, i dont know that to do...
Im having a problem when I go to do the sql query, I get 3 errors in a row that say
The system cannot find the file specified
Please can I get an answer to this, got a lan party coming up and want to get this going, THANKS!
Got past the sql query part but now Im stuck again, I can get realmd to run, but when I try to run mangosd.exe a dos windows pops up and goes away immidietly. I have done this on 2 seperate computers following every step carefully. Anyone got a solution?
Hey, you must be so sick of helping everyone,lol, but i really need help, i have installed everything, dbc, maps & vmaps and when i run it i get that there are to many feilds in the DBC files, why?
Got the server up and running, but when I try to create a character the character doesn't get saved, and in the cmd it says
SQL ERROR: Unknown column 'zone' in 'field list'
Please help?
This is a message for Draco - I have all the required things now downloaded. Which guide on this site do I follow? This guide does not use a 'SQLyog' to my knowledge. E-mail me at ERietdyk@hotmail.com
Ok, for anyone that is having trouble extracting DBC files i have found that if you open the data folder, then open your enUS or enGB folder and yor the locale-enUS.mpq or locale-enUS.mpq, the both contain DBC Files that you can use, also check the patches.
disappearing mobs . . . yeah, i had a couple people on my server say mobs are disappearing up into the ceiling in UBRS. i'm wondering if i need to downgrade my version of TBC, or if i ought to try and do a 2.1.3 version.
I got past my previous problem, but now I have a new one: there are no npcs (mobs or friendly) in my server. I can log in and create characters and move around the world, but there is nothing to interact with.
Nevermind, I got it :) Thanks a bunch for the guide!
Very cool guide. i followed and end in unable to login . i mean i found your realm type user/password i created in mangos but he try to login and fail.
Any ideas ?
Using 1.12.1 and your downloads
Benz & Valery
thanks for the help if you guy's still have problems with the mobs disapearing into the ceiling you need to ge vmaps the newest one on the mangos projects website and run it in your data directory. after that change the following lines in your mangos config file
vmap.enableLOS = 0
vmap.enableHeight = 0
to the following
vmap.enableLOS = 1
vmap.enableHeight = 1
you will vind it on the botom of mangos rev4067
config file.
thank again for your help my mangos is working perfectly.
that worked. i ran the utility during lunch today, and i'm talking to a guy on my server right now. he says all is well.
i've noticed a few spells that aren't working properly. the mage's Frostbolt spell doesn't apply the "chill" effect to mobs. also, the paladin's divine illumination does not refund mana when crit-heal. . . . and divine favor does not crit the healing spells, but it DOES crit the holy shock spell.
if you run across a fix for that, please post here. thanks again, draco.
HEy dude this kicks ass, but Im having problems with the SBD, see I copied create_mysql and realmd into SBD as is, and then I used CMD prompt type your directions, and nothing works it says error so i checked over everything and im stumped,
Thanks dude
Hey guys, if any of you were wondering how to make a server for 2.1.3 (which I have for a long time) I finally found a pack.
http://thepiratebay.org/tor/3751051/WoW_Private_server_2.1.3_(Mangos)_Super_easy___n00b_edition.
It's a torrent that you download and it has everything you need in it and it works pretty good.
However, the mangos files in my previous post won't work to set up a lan connection because the pack gives you a mysql server that you can't edit. So if anyone finds mangos files along with a compatible sdb files for wow version 2.1.3, Please post your links :)
Turox did you try mysqlog to edit your mangos
Benz did you downloud the full SDB update from Valery that one works also. Where do you host your game from im trying to get myne to be hosted but dont know from where. Do you by any chance know wehere i can get a adon for the create acount to make it easy for people to use it.
Benz
did you downloud the full SDB update from Valery that one works also. Where do you host your game from im trying to get myne to be hosted but dont know from where. Do you by any chance know wehere i can get a adon for the create acount to make it easy for people to use it.
Is anyone getting a 1007 error message after typing the stuff for the SDB in the command prompt? it says Error 1007 can't create database 'mangos'; database exists. it then asks for my password again, proceeds normally, but after /*40111 set sql_notes=gold_sql_notes */ it says the system cannot find the file specified.
Landwarior
Are you installing a new server of mangos did you have a previous mangos running if so you need to uninstall mysql delete the mysql in program files and do it all over vollowing reaper x guid.
when it comes to sdb instalation install only the
create_mysql.sql
realmd.sql
mangos.sql
SDBFull-202-4067.sql
in this order then it wount give you a error.
worked for me. does anybody know where i can get a item creator and how to import the items into mangos.
This is for Evan
I have sent you a E-mail to the address provided it will take you trou the steps of how to set up SQLog.
Injoy.
Hi, I used another guide in general on http://www.hsforum.net/index.php?&showtopic=18698 but I got problems getting my friends to join through hamachi. They can connect and log on the accounts i created for them, but they cannot make a character, instead the "realm loop of death". I can play on my server, but they cant. I'm currently running the latest version of TomCh's 4.0 pack and the latest patch version of tbc. As I stated above, it works great for me, but my friends get the loop. They can log in and get assigned to the mangos server but get looped from there. This server is ment for my friends only through hamachi(no Lan party). What I havent been able to do is configure the mysql correctly.. more like not at all really.. ok.. to sum it up alittle.. my friends change their realmlist to my ip.. ok.. works cuz they can logon but cant do more... my realmd and mangosd are both set to 127.0.0.1 as stated in a post(works for me alone with my hamachi ip aswell ofc).. Heres another thing I dont get.. the port is set too 3306 for wow.. but when I use the MySql Server 5.0 Instance Config Wizard 1.0.8 I get asked something another somthin is runnong on port 3306.. do you want to continue.. should I? What confuses me alittle is that the other guide is written also for how to use hamachi but I cant get it to work it seemed like it was easier to get help here.
Here is another post I found with the exact problem:
If I run the server on MY computer and set everything to 127.0.0.1(If I'm running it) or my IP (***.***.*.***) on the local network... I can login and use my characters just fine, but others get the realmlist loop. But if I set the server to a computer where someone else is running the server, I get a realmlist loop...
Can someone help me out here. I read the other posts where people could make it work just fine on the LAN, but I don't believe it's the same problem.
I'd prefer not to dial in ever single time I wanted to try and use WoW with hamachi. Not to mention the latency up/down between 2 computers over 1 little connection.
/////////////////
Answer:
I think I see the problem... You have to make sure all of your .conf files have your IP AND that you have changed the address in your realmd/realmlist DB in Navicat to your IP.
//////////////
Ok.. he is now saying the exact opposite of what you said. To change the 2 conf files into having ur ip. I changed them.. no difference..
but the last part is what I think I have done wrong or havent done at all.. dont understand what he meens exactly...
Also.. last.. I have seen many posts like mine(alittle shorter maybe lol :P) so I see that I'm not the only one not managing to make this work.. plz plz plz help =)
Thanks for your time =)
Draco,
I'm installing a new mangos server. What could the problem be?
Now its saying Error 2003 can't connect to mysql server on 'local host' i forgot to put the .sql at the end of the sql dump. could that have been the problem? the error 2003 happened before, i just reconfigured the mysql according to the guide, and it fixed it. any ideas on what to do?
(Draco, thanks for the response, btw)
ok, i fixed the error 2003 thing, but its back to the "mangos database already exists" thing. i deleted the config in my sql, and started from scratch. do i need the reinstall the whole sql?
Landwarior
you need to re install mysql from the beginig
also when you uninstall mysql make sure that you delete the sql dump folder. then re install and let me know how it go's
There should be a ventrilo channel for this lol
when i try to reinstall MYSql it stops at "start service" as its configuring the server. it says "could not start the service MySql. Error: 0" =(
Draco,
i have multiple computers in my house, and i host a server on one computer, plus i play in it from another server.
yes, i downloaded Valery's SDB files. funny, i think the vmaps fix actually corrected the "chill" effect problem i was having w/ the mage's frostbolt spell.
Draco,
i reinstalled EVERYTHING, but the error saying that a mangos database already exists is still there.
ok, i got everything working except for mangosd. it opens for less than a sec, then closes. when i check DBErrors (is this the right file to check?) it says things like "2007-06-17 15:47:34 query ERROR: Table 'mangosd.jail_conf' doesn't exist
" or "2007-06-21 17:32:10 Race 1 Class 1 Level 71 not have stats data, using data for 70." did i miss something?
ok, i think i've figured it out. ok, now i get this "2007-07-31 00:22:48 World Database: 127.0.0.1;3307;root;yes;mangosd
2007-07-31 00:22:48 ERROR:Could not connect to MySQL database at 127.0.0.1: Unknown database 'mangosd'
2007-07-31 00:22:48 ERROR:Cannot connect to world database 127.0.0.1;3307;root;yes;mangosd"
i think someone had this same problem, but i didn't understand the solution. any help is extremely appreciated
wow, now i fixed that, but it says this when i run mangosd.exe now "2007-07-31 02:00:22 World Database: 127.0.0.1;3307;root;yes;mangos
2007-07-31 02:00:22 Login Database: 127.0.0.1;3307;root;yes;realmd
2007-07-31 02:00:22 Realm running as realm ID 1
2007-07-31 02:00:22 Using DataDir C:\WoW\data\
2007-07-31 02:00:22 ERROR:Check existing of map file 'C:\WoW\data\maps/0004331.map': not exist!
2007-07-31 02:00:22 ERROR:Correct *.map files not found in path 'C:\WoW\data\maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file."
i checked for that file, and i have it, i'm positive
thanks for your help in advance =)
Landwarior
the stesp for extracting a map is
1.copy the ad.exe file to your wow directory
2.create a directory/file called maps in your wow folder.
3.double click on your ad.exe (it will extract your maps to the folder.
4. copy the maps folder to the C:\WOW\DATA\ folder ( or whatever your directory structure is.
make sure you have the newest ad.extractor you
can dowloud it at this site
http://filebeam.com/2e1e5aa188f6e43c0f27da434804a0be
Hello im haveing a problum geting up my server, i have it all working but i can talk,use gms commands or anything.Im thinking its because i dont have my patch lsit on 2.0.12 (Yes its a tbc server)Is this my problum and if it is how do i set it to 2.0.12.If you can help me my email is babymoocow@yahoo.com plz help me :)
Hi i have a tbc wow server and i got it all set up and work but when im in game i cant talk or use gm commands is this because i have my patch list set higher than 2.0.12 plz help me if you can help my email is babymoocow9@yahoo.com
My MPQE shortcut dosen't work it says it failed
Also when I make a shortcut set the propoties to “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p
dbc.MPQ DBFilesClient\*.dbc
it won't work Can anyone help me?
Ty for your time
thanks draco, but i already did that, and i checked for 004331.map in the correct folder, and i have it. what could the problem be now? oh, and im making a 2.0.12 server btw
is ad.exe spyware? several websites say it is
now it says that it can't find ANY of the correct dbc files
i am so close. can someone please tell me all the file names for the extract dbc step. i couldn't get mpqe to work, so i have to use winmpq. thanks
omfg, now i got past that, but i get this 2007-07-31 21:42:06 Cleaning up instances...
2007-07-31 21:42:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
2007-07-31 21:42:06 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-07-31 21:42:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
2007-07-31 21:42:06 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-07-31 21:42:06 ERROR:SQL: SELECT `id` FROM `instance`
2007-07-31 21:42:06 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-07-31 21:42:06 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` > 1185946926)
2007-07-31 21:42:06 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-07-31 21:42:06
2007-07-31 21:42:06 >> Initialized 0 instances, deleted 0 old instances
2007-07-31 21:42:06 Packing instances...
2007-07-31 21:42:06
2007-07-31 21:42:06 >> Instance numbers remapped, next instance id is 1
2007-07-31 21:42:06 Loading Game Object Templates...
2007-07-31 21:42:06 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-07-31 21:42:06 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-07-31 21:42:06 ERROR:Error loading `gameobject_template` table (not exist?)
one problem after another =( please help, getting frustrated with this.
that error message was caused because you didn't import the sql file properly, and of course that means you need to reimport the sql files again :)
What program do i use to create weapons and how do i import them. (where can i get this program)
Can anyone help me i get to the part where i have to download the maps for the classic server. i have burning crusade downloaded could that be affecting the map download?
Ok. nvm about my previous post i got that figured out. but now when i try to go on it says error user mangos can not connect to mysql 127.0.0.1
Just downloud your map extractor from this file
http://www.megaupload.com/?d=MJ9ZOEEJ
i use the mysql -u root -p -v
and what did you ad after wards
my friends are still getting the realm loop when trying to join through hamachi.. they can log in but not much more.
any Ideas Reaper-X?
Ok. i got everything working up to the last part where my mangosd when i click on it it just closes i have everything like reaper-x says it should look like. but idk why
lol, now i get this
Loading Spell Chain Data...
2007-08-01 10:31:09 ERROR:Spell 36916 listed in `spell_chain` not exist
2007-08-01 10:31:09 ERROR:Spell 38764 listed in `spell_chain` not exist
2007-08-01 10:31:09 ERROR:Spell 38699 listed in `spell_chain` not exist
2007-08-01 10:31:09 ERROR:Spell 37420 listed in `spell_chain` not exist
2007-08-01 10:31:09 ERROR:Spell 39374 listed in `spell_chain` not exist
2007-08-01 10:31:09 ERROR:Spell 38768 listed in `spell_chain` not exist
2007-08-01 10:31:09 ERROR:Spell 40120 listed in `spell_chain` not exist
2007-08-01 10:31:09
2007-08-01 10:31:09 >> Loaded 1888 spell chain records
2007-08-01 10:31:09 Loading Spell Learn Skills...
2007-08-01 10:31:09
2007-08-01 10:31:09 >> Loaded 42 spell learn skills + found in DBC 73
2007-08-01 10:31:09 Loading Spell Learn Spells...
2007-08-01 10:31:09
2007-08-01 10:31:09 >> Loaded 41 spell learn spells + found in DBC 5806
2007-08-01 10:31:09 Loading Spell Proc Event conditions...
2007-08-01 10:31:09 ERROR:Error in `spell_proc_event` table, probably sql file format was updated (there should be 7 fields in sql)
what now? =(
(btw, thanks for the help reaper)
Wtf. ok i got everything working but now it says unable to vailidate game version may be corrupted files or somthing
How you fix that promblme? I have the same promble plz help me ty
Where are you all finding all these SDB Full dumps? I go to the Silver Database Community, but the SDB files I see aren't anywhere near 40+ mb downloads. I don't think they include mobs, quests, things like that.
Are you all getting them somewhere else? Or making them yourself? Because I would like to find a SDB Full dump that is compatible with the most current version(s) of Mangos. 4067 is starting to lose distance to the current version of Mangos, which is up to 4222 - and 4222 is even compatible with 2.1.3 TBC.
ok I downloaded somtnmig to fix my last problem now when I use the shortcut to MPQE A black sreen comes out and closes in less then a second. When I run MPQE it dose the same thing am I doing somthing worng plz help me. ty
Chris waht server are you running a 2.1.2 becouse it only gives you that when your wow needs to be patched to a higher level.
does the mangos version and the SDB dump neecd to be the same version?
When I try to run ad.exe, I everything your image shows, but I get an error
OPening ./Data/patch-2/MPQ
Opening ./Data/patch.MPQ
Opening .Data/Terrain.MPQ
Error opening archive .Data/terrain.MPQ
Opening ./Data/dbc.MPQ
Error Opening Archive ./Data/dbc.MPQ
Assertion failed: header[0]=='W' && header]1]=='d' &&header[2]=='b' && header[3]=='c' , file d:\dokumente undeinsellugen\inject\desktop\sammelordner\mangos\compile\contrib\map_extractor\dbcfile.cpp,line 17
any help?
couldn't someone just compile all of this into one file, then automate it so you don't have to struggle with this crap? why does it have to be so hard?
omg, now i get this 2007-08-02 01:44:38 World Database: 127.0.0.1;3307;root;yes;mangos
2007-08-02 01:44:38 Login Database: 127.0.0.1;3307;root;yes;realmd
2007-08-02 01:44:38 Realm running as realm ID 1
2007-08-02 01:44:38 Using DataDir C:\Program Files\WoW\data./
2007-08-02 01:44:38 Initialize data stores...
2007-08-02 01:44:38 ERROR:
Some required *.dbc files (1 from 35) not found or not compatible:
C:\Program Files\WoW\data./dbc/Map.dbc (exist, but have 72 fields instead 75) Wrong client version DBC file?
wtf does this mean? reaper, could you please add a new link to the compiled mangos revision 3900?
Landwarior
Yes it needs to be
actually the error message already said it all
Wrong client version DBC file?
the only solution of course is getting the new DBC Extractor from mangos forum
as for the link to Mangos R3900, you can get it from the Compiled Mangos for Win32 (requirement section of this post)
how about somebody get a compiled SDB Full that's compatible for the latest Mangos 4222. That way we all can run TBC 2.1.3.
Um draco im running a wow classic server. i think it may be becasue i didnt download any patches to it is that why? thx for ur help otherwise tho
Draco if it is that i didnt download any patches can u give me the link to download patch 1.12.1
does anyone know how to use filebeam? if so, could you please tell me?
Hello, I got the 1.12.1 version of my private server up, and all if well, the only question i have is. is there like a in game UI for mango, that makes it easier to modify the different values within the game?
Thanks
There was a mango admin addon... dont know if it works anymore of if its been updated..
how do you know if the SDB dump is compatible with Revision 3900? is the second number the version? ex: SDBFull-201-4051. would the 4051 be the version?
so, does anyone know how to use filebeam? i download "download 2.htm", which is about 2 kb, then clik on it. it takes me to filebeam, then says that i am trying to download this this file too quickly, please try again in 60 seconds. why cant i download anything?
I used reaper-x's extracted DBC Files and when I ran
mangosd.exe
I t loaded for a while then it said:
Error in 'creature_template' table, probably sql file format was updated .
and stoped runing.
Also there was a whole lot of other smae errors.
plz help ty
ok, i figured out the filebeam thing. my stupid browser was blocking it. now i just need help for the SDB version thing. =)
Sry for my last post Here is what happens when I run
mangosd (the whole thing)The last part is the error
and a few other ones is in there.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Owner>cd /d C:\WoW\Mangos
C:\WoW\Mangos>cd /d C:\WoW\mangos rev3462+scriptdev2 rev34+honor0.71+mch1.5c NO_
SAVE by Maxi
C:\WoW\mangos rev3462+scriptdev2 rev34+honor0.71+mch1.5c NO_SAVE by Maxi>mangosd
Using configuration file mangosd.conf.
MaNGOS daemon /0.7-SVN (Win32)
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
World Database: 127.0.0.1;3306;mangos;mangos;mangos
Connected to MySQL database at 127.0.0.1
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Connected to MySQL database at 127.0.0.1
Realm running as realm ID 1
Using DataDir C:\WoW\data/
Initialize data stores...
==================================================== 100%
>> Loaded 28 data stores
Cleaning up instances...
SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
query ERROR: Unknown column 'instance' in 'field list'
SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
query ERROR: Unknown column 'instance' in 'field list'
SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
query ERROR: Table 'mangos.character_instance' doesn't exist
SQL: SELECT `id` FROM `instance`
query ERROR: Table 'mangos.instance' doesn't exist
SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `charact
er_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`inst
ance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1186
181955)
query ERROR: Table 'mangos.instance' doesn't exist
==================================================== 100%
>> Initialized 0 instances, deleted 0 old instances
Packing instances...
SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` 0
query ERROR: Table 'mangos.character_instance' doesn't exist
==================================================== 100%
>> Instance numbers remapped, next instance id is 1
Loading Game Object Templates...
==================================================== 100%
>> Loaded 3712 game object templates
Loading Spell Chain Data...
=Spell 23489 listed in `spell_chain` have not compatiable chain data (prev: 2021
9, first: 4036, rank: 0)
=Spell 23486 listed in `spell_chain` have not compatiable chain data (prev: 2022
2, first: 4036, rank: 0)
>> Loaded 1330 spell chain records
Loading Spell Learn Skills...
==================================================== 100%
>> Loaded 40 spell learn skills + found in DBC 56
Loading Spell Learn Spells...
SQL: SELECT `entry`, `SpellID`,`IfNoSpell` FROM `spell_learn_spell`
query ERROR: Table 'mangos.spell_learn_spell' doesn't exist
==================================================== 100%
>> Loaded 0 spell learn spells
`spell_learn_spell` table is empty!
Loading Spell Proc Event conditions...
==================================================== 100%
>> Loaded 819 spell proc event conditions
Loading Aggro Spells Definitions...
==================================================== 100%
>> Loaded 53 aggro generating spells
Loading NPC Texts...
==================================================== 100%
>> Loaded 2663 npc texts
Loading Quest Area Triggers...
==================================================== 100%
>> Loaded 21 quest trigger points
Loading Items...
==================================================== 100%
>> Loaded 14347 item prototypes
Loading Page Texts...
==================================================== 100%
>> Loaded 1261 page texts
Loading Item Texts...
==================================================== 100%
>> Loaded 0 item pages
Loading Creature Templates...
Error in `creature_template` table, probably sql file format was updated (there
should be 66 fields in sql).
cd /d C:\WoW\Mangos
C:\WoW\Mangos>cd /d C:\WoW\mangos rev3462+scriptdev2 rev34+honor0.71+mch1.5c NO_
SAVE by Maxi
Using configuration file mangosd.conf.
MaNGOS daemon /0.7-SVN (Win32)
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
World Database: 127.0.0.1;3306;mangos;mangos;mangos
Connected to MySQL database at 127.0.0.1
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Connected to MySQL database at 127.0.0.1
Realm running as realm ID 1
Using DataDir C:\WoW\data/
Initialize data stores...
==================================================== 100%
>> Loaded 28 data stores
Cleaning up instances...
SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
query ERROR: Unknown column 'instance' in 'field list'
SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
query ERROR: Unknown column 'instance' in 'field list'
SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
query ERROR: Table 'mangos.character_instance' doesn't exist
SQL: SELECT `id` FROM `instance`
query ERROR: Table 'mangos.instance' doesn't exist
SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `charact
er_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`inst
ance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1186
181955)
query ERROR: Table 'mangos.instance' doesn't exist
==================================================== 100%
>> Initialized 0 instances, deleted 0 old instances
Packing instances...
SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` 0
query ERROR: Table 'mangos.character_instance' doesn't exist
==================================================== 100%
>> Instance numbers remapped, next instance id is 1
Loading Game Object Templates...
==================================================== 100%
>> Loaded 3712 game object templates
Loading Spell Chain Data...
=Spell 23489 listed in `spell_chain` have not compatiable chain data (prev: 2021
9, first: 4036, rank: 0)
=Spell 23486 listed in `spell_chain` have not compatiable chain data (prev: 2022
2, first: 4036, rank: 0)
>> Loaded 1330 spell chain records
Loading Spell Learn Skills...
==================================================== 100%
>> Loaded 40 spell learn skills + found in DBC 56
Loading Spell Learn Spells...
SQL: SELECT `entry`, `SpellID`,`IfNoSpell` FROM `spell_learn_spell`
query ERROR: Table 'mangos.spell_learn_spell' doesn't exist
==================================================== 100%
>> Loaded 0 spell learn spells
`spell_learn_spell` table is empty!
Loading Spell Proc Event conditions...
==================================================== 100%
>> Loaded 819 spell proc event conditions
Loading Aggro Spells Definitions...
==================================================== 100%
>> Loaded 53 aggro generating spells
Loading NPC Texts...
==================================================== 100%
>> Loaded 2663 npc texts
Loading Quest Area Triggers...
==================================================== 100%
>> Loaded 21 quest trigger points
Loading Items...
==================================================== 100%
>> Loaded 14347 item prototypes
Loading Page Texts...
==================================================== 100%
>> Loaded 1261 page texts
Loading Item Texts...
==================================================== 100%
>> Loaded 0 item pages
Loading Creature Templates...
Error in `creature_template` table, probably sql file format was updated (there
should be 66 fields in sql).
tyty if anyone can help me.
how do you use winmpq? mpqe just dosen't work for me. what do you have to extract for winmpq?
I have been blending your guilds and others and these files and that and I have gotten the 2.1.3 emulation proccess to all the way to the point where I just have to logon mango and realmd are both working fine and everytime i try to logon it either gives me disconnected right of or connecting and eventually unable to connect depending on some minor adjustments i made in attempting to make it work. I am runing mangos revision 4164 and I am using their their TBC DBS dump which seems to work fine and mysql 5.1 i have windows xp and world of warcraft 2.1.3 can anyone help me fix the last bit?
in atempting to fix it i think i made it worse because i am now having problems with mysql still if anyone knows why it wouldnt work pls let me know i may be able to eventualy get it back to where it was
ok im sorry to be posting like this but its driving me nuts the mysql is not accepting conncetiongs this is what it looks like when i try to use realmd.exe
Using configuration file realmd.conf.
MaNGOS realm daemon /0.8-SVN (Win32)
to stop.
Database: 127.0.0.1;3724;root;MYPASSWORD;realmd
Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
Cannot connect to database
can anyone tell me why it was working fine for hours and now this it became messed up when I uninstalled and reinstalled to try to match the games port and the servers port hoping that might do something but it didnt and i have made sure that every trace of MySQL was erased before i reinstalled it and i am possitive i configured it exactly like i had the 1st time
Hi, i have a problem with the enemys. They seem to not detect me, and when i hit them they get full health after a sec or two. What could be wrong?
Great tutorial by the way!
I upgraded from 4067 to 4236, and a LOT of character bugs have been fixed in that newer release. 4236 seems to be darn-near perfect.
Does anybody know how you can save character accounts in an older server version so I can put it in the new server version? (so my players don't lose their accounts)?
hey Im haveing a problem when i try to run the Mangos.exe .....
2007-08-04 11:00:55 Using configuration file mangosd.conf.
2007-08-04 11:00:55 MaNGOS daemon /0.8-SVN (Win32)
2007-08-04 11:00:55 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-08-04 11:00:55 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-04 11:00:55 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-08-04 11:00:55 Realm running as realm ID 1
2007-08-04 11:00:55 Using DataDir C:\WoW\data/
2007-08-04 11:00:55 WORLD: VMap support included. LineOfSight:1, getHeight:1
2007-08-04 11:00:55 WORLD: VMap data directory is: C:\WoW\data/vmaps
2007-08-04 11:00:55 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-08-04 11:00:55 ERROR:Could not find vmap file 'C:\WoW\data/vmaps/000_43_31.vmdir'
2007-08-04 11:00:55 ERROR:Correct *.map files not found in path 'C:\WoW\data/maps' or *.vmap/*vmdir files in 'C:\WoW\data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
using...
MySQL 5.0
MaNGOS_rev4238_ScriptDev2_RELEASE
SDBFull-204-4176
any help ? thx
i am trying to setup a TBC server and i have version 2.1.3
First of all i would like to say thanks for a very nice and understandable guide to create this server. But i got one problem.. when i am trying to run mangosd.exe it just closes again very fast. I followed your guide completely, but this still happens... it breaks down when it is trying to initialize data stores, and it says that some required .*dbc files (1 from 28) is missing or incompatible. "C:\WoW\data/Spell.dbc (exists, but have 171 fields instead 173) wrong client version DBC file?"
Do i then have to download a new version of the DBC files (in that case, where do it get them) or do i just have to change something in the file: Spell.dbc? (In that case, what do i have to change)? :)
Hope you can help me... and ty in case
I have the same problem as ninja mord and terox. Can any one help? it looks like mord was able to figure it out but he did not post how he fixed it. I would truly appreciate any and all help. thanx in advance!
Landwarior
download the newwest mangos you will vind a dbc extractor and a map extractor the . just use the mangos site reaper x provided.
Chris you need to get a sdb full for a mangos 0.7 so if you get something with before 3060
Cryzy paco
i had the same problem, what you need to do is change your realmlist.wtf to localhost if you are running from one machine. And if you are running in a network you need to get mysqlOG and set is up sodat your realm reflects your ip addres if you need help let me know. im running a wow 2.1.3 also.
I fix the other problem but now when I run mangosd it gos fine then at the end there is a loud beep from my computer then I go to some kind of test zeppelin loop can enyone tell me how to fix this?
thanks in advance! if someone can help me
I have the same problem as you mudkiller. I am stuck in a testship/zeppelin move loop and cant access any admin functions cause I cant get to a prompt. Anyone know what causes this?
this is also applies to cananden,
the loud beep from your computer mean the mangos process successfully started
and about the zeppelin thing, that mean the mangos already running in full debug
to disable showing debug messages, open the mangosd.conf and find LogLevel and change the value into 1
as for the beep, you can also disable it by editing the mangosd.conf, try searching for beep or similar words, and change the value into 0
here's the summary :
change the value like below :
LogLevel = 1
BeepAtStart = 0
i have a bug, u cant see any chat :S
Alright, my Mangosd.exe file is saying
2007-08-08 13:20:16 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-08 13:20:16 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-08-08 13:20:16 Realm running as realm ID 1
2007-08-08 13:20:16 Using DataDir C:\WoW\data/
2007-08-08 13:20:16 ERROR:Map file 'C:\WoW\data/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.
2007-08-08 13:20:16 ERROR:Correct *.map files not found in path 'C:\WoW\data/maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
what do i do
Hey
Trying to get a hold of a copy of Mangos revision 3900+ compiled for Win32. The link on the guide page here seems to be broken.
Any suggestions?
when checking to make sure that everything is ready to be used, the realmd comes up fine, but when i run mangosd, it starts up fine, and runs through most of the things, then it quits and the error text that shows errors said, 'ERROR:Error in `creature_template` table, probably sql file format was updated (there should be 65 fields in sql).' What should I do to make it work? and if there is a file i have to change, where would it be?
i just tried it and it worked fine .. btw just in case you didn't know. You need to register first in order to see that page :)
that mean , you were using incompatible SDB file. And to fix it first you need to get compatible SDB
here's an example if you downloaded the sdb full dump from e-turray (today) :
SDBFull-204-4176.rar 6.32 MB 30.07.07 09:54:32
from the above filename as you can see that the full SDB Dump was tested with Mangos Revision 4176, and so your best bet is of course download mangos revision 4176
Mine Worked perfectly. just i used the one at this link and in the comments of the torrent are the instructions but ignore the 127.0.0.1 thing. go to thepirateay.org and search this "WoW_Private_Server_2.1.3 and you should get it.
But I want my realm name not mangos. Also, on my server on m6 laptop i wanted to see if there were any other realms. So I rejected the one there. And when I select it it won't let me use it it says logging into game server.....
Then 1 second later it comes back up really fast! how can i fix this
can u help me reaper-x or somebody?
hey Benz, i was wondering what SDB database you are using with your 4236 and where you got it and where you got your mangos version?
thx
What is the folder "ScriptDev2"? I see that in the Mangos compressed archives, and I read that you're suppose to "execute" them somehow? Will Mangos run normally if ScriptDev2 is left alone?
Hey, I got most of it to work but I am having problems with the ad file. When I run it I get a box that pops up and says this:
Debug Error!
Program C:\WoW\data\ad.exe
This application has request the Runtime to terminate it in an unusual way. Please contact the application's support them for more information.
I don't have any clue why it's doing that...help please.
did you create the maps folder first before running the ad.exe ?
run this command from command prompt :
1. mysql -u root -p
2. use realmd
3. update `realmlist` set `name` = 'My Server' where `id` = 1;
4. quit
if you're using other 3rd party program to edit your database just go to the realmd database -> realmlist -> and change the name
that error message mean you're using wrong DBC files, if you use the latest WoW and Mangos, just make sure you've downloaded the correct DBC files or .. you can also extract it directly by yourself from your wow data
yeah but I keep getting the same error
What is ScriptDev2?
I've gotten my maps and DBC's dumped, but I dont' have a mangosd.conf file, wtf? can anybody tell me where I can get one? that's my only problem, as of now.
nvm, had a bum copy of MaNGOS >.
Where do i find Mangos Revision 4176, i've looked for hours >.
hey there i was wondering if theres a different link for Mangos 3900 the other one seems to be broke
tyvm sorry if someone already posted about this to lazy to look through everything.
I am planning to use a wow classic server, so can u plz link me the right mangos version and the right DBC files for that?
can u plz help me? im haveing trouble with changeing the mangos config file and its not working can u plz email me? or add me on msn brandt_smit@hotmail.com thanks
when i try to run the mangosd.exe file it says:
Error in "item template" table, probably sql file format was updated (there should be 132 fields in sql).
how do i fix this?
Reaper-X
How do i export my caracter sodat i can use it in a nother server.
I am stuck on teh DBC extraction,
when i go to set the new target to “C:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc
i get an error that says the path does not exsist now my WoW is installed on D: so i tried to edit the path to
“D:\Program Files\World of Warcraft\Data\MPQE.exe” /p dbc.MPQ DBFilesClient\*.dbc
but im still having the same problem. any help email me at Grab_Shell@hotmail.com because i will check that more regularly than here.. ty in advance
do you have microsoft .NET runtime installed on your computer ? btw you can get .NET from microsoft website directly (just search for it)
you can try exporting the character table in your realmlist, but your best bet is try looking at the mangosproject forum and read about it there (especially at upgrading section, because it give you a detailed info on which table are used by mangos)
A buddy and myself are working on a private server operatin on the latest patch. We tried a few instances and the boss encounters are not "working". The bosses are there, but they do not really fight back. Basicaly for example...the Moroes fight of the Nightmane fight are not working. They almost stand around and just look at you. Are the scripts for the bosses available?
Thanks
Rockne
Hey there im having a litttle trouble at the end everything is set up but when i go to sign it it says cannot conect mmabye we can get on a vent server and you can help me out. My e-mail is Atopaintballa@aol.com
Hi, I'm stuck at the SDB portion. I downloaded the SQL file and when I type the mysql -u root -p etc. I get the error on my command prompt: "'mysql' not recognized as an internal or external command, an operable program, or batch file" what's wrong?
Where do I get the DBC Extractor?
ok, i got to the mpqe file stuff, but when i try to run it after i got it all changed over, the target and all that, it saysthe application failed to initialize properly (0xc0000135). click ok to terminate the application.
ok, yeah, i cant seem to get the hang of this, so, could you make me a priv server plz, i dont know what exactly i need but if ya will, could ya send it to me, or at least tell me your answer
email: ireallywantanameforthis@hotmail.com
thank you!
when i get to the MPQ shortcut thing, the cmd window pops up for a few seconds but then goes away and nothing happens. somethings wrong when i type the address fo rthe shortcut or i put the files in the wrong place, but i cant figure out what i did wrong... [reaper, i added u in MSN if thatd be easier (theeviltorrent@yahoo.com)]
Ok, well, I fixed my previous error, but I got a new one. When I try to load mangosd.exe or realmd.exe I get error 0xc0150002 application failed to initialize. Click OK to terminate, every time, I don't think I did anything wrong... any solutions?
lol im only 12 ive got the first part down but on part 2 i cant get ad.exe or the SBD Full Dump. My email is alenatic@hotmail.com and if anyone knows how or why can they send me an email? (prefer reaper-x)
i tried using the vmapextract v2 thing but its taking forever so im not sure wat to do!!! please help!!!anybody!!!
I just wanted to say this is a great guide and easy to understand (I think :) ) but I have 4 small problems
1. I don't have any interactive game objects (banks, signs, mailboxes and stuff)
2. I don't have npc's and quest givers (Horde and Ally)
3. I got no mobs and critters and at last
4. I have some errors regarding tables
I have followed this guide as close as I could. I'm using TBC 2.1.3 with the mangos 4307 from mangos-files.de and CompleteSDB156-Mangos3462. (Maybe thats why it doesn't work)
Got a fully playable world with lan connections only there is nothing to do :)
Can anyone help?
Is "Latest DBC Extractor" a kind of program?
Any of You wanna gimme a hand finding it?
Here is my mail :p nathre.gotta.gun@gmail.com
serdna_solrac@hotmail.com .
Right... I got all the stuff
SDB
Data
Mangos
Iv done it all how u say sept i didnt get the part about the mpqe cose the magnos version i got came with summin like vmap and i just used that -dunno how but i did lol anyaway when i used it it created a buildings folder the vmap folder. Is this right? I was thinking maybe i did summin wrong or summin maybe because i got mangos 4326 - lastest version i could find but the sdb thing i got was SDBFull-204-4176.rar and i couldnt find 1 that says 4326.
Also when i try and make a database it doesnt work maybe thats summin to do with not having used that mpqe i dunno.
But if were creating a tbc server do we need that mpqe?
Hmm well i downloaded a diffrent mangos pack which came with a mpqe thing and i did what u said but when i ran the short cut it just flicked on and flicked of is this right?? and also i dont think its created a DBfilesClient folder but the folder the thing is in is called Dbc is that right?
Nope still not working.
Can u do a seprate guide on making Wow TBC servers cose this ones just made me totally confused
My emails tokodu@hotmail.com if u want to contact me btw
got a list of wrong DBC's this is my first ever attempt at anything this complex so i dont know what i did wrong, i downloaded everything as stated above for a TBC client, please advise what i need to give u
sorry i get xxxxxx.dbc exists, but is 13 instead of 23 etc
Detailed list here
2007-08-17 15:42:42 ERROR:
Some required *.dbc files (23 from 36) not found or not compatible:
C:\WoW\data/dbc/AreaTable.dbc (exist, but have 21 fields instead 35) Wrong client version DBC file?
C:\WoW\data/dbc/BattlemasterList.dbc
C:\WoW\data/dbc/ChatChannels.dbc (exist, but have 21 fields instead 37) Wrong client version DBC file?
C:\WoW\data/dbc/ChrClasses.dbc (exist, but have 15 fields instead 24) Wrong client version DBC file?
C:\WoW\data/dbc/ChrRaces.dbc (exist, but have 29 fields instead 35) Wrong client version DBC file?
C:\WoW\data/dbc/CreatureFamily.dbc (exist, but have 18 fields instead 26) Wrong client version DBC file?
C:\WoW\data/dbc/Faction.dbc (exist, but have 24 fields instead 53) Wrong client version DBC file?
C:\WoW\data/dbc/GemProperties.dbc
C:\WoW\data/dbc/gtChanceToMeleeCritBase.dbc
C:\WoW\data/dbc/ItemExtendedCost.dbc
C:\WoW\data/dbc/ItemRandomProperties.dbc (exist, but have 16 fields instead 24) Wrong client version DBC file?
C:\WoW\data/dbc/ItemRandomSuffix.dbc
C:\WoW\data/dbc/ItemSet.dbc (exist, but have 82 fields instead 53) Wrong client version DBC file?
C:\WoW\data/dbc/Map.dbc (exist, but have 37 fields instead 123) Wrong client version DBC file?
C:\WoW\data/dbc/SkillLine.dbc (exist, but have 22 fields instead 38) Wrong client version DBC file?
C:\WoW\data/dbc/Spell.dbc (exist, but have 157 fields instead 211) Wrong client version DBC file?
C:\WoW\data/dbc/SpellItemEnchantment.dbc (exist, but have 24 fields instead 34) Wrong client version DBC file?
C:\WoW\data/dbc/SpellItemEnchantmentCondition.dbc
C:\WoW\data/dbc/SpellRange.dbc (exist, but have 22 fields instead 38) Wrong client version DBC file?
C:\WoW\data/dbc/TalentTab.dbc (exist, but have 15 fields instead 23) Wrong client version DBC file?
C:\WoW\data/dbc/TaxiNodes.dbc (exist, but have 14 fields instead 24) Wrong client version DBC file?
C:\WoW\data/dbc/TaxiPathNode.dbc (exist, but have 9 fields instead 11) Wrong client version DBC file?
C:\WoW\data/dbc/WorldSafeLocs.dbc (exist, but have 14 fields instead 22) Wrong client version DBC file?
Ok I got it all working now for WoW TBC 2.1.2. The last problem I have is that I can't do instances.
When I attack a mob in there they disappear, for the DM's they walk into the air and then vanish. Is this caused by the maps or the dbc files?
I'm not sure if someone has already with this problem or if you have found out on your on... but for you and anyone else that is having the same problem.....when you create your account you are creating a normal user account. To set a GM level to an account, type "setgm [user name] [level of GM 1-3]"... it should look something like
mangos>setgm mangopie 3
Mangopie being the user name, and 3 being the level of GM, on the mangos server their are 3 levels of GM 3 being the one with the most access and 1 being the lowest. I'm not sure what each level of GM has access to, but 3 is admin and will allow you to do anything you want, given it is available in the mangos commands.
Note: When logged into a GM account type ".commands" into the chat bar for a list of available commands.
i have a wierd problem and i dont know if its just me or if its everyone but when i run mangos i get this looping message telling me things are being moved... here is a screenshot cause im too lazy to type what it really says
http://i45.photobucket.com/albums/f100/thewooleymammoth/help.jpg
[IMG]http://i45.photobucket.com/albums/f100/thewooleymammoth/help.jpg[/IMG]
my email is thewooleymammoth@gmail.com btw please email me if youve got a solution thanks
Hey All, I'm having a Realm Loopback Issue, and i was wondering if I could get some pointer's:
Hey all, I've been browsing through the posts, to see if i could find the answer to my problem, but it does not seem to be here: Alright here is my setup:
I'm running mangos server version 4289 found here:http://www.mangosproject.org/forum/index.php?showtopic=4088&st=40
Its a release by Void:
and Silver's DB 0.7 full: Properly updated all the way through 206. I used Sqlylog to import this SQL batch file to mangosd Database, then I appiled the Core updates in each folder, in order, then Applied the update itself, and did this all the way through 206, as it is supposed to be compatible with Mangos Version 4289. http://sdb.unix7.net/forums/index.php?showtopic=10294
I've got all my dbc's, vmaps, and maps, and buildings extracted from a 2.1.3 setup, which according to the documentation that I've read should be compatible with that release.
The mangos server is running on a Windows 2003 Server, that I setup just to run the mangos app. I also have Mysql Server 5.1, and SQLylog Community Edition 6.0.5, and for Grins and Giggles Navicat as well.
When I startup Mangosd.exe I'm getting no errors, and the Ships are moving around constantly which is a good thing, tells me thats working at least. Realmd is running, and showed no errors.
My Server is setup using a private class 3 IP address behind a NAT Router, i.e anotherwords 192.168.1.104
and my Computer that I am logging in from is 192.168.1.102, and I've turned off the Firewall's on the server
Now here's the sticky wicky: I try to log in and blam, I get the realm loop, i,e it lets me select the realm, and i goto the character screen, then it boots me back to the realm selection, then eventually disconnected.
As I am not playing on my server, I set the Login and the Realm database to 192.168.1.104;3306;root;mangos;database i.e where database is realmd or mangos respectively. In the realmd config the logindb is set the same 192.168.1.104;3306;root;mangos;database.
I also set the realmlist table to
1 Omicron 192.168.1.104 3306 1 0 1
I know, i know, I'll change passwords once everything is up and running properly. All i want to do is connect from inside my lan, I don't intend on having any outsiders connect to this server, simply because my internet connection sucks.
I've checked my hosts file, and everything appears to be kosher there, any thoughts or ideas, other than I'm a noob, and go read other posts; and or guides. I've checked the guides at both the official mangos forumn and the SD site as well if that helps. In theory my setup should work, I'm just stumped at the moment, the only other thing i know to do is to attempt to use Hamachi :(
Thanks all!
well umm nevermind i guesse, figured out what my issue was, or could have been. It was one of three things i changed.
First I went to myip org and got my public address, then I changed, my server addresses to that in my config files, realmd and mangos.
Second in my realm list table, I left that at my private IP address, of 192.x.x.x then I found that the World Server uses the default port of 8085, so I changed my realm list table port field to 8085, then I also made sure that my realm.wtf IP address was the same as my realmlist.table in sql. I also went and double checked my port forward settings on my router, and one of them was 8085, I had that setup from an older setup, now that I remember about it.
Third, and I feel really dee de dee! about this, is that in the realm.database my ip banned had an auto-default to 127.0.0.1....doh! so I changed it from my server's loopback address to x.x.x.x I'm glad the field type was setup for varchar.
So one of those if not all of them fixed my issue, and maybe it might help someone else out there as well.
Peace!
I Don't see any mobs, friendly/hostile, Dreyfuss had this problem too, but i can't find a solution :(
I am very new to this and your guide is great. I'm having some problems with the dbc extractor, when it loads it gets an error and closes instantly. Any ideas? benigni118@yahoo.com
since i never experienced that error message before, i guess it's was caused because you're using incompatible mangos version used (previously someone ask me why his chat doesnt show up) ... and it was caused because he is using wow 2.1 (it's not supported back then and when rolled back into 2.0.12 the problem disappear)
Thanks Reno, as for your question, are you talking about the MPQE or the ad.exe ?
Actually that mean mangos is working :)
if you don't want to see that message, you can adjust the debug level into 1 ;)
somethigns wrong with the MPQE shortcut, it flashes on an off again, but the DBFilesClient folder isnt anywhere, so the MPQE probably didnt work, though i did what the guide said to do and i dont know wer i went wrong
Hey Reaper thanks to you i got my own server antrix though, some information you gave me made it possible for me to get my own server.
I just have one little problem i have TBC Version of wow i think 2.0.12 or something like that when there are other vesions that have to be downloaded. If people do download a patch it says the server is not up to date and so on. So how do i update my server over and over agian as Blizz keeps making more of them. I don't want to have people to downgrade their version to be able to join.
Any thing i could do to help?
Thanks in advance for helping me ;)
I am having a similar problem as Sean. I get all the way to where I run the mangosd and realmd.exe. I get the errors below:
2007-08-19 16:03:14 Using configuration file mangosd.conf.
2007-08-19 16:03:14 MaNGOS daemon /0.7-SVN (Win32)
2007-08-19 16:03:14 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-08-19 16:03:14 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-19 16:03:14 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-08-19 16:03:14 Realm running as realm ID 1
2007-08-19 16:03:14 Using DataDir c:\wow\data/
2007-08-19 16:03:14 Initialize data stores...
2007-08-19 16:03:14 ERROR:
Some required *.dbc files (7 from 28) not found or not compatible:
c:\wow\data/dbc/AreaTable.dbc (exist, but have 21 fields instead 25) Wrong client version DBC file?
c:\wow\data/dbc/ChrClasses.dbc (exist, but have 16 fields instead 17) Wrong client version DBC file?
c:\wow\data/dbc/Faction.dbc (exist, but have 28 fields instead 37) Wrong client version DBC file?
c:\wow\data/dbc/ItemSet.dbc (exist, but have 82 fields instead 45) Wrong client version DBC file?
c:\wow\data/dbc/Map.dbc (exist, but have 37 fields instead 42) Wrong client version DBC file?
c:\wow\data/dbc/Spell.dbc (exist, but have 162 fields instead 173) Wrong client version DBC file?
c:\wow\data/dbc/TaxiNodes.dbc (exist, but have 14 fields instead 16) Wrong client version DBC file?
any assistance will be appreciated.
The MPQE shortcut, it comes up for a second, gets an error and closes but its never up long enough to see what the error says
so i figured some things out about the GM commands.
yes, you have to set your account to be GM (level 3 preferably).
After you do that, you can run any MANGOS gm command.
type in .command for a listing..but theres so many that you won't be able to see them all...
i found a list somewhere, but the easiest thing to do is probably to just go into your database and looka at the command table...(in the main database, not the realm one)...all the commands are listed there, with descriptions if available.
also, when i typed in .title, it initiated GM mode...it put the tag before my name and yea...creatures can NOT go into combat with me..kinda gay =/ i dunno how to turn it off yet..
should be able to type in .gmoff to turnofff gm mode, and .gmon to turn it on. When GM mode is engaged, critters won't attack, and you can't learn spells, and skills from trainers :)
i get a error with i try to open the shortcut of MPQE ... it tell me ... Coulnd not locate MPQ Archive dbc.mpq .... Whats wrong ???
every time i run realmd or mangosd it comes up with "the application failed to initialize properly (0xc0150002). how do i fix this i've searched everywhere.
i cant get the mpqe part to work either..i dont have a file called dbc.mpq anywhere on my system...help!
i can't get the MPQE thing to work... can anyone help. it tells me that the path is incorrect and everything and i have everything correct but i can't seem to figure it out... please AIM me "swiftimundo" or reply to this comment... thanks for your help!!!
i can't figure out the MPQE thing, i put everything in correct but it says that the path couldn't be located or something like that or the the application failed to initialize properly (0xc0150002" thing... ive tried everything.... please help my AIM is "swiftimundo" or just reply to this comment. Thanks for your help!!!
try looking for the dbc file under your wow game directory (some people reported, for tbc client you can find it under your patch directory)
neither my mangosd or my realmd will stay open i keep getting and (10061) error and it says i cannot connect to the database. ive allowed incoming and outgoing ports on both my router and my firewall for the same port mysql is using (port:3309) but it dosnt seem to connect, what am i doing wrong?
make sure :
1. Mysql service already started (look under task manager process for mysql to confirm it)
2. you've put the correct password and username so mangos can connect to the mysql server
I had my server working last night. Everyone was fine until this morning when i began to get this error when running realmd.exe :
2007-08-21 13:02:23 Database: 127.0.0.1;3306;root;root;realmd
2007-08-21 13:02:23 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-08-21 13:02:23 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2007-08-21 13:02:23 ERROR:No valid realms specified.
can you please tell me what to do. Any help would be appreciated
Hey just stopped by to say the tutorial is exellent.
I just have a couple questions:
Just like another person way up there I have 2 boxes too.
Box A is running win XP home and the server works perfectly.
Box b is running win 2k adv server. realmd runs but mangos stops at the realm set to ID 1 and closes.
here's the questions:
1) do you have to run the mangos server on an XP box?
2) does WoW have to be installed on the box in order for it to run?
Just in case it's mangos 3462 and clasic WoW.
thanks in advanced
thanks that helped, but now mangosd gives me this error:
ERROR:Map file 'I:\WoW\data/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.
ERROR:Correct *.map files not found in path 'I:\WoW\data/maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
i ran ad.exe again and still get an error.
btw: im using the ad.exe that was shown here as the most current because the one packaged did not work (im making a classic server)
ok, someone help me, i get to the MPQE shortcut, i changed the target, checked it like 5 times, got the dll file, and then run the shortcut, and then this comes up:
The application failed to initialize properly (0xc0000135). Click on OK to terminate the application.
I have check my password and it is correct but I keep getting this error when I run the "realmd.exe"
Using configuration file realmd.conf.
MaNGOS realm daemon /0.8-SVN (Win32)
to stop.
Database: 127.0.0.1;3306;root;[password];realmd
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@
'localhost' (using password: YES)
Cannot connect to database
I also get this error when I run the "Mangosd.exe"
Using configuration file mangosd.conf.
MaNGOS daemon /0.8-SVN (Win32)
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
World Database: 127.0.0.1;3306;root;[password];mangos
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@
'localhost' (using password: YES)
Cannot connect to world database 127.0.0.1;3306;root;[password];mangos
Any help would be great. I am running windows Vista if that helps. and MaNGOS_rev4339_ScriptDev2_RELEASE.
thanks.
I have that same problem please can anyone help?
Hmm tryed it all again and just still cant get the hang of it. Great guide the i followed most of it easyly but once it started going into the normal wow stuff i just got confused. Yeh anyways if possible i think it would be great if u did a guide to make a TBC cose thats the one im trying to make dunno about anyone else but i think it would be great. Thanks for your time and effort.
tokodu@hotmail.com - if u want to contact me.
Opps i put(Great guide the i..) lol sorry
also just a reminder, looking at the syntax for the Create-database.sql file you don't have to edit the conf file to reflect root's password..
it gives user mangos all access privliges.
course i'm still talking about classic and not TBC. but I looked at TBC's create database file and it's almost identical. so no change is needed.
i cant find mangos AT ALL. torrents dont seem to work. if anyone with all the stuff i need could catch me on aim and send me mangos i would appreciate it. or find a site where i can download it. utorrent says downloading. BUT NEVER DOWNLOADS! my aim is iVolatile.
ok i beleave i did every thing right but when i open
Mangosd.exe or realmd.exe it comes up and it says cannot connect to database for realmd and for mangosd cannot connect to world database and cannot connect to mysql database at127.0.0.1: can't create tcp/ip socket i have no idea what to do Help Pls
Hi friend, Great tutorials, i just seem to be stuck on the MPQE bit, When i make the shortcut, i double click it and it says "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorwks.dll could not be loaded"
Thanks, Danny
NVm i got it but now i got a differnt problem i cant create my test acc
ive tryed what u said could u explain it a little better to me =/
to create test account, you'll need to use this command at mangos window :
create desired_username password
Yes i have that problem as well and it is really annoying -.-
how did you get passsed that affair?
Reaper x
How does the writepdump in mangos work when i use it it gives me i file but nothing inside. Please help whant to export a carracter to a nother server but dont know how.
Hi i have a problem with realmd.exe and mangosd.exe
realmd.txt
2007-08-23 13:22:01 Database: 127.0.0.1;3306;root;mangos;realmd
2007-08-23 13:22:01 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-08-23 13:22:01 ERROR:Cannot connect to database
server.txt
server.txt
2007-08-23 13:22:00 World Database: 127.0.0.1;3306;root;mangos;mangosd
2007-08-23 13:22:00 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-08-23 13:22:00 ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangosd
Ok i got passed that, now when i try to log on it says something like:
Unable to validate the game. This may be due to the version of the game being corrupt....
Can anyone help me??
that mean, you're trying to use incompatible mangos with your wow installation
for example, you have wow classic installed on your computer (without tbc), the only mangos you can use is only Revision 3462 and you can't go any higher than that
and the same goes for TBC expansion pack too, which mean if you're using TBC client you need to use mangos revision 3463 and above
Okay, I got all the problems fixed but now when I start wow I cant get to the realm list. I also get a message when I run the realmsd.exe
Mangos realmd can not bind to port 3306
anyone know why? Ohh and by the way this guide rocks out loud!!!
Awesome guide, nice work! Screenshots helped.
However, I have a perhaps major problem.
The mangsod.exe does not run. I've done the reconfigure thing like three times in a row, reinstalled it, removed it all and installed it all again, still not working. I even got my friend's .exe file which was working and it doesn't work for me. It gives me an error report "Send" or "Don't Send" window whenever I try to open the .exe. It never tells me what the error is. I looked through all the different notepad files and found the only trace of an error in the Server notepad file.
2007-08-22 18:40:09 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-22 18:40:10 ERROR:Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
2007-08-22 18:40:10 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
Any help? Thank you very much.
~Jedash
change the first mangos to your username and the second mangos to you password
I see.. I'll give it a whirl. Thank you.
Well, I did this in the mangosd.conf
WorldDatabaseInfo = "127.0.0.1;3306;root;jedash;password"
Still not working, the .exe still closes on me. And the server text document still says the same error, however, the date has not changed. Any other suggestions?
Comment by Jedash | 2007-08-24 09:46:50
Well, I did this in the mangosd.conf
WorldDatabaseInfo = “127.0.0.1;3306;root;jedash;password”
Still not working, the
No root would be the username and jedash would be the password so it should look like this
“127.0.0.1;3306;root;jedash;realmd” for the realmd config
and
LoginDatabaseInfo = "127.0.0.1;3306;root;jedash;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;jedash;mangos"
try that
Hi jedash,
i'd suggest you to run it from the command prompt directly instead of double clicking on the exe so you can see what causes mangos process to close, and here's how to do that :
Note: i assume you're running Windows XP
1. Start Menu -> Run -> type CMD and press enter
2. go into your mangos directory, for example if you place mangos in C:\WoW\Mangos then type cd /d C:\wow\mangos
3. type mangosd.exe
4. now you'll be able to see what is the actual problem