[Guide] Mangos Windows Setup

[scotty562]

I too am getting the 0004331 error. Could you provide a link to the compatable versions? Also, most of your pics are down.

[Aleee]

If it tells you that the map-file is incompatible you shouldn't ask for compatible one, cause all you have to do is to use an appropriate ad.exe and an appropriate wow client. If you use the latest branch of official sources you can find ad.exe in /contrib/extractor and the version of client you need is 3.3.5.

[scotty562]

If it tells you that the map-file is incompatible you shouldn't ask for compatible one, cause all you have to do is to use an appropriate ad.exe and an appropriate wow client. If you use the latest branch of official sources you can find ad.exe in /contrib/extractor and the version of client you need is 3.3.5.

I'm not asking for a compatable map. I'm asking for a compatable ad.exe. I followed this guide and compiled my own /contrib/extractor and used the ad.exe as I was insctructed. If I need to use the local branch to fix this, I don't know how to do that if it isn't in the guide.

Edit:

I found the problem. In the mangos conf file it has you set datadir = "."

I set it to datadir = "" and it got past the error.

Of course, it only gets to [0 ms] SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1' and then crashes. So at least I'm past the first hurdle .

[dani03]

Hello all, I did all, server work, but someone know why i can't create blood elf or draenei ?? it' a bug?? Please show me how to fix it

[TEC2008]

Ok I am at the database install part and I am unsure which updates I install first! Do I install the updates from UDB first or the ones in the mangos source folder?

[bisonte]

Hello all, I did all, server work, but someone know why i can't create blood elf or draenei ?? it' a bug?? Please show me how to fix it

You must have at the "expansion" field (realmd.account) minimum value 1 (BC) for this account you want to use...

[bisonte]

Ok I am at the database install part and I am unsure which updates I install first! Do I install the updates from UDB first or the ones in the mangos source folder?

First Database ... which core version is needed ? and then apply all following sql updates from sql/update folder of the core if needed.

[TEC2008]

First Database ... which core version is needed ? and then apply all following sql updates from sql/update folder of the core if needed.

I am running Revision 10271, I installed the UDB core and all updates followed by the updates in the mangos source and I get the following error:

2010-07-25 15:16:51 ERROR:SQL: SELECT required_10254_01_characters_auctionhouse FROM character_db_version LIMIT 1

2010-07-25 15:16:51 ERROR:query ERROR: Unknown column 'required_10254_01_characters_auctionhouse' in 'field list'

2010-07-25 15:16:51 ERROR:The table `character_db_version` in your [CHARACTER] database indicates that this database is out of date!

2010-07-25 15:16:51 ERROR:

2010-07-25 15:16:51 ERROR: [A] You have: --> `10160_02_characters_pet_aura.sql`

2010-07-25 15:16:51 ERROR:

2010-07-25 15:16:52 ERROR: You need: --> `10254_01_characters_auctionhouse.sql`

2010-07-25 15:16:52 ERROR:

2010-07-25 15:16:52 ERROR:You must apply all updates after [A] to to use mangos with this database.

2010-07-25 15:16:52 ERROR:These updates are included in the sql/updates folder.

2010-07-25 15:16:52 ERROR:Please read the included [README] in sql/updates for instructions on updating.

[Blader]

You didn't apply *_characters_* updates to your characters database.

[dani03]

Thank you bisonte, but now i have an other issue, how can I know a password of a account, cause is coded :-s

[Phenomenon]

Thank you bisonte, but now i have an other issue, how can I know a password of a account, cause is coded :-s

You aren't supposed to know what it is because that's a privacy issue. If you want to change a user's password however, you can do that in the mangosd.exe command window if I remember correctly.

[dani03]

I mean if I'm admin and i want to know a account password how i can know it? there is a loooong code

[EARTHWALKER]

I mean if I'm admin and i want to know a account password how i can know it? there is a loooong code

He knows what you mean dude and his answer still stands. But I'll answer it again for you.

You can't ever find out, unless you get hold of a patch to change the sha_password_hash field to something un-encrypted. I'm sure there's something in the multiverse somewhere.

[temporary]

There is no good reason why you should know that, as all reason leads to something dishonest

[Artmendel]

HI, just wanted to thanks Phenomenon for this incredibly awesome tutorial, i made it today, got some issues like anyone but its mostly cause i missed some parts cause of my "iwant it up badly" feelings, and few hours were enough to make it up, that rocks !!!

Now, i just have to get french quests and all, and figure out some coding to change some strange appears, how to get some mines where they're supposed to be, etc ... let's the adventure begins !

[despiron]

edit: I am sorry, wrong place to post.

[unbreakable99]

Hey, Thanks for this great guide, however i keep encountering problems when trying to update my database tables.

It is informing me i need to update, i have all the required update SQL files, howveer when i execute them i get messages like this one:

Query : ALTER TABLE realmd_db_version CHANGE COLUMN required_9748_01_realmd_realmlist required_10008_01_realmd_realmd_db_version bit

Error Code : 1054

Unknown column 'required_9748_01_realmd_realmlist' in 'realmd_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Can you provide a solution, or what am i doing wrong?

I'm using SQLyog exactly like described.

Nevermind, Fixed!

[DeadOwnage]

Hey Great guide im stuck at the beginning although it isn't my fault. I did the Git Gui thing for the source folder, but it has been on "Working Please Wait" for the last 10 minutes. Do you have any idea how to fix this? If you do please reply back.

edit: I think I fixed the problem.

[mortem86]

Thanks for the guide and the work you put into it.

[wuhaoyang]

Hello, my friends, is the UDB can not use the above procedure in the latest Mangos, UDB no longer whether to update it? Good Luck!

[coco77]

can anyone who's really good at that i want to put a mangos server on my computer but im too bad so anyone can teamviewer and do it for me plz ? i do anything you want after ! (... ) i want to have a server website too and not a local server i want to put my server online like all the other mangos private server on internet

[antiroot]

@coco77

a server on the internet is not private, it then becomes public.

Public MaNGOS Servers are not supported by the MaNGOS community, the forums are here for support and group collaboration on developing private MaNGOS servers for educational use, and advancing C/C++ knowledge

[lol553]

i get Query:

DROP TABLE IF EXISTS `access_requirement`

Error occured at:2010-08-28 08:47:47

Line no.:22

Error Code: 1046 - No database selected

Query:

DROP TABLE IF EXISTS `account_data`

Error occured at:2010-08-28 08:58:05

Line no.:22

Error Code: 1109 - Unknown table 'account_data' in information_schema

Query:

CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2010-08-28 08:59:20

Line no.:3

Error Code: 1007 - Can't create database 'world'; database exists

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-08-28 16:56:33

Line no.:2

Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-08-28 16:57:00

Line no.:2

Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-08-28 16:58:45

Line no.:2

Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit

Error occured at:2010-08-28 16:59:33

Line no.:1

Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit

Error occured at:2010-08-28 17:06:05

Line no.:1

Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit

Error occured at:2010-08-28 17:06:55

Line no.:1

Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit

Error occured at:2010-08-28 17:07:30

Line no.:1

Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9246_01_characters_character required_9250_01_characters_character bit

Error occured at:2010-08-28 17:07:32

Line no.:1

Error Code: 1054 - Unknown column 'required_9246_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-08-28 17:09:14

Line no.:2

Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version'

when i try to do the first update

[jacko]

Hi, when I try to compile mangos i get 8 succeeded and 4 failed. I have redownloaded the mangos from git several times without any progress, I have also followed different guides but it didnt help...

Also the Bin/Win32_release directory is empty after compileing.

Here is the log from visual c++ 2010 after the compiling is finished:

http://pastebin.com/QDuv5wCy

So, is there someone who knows the problem and are willing to help me ?

[n3ox89]

must i dont scriptdev2 copy in mangos/src/binding and then Compiling???