[Guide] Mangos Windows Setup

[kageb0shi]

www.github.com/mangos/mangos.git <<< check it yourself from there there is so revision.h period so that's nothing to do with me

oh did a new pull and look new errors lol

Try Build > Clean Solution then Build > Build Solution. Also check that you're building it for release, not debug.

[turaj]

Yes you can't run mangosd.exe if you had problems creating the databases. We need more info. Is this a new installation? If so then you don't need to do the SQL updates.

Yes this is a new "clean" installation

I have followed the guide to the letter, I am not totally sure I did it correctly. When i compiled mangos I got 11 succeeded 0 failed so it looked good, from that point I copied the .exe..dll and .pdb files from f:\\mangos\\bin\\win32release and placed them into f:\\mangos server (I still feel i copied these files from the wrong spot)

I am also not sure if I did something wrong at the start, I installed GIT and made a folder called F:\\MaNGOS, right clicked and did the whole get gui thing, but got the error that folder already exists, so I just directed it to a folder I called MaNGOS1 (which I had not yet created) and it installed there. So from reading the posts and getting some help, I assumed that F:\\MaNGOS1 would be my "source folder" and F:\\mangos server would be my compile folder?

so far I have compiled Mangos (at least I think I did that correctly) ========== Build: 11 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

[s32ialx]

Try Build > Clean Solution then Build > Build Solution. Also check that you're building it for release, not debug.

ok seriously you acting like i haven't done this before this is not newbie mistakes ok this is flow blown errors. I've been compiling mangos since 2.5 no problems. and no 309 ur acting as if i am new to compiling it like hello read above post 303 COMPILES FINE so WHY does 309 not compile

[error0024]

Guys i dont really get this part

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

Ive already build and it has been built...without errors

Any idea?

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

This part i dont get it..

[no.human.being]

Guys i dont really get this part

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

Ive already build and it has been built...without errors

Any idea?

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

This part i dont get it..

He means you should create another folder for the MaNGOS binaries and config files. Then you go into the source-folder (the one where you checked out the repository and compiled the source code), search for all the binary files (*.pdb, *.dll, *.exe) and put them into the folder you've just created for the binaries.

My question is still open. Anyone knows where the version check takes place or where the expected client version is stored server-side?

[chosenken]

ok seriously you acting like i haven't done this before this is not newbie mistakes ok this is flow blown errors. I've been compiling mangos since 2.5 no problems. and no 309 ur acting as if i am new to compiling it like hello read above post 303 COMPILES FINE so WHY does 309 not compile

I think what happened is the dependencies got mixed up in 3.0.9. The genrevision.exe should be built first since it generates the revision.h file. It is an issue with the solution file is all. Just build the revision project, then build the entire project once more. This will build the genrevision.exe file, which the other projects depend on.

[s32ialx]

I think what happened is the dependencies got mixed up in 3.0.9. The genrevision.exe should be built first since it generates the revision.h file. It is an issue with the solution file is all. Just build the revision project, then build the entire project once more. This will build the genrevision.exe file, which the other projects depend on.

i have tried building genrevision project first and it still takes a shit in the end

[no.human.being]

i have tried building genrevision project first and it still takes a shit in the end

I've been following the guide in this thread very closely, except for the "Include" and "Library" folders, which were named differently on my system, but it seems I got the right ones as the project compiled without errors. Was using Visual Studio 2008 Professional.

[s32ialx]

I've been following the guide in this thread very closely, except for the "Include" and "Library" folders, which were named differently on my system, but it seems I got the right ones as the project compiled without errors. Was using Visual Studio 2008 Professional.

well i am using Visual Stupid 2008 Standard I'll install professional and try it thanks

[kageb0shi]

ok seriously you acting like i haven't done this before this is not newbie mistakes ok this is flow blown errors. I've been compiling mangos since 2.5 no problems. and no 309 ur acting as if i am new to compiling it like hello read above post 303 COMPILES FINE so WHY does 309 not compile

whoa there chief. Just doing a little troubleshooting to isolate an issue. Whats the error for the genrevision compile?

[s32ialx]

whoa there chief. Just doing a little troubleshooting to isolate an issue. Whats the error for the genrevision compile?

lol um genrevision when compiled alone AS x64 no errors when compiled at x86 it errors out saying it's not the right system and i need to compiled as x64

[kageb0shi]

Yes this is a new "clean" installation

I have followed the guide to the letter, I am not totally sure I did it correctly. When i compiled mangos I got 11 succeeded 0 failed so it looked good, from that point I copied the .exe..dll and .pdb files from f:\\mangos\\bin\\win32release and placed them into f:\\mangos server (I still feel i copied these files from the wrong spot)

I am also not sure if I did something wrong at the start, I installed GIT and made a folder called F:\\MaNGOS, right clicked and did the whole get gui thing, but got the error that folder already exists, so I just directed it to a folder I called MaNGOS1 (which I had not yet created) and it installed there. So from reading the posts and getting some help, I assumed that F:\\MaNGOS1 would be my "source folder" and F:\\mangos server would be my compile folder?

so far I have compiled Mangos (at least I think I did that correctly) ========== Build: 11 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

Yep thats right. So far so good. You copied the .exe, .dll, and .pdb files from bin\\win32_release to f:\\mangos server

I also had that issue with git not wanting to do anything with an existing folder. Have you extracted maps and dbc? The output of that action will be two folders named maps and dbc then copy that to F:\\Mangos Server

Well, back to your SQL issue. You will have a total of 4 databases, and they are realmd, characters, mangos, and scriptdev2. Just run the sql dump files in UDB\\trunk\\Full_DB\\ForCleanInstallOnly

Then run the sql dump file UDB_0.11.5_Core_7681_SD2_1012.sql

[s32ialx]

so that the end of ur troubleshooting? lol

[kageb0shi]

so that the end of ur troubleshooting? lol

sure is. I don't have a 64 bit system and I didn't have that problem. how about you use google to search for your problem.

[turaj]

Well, back to your SQL issue. You will have a total of 4 databases, and they are realmd, characters, mangos, and scriptdev2. Just run the sql dump files in UDB\\trunk\\Full_DB ForCleanInstallOnly Then run the sql dump file UDB_0.11.5_Core_7681_SD2_1012.sql

Ok everything on the guide is complete up to the database portion, i have F:\\mangos server

In this folder are all the .exe, .dll, .pdb files, maps and dbc folders with info extraced using the ad.exe

my mangosd.conf and realmd.conf files have been set up like it shows.

Still when I do the steps for the databases and i have both that you showed me it gives me the 1064 error code: which basically just prints off each line of the (in this case) characters.sql file, with each line giving the 1064 error

something that I just realized when looking back at the mysql is I don't see a database called scriptdev2, where is this database and how do I get it?

[PsyberMind]

I might have skimmed over it, but when I did the C/P of the Dump, it executed with a 0 rows affected. However when I just did a dump restore (like on the other tables) it executed fine, and everything loaded perfectly

So those of you having problems with executing the query, try restoring from dump.

[error0024]

Well ..i know,just create a folder right?

but then where can i find the compiled files -.- im quite confused here

cuz ive already built the stuff

[kageb0shi]

Ok everything on the guide is complete up to the database portion, i have F:\\mangos server

In this folder are all the .exe, .dll, .pdb files, maps and dbc folders with info extraced using the ad.exe

my mangosd.conf and realmd.conf files have been set up like it shows.

Still when I do the steps for the databases and i have both that you showed me it gives me the 1064 error code: which basically just prints off each line of the (in this case) characters.sql file, with each line giving the 1064 error

something that I just realized when looking back at the mysql is I don't see a database called scriptdev2, where is this database and how do I get it?

scriptdev will come later. Scriptdev contains the AI for all the creatures. Sorry I didn't mention that before. What are you using for your SQL reader? SQLyog?

[turaj]

scriptdev will come later. Scriptdev contains the AI for all the creatures. Sorry I didn't mention that before. What are you using for your SQL reader? SQLyog?

SQLyog community edition mysql gui v8.1

[maramures]

I encountered a problem, I'm using windows 7 and SQL Client crashes and I can't make it work what ever I tryed. Can someone suggest me another program close to this one or maybe have any idea how can I make it work ?

[caeruleaus]

it worked fine for me on my windows 7 install, my only problem was that i couldnt install the .net frameworks 1.1 and 2.0. They've probably fixed that by now since i tried it almost directly after release.

[s32ialx]

ok a little update to my confusion... i formatted and installed Vista Sp1 x64 (originally using windows 7 x64 (which btw is not released it's RC1 "Release Candidate 1" above poster)) so the thing is Winows 7 x64 forced me to compile as x64 release using Microsoft Visual Stuido 2008 Standard Edition but would error out. Now Vista sp1 x64 won't do ANYTHING when compiled for x64 release... just skips everything. BUT when compiled x86 no problems.... now i was using Microsoft Visual Studio Team System 2008 weather that actually makes a difference who knows. both Visual Studio Editions were x64. anyone?

[MephistoVI]

caeruleaus, the dot net framework is included already in the windows 7 RC distribution I downloaded almost a month ago, so maybe thats your issue with not installing them. now to my issue. needs to be updated to show the changed commands. create is now a sub command under the account command and there is no longer the setexpansion command. it also is under the account main command set sub command addon sub sub command. should now be: account set addon [account name here] [0 for none, 1 for Burning Crusade, 2 for BC and WOTLK]

[Nelspruit]

when I tried to run mangosd.exe, error occurred as follow:

2009-05-31 18:36:15 Loading Creature templates...

2009-05-31 18:36:16 ERROR:Error in creature_template table, probably sql file format was updated (there should be 69 fields in sql).

I have already update my database to UDB_0.11.5_Core_7681_SD2_1012

I have solved the problem. Updating in right order to 7908

I have the same problem, i'll post the entire server.log:

2009-06-10 19:14:12 MaNGOS/0.13.0-DEV (* * Revision 7979 - *) for Win32 (little-endian) [world-daemon]
2009-06-10 19:14:12 <Ctrl-C> to stop.

(Mangos ascii logo)

2009-06-10 19:14:12 Using configuration file mangosd.conf.
2009-06-10 19:14:12 World Database: 127.0.0.1;3306;root;mangos;mangos
2009-06-10 19:14:12 MySQL client library: 5.0.56
2009-06-10 19:14:12 MySQL server ver: 6.0.10-alpha-community 
2009-06-10 19:14:12 Character Database: 127.0.0.1;3306;root;mangos;characters
2009-06-10 19:14:12 MySQL client library: 5.0.56
2009-06-10 19:14:12 MySQL server ver: 6.0.10-alpha-community 
2009-06-10 19:14:12 Login Database: 127.0.0.1;3306;root;mangos;realmd
2009-06-10 19:14:12 MySQL client library: 5.0.56
2009-06-10 19:14:12 MySQL server ver: 6.0.10-alpha-community 
2009-06-10 19:14:12 Realm running as realm ID 1
2009-06-10 19:14:12 Using World DB: UDB 0.11.0 (371) for MaNGOS 7681 with SD2 SQL for rev. 1012
2009-06-10 19:14:12 Using creature EventAI: ACID 0.0.9 - Full Release for Mangos 7673+
2009-06-10 19:14:12 Using DataDir ./
2009-06-10 19:14:12 WORLD: VMap support included. LineOfSight:0, getHeight:0
2009-06-10 19:14:12 WORLD: VMap data directory is: ./vmaps
2009-06-10 19:14:12 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2009-06-10 19:14:12 
2009-06-10 19:14:12 Loading MaNGOS strings...
2009-06-10 19:14:12 
2009-06-10 19:14:12 >> Loaded 649 MaNGOS strings from table mangos_string
2009-06-10 19:14:12 Initialize data stores...
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Initialized 78 data stores
2009-06-10 19:14:13 Using enUS DBC Locale as default. All available DBC locales: esES enUS 
2009-06-10 19:14:13 
2009-06-10 19:14:13 Loading Script Names...
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 629 Script Names
2009-06-10 19:14:13 Loading InstanceTemplate...
2009-06-10 19:14:13 >> Loaded 73 Instance Template definitions
2009-06-10 19:14:13 
2009-06-10 19:14:13 Loading SkillLineAbilityMultiMap Data...
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 9843 SkillLineAbility MultiMap Data
2009-06-10 19:14:13 Cleaning up instances...
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Initialized 0 instances
2009-06-10 19:14:13 Packing instances...
2009-06-10 19:14:13 >> Instance numbers remapped, next instance id is 1
2009-06-10 19:14:13 
2009-06-10 19:14:13 
2009-06-10 19:14:13 Loading Localization strings...
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 npc_option locale strings. DB table `locales_npc_option` is empty.
2009-06-10 19:14:13 
2009-06-10 19:14:13 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.
2009-06-10 19:14:13 >>> Localization strings loaded
2009-06-10 19:14:13 
2009-06-10 19:14:13 Loading Page Texts...
2009-06-10 19:14:13 >> Loaded 1625 page texts
2009-06-10 19:14:13 
2009-06-10 19:14:13 Loading Game Object Templates...
2009-06-10 19:14:14 >> Loaded 17847 game object templates
2009-06-10 19:14:14 
2009-06-10 19:14:14 Loading Spell Chain Data...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 2351 spell chain records
2009-06-10 19:14:14 Loading Spell Elixir types...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 99 spell elixir definitions
2009-06-10 19:14:14 Loading Spell Learn Skills...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 97 Spell Learn Skills from DBC
2009-06-10 19:14:14 Loading Spell Learn Spells...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 31 spell learn spells + 545 found in DBC
2009-06-10 19:14:14 Loading Spell Proc Event conditions...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 858 extra spell proc event conditions +14 custom
2009-06-10 19:14:14 Loading Spell Bonus Data...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 0 extra spell bonus data
2009-06-10 19:14:14 Loading Aggro Spells Definitions...
2009-06-10 19:14:14 >> Loaded 89 aggro generating spells
2009-06-10 19:14:14 
2009-06-10 19:14:14 Loading NPC Texts...
2009-06-10 19:14:14 
2009-06-10 19:14:14 >> Loaded 5123 npc texts
2009-06-10 19:14:14 Loading Item Random Enchantments Table...
2009-06-10 19:14:15 
2009-06-10 19:14:15 >> Loaded 28575 Item Enchantment definitions
2009-06-10 19:14:15 Loading Items...
2009-06-10 19:14:17 >> Loaded 31408 item prototypes
2009-06-10 19:14:17 
2009-06-10 19:14:17 Loading Item Texts...
2009-06-10 19:14:17 
2009-06-10 19:14:17 >> Loaded 0 item pages
2009-06-10 19:14:17 Loading Creature Model Based Info Data...
2009-06-10 19:14:17 >> Loaded 22384 creature model based info
2009-06-10 19:14:17 
2009-06-10 19:14:17 Loading Equipment templates...
2009-06-10 19:14:17 >> Loaded 1804 equipment template
2009-06-10 19:14:17 
2009-06-10 19:14:17 Loading Creature templates...
2009-06-10 19:14:17 ERROR:Error in creature_template table, probably sql file format was updated (there should be 69 fields in sql).

I just followed the entire tutorial, and got just one DB error.

I've read the entire post and there are people withe the same error that solved it, but i don't know how.

I don't recognize if i have to update the core (i think i have the 0.13 7979 version, the one i got just following this guide) or the database ( UDB 0.11.0 (371) for MaNGOS 7681 with SD2 SQL for rev. 1012). An neither know how to update it. I almost got it >_< f*ing error at the end of the process.

I will thank if someone can clarify this a bit and told me how to update it.

I registered myself in udbforums downloaded a few patches but since i don't know if it's a db or core failure i don't know what to do with this files or how to patch-update it.

Thx

Edit: i installed the UDB_0.11.5_Core_7681_SD2_1012.sql but no effect happened. The db says 0.11.0 instead of 0.11.5 so i suppose i did it badly

Edit2: Sorry for newbie questions. Working a bit on it i understand now and updated correctly.

I had 7681 , just updated mangos db with patches till 7920. Ty

[maramures]

After everything works like a charm but no mobs, loot, items, spells and all the rest is missing. I still can't find any hint how to install UDB_0.11.5_Core_7681_SD2_1012.sql (since this is the newest I found).Can someone tell me how can I do this or a link for more specific directions?