[Guide] Mangos Windows Setup

[Phenomenon]

When I get to step 3 and right click the folder, It doesnt say Git Gui. Any suggestions?

Open GIT through the Start menu then.

Start -> Programs -> Git -> Git GUI

Right, I have everything nice and set up. When I got to the step to load the realmd.exe and mangosd.exe, the realmd works fine, but on the other hand, mangosd seems to just pop up for less than a second, and then close. I'm not sure what's causing this.

Edit: I quickly took a screenshot of what the mangosd.exe is telling me. It says:

query ERROR: Unknown column 'requred_9924_02_mangos_command' in field list'

[0 ms] SQL: SELECT * FROM db_version LIMIT 1

The table 'db_version' in your [WORLD] darabase indicates taht this database is out of date!

[A] You have: --> '9763_01_mangos_battleground_template.sql'

You need: --> '9924_02_mangos_command.sql'

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder. Etc.

Anyways, I guessed I need to run the query '9924_02_mangos_command.sql' on the mangos DB. I tried that, and the result contained something like 'Query : ALTER TABLE db_version CHANGE COLUMN blah blah'.

Edit2: Just for more info, when I was creating the SQL connection in SQLyog, the results from the queries contained a lot of errors.

Just because the MaNGOS CMD window tells you to do 1 update doesn't mean that it should fix everything on it's own. Check your MaNGOS revision and apply all the newest updates. If you're lazy, then go on UDB and grab some update packs.

[Akele]

I'm confused as to how to do this. I've queried the updatepacks and corepatch that was located in the updates folder I created previously. Also, I'm not sure if the MaNGOS>Source>sql>Update files matter in this case? If so, which update file should I start from because I think each update needs a previous update in order to work.

[trademark]

I seem to be having a strange issue...

When my config files have their IPs set to 127.0.0.1 Everything on the server starts up and works great, i can login and play from the server as well.

However when i try to login from another computer on my network i can login and see the MaNGOS server but it will not load.

If i change the IP to the local IP 192.168.0.103, the server closes almost immediately after starting.

[Edder]

I tried to compile mangos with VC++2010, in Win32 and release or debug (doesnt matter) it works like charm, but for x64 arent all necessary project file in the project folder i guess?!

Only my local problem or are x64 files in the mangos folder missing?

@trademark: correct realmlist on the other computer?

with change ip, you mean change the BindIP from mangosd/realmd.conf ?

[Phenomenon]

I'm confused as to how to do this. I've queried the updatepacks and corepatch that was located in the updates folder I created previously. Also, I'm not sure if the MaNGOS>Source>sql>Update files matter in this case? If so, which update file should I start from because I think each update needs a previous update in order to work.

Look at the revision you downloaded (mangos database -> tables -> db_version), then look at the SQL updates. Apply every update after your db_version.

I seem to be having a strange issue...

When my config files have their IPs set to 127.0.0.1 Everything on the server starts up and works great, i can login and play from the server as well.

However when i try to login from another computer on my network i can login and see the MaNGOS server but it will not load.

If i change the IP to the local IP 192.168.0.103, the server closes almost immediately after starting.

Even though you're on a network, I believe you still need to forward the ports through your router. Don't quote me on that though, I'm no network expert

[Auntie Mangos]

Interesting guide, will check it.

[dexter2012]

Im sorry Im new to this. it seems when I add querys they seem out of date because they wont execute. From

"NOTICE:

This part is somewhat tricky and can be hard to explain, but I'll do my best. The updates must be done in proper order or else things can get messed up, so please follow the next steps carefully!

Go into your updates folder and open the first update pack, copy the contents, then paste them into the query box (similar to the ScriptDev2 query stuff we did earlier)

Take notice to which database needs to be selected; most update packs will be named in the following pattern: update#_patchtype_databasename_revision#_to_revisi on#, so for example 388_corepatch_characters_9311_to_9582.sql

Look at the database name part of the filename, this is the database that you need to select before pushing the play button (this is VERY important, in my example filename above I would have to select

the "characters" database)

Push the play button

Repeat the update steps above for every update pack that was downloaded

You may need to add additional updates depending on the progress of database content

You can check your database revision number by clicking the "+" next to the database name in the database list, clicking the "+" next to "Tables" then finding the corresponding table for each database:

Characters: Characters_DB_Version

Mangos: db_version

Realmd: Realmd_DB_Version

(click here for an image)

You can then click the "Tables" tab on the right of SQLyog (shown) to see the table information

Somewhere in the table information (there isn't much within the db_version tables, so look for it), there will be something that says "required" in it, such as "required_9803_01_mangos_spell_bonus_data"

Go into your MaNGOS source folder then into the "sql" folder and find the required update (it will have the same name) and do all the updates after it (all the newest ones)

SQLyog will be disabled while running updates; when it is enabled again, you'll know that that's when the update has finished"

down none of the directions work. Where are the new databases that need to be executed?

thank you

[Edder]

problem solved, never mind...

[hitmandoug]

So i did everything and it all seems to work but i can't get Realmd.exe and mangosd.exe to run they come up for about 1 second and then disappear any suggestions?

[Edder]

What does the logs say?

Forgot any sql update or the mangosd.conf or realmd.conf in the binary folder? Or forgot to rename it?

[dani03]

Hello all... i got a problem. i did all but when i must do the updaes it say:

Query : -- 9339 ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group b...

Error Code : 1054

Unknown column 'required_9250_01_characters_character' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : ALTER TABLE groups ADD COLUMN `groupId` int(11) unsigned NOT NULL FIRST

Error Code : 1060

Duplicate column name 'groupId'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

(0 row(s) affected)

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

(0 row(s) affected)

Execution Time : 00:00:00:141

Transfer Time : 00:00:00:000

Total Time : 00:00:00:141

Query : ALTER TABLE group_member CHANGE COLUMN `leaderGuid` `groupId` int(11) unsigned NOT NULL

Error Code : 1054

Unknown column 'leaderGuid' in 'group_member'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : -- 9349 ALTER TABLE character_db_version CHANGE COLUMN required_9339_01_characters_group required_9349_01_characters_character_a...

Error Code : 1054

Unknown column 'required_9339_01_characters_group' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : ALTER TABLE `character_action` ADD `spec` tinyint(3) unsigned NOT NULL default 0 AFTER `guid`

Error Code : 1060

Duplicate column name 'spec'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : -- 9354 ALTER TABLE character_db_version CHANGE COLUMN required_9349_01_characters_character_action required_9354_01_characters_...

Error Code : 1054

Unknown column 'required_9349_01_characters_character_action' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

(0 row(s) affected)

Execution Time : 00:00:00:031

Transfer Time : 00:00:00:000

Total Time : 00:00:00:031

Query : -- 9359 ALTER TABLE character_db_version CHANGE COLUMN required_9354_01_characters_character_action required_9359_01_characters_...

Error Code : 1054

Unknown column 'required_9354_01_characters_character_action' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : ALTER TABLE `characters` ADD `specCount` tinyint(3) unsigned NOT NULL default 1 AFTER `power7`

Error Code : 1060

Duplicate column name 'specCount'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : ALTER TABLE `characters` ADD `activeSpec` tinyint(3) unsigned NOT NULL default 0 AFTER `specCount`

Error Code : 1060

Duplicate column name 'activeSpec'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : -- 9374 ALTER TABLE character_db_version CHANGE COLUMN required_9359_01_characters_characters required_9374_01_characters_charac...

Error Code : 1054

Unknown column 'required_9359_01_characters_characters' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : -- 9375 ALTER TABLE character_db_version CHANGE COLUMN required_9374_01_characters_character_glyphs required_9375_01_characters_...

Error Code : 1054

Unknown column 'required_9374_01_characters_character_glyphs' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

(0 row(s) affected)

Execution Time : 00:00:00:031

Transfer Time : 00:00:00:000

Total Time : 00:00:00:031

(0 row(s) affected)

Execution Time : 00:00:00:047

Transfer Time : 00:00:00:000

Total Time : 00:00:00:047

Query : -- Extract values from data blob fields and insert them into character_glyphs INSERT INTO `character_glyphs` SELECT `guid`, 0, 0...

Error Code : 1054

Unknown column 'data' in 'field list'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : INSERT INTO `character_glyphs` SELECT `guid`, 0, 1, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1320), ' ', -1) AS UNSIG...

Error Code : 1054

Unknown column 'data' in 'field list'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : INSERT INTO `character_glyphs` SELECT `guid`, 0, 2, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1321), ' ', -1) AS UNSIG...

Error Code : 1054

Unknown column 'data' in 'field list'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : INSERT INTO `character_glyphs` SELECT `guid`, 0, 3, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1322), ' ', -1) AS UNSIG...

Error Code : 1054

Unknown column 'data' in 'field list'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : INSERT INTO `character_glyphs` SELECT `guid`, 0, 4, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1323), ' ', -1) AS UNSIG...

Error Code : 1054

Unknown column 'data' in 'field list'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : INSERT INTO `character_glyphs` SELECT `guid`, 0, 5, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1324), ' ', -1) AS UNSIG...

Error Code : 1054

Unknown column 'data' in 'field list'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

(0 row(s) affected)

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

and I tried whit Heidisql and it say: SQL Error (1054): Unknown colum 'required_9250_01_characters' in 'character_db_version'

Please help me.. Have a nice day!!

[racs]

Is it really necessary to set patchs in visual c++ 2008? and what about the file to open, it's supposed to be the mangosdVC90 right?

[amidah2000]

i have a problem compiling scriptdev2 on vsc++ 2008 and 2010 ill try both version it give me an error like this:

Creating temporary file "c:\\MaNGOS\\src\\bindings\\ScriptDev2\\VC90\\ScriptDev2__Win32_Release\\BAT00000139162072.bat" with contents

[

@echo off

cd "C:\\MaNGOS\\src\\bindings\\ScriptDev2\\"

"C:\\MaNGOS\\src\\bindings\\ScriptDev2\\..\\..\\..\\win\\VC90\\genrevision__Win32_Release\\genrevision.exe"

if errorlevel 1 goto VCReportError

goto VCEnd

:VCReportError

echo Project : error PRJ0019: A tool returned an error code from "Extracting revision"

exit 1

:VCEnd

]

Creating command line "c:\\MaNGOS\\src\\bindings\\ScriptDev2\\VC90\\ScriptDev2__Win32_Release\\BAT00000139162072.bat"

Extracting revision

The system cannot find the path specified.

Project : error PRJ0019: A tool returned an error code from "Extracting revision"

Build log was saved at "file://c:\\MaNGOS\\src\\bindings\\ScriptDev2\\VC90\\ScriptDev2__Win32_Release\\BuildLog.htm"

ScriptDev2 - 1 error(s), 0 warning(s)

if anyone ghas any ideea pls pm me or write a mail to [email protected]

[Tryphen]

I just wanted to return a little something to the community as I have got so much from it.

I was curious how Blizz set up its 'Breaking News' dialog at the login screen...well I won't bother you with the details but can tell you that if you want your clients to see your 'Breaking News' then all they have to do is make the following entry in the hosts file (by default in the <WINDOWS>\\system32\\drivers\\etc directory):

1.2.3.4 launcher.worldofwarcraft.com

where 1.2.3.4 is the IP address of your server. Yes, unfortunately since what you are doing is redirecting the message request to your server, you have to use an IP and not a name, therefore if your IP changes you will have to instruct your users to update the file (I just provide a download of a hosts file on my webpage along side the realmlist.wtf sample)

A default hosts file looks like this:

# Copyright © 1993-1999 Microsoft Corp.

#

# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.

#

# This file contains the mappings of IP addresses to host names. Each

# entry should be kept on an individual line. The IP address should

# be placed in the first column followed by the corresponding host name.

# The IP address and the host name should be separated by at least one

# space.

#

# Additionally, comments (such as these) may be inserted on individual

# lines or following the machine name denoted by a '#' symbol.

#

# For example:

#

# 102.54.94.97 rhino.acme.com # source server

# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost

so you just have to add the line to the end like this:

# Copyright © 1993-1999 Microsoft Corp.

#

# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.

#

# This file contains the mappings of IP addresses to host names. Each

# entry should be kept on an individual line. The IP address should

# be placed in the first column followed by the corresponding host name.

# The IP address and the host name should be separated by at least one

# space.

#

# Additionally, comments (such as these) may be inserted on individual

# lines or following the machine name denoted by a '#' symbol.

#

# For example:

#

# 102.54.94.97 rhino.acme.com # source server

# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost

1.2.3.4 launcher.worldofwarcraft.com

Lastly, you create a file on the root of you HTTP server called 'alert'. A sample of mine is as follows:

<snip>

SERVERALERT:

May 3rd, 2010 21:05 MST

Levelling up my hunter...w8n for some company.

Staff At MyWoWServer

</snip>

NOTE that the first line must be as shown above: SERVERALERT: as the blizz parser looks for this.

I searched through the forum for this information and couldn't find it.

When I get some time I may add this funtionality to my DotNet app that can be downloaded to manage realmlists (similar to WoW FE) so that it can be enabled/disabled programmatically.

[Curious]

You should post this to general help or core modification. There is no good forum division for that but putting it here may low the visibility of your work.

[Tryphen]

Thanks mate, will do.

[jagler04]

I got mangos.exe running with no errors and realmd.exe as well but when i log into WOW it tells me that the realm is offline. Anyone have any suggestions?

[Spent]

Thank you for making this helpfull guide!

[Phenomenon]

I got mangos.exe running with no errors and realmd.exe as well but when i log into WOW it tells me that the realm is offline. Anyone have any suggestions?

Make sure that your realm is set to your WoW realmlist (so if you want to play locally, you need to set your realm's IP in your realmd database to 127.0.0.1 or localhost). Alternatively, it's possible that you have some kind of security blocking the connection to the realm such as a firewall or anti-virus.

[jagler04]

Make sure that your realm is set to your WoW realmlist (so if you want to play locally, you need to set your realm's IP in your realmd database to 127.0.0.1 or localhost). Alternatively, it's possible that you have some kind of security blocking the connection to the realm such as a firewall or anti-virus.

wouldn't the anti-virus and or firewall make it so that u couldn't even see a server online or offline? regardless of that there are no issues involving anti-virus or a firewall that can make is so that you see a server offline instead of online. I appreciate the possible issue but that has no bearing on a 127.0.0.1 server. as for the realmlist in WOW it is set to 127.0.0.1 or else i wouldn't see the mangos realm as offline.

[jagler04]

its all fine now i figured it all out after reinstalling and patching a few times, miss patch through it all off.

[conspicuous]

Hmm - Anyone else had an issue with the mangosd.exe?

2010-07-01 20:04:17 ERROR:Map file './maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.

2010-07-01 20:04:17 ERROR:Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

When I run I get the above. I've used the ad.exe tool again and copied over the ones I did earlier yet I still get the same issue in that area.

I have also moved vmaps into the mangos dir also so I currently have dbc, maps, buildings & vmaps in my mangos dir.

As for the second error I've taken a look at my mangosd.conf and the DataDir does = "."

Any ideas? ;(

==========================

Ignore the above. The reason why I was getting these is because I forgot I updated my WoW version to 3.3.5

Created a second copy of the WoW Dir and downgraded to 3.3.3 :-P

other than that silly little mistake of mine, everything else worked first time! Wicked Guide.

[barsken]

Thanks for this guide!

[scout]

Hello to everybody !!! I have a problem guys.

When I start mangosd.exe and realmd.exe seeing some errors in mangosd.exe window. Here is

Map file ' ./maps/0004331.map is non-compatible version <outdated?>. Please, create new using ad.exe program.

Correct *.map file not found in path './map' or *.vmtree/*.vmtile file in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.

My english is bad sorry for this. If you help me about it I'll be very happy. Thanks

i found this errors in Server.log

ERROR:Map file './maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.

2010-07-12 18:12:51 ERROR:Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.

I found and fix that errors thanks to everybody KKKBOOMS and I am very happy yaaaaaaaaa

[deimMudda]

very very good work!!!! with screenshots .. the best guide ever!!!!!! THANK YOU!