Reaper Mangos Installation / Upgrade Guide
By Reaper-X on Jan 30, 2008 in Guide, Reaper Mangos, Reaper Mangos Mod
To make things easier for me to update Reaper Mangos in the future without the need to write the installation guide each time there’s a new release, i’ve decided to a separate post explaining on how to install Reaper Mangos … but please note that guide is specifically designed to those who wants to install Reaper Mangos from scratch (not upgrading) or in other words, fresh installation, because in order to upgrade you just need to execute the batch file in the upgrade folder inside reaper-eazy-mangos directory
Once again, if you’re going to upgrade your Reaper Mangos installation, make sure you’re using 1 version below the current release or you’ll lose all of your character data (unless you’ve created a backup before) and other customization made by yourself. So without further ado here goes the guide
Requirements :
1. MySQL Community Edition (Free) … as for the installation guide, you can read my previous post on how to install MySQL on Windows
Important: Grab the version 5.0 setup.exe version instead of 5.1 or 6.0 because the 5.1 series is still in Release Candidate stage while the 6.0 version is still at early alpha stage and not recommended for production use
2. World of Warcraft Client (supported version changed on each release)
3. Reaper Mangos itself
p.s the image itself might be outdated but the process is still the same :)
Fresh Installation :
Once again, please Note : Fresh installation will overwrite your database which means everything will be from fresh
1. First you’ll need to install MySQL
2. And the next step would be extracting Maps, DBC and VMaps from your World of Warcraft installation … (Maps and DBC are required in order for mangos to run, while VMaps are optional)
3. Run the reaper-x-mangos.exe inside the reaper-eazy-mangos folder, and you’ll get something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)
If you’re didn’t write the correct path, you can be sure that you’ll get an error message at the next step
4. Now you just need to choose option number 1 to install the database as shown below, and when prompted for your mysql root password, don’t forget to write the correct password … :)
And one more thing, when you see something like in The Matrix movie (well … that’s how people called it) :) , you just need to wait until it finished and don’t interrupt the process
5. After finished with the database installation, now you need to choose option number 4 (required, unless you know how to edit the mangosd.conf manually) to adjust the datadir and adjust the exp rate, and drop rate (although the most important thing is your datadir path
6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …
Replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
With :
set realmlist 127.0.0.1
and then save it and close realmlist.wtf file
7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account
Btw if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :
create username password
to create the account, and then to allow your account to access The Burning Crusade Expansion pack (like BloodElf) you need to type :
setbc username 1
and finally :
setgm username (1–3)
for example setgm myusername 3
to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)
Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.exe to adjust it :)
Upgrading Reaper Mangos :
Make sure to backup your Characters data before upgrading
Upgrading Reaper Mangos can be done by simply running the reaper-x-upgrade.bat in Upgrade folder in reaper-eazy-mangos directory
But please note, that if you’re still using 2 version below the current release, the upgrade process is not going to be completed successfully (i’ve been trying to make sure that the upgrade process can be used by any version but it’s seems that there’s no easy way to accomplish this, but if you got a suggestion on how to process this, just let me know about it)
Note : You don’t need to worry about your custom stuff being overwritten by the upgrade process, because unlike before this time it’s only upgrade the necessary stuff only and not going to overwrite your custom stuff (but i assume that you’re using high id numbers for your custom stuff)
Finally i’d suggest you to check out the GM Commands List because there are some changes made at the GM Commands especially at the lookup command (and of course i’ll always update the GM Commands List whenever there are new command available for you to use, or there are previous command that is being replaced with new commands)
Related Links :
Complete Mangos GM Commands
Creating Public WOW Server
Creating 2 different World using Mangos
Apache Web server Installation Guide
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
Yay, first comment. :)
Thiers a problem with 5. in the current5082 release, it says the this option doesnt work and so some people may get confused when it doesnt work so could you tell them the other option or I could tell them if you want me to.
Steve
(the bit about choosing option 4 is what i'm talking about)
So please find me in skype:azumruf
I can handle the problem with these maps!
I got problem when i start mangos.exe it says that map 0004331.map is non-compatible version
What can i do ?
Also says to creat new with ad.exe but don't know how to use it...
Answer my questions please !!!
ya tell us plzz i am right at that part
dude i need help i am right at that part
Can i have a direct guide on how to backup my character data? Every time i try to restore my already backed up data, it says:
The system cannot find the file specified
The system cannot find the file specified
The system cannot find the file specified
What files and how do i fix this. Can you answer my questions and give me a direct guide?
Thanks-
Evan
#Everyone that needs help with number 5,
I'll be home in about an hour or so and i'll write it up then so hold on...
Steve
#Everyone that needs help with number 5
Here's what to do (copied from an email i sent a few days ago):
Open up mangosd.conf which is in where you saved reaper-x mangos and look for:
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = ""
and
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database - use named pipes at Windows
# Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters"
On the first one, where it says:
DataDir = ""
put in the "" where youve saved the extracted vmaps, maps and dbc files.
On the second one, where it says,
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters"
change:
= "127.0.0.1;3306;mangos;mangos;realmd"
= "127.0.0.1;3306;mangos;mangos;mangos"
= "127.0.0.1;3306;mangos;mangos;characters"
into
= "127.0.0.1;3306;root;password;realmd"
= "127.0.0.1;3306;root;password;mangos"
= "127.0.0.1;3306;root;password;characters"
Where root is the database username (default root) and the password is the database password (what you used when configuring MySQL).
In realmd.conf look for:
LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
(it may not say mangos;mangos on either of these so look for the words/numbers around it)
and change it to:
LoginDatabaseInfo = "127.0.0.1;3306;root;password;realmd"
with the same rule as before. For scriptdev2.conf look for
ScriptDev2DatabaseInfo
= "127.0.0.1;3306;root;password;scriptdev2
and change using the same rule as before.
Sorry if its hard to follow, email me at steveya@hotmail.co.uk if your confused.
Steve
# Evan
Could you tell me which revision you are using ? so i can take a look at it (and of course i'll create a guide on how to backup your character data manually) :)
# Steveya
yes actually i've fixed that and will be included again on the next release and btw thanks for the help ;)
I have everything setup and can connect ot my server with my client. I can select the real in the real list but it continues to bounce back to the real list. I never make it to the create character screen. What do I do to fix this. Thanks for the help also.
sorry for the double post but it says logging into game server then bounces back to realm list. Missed the m on realm in the previous post as well. LOL
#Reaper-x
no problem. also, can you answer my question in the http://www.reaper-x.com/2007/07/03/creating-public-server-for-lan-party-setting-up-private-wow-server/ guide... i'm still having problems, like loads of other people... lol
Steve
Martacom Webportal - Webproxy
A very effective proxy site, use it for your own good.
Martacom your easy to use webproxy.
You surf anonymous on the web and
bypass websites that block your IP with a few clicks.
An easy to use interface and very effective script implementation for powerful proxy features.
http://www.martacom.nl/
Yeah im using the newest version for 2.3.3, Reaper Mangos 5082
heey. i made a rly bad mistake. i usede blizz srv on net. and then my wow updated. and now my wow cant find my own srv. so my Question is. how do i update my private srv ?
:)
Mike what version is your wow client on?
If its 2.3.3 you need to update your reaper mangos to 5082.
hello can you please tell me what to write when you type 1 in the x reaper helper menu ? there comees for example "what is your Mysql database name?
toxic or anyone just help or tell where to fid out!
#help
its root
Steve
Im only 13 years old.. do i have to write just "root" or something with C:/Programs/World Of Warcraft/something?
and what about the others? where what shall i for examle write at "whats your mangos database" ?
when i try to open mangosd / realmd i get an errormessage saying i miss the file MSVCR71.dll
and therefor application couldnt be started, i looked pretty much every of ur posts but cant find what to do, is it something with config or?
I found out about the "whats your mangos database" and all the others, but i only need to know what to type "MySQL database" shall, if i just write "root" it comes with three errors..
when you say root, you mean just i type r o o t, or some of my username or something?
sorry for the bad english.. but i must say im doing well when you think im 13 years old..
Hey! i love this program! but i got a small problem on the last part of the instalation where i opened mangosd.exe and realmd.exe everything loaded till the last part “Loading items….
SQL: SELECT MAX from ´item template´
query ERROR: Table ´mangos.item_template´doesn´t exist
Error loading ´item_template´table
i use SQLyog with mySQL server and ive done eveything as in the guides, how do i fix this!? SUX being stuck on the last part! plaus i cant write anything in the mangosd.exe and realmd.exe when the error comes
i found the file , but when i open realmd i get
"Could not connect to MySQL database at 127.0.0.1: acces denied for user ´mangos ´@´localhost´
cannot connect to database."
i got the same probleme isgrodan have plz help some one
ok no i got it srry
I NEED a guide to help backup my server pleaspleaseplease
# evan
evan if you're using reaper mangos, actually you can use it to backup your character data and login data (realmd) :)
# isgrodan
you can get msvcr71 from :
http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71
# help
the correct root would be "root" without quotes
How can i decrease the chance of mobs to critical hit.Every single hit is crit. ???? Thank you!
anybody answer me please
please just tell me what to write at ALL the things, because i dunno what to type at everything.. :s
im trying to set the server back up because the other computer it was on broke, any who i did everything (i think) that your guide said and up to where you create your account i open mangosd.exe and it run for a sec and it says
world Database: 127.0.0.1;3306;mangos;mangos;mangos
MySQL client library:5.0.45
MySql serser ver: 5.0.45-community-nt
Character database: 127.0.0.1;127.0.0.1;3306;mangos;mangos;characters
MySQL client library:5.0.45
login database: 127.0.0.1;3306;mangos;mangos;realmd
MySQL client library:5.0.45
Realm running as realm ID 1
using udb 0.9.1 with SD2 calls rev.236
Using datadir directory is: @prefix@/share/mangos
world vmap support included. Line of sight:0 get hight:0
World vmap data directory is @prefix/share/mangos/vmaps
World:vmap confg keys are :vmap.enableLOSm, vmap.enableheight, vmap.ignoremapIds, ignorespellids
Check existing map of file '@prefix@/share/mangos/maps/0004331.mao': not exist!
Correct *.map files nt mound in path '@prefix@/share/mangos/maps' or *vmap/*vmadir files in @prefix@/share/mangos/vmap'. please place *map/*vmap/*.vmdir files in appropriate directories of correct the datadir value in a mangosd.conf files.
I dont know what to do.
how to uninstall mysql
sory for all my posts iuninstalled mysql now, well but, i had an error when i tried to configure mySQL, it keeps saying something with "The service could not be started. Error 0
" at "Start Service"
I followed everything started up WoW and it says Unable to connect i set my realm list to set realmlist 127.0.0.1
i did everything right, step by step, but when i open mangosd.exe it sais:
world Database: 127.0.0.1;3306;mangos;mangos;mangos
MySQL client library:5.0.45
MySql serser ver: 5.0.45-community-nt
Character database: 127.0.0.1;127.0.0.1;3306;mangos;mangos;characters
MySQL client library:5.0.45
login database: 127.0.0.1;3306;mangos;mangos;realmd
MySQL client library:5.0.45
Realm running as realm ID 1
using udb 0.9.1 with SD2 calls rev.236
Using datadir directory is: @prefix@/share/mangos
world vmap support included. Line of sight:0 get hight:0
World vmap data directory is @prefix/share/mangos/vmaps
World:vmap confg keys are :vmap.enableLOSm, vmap.enableheight, vmap.ignoremapIds, ignorespellids
Check existing map of file ‘@prefix@/share/mangos/maps/0004331.mao’: not exist!
Correct *.map files nt mound in path ‘@prefix@/share/mangos/maps’ or *vmap/*vmadir files in @prefix@/share/mangos/vmap’. please place *map/*vmap/*.vmdir files in appropriate directories of correct the datadir value in a mangosd.conf files.
What do i do?
When i try to run mangosd.exe and realmd.exe i get the message:
2008-02-05 01:58:37 Using configuration file mangosd.conf.
2008-02-05 01:58:37 MaNGOS daemon /0.10.0-SVN (Revision 5116 ) - http://www.reaper-x.com (Win32)
2008-02-05 01:58:37 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
2008-02-05 01:58:37 Daemon PID: 3396
2008-02-05 01:58:37 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2008-02-05 01:58:38 ERROR:Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
2008-02-05 01:58:38 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
Any ideas?
i installed this about 4 months ago but my hard drive i followed all the steps but when i run mangosd.exe and realmd.exe i get "unable to locate component this application had failed to start because MSVR71.dll was not found re-installing the application may fix the problem" i tried downloading and extracting again but it did not help
thanks -joe
but my hard drive died*
sorry i skipped through the other comments missed the link to the .dll, copied it to my system folder now everything is up and running. i wonder why i didn't have that .dll
@Tomcat
@nikor
You need to setup your data folder. What you need to do is go to mangos.conf search for
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir =
what you need to change is your DataDir =
that is what you need to change if not mangos will NOT run. here is a example
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "C:/WoW Server/Reapermangos5082/data"
after you save where your data folder is located then save but before you save look once more before you send another comment in.
DataDir = "C:/WoW Server/Reapermangos5082/data"
you notice that it's not using the forward slash " \ " it is using the back slash " / " use back slash. Forward slash do not work for that spot so MAKE SURE you do that or you will not get that server up and running
@Joe
scroll up reaper has already answered that from someone else and also gave out a link for you to go to.
I will be nice and give you the link but you might want to search next time
http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71
Reaper i would personally like to congratulate you on another great job! time and time again i use ur products and i am never dissapointed, it always works and u have great support. just for the record this package does work so guys look over what u have done and keep trying....trust me its worth it.
Thanks again Reaper!!!
@ knight00011
Thx, i did what you told me, but now it keeps giving me a constant look of the transport. I need to make an account on mangosd.exe, but there is no time to type anything and i don't see the schreen reaper shows on 7.
i see the screen and i know how to make myself an account, but i can't get the text to stop appearing, whenever i type in 2 letters something in the line of "Booty Bay Shp moved to -4333.299561"
Hi I am having the same problems as Tomcat and Nikor. I tried fixing the path the way I was told, but it is still giving me the same messages as Tomcat and Nikor. When I go into the data/maps directory, there are no files in there. Did I do something wrong? Are there supposed to be files in the Maps directory?
@ Travis
Yes you should have files in there, if they have gone missing, make new ones by running the MapExtractor program again.
@ Tomcat
I tried to make maps again by running extract-map.bat in the
C:\Program Files\World of Warcraft\data\enUS
it is still not putting any files in the Maps folder. Not sure what else to do.
@ Travis
you don't have to place it there, you have to place it in the root of your game, in your case "C:\Program Files\World of Warcraft" and not in data.
@Tomcat
WewT! That worked! Thanks for the help!
Travis:.....
The recent WoW installation does not contain any maps, the maps are actually stored in the users account on the Blizzard server, as are the characters and most of the realm details.
Therefore it is NOT, and will NEVER be possible to run a successful private WoW server, unless a Blizzard employee can be bribed to obtain their server software, prepackaged, ready to work out-of-the-box, with only the ip addresse(s) to be changed.
Ok, so i finaly created an account, but when i wanted to start playing, it said it was an invallid version, so i updated, when i restarted mangosd.exe, it gave me an error: "Error in 'item_template' table, probably sql file format was updated (there should be 141 fields in sql)."
I know it is updated, i just did that, but how do i fix it?
Well heres my problem, the Mangosd.exe has this, and will not do anything but this...
Incorrect DataDir value in mangosd.conf or ALL required *.dbc files not found by path: D:\WoW\Data/dbc.
Now, Im a bit lost..Im using the version which works with 2.3.3 so can someone please help?..
And if you can comment back asap tha would be good..im having GF problems..and i need this to take my mind off it.
@ my old post, I need help with #7+ if someone can help.
Hey, someone can help me?
When I run mangosd.exe, it says that my 'item_template' has some problems and it may be outdated. What I do to fix that?
I am using the lastest version of the Reaper Mangos(5116)
I guess no one cares, but, I took the following actions to see if this would help.
Steven, on a higher post, told people how to fix #5. I figured, hell why not give it a try. So I did and now I can't turn mangos or realmd on at ALL. So I'm going to reverse that crap, and beg for help with step #7. I cannot get realmd or mangos to allow me to even type on them. Perhaps its because I have no idea where the dbc files are?
Maybe someone can list the exact dbc files I need to put in D:\WoW\Data
http://www.reaper-x.com/2007/10/10/wow-mangos-map-vmaps-and-dbc-extraction-guide/
SELECT 1 FROM `account` WHERE `username`='root'
query ERROR: Table 'realmd.account' doesn't exist
SQL: INSERT INTO `account`(`username`,`I`,`joindate`) VALUES('root',SHA1(CONCAT(UPPER('root'),':',UPPER('root'))),NOW())
SQL ERROR: Table 'realmd.account' doesn't exist
SQL: INSERT INTO `realmcharacters` (`realmid`, `acctid`, `numchars`) SELECT `realmlist`.`id`, `account`.`id`, 0 FROM `account`, `realmlist` WHERE `account`.`id` NOT IN (SELECT `acctid` FROM `realmcharacters`)
SQL ERROR: Table 'realmd.account' doesn't exist
can some1 help me with this
DBC error
You have _outdated_ DBC files. Please extract correct versions from current using client.
_______________________________________________
I Have tried everything, patch up to date, runnin on windows xp, got new version of mangos 5116, re extracted DBC files adn matrixed again with correct file path. Plz help, it's got me confused.
when i run mangosd exe it says that my DCB files are outdated and i need to extract the current ones from client but as far as i can tell they are up to date as shown above how do i fix this problem?
Hey guys, first thing I want to say awsome job. I never thought I'd be able to look at the BT bosses face to face but thanks to you I can die now :p.
The only thing that's giving me a problem is the fact that I can't create a 2nd toon for some reason. As soon as I do, or as soon as a friend joins my server, my character screen stays blank and I can't see nor select any characters. Neither can my friends. Only after I delete all accounts and start over, can I see 1 toon. And as soon as I create a 2nd they dissapear again.
They exist because if I click on change realm, it tells me that my realm has X number of toons on it. But I can neither see nor select any toons.
I've tried searching 2 days for a fix but so far I've only read about 1 guy with a similar problem on a different forum with no luck.
Thanks for any info you can give me. BTW The game doesn't give me an error message of any kind which is what I found odd.
I did all the things listed, but when im done and have to start realmd.exe and mangosd.exe they both give an error: Cannot connect to world database. What can i do about this
alright, so i figured out how to fix that side-by-side error, now how do i actually get into it to play?
i click connect... it says unable to connect... how do I fix this problem... I have WoW 2.3.3 and mysql 5.0.51. i'm on vista and got around the "side-by-side" error for the mysql. but i can't connect to play.
i'm also using reaper mangos 5116
I think it may have something to do with realmd.exe. I can't type in it, and it also doesn't seem to do anything when i run it. How long should it take to complete?
how do u install v 5225 on a linux box i looked in the readme and there was was no installation guide that shows for linux server
Thx again :D
I just changed my OS from win xp to Vista and after 2-3 hour i have at last installed the private server.
Respect to your work with mangos.
#johaan
i have the same problem...in fact when anyone tries to make a character from any connection on any account they can't see it on the character list
download mySQL 6.0 it works
heeeeeeeeeeeeeeeelp me please im going through a real stressful time and i need this to take my mind off it but when i try to run mangosd it stops and says
2008-02-17 21:40:05 ERROR:Map file 'C:/wow/data/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.
2008-02-17 21:40:05 ERROR:Correct *.map files not found in path 'C:/wow/data/maps' or *.vmap/*vmdir files in 'C:/wow/data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
During my setup, I first met the problem Tomcat and nikor noticed above, and when I fixed that problem I got a new error message:
Loading MaNGOS strings...
SQL: SELECT 'entry','content_default' FROM 'mangos_string'
query ERROR: Table 'wow private server.mangos_string' doesn't exist
==================================100%
>> Loaded 0 mangos strings. DB table 'mangos_string' is empty. Cannot continue.
What should I do to fix this problem?
Great job... easy to follow and set up.
I have been stymied a bit by a Warning the from the server...
SD2 :WARNING >> Loaded 0 Localized_Texts. DB table 'Localized_Texts' is empty
and
SD2: WARNING >> Loaded 0 EventAI_Scripts. DB table 'Event_AI_Scripts' is empty.
This does not seem to make the server not work but it is puzzling. is this a normal message ? or should I look for problems.
SQL: SELECT ‘entry’,'content_default’ FROM ‘mangos_string’query ERROR: Table ‘wow private server.mangos_string’ doesn’t exist
==================================100%
>> Loaded 0 mangos strings. DB table ‘mangos_string’ is empty. Cannot continue
I am also having this problem, Did it not import this table with the rest of them? I do see atleast what looks like the other tables in ..\MySQL\MySQL Server 5.0\data\mangos
I've tried for several hours to fix it, searching for it, didn't turn up much.
Please Help :(
Im having same problem here :
-----------------------------------------------------
Loading MaNGOS strings...
SQL: SELECT `entry`,`content_default` FROM `mangos_string`
query ERROR: Table 'mangos.mangos_string' doesn't exist
[**************************************************] 100%
>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.
macos/FastLock.h:73: failed assertion `false'
Abort trap
logout
-----------------------------------------------------
I also have been at this for a hole day, still nothing.....i can't find the solution to this problem.
Been using Mangos on my old PC with no problems....this error is on my Mac using "Mangos 5235" with Maps,DBC, Vmaps and everything downloaded via the program !
PLEASE HELP REAPER !!!!!!
I got one error "Could not connect to MySQL database at 127.0.0.1: can´t connect to MySQL server on 127.0.0.1" what´s wrong? thx for help=)
i am getting a msg
“Could not connect to MySQL database at 127.0.0.1: acces denied for user ´jepe ´@´localhost´
cannot connect to database.” ???
# Kenneth and Pheen
from that error message it seems that you didn't choose to upgrade the database, try using reaper-x-mangos.exe and then choose to upgrade the database :)
# /beg
Are you using Reaper Mangos 5225 ? if so ... i'm guessing that you choose to write your own username when asked at the fresh installation steps and the solution to it :
1. Leave blank when prompted to use root as the username and continue with fresh installation
2. When asked whether you want to create separate username for mangos, answer Y and it'll create separate username for mangos automatically
# David Bentley
Yes, actually you can just ignore it :) .. because the current release (if you choose to use UDB as the database instead of PSDB) still not using the new EventAI, but on the next version there'll be eventai too for UDB, just wait for it ;)
Dear Reaper,
Thanks for advice on the mysql installation.
Now i have some problem. where can i download the reaper mango 5225 software? hope you are able to provide me the link, thanks once again... ed
# Edan
You can always look for the new release from the homepage directly ( http://www.reaper-x.com ) or you can also take a look at the footer section or you can also browse through the reaper mangos archive
"ERROR 1064 at line 1: 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's world', 'sddress' = '127.0.0.1' WHERE ' id' = 1 LIMIT 1; SELECT * FROM 'realmli' at line 1" i'm not sure what this means, can anyone help?
mmmk... fixed another problem i was having... now i can get to the realm list, but can't get to the create a character part, I may have missed through the posts, but if someone could point me in the right direction?
i got the same problem as Frank. On step 7 when i start mangosd.exe and realmd.exe, neither can connect. Everything before that worked though
ok i got the mangosd.exe to go a little farther, but now it says i have an outdated DBC file, how do i get the most recent one?
as for the realmd.exe, it says "No valid realms specified."
Reaper, Good work!
I need a little help. Sorry if I missed the answer.
Mangos 5225
SQL 5.0
I followed the instructions step by step. No errors until I run..
mangosd and realmd
I cannot connect.
World Database: 127.0.0.1;3306;root;gibbs;aiden
It says unknown DB aiden
Any ideas on whats wrong?
NM sorry, I got it. Thanx again reaper
-turwon
i got that too and where you have aiden, i changed it to mangos and it connected but now it's telling me i have an outdated DBC
hi i cant get my DBC files to work plz help .. when im going to locate my DataDir it cant finde my DBC files . and i have put maps, vmaps and DBS in same folder but when i try to locate that map it says ''The system cannot find the path specified. DBC directory dos not existe'' and as i sed map, vmap and DBC are in the same folder
Hi reaper,
I cant find the reaper-x-mangos.bat inside the reaper-eazy-mangos folder for reaper mango 5225 version, please advice, thanks...
hey mate good guide tho i am having alot of trouble working out mangos like where do i find the installation file i have looked all over this site and cant find plz get back to me throuhg my email
I'm still having problems with mangosd.exe. It didn't connect before, but now i get it to work by changing the database on the CONF File to Mangos on LoginDatabaseInfo, WorldDatabaseInfo, and CharacterDatabaseInfo so they all say "127.0.0.1;3306;username;password;Mangos", but now i get to:
Loading Auctions...
SQL: SELECT 'itemguid','item_template' FROM 'auctionhouse'
query ERROR: Table 'mangos.auctionhouse' doesn't exist
SQL: SELECT COUNT FROM 'auctionhouse'
query ERROR: Table 'mangos.auctionhouse' doesn't exist
can anyone help?
Hey I need help!!!. I jave installed and reinstalled mangos several time. I have even gone as far as doing my whole system just to make sure every thing was strate. I have every thing done no errors it seems to be running. then when I try to connect it can't I have changed my ip addres port # and I can get as far a authenticating and it stops.
I have gone from ip 127.0.0.1 to 192.168.1.100:3306 or 8805 and I get the best respons from port 3306 please help I don't know where I have messed up or what I need to change. I have followed you instuctions to the letter I even printed them out.
but now I have(had) the server running, but after dying at a boss in SSC, I cannot rezz, so I tried to .ressurect, but I kinda ressurected but then died again, then mangosd crash when loading character corpses, and everytime I try to start it it crashes again. I tried getting a new mangosd but it didn't work. How do I delete/fix/move characters?
i have a problem...
i can only create one char... if i create 2 or one of my friends login my char desapear and we cant create another...
im running windows vista sql 6.0
Hey im having a problem with the first step when i put my sql directory in it doesnt come up with options 1, 2 , 3 etc..
By-passed that problem now im having problems with it saying it cannot locate my dbr files in my wow/data but ive checked and double checked and triple checked and its there,
ok my past 2comments make no sense really, when i start from putting in my SQL link, from there everything goes different from what the instructions say wayy different and im not sure if its something im doing or if its supposed to do that, once i just kept clicking enter and i got me through the "matrix thing lol" and then when it camt to puting in for where the DBC is it said it wasnt there but im purdy sure that ive gone 100% wrong from the begining becouse its all so different to the instructions..
I'm having trouble running my mangosd.exe, it shows a quick error that I can't type in here real quick but it says that it can't find config file.
im getting an "unable to connect" message from WoW, my realmlist.wtf is "set realmlist 127.0.0.1"
Whenever i try to run Mangosd.exe it says cannot connect to world database.
Anyone know the reason why? or why it could be?
thanks much.
I fixed #5, but now i got this one:
Check existing of map file 'C:/WoW/maps/5301243.map' not exist!
I personally checked and in the maps directory there isn't file with that name...
I'm using GB version...
I get 'Could not connect' when trying to log in. both mangosd.exe and realmd.exe start up and run with no problems.
What could be wrong? I know other people are having this same problem
Thanks
Hey there. sorry to bother you
i saw your problem about the "Loading auctions"
error and i have the same problem.
Have u sorted it yet?
If so how?
Thanks alot
Sam
Man, you´re the best ! My mangos server is great ! But the draenei and blood elf are not available to choose ... can u help me with this ??? i have the 2.3.3 wow version. the others characters are ok !
thanks a lot
Sorry i forgot to said that i´m using the 5225 version. (Draenei and Blood elf not available , i can see the icons but can´t choose then). Thanks for help !
# Fred
Did you type :
setbc youruseraccountname 1from the mangosd window ;)
# Sam
Could you describe the problems (what kind of error message you get, etc) a little bit more? :)
# Marco
Do you have Burning Crusade expansion pack installed?
Hi reaper,
I cant find the reaper-x-mangos.bat inside the reaper-eazy-mangos folder for reaper mango 5225 version after extraction, please advice, thanks…
Reaper. I am still having that prob. with the server getting stuck in " authenticating" user name and password. how do i fix this.
Reaper - Bravo and thanks as always - I'm getting to the Realm Selection screen and my Realm is showing up as "Offline"? Any help on what I could be forgetting? Thanks.
umm... hi i have a problem trying to run mangos.exe and realmd.exe, when i try to run them they say can not connect to mysql DB and can not connect to my character DB can u help me out plz
nvm i made it work now the only problem is that it wont let me create a new character
Can someone help PLS.
Whatever i do(when i try to update)error comes
1061.
What i should do?
I have my server running smoothing.. for everyone else connecting =/..
When I try to connect locally I get to the Realm Selection screen.. select my server, it tries to logon to it for a second then goes back to the Realm Selection screen.
Does anyone know how to fix this?
anyoneknow why i can't create a new character it says something about taxi column not being identified
Im getting the same error as nabojka, whenever i try to update I get
ERROR 1061 (42000) at line 1: Duplicate key name 'guildid_key'
Anyone know how to fix?
Never mind fixed it =)
Guys, I was getting access denied to localhost when I ran the mangos.exe but I created a new mysql user choosing option 8 after running reaperxmangos.exe. It created a new user just for mangos and it worked. I was stuck on access denied for localhost but got it working after running this step.
heya man, excelent job, :D awsome server...
but theres one thing..is it possible to launch this server online for other peopli like friends..?
if it is could u please jjust tell hwo if u dont mind...
I got to the point in the config were it asked me were my Datadir is located ( the one were i put vmaps, maps, and dbc in) and i typed in the correct path c:\WoW\data and it said
Your maps directory missing important file, try re-extracting the maps again. I opened the maps folder and it has nothing in it, did i do somthing wrong on extraction?
I got to the point in the config were it asked me were my Datadir is located ( the one were i put vmaps, maps, and dbc in) and i typed in the correct path c:\WoW\data and it said
Your maps directory missing important file, try re-extracting the maps again. I opened the maps folder and it has nothing in it, did i do somthing wrong on extraction? I redid the extracting and it took about half a second, it made a new maps file and that one is empty too.
LOCK TABLES `creature` WRITE
--------------
--------------
/*!40000 ALTER TABLE `creature` DISABLE KEYS */
I get this and it doesn't continue :(
hi reaper or anyone,
can help me, i am not abl eto find the reaper-x-.exe file in my folder. is there any way i can download some where? thanks..
#Edan did you check the reap-easy-mangos folder?
REAPER/ANYONE HELP ME, my mangosd and realmd will not launch please help!!!!!!
I cannot get mangosd or realmd to connect to world database. How do I fix this?
I could not connect to mysql database..says access denied.
Ok lol Everything I did now was correct...how do I connect to the server? I went to wow launcher and It is unable to connect and it shows no realm. I have changed the realmlist to set realmlist 127.0.0.1 so I'd like to know how to connect. Which programs must be running in order to connect?
I'm able to login and view the realm list and my server show online but when I double click it to connect it immediately drops me back into the realm list. No errors and nothing stands out in any log files. I noticed a couple of other people having problems after what appears to be a successful install too.
someone please help me , my mangosd.exe and realmd.exe will not open. It opens then closes like a second later. Cant read wut it says . Someone please help.
The installation was succesful but when I tried to run the mangosd.exe and the realmd.exe
the mangosd.exe doesn't load up all the way
An SQL ERROR: Table 'realmd.realmlist' doesn't exist
=========================================== 100%
>> Loaded 443 MaNGOS strings
Initialize data stores...
=== SQL: UPDATE 'realmlist' SET 'icon' = 1 WHERE 'id' = '1'
SQL ERROR: Table 'realmd.realmlist' doesn't exist
=========================================== = 96%
Some required *.dbc files not found or not compatible:
C:\WOW\data/dbc/ItemExtendedCost.dbc Wrong client version DBC file?
That's just on the mangosd.exe
The realmd.exe says:
Using configuration file realmd.conf
MaNGOS realm daemon /0.10.0-SVN
to stop.
Daemon PID: 3744
Database: 127.0.0.1;3306;root;root;realmd
MySQL client library: 5.0.54
MySQl server ver: 4.1.22-comunity-nt
SQL: SELECT 'id', 'name', 'address', 'port', 'icon', 'color', 'timezone', 'allowedSecurityLevel', 'population' FROM 'realmlist' WHERE 'color' != '3' ORDER BY 'name' query ERROR: Table 'realmd.realmlist' doesn't exist
No valid realms specified.
Everything went smoothly at the beginning, and then when i tried to run these two the above errors come up. Please help me.
I've already tried uninstalling and deleting all directory files and started all over from the installation and patching up of the World of Warcraft directory files and folders, and tried reinstalling ReaperMangos5225
To Alucaris,
I have check the folder, but there's no .exe or .bat file in the folder. Is there anyway i can download the exe or bat file? pls advice, thanks.. edan
um theres a link on this site to the download the vmaps and maps, but it's from megaupload.com, witch means if your not a member you can only download one thing. so if you downloaded before it won't work, if you havent then go to the upper right of this page and click the reaper mangos 5225 - easy wow 2.3.3 private server link and find the download link
can some one tell me what is inside the maps folder their map extractor created. cause mine always makes an empty folder and when i try to configure mangos it says that the maps folder is missing an important file so if someone could please tell me whats in theirs i would be greatly appreciative
@Jon C.
u need to make a database in SQLyog called realmd and right click on it > import batch file > go into the reaper folder and click realmd
god ppl are stupid as hell, u wouldnt believe how many times ive answered that one
@Chris
u need to go to the reaper folder and run them
if your using a shortcut it wont work
or if that doesnt work
tell me exactly where the reaper folder is (the one that is ReaperMangos5225) and i can tell u how to run it a different way
To Chris:
my reaper easy mangos folder is inside a folder named private server on my desktop,I opened the tools folder opened map extractor and dragged the two files there into my world of warcraft\data\enus folder and ran the extract-map, it flashes across my screen at light speed and makes an empty maps folder in the same directory
um, ugh i'm not sure why i wrote to Chris on there, guess i'm tired
Ok i finally fixed my maps problem and now i'm to the part when i run mangosd.exe when i run it it tells me the following error
Daemon PID: 1024
World Database: 127.0.0.1;3306;alucaris;aug81991;worldDB
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'alucaris'@'Localhost' to database 'worldDB;
Cannot connect to world database 127.0.0.1;3306;alucaris;aug81991;worldDB
I don't know what to do to fix this
im stuck on the last part i dont know where to put my pass and everything i ran both programs but dont know how to get to last screen
ok i have redone EVERYTHING like 4 times... like literally 18 hours of my time gone into trying to get this to work:p and im stuck on trying to tell it where the datadir is at(where vmaps, maps and dbc is at) which is the data file C:\WoW\Data and it gives me "DBC Directory doesnt exist make sure to put/copy/move the DBC directory into C:/WoW/Data" which i have its there i checked i have done everything i can think of and redone this intire thing over from start to finish coming up with this =/ please tell me how to fix this thanks a ton:D
ok the probelm that i keep comgin up with is durring a fresh installation. i got all of the files that i need in the right places, but when i choose '1' for the installation and then '1' again for unified database, it says, "the system can not find the fie specified" X2 then "please wait it'll take a while to import the database" and "press any key to continue..." after i find the "any key" it goes to the next screen it says "generating default configuration file...etc etc..." then it says "file not found" X5 "press any key to continue..."
it offers to create another username since i'm using the root account as the default. i tried both yes and no. nothing changes. this is as far as i can get. i'd like to know how to set this up because i'm going back to iraq soon and the satelite internet there is horrible.
i've also tried some of the other builds of mangos and same with all except 4875. but i still can't run TBC on that build. i did, however, get as far as setting up a server on my computer, i couldn't get WOW and mangos to communiate. wow said something about "cannot verify this version of wow. please contact some dumbass at blizzard etc etc"
if anyone knows what's going on here, please let me know. i'm on MSN all the time. feel free to IM me. sereicikas@hotmail.com
well every thing went of with out any errors but i cant log in to wow but i did change my realm list to what it needs to be and still cant log in.
i wish there was a chatroom on this website. even a java-based one for live chats about mangos-topics
Reaper-X thank you for your great job of making this. The guide is great! It was so easy with your guide to complete my own server :D
What also would be nice is a guide to create portals to other citys at the entrance of each city. Maybe there allready is such a post but i havent seen it yet :D. But really thnx for all your work.
Greet Rai
I have a problem with number 7 when i go into both programs it says Could noy connect to MySQL database at 127.0.0.1: Access denied for user 'mangos @ localhost
"Cannot connect to world database 127.0.0.1;3306;mangos;mangos;magos
I followed the answer to part 7 but the mangos.conf file is PDB i have been trying to fix it btu no luck any suggestions?
Its in PDB file format but the file is CONF but i cant access it everytime i go to access it, it says select a program you wish to open it with... any suggestions on how i can repair this file to its original format?
you can contact me on my email Nath_boy1993@hotmail.com, thanks
Reaper i opened the file in notepad and did what it said and still it comes up Check existing of map file 'C:/WoW Server/Reapermangos5082/data/maps/0004331.map': not exist! Correct *.map files not found in path 'C:/WoW Server/Reapermangos5082/data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file if you can contact me my email is Nath_boy1993@hotmail.com ASAP as i am going away for a few weeks and need something to keep me entertained on my laptop..
ok i need help from the very start :S
So if iv got Windows Vista, for MySQL community Service do i need Windows Downloads or Windows x64 downloads? and also, say it was Windows x64, do i need Essentials, ZIP/setup.EXE, or Wihtout installer?
thx for ur time to help a stupid dimwitted person :)
Reaper i am in dire need of help here, when i go to extract the Map directory files it only creates the map folder and theres nothing in it... and the
extract-map program stays up for 2 seconds then goes out and then a map file appears with nothing inside it, i need help because i have every other file put it a certain place i just need to know why it is only creating the map folder.. and not the files in it..
i followed where to create them and it says my maps directory is missing an important file i only need that one important file but i don't know what it is i have re-extracted it serveral times adn it still is missing the important file i only need this answered in order to continue to make my GM accoun
i cant find the Reaper-x-mangos.exe file anywhere in this directory.
can somebody please help me.
*sighs* I did everything steveya | Jan 31, 2008 at 2:47 / 2:47 AM | Links to this comments | Reply
#Everyone that needs help with number 5
Here’s what to do (copied from an email i sent a few days ago):
Open up mangosd.conf which is in where you saved reaper-x mangos and look for:
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “”
and
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database - use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;mangos;mangos;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;mangos;mangos;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;mangos;mangos;characters”
On the first one, where it says:
DataDir = “”
put in the “” where youve saved the extracted vmaps, maps and dbc files.
On the second one, where it says,
LoginDatabaseInfo = “127.0.0.1;3306;mangos;mangos;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;mangos;mangos;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;mangos;mangos;characters”
change:
= “127.0.0.1;3306;mangos;mangos;realmd”
= “127.0.0.1;3306;mangos;mangos;mangos”
= “127.0.0.1;3306;mangos;mangos;characters”
into
= “127.0.0.1;3306;root;password;realmd”
= “127.0.0.1;3306;root;password;mangos”
= “127.0.0.1;3306;root;password;characters”
Where root is the database username (default root) and the password is the database password (what you used when configuring MySQL).
In realmd.conf look for:
LoginDatabaseInfo = “127.0.0.1;3306;mangos;mangos;realmd”
(it may not say mangos;mangos on either of these so look for the words/numbers around it)
and change it to:
LoginDatabaseInfo = “127.0.0.1;3306;root;password;realmd”
with the same rule as before. For scriptdev2.conf look for
ScriptDev2DatabaseInfo
= “127.0.0.1;3306;root;password;scriptdev2
and change using the same rule as before.
Sorry if its hard to follow, email me at steveya@hotmail.co.uk if your confused.
Steve said and it still cant find the DBC file it does not exsist. can someone Please help me iam pososit i have the dbc folder in the wow data.. me's really need help
IF i try to log on to WOW then i get this message:
,,Unable to connect to realm list server''...
Awnser in a post or mail Cyber-Kurt@hotmail.com, Please..
CyberKurt (Cyber-Kurt@hotmail.com)
#RanDT
Email me for more help, it's easier that way: steveya@steveya.tk
Steve
sorry for the double post:
email me at the other one that's said if you want to instead. i don't mind
ok ok someone plzz put on the forum how to really fixx the error 4331 C:/WoW Server/Reapermangos5082/data/maps/0004331.map’: not exist plzz
i got a problem when i run the Reaper-x-Mangos.bat
in the reaper-eazy-mangos and i choose write my password and then it says unknown Database 'Realmd' and then i can choose the silvermoon project thingy and the UDB and i choose silvermoon
and it says unknown Database 'Mangos' plz help
Hai! I have a problem. I am using 5472. When I open reaperx-eazy-mangos.exe, I get an error - "/F was unexpected at this time"... I am getting this when I run it thru command prompt. When I double click the file, it just flashes a black screen and closes...
Please let me know what I am doing wrong...
Thanx
hey, does anyone know why i get this strange error when i run the reaper-x-mangos exe? "/F unexpected at this time"... very 5472 and 5225
ok i have done this before on another computer but im having trouble with this one. when i try to configure mangos and i have to type in the data directory i type in
C:\Program Files\World of Warcraft\Data
then is says
DBC Directory doesnt exist make sure to put/copy/move the DBC Directory into C:\Program Files\World of Warcraft\Data
someone plz help.
ok well i moved the whole data folder ino C:\ instead so now it work for configuring but when i try to run mangosd and realmd is doesnt work.
ok i think i figured out some stuff and now the realmd works when i start it but the mangosd just goes away instantly when i double click it. wat is the problem?
Reaper-x
First and mostly thanks for all your time and effort that went into making this. it rocks!
I used your guide and all's well except my fave char, the Warlock!
2 problems:
1. Soul Link does not work! Am I doing someting wrong? I went to lvl 70, got all my pets, learned them all the spells, and speced my Demonology tree to soul link. The game requirement is lvl 40 for Soul Link. When I cast it, the aura does not apply to my char.
2. Demonic Embrace also does not show up on my char. Both these are Talents that you aquire as you move up the lvling ladder. They are very important for the lock build.
Any ideas?
Mangos version 5472
wow client 2.3.3
any feedback or ideas would be much appreciated!
Reaper-X
Thx a mil for great server!
Got everything up and running, only one little prob; I can't choose a blood elf or draenei character. It shows but can't click on them!
It asked at one point; Enable TBC Expansion Pack? And I did, but it didnt work, thx again!
This whole thing is awesome. I am very excited about getting this going. Thank you Reaper for all the time and effort you have put into it - and also to the others who are knowledgable and willing to help people with problems...
I am an extreme novice, so I could really use some help as well...
I am on step 3 (didn't get very far yet obviously.. lol)
Instead of a list 1, 2, 3 to chose from, it asks me questions. I read the posts and used the default "root" but now, it is asking for my "root password"...
I have no idea what this is.. I never setup a password, and it will not go further until I answer this question.
I would appreciate any assistance...
Thanks!
Welp all in all great installation, everything appears setup correctly, I go to run WoW and it brings up the patching screen, patch is data\enUS\expansion-speech-enUS.mpq about 103mb, dunno if this is normal, maybe I have overlooked something. I have patched from 2.3.0 to 2.3.2.
Will have more details if i come across anything strange in my setup. Note the help with step #5 was great, got me fixed in about 5 mins. Thanks again.
Issue was resolved, after running a WoW Launcher.
Note, I see all the commands for GM's is there anything i need to do to make them work, i see .blah ect.. any key press needed?
looking for help. i can set the up the server fine and run all the programs and have 0 problems with it but once i run wow.exe and try to login it trys to connect and then just says "unable to connect". what am i not doing right?
Hello Reaper
Love ur guide but im going to set up server but i cant cause wen i use extract-map then it makes folder but wen i open it its completely empty
nvm i figured it out
but wen i start wow and try log on it wants me to get next patch
is there some special way i gotta start wow up or just the normal way??
ok, I keep getting a dll error, It says im missing
MSVCR71.dll and wont allow me to open the .exe's in the Mangos directory
Lol thats easy u just need the MSVCR dl
Here it is
http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71
Had my Server up running 100% yesterday but now it says wen i try start mangosd
Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL Server on '127.0.0.1'
Any help?
Everything is running fine. But when WoW goes to the Suggest a Realm page, No mater what I click on, there is no suggested realm.
My server is set up to be PvP atm.
Thanks.
Hey, every time I go to make a character it never shows up after I create it. Is there any chance you can help me with that? Thanks
Sorry to bother you but when i run mangosd I get the following errors.
Reaper Mangos 0.10.0-SVN (Revision 5472) | http://www.reaper-x.com
Daemon PID: 4492
World Database: 127.0.0.1;3306;root;removed;realmd
MySQL client library: 5.0.51a
MySQL server ver: 5.0.51b-community-nt
Character Database: 127.0.0.1;3306;root;removed;characters
MySQL client library: 5.0.51a
MySQL server ver: 5.0.51b-community-nt
Login Database: 127.0.0.1;3306;root;removed;realmd
MySQL client library: 5.0.51a
MySQL server ver: 5.0.51b-community-nt
Realm running as realm ID 1
SQL: SELECT version FROM db_version LIMIT 1
query ERROR: Table 'realmd.db_version' doesn't exist
Using unknown world database.
Using DataDir c:\wow\data/
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: c:\wow\data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
SQL: SELECT MAX(guid) FROM creature
query ERROR: Table 'realmd.creature' doesn't exist
SQL: SELECT MAX(guid) FROM gameobject
query ERROR: Table 'realmd.gameobject' doesn't exist
Loading MaNGOS strings...
SQL: SELECT entry,content_default FROM mangos_string
query ERROR: Table 'realmd.mangos_string' doesn't exist
==================================================== 100%
>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue
Reaper,
I upgraded my server to core 2.4.1 (running Silvermoon PSDBx11 2.4.1), The server works, loaded fine...but my characters database from 2.3.3 appears to be having some sort of version conflict, I am not sure as to how that is happening. This is a serious issue, and is setting back my server's relaunch date a tad bit. When my players log into the world server, none of their characters are visible, and the mangos world server reports "broken data" in the characters "data" field. That is the only thing preventing them from properly loading. The characters are all there inside of the database, and I was sure to back up the characters database prior to upgrading. I am completely stumped. Any thoughts? Please respond.
-Seige
hi all.
i'm kind created my own wow server by this guid, but i would like to know how to update server to version 2.4.1
i can't find any info about how to do that. so could someone help me with problem?
Reaper,
I resolved the problem myself, managed to correct my character database issue. =)
Phillip,
Make certain that your MySQL service is running, for it may have crashed. This occurs sometimes after the 2.3.3 server has been running for any great length of time, that I've noticed anyway. You accomplish this by right-clicking on your "My Computer" icon, and selecting "Manage". Once inside of your computer management window, locate "Services". Within the panel to the right, scroll down until you see your "MySQL" service. If it is already started, but your server is still not connecting to the database, try restarting the service. That should get it up and running pretty fast. There are other things that may be preventing it from connecting, but this is the most common one that I've encountered. Write back to this forum if you are still experiencing the same issue, and I'll help you troubleshoot it further.
-Seige
ok, now I fixed all my errors up till now. Now when I attempt to join my server on WoW it says invalid game version. any help?
Drizzt,
Your Client (not your server) is reporting that its version is *not* compatible with your server's version. For both the Client and the Server to work together, they *must* have the same game version. For instance, if your server is version 2.4.1, but your Client is 2.3.3, and you have patching disable in your realmlist.wtf file, It will produce the very same problem that you are experiencing.
Here is the solution:
You have *one* of possible 2 things that need to be done in this scenario.
1. If your Client version is greater than your server version, you need to depatch your client. I can explain this process *if* it is necessary that you take this step.
2. If your Client version is lower than your Server version, you need to upgrade to your server's version.
Let me know if this solves your issue.
-Seige
I appoligize for the typoes in my last post, lol. Long day at work.
Corrections:
(I wish I could edit my post, honestly)
***patching disabled***
***2 possible (not "possible 2")***
well my Client is 2.4.0 or 1 or w.e
and the Server is whatever this is automatically set to
how do u make spells for tha database or edit it like adding a spell thet does 10000 damage?
ok, it works now, Thank you. and Reaper, Nice Job.
also, how would I set this up for a LAN?
Hi, i got everything runnig exept that i cant create users, i always get the same error message:
sql error: unknown column ´I´ in ´field list´
someone knows what i have to change? perhaps reinstall mysql? :)
or email me @ wiesel89@gmx.de
Drizzt,
You are very welcome. =)
-Seige
Another Question. How would I make this play over my LAN? and also.. Why the hell is there a lvl ?? imp at the blood elf starting area which kills me instantly?
The problem I'm having goes sort of along the lines as what I think Philip (in his comment on 4/25/08 at 14:40) had (with the exception that my server hasn't been functional yet). When I run mangosd.exe here is the problem that occurs, fairly early on:
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'xxxx' @ 'localhost' to database 'xxxx'
Taking Seige's advice I went into Computer Management and restarted MySQL, but this hasn't resolved anything for me.
I'd greatly appreciate help with this :)
I tried to install this last night, and I got a few error messages, and some things didn't look even remotely like this guide, so I winged it in a few parts, and that didn't work, so I'm asking for help now... First problem is on step 4, my menu does not look anything like that, but I push 1 anyways, and then I get 2 options, Unified Database and Project Silvermoon, which should I choose, and after that(I picked UD), I get 5 error messages saying
Unhandled Exception:Cannot Print Exception string because Exception.ToString failed.
and a popup saying RXFind has encountered and error and must close for each one.
hwo do you install mangos itself... when i got it fromt he website provided it dl as a .rar file and you cant open it... plz help.
you use winrar to extract those files... but where did you get yours? cause one of us got the wrong file then... cause mine came as a .exe
Greetings,
Spent about 2 hours setting up SQL and going through the walkthrough on how to set this up, extracted all maps, vmaps and DBC put them in a folder, ran the reaper easy mangos program setup all databases. Ran mongosd.exe as it said to and get this
2008-05-13 20:40:09 Using configuration file mangosd.conf.
2008-05-13 20:40:09 MaNGOS daemon /0.10.0-SVN (Revision 5472) (Win32)
2008-05-13 20:40:09 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
2008-05-13 20:40:09 Daemon PID: 3668
2008-05-13 20:40:09 World Database: 127.0.0.1;3306;mangos;john2005;mangos
2008-05-13 20:40:09 MySQL client library: 5.0.51a
2008-05-13 20:40:09 MySQL server ver: 5.0.51b-community-nt
2008-05-13 20:40:09 Character Database: 127.0.0.1;3306;mangos;john2005;characters
2008-05-13 20:40:09 MySQL client library: 5.0.51a
2008-05-13 20:40:09 MySQL server ver: 5.0.51b-community-nt
2008-05-13 20:40:09 Login Database: 127.0.0.1;3306;mangos;john2005;realmd
2008-05-13 20:40:09 MySQL client library: 5.0.51a
2008-05-13 20:40:09 MySQL server ver: 5.0.51b-community-nt
2008-05-13 20:40:09 Realm running as realm ID 1
2008-05-13 20:40:09 Using PSDB X9 SD2 297
2008-05-13 20:40:09 Using DataDir D:\WOW/
2008-05-13 20:40:09 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-05-13 20:40:09 WORLD: VMap data directory is: D:\WOW/vmaps
2008-05-13 20:40:09 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-05-13 20:40:09
2008-05-13 20:40:09 Loading MaNGOS strings...
2008-05-13 20:40:09
2008-05-13 20:40:09 >> Loaded 460 MaNGOS strings
2008-05-13 20:40:09 Initialize data stores...
2008-05-13 20:40:09 ERROR:
Some required *.dbc files (6 from 51) not found or not compatible:
D:\WOW/dbc/BattlemasterList.dbc (exist, but have 33 fields instead 32) Wrong client version DBC file?
D:\WOW/dbc/ChrClasses.dbc (exist, but have 58 fields instead 24) Wrong client version DBC file?
D:\WOW/dbc/ChrRaces.dbc (exist, but have 69 fields instead 35) Wrong client version DBC file?
D:\WOW/dbc/CreatureDisplayInfo.dbc (exist, but have 14 fields instead 21) Wrong client version DBC file?
D:\WOW/dbc/Map.dbc (exist, but have 125 fields instead 123) Wrong client version DBC file?
D:\WOW/dbc/Spell.dbc (exist, but have 213 fields instead 211) Wrong client version DBC file?
Any help?
Kind Regards
-Isaa
Chris: I think that your MySQL isn't operational, have you tried restarting your computer? I was having that error for a bit. Other than that, maybe try reinstalling MySQL. Maybe you didnt set it up properly, set up your MySQL exactly as Reaper Says. I tried differently and it messed up like yours. Try reinstalling
Isaa , From what I can see your DBC files arent the correct ones? Did you get your DBC files from the game after you updated? If not you should extract them from your updated WoW and then retry. If that doesnt work idk what will
any info on how to upgrade the server from 2.3.3 would be greatly appreciated. I have all the files necessary to make the server 2.4.2 but I'm not sure what to do with them as they came with no read me or instructions of any kind.
Roadmin.net FTL
Hey Reaper- guess who! I decided to take another crack at this, and I almsot had it! Only problem is Mangosd.exe crashes when it hits exactly 86% while initalizeing Data Stores. Happens every time, not sure what to do with this one!
Please help im on the verge of giving up. I cant find the reaper-x-mangos file in the reaper-easy-mangos file.
I have tried installing the mangos 4 times now and avast keeps telling me it's a trojan virus... Little help?
Hi,
i have a problem installing everything there is no reaper-easy-mangos.exe or .bat in the folder can anyone help me plz i tryd useing one out of an older version but this didnt help, simply got some errors.
Many thnx in advance
Chris
First of all thanks so much for the outstanding program and guide!!!
I got everything to work (including playing the game) except for when I run reaper-x-mangos.bat and select option "[7] Installs the Optional GM Island Vendors!"
When I choose this option and enter the required info I get the "Matrix" screen followed by:
Error 1136 (21S01) at line 24: Column count doesn't match value count at row 1
I'm using "mangos" for the MaNGOS/World database name, which I assume is correct, but I'm not sure.
Thanks for any help!
@zippy
thats cuz the custom vendors are only for the PS DB which reaper conveniently didn't include in the release
That makes sense. Thanks!
alright im having a problem with 5 once i get to the datadir path, i have DBC's directory in my wow folder but it still cant find it. Help!
Tsuki, I'm havin the same issue. I recently upgraded nortin anitvirus, 2007 version let me do it just fine, but 2008 says its a trojan. I'll check if theres something I can change in settings, but just letting everyone know.
i did everything from installing MySQL to running reaper mangos and everything goes fine until i run mangosd.exe and realmd.exe
when i run those two i get the same error on both "cannot connect to database" plz if anyone knows how to solve this educate me.. btw i've already tried the solution given to /beg
hi, I downloaded the repack but when I get to step 5 I cant find option 4 (mangos config editor), and when I try to run mangosd.exe and realmd.exe I get the same problem as jay that it cant connect to database... could you please help me?
Keep up the good work (Y)
Thanks,
Prevas
Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
Loading Item Texts...
==================================================== 100%
>> Loaded 0 item pages
Loading Creature Model Based Info Data...
==================================================== 100%
>> Loaded 16891 creature model based info
Loading Equipment templates...
==================================================== 100%
>> Loaded 1874 equipment template
Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there sh
ould be 65 fields in sql).
@Prevas
If you don't have the config option, you'll need to edit your config files manually, meaning that you open the .conf files with notepad, then change the password to your MySQL password.
I hope this helps, I don't have enough patience for listing all options in the configs. :P
@ fox
Same exact problem here fox. To the letter. We have both obviously missed the same thing.
" Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql). "
Okay...I'm a n00b....found the fix...gonna try it...had the file on my hard drive allready, just hadn't run it yet, didn't think it would be the 'fix' to my problem. ..and I quote, from the website:
"Apply Bug Fix 1 if you are having problems with creature templates, etc."
Conviently located at:
http://www.reaper-x.com/2008/08/01/reaper-x-ur1-arcane-fire-243/
@Jones
Thanks a lot m8, it did work and the server is running.
when i fished make my server then i runed my magosed.exe it says(you have outadted dbc files. please extract correct version from current using client)
outadted=outdated
I'm having an issue with reaper-x-mangos.exe. I'm using vista 64 bit and when i type in the path for my MySQL directory, it just closes and nothing else happens, am i missing something?
I would like to know how to correct the 'broken data' in the characters table. If I knew that I would be completely okay! plz help me.
Problem with Mangosd
Extracted dbc files multiple time
World Database: 127.0.0.1;3306;mangos;mangos;mangos
Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Realm running as realm ID 1
Using unknown world database.
Using DataDir C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMan
gos4535/Data/
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is: C:/Documents and Settings/Zachary/Desktop/Private
Server/ReaperMangos4535/Data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Initialize data stores...
========================================= = 80%
Some required *.dbc files (7 from 38) not found or not compatible:
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/BattlemasterList.dbc (exist, but have 33 fields instead 32) Wrong client vers
ion DBC file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/ChrClasses.dbc (exist, but have 58 fields instead 24) Wrong client version DB
C file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/ChrRaces.dbc (exist, but have 69 fields instead 35) Wrong client version DBC
file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/CreatureDisplayInfo.dbc (exist, but have 14 fields instead 21) Wrong client v
ersion DBC file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/ItemExtendedCost.dbc (exist, but have 14 fields instead 13) Wrong client vers
ion DBC file?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/Map.dbc (exist, but have 125 fields instead 123) Wrong client version DBC fil
e?
C:/Documents and Settings/Zachary/Desktop/Private Server/ReaperMangos4535/Data/d
bc/Spell.dbc (exist, but have 216 fields instead 211) Wrong client version DBC f
ile?
ok I need help whenever I try to run mangosd and realmd it sais unable to connect or whatever.
Cannot connect to database.\
Help plz?
same here as i open up mangosd.exe and it says;
World Database: 127.0.0.1;3036;myusername;mypassword;worlddb
Could not connect to MySQL database at 127.0.0.1: Can't connect tp MySQL server on '127.0.0.1' (10061)
Cannot connect to world database 127.0.0.1;3036;myusername;mypassword;worlddb
and when i open up realmd.exe:
Daemon PID: 3680
Database: 127.0.0.1;3036;myusername;mypassword;realmd
Could not connect to MySQL database 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
Cannot connect to database
I need serious help with this, any help will be greatly appreciated!
When I open mangosd.exe I get the same error I have seen on about 5 previous posts.
2008-09-28 09:52:55 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2008-09-28 09:52:55 ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
I have configured the mangosd.conf file and added in the Data dir and I have also tried re-installing three times all to no avail. Can someone look into this problem because I know a lot of other people have it too.
TO: DanielRabin
I ran into the same problem. My password was set incorrectly. Make sure the password you put into mysql and the password in the mangosd.conf file is the same. Read the blurb at the beginning of the mangosd.conf file to figure it out. good luck. you also have to keep mangosd and realmd running while you launch wow.
I get the same as Zafara except ihave just the one. Some required *.dbc files 1 from 55 not found or not compatible: C:\program files\world of warcraft \data\dbc\Spell.dbc wrong client version DBC file?
Just cant figure this out any help would be greatly appreciated,so close.
Hi I get MaNGOS realmd can not bind to 0.0.0.0:3306 when I try to run realmd and I get this when I try to run mangosd
World:Vmap config keys are :vmap.enableLOS,vmap.enableHeight,vmap.ignoremapids, vmap.ignorespellids
Check existing of map file ' C:\Program Files\World of Warcraft\World of Warcraft/maps' or *.vmap/*vmdir files in C:\Program Files\World of Warcraft\World of Warcraft. Please place *.map/*.vmap/*.vmdir files in appropriate direcotires or correct the DataDIR value in the mangosd.conf file.
I think the MangosD problem is that it's looking for C:\Program Files\World of Warcraft\World of Warcraft/maps when it should be a backlash email is st.louis26@hotmail.com please post on my problem thanks.
I set up Repack Arcane-Fire as said, and i put the update from Oatman Bug fix to fix the error with the characters, but i'm still getting the character error.
This post is awesome, nice work!