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