Cactiusers.org
• Search • Login
It is currently Tue Feb 07, 2012 5:27 pm

View unanswered posts | View active topics


Board index » Plugins » General

All times are UTC - 6 hours [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
 Discover Plugin Problem 
Author Message
Viruk
New User

Joined: Wed Aug 05, 2009 11:13 am
Posts: 4
Post Discover Plugin Problem
Hi,

I have installed the discover plugin and since that has been running I have been getting quite a lot of errors in the log.

I am running cacti 0.8.7e and the plugin architecture 2.5
Discovery plugin version 0.8.5

I have hunted around but I'm struggling to find any useful information. I found the following reference viewtopic.php?f=8&t=1909&start=0
This looks very similar to my problem, however:
- that problem appears to only get logged every hour (when discover runs), although my problem occurs much more regularly than that
- the report of a duplicate line
Quote:
. sql_sanitize($device['snmp_sysName']) . "', '"
apeears to have been fixed already as it doesn't appear in my findhosts.php
- the report of a missing line
Quote:
. sql_sanitize($device['os']) . "', "
also appears to have been fixed and this line exists in my findhosts.php

Finally, both posts I have mentioned that suggest changing code in findhosts.php have different lines of code at the end of the block that required changes.
The first post shows:
Quote:
. ",'0','1','" .time() . "')");

The second shows:
Quote:
. "'0','1','" .time() . "')");

And finally mine shows:
Quote:
. "1, 1,".time() . ')' );

Could this be an issue? Or can anyone explain to me what the differences are?

The following is the output of 1 hour's worth of standard logging.

Quote:
08/06/2009 08:05:04 PM - SYSTEM STATS: Time:3.1403 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 08:00:04 PM - SYSTEM STATS: Time:3.1375 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:55:04 PM - SYSTEM STATS: Time:3.1374 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:50:05 PM - SYSTEM STATS: Time:3.1819 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:45:04 PM - SYSTEM STATS: Time:3.1434 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:40:36 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.128', '176383104', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249584036)'
08/06/2009 07:40:04 PM - SYSTEM STATS: Time:3.1933 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:35:05 PM - SYSTEM STATS: Time:3.1710 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:30:04 PM - SYSTEM STATS: Time:3.1794 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:25:27 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.91', '176383067', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249583127)'
08/06/2009 07:25:04 PM - SYSTEM STATS: Time:3.2052 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:20:05 PM - SYSTEM STATS: Time:3.1380 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:17:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.63', '176383039', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582632)'
08/06/2009 07:16:48 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.62', '176383038', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582608)'
08/06/2009 07:16:23 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.61', '176383037', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582583)'
08/06/2009 07:15:04 PM - SYSTEM STATS: Time:3.1656 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:14:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.56', '176383032', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582460)'
08/06/2009 07:13:56 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.55', '176383031', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582436)'
08/06/2009 07:13:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.54', '176383030', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582411)'
08/06/2009 07:13:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.53', '176383029', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582387)'
08/06/2009 07:12:42 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.52', '176383028', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582362)'
08/06/2009 07:12:18 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.51', '176383027', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582338)'
08/06/2009 07:11:04 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.46', '176383022', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582264)'
08/06/2009 07:10:04 PM - SYSTEM STATS: Time:3.1396 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:09:50 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.43', '176383019', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582190)'
08/06/2009 07:09:26 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.42', '176383018', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582166)'
08/06/2009 07:09:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.41', '176383017', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582141)'
08/06/2009 07:08:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.40', '176383016', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249582117)'
08/06/2009 07:06:34 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.35', '176383011', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249581994)'
08/06/2009 07:05:04 PM - SYSTEM STATS: Time:3.1730 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:54 RRDsProcessed:39
08/06/2009 07:00:29 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1136', SQL:"REPLACE INTO plugin_discover_hosts (hostname, ip, hash, community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, sysName, sysLocation, sysContact, sysDescr, sysUptime, os, snmp, up, time) VALUES ('', '10.131.100.1', '176382977', '', '1', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, 1,1249581629)'
08/06/2009 07:00:05 PM - POLLER: Poller[0] Network Discover is now running


Does anyone have any idea what may be going on? Or how I can resolve it?
Fri Aug 07, 2009 8:42 am
Viruk
New User

Joined: Wed Aug 05, 2009 11:13 am
Posts: 4
Post Re: Discover Plugin Problem
I have just found version 0.9 of the Discovery plugin at http://docs.cacti.net/plugin:discovery, the cactiusers site only has Discovery - v0.8.5 listed.

I have removed version 0.8.5 and added version 0.9

The problems in the logs have now stopped appearing however I want to wait until after the next hour to find out whether or not they will start again.
Fri Aug 07, 2009 10:39 am
Viruk
New User

Joined: Wed Aug 05, 2009 11:13 am
Posts: 4
Post Re: Discover Plugin Problem
After leaving this running for the weekend there are no more errors.
Mon Aug 10, 2009 5:30 am
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 

Board index » Plugins » General

All times are UTC - 6 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 2 guests

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: