Trouble inatalling Weathermap plugin

[oknetman]

I am getting errors installing weathermap plugin. I can create maps and they are in the list but I can;t activate them.

12/26/2011 11:30:04 PM - WEATHERMAP: Poller[0] WARNING: No activated maps found. [WMPOLL05]
12/26/2011 11:30:04 PM - 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"
12/26/2011 11:30:04 PM - WEATHERMAP: Poller[0] DEBUG: [weathermap_memory_check@poller-common.php:11] MEM Initial: memory_get_usage() says 6.9MBytes used. Limit is 512M
12/26/2011 11:30:04 PM - WEATHERMAP: Poller[0] Weathermap 0.97a starting - DEBUG mode is on
12/26/2011 11:30:04 PM - SYSTEM STATS: Time:1.5300 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:15
12/26/2011 11:30:04 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /srv/www/htdocs/cacti/rra/airportxtreme_traffic_in_17.rrd --template traffic_out:traffic_in 1324963804:1343536102:1005587021
12/26/2011 11:30:04 PM - WEATHERMAP: Poller[0] WM poller_output: ENDING
12/26/2011 11:30:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select distinct weathermap_data.id, weathermap_data.last_value, weathermap_data.last_time, weathermap_data.data_source_name, data_template_data.data_source_path, data_template_data.local_data_id, data_template_rrd.data_source_type_id from weathermap_data, data_template_data, data_template_rrd where weathermap_data.local_data_id=data_template_data.local_data_id and data_template_rrd.local_data_id=data_template_data.local_data_id and weathermap_data.local_data_id<>0;"
12/26/2011 11:30:04 PM - WEATHERMAP: Poller[0] WM poller_output: STARTING
12/26/2011 11:30:04 PM - CMDPHP: Poller[0] Time: 0.8255 s, Theads: N/A, Hosts: 3
12/26/2011 11:30:04 PM - CMDPHP: Poller[0] Host[3] DS[17] SNMP: v1: 192.168.0.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9, output: 1343536102
12/26/2011 11:30:04 PM - CMDPHP: Poller[0] Host[3] DS[17] SNMP: v1: 192.168.0.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, output: 1005587021
12/26/2011 11:30:04 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /srv/www/htdocs/cacti/rra/airportxtreme_traffic_in_16.rrd --template traffic_out:traffic_in 1324963804:0:0
12/26/2011 11:30:04 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /srv/www/htdocs/cacti/rra/airportxtreme_traffic_in_15.rrd --template traffic_in:traffic_out 1324963804:1978994097:1148900446
12/26/2011 11:30:04 PM - WEATHERMAP: Poller[0] WM poller_output: ENDING
12/26/2011 11:30:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select distinct weathermap_data.id, weathermap_data.last_value, weathermap_data.last_time, weathermap_data.data_source_name, data_template_data.data_source_path, data_template_data.local_data_id, data_template_rrd.data_source_type_id from weathermap_data, data_template_data, data_template_rrd where weathermap_data.local_data_id=data_template_data.local_data_id and data_template_rrd.local_data_id=data_template_data.local_data_id and weathermap_data.local_data_id<>0;"

Any suggestions?

[islamgul]

I have the same problem as below:

01/05/2012 01:00:02 PM - 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"
01/05/2012 01:00:02 PM - WEATHERMAP: Poller[0] WARNING: No activated maps found. [WMPOLL05]
01/05/2012 01:00:02 PM - WEATHERMAP: Poller[0] STATS: Weathermap 0.97a run complete - Thu, 05 Jan 12 13:00:02 +0000: 0 maps were run in 0 seconds with 0 warnings.

I have tried a number of things but did not work

I am using the cacti version with builtin plugin support.

Any Idea?

[Howie]

There isn't a cacti version with builtin plugin support, as far as I know.

If you look in the database, do the weathermap_maps and weathermap_groups tables exist?

[cigamit]

There isn't a cacti version with builtin plugin support, as far as I know.

If you look in the database, do the weathermap_maps and weathermap_groups tables exist?

On the downloads page, there is a version of 0.8.7i that is pre-patched with the Plugin Architecture.

[Howie]

There isn't a cacti version with builtin plugin support, as far as I know.

If you look in the database, do the weathermap_maps and weathermap_groups tables exist?

On the downloads page, there is a version of 0.8.7i that is pre-patched with the Plugin Architecture.

Holy crap! Hallelujah!

[Durski]

I have the same problem. So far I hear this is related to tables not existing, because setup.php did not create them. Where is the database that's supposed to have these tables? How do I create them?

[Howie]

It's the cacti database. You can try copying the SQL CREATE statements out of setup.php...
it would be useful to know what the actual error is, if anything.

It may be as simple as change the TYPE=MyISAM to read ENGINE=MyISAM, actually. I know some newer versions have dropped support for the older syntax. This is already changed in svn.

[Durski]

Should I wait for a 0.98 release, or dig in to troubleshooting this? The errors appear to all be of the flavor:
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146',

[Howie]

That's just Cacti's generic 'the query failed' message.

It would be useful to try pasting one of those CREATE TABLE commands into mysql, and see what the real error is.

0.98 is still going to be a while - my spare time is being taken up with real life at the moment.

[Durski]

0.98 is in svn? I don't see it, maybe I don't know what I'm looking for. I'd like to try that before I dive down this rabbit hole

[Durski]

Do I need a mySQL viewer or something? It's been a while since I've messed with SQL. So I have 2 questions, where is the cacti sql database, and how do I run commands against it? I'm familiar with the syntax of SQL, just forgot how to interface with it.

[Howie]

(Sorry this is going to sound ruder than intended)... I don't have spare time to go into a lot of detail. You'd use phpMyAdmin usually - I suggest grabbing a LAMP tutorial which covers the basics of accessing mysql databases.

[Durski]

Point me in the direction of the cacti database and I'll get out of your hair

[Howie]

It's the database you created when you installed Cacti. The details will be in include/config.php

[Joost]

I'm seeing the same problem on my staging-server which I recently installed with 0.8.7i.

I'll have a look to see if I can manually add the necessary tables, although.. I foresee a challenge