Creating Mangos Server Mangos

albmans · Apr 26, 2008

Re: [Mangos] How to make a Mangos server

Great tutorial.
I've got 1 question though: I've got mangos revision 5705 (for patch 2.4.1??) but I need to know how can I configure mangosd.conf correctly so that it doesn't include VMaps? Or configure it right so that it does include VMaps, but that it works. Have you got any ideas how to solve this problem with VMaps? Ty =)
(P.S. Preferably I'd not include VMaps)

Zizuph · Apr 27, 2008

Re: [Mangos] How to make a Mangos server

I don't see a UDB Database anywhere on the forums. Yes, I registered.

Zizuph · Apr 27, 2008

Re: [Mangos] How to make a Mangos server

Using MaNGOS_5712_ScriptDev2_350_SSE, and attempting to import the mangos sql file, I get the following errors...

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`),
UNIQUE KEY `a` (`entry`,`spell`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-04-27 02:26:24
Line no.:28
Error Code: 1046 - No database selected

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-04-27 02:26:49
Line no.:26
Error Code: 1046 - No database selected

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:07:09
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:07:26
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:08:29
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:08:53
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:10:40
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:12:20
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

_____

While attempting to import the realmd sql file, I get the following errors...

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`),
UNIQUE KEY `a` (`entry`,`spell`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-04-27 02:26:24
Line no.:28
Error Code: 1046 - No database selected

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-04-27 02:26:49
Line no.:26
Error Code: 1046 - No database selected

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:07:09
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:07:26
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:08:29
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:08:53
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:10:40
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:12:20
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-04-27 15:17:30
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

czeal · Apr 28, 2008

Re: [Mangos] How to make a Mangos server

Hello,
Love the guide but this is the only error I have gotten. I can log on if I leave the ip addresses at 127.0.0.1, but once I place it as my external ip address it gives me this error everytime I try running Realmd.exe

------------------------------------------------------------------------
2008-04-28 15:53:56 ERROR:Could not connect to MySQL database at 99.139.217.112: Host 'David-PC.gateway.2wire.net' is not allowed to connect to this MySQL server
2008-04-28 15:53:56 ERROR:Cannot connect to database
------------------------------------------------------------------------

Help would be very appriciated thanks for your time.
Czeal

Kira90 · May 4, 2008

Re: [Mangos] How to make a Mangos server

Guys? ... Does mangos have an svn ... since ascents going ... I gotta know is mangos open source and plz link the svn ... ty!

albmans · May 5, 2008

Re: [Mangos] How to make a Mangos server

3 solutions;
@zizuph; You already said you didn't see a udb database. So you didn't skip the part where it says YOU HAVE TO use it! The mangos.sql file is not some kind of replacer for when you can't download the udb file... For 2.4.1 you need

To view the content, you need to sign in or register

.
And click the lowest download link.

@czeal; Make sure you change the IP row in the realmlist table in 'realmd' to your Wan IP
. Also make sure you erase the patchlist line (line 2) in realmlist.wtf in your WoW Client

@kira90; Yes, MaNGOS is open source, just look around for the svn, it should be around somewhere

pirkepirke · May 5, 2008

Re: [Mangos] How to make a Mangos server

Im working on some server and i made a shop and now how to make a teleport that the players can use it to go there. or maby can you tell me how to make teleporter npc..Please YOU ARE THE BEST !!!!!!

Delluseonist · May 10, 2008

Re: [Mangos] How to make a Mangos server

Hey dude fantastic guide, one problem...... I dont know how to setup the client to connect to the server lol. Im new to private WOW servers, ive searched for how to setup a client to connect to a private server but I want to make sure that it will be compatible to this guide. Could somone give me a link to a setup guide for the client to connect to this type of server? Thanks.

dagamerc13 · May 13, 2008

Re: [Mangos] How to make a Mangos server

I'M BACK!!
sorry guys i couldn't reply to anything because my internet was out for about a week then i wasnt home but its all good cause i'm back.
now to help:

to configure the client simply edit the realmlist.wtf file in your wow folder to the ip of the server.

and as for the teleporter i am not exactly sure because i have not experimented with that part.

Arrow123 · May 13, 2008

Re: [Mangos] How to make a Mangos server

PSSSTT Update the main topic, lots of dead rz links

Dopestar · May 14, 2008

Re: [Mangos] How to make a Mangos server

Arrow123 said:
PSSSTT Update the main topic, lots of dead rz links

updated the first post although I couldn't find a working link to the Vmap extractor so if anyone could upload that I cant edit that link also

dagamerc13 · May 16, 2008

Re: [Mangos] How to make a Mangos server

ok i'll fix the links. thanks for telling me.

Unrealdj · May 20, 2008

Re: [Mangos] How to make a Mangos server

link for website goez X

Planium · May 25, 2008

Re: [Mangos] How to make a Mangos server

How do i get this to work with enGB?
- Don't worry, fixed it!

Ronyszkusz · May 28, 2008

Re: [Mangos] How to make a Mangos server

I have a little problem. I did everything like the guid but when i start the server it's says: "could not connect to MSQL database at 127.0.0.1: unknow database 'mangos'
Cannot connect to world database 127.0.0.1;root;ronyszkusz;mangos"
What's the problem?

redeye123 · May 28, 2008

Re: [Mangos] How to make a Mangos server

I have a little problem anyone now how to fix this

2008-05-28 14:46:07 Using configuration file mangosd.conf.
2008-05-28 14:46:07 MaNGOS daemon /0.11.0-SVN (Revision 5970) (Win32)
2008-05-28 14:46:07 <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

To view the content, you need to sign in or register

MMMMMM

2008-05-28 14:46:07 World Database: 127.0.0.1;3306;root;danny123;mangos
2008-05-28 14:46:07 MySQL client library: 5.0.56
2008-05-28 14:46:07 MySQL server ver: 5.0.51a-community-nt
2008-05-28 14:46:07 Character Database: 127.0.0.1;3306;root;danny123;characters
2008-05-28 14:46:07 MySQL client library: 5.0.56
2008-05-28 14:46:07 MySQL server ver: 5.0.51a-community-nt
2008-05-28 14:46:07 Login Database: 127.0.0.1;3306;root;danny123;realmd
2008-05-28 14:46:07 MySQL client library: 5.0.56
2008-05-28 14:46:07 MySQL server ver: 5.0.51a-community-nt
2008-05-28 14:46:07 Realm running as realm ID 1
2008-05-28 14:46:07 Using Mangos default database.
2008-05-28 14:46:07 Using DataDir ./
2008-05-28 14:46:07 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-05-28 14:46:07 WORLD: VMap data directory is: ./vmaps
2008-05-28 14:46:07 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-05-28 14:46:07
2008-05-28 14:46:07 Loading MaNGOS strings...
2008-05-28 14:46:07
2008-05-28 14:46:07 >> Loaded 474 MaNGOS strings
2008-05-28 14:46:07 Initialize data stores...
2008-05-28 14:46:07 ERROR:
Some required *.dbc files (9 from 52) not found or not compatible:
./dbc/BattlemasterList.dbc (exist, but have 32 fields instead 33) Wrong client version DBC file?
./dbc/CharTitles.dbc (exist, but have 20 fields instead 37) Wrong client version DBC file?
./dbc/ChrClasses.dbc (exist, but have 24 fields instead 58) Wrong client version DBC file?
./dbc/ChrRaces.dbc (exist, but have 35 fields instead 69) Wrong client version DBC file?
./dbc/CreatureDisplayInfo.dbc (exist, but have 21 fields instead 14) Wrong client version DBC file?
./dbc/ItemExtendedCost.dbc (exist, but have 13 fields instead 14) Wrong client version DBC file?
./dbc/Map.dbc (exist, but have 123 fields instead 125) Wrong client version DBC file?
./dbc/Spell.dbc (exist, but have 211 fields instead 213) Wrong client version DBC file?
./dbc/SpellShapeshiftForm.dbc (exist, but have 23 fields instead 35) Wrong client version DBC file?

dagamerc13 · May 30, 2008

Re: [Mangos] How to make a Mangos server

Ronyszkusz: your problem is that it cannot find the database mangos in your sql database. make sure that you named the database mangos when you uploaded it.

redeye: your problem is an incorrect version of dbc files with your mangos version.

example: your mangos rev will only work on a certain version of wow, if your server version doesn't match your client version then you would be taking outdated dbc files from the client.

Delluseonist · Jun 1, 2008

Re: [Mangos] How to make a Mangos server

When you go to the downloads for the mangos core folder, which revision is conpatible with a 2.0.12 client ? Because there are a hell of a lot in that list and I dont wanna download the wrong one.

dagamerc13 · Jun 6, 2008

Re: [Mangos] How to make a Mangos server

sorry but i have no clue how far back you'd have to go for a 2.0.x server rev. if you could even find it at all.

Delluseonist · Jun 9, 2008

Re: [Mangos] How to make a Mangos server

ok cool. Well what client version do I need to connect to a mangos 5844 core version running UDB 9.0??? also, the client section of your guide only goes up to 2.1.3 so if I need anything later than that where can I get the patches? - BTW thanks for your help so far

Creating Mangos Server Mangos

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Experienced Elementalist

Junior Spellweaver

Initiate Mage

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Your omega

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Initiate Mage

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners