LibreNMS Discovery
Version info:
Commit SHA: 0e6b42fc05e5b936e2f9fa36745234c8a09d7633
DB Schema: 185
PHP: 7.0.15-0ubuntu0.16.04.4
MySQL: 10.0.29-MariaDB-0ubuntu0.16.04.1
RRDTool: 1.5.5
SNMP: NET-SNMP 5.7.3
DEBUG!
SQL[SELECT version FROM dbSchema
ORDER BY version DESC LIMIT 1]
DB Schema already up to date.
SQL[SELECT * FROM devices
WHERE status = 1 AND disabled = 0 AND hostname
LIKE ‘192.168.122.199’ ORDER BY device_id DESC]
SQL[SELECT * FROM devices_attribs WHERE device_id
= ‘50’]
192.168.122.199 50 ricoh SQL[INSERT INTO device_perf
(xmt
,rcv
,loss
,min
,max
,avg
,device_id
,timestamp
) VALUES (‘3’,‘3’,‘0’,‘0.44’,‘0.50’,‘0.47’,‘50’,NOW())]
SNMP Check response code: 0
Modules status: Global+ OS+ Device
Load disco module toner
Toner: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Printer-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 prtMarkerColorantMarkerIndex]
prtMarkerColorantMarkerIndex.1.1 = 1
prtMarkerColorantMarkerIndex.1.2 = 1
prtMarkerColorantMarkerIndex.1.3 = 1
prtMarkerColorantMarkerIndex.1.4 = 1
prtMarkerColorantMarkerIndex.1.5 = 1
SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Printer-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 prtMarkerSuppliesLevel]
prtMarkerSuppliesLevel.1.1 = -3
prtMarkerSuppliesLevel.1.2 = -3
prtMarkerSuppliesLevel.1.3 = -3
prtMarkerSuppliesLevel.1.4 = -3
prtMarkerSuppliesLevel.1.5 = -3
SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Printer-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 prtMarkerSuppliesMaxCapacity]
prtMarkerSuppliesMaxCapacity.1.1 = -2
prtMarkerSuppliesMaxCapacity.1.2 = -2
prtMarkerSuppliesMaxCapacity.1.3 = -2
prtMarkerSuppliesMaxCapacity.1.4 = -2
prtMarkerSuppliesMaxCapacity.1.5 = -2
SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUsa -m Printer-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 prtMarkerSuppliesDescription]
prtMarkerSuppliesDescription.1.1 = "Black Toner"
prtMarkerSuppliesDescription.1.2 = "Waste Toner"
prtMarkerSuppliesDescription.1.3 = "Cyan Toner"
prtMarkerSuppliesDescription.1.4 = "Magenta Toner"
prtMarkerSuppliesDescription.1.5 = “Yellow Toner”
SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUsa -m Printer-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 prtMarkerColorantValue]
prtMarkerColorantValue.1.1 = "black"
prtMarkerColorantValue.1.2 = "other"
prtMarkerColorantValue.1.3 = "cyan"
prtMarkerColorantValue.1.4 = "magenta"
prtMarkerColorantValue.1.5 = “yellow”
Discover Toner: .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.1, 1, jetdirect, Black, , 100, 50
SQL[SELECT COUNT(toner_id) FROM toner
WHERE device_id = ‘50’ AND toner_type = ‘jetdirect’ AND toner_index
= ‘1’ AND toner_oid
=’.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.1’]
SQL[SELECT * FROM toner
WHERE device_id
= ‘50’ AND toner_type
= ‘jetdirect’ AND toner_index
=‘1’]
.Discover Toner: .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.2, 2, jetdirect, Other, , 100, 50
SQL[SELECT COUNT(toner_id) FROM toner
WHERE device_id = ‘50’ AND toner_type = ‘jetdirect’ AND toner_index
= ‘2’ AND toner_oid
=’.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.2’]
SQL[SELECT * FROM toner
WHERE device_id
= ‘50’ AND toner_type
= ‘jetdirect’ AND toner_index
=‘2’]
.Discover Toner: .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.3, 3, jetdirect, Cyan, , 100, 50
SQL[SELECT COUNT(toner_id) FROM toner
WHERE device_id = ‘50’ AND toner_type = ‘jetdirect’ AND toner_index
= ‘3’ AND toner_oid
=’.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.3’]
SQL[SELECT * FROM toner
WHERE device_id
= ‘50’ AND toner_type
= ‘jetdirect’ AND toner_index
=‘3’]
.Discover Toner: .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.4, 4, jetdirect, Magenta, , 100, 50
SQL[SELECT COUNT(toner_id) FROM toner
WHERE device_id = ‘50’ AND toner_type = ‘jetdirect’ AND toner_index
= ‘4’ AND toner_oid
=’.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.4’]
SQL[SELECT * FROM toner
WHERE device_id
= ‘50’ AND toner_type
= ‘jetdirect’ AND toner_index
=‘4’]
.Discover Toner: .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.5, 5, jetdirect, Yellow, , 100, 50
SQL[SELECT COUNT(toner_id) FROM toner
WHERE device_id = ‘50’ AND toner_type = ‘jetdirect’ AND toner_index
= ‘5’ AND toner_oid
=’.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.5’]
SQL[SELECT * FROM toner
WHERE device_id
= ‘50’ AND toner_type
= ‘jetdirect’ AND toner_index
=‘5’]
.
Checking valid toner …
Array
(
[jetdirect] => Array
(
[.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.1] => 1
[.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.2] => 1
[.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.3] => 1
[.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.4] => 1
[.1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.5] => 1
)
)
SQL[SELECT * FROM toner WHERE device_id = ‘50’]
Array
(
[0] => Array
(
[toner_id] => 116
[device_id] => 50
[toner_index] => 1
[toner_type] => jetdirect
[toner_oid] => .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.1
[toner_descr] => Black
[toner_capacity] => 100
[toner_current] => 90
[toner_capacity_oid] =>
)
[1] => Array
(
[toner_id] => 117
[device_id] => 50
[toner_index] => 2
[toner_type] => jetdirect
[toner_oid] => .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.2
[toner_descr] => Other
[toner_capacity] => 100
[toner_current] => 90
[toner_capacity_oid] =>
)
[2] => Array
(
[toner_id] => 118
[device_id] => 50
[toner_index] => 3
[toner_type] => jetdirect
[toner_oid] => .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.3
[toner_descr] => Cyan
[toner_capacity] => 100
[toner_current] => 90
[toner_capacity_oid] =>
)
[3] => Array
(
[toner_id] => 119
[device_id] => 50
[toner_index] => 4
[toner_type] => jetdirect
[toner_oid] => .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.4
[toner_descr] => Magenta
[toner_capacity] => 100
[toner_current] => 100
[toner_capacity_oid] =>
)
[4] => Array
(
[toner_id] => 120
[device_id] => 50
[toner_index] => 5
[toner_type] => jetdirect
[toner_oid] => .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.5
[toner_descr] => Yellow
[toner_capacity] => 100
[toner_current] => 0
[toner_capacity_oid] =>
)
)
Runtime for discovery module ‘toner’: 0.0710 seconds with 16480 bytes
Unload disco module toner
SQL[SELECT attrib_value FROM devices_attribs WHERE device_id
= ‘50’ AND attrib_type
= ‘poll_mib’ ]
SQL[SELECT attrib_value FROM devices_attribs WHERE device_id
= ‘50’ AND attrib_type
= ‘poll_mib’ ]
MIB: registering
SNMP[snmptranslate -M /opt/librenms/mibs -IR -m all enterprises.367.1.1 2>/dev/null]
RFC1155-SMI::enterprises.367.1.1
SNMP translated: all::enterprises.367.1.1 -> RFC1155-SMI::enterprises.367.1.1
RFC1155-SMI::enterprises.367.1.1
Array
(
)
MIB: Could not load definition for RFC1155-SMI::enterprises.367.1.1
SQL[UPDATE devices
set last_discovered
=NOW(),last_discovered_timetaken
=‘0.958’ WHERE device_id
= ‘50’]
Discovered in 0.958 seconds
SQL[INSERT INTO perf_times
(type
,doing
,start
,duration
,devices
,poller
) VALUES (‘discover’,‘192.168.122.199’,‘1492600541.5023’,‘1.007’,‘1’,‘haralampije-To-be-filled-by-O-E-M\n’)]
./discovery.php 192.168.122.199 2017-04-19 13:15:42 - 1 devices discovered in 1.007 secs
SNMP: Get[1/0.02s] Walk [5/0.07s]
MySQL: Cell[8/0.00s] Row[7/0.00s] Rows[5/0.00s] Column[0/0.00s] Update[1/0.03s] Insert[2/0.06s] Delete[0/0.00s]
LibreNMS Poller
Version info:
Commit SHA: 0e6b42fc05e5b936e2f9fa36745234c8a09d7633
Commit Date: 1492594930
DB Schema: 185
PHP: 7.0.15-0ubuntu0.16.04.4
MySQL: 10.0.29-MariaDB-0ubuntu0.16.04.1
RRDTool: 1.5.5
SNMP: NET-SNMP 5.7.3
DEBUG!
Starting polling run:
SQL[SELECT * FROM devices
WHERE disabled
= 0 AND hostname
= ‘192.168.122.199’ ORDER BY device_id
ASC]
SQL[SELECT * FROM devices_attribs WHERE device_id
= ‘50’]
Hostname: 192.168.122.199
Device ID: 50
OS: ricoh (printer)
SQL[INSERT INTO device_perf
(xmt
,rcv
,loss
,min
,max
,avg
,device_id
,timestamp
) VALUES (‘3’,‘3’,‘0’,‘0.30’,‘0.56’,‘0.46’,‘50’,NOW())]
SNMP Check response code: 0
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
sysUpTime.0 = 2179400
sysLocation.0 =
sysContact.0 =
sysName.0 = Aficio MP C3300
sysObjectID.0 = enterprises.367.1.1
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysDescr.0]
RICOH Aficio MP C3300 1.24 / RICOH Network Printer C model / RICOH Network Scanner C model
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
snmpEngineTime.0 = No Such Object available on this agent at this OID
hrSystemUptime.0 = 2179400
Using hrSystemUptime (21794s)
RRD[update /opt/librenms/rrd/192.168.122.199/uptime.rrd N:21794]
[RRD Disabled]Uptime: 6h 3m 14s
Modules status: Global+ OS+ Device
Load poller module toner
SQL[SELECT * FROM toner WHERE device_id = ‘50’]
Checking toner Black… SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.1]
90
90 %
RRD[update /opt/librenms/rrd/192.168.122.199/toner-1.rrd N:90]
[RRD Disabled]SQL[UPDATE toner
set toner_current
=‘90’,toner_capacity
=‘100’ WHERE toner_id
= ‘116’]
Checking toner Other… SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.2]
90
90 %
RRD[update /opt/librenms/rrd/192.168.122.199/toner-2.rrd N:90]
[RRD Disabled]SQL[UPDATE toner
set toner_current
=‘90’,toner_capacity
=‘100’ WHERE toner_id
= ‘117’]
Checking toner Cyan… SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.3]
90
90 %
RRD[update /opt/librenms/rrd/192.168.122.199/toner-3.rrd N:90]
[RRD Disabled]SQL[UPDATE toner
set toner_current
=‘90’,toner_capacity
=‘100’ WHERE toner_id
= ‘118’]
Checking toner Magenta… SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.4]
100
100 %
RRD[update /opt/librenms/rrd/192.168.122.199/toner-4.rrd N:100]
[RRD Disabled]SQL[UPDATE toner
set toner_current
=‘100’,toner_capacity
=‘100’ WHERE toner_id
= ‘119’]
Checking toner Yellow… SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.4.1.367.3.2.1.2.24.1.1.5.5]
No Such Instance currently exists at this OID
0 %
RRD[update /opt/librenms/rrd/192.168.122.199/toner-5.rrd N:0]
[RRD Disabled]SQL[UPDATE toner
set toner_current
=‘0’,toner_capacity
=‘100’ WHERE toner_id
= ‘120’]
Runtime for poller module ‘toner’: 0.2784 seconds with 10208 bytes
Unload poller module toner
RRD[update /opt/librenms/rrd/192.168.122.199/poller-perf-toner.rrd N:0.27841091156006]
[RRD Disabled]### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name]
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=‘50’ AND (devices.mac = “” && devices.ip = “” ) LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘50’]
Groups Added:
Groups Removed:
End Device Groups
RRD[update /opt/librenms/rrd/192.168.122.199/poller-perf.rrd N:0.768]
[RRD Disabled]RRD[update /opt/librenms/rrd/192.168.122.199/ping-perf.rrd N:0.46]
[RRD Disabled]Polled in 0.768 seconds
Updating 192.168.122.199
SQL[UPDATE devices
set uptime
=‘21794’,last_ping
=NOW(),last_ping_timetaken
=‘0.46’,last_polled
=NOW(),last_polled_timetaken
=‘0.768’ WHERE device_id
= ‘50’]
UPDATED!
Start Alerts
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘50’]
SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = ‘50’ ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), ‘–%d’) AND (end_recurring_dt >= date_format(NOW(), ‘–%d’) OR end_recurring_dt is NULL OR end_recurring_dt = ‘0000-00-00’ OR end_recurring_dt = ‘’)) AND (date_format(now(), ‘%H:%i:%s’) BETWEEN start_recurring_hr
AND end_recurring_hr) AND (recurring_day LIKE CONCAT(’%’,date_format(now(), ‘’),’%’) OR recurring_day is null or recurring_day = ‘’))) LIMIT 1]
SQL[SELECT device_group_id
FROM device_group_device
WHERE device_id
=‘50’]
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = ‘50’ ) || alert_map.target = ‘50’ )]
Rule #1 (Devices up/down):
SQL[SELECT state FROM alerts WHERE rule_id = ‘1’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices WHERE (devices.device_id = ‘50’) && ( ( ( devices.status = 0 && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) ) ) = “1”)]
Status: NOCHG
Rule #2 (Device rebooted):
SQL[SELECT state FROM alerts WHERE rule_id = ‘2’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM devices WHERE (devices.device_id = ‘50’) && (devices.uptime < “300” && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) = “1”)]
Status: NOCHG
Rule #3 (BGP Session down):
SQL[SELECT state FROM alerts WHERE rule_id = ‘3’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = ‘50’) && (bgpPeers.bgpPeerState != “established” && ( ( devices.status = 1 && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) ) ) = “1”)]
Status: NOCHG
Rule #4 (BGP Session established):
SQL[SELECT state FROM alerts WHERE rule_id = ‘4’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM bgpPeers WHERE (bgpPeers.device_id = ‘50’) && (bgpPeers.bgpPeerFsmEstablishedTime < “300” && bgpPeers.bgpPeerState = “established”)]
Status: NOCHG
Rule #5 (Port status up/down):
SQL[SELECT state FROM alerts WHERE rule_id = ‘5’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM ports WHERE (ports.device_id = ‘50’) && ( ( ( ports.ifOperStatus = “down” && ports.ifAdminStatus != “down” && ( ( ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0 ) ) ) ) = “1”)]
Status: NOCHG
Rule #6 (Port utilisation over threshold):
SQL[SELECT state FROM alerts WHERE rule_id = ‘6’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM ports WHERE (ports.device_id = ‘50’) && ( ( ( ( ports.ifInOctets_rate*8 ) / ports.ifSpeed ) *100 ) >= “80” && ( ( ports.ifOperStatus = “up” && ports.ifAdminStatus = “up” && ( ( ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0 ) ) ) ) = “1” && ( ( ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0 ) ) = “1”)]
Status: NOCHG
Rule #7 (Sensor over limit):
SQL[SELECT state FROM alerts WHERE rule_id = ‘7’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM sensors WHERE (sensors.device_id = ‘50’) && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = “1”)]
Status: NOCHG
Rule #8 (Sensor under limit):
SQL[SELECT state FROM alerts WHERE rule_id = ‘8’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM sensors WHERE (sensors.device_id = ‘50’) && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = “1”)]
Status: NOCHG
Rule #9 (Service up/down):
SQL[SELECT state FROM alerts WHERE rule_id = ‘9’ && device_id = ‘50’ ORDER BY id DESC LIMIT 1]
SQL[SELECT * FROM services WHERE (services.device_id = ‘50’) && (services.service_status != “0”)]
Status: NOCHGSQL[SELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ‘50’ && alert_log.rule_id = ‘9’ && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1]
SQL[UPDATE alert_log
set details
=‘xڍP�� ��gCJ+(��ŋ�\0c
R�$}�.51M��Ńr�����.3����r(�T�aY�8���
hǧ3��j"9����Zd|>*Tθ�1�ӭTB��’G��� Z[4�2�\n&��ė�RE����Qw]�c
JGà�DeB������~�ڨ\(��mBwQ7��4���W��qwG-��������u
�X.��Z��2��,�/ofKp�’ WHERE id = ‘2545’]
End Alerts
SQL[INSERT INTO perf_times
(type
,doing
,start
,duration
,devices
,poller
) VALUES (‘poll’,‘192.168.122.199’,‘1492600616.4601’,‘0.921’,‘1’,‘haralampije-To-be-filled-by-O-E-M\n’)]
./poller.php 192.168.122.199 2017-04-19 13:16:57 - 1 devices polled in 0.921 secs
SNMP: Get[9/0.15s] Walk [0/0.00s]
MySQL: Cell[4/0.00s] Row[9/-0.00s] Rows[16/0.00s] Column[3/0.00s] Update[7/0.30s] Insert[2/0.06s] Delete[0/0.00s]