Not able to add a maps ( 0.8.8h, Win2012R2, IIS)

[ErikVC]

Dear all,
I have a Cacti (Version 0.8.8h) freshly installed on Windows server 2012R2 Using IIS webserver, and all basics are running fine (stats, graphs, ...).
I have added the weathermap plugin, added all weathermap rights for my user in User Management / Realm and gave "IUSR" (the default IIS user) the necessary rights in C:\inetpub\wwwroot\cacti\plugins\weathermap\configs.
The weathermap editor works, and can create and edit config files. However, I don't seem to be able to add weathermaps (config files) in the display.
This is what happens: in the console, I click "Weathermaps" menu on the left side, then in the right pane I click "Add" to add a weathermap,
I see the list of existing config files under "Available Weathermap Configuration Files" and I can use the "View" button to see the config file (opens new tab with view of the config file text),
However when I click "Add" to add the file, it jumps back to the previous screen without adding the map.
Because I tought this could also be related to some user rights, I gave IUSR all rights to the weathermap directory, but that doesn't seem to solve the issue. Would anyone have another good idea? Or could I test something outside of the web interface?

I should have seen and added this earlier; I do have errors in the cacti log. When I try adding a config file as an map to display by adding it, these are the errors that are spawned:
>>>>>>>>>>>>>>
05/23/2016 10:28:59 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select weathermap_maps.*, weathermap_groups.name as groupname from weathermap_maps, weathermap_groups where weathermap_maps.group_id=weathermap_groups.id order by weathermap_groups.sortorder,sortorder"
05/23/2016 10:29:04 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from weathermap_maps"
05/23/2016 10:29:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"insert into weathermap_maps (configfile,titlecache,active,imagefile,htmlfile,filehash,config) VALUES ('network.conf','Dubai Network Map','on','','','','')'
05/23/2016 10:29:07 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set filehash=LEFT(MD5(concat(id,configfile,rand())),20) where id=0'
05/23/2016 10:29:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from weathermap_maps order by group_id,sortorder;"
05/23/2016 10:29:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select weathermap_maps.*, weathermap_groups.name as groupname from weathermap_maps, weathermap_groups where weathermap_maps.group_id=weathermap_groups.id order by weathermap_groups.sortorder,sortorder"
>>>>>>>>>>>>>>>>>

[Howie]

Check if the weathermap_* tables were created correctly in the mysql database.

You can see the list of database tables inside Cacti by going to the Utilities..System Utilities page and choosing Technical Support. There should be 5 tables named weathermap_* near the bottom of the table list.

If not - which version of mysql is this? And which version of weathermap?

[ErikVC]

The weathermap tables I find in the "MySQL Table Information" are the 4 following:
weathermap_auth 21 MyISAM utf8_general_ci
weathermap_data 0 MyISAM utf8_general_ci
weathermap_groups 1 MyISAM utf8_general_ci
weathermap_settings 0 MyISAM utf8_general_ci

I installed Weathermap 0.97c, but the Cacti Plugin Management says "0.97b" .
The mysql was installed with Cacti 0.8.8h; the install log said "Installing MySQL 5.6.27..."

Thanks!

[Howie]

OK, there should also be a weathermap_maps, which stores which maps to run and their settings...

Here's a previous thread about the same issue: http://forums.cacti.net/viewtopic.php?f=16&t=54604

That is how to manually create the missing weathermap_maps table.

I'm working on a new release, but there are a few small bugfixes waiting, so I think I might make a 0.87d soon.

[ErikVC]

OK perfect,
the (corrected) script from the other thread worked fine for me. I'm attaching it for anyone having the same issue (remove the .txt extension).
Just need to run it with the following command:
mysql --user=root --password cacti < MW_correction.sql

Thanks a lot !!
I like Weathermap!

[Howie]

Cool

And this has spurred me to make a 0.97 maintenance branch for all the 'little fixes' that are piling up.

https://github.com/howardjones/network- ... aintenance

This should mean 0.97d coming soon without the little problems, and 1.0 sometime later with lots of changes.