[Resolved] Retrieve informations stored as string in MIBs
Moderators: Developers, Moderators
[Resolved] Retrieve informations stored as string in MIBs
Hello,
I'm trying to graph some informations from Checkpoint VSX MIB. The problem is that informations (numbers) I would like to graph are stored as String values in the MIB instead of Integer, so in Cacti's Data Sources, values are at value 0 for all this OIDs.
Is there a mean to fix it?
Regards
I'm trying to graph some informations from Checkpoint VSX MIB. The problem is that informations (numbers) I would like to graph are stored as String values in the MIB instead of Integer, so in Cacti's Data Sources, values are at value 0 for all this OIDs.
Is there a mean to fix it?
Regards
Last edited by mimiche on Mon Jul 28, 2008 8:05 am, edited 1 time in total.
Thanks for your answer. Actually, I use cmd.php as pooler because I've got a problem with Spine. I'll try with Spine when I'll have fix this problem.gandalf wrote:Hmm, from a discussion with other devs I know that it's assumed to work even with STRING type stuff as long as numbers are spit out. If running spine, please post the result of a "spine --verbosity=5 <id> <id>", where <id> is the numerical host id of the failing host
Reinhard
PS: I use Cacti on Windows 2003, Cacti version is 0.8.7b
I have some SQL errors but nothing about the values:
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_list'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_list'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "show columns from reportit_reports"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "show tables from cacti"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='802'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_action'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_action'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
Ps :I've got some problems with SNMPv3 (not for this device) : could it e the reason?
Regards
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_list'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_list'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "show columns from reportit_reports"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "show tables from cacti"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='802'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_action'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'utilities_action'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/07/2008 02:09:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
Ps :I've got some problems with SNMPv3 (not for this device) : could it e the reason?
Regards
Thanks for your link . Here is the log of the command:gandalf wrote:The SQL errors are related to the plugin architecture. They do not interfere with your current problem. The log does not show anything about the polling from cmd.php. Please see 2nd link of my sig to learn about debugging and retry. You may post your SNMP V3 problem in a different thread
Reinhard
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1523, 'vsxCounterPackets', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1523] SNMP: v1: 192.168.0.90, dsname: vsxCounterPackets, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.5.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1523, 'vsxCountersAccepted', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1523] SNMP: v1: 192.168.0.90, dsname: vsxCountersAccepted, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.7.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1524, 'vsxCountersAccepted', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1524] SNMP: v1: 192.168.0.90, dsname: vsxCountersAccepted, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.7.3.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1523, 'vsxCountersDropped', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1523] SNMP: v1: 192.168.0.90, dsname: vsxCountersDropped, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.6.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1525, 'vsxCounterPackets', '2008-07-08 16:23:24', '10')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1525] SNMP: v1: 192.168.0.90, dsname: vsxCounterPackets, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.5.4.0, output: 10
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1525, 'vsxCountersAccepted', '2008-07-08 16:23:24', '10')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1525] SNMP: v1: 192.168.0.90, dsname: vsxCountersAccepted, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.7.4.0, output: 10
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1525, 'vsxCountersRejected', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1525] SNMP: v1: 192.168.0.90, dsname: vsxCountersRejected, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.8.4.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1525, 'vsxCountersDropped', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1525] SNMP: v1: 192.168.0.90, dsname: vsxCountersDropped, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.6.4.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1524, 'vsxCountersDropped', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1524] SNMP: v1: 192.168.0.90, dsname: vsxCountersDropped, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.6.3.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1524, 'vsxCounterPackets', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1524] SNMP: v1: 192.168.0.90, dsname: vsxCounterPackets, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.5.3.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1524, 'vsxCountersRejected', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1524] SNMP: v1: 192.168.0.90, dsname: vsxCountersRejected, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.8.3.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1518, 'dropped', '2008-07-08 16:23:24', '64')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1518] SNMP: v1: 192.168.0.90, dsname: dropped, oid: .1.3.6.1.4.1.2620.1.1.6.0, output: 64
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1519, 'logged', '2008-07-08 16:23:24', '208342')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1519] SNMP: v1: 192.168.0.90, dsname: logged, oid: .1.3.6.1.4.1.2620.1.1.7.0, output: 208342
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1520, 'rejected', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1520] SNMP: v1: 192.168.0.90, dsname: rejected, oid: .1.3.6.1.4.1.2620.1.1.5.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1514, 'mem_free_real', '2008-07-08 16:23:24', '1733554176')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1514] SNMP: v1: 192.168.0.90, dsname: mem_free_real, oid: .1.3.6.1.4.1.2620.1.6.7.4.5.0, output: 1733554176
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1513, 'mem_act_virtual', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1513] SNMP: v1: 192.168.0.90, dsname: mem_act_virtual, oid: .1.3.6.1.4.1.2620.1.6.7.4.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1510, 'proc_system', '2008-07-08 16:23:24', '12')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1510] SNMP: v1: 192.168.0.90, dsname: proc_system, oid: .1.3.6.1.4.1.2620.1.6.7.2.2.0, output: 12
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1512, 'mem_act_real', '2008-07-08 16:23:24', '379838464')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1512] SNMP: v1: 192.168.0.90, dsname: mem_act_real, oid: .1.3.6.1.4.1.2620.1.6.7.4.4.0, output: 379838464
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1515, 'mem_tot_real', '2008-07-08 16:23:24', '2113392640')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1515] SNMP: v1: 192.168.0.90, dsname: mem_tot_real, oid: .1.3.6.1.4.1.2620.1.6.7.4.3.0, output: 2113392640
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1516, 'mem_total_virtual', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1516] SNMP: v1: 192.168.0.90, dsname: mem_total_virtual, oid: .1.3.6.1.4.1.2620.1.6.7.4.1.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1517, 'acc', '2008-07-08 16:23:24', '1715876002')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1517] SNMP: v1: 192.168.0.90, dsname: acc, oid: .1.3.6.1.4.1.2620.1.1.4.0, output: 1715876002
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1523, 'vsxCountersRejected', '2008-07-08 16:23:24', '0')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1523] SNMP: v1: 192.168.0.90, dsname: vsxCountersRejected, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.8.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1509, 'conn', '2008-07-08 16:23:24', '48')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1509] SNMP: v1: 192.168.0.90, dsname: conn, oid: .1.3.6.1.4.1.2620.1.1.25.3.0, output: 48
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1511, 'proc_user', '2008-07-08 16:23:24', '2')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1511] SNMP: v1: 192.168.0.90, dsname: proc_user, oid: .1.3.6.1.4.1.2620.1.6.7.2.1.0, output: 2
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='' where host_id='63' and data_query_id='20' and arg1='.1.3.6.1.2.1.1.3.0'"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='' where host_id='63' and data_query_id='19' and arg1='.1.3.6.1.2.1.1.3.0'"
If you see something wrong, please tell me.
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
You suppose that e.g. this should be non-zero? Can you please post an snmpget output for this OID? Did you already try spine instead of cmd.php?mimiche wrote:07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1523] SNMP: v1: 192.168.0.90, dsname: vsxCounterPackets, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.5.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1523, 'vsxCountersAccepted', '2008-07-08 16:23:24', '0')"
Reinhard
This value is "0" even in snmpget and it's normal. The matter is that for this value (an example):gandalf wrote:You suppose that e.g. this should be non-zero? Can you please post an snmpget output for this OID? Did you already try spine instead of cmd.php?mimiche wrote:07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1523] SNMP: v1: 192.168.0.90, dsname: vsxCounterPackets, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.5.2.0, output: 0
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1523, 'vsxCountersAccepted', '2008-07-08 16:23:24', '0')"
Reinhard
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1525, 'vsxCountersAccepted', '2008-07-08 16:23:24', '10')"
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1525] SNMP: v1: 192.168.0.90, dsname: vsxCountersAccepted, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.7.4.0, output: 10
In Cacti, all the values which seems to be retrieved by the pooler are at value 0 (query graph)
2008/07/08 16:25:00 0 0 0 0
I'm not sure that the pooler is the problem... What do you think about that?
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Your answer does not help, unfortunately. Please post result of to learn what's going on
Reinhard
Code: Select all
snmpget -c <community> -v <version> <target> .1.3.6.1.4.1.2620.1.16.23.1.1.5.2.0
Reinhard
Sorrygandalf wrote:Your answer does not help, unfortunately.
The result of the request is:gandalf wrote:Please post result ofto learn what's going onCode: Select all
snmpget -c <community> -v <version> <target> .1.3.6.1.4.1.2620.1.16.23.1.1.5.2.0
Reinhard
C:\USR\bin>snmpget -c xxx -v 1 xxxx .1.3.6.1.4.1.2620.1.16.23.
1.1.5.2.0
SNMPv2-SMI::enterprises.2620.1.16.23.1.1.5.2.0 = STRING: "0"
Thanks in advance
It's Ok for this OID but for the OID .1.3.6.1.4.1.2620.1.16.23.1.1.5.4.0 (other vsx) th result is SNMPv2-SMI::enterprises.2620.1.16.23.1.1.5.4.0 = STRING: "10" and I have the value 0 in the data source...gandalf wrote:Well, that's exactly what the poller found out: The result is "0". What did you expect it to be in cacti, then?
Reinhard
I don't understand where is the problem...
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
But from an earlier post I seemimiche wrote:It's Ok for this OID but for the OID .1.3.6.1.4.1.2620.1.16.23.1.1.5.4.0 (other vsx) th result is SNMPv2-SMI::enterprises.2620.1.16.23.1.1.5.4.0 = STRING: "10" and I have the value 0 in the data source...gandalf wrote:Well, that's exactly what the poller found out: The result is "0". What did you expect it to be in cacti, then?
Reinhard
I don't understand where is the problem...
so cacti got it correctly07/08/2008 04:23:24 PM - CMDPHP: Poller[0] Host[63] DS[1525] SNMP: v1: 192.168.0.90, dsname: vsxCounterPackets, oid: .1.3.6.1.4.1.2620.1.16.23.1.1.5.4.0, output: 10
07/08/2008 04:23:24 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1525, 'vsxCountersAccepted', '2008-07-08 16:23:24', '10')"
Reinhard
Who is online
Users browsing this forum: No registered users and 2 guests