Skip to content

Instantly share code, notes, and snippets.

@Accendil
Created March 4, 2019 11:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Accendil/8209fdcc744777e667ce2507b9dd0d01 to your computer and use it in GitHub Desktop.
Save Accendil/8209fdcc744777e667ce2507b9dd0d01 to your computer and use it in GitHub Desktop.
Poller
[root@localhost librenms]# ./poller.php -h 185.72.95.136 -r -f -d
LibreNMS Poller
SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.41ms]
SQL[SELECT version() [] 0.19ms]
===================================
Version info:
Commit SHA: 91bb7250067f13262e505a65df7ed2fc884f673d
Commit Date: 1542671559
DB Schema: 271
PHP: 7.2.11
MySQL: 5.5.60-MariaDB
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2
==================================DEBUG!
Updating os_def.cache... Done
Starting polling run:
SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '185.72.95.136' ORDER BY `device_id` ASC [] 0.93ms]
SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [23] 0.32ms]
Hostname: 185.72.95.136
Device ID: 23
OS: ios
Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 248
(cisco)
[FPING] /usr/sbin/fping -e -q -c 3 -p 500 -t 500 185.72.95.136
Array
(
[xmt] => 3
[rcv] => 3
[loss] => 0
[min] => 21.2
[max] => 21.6
[avg] => 21.4
[exitcode] => 0
)
SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":"3","rcv":"3","loss":"0","min":"21.2","max":"21.6","avg":"21.4","device_id":23,"debug":"[]"} 1.33ms]
Timeout: No Response from udp:185.72.95.136:161.
SNMP Check response code: 1
SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m SNMPv2-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/cisco udp:HOSTNAME:161 sysObjectID.0]
Timeout: No Response from udp:185.72.95.136:161.
SNMP UnreachableSQL[UPDATE `devices` set `status`=?,`status_reason`=? WHERE device_id=? ["0","snmp",23] 2.07ms]
SQL[INSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) {"host":23,"device_id":23,"reference":"NULL","type":"down","severity":2,"message":"Device status changed to Down from snmp check.","username":""} 0.68ms]
#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [23] 0.34ms]
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 = ? ) && ((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 [23] 0.54ms]
SQL[SELECT DISTINCT a.* FROM alert_rules a
LEFT JOIN alert_device_map d ON a.id=d.rule_id
LEFT JOIN alert_group_map g ON a.id=g.rule_id
LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [23,23] 0.94ms]
#### End Alerts ####
SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"185.72.95.136","start":1551695463.7867849,"duration":"13.26","devices":1,"poller":"localhost.localdomain"} 0.79ms]
./poller.php 185.72.95.136 2019-03-04 10:31:17 - 1 devices polled in 13.26 secs
SNMP [2/12.05s]: Get[2/12.05s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [7/0.01s]: Cell[2/0.00s] Row[-2/-0.00s] Rows[2/0.00s] Column[1/0.00s] Update[1/0.00s] Insert[3/0.00s] Delete[0/0.00s]
RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
[root@localhost librenms]#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment