Cacti and single oid monitoring

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Cacti and single oid monitoring

Post by rrj »

Hi.
I've got such a problem.
Everything is ok, b4 i add a querry to monitor some single oid on the host.

my steps are:
create a device
create new graph, chose SNMP OID
writing my oid in with . at start, add graph.
everything is ok and i'm reciveing those graphs, but if i add another oid on this host, i get nothing (blank graph) and alos i've got these errors:

Code: Select all

07/27/2010 12:06:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/27/2010 12:06:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/27/2010 12:10:05 PM - SYSTEM STATS: Time:4.3650 Method:spine Processes:1 Threads:1 Hosts:46 HostsPerProcess:46 DataSources:1009 RRDsProcessed:505
07/27/2010 12:12:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/27/2010 12:15:06 PM - SYSTEM STATS: Time:4.3571 Method:spine Processes:1 Threads:1 Hosts:46 HostsPerProcess:46 DataSources:1009 RRDsProcessed:505
07/27/2010 12:18:02 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/27/2010 12:20:06 PM - SYSTEM STATS: Time:4.3617 Method:spine Processes:1 Threads:1 Hosts:46 HostsPerProcess:46 DataSources:1009 RRDsProcessed:505
by the way, snmpwalk and get return data.

version
Version 0.8.7d
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

please, i need a solution. what should i do to fix these errors?
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

okay, my graphs are OK now, but what can i do about these errors? the more "SNMP - Generic OID Template" type graps i add, the more errors in logs. 1 graph = 1 error. any ideas?
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

In general, please refer to 2nd link of my sig.
In your example, it may make sense to search that OID under "System Urilities -> View Poller Cache"
R.
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

Thank You for Your reply!

yes, i can find it there, but what doest it give me?

SNMP Version: 2, Community: *, OID: .1.3.6.1.4.1.2566.127.1.2.167.103.2.3.1.17.1
RRD: /var/lib/cacti/rra/dvbt-kardla-mux1_snmp_oid_563.rrd
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please try to walk that OID manually and return your results
R.
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

You mean to run snmpget from console? its ok
SNMPv2-SMI::enterprises.2566.127.1.2.167.103.2.3.1.17.1 = STRING: "-42.4"

as i told, i've got my graphs working.. but have this error all the time in logs .. how can i get rid of them? :) thak You.
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

seems like i've got it.. i receive these errors only when i've got this in my crontab:

*/6 * * * * php /usr/share/cacti/cli/poller_graphs_reapply_names.php -id=All

why ? seems like because the signal i check has no name ?
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

OMG!!! stop that spam.
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

rrj wrote:seems like i've got it.. i receive these errors only when i've got this in my crontab:

*/6 * * * * php /usr/share/cacti/cli/poller_graphs_reapply_names.php -id=All

why ? seems like because the signal i check has no name ?
any ideas?
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

Running re-apply every 6 minutes is a bad idea. You should have poller.php at a 5 minute interval, where is that?

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

how often is a good idea then?
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

I would do it no more often than once a day, depending on how many devices and how things change on them.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

done and keep watching. but i think that this error will reoccur now just a bit rarely 1 time per day. but it will still be there... we'll see. thanks for Your reply.
Top
rrj
Posts: 12
Joined: Tue Jul 27, 2010 4:15 am

Post by rrj »

yep, as i've suspected.
i've added 3 more custom OIDs and now i've got 6 erros after
poller_graphs_reapply_names.php -id=All
command @ 12:30 AM

Code: Select all

08/17/2010 12:30:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
08/17/2010 12:30:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
08/17/2010 12:30:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
08/17/2010 12:30:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
08/17/2010 12:30:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
08/17/2010 12:30:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
can any1 help plz?
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 0 guests