µManager for Mangos

[rilex]

You shouldn't have any errors.

If you can start fresh on your MicroManager database, apply the following:

Extract:

\\Setup\\Full_DB_0.7.5\\en_US\\microManager_sql

microManager.sql will create the microManager database.

Then apply, in the following order (these are mixed between Global_Updates and the en_US folder):

2009-01-03_configuration.sql

2009-01-11_lookup_spellfilename.sql

2009-01-11_lookup_talent_spells.sql

2009-01-12_lookup_item_displayid.sql

2009-01-15_lookup_maps.sql

2009-02-24_configuration.sql

2009-03-05_configuration.sql

2009-03-28_configuration.sql

2009-03-28_globalconfiguration.sql

2009-04-04_acctunlock.sql

2009-04-04_globalconfiguration.sql

2009-4-27_expansion.sql

2009-06-10_offset_313.sql

2009-07-11_offset_313.sql

2009-07-11_lookup_allegiance.sql

2009-07-11_lookup_class.sql

2009-07-11_lookup_race.sql

2009-07-11_lookup_rank.sql

[3KyNoX]

it was needed to apply sql files in order mixing between directories, thanks.

trying to resolve other problem, i'll inform u.

Thanks for help.

[rilex]

Cool...some day I'll get those SQL files sorted properly...

[3KyNoX]

1. Applied FULL 7.5 sql file to empty database without error and in order, files u told me to apply to database :

2009-01-03_configuration.sql return 2 errors ( / 3 queries) :

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `configuration` VALUES
('MangosLogs', NULL);
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `configuration` VALUES
('MangosCrashLogs', NULL);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

2009-02-24_configuration.sql return same errors ( / 3 queries) :

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `configuration` VALUES
('DownloadIcons','FALSE');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `configuration` VALUES
('IconPath',NULL);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

2009-03-05_configuration.sql return 1 error ( / 2 queries) :

[Err] 1054 - Unknown column 'Item' in 'field list'
[Err] INSERT INTO `configuration` (`Item`,`Value`) VALUES
('CreateGMLevel',0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

================================================================

About the first problem to access Web.config file, i replaced that code :

Dim rootWebConfig As Configuration
           rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~/")
           Dim micromanagerConnString As New ConnectionStringSettings
           micromanagerConnString = rootWebConfig.ConnectionStrings.ConnectionStrings("micromanager")
           Dim micromanagerCS As New MySqlConnection(micromanagerConnString.ToString())

by this one :

Dim micromanagerConnString As New ConnectionStringSettings
           micromanagerConnString = System.Configuration.ConfigurationManager.ConnectionStrings("micromanager")
           Dim micromanagerCS As New MySqlConnection(micromanagerConnString.ToString())

ConfigurationManager itself locate Web.config.

i did the same for realmd, mangos, etc....

But... When i launch the solution and login, i got no errors but screen freeze on loading. I tried follow process step by step (F11) and it connect correctly with mySQL.

I'll check the database for that freeze problem.

Thanks.

[rilex]

By deleting:

rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~/")

...you're not even opening the web.config file to get the connection string, so the browser will hang. There is something wrong with the way you pulled the project.

[3KyNoX]

While passing step by step, it return configuration informations included inside web.config (server host, database login, database password, database name, etc...) so yes it get inside web.config.

realmdConnectionString = "Database=realmd;Data Source=IP....;User Id=root;Password=password_masked;Pooling=False;Max Pool Size=500;Min Pool Size=1;Connection Lifetime=30; Allow Zero Datetime=true"

mySQLCOnnection realmdCS object got all that it need and connect correctly.

[rilex]

34151 includes a bunch of pages converted from Repeaters to ListViews. Still working on eliminating the Repeaters, but there are only a few more to go. After I'm done with that, I'll release 0.8.

[bosit]

Thanks for the hard work, it's a great program Maybe with the new release you could add more detailed installation instructions. I've been having problems with the database, mainly don't know if I have to apply the global updates first or the en_gb updates (an up to date sql with all updates included would be even better )

[rilex]

Yep, I will.

You have to apply them in order of date. I think what I may do in the future is instead of seperating them out between folders, is to just append _en-US, _gr-GR, etc. to the file name.

[bosit]

Hm then something seems wrong... I create a new micromanager database, execute the full 0.7.5 SQL and after that the first chronological update is:

Global updates-> 2009-01-03_configuration.sql

Which gives me an error:

[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `configuration` VALUES

('MangosLogs', NULL);

[Msg] Finished - Unsuccessfully

[rilex]

I'll have to export a new base copy of the database to make it easier. Seems like that is a pain-point

[bosit]

That would be most welcome I could check out the error myself since I do know SQL but I've lost so much time making ISS work on Win 7 for this that I've given up

I'll be glad to make a Greek translation if you point me to the right direction

[rilex]

34247 contains a packaged template database for what will be release 0.8. You can find it at:

\\MicroManager\\Setup\\Full_DB_0.8

This is for en-US (English) only -- I'm not an expert at any other languages This database will _DROP_ your existing microManager database and does NOT contain any new updates since the last SQL updates in 2009-07-11. I don't plan on making any changes between now and the release of 0.8.

I hope this works for you guys that were having trouble with all of the updates that have come out since 0.7.5.

[rilex]

A translation how-to is at:

http://micromanager.codeplex.com/Wiki/View.aspx?title=Creating%20Translations

[rogermangos]

I did lot of research and tried a few solutions but still keep getting iis errors. Any insight?

HTTP Error 500.19 - Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid.

[bosit]

I was getting that too. Google the error and you'll find a page that guides you through some changes you need to make to a config file of ISS to get around that

[rogermangos]

I was getting that too. Google the error and you'll find a page that guides you through some changes you need to make to a config file of ISS to get around that

Well, I did try lot of solution provided by google 's results, such as relocate web folder to wwwroot, change IIS_IUSR account to proper rights, make sure physical dir is correct, etc, so far, none of them worked for me.

And I did read through .docx installation instructions, that's why i'm here to see if i can get luck.

Edit:

ok, problem defused.

Reinstalled ASP.NET, problem solved.

Thank you.

[bosit]

Thanks for the new SQL rilex Unfortunately I can't apply it (even dropped my old DB manually).

Here's the log:

[Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
[Err] replace into `lookup_spellfilename`(`spell_id`,`filename`) values (1,'trade_engineering'),
(3,'trade_engineering'),
(4,'trade_engineering'),
(5,'inv_misc_bone_humanskull_01'),
(7,'spell_shadow_lifedrain'),
(10,'spell_frost_icestorm'),
(11,'spell_frost_frostbolt02'),
(12,'trade_engineering'),
(13,'trade_engineering'),
(14,'trade_engineering'),
(15,'trade_engineering'),
(17,'spell_holy_powerwordshield'),
(18,'trade_engineering'),
(22,'trade_engineering'),
(24,'trade_engineering'),
(25,'spell_frost_stun'),
(26,'trade_engineering'),
(27,'trade_engineering'),
(31,'trade_engineering'),
(33,'trade_engineering'),
(34,'trade_engineering'),
(35,'trade_engineering'),
(43,'ability_racial_bloodrage'),
(45,'ability_bullrush'),
(47,'trade_engineering'),
(49,'spell_holy_layonhands'),
(50,'spell_shadow_mindbomb'),
(53,'ability_backstab'),
(56,'inv_mace_02'),
(58,'trade_engineering'),
(59,'trade_engineering'),
(60,'trade_engineering'),
(61,'trade_engineering'),
(65,'spell_nature_invisibilty'),
(66,'ability_mage_invisibility'),
(67,'spell_holy_vindication'),
(68,'trade_engineering'),
(71,'ability_warrior_defensivestance'),
(72,'ability_warrior_shieldbash'),
(75,'ability_whirlwind'),
(77,'trade_engineering'),
(78,'ability_rogue_ambush'),
(81,'spell_nature_invisibilty'),
(87,'spell_holy_fanaticism'),
(89,'spell_shadow_cripple'),
(91,'ability_shockwave'),
(96,'ability_backstab'),
(99,'ability_druid_demoralizingroar'),
(100,'ability_warrior_charge'),
(101,'ability_rogue_trip'),
(107,'ability_defend'),
(108,'trade_engineering'),
(110,'trade_engineering'),
(111,'trade_engineering'),
(112,'trade_engineering'),
(113,'spell_frost_chainsofice'),
(116,'spell_frost_frostbolt02'),
(118,'spell_nature_polymorph'),
(120,'spell_frost_glacier'),
(122,'spell_frost_frostnova'),
(124,'trade_engineering'),
(126,'spell_shadow_evileye'),
(128,'inv_misc_gem_sapphire_01'),
(130,'spell_magic_featherfall'),
(131,'spell_shadow_demonbreath'),
(132,'spell_shadow_detectlesserinvisibility'),
(133,'spell_fire_flamebolt'),
(134,'spell_fire_immolation'),
(136,'ability_hunter_mendpet'),
(139,'spell_holy_renew'),
(142,'trade_engineering'),
(143,'spell_fire_flamebolt'),
(145,'spell_fire_flamebolt'),
(168,'spell_frost_frostarmor02'),
(172,'spell_shadow_abominationexplosion'),
(184,'spell_fire_immolation'),
(196,'inv_axe_01'),
(197,'inv_axe_04'),
(198,'inv_mace_01'),
(199,'inv_mace_04'),
(200,'inv_spear_06'),
(201,'ability_meleedamage'),
(202,'ability_meleedamage'),
(203,'ability_golemthunderclap'),
(204,'ability_racial_shadowmeld'),
(205,'spell_frost_frostbolt02'),
(227,'inv_staff_08'),
(228,'spell_magic_polymorphchicken'),
(246,'spell_nature_slow'),
(260,'trade_engineering'),
(261,'trade_engineering'),
(264,'inv_weapon_bow_05'),
(265,'spell_shadow_shadetruesight'),
(266,'inv_weapon_rifle_01'),
(269,'trade_engineering'),
(271,'spell_shadow_deathcoil'),
(284,'ability_rogue_ambush'),
(285,'ability_rogue_ambush'),
(324,'spell_nature_lightningshield'),
(325,'spell_nature_lightningshield'),
(331,'spell_nature_magicimmunity'),
(332,'spell_nature_magicimmunity'),
(339,'spell_nature_stranglevines'),
(348,'spell_fire_immolation'),
(355,'spell_nature_reincarnation'),
(370,'spell_nature_purge'),
(379,'spell_nature_skinofearth'),
(403,'spell_nature_lightning'),
(408,'ability_rogue_kidneyshot'),
(421,'spell_nature_chainlightning'),
(427,'trade_engineering'),
(428,'trade_engineering'),
(430,'inv_drink_07'),
(431,'inv_drink_07'),
(432,'inv_drink_07'),
(436,'trade_engineering'),
(437,'trade_engineering'),
(438,'trade_engineering'),
(439,'trade_engineering'),
(440,'trade_engineering'),
(441,'trade_engineering'),
(442,'trade_engineering'),
(443,'trade_engineering'),
(444,'trade_engineering'),
(445,'trade_engineering'),
(446,'trade_engineering'),
(447,'trade_engineering'),
(448,'trade_engineering'),
(453,'spell_holy_mindsooth'),
(454,'temp'),
(456,'spell_nature_nullward'),
(457,'spell_shadow_mindsteal'),
(458,'ability_mount_ridinghorse'),
(459,'ability_mount_whitedirewolf'),
(461,'spell_holy_innerfire'),
(463,'spell_holy_resurrection'),
(464,'trade_engineering'),
(465,'spell_holy_devotionaura'),
(467,'spell_nature_thorns'),
(468,'ability_mount_ridinghorse'),
(469,'ability_warrior_rallyingcry'),
(470,'ability_mount_nightmarehorse'
[Msg] Finished - Unsuccessfully

What kind of encoding does the DB need? I recall reading somewhere it needs some specific encoding, maybe that's why I'm having trouble.

Greek translation will be ready tomorrow

[rogermangos]

I'll have to export a new base copy of the database to make it easier. Seems like that is a pain-point

Yes, Please, I followed exact sql order as instructed above, I 'm able to get login screen, but when try to login i got this

Please sort out code version respect to sql version like udb did. Jumping here and there apply sql is really a pain in ass.

[rilex]

What kind of encoding does the DB need? I recall reading somewhere it needs some specific encoding, maybe that's why I'm having trouble.

Database is UTF8. See this for that particular error:

http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

I think my Mysql.ini is set to 64M.

rogermangos, when I get home I'll fix that. We shouldn't be returning a string to an int.

[bosit]

Database is UTF8. See this for that particular error:

http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

I think my Mysql.ini is set to 64M.

rogermangos, when I get home I'll fix that. We shouldn't be returning a string to an int.

Thanks, I was using the default 1M, changed to 32M and executed fine.

It works pretty nicely now, but I can't control the services:

Mangosd Service: Access is Denied or Unknown

Realmd Service: Access is Denied or Unknown

I've set the path to the config files in the setup screen. Also Tools->Mangos Config has the correct paths too but the contents of the config files don't show in the edit boxes.

Using Mangos rev 8541

[rilex]

The paths are relative to the web server. So if you're running MaNGOS and the microManager on the same server, you would add:

C:\\mypath\\mangsod.conf (or use quotes if there are spaces)

Also, the user account running the Application Pool must have at least read access (if you want to view) or Modify access (if you want to be able to write) to the config files.

The user running the Application Pool also needs similar rights as a service, though off hand I forget what that is (although for testing purposes only, promoting the user to an administrator will work -- OR using the same user for the App Pool that you use to run the Mangos services). Of course, you need to set Mangos to run as a service

[bosit]

The paths are relative to the web server. So if you're running MaNGOS and the microManager on the same server, you would add:

C:\\mypath\\mangsod.conf (or use quotes if there are spaces)

Also, the user account running the Application Pool must have at least read access (if you want to view) or Modify access (if you want to be able to write) to the config files.

The user running the Application Pool also needs similar rights as a service, though off hand I forget what that is (although for testing purposes only, promoting the user to an administrator will work -- OR using the same user for the App Pool that you use to run the Mangos services). Of course, you need to set Mangos to run as a service

OK my path does have spaces, but this: 'C:\\WoW Server\\mangos\\realmd.conf' didn't work either (tried " " as well)

Gah stupid me, somehow I was somehow mistaking service with application. So to get that data I'll have to add em as services huh? Wouldn't that hide the console logs from me? Cause I want to see what's going on and that wouldn't work for me

[rilex]

Does your user account running the Application Pool have access to that path? Is the mangos install on the same server as the web server (it doesn't have to be, but if it isn't, you have to use a UNC)?

Wouldn't that hide the console logs from me?

It would hide the console from you, yes. Currently the only thing microManager exposes are the crash logs and config files... Should be simple to set up one that exposes the console logs.

[bosit]

Does your user account running the Application Pool have access to that path? Is the mangos install on the same server as the web server (it doesn't have to be, but if it isn't, you have to use a UNC)?

It would hide the console from you, yes. Currently the only thing microManager exposes are the crash logs and config files... Should be simple to set up one that exposes the console logs.

Yeah the user account is a PC admin and has all priviledges on the whole path (I even checked the files individually) . Yes I'm running the web server from the same machine mangos runs, launching μmanager in localhost.

Would be nice, but I'd want it to update dynamically as it is done on the console. Someone could even take it as far as filtering for example battle messages from area updates/battleground resets etc to have an even better overview of what's going on. Another great feature would be a simple search function in both items list and game objects I could give you a hand with the SQLs if you want (ok I'll stop asking for more features now hehe).

Great program though