Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Thu Dec 18, 2014 12:35 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Trouble inatalling Weathermap plugin
PostPosted: Mon Dec 26, 2011 6:44 pm 
Offline

Joined: Wed Dec 21, 2011 6:39 am
Posts: 4
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?


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Thu Jan 05, 2012 10:04 am 
Offline

Joined: Thu Mar 26, 2009 9:33 am
Posts: 2
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?


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Thu Jan 05, 2012 12:23 pm 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4647
Location: United Kingdom
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?

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Thu Jan 05, 2012 12:38 pm 
Offline
Developer

Joined: Thu Apr 07, 2005 3:29 pm
Posts: 1904
Location: B/CS Texas
Howie wrote:
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.

_________________
CactiEZ CD


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Fri Jan 06, 2012 4:07 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4647
Location: United Kingdom
cigamit wrote:
Howie wrote:
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! :-)

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Mon Jan 23, 2012 5:36 pm 
Offline
Cacti User

Joined: Tue Dec 15, 2009 5:30 pm
Posts: 52
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?


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Mon Jan 23, 2012 5:46 pm 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4647
Location: United Kingdom
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.

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Mon Jan 23, 2012 5:52 pm 
Offline
Cacti User

Joined: Tue Dec 15, 2009 5:30 pm
Posts: 52
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',


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Mon Jan 23, 2012 6:00 pm 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4647
Location: United Kingdom
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.

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Mon Jan 23, 2012 6:09 pm 
Offline
Cacti User

Joined: Tue Dec 15, 2009 5:30 pm
Posts: 52
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


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Tue Jan 24, 2012 10:20 am 
Offline
Cacti User

Joined: Tue Dec 15, 2009 5:30 pm
Posts: 52
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.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Tue Jan 24, 2012 10:26 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4647
Location: United Kingdom
(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.

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Tue Jan 24, 2012 10:30 am 
Offline
Cacti User

Joined: Tue Dec 15, 2009 5:30 pm
Posts: 52
Point me in the direction of the cacti database and I'll get out of your hair


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Tue Jan 24, 2012 10:40 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Sep 16, 2004 5:53 am
Posts: 4647
Location: United Kingdom
It's the database you created when you installed Cacti. The details will be in include/config.php

_________________
Weathermap 0.97c is out! & QuickTree 0.2. Superlinks is over there now.
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)

Security Notice: CVE-2013-2618 Network Weathermap 0.97a - editor security issues

My System: CentOS5 64 bit, 4 2GHz cores (Intel E5405), 8GB, Cacti 0.8.7e, Spine 0.8.7e, Weathermap 0.98dev, Superlinks 0.8, ReportIt 0.7.1, THold 0.3.9hj, Explain 0.1, Uptime 0.4hj, Realtime 0.36hj, QuickTree 0.2 - 17000 DS, 320 Hosts. 150 seconds poll.


Top
 Profile  
 
 Post subject: Re: Trouble inatalling Weathermap plugin
PostPosted: Thu Jan 26, 2012 3:12 am 
Offline

Joined: Wed May 19, 2010 7:55 am
Posts: 6
Location: Amsterdam, The Netherlands
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 :wink:

_________________
System: 2x Intel X5460 3.16GHz, 24GB, 6x 15k RPM Disks in RAID-10,
Software: Fedora 13 64 bit, Cacti 0.8.7g, Spine 0.8.7g, Weathermap 0.97a, Syslog 1.05, Thold 0.4.2


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group