Discovery Plugin problem

[cevherk]

I use bellow cacti and PIA versions
Cacti Version: 0.8.8f
Plugin Architecture Version: 3.1

I have been installed Discovery Plugin version 5.1

I configured Misc tab like bellow

discovery.JPG (108.6 KiB) Viewed 3245 times

But discovery tab seem empty

discovery_tab.JPG (66.06 KiB) Viewed 3245 times

Please anyone can help me?

[cigamit]

Does your poller run as root? If not, its most likely not going to be able to do ICMP Pings. You might check your cacti log also.

[cevherk]

Does your poller run as root? If not, its most likely not going to be able to do ICMP Pings. You might check your cacti log also.

Thank you for your reply

when i checked <cacti_path>/log/cacti.log , i saw this result for all switches.

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 ('''', 'x.x.x.x', '3232292428', '''', ''3'', ''xxx'', ''xxxx'', ''SHA'', ''xxxx'', ''DES'', '''', ''xxxxx'', ''xxxx'', ''xxxxx'', ''HP J9147A 2910al-48G Switch, revision W.15.12.0011, ROM W.14.06 (/ws/swbuildm/W_rel_knoxville_qaoff/code/build/sbm(swbuildm_W_rel_knoxville_qaoff_rel_knoxville)) (Formerly ProCurve)'', ''1310119847'', '''', 1, 1,1455867334)'

Furthermore, i saw this result
02/19/2016 09:33:39 AM - DISCOVER: Poller[0] 252 IPs Scanned, 78 IPs Responded to Ping, 74 Responded to SNMP, 0 Device Added, 0 Graphs Added to Cacti
02/19/2016 09:35:02 AM - POLLER: Poller[0] WARNING: There are '1' detected as overrunning a polling process, please investigate
02/19/2016 09:35:02 AM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Issues Found: 44, Data Sources: traffic_out(DS[54]), traffic_out(DS[55]), traffic_out(DS[56]), traffic_out(DS[57]), traffic_out(DS[58]), traffic_out(DS[59]), traffic_out(DS[60]), traffic_out(DS[61]), traffic_out(DS[62]), traffic_out(DS[63]), traffic_out(DS[64]), traffic_out(DS[65]), traffic_out(DS[66]), traffic_out(DS[67]), traffic_out(DS[68]), traffic_out(DS[69]), traffic_out(DS[70]), traffic_out(DS[71]), traffic_out(DS[72]), traffic_out(DS[73]), Additional Issues Remain. Only showing first 20
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (3, 'mem_buffers', '2016-02-19 09:35:02', '175940')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (4, 'mem_swap', '2016-02-19 09:35:02', '4079600')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (5, '', '2016-02-19 09:35:02', '1min:0.26 5min:0.32 10min:0.32')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (6, 'users', '2016-02-19 09:35:02', '2')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (8, 'traffic_in', '2016-02-19 09:35:02', '2310200908')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.222.1', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] Host[2] DS[13] WARNING: Result from SNMP not valid. Partial Result: U
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.222.1', and OID:'.1.3.6.1.4.1.9.2.1.58.0'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] Host[2] DS[13] WARNING: Result from SNMP not valid. Partial Result: U
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (14, 'traffic_in', '2016-02-19 09:35:02', '3095363207')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (15, 'traffic_in', '2016-02-19 09:35:02', '2142173740')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (16, 'traffic_in', '2016-02-19 09:35:02', '527385763')'
02/19/2016 09:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (17, 'traffic_in', '2016-02-19 09:35:02', '2029125025')'

[cigamit]

Did you happen to import the SQL file that comes with the plugin into your MySQL database? It seems that it is running and finding devices, just not putting them into the table.

Also, you have other issues going on that you may want to look at. Your poller is hanging and timing out.

[cevherk]

Did you happen to import the SQL file that comes with the plugin into your MySQL database? It seems that it is running and finding devices, just not putting them into the table.

Also, you have other issues going on that you may want to look at. Your poller is hanging and timing out.

Thanks.

I didn't happen to import any database without cacti database
I have this databases
MariaDB [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cacti |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

are there any database that i should import?
which database that i should import?

Thanks.

[cevherk]

Did you happen to import the SQL file that comes with the plugin into your MySQL database? It seems that it is running and finding devices, just not putting them into the table.

Also, you have other issues going on that you may want to look at. Your poller is hanging and timing out.

Thanks.

I didn't happen to import any database without cacti database
I have this databases
MariaDB [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cacti |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

are there any database that i should import?
which database that i should import?

Thanks.

now i have noticed that i have discover.sql file in <cacti_path>/plugins/discovery directory.
but how can i import this file?
can i try "mysql -u root -p cacti < cacti_path/plugins/discovery/discover.sql" command.

[cigamit]

yes, that should work

[cevherk]

yes, that should work

I have just tried this also. But nothing have been changed.

[cevherk]

yes, that should work

I have just tried this also. But nothing have been changed.

I have changed findhosts.php like below

if (!$host_id) {
db_execute("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 (" . sql_sanitize($device['dnsname']) . ", '" . $host . "', " . $device['hash'] . ", " . sql_sanitize($device['community']) . ", " . sql_sanitize($device['snmp_version']) . ", " . sql_sanitize($device['snmp_username']) . ", " . sql_sanitize($device['snmp_password']) . ", " . sql_sanitize($device['snmp_auth_protocol']) . ", " . sql_sanitize($device['snmp_priv_passphrase']) . ", " . sql_sanitize($device['snmp_priv_protocol']) . ", " . sql_sanitize($device['snmp_context']) . ", " . sql_sanitize($device['snmp_sysName']) . ", " . sql_sanitize($device['snmp_sysLocation']) . ", " . sql_sanitize($device['snmp_sysContact']) . ", " . sql_sanitize($device['snmp_sysDescr']) . ", " . sql_sanitize($device['snmp_sysUptime']) . ", " . sql_sanitize($device['os']) . ", " . "1, 1," . time() . " );" ) ; }
}
}else if ($result) {
if ($dns != '') {
$dnsname = discover_get_dns_from_ip($host, $dns, 300);
if ($dnsname != $host && $dnsname != 'timed_out') {
$device['dnsname'] = $dnsname;
}
$device['dnsname_short'] = preg_split('/[\.]+/', strtolower($dnsname), -1, PREG_SPLIT_NO_EMPTY);
}else{
$dnsname = $host;
$device['dnsname'] = '';
$device['dnsname_short'] = '';
}
db_execute("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 ("
. sql_sanitize($device['dnsname'])
. ", '" . $host . "', "
. $device['hash'] . ", "
. sql_sanitize($device['community']) . ", "
. sql_sanitize($device['snmp_version']) . ", "
. sql_sanitize($device['snmp_username']) . ", "
. sql_sanitize($device['snmp_password']) . ", "
. sql_sanitize($device['snmp_auth_protocol']) . ", "
. sql_sanitize($device['snmp_priv_passphrase']) . ", "
. sql_sanitize($device['snmp_priv_protocol']) . ", "
. sql_sanitize($device['snmp_context']) . ", "
. sql_sanitize($device['snmp_sysName']) . ", "
. sql_sanitize($device['snmp_sysLocation']) . ", "
. sql_sanitize($device['snmp_sysContact']) . ", "
. sql_sanitize($device['snmp_sysDescr']) . ", "
. sql_sanitize($device['snmp_sysUptime']) . ", "
. "'', 0, 1,".time() . ')' );
discover_debug(" - Host $dnsname is alive but no SNMP!");
}


after i changed findhosts.php, I don't have seen same error . But i don't have seen nothing on discover tab also.

[classen]

try this:

do a global search for "sql_sanitize" and replace with "stripslashes"

worked for me.

[cevherk]

try this:

do a global search for "sql_sanitize" and replace with "stripslashes"

worked for me.

Thanks.
i solved this problem. But i have another problem now.

when i want to add a device from discover tab, i come on below error.

[classen]

Are you are using snmp version 3 authentication?

[cevherk]

Are you are using snmp version 3 authentication?

Yes, i am using version 3