[Guide] Mangos Windows Setup

[davemm]

k everything is fine with database now.. but a new problem has occurred when i tried to execute "mangosd.exe" and "realmd.exe"

it says something like

C:\\ManGOS\\mangosd.exe

The NTVDM CPU has encountered an illegal instruction.

CS:126f IP:027b OP:63 79 3e 0d 0a Choose 'Close' the terminate the application

wat does this mean.. can u pls help me..

did you compile master branch?

are you running mangos on the machine you compiled on?

[warrior1988]

well i tried something made it execute but it is giving me some error such that it could not connect.. here it is..

i dunno y database is not getting connected.. but when i try connecting with SQLyog it is working and gets connected,

And one more thing i can find is.. i login SQLyog @ 127.0.0.1 and here i chcked the file mangosd.conf and it has 127.0.0.1 but y does it show in command as connecting root @ 'localhost' ?

and this is how my folder looks like am i correct??

[davemm]

mysql password would appear to be incorrect

[warrior1988]

can someone pls add me in ur messenger and guide me.. it will be soo helpful pls...

my windows live id : [email protected]

Google talk id : [email protected]

i really want someone to guide me...

[olliepop]

Im stuck on this part of the guide:

-Click the open button near the right of the dialog window, and make sure the path is:

Code:

C:\\Program Files\\Microsoft Platform SDK for Windows Server 2003 R2\\Bin

I cant find were this is located at. Can someone help me

I too have that issue. I can't find it in my program files.. i dont think it exists. Does that matter? If so, what do i do? Thanks!

[KGTM]

Hello everybody.

Long time no see since mangos was at "mangosproject".

Well i wanted to try out Wrath, so i came and did the usual, you know.

Complie.

Config.

etc..

But then it came the SQL problems as usual.

Note:

No compiler errors and warnings.

Win XP SP3 fully updated.

Nothing else then mangos stuff in the HD.

Conf files in the right place and properly configured.

Map extraction OK.

WoW + BC + Wrath 3.13

MySql server 5. Well configured and communicates with Mangos.

---

Then it came the database.

Well i've created the default databases (mangos, realmd, characters).

Then according to the manual i had to run the sql dump files in the Mangos Dir/sql directory.

So i did.

Everything ok.

Then i went to unifieddb to get the latest core (mangos) sql dump file.

Mangos Core SQL Dump: "UDB_0.11.5_Core_7681_SD2_1012.sql"

I've updated my mangos db with it.

No problems.

Then came the update part, updating the databases with sql dump files "related to my core".

List of files in the update folder:

Folder name: "0.11.5_additions"

"380_corepatch_characters_7682_to_7894.sql"

"380_corepatch_mangos_7682_to_7894.sql"

"380_corepatch_realmd_7682_to_7894.sql"

"380_updatepack_mangos.sql"

"381_corepatch_characters_7895_to_8029.sql"

"381_corepatch_mangos_7895_to_8029.sql"

"381_corepatch_realmd_7895_to_8029.sql"

"381_updatepack_mangos.sql"

"382_corepatch_characters_8030_to_8280.sql"

"382_corepatch_mangos_8030_to_8280.sql"

"382_updatepack_mangos.sql"

Updates to realmd and characters databases no problems.

But mangos as some problems.

This what i did for mangos db:

I've created mangos in mysql server. [OK]

Used "mangos.sql" in the Mangos Source folder to do a update from sql dump file to my mangos DB. [OK]

Updated my Mangos DB with the Core Sql Dump. [OK]

"UDB_0.11.5_Core_7681_SD2_1012.sql"

Then i updated the mangos DB with:

"380_corepatch_mangos_7682_to_7894.sql". [OK]

Then:

"380_updatepack_mangos.sql" [ERROR]

After many tries i managed to get a "solution" for the update.

I've deleted content from mangos DB.

And i skipped the part where i should use the "mangos.sql" form the SQL directory in the Mangos Source Folder.

Then updated my mangos with the core.

Then the update order:

"380_corepatch_mangos_7682_to_7894.sql"

"380_updatepack_mangos.sql"

"381_corepatch_mangos_7895_to_8029.sql"

"381_updatepack_mangos.sql"

"382_corepatch_mangos_8030_to_8280.sql"

"382_updatepack_mangos.sql"

That way, just by skipping the mangos.sql file the update process worked with no problems (at least SQLyog didn't repported any).

Then i was all happy.

I have started realmd.exe [OK]

Then mangos.exe [issues]

// Reported some SQL problems but mangos.exe was running.

Created my account on the game.

Started W*W;

Login;

Then i ways creating a new char, give her a name, the "Create".

He reported sucess. And went to the My Chars View.

And none char was there.

I've restarted W*W and still no char there.

I went to mangos and he reported some SQL errors, he could find the table "characters.character_battleground_data";

Here goes the DBErrors.log:

2009-08-24 21:55:47 SQL: SELECT version, creature_ai_version, cache_id FROM db_version LIMIT 1
2009-08-24 21:55:47 query ERROR: Unknown column 'cache_id' in 'field list'
2009-08-24 21:55:48 SQL: UPDATE character_battleground_data SET instance_id = 0
2009-08-24 21:55:48 SQL ERROR: Table 'characters.character_battleground_data' doesn't exist
2009-08-24 21:56:36 Table `achievement_criteria_data` not have expected data for criteria (Entry: 3680 Type: 76) for achievement 1157.
2009-08-24 21:56:36 Table `achievement_criteria_data` not have expected data for criteria (Entry: 9798 Type: 76) for achievement 2772.
2009-08-24 21:57:46 SQL: DELETE FROM character_battleground_data WHERE guid='1'
2009-08-24 21:57:46 SQL ERROR: Table 'characters.character_battleground_data' doesn't exist
2009-08-24 21:57:56 SQL: UPDATE character_battleground_data SET instance_id = 0
2009-08-24 21:57:56 SQL ERROR: Table 'characters.character_battleground_data' doesn't exist

Any suggestions?

[davemm]

you missed some character db sql updates somewhere.

[leone1]

You should use the characters and realmd sql dump in the mangos folder not the udb folder.Then update it as needed.I had same problem when using the characters and realmd sql from the udb folder.There is in fact a post that specifically says this on the udb forums http://udbforums.org/index.php?topic=12626.0

[cblair91]

*edit* managed to fix it *edit*

When i load the UDB onto my mangos database - i get the following error when i try to load mangosd.exe

2009-08-26 08:09:43 
2009-08-26 08:09:43 
2009-08-26 08:09:43 Loading Localization strings...
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 npc_option locale strings. DB table `locales_npc_option` is empty.
2009-08-26 08:09:43 
2009-08-26 08:09:43 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.
2009-08-26 08:09:43 >>> Localization strings loaded
2009-08-26 08:09:43 
2009-08-26 08:09:43 Loading Page Texts...
2009-08-26 08:09:43 >> Loaded 1625 page texts
2009-08-26 08:09:43 
2009-08-26 08:09:43 Loading Game Object Templates...
2009-08-26 08:09:43 ERROR:Error in gameobject_template table, probably sql file format was updated (there should be 39 fields in sql).

[cblair91]

I too have that issue. I can't find it in my program files.. i dont think it exists. Does that matter? If so, what do i do? Thanks!

With that error, sometimes microsoft changes that location to

C:/Program Files/Microsoft SDKs/*your sdk*/bin/

[cblair91]

Ok, I have seen here that many people are getting stuck on the databases part.

I have also, but now I found out how to work it.

follow the updates in the correct order!!!

Required files are all here:

http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/ForCleanInstallOnly/ - for first databases

http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/ Main core

http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.5_additions/ - updates

Open SQLyog: create the 3 databases:

mangos

characters

realmd

ok, now load the mangos.sql from the folder /ForCleanInstallOnly/

Load UDB Core onto that from the /Full_DB/

Load the updates from /0.11.5_additions/ in the following order:

[list]
* 380_corepatch_mangos_7682_to_7984.sql
* 380_updatepack_mangos.sql
* 381_corepatch_mangos_7895_to_8029.sql
* 381_updatepack_mangos.sql
* 382_corepatch_mangos_8030_to_8280.sql
* 382_updatepack_mangos.sql
[/list]

Select characters and load on the database charaters.sql from /ForCleanInstallOnly/

Load the following updates from /0.11.5_additons/ in the following order

[list]
* 380_corepatch_characters_7682_to_7894.sql
* 381_corepatch_characters_7895_to_8029.sql
* 382_corepatch_chatacters_8030_to_8280.sql
[/list]

Select realmd and load the database realmd.sql from /ForCleanInstallOnly/

Load the following updates from /0.11.5_additions/ in the following order

[list]
* 380_corepatch_realmd_7682_to_7894.sql
* 381_corepatch_realmd_7895_to_8029.sql
[/list]

Once you have loaded all them databases in correctly, make shure your mangosd.conf is set to the correct databases with correct mysql password and username.

Load mangosd.exe and it should run smoothly and the end process should look like this once it is done:

2009-08-26 08:38:38 >> Loaded 19 transports
2009-08-26 08:38:38 Deleting expired bans...
2009-08-26 08:38:38 Calculate next daily quest reset time...
2009-08-26 08:38:38 Starting objects Pooling system...
2009-08-26 08:38:39 Starting Game Event system...
2009-08-26 08:38:39 GameEvent 31 "Edge of Madness, Renataki" started.
2009-08-26 08:38:39 WORLD: World initialized
2009-08-26 08:38:39 mangosd process priority class set to HIGH
2009-08-26 08:38:39 
2009-08-26 08:38:39 

Run realmd.exe and it should look like this if its working:

2009-08-25 23:29:35 Using configuration file realmd.conf.
2009-08-25 23:29:35 Database: 127.0.0.1;3306;root;pombom;realmd
2009-08-25 23:29:35 MySQL client library: 5.0.56
2009-08-25 23:29:35 MySQL server ver: 5.4.1-beta-community 
2009-08-25 23:29:35 Added realm "MaNGOS".
2009-08-25 23:29:35 realmd process priority class set to HIGH
2009-08-25 23:29:35 

[leone1]

If you do the above instructiosn to the letter you do in fact get the same problem that KGTM stated. When you create a character it will not show up in your character list. You must use the characters and realmd sql dumps from the mangos source folder not the udb folder.The path will look similar to this

new folder\\mangos source\\sql\\characters.sql

new folder\\mangos source\\sql\\realmd.sql

This is in fact how the instructions are given on the udb forum post http://udbforums.org/index.php?topic=12622.0. You will not need to update the characters and realmd databases sicen the latest revision of mangos source is higher thatn the udb 382 update.

[KGTM]

You should use the characters and realmd sql dump in the mangos folder not the udb folder.Then update it as needed.I had same problem when using the characters and realmd sql from the udb folder.There is in fact a post that specifically says this on the udb forums http://udbforums.org/index.php?topic=12626.0

I've used mangos sql file dumps for "characters" and "realmd".

Then i've updated as long SQLYog stated no problems in the batch (from UDB updates).

But i will try to update as long it is needed, and i will report something.

Thks.

[cblair91]

If you do the above instructiosn to the letter you do in fact get the same problem that KGTM stated. When you create a character it will not show up in your character list. You must use the characters and realmd sql dumps from the mangos source folder not the udb folder.The path will look similar to this

new folder\\mangos source\\sql\\characters.sql

new folder\\mangos source\\sql\\realmd.sql

This is in fact how the instructions are given on the udb forum post http://udbforums.org/index.php?topic=12622.0. You will not need to update the characters and realmd databases sicen the latest revision of mangos source is higher thatn the udb 382 update.

you say you HAVE TO use the files in /sql/ folder correct?

i loaded everything from the udb server and its all working perfect and can connect fine.

[kageb0shi]

you say you HAVE TO use the files in /sql/ folder correct?

i loaded everything from the udb server and its all working perfect and can connect fine.

if you only loaded it from UDB then you're missing out on some DB fixes which are contained in the mangos/sql folder.

[marurder3]

When I finally got this far (it wasn't easy but from others problems I figured it out.

Creating the actual account

Code:

create [username] [password]

Example: create Phenomenon 123

This was for me account create test test, I wasn't expecting having to type 'account' at the start.

Enabling expansions for a user

Code:

setexpansion [username] [1 for TBC, 2 for TBC and WotLK]

Example: setexpansion Phenomenon 2

I cannot get this to work on account "test"

Changing GM levels

Code:

setgm [username] [anything from 0 to 3, 3 being administrator, 0 being player]

Example: setgm Phenomenon 3

I cannot get this to work on account "test" either, is there something I missed before?

Every time I get the "there is no such command"

I can log in on the account and make characters normally.

Thankyou for your time

Check that, I found the entry in SQL database and managed to fix both issues.

[leone1]

account set addon {1-2} <-----this sets the expansions

account set gmlevel {1-3} <------ this sets the level of the account 1 being just user up to 3 being gm

If you type account and hit enter it will show you the list of options.Then type account set press enter it will show you the rest of the options.

[Phenomenon]

Thank you, I'll update it right now. Since I play retail WoW a lot, I actually haven't really been into private servers lately since Mangos doesn't yet have support for 3.2.

[metis]

One problem I am having and I have not seen the answer to it in all the posts is the difference between "Source" folder and "Core". In the instructions you tell how to make the "source" folder but you say nothing about the location of the "core" folder. I have copied the .exe, and .dll files into a parent directory to the source directory for now... I can't find the .pdb files though.

Also, instructions dictate moving the .exe, .dll, AND .pdb files FROM the Source folder TO the Core folder... thus they are (if I am interpreting it correctly) different folders... Am I way off base?

Did anyone ever reply to this...I'm stuck here also for same reason....please help!!

[coorah]

sorry you guys for taking up space (this is edited) i fixed my problem

[robuss]

hi i have rev 8480 db_version Mangos default database. whene i whant to update to rev 382 its shows some error and it won't open mangosd can somebody help?

thanks

[davemm]

hi i have rev 8480 db_version Mangos default database. whene i whant to update to rev 382 its shows some error and it won't open mangosd can somebody help?

thanks

that would depend rather on what the error is. My crystal ball is broken unfortunately.

[robuss]

that would depend rather on what the error is. My crystal ball is broken unfortunately.

so this is the erro SQL: SELECT required_8462_01_mangos_creature_ai_texts FROM db_version LIMIT 1 query ERROR: Unknown column 'required_8462_01_mangos_creature_ai_texts' in 'field list Table `db_version` have field `required_8254_01_mangos_spell_proc_event` but expected `required_8462_01_mangos_creature_ai_texts`! Not all sql updates applied?

[kich0]

your Db revision doesn't match your MaNGOS rev...apply all needed sql updates..

[robuss]

your Db revision doesn't match your MaNGOS rev...apply all needed sql updates..

thanks mate