[Guide] Mangos Windows Setup

[nebixts]

I keep getting this problem:

just copy paste address on source location and copy paste too address the target or typed (make sure u have the folder u create for the target)

if already exist just del folder exist and create new one

then click clone button

ok.

[elfconnie]

I have Version 3.3 how can I bring it back to 3.2 so that I can do this?

Thanks.

[martyboy]

Thanks for the guide but I got a problem: if I want to run mangosd.exe it open the dosbox but it close in 0.5 sec. I have used prt sc and it say that it cannot find "mangosd.conf" , realm.exe works properly.

I have do everything good and I can connect to the database with sqlyog so that can't be the problem.

plz help me.

EDIT: the serverlol.txt :

2010-01-23 14:32:57 MaNGOS/0.16.0-DEV (* * Revision 9239 - *) for Win32 (little-endian) [world-daemon]

2010-01-23 14:32:57 <Ctrl-C> 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://getmangos.eu

MMMMMM

2010-01-23 14:32:57 Using configuration file mangosd.conf.

2010-01-23 14:32:57 World Database: 127.0.0.1;3306;root;pokemon;mangosLoginDatabaseInfo

2010-01-23 14:32:57 ERROR:Could not connect to MySQL database at 127.0.0.1: Unknown database 'mangoslogindatabaseinfo'

2010-01-23 14:32:57 ERROR:Cannot connect to world database 127.0.0.1;3306;root;pokemon;mangosLoginDatabaseInfo

"pokemon" is my pasword

[allantb]

Thanks a lot, I finally get the best with YTDB...

[btaylor1988]

Hi,

I am trying to compile mangos, however i seem to get failed on 6 items:

13>C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1040) : error C2733: second C linkage of overloaded function '_interlockedbittestandset' not allowed

13> C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1040) : see declaration of '_interlockedbittestandset'

13>C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1041) : error C2733: second C linkage of overloaded function '_interlockedbittestandreset' not allowed

13> C:\\Program Files\\Microsoft Visual Studio 9.0\\VC\\include\\intrin.h(1041) : see declaration of '_interlockedbittestandreset'

13>Build log was saved at "file://c:\\source\\win\\VC90\\script__Win32_Release\\BuildLog.htm"

13>script - 6 error(s), 0 warning(s)

========== Build: 7 succeeded, 6 failed, 0 up-to-date, 0 skipped ==========

any ideas?

[dj-habana]

Ok I have a Question whenever I compile it I get no errors and no warnings I have Visual Studio 2008

"-Add all the .exe files, .dll files and .pdb files in the compile folder into your Mangos folder (Ctrl + F to find them)"

Where do I press Ctrl + F and If I go look for them manually where should that be because if I go to my location

"C:\\Users\\Donald\\mangos\\win\\VC90\\ace__Win32_Debug_NoPCH" then I find alot of obj files also pdb but no dll or exe the nearest to dll is ACEd.dll.intermediate.manifest is this correct?

Also If I go into the other folders the only .exe I find is

genrevision.exe

then I also find

mangosd.exe.intermediate.manifest

realmd.exe.intermediate.manifest

which is 1 KB

[Random777]

Thanks for the guide but I got a problem: if I want to run mangosd.exe it open the dosbox but it close in 0.5 sec. I have used prt sc and it say that it cannot find "mangosd.conf" , realm.exe works properly.

I have do everything good and I can connect to the database with sqlyog so that can't be the problem.

plz help me.

EDIT: the serverlol.txt :

2010-01-23 14:32:57 MaNGOS/0.16.0-DEV (* * Revision 9239 - *) for Win32 (little-endian) [world-daemon]

2010-01-23 14:32:57 <Ctrl-C> 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://getmangos.eu

MMMMMM

2010-01-23 14:32:57 Using configuration file mangosd.conf.

2010-01-23 14:32:57 World Database: 127.0.0.1;3306;root;pokemon;mangosLoginDatabaseInfo

2010-01-23 14:32:57 ERROR:Could not connect to MySQL database at 127.0.0.1: Unknown database 'mangoslogindatabaseinfo'

2010-01-23 14:32:57 ERROR:Cannot connect to world database 127.0.0.1;3306;root;pokemon;mangosLoginDatabaseInfo

"pokemon" is my pasword

Is your database called "mangoslogindatabaseinfo", or "mangos" The guide says to name it "mangos". Take alook

[btaylor1988]

Hi, I have managed to get to the point were i am setting up the database. i have followed the instructions, however when i run mangos.exe i get this error:

2010-01-24 17:22:25 Using configuration file mangosd.conf.

2010-01-24 17:22:25 World Database: 192.168.55.10;3306;wow;password;mangos

2010-01-24 17:22:25 MySQL client library: 5.0.56

2010-01-24 17:22:25 MySQL server ver: 5.0.77

2010-01-24 17:22:25 ERROR:SQL: SELECT required_9244_02_mangos_spell_chain FROM db_version LIMIT 1

2010-01-24 17:22:25 ERROR:query ERROR: Unknown column 'required_9244_02_mangos_spell_chain' in 'field list'

2010-01-24 17:22:25 ERROR:Table `db_version` have field `required_8731_01_mangos_creature_template` but expected `required_9244_02_mangos_spell_chain`! Not all sql updates applied?

i believe this means i need to update some parts of the database, however i am unsure what files i need for the update.?

[Random777]

Hi, I have managed to get to the point were i am setting up the database. i have followed the instructions, however when i run mangos.exe i get this error:

2010-01-24 17:22:25 Using configuration file mangosd.conf.

2010-01-24 17:22:25 World Database: 192.168.55.10;3306;wow;password;mangos

2010-01-24 17:22:25 MySQL client library: 5.0.56

2010-01-24 17:22:25 MySQL server ver: 5.0.77

2010-01-24 17:22:25 ERROR:SQL: SELECT required_9244_02_mangos_spell_chain FROM db_version LIMIT 1

2010-01-24 17:22:25 ERROR:query ERROR: Unknown column 'required_9244_02_mangos_spell_chain' in 'field list'

2010-01-24 17:22:25 ERROR:Table `db_version` have field `required_8731_01_mangos_creature_template` but expected `required_9244_02_mangos_spell_chain`! Not all sql updates applied?

i believe this means i need to update some parts of the database, however i am unsure what files i need for the update.?

Do this:

-Step 1: Delate and remake you mangos database

-Step 2: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/UDB_0.11.6_Core_8734_SD2_1480.rar?revision=384 And Import to mangos

-Step 2: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/384_corepatch_mangos_8587_to_8734.sql?revision=384 And Import to mangos

-Step 3: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/384_updatepack_mangos.sql?revision=384 And Import to mangos

-Step 4: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/385_corepatch_mangos_8735_to_8798.sql?revision=385 And Import to mangos

-Step 5: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/385_updatepack_mangos.sql?revision=385 And Import to mangos

-Step 6: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/386_corepatch_mangos_8799_to_8994.sql?revision=386 And Import to mangos

-Step 7: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/386_updatepack_mangos.sql?revision=386 And Import to mangos

Once thats done, Apply all sql updates for mangos after the db version you have (everything after 8994 i belive)

hope that gets you somewhere

[btaylor1988]

ok i am following your steps. Thanks.

just to check do you mean the updates from sql\\updates folder, starting from 8995_01_mangos_spell_proc.event.sql

the one before that is 8993.

[Random777]

from the sql/updates folders and the 8995 would be the enxt update to apply

[btaylor1988]

cheers i have followed your steps, and now come to the following mangos error? could this mean i need more updates?

2010-01-24 18:18:42 MySQL client library: 5.0.56

2010-01-24 18:18:42 MySQL server ver: 5.0.77

2010-01-24 18:18:42 Realm running as realm ID 1

2010-01-24 18:18:42 Using World DB: UDB 0.11.6 (386) for MaNGOS 8994 with SD2 SQL for rev. 1516

2010-01-24 18:18:42 Using creature EventAI: ACID 3.0.1 - Full Release for Mangos

2010-01-24 18:18:42 Using DataDir ./

2010-01-24 18:18:42 WORLD: VMap support included. LineOfSight:0, getHeight:0

2010-01-24 18:18:42 WORLD: VMap data directory is: ./vmaps

2010-01-24 18:18:42 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds

2010-01-24 18:18:42

2010-01-24 18:18:42 Loading MaNGOS strings...

2010-01-24 18:18:43

2010-01-24 18:18:43 >> Loaded 695 MaNGOS strings from table mangos_string

2010-01-24 18:18:43 Initialize data stores...

2010-01-24 18:18:43 ERROR:Found DBC files for build 10505 but mangosd expected DBC for one from builds: 11159 Please extract correct DBC files.

[Random777]

cheers i have followed your steps, and now come to the following mangos error? could this mean i need more updates?

2010-01-24 18:18:42 MySQL client library: 5.0.56

2010-01-24 18:18:42 MySQL server ver: 5.0.77

2010-01-24 18:18:42 Realm running as realm ID 1

2010-01-24 18:18:42 Using World DB: UDB 0.11.6 (386) for MaNGOS 8994 with SD2 SQL for rev. 1516

2010-01-24 18:18:42 Using creature EventAI: ACID 3.0.1 - Full Release for Mangos

2010-01-24 18:18:42 Using DataDir ./

2010-01-24 18:18:42 WORLD: VMap support included. LineOfSight:0, getHeight:0

2010-01-24 18:18:42 WORLD: VMap data directory is: ./vmaps

2010-01-24 18:18:42 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds

2010-01-24 18:18:42

2010-01-24 18:18:42 Loading MaNGOS strings...

2010-01-24 18:18:43

2010-01-24 18:18:43 >> Loaded 695 MaNGOS strings from table mangos_string

2010-01-24 18:18:43 Initialize data stores...

2010-01-24 18:18:43 ERROR:Found DBC files for build 10505 but mangosd expected DBC for one from builds: 11159 Please extract correct DBC files.

Your close bud just make sure of this

That you wow Client is 3.3.0a [11159]

Go into the contrib folder and get the "new" ad.exe, the ones you used in the past wont work.

replace the dbc/map files with the ones you get from your new ad.exe and you should be set

[thephoenix007]

ok... this is the 3rd time i've had to redo my entire mangos database...

can someone please help with the order of the sql files? (following the order gives me an error in the sql import. and subsequently crashes mangosd to a prompt when ran)

i'm thinking there's a version problem somewhere, it's not very intuitive and i've spent about 2 hours trying to get my DB populated properly.

Thanks in advance for the help!

(just to clarify, i've followed the above steps in downloading the correct information)

[Random777]

Tell me what step it errors at.

[thephoenix007]

well, if i uncheck "continue on errors" the second link gives me an error(not the big core pack, but the first smaller one).

if i check "continue on errors" i update in the order you described and at the end get this:

SQL: SELECT required_9244_02_mangos_spell_chain FROM db_version LIMIT 1
query ERROR: Unknown column 'required_9244_02_mangos_spell_chain' in 'field list'
Table `db_version` have field `required_8993_01_mangos_spell_proc_event` but expected `required_9244_02_mangos_spell_chain`! Not all sql updates applied?

Wouldn't be so frustrating, but the big pack takes about 10 minutes to apply (on my 4th run now)

EDIT: for those having problems with a fresh start and using UDB DB files:

1. UDB 11.6 full

2. 385 corepatch

3. 385 updatepack

4. 386 corepatch

5. 386 updatepack

6. check your db version in mangos.db_version, it will say required_8993_01_mangos_spell_proc_event

7. Go to mangos source folder/sql/updates, find 8993_01_mangos_spell_proc_event.sql

8. Manually install the NEXT sql file with a HIGHER number, in this case 8995_01_mangos_spell_proc_event.sql

9. Keep going installing all sql files with MANGOS in their name until you reach the end of the list

This is time consuming, but will get you up and running

[dj-habana]

"

Installing MaNGOS

-Add all the .exe files, .dll files and .pdb files in the compile folder into your Mangos folder (Ctrl + F to find them) <<<--- this line

-Go back into your MaNGOS source folder, then into the "src" folder, then into the "mangosd" folder

-Rename "mangosd.conf.dist" to "mangosd.conf"

-Go back into your MaNGOS source folder, then into the "src" folder, then into the "realmd" folder

-Rename "realmd.conf.dist" to "realmd.conf"

"

I am using Visual studio 2008 after the compile is complete and I press Ctrl + F I get nothing but a find box within the scripts

But Then I also find in the C\\\\:Mangos a folder named Bin inside bin is alot of files namely

Mangosd.exe

ACEd.dll

realmd.exe

+ alot of pdb and dll files are these the files i have to "-Add all the .exe files, .dll files and .pdb files in the compile folder into your Mangos folder"

[btaylor1988]

cheers Random777 !!!

I have a fully working mangos server up and running now.

running in a VMware machine on Linux and is nice and stable.

[Random777]

Glad to help, But why run it in a virtual machine? what os are you using?

[dj-habana]

I did everything the tutorial said but when I run mangosd.exe or realmd I get the following errors

"C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\mangosd.conf"

No such file or directory

Could not find Configuration file mangosd.conf

"C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\realmd.conf"

No such file or directory

Could not find Configuration file realmd.conf

if I look at where those files are I find them at

C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\src\\mangosd\\mangosd.conf

C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\src\\realmd\\realmd.conf

What must I do to fix this error ??

[dj-habana]

Do this:

-Step 1: Delate and remake you mangos database

-Step 2: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/UDB_0.11.6_Core_8734_SD2_1480.rar?revision=384 And Import to mangos

-Step 2: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/384_corepatch_mangos_8587_to_8734.sql?revision=384 And Import to mangos

-Step 3: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/384_updatepack_mangos.sql?revision=384 And Import to mangos

-Step 4: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/385_corepatch_mangos_8735_to_8798.sql?revision=385 And Import to mangos

-Step 5: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/385_updatepack_mangos.sql?revision=385 And Import to mangos

-Step 6: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/386_corepatch_mangos_8799_to_8994.sql?revision=386 And Import to mangos

-Step 7: Download http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.6_additions/386_updatepack_mangos.sql?revision=386 And Import to mangos

Once thats done, Apply all sql updates for mangos after the db version you have (everything after 8994 i belive)

hope that gets you somewhere

If I do this and I run those files I get the followwing error

 -- 8589

ALTER TABLE db_version CHANGE COLUMN required_8573_01_mangos_mangos_string required_8589_01_mangos_creature_template bit;

[Err] 1054 - Unknown column 'required_8573_01_mangos_mangos_string' in 'db_version'

[bogdan012794]

THANKS RANDOM777 , I had the same problem , and I solved thanks to you.!

Thanks man

[dj-habana]

Guys How Do I know what db I have to install, and what patch I have my client is 3.2.2a

[Gimp]

I did everything the tutorial said but when I run mangosd.exe or realmd I get the following errors

"C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\mangosd.conf"

No such file or directory

Could not find Configuration file mangosd.conf

"C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\realmd.conf"

No such file or directory

Could not find Configuration file realmd.conf

if I look at where those files are I find them at

C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\src\\mangosd\\mangosd.conf

C:\\Users\\Donald\\Donald\\PVServer\\Mangos\\Mangos\\src\\realmd\\realmd.conf

What must I do to fix this error ??

Place the files in your bin folder where your mangosd.exe and realmd.exe is

[Gimp]

If I do this and I run those files I get the followwing error

 -- 8589

ALTER TABLE db_version CHANGE COLUMN required_8573_01_mangos_mangos_string required_8589_01_mangos_creature_template bit;

[Err] 1054 - Unknown column 'required_8573_01_mangos_mangos_string' in 'db_version'

You still need to install the Mangos sql updates found in ..mangos/sql/updates