Creating Mangos Server

Printable View

Show 100 post(s) from this thread on one page

15-04-08
QuicksilverFX

Re: [Mangos] How to make a Mangos server

Quote:

Originally Posted by HypoCentruM

Thanks for the GREAT guide...
I've already set up the server and it is working..
but how can i change the drop rate from the bosses?
i make the rate like this

i've tried to increase or decrease the rate but the bosses only drop 3 or 2 equipments.
anyone can help :)

try GM command?

[youtubevid]oMaTZFCLbq0[/youtubevid]
15-04-08
Auris782

Re: [Mangos] How to make a Mangos server

Firstly, I'd just like to say, this guide is a godsend. Initially I didn't even know where to start with MaNGOS... and thanks to this guide, now I've stumbled on my first server admin bug.

Anyway, onto the problem. I've worked through the guide using the resources provided within, yet upon initialization of mangosd.exe, an error is produced:

Loading Game Object Templates...
Error in gameobject_template, probably SQL file format was updated (there should be 33 fields in SQL).

I can't seem to isolate the cause of this. I've used the UDB release 0.9.3, MaNGOS 5629, and with WoW-TBC US Patch 2.3.3.

This error was avoided when I tried using the magnos.sql file in the sql folder instead of the UDB sql file, but naturally, that database was empty, which presented an issue. Or rather, a lack of them, as well as a lack of... anything. Also, when I attempted to connect like this, the WoW title screen instead displayed the title of the last server I'd connected to, and a login attempt resulted in the everlasting handshake.

So, I reverted to UDB 0.9.3, and sure enough, the error returns. And I'm once again stumped.

Any assistance or tips would be greatly appreciated.

-Edit-
Directly above the aforementioned error, mangosd.exe reports that 'locales_creature', 'locales_gameobject', 'locales_item', 'locales_quest', 'locales_npctext' and 'locales_pagetext' are all empty. Could be related so I thought I should add that.
15-04-08
dagamerc13

Re: [Mangos] How to make a Mangos server

Auris thank you for the compliment. that goes a long way!

your error is linked to incompatible mangos version for you udb. check the rev number they recommend for udb 0.9.3 on their forums and use that version. same for you pirke

mangos has not come to be with the 2.4.1 generally what they do is work all the bugs out first unlike ascent that releases quickly with bugs.

.......... :2gunsfiring_v1::smilie_xp
15-04-08
Auris782

Re: [Mangos] How to make a Mangos server

Ah, thank you. I must admit, with this being my first foray into emulation, the version numbers were rather confusing and I took "5578+" a little too literally without realising 5629 was a much newer version. I shall try an earlier version, one released closer to UDB 0.9.3.

-Edit-
Is now working like a dream with MaNGOS 5580. Thank you again.
15-04-08
pirkepirke

Re: [Mangos] How to make a Mangos server

The HELP you are giving is great :D thanks for all. Soo is the "UDB_o.9.3_core_5578_SD2_323." good with "MaNGOS_4847_ScriptDev2_203_SSE_MCH_NoSave"??BEcause i havent try it.thanks :D
21-04-08
dagamerc13

Re: [Mangos] How to make a Mangos server

try core 5575 for udb 0.9.3
22-04-08
katmiaugo

Re: [Mangos] How to make a Mangos server

Aid
I have updated with mangos 5684-2.4.1 UDB 0.10, and do not work as trainer PCP use the patch udb and remains the same.
Dagamerc13 you could advise me something please
22-04-08
Nehrova

Re: [Mangos] How to make a Mangos server

for trainer fix execute this into your db
download ---Here---
24-04-08
Dirtpatch

Re: [Mangos] How to make a Mangos server

Thanks for the tut. I have a problem though and would appreciate any help. after install and run, i can connect , create characters, play, etc, but there are no loot items. seems that my loot definitions are empty. any ideas? thanks
26-04-08
dagamerc13

Re: [Mangos] How to make a Mangos server

udb will be releasing a db to work with 2.4.x soon. many problems will be worked out when its released.
26-04-08
albmans

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)
27-04-08
Zizuph

Re: [Mangos] How to make a Mangos server

I don't see a UDB Database anywhere on the forums. Yes, I registered.
27-04-08
Zizuph

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
28-04-08
czeal

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
04-05-08
Kira90

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!

Show 100 post(s) from this thread on one page