Creating WoW Private Server the easier way (perhaps)
By Reaper-X on May 5, 2007 in Emulators, Freeware, Guide, MMORPG, Misc. Games, Software, Tutorials
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 old version of my WoW Private Server Guide, the new version that gives you a detailed step (with images) can be found at below links :
- Installing MySQL
Setting up the Mangos- Just in case you want to create lan party
- Setting up the webserver to put registration page
Maybe my previous post about creating WoW private server is a little bit confusing for some people and that’s why i create another post on how to set up world of warcraft private server once again but this time … i promise it is not going to be confusing like before :D … and actually i should be thanking everyone who put comments on my previous post, because of their comments i was able to get new topics for my blog … hahaha
Okay and that’s all on the introduction part … now let’s start the guide, but before that please keep this in mind, this guide tested with 1.12.1 World of Warcraft Client (known as WoW Classic) non modified in any part and tested to work with Mangos Revision 3462, but this guide can also be used if you’re going to create The Burning Crusade server although you’ll need to get different database dump from someone else, and of course getting the newer mangos release :
Required Software
1. Mangos Revision 3462 : The mangos release is compiled by Maxi and this release also include the following patches :
- ScriptDev2 R34
- Honor 0.71
- MCH 1.5c
And just like i said to make thing easier, i upload this mangos release (just in case Maxi reading this, and he does not want me to upload his file here … let me know immediately so i can remove it … because i already forgot where i get his release) .. i think it is from his userbeam / beam something folder
2. Complete SDB with Changesets 156 : Because there’re problem for some people when importing each changeset, i decided to release the SDB used by me … and this SDB updated till changesets 156
But i also include, the create database, and realmd database to make thing even easier
3. MySQL : Essential program, the above 2 files can not be used if you dont have this installed :)
4. Map & DBC Extractor : This is tested to work with World of Warcraft Client version 1.12.1 and Mangos Revision 3459 and Revision 3462 only
But just as i said before, to make thing simpler. I’ve uploaded the DBC Files (maps not included because the file size is bigger than i thought, and my connection speed is nothing compared to all of you) .. and that means all you have to do is just using the ad.exe / map extractor to extract the WoW Maps
Mirror to download the above files if you’re having problem with Megaupload :
Complete SDB Dump for Mangos 3462 WoW ClassicMangos 3462 by MaxiWorld of Warcraft 1.12.1 DBC Files
Let’s Start
I assume you’ve already downloaded the required software and already installed it (for more in-depth WoW Mangos installation please refer to my previous post)
1. Install the MySQL Software and configure it accordingly, in this example MySQL installed in C:\MySQL and using the default root password which is blank
2. Extract the Complete Database file somewhere in your harddisk, and you’ll see there’re 3 files :
- create-database.sql
- realm-database-full.sql
- mangos-full-for-rev3462.sql
Run it by using this command (this time i make sure to use the default path instead of using command which is already set in environment variable path) from Start Menu => Run => cmd (this cmd can only be used in Windows XP) or command (Win9x) => and change to the extracted directory :)
- C:\MySQL\bin\mysql.exe -u root < create-database.sql
- C:\MySQL\bin\mysql.exe -u root -D realmd < realm-database-full.sql
- C:\MySQL\bin\mysql.exe -u root -D mangos < mangos-full-for-rev3462.sql
Note : The create database will also drop your realmd and mangos database if it is found .. i do this in order to make thing easier (how many times did i say this words in this post) lol
Yet another Note : Extract the database into the same path where your MySQL bin located, or if you already extracted it somewhere adjust the path like below for example :
C:\MySQL\bin\mysql.exe -u root < X:\where_SDB_extracted\create-database.sql
3. Put the downloaded DBC Directory somewhere, in this example C:\WoW\Data\DBC
4. Copy the ad.exe into your WoW installation directory also create directory called maps and run it .. and wait till finished and move the maps directory into C:\WoW\Data\maps
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
DataDir = "C:/WoW/Data"
If you’re using the example path given in this guide, you can use the above datadir configuration
6. Run the mangosd.exe and realmd.exe …. and you’re finished :D configuring the server
7.I’m sorry i forgot to write the last step in this post (thanks to GreekSoul). Now since you’ve finished configuring the server all you have to do now is configuring the client (WoW game) to connect to your server instead of using the default / official server. And it can be done by open the realmlist.wtf in your WoW Game directory and change the realmlist into 127.0.0.1 … and you’re all set
Common Question
I create this part thanks to all the commenters before … especially to metaltildea, PepsiG, Xtonic, luke, Venomz, etc
Q : hay me again it works but the CMD thing it says that the thing u wrote up dosnt exist on the second time
so it wont make the directory :(
A : If you tried to run the mysql command directly without setting it to use the env. variable path, you’ll get that error message … also CMD only work in Windows 2K (correct me if i'm wrong because i already forget about it) and Windows XP (guaranteed to work)
Q : I forget about the signs that dont let me post it.. ERROR 1045 (28000): Access denied for user `username @ localhost` (using password: NO)
A : That error message means, you’re trying to use wrong password for a username, username does not exist, etc .. but in this case, you’re trying to use non existent username (because it was an example)
Q : ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)
A : If you’re trying to use named pipe (this mysql feature only can only be used on NT series such as Windows XP) and you havent configured mysql to do so .. you’ll get that message … to fix it you just have to put below line into you my.ini file (do not forget to restart the mysql service after you done)
enable-named-pipe
Q : Can i import the official data from Blizzard server into my mangos server ?
A : The answer is no, because … blizzard is using different server software which is not available to public .. and no one have access to their server :P ..
Q : my add.exe wont run in my wow map
A : Did you create the maps folder first ? if you did not create it you’ll get an error message. Also you’ll need to run it in your root directory of your WoW installation directory
Q : I can’t run ad.exe or MPQE
A : Im sure there’re missing runtime in your windows system, try downloading and installing below 2 files first and see if it’s fixes the problem or not
- Microsoft .NET 2 Runtime
- Microsoft Visual C++ 2005 Redistributable Package
Q : ERROR 1264 at line 294: Out of range value adjusted for column ‘waittime’ at row 1
A : You’re trying to insert value higher than the allowed value specified in your mysql table … but in this case, this error message seems strange, because i have no problem importing the SDB files including it’s changesets … and that’s why i create this post and upload my database dump :)
Q : I want to be a GM in my mangos server
A : Look at the step #10 in my in-depth explanation on setting up mangos server (do not copy paste the text directly because it’ll give you error message) … and if you get other error message just leave comment here :)
Q : What are the GM Commands ?
A : After making your account to be a GM account, type this ingame .commands and you’ll see available commands to use
Q : My friends can't connect to my server ?
A : Try checking your configuration especially at port configuration, and make sure there's no conflict
Okay that’s all for now … i’ll be sure to update this post / create new post if i found something new from you :)
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
Facebook
Last.fm
Twitter
YouTube
hey can you help me with mySQL im at the step where it tell me to configure the mysql server server instance where they are like 4 white spot whrited prepare configuration ,write configuration file , start service , apply security setting ... i click on execute and there an X in the white circle beyond de start service and its writed CANNOT CREATE WINDOWS SERVICE FOR MySQL. ERROR: 0
Hello GreekSoul
Did you ever installed mysql before ? btw what is your operating system ? is it windows xp ? if it's windows xp try typing this at the Run in start menu
services.msc
and look if mysql service already installed there or not
if it's already installed, try right clicking on the mysql service and choose Start
Hi I have a problem connecting to the Mangos server from another pc. I can connect from if I run WOW on the server PC, but not from another. allready checked the realmlist file. Thanks
hi i have revision 3459 i just wanted to know how i could update from my mangos to revision 3462 or if theres really a big difference or not if not i will stay how i am. mainly wanted to know if there was any new fixes for pets in revision 3462 that there werent in 3459 thanks
Ok Thx For Your help ! i do all the steps and everything seem to had worked without some ERROR but now im wondering '' 6. Run the mangosd.exe and realmd.exe …. and you’re finished '' its ok i run both of it and all seem to work properly but now how can i connect and play on my server ??? ( Sorry for my noobs question but i don't know , i'm skilled a bit with computer and C++ ect... but first time i create a server and ect... ) thx for your help very apreciated ! ....
# Greeksoul
Im so sorry GreekSoul, i forgot to add the last step which is involved editing the realmlist file (i forgot i wrote it in my previous post) lol
And thank you very much for telling me about this .. and this post has been updated now
# Meza
I dont know much about pet in wow but i didnt see anything related to pet in changelog 3462
btw here's the changelog of Mangos 3462 (3460 - 3462) from its svn :
-Fixed compiler warning at float->uint32 conversion
- Revert talent related code changes from [3460] until additional research.
-Fixed "When player sends a mail with C.O.D and the mail expires and is returned to sender. And when original poster will take item back he must pay C.O.D and money are send to original reciver" - patch provided by Marty .. thx
-Fixed: talents bonus loading: load auras after spell load and talent initialize. Patch provided by Ianos Gnatiuc.
-Fixed: use special packet instead text notifier for instance warning about forced exit. Patch provided by TOM_RUS.
And changelog for 3459 :
-Fixed: update pet/charmed pvp state at owner player pvp state update.
-Replace function Unit::isInCombatWithPlayer to more useful for neutral city guard scripting Unit::isAttackingPlayer.
# ME24
Ah it seems you're trying to set up mangos for LAN ? if that's the case try editing the realmlist table in realmd database, and configure it to use your lan ip address instead of the default 127.0.0.1
ok thanks for the changelog info
Q : I want to be a GM in my mangos server
A : Look at the step #10 in my in-depth explanation on setting up mangos server (do not copy paste the text directly because it’ll give you error message) … and if you get other error message just leave comment here
I Was Asking myself about that , i tryed to Do It But i dont find the mangosd window and i dont know where to enter the commands to create an account
10. Now you can connect to your own server, if you want to create new user account you can do so by typing create username password from the mangosd window (it’ll create normal user account). But if you want to create GM account you can do so by typing this from normal command line (type cmd in the run command) and type below lines :
where i type these lines ? in the mangosd window , but where i can poped out this window ? i don't find where i can start this window .... sorry its very embarrassing but i don't find where i can pop out these window!!!!! thx for taking of your time to answer me ! very apreciated !
GreekSoul.....
# meza
Your welcome meza :)
# GreekSoul
dont worry about it, beside that's what this comment form used for :)
and actually you type it in real command prompt window (type cmd at run) and then continue to type the sql query and you're finished
but you can also use mysql client to do the same thing if you don't want to type the whole sql command
Can u make me a server i cant do anything, i tried everything but still nothing. if u could make me a server i wouldnt know how to repay you. i am begging u to make me a server and give me the realmlist
make it a funserver, XP X 1000 Money X 1000 drop X 1000
How can we get some TBC action?
i was wondering how to get the latest verson of WoW onto a private server so it can be just me and a couple of friends?
if you already have a private server using the latest version of WoW can you bring it online so other ppl can play? how do u change the xp/item-drop/gold-drop using this method?
Ok thx i found the window ... but now im doing the step to create an account ( step 10 in your other guides ) im writing ( -u GreekSoul -p ) press enter now its asking me for a password , i enter the password then press enter but its writing me ERROR 2003 : Can't connect to MySQL server on ' localhost ' :S ( i enter MySQL in the environement system path ! ) and still writing me that , so i tryed to create a GM account but still writing the same error after i tryed this commands ( USE `realmd`; ) and tell me that the commands is not recognized like an internal command ect..... ! :S i just need to create a account to play in my server but im stuck at this stage ! if you could help me or tell me another way to create an account so i can play in my server ( i want a GM account ) ( please note i have entered MySQL in System environement path )
your help is very apreciated !
can u make a new guide for dumbi ppl plz lol, i dont understand
Hey there. I can't install mysql. I went to the services.msc like you said, but i get the error: ERROR 1067, could not start the process locally. Please, any info would be greatly appreciated. Thanks.
# somi
yes its possible to create high rate server like that because all you have to do is just edit the mangosd.conf and set the XP rate from Quest,etc into 10000 or more ;)
but i do not recommend you to set drop rate higher than 10 (i tested it in 1, 5, 10, 100, and 1000) .. both 100 and 1000 drop rate cause problem with quest
# GreekSoul
hm .. if you cant connect to the mysql server on localhost, im sure the mysql service is not started. try start the mysql service first by using below command (type it in run)
net start mysql
if the mysql service cant be started try searching for *.err filetype in your mysql directory and post the log here :)
# carbon
im sure there's something wrong with your mysql configuration .. maybe you could try posting the error log here, so i can see it ?
to look for the error message, search for a filename *.err in your mysql installation directory and then open it using your favorite text editor (for example notepad)
# Dhaka2
if you could tell me which step you're stucked at maybe i can tell you how ... or if you could give me a suggestion on how to improve this guide further :)
Sure thing, but unfortunately, I'm rather noobish and don't know how to access my mysql installation directory. Sry bout this, but I'm learning! Thanks again for your patience.
Carbon.
This suck, When i put the AD.exe in my wow installtion dir and create a dir called maps and run AD.exe it's just poping up errors, and besides that, I cant run those sql files , This is really a bad tut, You dont explain where i shoeld run it or what program i shoeld use, Really bad :S, I want a more understandable tut, Please ?
Hi!
The thing is great, but I can't get the coding to work. I have all the files, but the code says it doesn't exist.
Thanks
Ed
im now trying the first step, but it keep saying it cannot find the file specific. but im sure i typed correctly
do u know why?
I've got the server up and running. I just need to know how to let my friends connect to it...
Thanks again.
# carbon
You can use the search function (i mean windows search function) to search your harddrive for MySQL :)
# Helimaster
I believe you're trying to use the ad.exe with WoW TBC client (i've received several email asking this too) .. and the answer to that question is ..
if you use TBC client, you'll need to get the newest ad.exe first (you can find it in mangosproject forum)
as for running the sql files, all you have to do is install the mysql first and then open the command prompt and do the rest .. there's no other program involved :)
# Ed & pk-kyo
Which file doesnt exist ? i guess you're trying to execute the sql files ... and if that's the case try switching the current directory first into where the sql files extracted ;)
# Ghost
Ah .. you can read it on my previous comment about creating public wow server
..okie this is suk....im missing creature_template table..in my files...
"
Using configuration file realmd.conf.
MaNGOS realm daemon /0.7-SVN (Win32)
to stop.
Database: 127.0.0.1;3306;mangos;mangos;realmd
Added realm "ReaperX".
realmd process priority class set to HIGH
"
Is the realmd.exe suppose to stop here?
# cinnam0nr011
That's correct cinnamon :)
# pk-kyo
ah .. im sure you didnt import the mangos sql files correctly because the creature template is inside there (open that file using your favorite text editor and search for it)
Hey Reaper-X. Thank you very much for taking so much of your time to write these guides, as well as help everybody out who is having difficulties.
Maybe you could help me out. I have everything downloaded, installed, and configured. I start up my server, and I log in successfully. I see my realm come up. I then try to click on my realm and go to the character page, but that does not happen. I just keep getting stuck on the page that shows me the realm I just made. Any suggestions? Thanks so much!!
Yeah, thanks for the guide. I happen to be having trouble with my Mangos server as well. Everything works locally. The problem is getting others to connect (Not LAN) I tried changing the ip from the default to my public IP - Did not work
Thanks
Oh, update (Sorry for double) - I forgot to add that they CAN login successfully, but when they get to the realm selection and try to accept a realm, it takes them right back to the beginning of realm selection again.
I have server working on my current machine, but I cant seem to connect using my other machine. It goes up to the part where you choose your realm and it keeps on asking even though I've pressed okay button many times... Do i have to install mysql for both machines or just the one thats hosting it? (having trouble connecting to the server on the other machine) I've setup the realmlist.wtf already. (set realmlist My_IP_Adress[192.168.xxx.xxx]). I don't know what to do at this point, to make the other machine able to connect to my current one thats hosting the thing.
Hey,
I am pretty sure I have done everything required, but when I try log into WoW, IT comes up with:
unable to validate game version....
That was on my regular account I made, on my GM account it says: unable to connect.
I might just start over again? Also, I find that the detailed guide is alot easier to understand than the new one.
When I run mangosd, it gives me the following error
Error in 'item_template' table, probably sql file format was updated .
I'm using 0.6.4 SDB, but I figured a more recent version would work aswell... So that may be the problem.
Steve
unable to validate game version….?
make sure your World of Warcraft Client version is version 1.12.1 and Mangos Revision 3459 and Revision 3462 only (4 on required) i think
# Avalanche, Nincb123 & cinnam0nr011
Im sure you guys already changed the IP address set it realmlist table, right ? so other can connect to your server
but if you still havent changed it here what you should do to change your IP address in realmlist table :
note: adjust the MySQL path accordingly
- open command prompt and type below command
- C:\MySQL\Bin\mysql -u root
- Use `realmd`;
- UPDATE `realmlist` SET `name` = 'The server name',
`address` = 'Change this to use your public IP' WHERE `id`=1 LIMIT 1 ;
- quit;
also dont forget to open port 8085 (the default port used) if you're using firewall
# cinnam0nr011
Do i have to install mysql for both machines or just the one thats hosting it? (having trouble connecting to the server on the other machine) I’ve setup the realmlist.wtf already. (set realmlist My_IP_Adress[192.168.xxx.xxx]). I don’t know what to do at this point, to make the other machine able to connect to my current one thats hosting the thing
No you dont have to setup mysql on client machine, all you have to do is just change the IP address in realmlist.wtf to use the server address used previously (it's the sql command)
# Nincb123
Were you able connect to your own server locally (not LAN / Internet) ?
# Steve
I am pretty sure I have done everything required, but when I try log into WoW, IT comes up with:
unable to validate game version…
If you get that message, im quite sure that there's a problem with your WoW installation
I might just start over again? Also, I find that the detailed guide is alot easier to understand than the new one.
Hahaha .. yes .. actually i made this one dedicated to those who's keep getting sql error message (quick and dirty fix) by uploading database dump
but i think i should make a screenshot too :)
# Carom
When I run mangosd, it gives me the following error
Error in ‘item_template’ table, probably sql file format was updated .
I’m using 0.6.4 SDB, but I figured a more recent version would work aswell… So that may be the problem.
What WoW Version you're running ? is it 1.12.1 (Classic) or 2.x (Burning Crusade)
Okay... I got the thing running but for lan it looks like they can't join it (whenever they logon, they go to the realmlist screen) after clicking on the server and the okay button it repeats on going to the realmlist screen.. can you help me?
Hi
i cant do the thing whith
"C:\MySQL\bin\mysql.exe -u root
Steve: check out this site http://www.gamedaily.com/world-of-warcraft/pc/game-downloads/2475/?dl=success
it has all of the patch files you need to get to 1.12.1
This is the same issue I had. Good Luck
I get stuck at the command part where do i extract the files to.. it keeps saying "the system cannot find the file specified."
# Caseyk
Try adjusting the path to where you installed MySQL
By default (if you didnt change the installation directory path when installing MySQL 5) the mysql bin can be found in :
C:\Program Files\MySQL\MySQL Server 5.0\bin
# Fredd1
Did you get an error message ? and if you did .. what is the error message ? if its the same error like Caseyk ... then adjust the path accordingly :)
# cinnam0nr011
Do you have firewall installed ? also were you able to connect to your own server (and play) it using the LAN ip address ?
Yes I was able to play it, it was using the LAN IP Adress, and Yes I do have firewall (AVG Free Edition). I've tested with firewall both closed and opened.. oh and
"
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070512 0:34:36 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070512 0:34:36 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070512 0:34:36 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070512 0:34:36 InnoDB: Started; log sequence number 0 0
070512 0:34:37 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070512 1:07:21 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070512 1:07:21 InnoDB: Starting shutdown...
070512 1:07:23 InnoDB: Shutdown completed; log sequence number 0 341071
070512 1:07:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070512 1:11:03 InnoDB: Started; log sequence number 0 341071
070512 1:11:03 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070512 14:07:57 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070512 14:07:58 InnoDB: Starting shutdown...
070512 14:08:02 InnoDB: Shutdown completed; log sequence number 0 973486
070512 14:08:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070512 14:08:09 InnoDB: Started; log sequence number 0 973486
070512 14:08:09 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070513 1:15:09 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 1:15:09 InnoDB: Starting shutdown...
070513 1:15:12 InnoDB: Shutdown completed; log sequence number 0 1006520
070513 1:15:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 1:15:17 InnoDB: Started; log sequence number 0 1006520
070513 1:15:17 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070513 2:20:50 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 2:20:50 InnoDB: Starting shutdown...
070513 2:20:53 InnoDB: Shutdown completed; log sequence number 0 1229756
070513 2:20:53 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 2:24:45 InnoDB: Started; log sequence number 0 1229756
070513 2:24:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070513 2:24:54 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 2:24:54 InnoDB: Starting shutdown...
070513 2:24:57 InnoDB: Shutdown completed; log sequence number 0 1229756
070513 2:24:57 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 2:25:01 InnoDB: Started; log sequence number 0 1229756
070513 2:25:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070513 2:46:49 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 2:46:49 InnoDB: Starting shutdown...
070513 2:46:53 InnoDB: Shutdown completed; log sequence number 0 1229766
070513 2:46:53 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 2:47:00 InnoDB: Started; log sequence number 0 1229766
070513 2:47:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070513 3:01:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 3:01:41 InnoDB: Starting shutdown...
070513 3:01:44 InnoDB: Shutdown completed; log sequence number 0 1229776
070513 3:01:44 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 3:01:44 InnoDB: Started; log sequence number 0 1229776
070513 3:01:44 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070513 15:45:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 15:45:56 InnoDB: Starting shutdown...
070513 15:45:59 InnoDB: Shutdown completed; log sequence number 0 1229786
070513 15:45:59 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 15:46:40 InnoDB: Started; log sequence number 0 1229786
070513 15:46:40 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
"
came out of the .err o.0
"
ERROR 1054 (42S22): Unknown column 'Change this to use your public IP' in 'field list'
"
(in this I changed the thing I used to what it was so that it doesn confuse you) this is the outcome of what you told me to do in the command prompt
- open command prompt and type below command
- C:\MySQL\Bin\mysql -u root
- Use `realmd`;
- UPDATE `realmlist` SET `name` = ‘The server name‘,
`address` = ‘Change this to use your public IP‘ WHERE `id`=1 LIMIT 1 ;
- quit;
my bad meant 'The server name‘ >.> sry bout that
# cinnam0nr011
I didnt see anything wrong with your mysql installation (it seems working fine)
and as for :
ERROR 1054 (42S22): Unknown column ‘Change this to use your public IP’ in ‘field list’
try typing this first like in real example below and see if the column number are same or not :
C:\Documents and Settings\Someone>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.xx
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use `realmd`;
Database changed
mysql> SELECT * FROM `realmlist`;
+----+-----------------+---------+------+------+-------+----------+
| id | name | address | port | icon | color | timezone |
+----+-----------------+---------+------+------+-------+----------+
| 1 | The server name | 1234567 | 8085 | 1 | 0 | 1 |
+----+-----------------+---------+------+------+-------+----------+
1 row in set (0.00 sec)
mysql> quit
Bye
C:\Documents and Settings\Someone>
forgot to tell you this, if you didnt set mysql in environment variable path ... adjust the mysql path accordingly :)
btw if you type the update command correctly it'll show you something like this (btw you must change the ip address into number first because it cant accept string) :
C:\Documents and Settings\Someone>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.xx
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use `realmd`;
Database changed
mysql> UPDATE `realmlist` SET `name` = 'The server name',
-> `address` = 'Set the IP Address here' WHERE `id`=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> quit
Bye
C:\Documents and Settings\Someone>
as an addition, you can copy paste the command from here (i mean this comment) directly, i've encoded the special character to make thing easier :)
I was able to set up my server and create a regular account with no problems and logged in and played. The problem now is that I can not make a GM account. I have entered exactly what I was suppose to in the cmd window and when i type USE 'realmd'; it says data base changed and then I enter in the next set of things but nothing happens. Then when i type quit nothing happens. I'm not sure what I'm doing wrong but I think I've done everything like you said. Thanks for your help.
hey when i run the ad.exe it comes up with a C++ runtime error, what does this mean?
yea im a noob at this ( im sure its a great guid ) but i dont get step 2 ..... little help?
me again :P can u add me on msn or email me to melp me out ?
Okay, Thanks for all your help ^^ Appreciated it. This means that my server is all good now. (all thanks to you :D)
Ok im stuck at the same problems for the last 12 hours, first one is when i click start the mangosd it says "The path selected does not contain Mangosd.exe" the second problem is that it keeps saying that My configuration file is rong and that i should modify my options... #28000Access denied for user 'root'@'localhost'(using password:YES)
I have Mysql 6 and i have the Rev.254 Mangos Database handler...
Any help would be great thanks...
# Danman
When you type the INSERT INTO did you get response like this :
Query OK, 1 row affected
If you get that message that means its already written into the database .. and you just need to login using that username you just created ;)
# LukeZ
There are 2 possibilities :
1. Your system missing the runtime required
2. You forgot to create the maps folder first before running it :)
# angus
me again :P can u add me on msn or email me to melp me out ?
Sure but what is your timezone ? you can see my local time by using Google
http://www.google.com/search?q=jakarta+time
# cinnam0nr011
Your welcome cinnamon :)
# Inittowinit
Hm ... could you post the server log here ?
as for the ERROR Message :
#28000Access denied for user ‘root’@'localhost’(using password:YES)
that means you use wrong password
by default, root password is blank / none :)
Reaper x, where is your email, ill send u a nice big email explaining all the problems im having... oh and the server log is so full of crap u dont wanna see it, i try to open something for 3 seconds and it spams this into the log:
Realmd server crashed at 15/05/2007 4:01:43 PM. It lasted 0 minutes
Yeah so if i could grab ur email ill send u stuff
sure, just take a look at the about me page ;) i already put my email address there lol
Sent a confirmation email first, just reply so i know its you. Ill give quick debreif... I downloaded Mangos Database Handler 0.4Svn from bluesailer.com and updated it to rev 254, Mysql from the mysql.com site (the latest version (6.0)) I use .rar (trail) to open up the files which you posted.. Bigger email coming soon
done (actually i already sent reply at 1:40 PM or 5 minutes after you posted your last message here)
note : the displayed time on comments are using my local timezone :)
OK sent it, basicly i just need a step by step word for word tab by tab description of what to do ...goodluck lol
Reaper! You gotta help me out on this one , ive been sitiing here now for 2 days " yeah 2 days !! " and stil cant figure out whats cousing my problem.
I get connecting for 10-15secs then it says Unnable to connect ?! - Any ideas PLEASE answer here or add me on msn: playableplayer@hotmail.com
Do you need to pay for the MySql or is it free?
If you have to pay has anyone tried mircosoft's SQL server 2005 express edition?
# mike
MySQL is free (grab the community version) :) ... so you dont have to worry about it, as for MS SQL, im sorry but i havent tried MS SQL :(
# nicca
Well .. maybe you could give me a detailed description on what error you're experiencing ?
Maybe you will be able to help me if I make it easier on you.
This is what I do in the cmd:
mysql -u root -p
I enter my password
USE 'realmd';
Then it says Database changed
Then I type:
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');
and I type it continuesly on the same line with the auto wrap around with no returns or anything like that. But when I hit enter nothing happens except a arrow appears on the next line like it wants me to type something else. I think I am entering that last line incorretly. Should I hit enter and a certain point? All your help is wonderful.
# Danman
Try copy paste this directly (i've encoded the ` and ' character so you and other can copy paste directly from the post)
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');
try it
Sorry if this go thow twice dont think it posted the first time
If u can plz help me, iv done step 6 "Run the mangosd.exe and realmd.exe …. and you’re finished :D configuring the server" (also changed reallist.wtf) and wen i try to log in it says Disconnected from Server.
I looked back over the steps and found Server & Realmd text docs appeard after running mangosd.exe , realmd.exe, and i think there saying my access wos denied.
This is the Server text doc
2007-05-16 13:09:26 Using configuration file mangosd.conf.
2007-05-16 13:09:26 MaNGOS daemon /0.7-SVN (Win32)
2007-05-16 13:09:26 to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2007-05-16 13:09:26 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-05-16 13:09:27 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES)
2007-05-16 13:09:27 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
And the Realmd
2007-05-16 13:09:29 Using configuration file realmd.conf.
2007-05-16 13:09:29 MaNGOS realm daemon /0.7-SVN (Win32)
2007-05-16 13:09:29 to stop.
2007-05-16 13:09:29 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-05-16 13:09:29 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES)
2007-05-16 13:09:29 ERROR:Cannot connect to database
Can u plz help me with my problem.
# R3d I
Im sorry but my spam filtering thought your comment was spam lol ... fortunately i checked it and saw your legitimate comment :)
as for your question :
2007-05-16 13:09:29 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
if you were using database from this site, did you run (i mean execute) the create_database.sql first ? before launching the mangosd process and realmd process ?
and if you use database and mangos release from another site, try go to the sql directory located in your mangos directory and run create sql first :)
Hello! There's just one problem about this. What do I do to get Mangos Revision 3462 and the other things? When I click on the link it takes me to the site for Megaupload. I've already downloaded it but it still doesn't want to work. Do you have any other links?
Ok sorry I was trying to use it with firefox. It works now. :P
also to my above post: im trying to set up a 2.0.12 server if any 1 knows another guide that would help greatly, atm 1.12.1 is basically practice for me
NM about the SQL. looked around the site and found the freeby download section sry bout tht
ok, encountered another problem, how am i supposed to configure the mysql? i see the configuration settings documents but im not sure which fits my comp best
noob me didnt extract the files when i thought i did lol, nm bout my last posts- now im having a problem with
C:\MySQL\bin\mysql.exe -u root
Thank You Very Much Reaper-X i can now run Mangosd.exe and realmd.exe, they both seem to be working.
mangosd all loads up and starts saying the zeppelin is moving...and such
realmd says wot is says ( i read a post where some 1 asks about it and u say it fine.
BUT... wen i load up WoW (witch is not the normal one i play with my account, it is another 1 i installed then changed the name of the original) and try to login, it says Disconnected from Server.
also i don't have any idea wot my username or password should be for logging in to the server, i'm just putting in any random letters
BUT… wen i load up WoW (witch is not the normal one i play with my account, it is another 1 i installed then changed the name of the original) and try to login, it says Disconnected from Server.
Could you be more specific about this ?
also i don’t have any idea wot my username or password should be for logging in to the server, i’m just putting in any random letters
If you dont want to create new account, you can use the built in account from Mangos
here's the username you can use to login :
full access
- username : administrator
- password : administrator
GM access
- username : gamemaster
- password : gamemaster
i need to know how to get my old default wow server back i already played the private server and i got bored and i cant get back on the normal server...so can u help me out?
# dvd
do you mean restore your WoW so it can play on official server again ? if that's your question
the answer is yes
you just need to edit the realmlist.wtf in your WoW installation directory and change the 127.0.0.1 into :
us.logon.worldofwarcraft.com
Hope that help :)
so, i want to get my buddies to play with me, but the catch is, i want them to play from their houses and whatnot. i have everything set properly, mangos and realmd load up fine, however, i also cannot enter the world from my other pc because it keeps sending me back to the realmlist. heres the catch, im using my friends internet to host the server. what should i do?
Would this software work with the client downloaded for the free trial account? Its the full version with burning crusade i think its 2.0.0 before patching. If you could point me in the direction of a really good emulator source and Database source that works good with this version id be greatful, it seems alot of the emulator links are outdated or dead due to blizzard cracking down on stuff. thanks
:D Thanks Reaper-X I got it all up and running now.
i don't now why it diden't working last time i tryed, but now it connects just like THAT! now.
Thanks again Reaper-X you realy are doing justice to the community :D
I need some help.
In the cmd line i type : "C:\MySQL\bin\mysql.exe -u melon
im having a problem with mangosd.exe and realmd.exe,when i start it,its just there for a few seconds and then it shuts down,on the note .log they create it says : mangos :2007-05-21 21:12:41 Using configuration file mangosd.conf.
2007-05-21 21:12:41 MaNGOS daemon /0.7-SVN (Win32)
2007-05-21 21:12:41 to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2007-05-21 21:12:41 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-05-21 21:12:41 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES)
2007-05-21 21:12:41 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
and on realm :2007-05-21 21:12:42 Using configuration file realmd.conf.
2007-05-21 21:12:42 MaNGOS realm daemon /0.7-SVN (Win32)
2007-05-21 21:12:42 to stop.
2007-05-21 21:12:42 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-05-21 21:12:42 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES)
2007-05-21 21:12:42 ERROR:Cannot connect to database
plz,what am i doing wrong ?
can you tell me how to create my own realm
To robert,theres a guide on how to create your own realm at the top of the page
I currently play WoW on Official servers But also whould like to have my own private server. Is it possible to have my normal WoW that I log into Bliz servers to play and the Private server at the same time? Please shed some light on this as I would really like to try out the priv server :)
Thank you
Im sorry for late reply everyone, because my old computer has finally rest in peace, and today i just bought a new replacement for it :)
# Shinjitsu
Hii shinjitsu ... try reading this and if you still have problem feel free to talk to me directly on MSN
# Snaef98
I believe it'll not work with the trial version, but recently i just talked with someone over MSN, and he says he has a problem with his mangos TBC downloaded from torrent and when i saw carefully it seems that he downloaded mangos and database (which is not work on his full version) that can be used on trial version so i think maybe you should try searching for it (since i forgot the url)
# Kotz
I believe you're trying to use incorrect password / username for your mysql account ... did you change anything when installing mysql ?
# CoolTool
If you can make install wow to use different path and registry, i think its possible although i havent tried it yet :D
perhaps virtual machine software can help you accomplish this ;)
Hint : Microsoft Virtual PC 2007 (free)
hello is there anyone from europe that can help me using mysql for my server please? or can help me via remote assistance
When i use the CMD commands it always says
the system cannot find the specified file, and i can see they are both there. HELP!!
Maby I am missing something but when I try to run the ad.exe from within my normal working wow directory it displays some errors that appear to mean it can't find the files. They appear like "Opening ./Data/patch-2.mpq" Then you get "Error opening archive ./Data/patch-2.mpq" I actually found a patch.mpq another file it wanted and when i put it in C:\data\patch.mpq the error went away in the ad.exe program but it still can't continue after about the fourth MPQ file it says something about an Assertion Failed: and some header things and then like it wants a file from a D: drive. Is there some way to get it to stop or is this just a result of the missing MPQ's from before the error?
I managed to fis the other issue I was having by downloading another version of the ad.exe program now mangos complains about a map file being non-compatible "Map file 'c:/wow/data/maps/0004331.map' is non-compatible version (outdated?). P
lease, create new using ad.exe program." Thought maby it was a new map and mangos could not run it with the version I have so I moved the map file but it needs that file apparently so i put it back and continue to get the same old error message.
# Bernard
I can help you if you want just add me on msn
# Daniel
open command prompt and type this :
mysql
thats it ... tell me what's the result
# Eagle472
if you're using TBC client, you'll need to get the latest ad.exe which is available for download from mangos SVN repository
look at my previous comment here
I am sure I must just be missing something. But I am unable to connect to the local server even though all the server parts appear to be functioning, at least they are doing something without displaying an error message. I have downloaded mangos, MySQL, the SDB, the Extractor, and the DBC downloads from above followed the instructions and appear to have the server running the mangos screen shows alot of this thing moved to x,y type information and the realmd program seems to be ok it says something about adding a realm and the process being set to high priority. Then I change the realmlist.wtf file to "set realmlist 127.0.0.1" and launch it using wow.exe running version 2.1.x.x the latest version blizzard has out. It would come up to the main login page with the dark portal in the background and the music asking for username and password. Then say that it can't verify game data and that something is corrupt. I then try reinstalling wow then bc and patching up to version 2.0.12.x the version pevious to 2.1.x.x and change the wtf file and get the same problem. I then try another reinstall of wow and then loading bc no patches change the wtf file and again same problem. Is this a problem with my installation of wow or am I missing something from the server that the client does not recognize it as a server and trys to get to blizzard? Please help.
unfortunately some people has been asking this question too (yesterday)
and i think it all happen because of the latest blizzard patch (2.1) ... some people who previously got their server working without problem always having problem after they've upgraded to WoW 2.1 :(
is there anyway you can upload the map files? i downloaded the updates for C++ and installed all the missing runtime components and the map add wont work. i have even tried redoing the whole thing a couple of times, it still wont work... please upload them?
ok so i typed in mysql, and now it does nothing, it says C:\blah\blah\blah\cmd mysql
and now i tried it again and it says
C:\Documents and Settings\Daniel>mysql
'mysql' is not recognized as an internal or external command,
operable program or batch file.
Really appreciate you taking the time to set up this guide. Helped me out alot.
I'm just wondering if you know where I can get the Mangos revision 3735 for BC expansion?
RE: Daniel
It kindof sounds like your sql installation directory is no longer in the path. During the MySQL Server Instance Configuration there is a step where you can install MySQL as a service (win 2k/xp) and also set it to be included in the path system variable. To check open a command prompt (cmd.exe), then at any point in the command line type path and press enter. The system will list a bunch of directories, one of these should be C:\(MySQL Install Location)\bin. For example if you followed Reaper's Installation it would be C:\MySQL\bin. If the path is missing you can re-run the configuration wizard and change the settings to include the Path setting. Hope this helps.
ok, now i have a error when i try to add a GM account with the command...
ERROR 1136 (21S01): Column count doesn't match value count at row 1
pls help
# Mystic
Ah it seems that you were running the Mangos TBC server ... btw if you use new mangos build you'll need to add '1' after the last '0'
# Eagle472
Thank you for helping me :) ... and yes Eagle are correct
in my.ini (typicly in c:\Program Files\mysql\mysql server 5 or c:\windows) and add the following value to the file
# SERVER SECTION
skip_grant_tables = 1
this should allow you to log in to your database, because the grant tables are skipped when mysql is loaded (in services)
also, I *PERSONALLY* recommend the mysql user name be "root" and the password be anything you want, MySQL will work better that way
Ok, I am a complete noob on this, do i need to reinstall WoW and patch it to 1.12.1 or where ever i need to go. I tried from the beginning and im just plain confused. I am new to this. So im begging for pro help. If you get this please help me :) Im not sure where to extract etc, I have TBC installed so im guessing nuke that. and start over.
This is the bit im stuck at:
2. Extract the Complete Database file somewhere in your harddisk, and you’ll see there’re 3 files :
create-database.sql
realm-database-full.sql
mangos-full-for-rev3462.sql
Run it by using this command (this time i make sure to use the default path instead of using command which is already set in environment variable path) from Start Menu => Run => cmd (this cmd can only be used in Windows XP) or command (Win9x) => and change to the extracted directory
C:\MySQL\bin\mysql.exe -u root
# UKmania
Actually even if you have TBC installed you can run TBC server too, but you'll need to get newer version of Mangos and the database itself of course (try visiting their page) because the version posted in this page can only be used on wow classic only (and its my database dump)
cant u make an server and an gm account on that server for me? just send an e-mail to me and i send u the name and pass i would like.
should be fun if u could ;)
denniskerstma@hotmail.com is my e-mail
whenever i try to start the realmd and mangosd things, it says that they don't exist and it also says that make sure the .conf file is in the same folder as the program which it is... ive been working on this for a long time and im stuck at this part ;( pls help
ty
Ok, I've done everything as you've said, but when I open mangosd.exe or realmd.exe from /C:WoW/Mangos They close right after. Are they supposed to do that because whenever I try it it says "Disconected from server."
Wait. I ran through again, and the first Answer on your FAQ "If you tried to run the mysql command directly without setting it to use the env. variable path, you’ll get that error message" Makes no sense. So, explain that and I'm good.
Hey I got everything to work but when I open the mangosd It closes real quick, I took a Quick screen shot of it befor it closed and it had a error message OF (Cant Find map 004313 ( I think it is this Number IM at a Diffrent computer right now) . Also when I open wow I can log in, but when I get to the Realm Selection Every time I try to Enter the realm It keeps bringing me back to the Realm Selection Screen.
The last thing is You say
Yet another Note : Extract the database into the same path where your MySQL bin located, or if you already extracted it somewhere adjust the path like below for example :
C:\MySQL\bin\mysql.exe -u root
# Paladin
Im sorry if only i have good connection then there's no problem for me to create server too :)
# Bryan0226
Are you sure the mangosd.conf and realmd.conf is in the same directory where mangosd.exe and realmd.exe can be found ?
# Tesmai
Actually if you dont set environment variable for mysql, you need to use full path in order to use mysql. Like this for an example :
Mysql not set in env. path :
C:\mysql\bin\mysql.exe -u username -p
Mysql in env. path :
mysql -u username -p
thats it :)
# JeremiahMan
Ah ... if you get that error message that means the maps you've extracted isnt compatible with the current mangos you're using
if you use TBC client you need to get the latest ad.exe from Mangos svn repository to extract maps :)
but if you're not using TBC client then you can use the ad.exe from here (its the old version of ad.exe)
OK, I had the right version of it but I had the mangosd config file set to the wrong path I had it set to C:\Wow\data and I reset it to C:\World of warcraft\data and now I dont get the error message, But the Mangosd.exe opens and closes real quick to. ( I think this is causing me not being able to get to the char select screen) I seen you wright in an earlier post about asking if the config was set up right What should the config for mangosd look like. If you could post it that would be great (For WoW Version 1.12.1)
I've also notice if I dont set up the sql right that the realmd.exe wont open up. the realmd .exe is opening up and staying open for me now But do you know any Idea why the mongosd isnt working? If you can email me Jeremy@alliancelaser.net that would be great.
# JeremiahMan
Hello Jeremiah :)
Try looking at the server.log or maybe you could send the server.log to my email address ? my email address can be found on my about page ;)
so u wanna create a server for me?
Great info! I was just curious as to the server specs you are running it on?
Are there any guidelines on what I would need for a machine to run this server with no more than 10 users on it at a time?
Cheers, chad
Hey Chad Im running it off my pc. My pc is costum built and its running off asus Motherboard
2.8 Pentuim 4 Hyperthread n6600 AGP 8x 256 Mb video card 1 Gig of DDR 400 Kingston Hyperx Ram with a seagate 80 Gig Harddrive. You should be fine if you can play wow. If you want your friends to connect and play with you, youll probly need a fast connection, and a bit more ram than I have. Good luck If you plan on setting up the server
YO ho! Great setup btw but I'm having trouble with my cmd. it always start off at:
C:\Documents and Settings\Xearo>
So no commands work cus it thinks everything's in Documents and Settings.
I've tried using MySQL's command but after i type the pw it accepts it but just sits there and i can't type anything else.
-=+Update+=-
I now have my server running but how do -->I
connect to it?
Sorry for late reply .. because ... well ... forget about it :D
# Paladin
As long as you have the sql, etc you just need to execute the queries and configure it accordingly and you're done :)
# chad
well for 10 people i guess standard machine can handle it without problem (but if its for me, i already has 1GB ram)
for more info you should take a look at Jeremiah post ;)
# Xearo
Edit the realmlist.wtf (in WoW game directory) so it'll connect to your server (put 127.0.0.1 as the server ip)
Hi, this is amazing content, I was wondering if this could be set up on a web host server over the internet where my friends and I could play by logging in from anywhere?
I am not very PC literate and and was wondering if you could please help me out with setting it up for me, I could even pay you $100 for the effort, I know its not much but its what I can afford at the moment.
Please let me know, Thanks.
Thanks :-)
Xearo IF your having trouble with your command just put in>>>>> CD C:\ (where ever you have mysql installed)>>>>> EX: C:\Program files\mysql\mysql 5.0\bin
Or if you have mysql set up to run in command just type in mysql. If your running vista I prefere you do it like this though C:\Program files\mysql\mysql 5.0\bin
ATTN: If you dont want to go through the steps of setting up an account on mangos, on your log in screen then for user name type in Gamemaster
and Gamemaster for your password. Once you create your charcter Type in .gmon and you will become a Gm. Once Gm is turned on you can type .com to see a list of commands you can do.
If you need any help with anything email me Jeremy@alliancelaser.net
I was wonder on how to build a private lan server for wow and i can across your site here and i was wondering if TBC exp would work with this.
Hey. Thanks for the help by the way. But one last thing.
Everytime i try to connect using my info it simply disconnects me. i check the cmd and it says it connected and approved but then disconnect me.
Darkspw TBC will work with a newer version of mangos. Scroll up on the forum it will tell you how to do it.
Xearo - Hmm are both programs open (The mangos Cmd Window, And the Realm CmdWindow. Both need to stay open while you play. If they are open what username and password are you using. Try using gamemaster for the username and gamemaster for the password let me know
!
magnosd and realmd close in 1 sec. thats not good. and when i create and account on sql it give like 4000 errors.
Paladin did you open the 3 sql files with the Sql.exe from your command prompt
If you want to talk on aim my name is weedseednine
Jeremiah i'm using something called BlackStorm V1 (which literally just does the exact same thing just does it automatically) It uses only one cmd. should I just manually do it? If so, the cmd from windows always starts off in
C:\Documents and Settings\Xearo\>
everytime i type commands from above it just says that's not a valid command.
Are you using SDB files from this forum for black storm? If you are I belive they are only designed for Mangos I dont know to much about black storm But, Ill do some research on it.
Oh yea to change the command Type this in the cmd window CD C:\
Is your using Vista Xearo befor opening the cmd Right click on it and run as Administrator
Leaving work now Be back at 7 Am In morning
Now it's saying system cannot find the file specified after i typed in command. prehaps i miss did a step?
MySQL ---> Local Disk C:\
All the files --->My documents
Jeremiah do you have yours setup? is there a way to send it to me or at least screen shot it so i know what it looks like?
email em: xearokk@yahoo.com
ps: i know you're at work respond asap.
Ok, after reading all of this, and messing around with my setup, I have mangos running (i can see it moving the zeps and boats and things of that nature), and realmd starts up fine.
The problem that I'm having is I cannot log in. As ambiguous as that is, all it tells me is that the version i am running cannot be validated. I am using Mangos v3462 and Running WoW BC 2.1.1.
I'm n00bish enough with SQL, but not too n00bish to figure out from reading all the posts and searching thousands of other forums that I need to have at least Mangos v3463 or later to support TBC. I am confident enough that I can figure it out from there, but I cannot find >= v3463 alone. I'd rather not download the unecessary 280mb packages available. I just need a link to where I can d'load the version of Mangos that supports TBC. Please help!
Hey Context That's because your using the wrong version of mangos. That version works for only 1.12.1 WoW Classic version If you want to run TBC 2.1.1 You need to get a diffrent version of mangos , Maps.(ad.exe) and The Sdb files. you can find them here http://www.mangosproject.org
can't one of you just make an server where u let everybody be an GM. that should be much fun :).
if one of u is creating one, plz let me join.
;)
http://www.wowstatus.net/serverlist_c_up.php go here paladin if you want to get on an open server. Pretty self explanotory
i cant create an private server. mangosd and realmd close in 1 sec. cant create account on sql. just nothing what i need works
Do other people have to have thier own copy or can everyone just copy the hacked version to be able to play on a LAN private server
WOW!, the cmd took the command finally. is it supposed to just sit there and move to the next line?
Ex:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql.exe -u root
-=+Update+=-
I know i've asked 1000000 questions bear with me almost done.
where exactly do you put the ad.exe?
Sorry for late reply, because my body hasnt fully recovered because of Vertigo (Dizziness) :(
# Xearo
Put it in your wow game directory and dont forget to create folder / directory called maps first or you'l get an error message
# KoolT4
Actually you dont need hacked / cracked copy, all you need is just set up mangos server, edit the realmlist table ip address to use your lan ip and then configure each client to connect to the ip server used on the realmlist table :)
# paladin112
Paladin if the mangos / realmd process as soon as you started it, try looking at the server.log in your mangos directory
# Jeremiah
Thank you very much for helping me Jeremiah ... i really appreciate it :D
Well i got everything ok. the only thing left is when i type the thing into the cmd
the -u root thing.
it just moves to the next line and the name of the window changes to:
C:\Windows\system32\cmd.exe -mysql.exe -u root
then it goes to the next line down from the -u root command and has an underscore... i cannot type anything at all. only thing i can do is close it. does that mean it worked, if so why was that important?
And as if i didn't add enough to say, should i be correct on the post above everything works but the ad.exe
Debug Error!
Program: C:\Program Files\WoW\ad.exe
THis application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more infomation.
Players can't connect to my server , they keep stuck with 'Connected' , they know what realm i have ... but can't connect...
Also, I cant' make a bloodelf nor a draenei on their account :D please help me m8
hey guys caould i join one of ur servers and be a gm i have tryed to make my own but i just cant do it plz. thanks for reading this message^^
Johnathan, this is either a firewall issue or a player issue when it comes to connecting.
Firewall: Make sure people can cannot TO your computer
Player: They can simply click cancel and try again. It's literally that simple.
As for your Bloodelf and Draenei make sure your server is running Burning Crusade and that their accounts are set for TBC.
Ryan, to answer your question, most people will not create servers that are up and trying to gain population here (from my knowledge, neither Jeremiah nor ReaperX have a full-time-server but i could be wrong and plus: GM status is usually only given to people the main GM knows they can trust 100%
where do i get wow version client 1.12.1 ??? plzzz, plzzz help !!! i downloaded all what i need to make an server but i still need wow 1.12.1!!! anyone help me, huh ?
I cannot get this to work at all. I'm stuck at the step where you tell it to:
C:\MySQL\bin\mysql.exe -u root
PLS HELP ME !!! How to create acount normal from mangosd.exe ???
I treid to open it but it clouses . Tell me how to create a acount PLS ???
I tink I didnt make step 5 corect . I opened the file with notepad and copy DataDir = “C:/WoW/Data” below . I dad corect ??? PLS help me were I goed rong !!! email me : big_bos_@abv.bg
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
DataDir = “C:/WoW/Data”
If you’re using the example path given in this guide, you can use the above datadir configuration
I am waiting :P HELP my realm exe works and the surver works fine PLS help I cant play :(
And oter thing pls more simple I am a BIG NOOB at making servers :)
10x in advance
U made step 2 to add data base and now my realmd. exe closes :( PLS HELP SOON HELP
it was working :( email me or anser me PLS : big_bos_@abv.bg
Hello. when we talk about mySQL means SQL Server 2005 Standard Edition - 32-bit?
im sorry about this question, is just that im not familiar with this
Hey Tyler If your stuck on that step it actully should look like this
C:\MySQL\bin\mysql.exe -u root
hmm my post didnt go all the way should look like
C:\mysql\bin\mysql.exe -u root
C:\mysql\bin\mysql.exe -u root
Hmm for some reason when I put the
Tyler What is your email address, for some reason it wont let me type what I want to say in here.
I tink I didnt make step 5 corect . I opened the file with notepad and copy DataDir = “C:/WoW/Data” below . I dad corect ??? PLS help me were I goed rong !!! email me : big_bos_@abv.bg
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
U made step 2 to add data base and now my realmd. exe closes :( PLS HELP SOON HELP
it was working :( email me or anser me PLS : big_bos_@abv.bg
DataDir = “C:/WoW/Data”
If you’re using the example path given in this guide, you can use the above datadir configuration
I am waiting :P HELP my realm exe works and the surver works fine PLS help I cant play :(
And oter thing pls more simple I am a BIG NOOB at making servers :)
10x in advance
reaper-x: cant u make an server and make all of the nooby's (including me) gm.;)
Ok, I'm really stuck, been trying to do this now for over 3 hours, how do I do this MySQL thing!?!?! I have all the SQL files etc in the correct place, could someone please just tell me EXACTLY what I have to type...?
Smithy whats your email Ill send you Screen shots
So does anyone have a server im able to actually play on up and running? if so i-m me or email
litefrombelow@aim.com
http://www.wowstatus.net/serverlist_c_up.php Go here Tumadre there are plenty of playable servers
Ok, I downloaded everything fine, i installed MySQL to the directory: C:\MySQL but now i'm stuck and so confused!
When i typed in what it said to in cmd box, it says it cant find the file specified, i checked that everything was typed in correctly and that the directory i was typing was right, and they both were, if anyone can help me fix or get around this problem plz let me know.
Thanks.
If you have spaces in your Directory (ex: C:\Program Files\) Make sure you put the spaces. Also Make sure after you type the -root Put In C:/(where ever you extracted the Realm-database.sql) I recommend you put it in your sql\Bin Directory on your hard drive.
Firstly, thanks a lot JeramiahMan coz that problem is now solved, but now, guess what, there is another, it now says: "ERROR 2003 : Can't connect to MySQL server on 'localhost' "
Hey JeremiahMan, sorry I forgot to look back on here... My Email address is smith257@hotmail.co.uk (I have MSN Messenger as well).
2007-06-13 00:01:04 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-06-13 00:01:04 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-06-13 00:01:04 Realm running as realm ID 1
2007-06-13 00:01:04 Using DataDir C:\Program Files\World of Warcraft\Data\
2007-06-13 00:01:04 Initialize data stores...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Loaded 32 data stores
2007-06-13 00:01:05
2007-06-13 00:01:05 Using Autodetected DBC Locale (0).
2007-06-13 00:01:05 Cleaning up instances...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Initialized 0 instances, deleted 0 old instances
2007-06-13 00:01:05 Packing instances...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Instance numbers remapped, next instance id is 1
2007-06-13 00:01:05 Loading Game Object Templates...
2007-06-13 00:01:05 ERROR:`gameobject_template` table is empty!
2007-06-13 00:01:05 >> Loaded 0 game object templates
2007-06-13 00:01:05
2007-06-13 00:01:05 Loading Spell Chain Data...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Loaded 1329 spell chain records
2007-06-13 00:01:05 Loading Spell Learn Skills...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Loaded 40 spell learn skills + found in DBC 76
2007-06-13 00:01:05 Loading Spell Learn Spells...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Loaded 36 spell learn spells + found in DBC 6011
2007-06-13 00:01:05 Loading Spell Proc Event conditions...
2007-06-13 00:01:05 >> Loaded 819 spell proc event conditions
2007-06-13 00:01:05
2007-06-13 00:01:05 Loading Aggro Spells Definitions...
2007-06-13 00:01:05 >> Loaded 53 aggro generating spells
2007-06-13 00:01:05
2007-06-13 00:01:05 Loading NPC Texts...
2007-06-13 00:01:05
2007-06-13 00:01:05 >> Loaded 0 npc texts
2007-06-13 00:01:05 Loading Items...
2007-06-13 00:01:05 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 134 fields in sql).
I seem to get many errors, especially with item_template.. I am running version 2.0.12 TBC. Anyone know the solution to this? I also have 0.6.4 SDB and the latest version of Mangos. Thanks in advanced.
Errm i have Error 1044 when trying to connect to make a gm file. it says: ERROR 1044 : Access denied for user ' '@'localhost' to database 'realmd'
Ok, let me apologize in advance if I fail to clarify my problem.
I am currently having the following problems:
1. I attempted to run MangosD.exe; it started and closed in roughly 1 second. I went through all of these posts (on this and the old topic) and the repeated response is "check your log", so I did. The only error reads
ERROR:Check existing of map file '“C:/WoW/Data”/maps/0004331.map': not exist!
So, naturally, I went to my directory and checked it out. The file does indeed exist. I'm looking right at it.
2. This is most likely directly related to problem (1), but, when I attempt to run WoW (I put a seperate installation of classic WoW to test the self-server waters and see if this way my kinda thing or not) it gets an error (even if i use the gamemaster username/password) that reads something along the lines of:
"Unable to validate game version. This may be caused by file corruption or the interference of another program" (and then gives the wow error web address)
So once again, I searched these posts. The common solution listed here is that it is related to TBC patch, but the version I am running for this server experiment is the 1.12 one (busted out the discs and the old patches and everything.) and not TBC at all.
-Is this error because I have 2 folders of WoW, one pure and with TBC for use on the WoW servers, and this classic one for use for this one; or is this error because of problem #1, the suddenly shutting down mangosd.exe that for some unknown reason can't find the map file that actually is there??
3. I cannot make a GM account in Mysql if my life depended on it. I'm simply not grasping the problem, when I type the insert into 'account' line and then the values data it, instead of processing it, starts a new line that begins in
">
Though after reading more of this post it doesn't seem to be that big a deal as long as I use the Gamemaster/Gamemaster thing that comes with Mangos (should I be graced enough to get it to work x_x)
Sorry for the long post, I await your response, it's not the end of the world if you can't respond soon (but I must admit these errors are ticking me off some)
-Gumdropps-
Yay, made my server, problem is I cant connect :S, when i type in info, it says Users: 0 (Max: 0) I am assuming this is why I cant connect... help please
Hey gum drops I had the same problem when I was setting up the server. The way I corrected this was Uninstalling EVERYTHING! THE MYSQL, MANGOS DELETING THE MAPS ETC. Get ride of all the files. Some times you might have dupilicate files and for some reason it messes up everything. After you get ride of everthing.................By of course uninstalling then going through Directory's and deleting the files that were left behind. Then Just redo everything and you should be good!
Little Stu try uninstalling Mysql.... Do this by going to Start menu Mysql Mysql Server instance config and stop the instance running. After that Go to My computer Control panel Uninstall/addprograms and uninstall it from their. After that go to Mycomputer C Drive and where ever you installed mysql and delete what ever it left behind after it was uninstalled. After Deleting it then you should just reinstall it. I had to do it about 3 times to get it to work right. Are you using Windows Vista?
Hey Mike make sure you extract the DBC files in the right order
So If I restart my PC (normal startup), what programs do I need to start to host a server? Clicking on Mangosd.exe and realmd.exe? When I do that, Mangosd opens, runs stuff, then disappears really quickly, but no errors. Realmd opens and stays, the text says:
Database: 127.0.0.1;3306;mangos;mangos;realmd
Added Realm "ReaperX".
realmd process priority class set to HIGH
Is there anything else I need to run?
I need to set my server to accept players off of my network, what do I do to allow them?
Finally, I didn't understand you instructions on how to create GM accounts and player accounts, can you spell it out to a newb like me?
Thanks so much
I have the same problem :(
Then I delete all and started all over and it got worse :(
# Tjikijiki
The most important program is of course the mysql because mangos will not work without it :)
as for creating GM account you just need to do the same step like importing the mysql with the exception this time you're going to run different command
# BigBoss
What problem ? mangos process close itself ?
mangos process close itself automatically = incorrect configuration / database
how to fix it ???????
Hi Reaper,
Im trying for to days now to start a wow server. when I run MangosD.exe i get the following error:
Loading Items...
Error in `item_template` table, probably sql file format was updated (there shou
ld be 134 fields in sql).
Firts i was running version 1.12.0 on mij server now i updated it tot 1.12.1 but it still gives me this error. Hopefully you can help me.
Thnx Brutus
Hi Reaper-X,
I opened the database with SQLyog when i count the collums in Item_template i have only 122 items in it. Mangosd.exe asks more rules.
Greetz Brutus
hello
I was just wondering which mysql do u download my friend?
when i log in i get the error:
Unable to validate game version. This may be caused by file corruption or the interference of another program. Please visit http://www.blizzard.com/support/wow/ for more information and possible solutions to this issue.
# BIGBOS
open the server.log in your mangos directory and look for the error message as for the rest you just need to adjust everything based from that error message ;)
common error message :
Q : map not found / anything related to map
A : extract map from your wow installation using ad.exe
Q : Mysql related error
A : adjust your mysql username (this is the most common problem i've seen from various email i get) or adjust the database and username accordignly
# Brutus
Which SDB you're using ? it seems you're not using compatible SDB / WoW Database version designed for the mangos version / revision you're running
# Gregory
MySQL 5.x Community edition should do the job ;)
# underdeath
Depending on your wow version and mangos revision that error message could means :
- You're setting up WoW TBC server using and try to connect to the TBC server using WoW Classic .. and you'll get that error message
- Another program / you modified WoW data (if you didnt edit anything then you dont need to worry about this)
I have seen the question asked, but never an answer given, where can we get the 1.12.1 client? I have a copy of the game somewhere, but is there somewhere we can download that version of the client?
2007-06-12 19:59:59 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-06-12 19:59:59 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-12 19:59:59 Realm running as realm ID 1
2007-06-12 19:59:59 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
2007-06-12 19:59:59 ERROR:SQL ERROR: Table 'realmd.account' doesn't exist
2007-06-12 19:59:59 Using DataDir @MANGOSD_DATA@/
2007-06-12 19:59:59 ERROR:Check existing of map file '@MANGOSD_DATA@/maps/0004331.map': not exist!
2007-06-12 19:59:59 ERROR:Correct *.map files not found in path '@MANGOSD_DATA@/maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
These are my maps folder is on place
and how to adjust my mySQl ???
and how to adjust my mySQl ???
sory for the boder :(
sory for the boder but how to adjust my mySQL ??? :(
batch proudly presented by
▄▄▄▄ ▄▄▄▄▄▄▄███████
█▓▓▓▐ ▄▄▄▄▄▄█▓▓▓▓▓▓█▓▓▓▓▓▓█
█▓▓▓▐ █▓▓▓▓▓▓▐▓▓ ▓▓█▓▓▓▓▓▓▓█
█▓▓▓▐ █▓▓▄▄▓▓▐▓▓▓▓▓▓█▓▓ ▓▓█
█▓▓▓▐ █▓▐ ▌▓▐▓▓▄▓▓█▐▓▓ ▓▓█
█▓▓▓▐ █▓▐ ▌▓▐▓▓▌▌▓▓█▓▓ ▓▓▓█
█▓▓▓▐▄▄▄▄█▓▓▀▀▓▓▐▓▓▌▌▓▓█▓▓▓▓▓▓▓█
█▓▓▓▓▓▓▓▓▓█▓▓▓▓▓▐▓▓▌▌▓▓█▓▓▓▓▓▓▐
█▓▓▓▓▓▓▓▓▓█▀▀▀▀▀█▓▓▌▌▓▓█▄▄▄▄▄▄▀
▀▀▀▀▀▀▀▀▀ ▀▀ ▀▀▀
█▀▀▀▀▀▀▀▀▀▄▄▄▄▄▄▄ ▄▄ ▄▄▄
█░░░░░░░░░█░░░░░░░█░░█ █░░▐
█░░░░░░░░░█░░ ▐░░█░░░█░░░▐
███░░░▐███░░ ▐░░█░░░░░░░▐
█░░░▐ █░░ ▐░░█░░███░░▐
█░░░▐ █░░░░░░░█░░█ █░░▐
█░░░▐ ███████ ███ █░░▐
█░░░▐ █░░▐
████ █░░█
▄ ▄▄░░▐
─────────────── ▐░▄▄▄░░▀▀▀
[LorD TOm] ▐░░░▀▀
─────────────── ▀▀▀
070617 21:20:11 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
Press any key to continue . . .
What do i do i cant figure it out...much help appreciated....
# Blasphemy
ahahaha .. im sorry if i didnt answer, im sure i miss that question :)
to get 1.12.1 client (i assume you've installed the previous update) ... you just need to search it using google here's an example :
http://www.google.com/search?q=1.12.1+client
it'll give you the result (btw it seems that 1.12.1 client words are famous since i dont use any other keywords after it) :P
# BIGBOS
There are two errors from that log
1. realmd.account doesn’t exist
Solution : reimport the sql files (to make thing easier, reimport all the sql files)
2. @MANGOSD_DATA@/maps/0004331.map
Solution : you didnt change the datadir in the mangosd.conf, you need to change it and adjust it to your data path
# Divinity
That error message means you dont have InnoDB configured on your mysql installation, try reconfigure mysql
if you use the mysql server instance config wizard enable the transaction database :)
note: mysql server instance wizard automatically installed when you install mysql 5, if it doesnt exist try downloading the 40++ MB (full mysql) instead of the small version
I set data dir this way ( DataDir=C:\wow\data )
and I reimported the sql files : C:\MySQL\bin\mysql.exe -u root 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
2007-06-18 15:52:35 ERROR:SQL ERROR: Table 'realmd.account' doesn't exist
2007-06-18 15:52:35 Using DataDir @MANGOSD_DATA@/
2007-06-18 15:52:35 ERROR:Check existing of map file '@MANGOSD_DATA@/maps/0004331.map': not exist!
2007-06-18 15:52:35 ERROR:Correct *.map files not found in path '@MANGOSD_DATA@/maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
:( :( :( :( :( :( :( :(
I set data dir this way ( DataDir=C:\wow\data ) and I reimported the sql files :
C:\MySQL\bin\mysql.exe -u root
2007-06-18 15:48:32 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-06-18 15:48:32 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-18 15:48:32 Realm running as realm ID 1
2007-06-18 15:48:32 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
2007-06-18 15:48:32 ERROR:SQL ERROR: Table 'realmd.account' doesn't exist
2007-06-18 15:48:32 Using DataDir @MANGOSD_DATA@/
2007-06-18 15:48:32 ERROR:Check existing of map file '@MANGOSD_DATA@/maps/0004331.map': not exist!
2007-06-18 15:48:32 ERROR:Correct *.map files not found in path '@MANGOSD_DATA@/maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
2007-06-18 15:59:47 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-18 15:59:48 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-06-18 15:59:48 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2007-06-18 15:59:48 ERROR:No valid realms specified.
HEY BIG BOIS Using DataDir @MANGOSD_DATA@/ That means you need to open up mangosd.conf and edit that to where ever your WoW Data folder is ex: C:\World of warcraft\data
Probably when you re imported the files it might have changed something
nop I checked Datadir is corect
When I Try to Extract MySQL there is an Error i think i download a Wrong one. Can you send me a Link to MySQL Windows XP Setup ?
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-noinstall-5.0.41-win32.zip/from/http://mysql.online.bg/
enjoy ;)
Hey reaper. I got the server up and running for 2.1.1 =) But now i can't figure out how to make more accounts for other to play -_-
Reaper HELP !!! :)
First of all i'd like to say many thanks to jeremiah for helping me :)
and sorry i cant reply yesterday because of blackout and lots of thunder near where i live :(
# BIGBOS (comment 198)
that error message means :
you didnt import the realmd database into your sql, or if you're using different database name for the realmd, try adjusting the database name from the mangosd.conf
and thats why it says the mangosd process cant find realmd database
# Xearo
if you intend to create public server or want to make registration page so your friends can register to your wow server, you need to install PHP with Apache
and then to make thing simpler, you can download simple registration page for mangos (i think there's a good one at mangos website, although i havent tested it)
OKS I WILL TRAY :)
LOOK REAPER I AM A IDIOT :p I DONT UNDERSTAND WATH TO DO !!!
WATH MEANS ( IMPORT ) ??? AND HOW TO (adjusting the database name from the mangosd.conf) ??? CAN YOU EXPLANE PLS
:d :D :d ;d
BigBos Try uninstalling Mysql and getting ride of The Db files and mangos ( START FROM SCRATCH) you should have some luck doing that.
oks will try
I maked the server again , see the erors
2007-06-21 16:50:11 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-06-21 16:50:11 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-21 16:50:11 Realm running as realm ID 1
2007-06-21 16:50:11 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
2007-06-21 16:50:11 ERROR:SQL ERROR: Table 'realmd.account' doesn't exist
2007-06-21 16:50:11 Using DataDir @MANGOSD_DATA@/
2007-06-21 16:50:11 ERROR:Check existing of map file '@MANGOSD_DATA@/maps/0004331.map': not exist!
2007-06-21 16:50:11 ERROR:Correct *.map files not found in path '@MANGOSD_DATA@/maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
Hmmm... To better help you out ,Send me a screen shot (Right click on my computer go to explore, Then go to where ever Mangosd.conf is and then open it up and send me a screen shot of the whole screen Jeremy@alliancelaser.net
also Take a few srcreen shots of you typing in mysql commands inside the cmd line
btw for all that want/need it. i have an updated database for 2.1.1 very few bugs but there're still some. :\
email:
xearokk@yahoo.com
Yo, im having the same prob as paladin way up their ^. my application files do also close after about 2 seconds and i just wondered wot id done wrong?
hi all n esp reaper X
the guide has been of real gud help for me,i tend to do all the steps told by the guide bt i end in nt able to loggin, the error unable to validate the game, the thing here is i hav been tryin to create a server usin uwc 134 bt didnt succeed with it,
did a search n found this guide,
i did evrythng as it says,
i'm usin sdb 062 full n fix n sdb set from 141-156
bt the version of the game is 1.9.2 n i did a hack patch of 1.9.2 also so tat i cud try usin uwc 134 version,
i'm tryin to use the game in lan,
i hav a wifi router n if there is a different settin for wifi cud u pls mail me or explain it in here,
by the way this is my 1st time creatin server or any kinda database,if this helps i', usin windows vista ultimate
thnks in advance
JeremiahMan I send you screen shots check your email . :)
It keeps saying "ACCESS DENIED" when I am entering the correct password and commands
Johnson Reinstall Mysql, and dont use a password when you set it up Make sure you delete the folder of mysql after you uninstall it, before you reinstall It.
Comment by ibbeywoox
You need to make sure your using all the files from here, Also make sure you have game version 1.12.1 It will not work if you dont have the right game version. Also you might want to uninstall Mysql and start from scratch before redoing.
Josh Mash Make sure on your mangosd.conf you put the right directory
DataDir = "@MANGOSD_DATA@" Put where ever your Wow data dir is for example C:\world of warcraft\data And dont put the " " it will put them in for you when you reopen the mangosd.conf
thnx JeremiahMan
i hav updated game to 1.12.1 nw n tried to logging with created user name n password
i was able to pass from there successfully, after tat i gt to select realm n type of play i did tat too pass from there too
next comes to connect to server bt from there i cannot connect,
i chnged realmlist 127.0.0.1 to my lan ip still no hope, this hapend wen creatin server usin uwc 134 also,after doin evrythng correctly and at last joinin server does nt work, i dont knw wats wrong any help regardin this wud b really gud
thnx in advance
See the screen shot with the datadir its corect ??? :|
HELP my surver is done i cant create a acount wen i type in mangosd.exe they are ssome zepplin test and boots that keep coming back
and wen this types new line ???????
and also realmd.exe is clousing how to fix ???
HELP I CREATED A ACOUNT BUT CANT START THE SERVER REALMS CLOUSES HELP
2007-06-24 19:49:53 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-24 19:49:53 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-06-24 19:49:53 ERROR:query ERROR: Table ‘realmd.realmlist’ doesn’t exist
2007-06-24 19:49:53 ERROR:No valid realms specified.
OPs i didnt create a acount it say thath mysql is at difrent version or somnting help !!!
# Bigbos
as i said before you didnt import the realmd sql, you need to import that file first or you wont be able to run the realmd process successfuly ;)
btw which database version you're using and where did you get it ? i ask this because lots of people asking me via email that they're using wow mangos downloaded from torrent and not downloaded it from mangos website or sdb website
as a note, mangos release already included the realmd sql that need to be imported although you'll need the SDB for a fully working mangos server
that's it ;)
C:\MySQL\bin\mysql.exe -u root
this means import raght ??? I import first CREATE DATABASE - secound REALMD DATABASE - third MANGOS DATA BASE Is this corect
and for 3 and 2 there is D-mangosd or some thing
I HAVE 3 FAILS CompleteSDB156-Mangos3462.rar
2007-06-25 18:47:33 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-06-25 18:47:33 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
2007-06-25 18:47:33 ERROR:query ERROR: Table 'realmd.realmlist' doesn't exist
2007-06-25 18:47:33 ERROR:No valid realms specified.
hi man.... i was wondering do u have msn?
hey, yea i saw you know alot about private servers lol, i hope u can help me for a little bit.
I made my own private server now, but it has many bugs.
I am wondering how do i fix things like, profession trainers not being able to train you or class trainers and things like that. Plus over that bug It wont even tell me how much money i have when I click on my backpack :( I have also seen many people put custom vendors and and so on.... Hope its possible to communicate with me somehow on this matter.
Btw sorry i am such a noob at this and stuff like that. I hope you can help me though.
HELP :( !!!
and some body know a TBC guide ??? link or some thing
# Bigbos
Im in progress of creating new guide but this time with screenshot of all progress :)
as for TBC ... basically the setup process is still the same as creating non TBC (setting up mysql, etc), with the only differences :
1. You need to get Mangos revision above 3462
2. You need to get SDB (Database) above 0.6.2
that's it ;)
# maker103
Well .. if you're running tbc server (mangos), try downloading their newest release with the latest SDB
ow ok i c yea V2.7? rite. Thankyou. Appreciate the help ;)
Yea now that i know what version, I have been trying to find a link somewhere to show me where to download it, anyone know one?
PLZ SET ALL OF THIS FOR DOWNLOAD
Oks but wath to do with realmd.exe .
Reaper-X I you can send me screen shots wath i need to do PLS email : big_bos_@abv.bg
Hello
Well ... first of all if you use sdb from this site for TBC server it wont work because you'll need recent version of mangos TBC server
but that error message got nothing to do with mangos itself even for the recent version because the realmd database wasnt successfuly imported
to correct this you need to use this command (from command prompt) :
mysql -u root -p -v -D realmd < realm-database-full.sql
to import the realmd sql file into Realmd database
Hi
Ive read about PepsiG's sullotion to how to stop the loop in the login phase, but it just dont seem to work for me?
anything else i can to to make it stop?
Woodrick
ok, so anyone know where i can install the newest version of mangos?
uhm i have a private wow server and the npcs wont teach me how to wear mail is there n e way to get a round it if so u can email me at sin623@gmail.com
im plain out retarded or something, cause i do not get this at all...step 2 i have no idea what to type in cmd i try C:\MySQL\bin\mysql.exe -u root
didnt do full comment so can u email me or something...... cause i really just want to host a lan server with my friends when we lan party. Furco3@yahoo.com
# Everyone
I just finished creating the new guide (two part already finished) and this time with images (based on request) on almost every step and you can find it from :
- First part about mysql installation
- and the second part about configuring mangos itself
HI I made the server !!! :D I got and idea to use SQLyog and it works like a charm . If some one is having troble importing realmd.sql use SQLyog . Thanks alot gays for your help and specialy Reper-X and JeremiahMan TNX gays !
and some can some body tell me the teleport comands ( go origmar strongwindcity ) or were to see the coordinates ???
and one more thing were is GM Island ??? bye :D
Is it possible to set up a private WoW server on a apple computer? This is all orientated towards PC. Any thoughts?
........2007-06-29 21:55:26
2007-06-29 21:55:26 >> Loaded 0 quest trigger points
2007-06-29 21:55:26 Loading Items...
2007-06-29 21:55:39 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 133 fields in sql).
im getting this error... what should i do? i re-executed the database.sql file but it crashes again.... what should i do ? :\ [maybe get another mangos?:D]
# Geoff
Since i never use a Mac before i dont know if Mac is supported by mangos or not
but if you have Virtual Machines software installed on your mac, perhaps you can run the mangos under the virtual machines (you can choose between Win XP or various Linux distro) ;)
# Moko
Ah .. that error message appear because you're not using compatible database (for example you use the old mangos revision and using the recent database)
try getting newer mangos revision also make sure it is compatible :)
There is some good tutorials and world of warcraft stuff on this site.
http://www.ironhorse-gaming.com
can you email me at Nolgan@excite.com and we can talk this over cause im stuck at mostly all the parts except for like 1...lol
Nolgan have you tried reading my new guide ? (which is using lots of images) because some people requested for it ;)
ok, ive done what you said up and got up to configuring Mysql when i get to the execute step, it when trying to start it, it says "The service could not be started. Error:0"
if you have AiM you can message me my SN is patdchad it would make it alot easier for me... thanks in advance.
Well I got everything working, but I didn't use Mangos, I was wondering how do you add a realm?
i did everthing and used import batch file on navicat sql it only loads 162 items then the timer just keeps going am i doing something wrong tried 6.2 full and hot fix it loads without error them when i run mangosd it starts to load with alot of errors
Reaper my server is runing and I am plying but wen my friends try to connect they cant connect to the realm ??? How to fix ? :D
Reaper-X i need very help because im very confused with this :S. if you could give me your email i would be very greatfull... i need your help plz help me. Ive got MSN if you dont mind add: J-Sousa_@hotmail.com (sorry my nobbish xP)
plz play
wow sites are fun
Reaper-x your tutorial is awesome! Ive got just about everything up and running. I start realmd and it starts fine. I start mangosd and it starts and i see the ships and what not changing locations. This tells me the server is active. However when I try to log in with WoW it says invalid username and password everytime.. I have accounts in realmd/accounts.
When i open the realmd window i see this "SQL: SELECT 'I','id','locked','last_ip','online' FROM 'account' WHERE 'username' = 'OPEN'
query ERROR: Unknown cloumn 'I' in 'field list'
any help would be great! Thanks
Ok for those of you who got my last post and have the same error import the 3939_realmd_account.sql from /sql/updates and it will solve the problem.. I have not yet fixed the disconnect.. hope this helps
# Dustin
Thank you very much for your kind words :)
as for the realmd, try creating user account from the mangosd window (for example create test test)
and try login to your server. If you get the same message try reimporting the realmd sql only
Sweet ! Im up an running!Just need o confiure for lan and wan adn we are in business! Thanks reaper-x!
Reaper, i think this was already asked but whenever we tried logging in to the server, its giving us an error saying "Cannot verify your game version" or something like that. I'm not sure what version my friend is running though for WOW but I hope you can shed some light on this. Thanks
djcoke
The error that your getting is that you are not on the right version of wow. You need to be on a version that is tied to your DBC files and your maps. And even vmaps if your using them.
~Melvinchi
yeah! thanks Melvinchi! I actually found that out just after posting... 'ma friend told me that he is using an old patch... Unfortunately, the MPQE file is not working with his pc for some reason... I gave him a copy of the patch required and we got it going! Thanks again!
Hey, thanks for the great guide, but i seem to have troubles logging in. when i log in my GM account it says: Unable to Connect.
I read that, that means my WoW installation was wrong. does that mean i just have to reinstall it?
Thanks
WoWFreak
WoWFreak
Is your realmlist set up right on your client(you)? It can be found in your root directory of WoW. it's name is realmlist.wtf
it should look like this
set realmlist
Another thing to check is in the database "realmd" you want to look for a table called realmlist. In here you will see a field named "address" make sure that is set to your WAN(Wide Area Network) ip. If your unsure of your ip go to http://www.google.com and type in
my ip click the first link towards the top and you should now have your ip.
Last thing I can think of is if your router is set up correctly. You want to forward port
8085 to the local ip address of your server ex. 192.168.25.154
And thats about it. Just make sure that you have realmd and mangos running at the same time and that you have all the information set up right. And if your running the servers on the same computer that your trying to play on you can't use localhost or 127.0.0.1 you HAVE to use your WAN ip.
Hope this helps...Cheers
~Melvinchi
*Sorry the last post got striped it should be
set realmlist your ip
~Melvinchi
hi. im having trouble with the maps like most people. I keep getting the inompat. version error and as soon as i try to log on it says "Disconnected from server". please help, can you PLEASE upload the maps!
now i get unable to validate game version
after picking a realm i always get sent out!
it seems like i got it to work. THANK YOU SO MUCH!
HELP!!! i cant type or see anything chat wise i can do commands but when i type .commands nothing shows up also i cant even say anthing
Fey
You can't move talk or see anything?...
The only thing I can think of is that your scripts got messed up some way. Try this
Download another revision from http://mangos-files.de what you want to do with this is extract it to a place you can find it. Then look in the root directory for a file called MaNGOSScript.dll copy that file and replace it with the one that your using.
Side note: mangos must not be running when you do this, I was looking at the code on a few revisions and if you use .loadscripts it will create a memory heap. Not 100% sure on that so don't quote me but thats just what I've seen.
~Melvinchi
i need help where do i put everything since i put all my files here E:\Downloads wt do i type?
when i type this in C:\Program Files\MySQL Server 5.0\bin\mysql.exe -C:\Documents and Settings\Ben\My Documents\CompleteSDB156-Mangos3462
it keeps saying ' C:\Program' is not a recognized as an internal or external command, operable program or batch file wt should i do??
Ben
ok for one its not "C:\Program Files\MySQL Server 5.0\bin\mysql.exe"
its C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe
Well thats default.
But I'm not really sure what your trying to do could you give me a little more?
well i try and type it in the cmd thing and it just keeps saying 'C:\Program' is not a recognized as an internal or external command, operable program or batch file
Hello Reaper-x
I really appreciate your work for the community!
And i have some questions for you please :
I wonder if i can play and host a private server on my own PC, just for 4 players (my bro and my two sisters).
Pc config:
Pentium 2.6 ghz
2gb ram
Radeon 9800
Lan : 100mb
Is it possible? or not enough powerful ?
Thanks in advance!
Wowa Weewa that worked great plus with all the errors others had that you addressed it went flawlessly! Thanks!!!!!
everything went pretty smooth for me up until I had to run realmmd.exe and mangosd.exe. I saw Q & A from PepsiG in other BLOG and loaded SQLyog...when I expand realmd, there is no realmlist under it...looks like something did not create correctly...what next?
First Of all, Amazing Tutorial, You Rock!
Second of all ,=], the mobs on my mangos do not drop money =[...
I Already tried to change the money drop on mangosd.conf to 2,10,30,50,100... But There is neither a coin Drop...
I'm Using exactly the files you linked for download, Classic 1.12.1.
If u know what is the problem please help me!
Tnx Brow!
Ben
Sorry for the late replay.
I'm still not 100% sure what your trying to do. But my guess is that you are trying to run mysql
try this
cd C:\Program Files\MySQL\MySQL Server 5.0\bin
then type: mysql --user= --password=
so it could look like this
mysql --user=root --password=123
~Melvinchi
Ahhhh... Post striped again... you think i would learn =\
thats - -user=bla - -password=bla
so thats two minuses but make sure there put together. :)
~Melvinchi
k reaper thanx for helping out alot too. but when i install mysql and try to configure itm it says
error Nr. 1045 acess denied for using password (yes or something like that is it possible to please help? or tell me how to do it step by step with this error?
It would be greatly appriciated
I have been tryign to fix it for just too long, if you can't help well then i guess I should forget my own private server and so on. along with being a gm.
Well hope u respon soon bye
Maker103
Follow my last post. that should help you fix your problem
~Melvinchi
Hey I think I followed your guide a while back and every thing worked in the first try. I am a Software Developer so I already had experience with mysql server and php so it was a quick install. I was also able to figure out the IP change within the database so other computers within the lan could log in to my server. The only problem I have now is mylauncher update WOW to the latest patch and I can't seem to connect to TBC Server any more. Is there any thing I can update to fix that?
thanks
faisal, sorry i am new at this but i think to update the verion of WoW you have, change the relmlist to the original WoW relmlist (there is none) and log in with ur normal account so it can update and just keep doing it untill there r no more updates left, then you can go and change the relmlist and then it should work ;)
If u ever need a Trustworthy GM
I have been a GM in many other servers and will be glad to help out for a little bit if u need it.
Note I am not Good with Mysql and stuff like that though.
Well yea hope I could help ur server for a while.
Thankyou. ;)
melvinchi
ok yea i am a really bad mysql and follow directions person, so thanx for trying to help but i am still stuck,
thanks though
I will now officially quit making a wow private server for myself.
If anyone wants a GM, that i can do, I have been a GM in many servers. I would love to help some ofu out ;)
on my last post (I would love to help some of you out)
I was typing incorrectly
hello i'm having trouble with step 2. when i type # C:\MySQL\bin\mysql.exe -u root
WTF my last post didnt fully show?!? my msn is nayr1991@gmail.com could someone give me a hand please.
Hi Reaper, I've been waiting over a month now for your respone, so I'm assuming you missed my huge post. I followed Jeremiah's advice and I am having the same problems, so here it is reposted:
Ok, let me apologize in advance if I fail to clarify my problem.
I am currently having the following problems:
1. I attempted to run MangosD.exe; it started and closed in roughly 1 second. I went through all of these posts (on this and the old topic) and the repeated response is “check your log”, so I did. The only error reads
ERROR:Check existing of map file ‘“C:/WoW/Data”/maps/0004331.map’: not exist!
So, naturally, I went to my directory and checked it out. The file does indeed exist. I’m looking right at it.
2. This is most likely directly related to problem (1), but, when I attempt to run WoW (I put a seperate installation of classic WoW to test the self-server waters and see if this way my kinda thing or not) it gets an error (even if i use the gamemaster username/password) that reads something along the lines of:
“Unable to validate game version. This may be caused by file corruption or the interference of another program” (and then gives the wow error web address)
So once again, I searched these posts. The common solution listed here is that it is related to TBC patch, but the version I am running for this server experiment is the 1.12 one (busted out the discs and the old patches and everything.) and not TBC at all.
-Is this error because I have 2 folders of WoW, one pure and with TBC for use on the WoW servers, and this classic one for use for this one; or is this error because of problem #1, the suddenly shutting down mangosd.exe that for some unknown reason can’t find the map file that actually is there??
3. I cannot make a GM account in Mysql if my life depended on it. I’m simply not grasping the problem, when I type the insert into ‘account’ line and then the values data it, instead of processing it, starts a new line that begins in
“>
Though after reading more of this post it doesn’t seem to be that big a deal as long as I use the Gamemaster/Gamemaster thing that comes with Mangos (should I be graced enough to get it to work x_x)
Sorry for the long post, I await your response, it’s not the end of the world if you can’t respond soon (but I must admit these errors are ticking me off some)
-Gumdropps-
gumdrops, ill see if i cant help you, your mangos problem is probally in your map files -ie- they are outdated for the version of mangos your running, try getting a new version of mangos with an ad.exe with it and getting new maps. or its in your sdb giving incorrect values.
2. your "unable to validate game version" is due to you mangos and wow client not being matching versions, i know for a fact sdb 4096 and mangos revision 4096 work for 2.1.2., and yes your 2 versions of wow (not sure how you did that my computer stoped me everytime) is probally causing some problem,
3. for you gm account, get mangos working, then allyou have to do is "create charname password" to make a new logon then "setgm charname 3" use 3-6 for diff gm levels
little hint check mangos-file.de for the 4096 revision and "e-turray.com/file/mangos/sdb/?dir=" for the sdb
hope that helps
also, gumdrops make sure that your map folder doesnot have an extra folder in it ie "C:\wow\data\maps\maps\*.map...i only say this because it happend to me the first time i had a maps folder in my maps folder
maker103, my server is not on the public internet yet but once I get my new dsl. you are more than welcome to be the GM on there.
After the latest patch. I can't connect to the server. It says the versions are not correct. Well the error doesn't say that but it's pretty much means that my client has a different version than what's expected by the server. Is there are way to update/patch the server so it can run the latest Blizzard patched client.
faisal, you can just need to update mangos to atleas 4112 to update to 2.1.3
e-turray.com/file/mangos/sdb/?dir= is good for sdb
mangos-file.de.vu is good for mangos revisions. both update fairily often just need to see what works, i dont rembember witch versions i used, sorry
hope it helps
I don't understand some of the things on the website sooo... i want to know ur screen name so we can do IM. please send me a mail or somthing for a solution.
Hi, my friend recently created a private server, i think he used your steps, and he's the only one who can get on it, whenever the rest of us try to connect we get stuck at "logging into game server" then it takes us right back to the reamlist
we are not running mySQL but the admin can get on w/o it
Pizzy can u ask ur friend to help me to make a private server... i've tryed other guides but they all don't work for me ... i think i might be missing stuff... please send me a message back on Beastckilla957@aim.com
right well i have made a private server its all up and running but im new to this so im a bit confused..
i would lke to change the rates and put in custom venders if you wish to contact e-mail its jayp16boi@hotmail.co.uk.
i am very greatful for anu help thank you
JOIN OUR FREE PRIVATE WoW SERVER!!
4X XP rate :: 100X item drop rate :: no E-mail address required to register :: Lag - Free!!!
JOIN OUR FREE PRIVATE WoW SERVER!!
4X XP rate :: 100X item drop rate :: no E-mail address required to register :: Lag - Free!!!
http://www.freewebs.com/wowpowerserver/
Can someone help me im on step 1 sort of i downloaded mangos but i dont know what program to open it with.
Just curiouse if it costsd anything to run your own private server, i have heard from several people that you must pay more every month.
Can someone please help me with the steps... i'm getting really confused. please contact me at beastckilla957@aim.com or u can aim me at beastckilla957. Thx
Hi i really need some help makin the private server so if you (maker103) can give me a message on beastckilla957@aim.com that'll be great
Hi i really need some help makin the private server so if you(maker103) can give me a message on beastckilla957@aim.com that'll be great
Oh and i would love other ppl to help me too sooo just e-mail the address above
HELP i am able to put up a server that i can join localy and my brother can see it on the realm list but when he tries to join it it says "Joining game realm" and then it takes him back to the WoW realm selection screen, over and over again. i need to have a working LAN server up by tomorrow because i am hosting a LAN and WoW is one of the headgames this time. i have worked on this for a week now i need a awnser PLEASE! Awnser on mail or MSN is fine aswell. Big_matte_123@hotmail.com
when i try to download the mangos revison it wants me to buy it can i get it for free????
I have a free "Noob" Version witch isnt realy for noobs it is just very fast to make a server and a SQL built in and working, you can make online and LAN server with it THO i havent been able to do it yet because of my problem above. Anyway if you want a fast and easy way to get a fully working TBC mangos server ver 2.0.12 working with ver 2.1.3 TBC send me a mail big_matte_123@hotmail.com
hey can anyone help me and tell me how can i change my explore rate pls ;) thnks.
hey can anyone pls tell me how i can change my explore rate on my private server ;) thanks
Melissa:
use serch and find "mangosd"
look in the 6thline I see if you can edit the text there for the explore rate
Please, can i get link to download wow server 1.12.0 or 2.1.3. Send me link to sinisa.nikolic@inet.hr
Thanks
CANNOT CONNECT TO SERVER WTF
plus everytime i start wow it wont even connect
ERROR:Map file 'C:\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 '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.
that one doesnt make any sense, i already have all the .map files in there
my email is krankzor@hotmail.com
try downloading newer ad.exe (the link can be found on my new wow guide with picture) :)
I download the new ad.exe at:
http://www.reaper-x.com/2007/06/28/configuring-mangos-for-tbc-server-or-wow-classic-server-setting-up-private-wow-server/
but still results in the same error message, plz e-mail me for help
krankzor@hotmail.com
this thing is causing me too much stress along with the fact that my responses are being completely ignored, i give up
Hey i got my server goig just fine thnx for the help but when another person trys to login it oes to the suggest realm, when they click okay it sends then back...can someone help me?I have good trouble shooting skills but this is a different thing.
going*
and btw i have the correct ports open adn i am also using the hamachi vpn software..reaper-z thnx for the help so far just push me over the edge.
thnx man
ah lol im so sorry, but i live in different timezone (GMT+7) and i've been busy setting up the new server (i just moved into new server) :)
and about your question :
i need to know which mangos revision you're using ? because different mangos revision (for example you can't use new ad.exe with the old mangos revision for wow classic server and vice versa)
well i found someone that said to dl NAVICAT and said to do a bunch of work ..now it does it to me .
I used the version mangos u provided, still when i run REALMD.exe it does not load completely, instead it freezes on the (last line) "realmd process priority set to HIGH" shouldnt there be a user input after that? My ad.exe works perfectly on extracting the maps, I even made sure to get the latest version, but my MANGOSD.exe will play russian roulette with loading the maps (sometimes it will sometimes it displays an error) "ERROR:Map file 'C:/WoW/Data/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program." I dont know whats going on, I might have screwed up on a step or two since I began... also I cant seem to put a user in.. it would be better of a help if u contacted me via IM on msn.
Mangos rev3462
actually the last line for realmd window / process is that line :)
as for the map problem, which ad.exe you're using ? is it the map extractor from here ? or using the new ad.exe from somewhere ?
as a note, the ad.exe from map-extractor is tested only for mangos 3462, and if you've downloaded new ad.exe version, then i'd suggest to use the mapextractor from here instead
Ok i installed a whole wow server package that works fine, but It will not display TBC content because it starts out as Original WoW (no patches) as soon as I try installing the new mangos or DBC it will not accept it and will throw me an error message for the maps and for the DBC content. How do I make it compatible with the current WoW version?
also when i sell something in te game I do not recieve any credit (gold, silver or copper)
the .additem wont go beyond 30000 #id and whener i use speed modifiers i get "stuck" on one spot with error: RunSpeedChange player is NOT correct (must be 35.000000 instead 0.000000), force set to correct value. keeps spamming
plz help
Run it by using this command (this time i make sure to use the default path instead of using command which is already set in environment variable path) from Start Menu => Run => cmd (this cmd can only be used in Windows XP) or command (Win9x) => and change to the extracted directory :)
C:\MySQL\bin\mysql.exe -u root
but I changed my Environment Variable path to
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin
so when I open CMD why doesn't it have
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin
nonetheless I put in my folder directory where I put my databases in.
C:\Program Files (x86)\CompleteDB
and all I get is a 'C\Program' is not recognized as an internal or external command.
I have all databases in a seperate folder like it says in the guide, but this CMD / MySQL is driving me crazy.
I don't understand why this isn't working i'm not else sure what to do if theres any alternative or if you could direct me on what im doing wrong it'd be much much much appreciated
thank you very much.
ok i've done all the steps but i'm using wow ver 1.9.4 (the only ver i have)... and every time i change the relmlist from us.login.worldofwarcraft.com to 127.0.0.1 i get the error "unable to validate version" and then it gives me a link to the wow support... i'm at a loss as to what to do. do i need ver 1.12.1?
i'm also haveing trouble loggin in... how do i create an account?
ok... i got the username and password (administrator) (root) but now it wont get past the "Handshaking" phase of the login. any suggestions?
to create account you can simply use the create desired_username desired_password from the mangosd window
and about your previous question, the answer is yes, you'll need at least 1.12.1 (WoW Classic)
you can get update for your wow classic from various website (fileplanet, filefront, etc) :)
when at the command prompt use double quotes when typing it .. for example :
"C:\Program files\blabla bleble\"
also if you don't like command prompt you can use various 3rd party mysql client such as Navicat, SQLYog, etc :)
I get to the point where I execute mangosd.exe and I get the error:
World Database: 127.0.0.1;3306;mangos;mangos;mangos
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 world database 127.0.0.1;3306;mangos;mangos;mangos
I am not sure what is wrong? :( BTW, I did add you on MSN and hopefully I will be able to find you on there.
Guys i have a mac and i havent found how to join or w/e a private server for that can any1 plz help i wanna get into a private server on a mac
email is Messyboy222@aim.com plz help
I might be using an outdated version of mangos and its loading only a percentage of the WoW content, for example some instances won't have enemies (in Outlands), wont load some of TBC items, glitchy mobs, and Illidan is in front of Black Temple lol. Also I cant use chat feature and my currency number is frozen at 0 copper. It would be nice to catch you on msn.
I downloaded the latest revision of mangos (I think it's 4125) but when i want to import the update.sql file into the mangos database it gives me some kind of syntax error.
Please help. Thx ;-)
ok, im soo confused on step 2, what database file, and how do i extract it, cause i got like, 10 database files when i just search for one, and i didnt see anythin for wow on those?
ohh, sry bout my lat comment, commented in the wrong area...
ok no i didnt, im an idiot, i just saw the emulators thing at the very top of comments and thought this was the place for them after i posted the first one, anyway, i was wonderin bout step 2 on the how to make a wow server the easier way.
HI! WHEN I TRY TO RUN MANGOSD.EXE IT WILL SHUT DOWN IN 1 SECOND .. THAT HAPPENS WITH REALMD.EXE TOO!!! HELP
IN MANGOSD.EXE THIS ERORR:
2007-08-15 11:32:02 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-15 11:32:02 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES)
2007-08-15 11:32:02 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
IN REALMD.EXE THIS ERORR:
2007-08-15 11:31:59 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES)
2007-08-15 11:31:59 ERROR:Cannot connect to database
PLSSSS HELP MEE IM TRYING TO RUN THIS FOR A MONTH!!! PLSPSL THX
That error message mean, you haven't created the mangos username on your mysql database yet
try reimporting the create-database (it'll delete all of your mangos related database) or you can just simply run these commands from command prompt :
1. mysql -u root -p (enter your root password when prompted)
2. GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
3. GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
4. GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
5. quit
that's it
as a note, if you change the database name / if you're using a modified mangos, the above commands might / might not work for you
if you prefer to look at my new guide with images, you can start from this link
ok, well, that didnt help me at all, i already did step one, im confused about step 2, i dont know which database file to extract, like the name of it, and i dont know how to extract it, i already used that page you sent me to for step one and all that worked fine. plz help!
Everyone who feels like a complete idiot raise your hand *raise hand* This is the most straight foreward guide ive seen, but im still stuck. Im trying to get this to work on my new laptop [runs on Vista =(] and im just getting confused. I added u on MSN (u can also email me at theeviltorrent@yahoo.com) and need to get some talk time in sometime because im jsut completely lost =(
just in case you havent looked at the new guide, i've updated this post with the link to the new guide :)
Hey i keep getting this error message too:
"World Database: 127.0.0.1;3306;root;root;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;root;mangos.
So then i tried doing:
GRANT ALL PRIVILEGES ON `mangos` . * TO ‘mangos’@'localhost’ WITH GRANT OPTION ;"
And so I tried doing what reaper-x said but i got another error message saying:
"ERROR 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near ''mangos' . * TO 'mangos'@'localhost' WITH GRANT OPTION' at line 1"
I'm pretty sure I typed everything in correctly. Still, really don't know what's going wrong. Help?
so sorry i forgot to encode the special character used, and it should be like below :
1. GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
2. GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
3. GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
as an addition, i've edited my previous comment to show the correct syntax :)
Hello, im a Gm in my server, but i cant talk at all...is it a bug?
Hi reaper... i was just wondering, yes people might of asked this before but i was wondering if it was possible to set this up and play by yourself offline... i mean i got a modem and everything (btw i dont have a static ip) but i dont wawnt to connect to the internet to play on my server... is it possible (if so could you tell me how please)
actually that's the point of this post (you run the server process on your own computer and connect directly to it from your own computer too) .. beside i dont have static ip myself and still using slow connection :)
plz help :)
ERROR 1045 : Acces denied for user 'root'@'localhost'
i tried with my username, with my password but it don't want to work plz help!!
Where is the ad.exe? :)
ok i found it. but i dunno were is the SDB FULL 0.6.2 stuff..
"5. Extract the SDB Full 0.6.2 file, SDB 0.6.2 Hotfix, and SDB Update"
Where are these files???
wow thanks, now can u just tell me how to modify my own items
Thanks :D
WTF does all of that mean?!!!!!!!
Hello , Ive tried to make my own server but it works and all i can go on it...but when i tell my frd to come they just cant join the realm...i put the IP i should put...But!...thats made an error...
in the console..(the black panel)
Like
Connecting to "server name" on "IP" ... Fail!
server connection failed .i will try again later.
and if i put 127.0.0.1 it works for me only.
plzz help :(
I've gotten everything to work that was explained in this guide but when i try to run ad.exe to extract the maps i get a C++ debugger error. Anyone know what that's about?
hey i keep getting an error when i try to start the mangos. im pretty sure i set everything up right but maybe i missed something
2007-08-26 00:29:30 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-26 00:29:31 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-26 00:29:31 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
thats the error and this is the status of my mysql
http://i91.photobucket.com/albums/k314/Quicksilver_0/mysqlerrorqs.jpg
also, when i run ipconfig shouldnt it say my default gateway is 127.0.0.1? because it says its 98.169.212.1
Hi..... I tryed to figure out everything in the past 2 months or so.... BUY I DON'T UNDERSTAND HOW!! PLEASE IM ME ( instant message) AT BEASTCKILLA957!
THANKS!
I HAVE A V 2.0.0 A TBC CLIENT WHICH INSTALLS ON OLD VERSION OF WOW CAN ANYONE PLEASE HELP ME WITH THE SERVER? I SEARCHED THE INTERNET AND DIDN'T FIND THE SERVER
i didnt see any problem with your screenshot. Btw try running below command at mysql command prompt
show databases;
to show you all the databases inside your mysql server and look for mangos
so i set up my server. it works fine. i can get my friends on it any everything.
but alot of the items do not work. for one, both green warglaives of azzinoth do not work, when i spawn the items that it shows in the ".lookupitem" command, they are some old version of the warglaives that are red and have different stats.
also the arena gear is old, and the setup of that in the hall of honor is different then in real wow.
im wondering, is there a new data ump or data file for the new setup that i can dload somewhere for the new weapons and stuff?
thx
i need help...
i got the version 2.00
and i assume this server doesn't use it because it doesn't work...
i don't have TBC
and i want a server can u help me make one...
i mean is there a way to downgrade my version so this thing would work?
okay so i got the server to work, very easy to follow, so grats on that... problem im haveing now is the inviteing friends part and most importantly; how do i log into my non private server? yes the private server is fun in all but i wouldnt want that to be my only option .. i am hopeing that you can help me fix these 2 issues. thanks, left you a IM on MSN btw.
Hey Matez, Woundering if yall can help me (: ...
i goes to run my MaNGOS (2.1.3 Version) and it comes up with lots of error's, a couple of them are stuff like;...
query ERROR:Table 'mangos.gameobject_respawn'doesn't exist
SQL Select DISTINCT FROM Character_intance'
query ERROR:Table 'mangos.character_instance'doesn't exist
SQL Select 'id' FROM 'instance'
Iwould realy apreciate youre help guyz.. ive tried all i can, butt it still don't work. i need some expert advise..
Srry 4 ma bad engish, my keyboard battery is runingout!!
Ty,
Matt
well ... you can always get the new database dump from sdb forum itself (not the mangos forum), although if it's for me i just need to check e-turay website to get new database changeset / full dump
i've just done what to do, but how i then make the account and connecting to the server?
type create desired_username desired_password from the mangosd window :)
Thanks for the guide, it was easy to follow and worked.
I am having one problem though, my account gets stuck at the retrieving character list screen. How do I fix this?
No problem Matt, beside my english language is not that good either lol
As for your question,
try reimporting the mangos SDB but wait until the process finished without interupting it
Your welcome Friesner :)
Do you mean the realm loop problem ? well .. it can be caused by many factors :
1. you didnt import the Database properly
2. mangos configuration error
3. incompatible mangos version with the wow version installed
4. and so on
i cant write in the mangosd, what shal i do?
k so I figured out to switch from the private server and the regular server... just had to make a copy of the orginal and have two seperate folders of wow... k so wheres my noob crown for not doing this in the firstplace. lol OK now that we cleared that bridge, i need to learn how to get my friends to my server... should they build there own server as well and just change the IP addy? or what do i do? appriciate any help you can give.
want o be GM!
hey its gonna be great if i canget private server
hey reaper
i downloaded ad.exe, but its outdated coz my wow classic server has other mpq's in the data dir: common, patch and patch-2. I've accordingly to one of your previous replies looked for a new one but i simply couldnt find. it would be a big mountain of happiness if you'd give me a link! (i added ur msn, verkeerslicht [at@#at} gmail ([{dot}]) com is mine)
thanks in advance - tierro
can someone plz help?, i cant do anything in mangosd, so i can make the account, what shal i do?
I'm wondering if there is a way to make this work with newer versions of WoW. Unless I'm missreading this, it only works with v1.12.
hey i have everything running fine but when i log into WOW with my GM name it says that it is an invalid name or password. what do i need to do?
Hello There. Im gonna start making the server, just wanted to say hello.
p.s.-What is URI?
I was wondering how i could find out all the commands because .commands dosen't seem to be working
# jackh
did you use your GM Account when typing .commands ?
# Sebastian
A good explanation about URI can be found here :
http://www.webopedia.com/TERM/U/URI.html
# Sleeperx
Are you sure you're using the correct password ? or try creating new account with GM Level
# Aaeon
Actually the process for creating TBC server is just the same, with the exception when creating TBC server you need to download the newer revision of Mangos and SDB from the respective website :)
Reaper-x,
Nice guide, the screen shot helped alot.
However I have followed it Everything works as it should (best that i can tell), but when i try log into the client it says:
the information you have supplied is incorrect......please contact your administrator... lost password or login.
this is at the client screen, BTW.
Got some good ideas from the prev. posts to check for errors but any other help would be appreciated.thanks
Forgot to add to previous post....
Making a WOW Classic server.
Im having to create servername and characters through the runmangos window......it worked once for me but then i installed BC and it didnt work anymore....got any ideas?? did i do something wrong?
# Mike
Thanks Mike, and about your question, it can be caused by several things like :
1. You havent changed the realmlist used into your own server ip address
2. Database is not properly imported / loaded
3. and more
but as for now, i'd suggest you to look into the realmlist.wtf file inside your wow game directory
# Sleeperx
Didnt work for you anymore since upgrade ? try looking at the realmlist.wtf file, to see if it's using your mangos ip address or wow official ip address
ive got mangos and gone through all the setup stuff put in my ip and all that and when it come to logging in a log in it trys to connect then says it is unable to connect to server wat do i do to fix it?
I'll check that too.
BTW, I used the admin account and it works, able to login i and create characters. However, i can create the user/account in mangos but it wont allow me to log in with that user name password.
Thoughts.
...BTW, I used the admin account and it works, able to login i and create characters...
NM, i think i understand....The realm I'm creating the accounts for probably isn't in the realm list. makes sense.
/headdesk ;)
2007-09-05 22:03:13 Using configuration file mangosd.conf.
2007-09-05 22:03:13 MaNGOS daemon /0.8-SVN (Win32)
2007-09-05 22:03:13 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-09-05 22:03:13 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-05 22:03:13 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-05 22:03:13 Realm running as realm ID 1
2007-09-05 22:03:13 Using DataDir C:\WoW\data/
2007-09-05 22:03:13 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-05 22:03:13 WORLD: VMap data directory is: C:\WoW\data/vmaps
2007-09-05 22:03:13 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-05 22:03:13 Initialize data stores...
2007-09-05 22:03:13 ERROR:
Some required *.dbc files (1 from 37) not found or not compatible:
C:\WoW\data/dbc/TaxiPathNode.dbc (exist, but have 9 fields instead 11) Wrong client version DBC file?
Can you please help with with this problem i am running "mangos version 4368 and database version 4344" yet when i come to load the server it always comes up with i am missing specific files
Dear, Reaper..
i'm trying to make a private server.. but it totaly isn't working out...i was wondering if you could help me trough Crossloop? ( that is an program, so you can log on in my computer )
and do it on my computer.. i also would pay you for it if it is very hard , and if it takes very long... please contact me over : wouter_van_der_vaart@hotmail.com
Sincerely,
Wouter
Hi erm yeah for some reason as it says logging into server the window goes off and it dosnt let me connect to my realm?
ke a private server?
yo how do u make ap private server?
hello
Cant seem to download the SDB156 Mangos3462 file.
Help pls. Thx a million in advance.
wow, this is supose to be easy lol i think this website is pretty good but, HARD to anderstand to many tings to do if there is some1 that anderstanded everything and has set the full ting well could u msg me on my email: liban_numero_1@hotmail.com to help me out whit all this. ty very much
confusing.
hey reaper, i have been trying to make the server and i have succefully installed mysql, but im stuck in the mangos part, it seems like the link to the first requirement to make a BC server, any way you can help me?????
Okay. After resolving many problems I have run into one more that I require some help with.
Okay when I run my Mangos.exe I get these errors. (And no it has noting to do with maps)
Error List
-------------
2007-09-11 19:55:53 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-11 19:55:53 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-11 19:55:53 Realm running as realm ID 1
2007-09-11 19:55:53 Using DataDir ./
2007-09-11 19:55:53 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-11 19:55:53 WORLD: VMap data directory is: ./vmaps
2007-09-11 19:55:53 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-11 19:55:53 ERROR:SQL: UPDATE `character` SET `online` = 0
2007-09-11 19:55:53 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2007-09-11 19:55:53 Initialize data stores...
2007-09-11 19:55:53 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2007-09-11 19:55:53 ERROR:SQL ERROR: Table 'mangos.corpse' doesn't exist
2007-09-11 19:55:53
2007-09-11 19:55:53 >> Loaded 37 data stores
2007-09-11 19:55:53
2007-09-11 19:55:53 Using Autodetected DBC Locale (0).
2007-09-11 19:55:53 Cleaning up instances...
2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-09-11 19:55:53 ERROR:SQL: SELECT `id` FROM `instance`
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-09-11 19:55:53 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` > 1189554953)
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-09-11 19:55:53
2007-09-11 19:55:53 >> Initialized 0 instances, deleted 0 old instances
2007-09-11 19:55:53 Packing instances...
2007-09-11 19:55:53 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` 0
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-09-11 19:55:53
2007-09-11 19:55:53 >> Instance numbers remapped, next instance id is 1
2007-09-11 19:55:53 Loading Game Object Templates...
2007-09-11 19:55:53 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
2007-09-11 19:55:53 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-09-11 19:55:53 ERROR:Error loading `gameobject_template` table (not exist?)
Help With the SDB156 Mangos3462 file Pls.
I am able to download the file. Just that it has errors when its complete.If Anyone could post a proper link to the File i`d be really grateful. Thank you.
#Jon & Anteaus03
Try looking at the second part of my new guide ... and if you're looking a tested mangos revision including it's download link, look at the update part
as for anteaus problem
that error message was caused because you didn't import the sql file properly
# Tailee
Could you tell me which wow server version you're trying to create ? the TBC or classic server ?
im looking to create a private server. If anyone can help (give me instructions) ill pay them:P, problem is ive got a router so the router assigns my IP (192.168.0.XXX) thx , I want a 2.1.3 server. My email is dog_man_sne2@hotmail.com
ok, dude srry for that, i wrote the question wrong, im really srry,
anyway, what i meant was that the link for the first requirement for making a TBC server is out of date, try it and youll see my prob, any way ypu can create a new link for the file???
ty very much, johndie
ok well nvm, i cant make the private server with windows vista, srry for the questions
Hey, everytime i download stuff for wow emulators they're always .rar file WHY !?!?
Winrar is just a good archiving system. If you can extract them just google winrar and get the program.
Help!!
everytime i open cmd prompt and type c:\mysql\bin\mysql.exe -u root but i entered my password when i configured mysql, and that time it didnt even ask me for a password! what am i doing wrong?
BTW im using XP
^^ i dont know how but half my message got cut out
anyone knows a place to find some game master commands?
other ppl can't get on my server, they can see it, but if they try to connect it says: logging on to the server... and then you get back to the server select screen ... anyone knows what im doing wrong?
Ok i sorta got it working better now, i did what youtold someone else to do in the same situation as me (error 28000 i think): That error message mean, you haven’t created the mangos username on your mysql database yet
try reimporting the create-database (it’ll delete all of your mangos related database) or you can just simply run these commands from command prompt :
1. mysql -u root -p (enter your root password when prompted)
2. GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
3. GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
4. GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
5. quit
i did that, mangosd.exe still closes in a second, but realmd.exe just stays open saying:
Database:127.0.0.1'3306;mangos;mangos;realmd
added realm "reaperX".
realmd process priority class set to HIGH
What am i doing wrong?
please healp
tom
ps. awesome guide thanks
Try opening the server.log file inside your mangos directory (it'll shows you what caused the mangos process to exit) ;)
well i cant do the first step in youre guide it says downloade mangos i take the link and it goes to a site but THERE ISNT A DOWNLOAD BUTTON
there should be a large animated neon colored download button for the latest revision and SDB I guess... it's called reading Mr. Why...
Tom
Help!!
everytime i open cmd prompt and type c:\mysql\bin\mysql.exe -u root but i entered my password when i configured mysql, and that time it didnt even ask me for a password! what am i doing wrong?
BTW im using XP
Tom#
try using the -p flag example: mysql -u root -p
Enter Password: *******
-------------------------------------
I'll help or mail :) | Sep 16, 2007 |
anyone knows a place to find some game master commands?
if you actually have a server running and made you account, did setgm ACCOUNT_NAME 2-3, type .commands it'll tell you what you can do...
Also
other ppl can’t get on my server, they can see it, but if they try to connect it says: logging on to the server… and then you get back to the server select screen … anyone knows what im doing wrong?
you have to go into the realmlist database as I told someone else on the configuring mangos part of the guide, and add a new row to the realmlist table, name the realm what ever you want, figure out your wan IP by going to whatsmyip.net, set the IP on the second realm to this IP adress, forward port 3724 and 8085 to the computer that's hosting the server, and edit the realmlist.wtf to say this...
set realmlist WAN_IP_ADRESS
set patchlist WAN_IP_ADRESS
-----------------------------------
Ok i sorta got it working better now, i did what youtold someone else to do in the same situation as me (error 28000 i think): That error message mean, you haven’t created the mangos username on your mysql database yet
try reimporting the create-database (it’ll delete all of your mangos related database) or you can just simply run these commands from command prompt :
1. mysql -u root -p (enter your root password when prompted)
2. GRANT USAGE ON * . * TO ‘mangos’@'localhost’ IDENTIFIED BY ‘mangos’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
3. GRANT ALL PRIVILEGES ON `mangos` . * TO ‘mangos’@'localhost’ WITH GRANT OPTION ;
4. GRANT ALL PRIVILEGES ON `realmd` . * TO ‘mangos’@'localhost’ WITH GRANT OPTION ;
5. quit
i did that, mangosd.exe still closes in a second, but realmd.exe just stays open saying:
Database:127.0.0.1′3306;mangos;mangos;realmd
added realm “reaperX”.
realmd process priority class set to HIGH
What am i doing wrong?
please healp
tom
ps. awesome guide thanks
Tom, when you setup the database initially did your mysql commands look like this in the prompt?
cd /d C(or D):/mangosdirectory/SDBfolder
mysql -u root -p -v(optional for the matrix stuff lol)
(sorry, post was cut off, too long I guess)
To continue..
Tom, when you setup the database initially did your mysql commands look like this in the prompt?
cd /d C(or D):/mangosdirectory/SDBfolder
mysql -u root -p -v(optional for the matrix stuff lol)
>.> keeps cutting me off
mysql -u root -p
Tom, when you setup the database initially did your mysql commands look like this in the prompt?
cd /d C(or D):/mangosdirectory/SDBfolder
mysql -u root -p -v(optional for the matrix stuff lol)
>.
Tom give me your email... lol
I'm so sorry but i have to close the comment form on this page to reduce the server load :( .. and if you want to continue the discussion feel free to use the forums :)