Jump to content

[Guide] Mangos Windows Setup

Guest AuntieMangos

By Guest AuntieMangos
in OldInstallation, configuration & upgrades

 Share

Recommended Posts

Gimp Advanced Member

Gimp

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

Mangos has switched to 3.3.0a support, if you download a fresh source it will be 3.3.0a, so update your game client. Rip the dbc files from that.

Install the latest UDB database, it's still for 3.2.2a but will run fine with 3.3.0a Mangos, it just doesn't have the latest 3.3.0a content yet.

Link to comment
Share on other sites
  • Replies 770
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Gimp Advanced Member

Gimp

Posted
Posted
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

That's a ton of extra work needlessly, if people download this address through their svn clients they'll have all the patches in one directory: https://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk/

Link to comment
Share on other sites
dj-habana Member

dj-habana

Posted
Posted

Well I found something but not sure, in the sql folder where you find character.sql and realmd.sql,

There is also a mangos.sql, shouldn't I load that, then UDB coz I loaded it now then it just gave me this error

2010-01-27 20:20:15 MaNGOS/0.16.0-DEV (* * Revision 9245 - *) for Win32 (little-endian) [world-daemon]

2010-01-27 20:20:15 <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-27 20:20:15 Using configuration file mangosd.conf.

2010-01-27 20:20:15 World Database: 127.0.0.1;3306;root;mangos;mangos

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Character Database: 127.0.0.1;3306;root;mangos;characters

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Login Database: 127.0.0.1;3306;root;mangos;realmd

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Realm running as realm ID 1

2010-01-27 20:20:15 Using World DB: Mangos default database.

2010-01-27 20:20:15 Using creature EventAI: Creature EventAI not provided.

2010-01-27 20:20:16 Using DataDir ./

2010-01-27 20:20:16 WORLD: VMap support included. LineOfSight:0, getHeight:0

2010-01-27 20:20:16 WORLD: VMap data directory is: ./vmaps

2010-01-27 20:20:16 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds

2010-01-27 20:20:16

2010-01-27 20:20:16 Loading MaNGOS strings...

2010-01-27 20:20:16

2010-01-27 20:20:16 >> Loaded 694 MaNGOS strings from table mangos_string

2010-01-27 20:20:16 Initialize data stores...

2010-01-27 20:20:16 ERROR:Found DBC files for build 10505 but mangosd expected DBC for one from builds: 11159 Please extract correct DBC files.

EDIT: Boy AM I stupid, I have to open my eyes lol, nvm this question I know what to do

Link to comment
Share on other sites
Gimp Advanced Member

Gimp

Posted
Posted
Well I found something but not sure, in the sql folder where you find character.sql and realmd.sql,

There is also a mangos.sql, shouldn't I load that, then UDB coz I loaded it now then it just gave me this error

2010-01-27 20:20:15 MaNGOS/0.16.0-DEV (* * Revision 9245 - *) for Win32 (little-endian) [world-daemon]

2010-01-27 20:20:15 <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-27 20:20:15 Using configuration file mangosd.conf.

2010-01-27 20:20:15 World Database: 127.0.0.1;3306;root;mangos;mangos

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Character Database: 127.0.0.1;3306;root;mangos;characters

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Login Database: 127.0.0.1;3306;root;mangos;realmd

2010-01-27 20:20:15 MySQL client library: 5.0.56

2010-01-27 20:20:15 MySQL server ver: 5.1.42-community

2010-01-27 20:20:15 Realm running as realm ID 1

2010-01-27 20:20:15 Using World DB: Mangos default database.

2010-01-27 20:20:15 Using creature EventAI: Creature EventAI not provided.

2010-01-27 20:20:16 Using DataDir ./

2010-01-27 20:20:16 WORLD: VMap support included. LineOfSight:0, getHeight:0

2010-01-27 20:20:16 WORLD: VMap data directory is: ./vmaps

2010-01-27 20:20:16 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds

2010-01-27 20:20:16

2010-01-27 20:20:16 Loading MaNGOS strings...

2010-01-27 20:20:16

2010-01-27 20:20:16 >> Loaded 694 MaNGOS strings from table mangos_string

2010-01-27 20:20:16 Initialize data stores...

2010-01-27 20:20:16 ERROR:Found DBC files for build 10505 but mangosd expected DBC for one from builds: 11159 Please extract correct DBC files.

EDIT: Boy AM I stupid, I have to open my eyes lol, nvm this question I know what to do

This is mostly for other people that might read this post and get confused, DO NOT load mangos.sql, only characters.sql and realmd.sql, the mangos.sql data is from UDB.

Link to comment
Share on other sites
rulebreaker Member

rulebreaker

Posted
Posted
Ehh..? I dont really understand this part.

You cant be serious?

When you compile mangos it makes a folder called BIN in the root of your mangos directory, copy the files from there into the directory you run your server from NOTE ONLY AN EXAMPLE: C:\\Dev\\Mangos\\Bin\\ to Z:\\Mangos

My God has no one on this forum even taken a basic computer programming course once in their lifetime

Link to comment
Share on other sites
Random777 Member

Random777

Posted
Posted
You cant be serious?

When you compile mangos it makes a folder called BIN in the root of your mangos directory, copy the files from there into the directory you run your server from NOTE ONLY AN EXAMPLE: C:\\Dev\\Mangos\\Bin\\ to Z:\\Mangos

My God has no one on this forum even taken a basic computer programming course once in their lifetime

Yea i do agree, Please come here knowing what a "File system' is for your your OS At least

Link to comment
Share on other sites
ipetrov1974 Newbie

ipetrov1974

Posted
Posted

Good time of the day.

I'm stuck at "Setting up the databases".

When i try to connect to MySQL with SQLyog, it says "Error no 2003. Can't connect to MySQL server on 'localhost' (10013)".

Yes, MySQL runs on this machine.

Yes, I can perfectly connect using mysql command line tool.

What can be wrong ?

Forgive me my noobiness.

Link to comment
Share on other sites
Gimp Advanced Member

Gimp

Posted
Posted
Good time of the day.

I'm stuck at "Setting up the databases".

When i try to connect to MySQL with SQLyog, it says "Error no 2003. Can't connect to MySQL server on 'localhost' (10013)".

Yes, MySQL runs on this machine.

Yes, I can perfectly connect using mysql command line tool.

What can be wrong ?

Forgive me my noobiness.

Make sure you don't name the databases (mangos;characters;realmd) on the sqlyog login screen before you've created them. Leave that line blank, go in, create the databases, then step back out and type their names in.

Link to comment
Share on other sites
ipetrov1974 Newbie

ipetrov1974

Posted
Posted
Make sure you don't name the databases (mangos;characters;realmd) on the sqlyog login screen before you've created them. Leave that line blank, go in, create the databases, then step back out and type their names in.
Thanks man,

but I already solved this problem using basic mysql command line client.

Link to comment
Share on other sites
 Share
Go to topic listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use