Custom Search
Configuring Mangos for TBC Server or WoW Classic Server – Setting up Private WoW Server
Posted by Reaper-X Jun 28 2007 6:07 pm
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
Trackbacks/Pingbacks
Leave a response
Connect with me
Ok, If you get a “Cannot verify version…” then update to 2.1.0 It fixed it for me and it DOES work! :)
Valery, I got the same error, I updated to 2.1.0 and it worked, don’t ask me why, but it does.
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?
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. =(
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
can u used a copyed over version or does it need ot be properly installed?
ok mine is working fine up ot when i run mangos it just keeps testign the ships, and mine only gets up to handshaking
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.
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!!!
Yeh, its in the root folder with maps created first.
“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.
i renamed my data to data2 btw
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?
Do u know a way that i can get the classic files without uninstall tbc?
On my mangosd.exe and realmd.exe they keep gettinf apllication errors and i dont know why, could you help me plz?
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?
# 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 ?
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?
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 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?
well there is multiple spell proc event sql files so that doesnt really help
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);
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?
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.
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
. . . 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.
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!
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?
THANK YOU SOOO MUCH REAPER!!
i figured out my problem!
YOU ROCCK!
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?
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’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!
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
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.
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?
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?
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.
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.
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?
lol sry but ignore my last comments…it is 3:57 AM here and I’ve been working on this since 11:30 pm>
[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?>
How you fix that promblme? I have the same promble plz help me ty
Does the classical version REQUIRE you to have v1.12.x or does it matter?(as long as it’s NOT TBC?)
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?
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
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.
I forgot to mention that i have version 2.0.12 installed and i was trying with different Mangos servers but without any luck
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
Excellent work.
Thanks so much for taking the time to do this.
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
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