"No weahtermap configured" Weathermap 0.97c & Cacti 0.8.8c

[alvin3088]

Hello,

I have a problem with my installation of Weathermap.
About my system :
Cacti is on Windows Server 2012 R2
Version : 0.8.8c
Weathermap version 0.97c
mySQL : 5.6.24

I cannot add a new map to weathermap configuration. Could you help me to solve this issue?

here is a latest cacti log, below:
05/13/2015 12:05:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select m.*, g.name as groupname from weathermap_maps m,weathermap_groups g where m.group_id=g.id and active='on' order by sortorder,id"
05/13/2015 12:05:02 AM - WEATHERMAP: Poller[0] WARNING: No activated maps found. [WMPOLL05]
05/13/2015 12:05:02 AM - WEATHERMAP: Poller[0] STATS: Weathermap 0.97c run complete - Wed, 13 May 15 00:05:02 -0700: 0 maps were run in 0 seconds with 0 warnings.
05/13/2015 12:09:05 AM - AUTH LOGIN: User 'admin' Authenticated
05/13/2015 12:09:09 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/13/2015 12:09:11 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from weathermap_maps"
05/13/2015 12:09:19 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"insert into weathermap_maps (configfile,titlecache,active,imagefile,htmlfile,filehash,config) VALUES ('example.conf','Network Overview','on','','','','')'
05/13/2015 12:09:19 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/13/2015 12:09:19 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from weathermap_maps order by group_id,sortorder;"
05/13/2015 12:09:19 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/13/2015 12:09:40 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select weathermap_maps.*, weathermap_groups.name as group_name from weathermap_auth,weathermap_maps, weathermap_groups where weathermap_groups.id=weathermap_maps.group_id and weathermap_maps.id=weathermap_auth.mapid and active='on' and (userid=1 or userid=0) order by weathermap_groups.sortorder"
05/13/2015 12:09:40 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select distinct weathermap_maps.* from weathermap_auth,weathermap_maps where weathermap_maps.id=weathermap_auth.mapid and active='on' and (userid=1 or userid=0) order by sortorder, id"
05/13/2015 12:09:40 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select weathermap_maps.*, weathermap_groups.name as group_name from weathermap_auth,weathermap_maps, weathermap_groups where weathermap_groups.id=weathermap_maps.group_id and weathermap_maps.id=weathermap_auth.mapid and active='on' and (userid=1 or userid=0) order by weathermap_groups.sortorder"
05/13/2015 12:10:01 AM - CMDPHP: Poller[0] Host[1] DS[3] WARNING: Result from CMD not valid. Partial Result: U
05/13/2015 12:10:01 AM - CMDPHP: Poller[0] Host[1] DS[4] WARNING: Result from CMD not valid. Partial Result: U
05/13/2015 12:10:01 AM - CMDPHP: Poller[0] Host[1] DS[5] WARNING: Result from CMD not valid. Partial Result: U
05/13/2015 12:10:01 AM - CMDPHP: Poller[0] Host[1] DS[6] WARNING: Result from CMD not valid. Partial Result: U
05/13/2015 12:10:01 AM - CMDPHP: Poller[0] Host[1] DS[7] WARNING: Result from CMD not valid. Partial Result: U
05/13/2015 12:10:02 AM - SYSTEM STATS: Time:1.8829 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:49 RRDsProcessed:27
05/13/2015 12:10:02 AM - WEATHERMAP: Poller[0] Weathermap 0.97c starting - Normal logging mode. Turn on DEBUG in Cacti for more information

05/13/2015 12:10:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select m.*, g.name as groupname from weathermap_maps m,weathermap_groups g where m.group_id=g.id and active='on' order by sortorder,id"
05/13/2015 12:10:02 AM - WEATHERMAP: Poller[0] WARNING: No activated maps found. [WMPOLL05]
05/13/2015 12:10:02 AM - WEATHERMAP: Poller[0] STATS: Weathermap 0.97c run complete - Wed, 13 May 15 00:10:02 -0700: 0 maps were run in 0 seconds with 0 warnings.


and mysql show tables;
mysql> show tables;
+---------------------------+
| Tables_in_cacti |
+---------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| plugin_config |
| plugin_db_changes |
| plugin_hooks |
| plugin_realms |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_reindex |
| poller_time |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
| weathermap_auth |
| weathermap_data |
| weathermap_groups |
| weathermap_settings |
+---------------------------+

Anyone can help me how to resolve this?

Thank You.

[randms26]

I think I have the same problem, the weathermap_maps table is not present on the cacti database

i've tried to add it manually but still no luck. I got this error while creating the table (see attached)

FYI i'm using mysql server 5.6 and here's the syntax I used

Code: Select all

CREATE TABLE weathermap_maps (
            id int(11) NOT NULL auto_increment,
            sortorder int(11) NOT NULL default 0,
            group_id int(11) NOT NULL default 1,
            active set('on','off') NOT NULL default 'on',
            configfile text NOT NULL,
            imagefile text NOT NULL,
            htmlfile text NOT NULL,
            titlecache text NOT NULL,
            filehash varchar (40) NOT NULL default '',
            warncount int(11) NOT NULL default 0,
            config text NOT NULL default '',
            thumb_width int(11) NOT NULL default 0,
            thumb_height int(11) NOT NULL default 0,
            schedule varchar(32) NOT NULL default '*',
            archiving set('on','off') NOT NULL default 'off',
            PRIMARY KEY  (id)
         );

did you have your issue solved bro?

[Howie]

This:

Code: Select all

            config text NOT NULL default '',

should be this:

Code: Select all

            config text NOT NULL,

I don't know what has changed to make it a fatal error - that has always been in there. It was always incorrect, too, but Mysql has become more fussy!

[randms26]

This:

Code: Select all

            config text NOT NULL default '',

should be this:

Code: Select all

            config text NOT NULL,

I don't know what has changed to make it a fatal error - that has always been in there. It was always incorrect, too, but Mysql has become more fussy!

wow, thanks for the correction Howie.
however, I'm still getting error while inserting those syntax but then I tried typing the whole syntax horizontally (without line break) instead of typing them line by line, and it works!

hey bro alvin3088 i think you should also try this