Search found 100 matches

by philipz
Mon Jun 18, 2012 6:50 am
Forum: Help: Linux/Unix Specific
Topic: Need help tweaking spine
Replies: 1
Views: 441

Need help tweaking spine

All, I am sometimes running into issues with spine, where it cannot process all hosts within a minute. I have 763 hosts with about 10.000 datasources. Typically, the statistics look like this: 06/18/2012 01:41:35 PM - SYSTEM STATS: Time:35.0389 Method:spine Processes:2 Threads:10 Hosts:763 HostsPerP...
by philipz
Wed Jun 13, 2012 6:10 am
Forum: Help: General
Topic: ERROR: SQL Cell Failed!, Error:'1064'
Replies: 11
Views: 3176

Re: ERROR: SQL Cell Failed!, Error:'1064'

The table "colors" was accessed when the error occurs. That makes sense only when - either a graph is displayed - or a graph is exported It may happen, that you have a graph template that is referring to a color that does not exist anymore. R. Hmm, I tried to find the source of the error but no luc...
by philipz
Fri May 25, 2012 3:02 am
Forum: Help: General
Topic: ERROR: SQL Cell Failed!, Error:'1064'
Replies: 11
Views: 3176

Re: ERROR: SQL Cell Failed!, Error:'1064'

No, you won't. We are enumerating the colors using mysql autoincrement. If that index does not exist any more, you will receive an SQL statement like your failing one. Find out, which graph produces that error. Then find the related graph template and verify all colors used therein. In case all are...
by philipz
Thu May 24, 2012 3:52 am
Forum: Help: General
Topic: ERROR: SQL Cell Failed!, Error:'1064'
Replies: 11
Views: 3176

Re: ERROR: SQL Cell Failed!, Error:'1064'

The table "colors" was accessed when the error occurs. That makes sense only when - either a graph is displayed - or a graph is exported It may happen, that you have a graph template that is referring to a color that does not exist anymore. R. Hmm, I tried to find the source of the error but no luc...
by philipz
Tue May 22, 2012 1:37 am
Forum: Plugin: (MAC Track)
Topic: Uninstall Mactrack - still errors in logfile?
Replies: 6
Views: 2864

Re: Uninstall Mactrack - still errors in logfile?

gandalf wrote:Are you running the mactrack poller from crontab?
R.
Nope, in fact I am not running Mactrack at all. The scanning frequency is set to 'disabled'

Thanks,

Philip
by philipz
Mon May 21, 2012 1:50 am
Forum: Plugin: (MAC Track)
Topic: Uninstall Mactrack - still errors in logfile?
Replies: 6
Views: 2864

Re: Uninstall Mactrack - still errors in logfile?

gandalf wrote:I meant to check
| plugin_config |
| plugin_db_changes |
| plugin_hooks |
| plugin_realms |
for mactrack entries.
R.
None of them contains any references to macktrack...
by philipz
Tue May 15, 2012 3:24 am
Forum: Help: General
Topic: ERROR: SQL Cell Failed!, Error:'1064'
Replies: 11
Views: 3176

Re: ERROR: SQL Cell Failed!, Error:'1064'

I noticed that the errors come from CMDPHP while I am running spine: 05/15/2012 10:17:15 AM - SPINE: Poller[0] Host[1133] SNMP Result: Host did not respond to SNMP 05/15/2012 10:17:15 AM - SPINE: Poller[0] Host[519] DEBUG: The POPEN returned the following File Descriptor 6 05/15/2012 10:17:15 AM - S...
by philipz
Tue May 15, 2012 2:54 am
Forum: Plugin: (MAC Track)
Topic: Uninstall Mactrack - still errors in logfile?
Replies: 6
Views: 2864

Re: Uninstall Mactrack - still errors in logfile?

I removed the table "mac_track_interface_graphs" as this one was still there but that didn't help. I did not see any left-behinds in the Plugin_* tables, here's what I have as tables: mysql> show tables; +---------------------------------------+ | Tables_in_cacti087g | +-----------------------------...
by philipz
Tue May 15, 2012 2:42 am
Forum: Help: General
Topic: ERROR: SQL Cell Failed!, Error:'1064'
Replies: 11
Views: 3176

Re: ERROR: SQL Cell Failed!, Error:'1064'

The connection to the database is fine as I can get graphs and history. I am not sure when this started so I don't know what has been changed at that time. The problem is that the error message doesn't show any ID or something so I don't know where to start looking... Shall I disable the last added ...
by philipz
Mon May 14, 2012 3:01 am
Forum: Help: General
Topic: ERROR: SQL Cell Failed!, Error:'1064'
Replies: 11
Views: 3176

ERROR: SQL Cell Failed!, Error:'1064'

All, Since a while I am getting 1000's of messages a day like this: 05/14/2012 09:56:15 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT hex FROM colors WHERE id=" There's not a lot of information in this error so I have no clue where to look... Any advice on how to capture ...
by philipz
Thu May 03, 2012 2:34 am
Forum: Plugin: (MAC Track)
Topic: Uninstall Mactrack - still errors in logfile?
Replies: 6
Views: 2864

Uninstall Mactrack - still errors in logfile?

All, I have moved Mactrack from our 'regular' cacti instance to a dedicated Mactrack server. Today I disabled/uninstalled Mactrack but I get lots of errors in the log: 05/03/2012 09:23:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_temp_ports WHERE ip_...
by philipz
Thu Apr 19, 2012 1:57 am
Forum: Help: General
Topic: SNMP timeout when polling Cisco CSS
Replies: 2
Views: 460

Re: SNMP timeout when polling Cisco CSS

gandalf wrote:Please try lowering MAX OID for the given device to a value of 1; thus deactivating snmpbulkwalk support
R.
That worked; thanks for the help, much appreciated! :D
by philipz
Wed Apr 18, 2012 3:38 am
Forum: Help: General
Topic: SNMP timeout when polling Cisco CSS
Replies: 2
Views: 460

SNMP timeout when polling Cisco CSS

Guys, I have 2 Cisco loadbalancers in our environment that I monitor with cacti. There's a template that I use for this, and it has been working for quite some time but it stopped working 2 days ago for 1 device. This is the log entry: 04/18/2012 10:31:18 AM - SPINE: Poller[0] Host[1238] DS[26195] W...
by philipz
Tue Mar 06, 2012 3:34 am
Forum: Plugin General
Topic: Syslog plugin not displaying complete message
Replies: 2
Views: 948

Re: Syslog plugin not displaying complete message

As a workaround, try to add this code into around line 1290: if (sizeof($syslog_messages) > 0) { foreach ($syslog_messages as $syslog_message) { $syslog_message["message"] = htmlspecialchars($syslog_message["message"]); // <-- THIS LINE $title = ... But unfortunately it doesn't work on tooltip.. :(...
by philipz
Thu Mar 01, 2012 8:21 am
Forum: Plugin General
Topic: Syslog plugin not displaying complete message
Replies: 2
Views: 948

Syslog plugin not displaying complete message

All, I am having a last issue (I hope) before the syslog plugin is fully functional. I am logging with rsyslog, this is the entry in the database: | local6 | notice | 2012-03-01 | 13:06:32 | RASserver | Group <SSLPolicy> User <philip> IP <10.20.30.40> SVC Message: 16/NOTICE: The user has requested t...