LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.25ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.4ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.3ms] =================================== Version info: Commit SHA: Commit Date: DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208) PHP: 7.4.19 MySQL: 10.6.0-MariaDB-1:10.6.0+maria~focal RRDTool: 1.7.2 SNMP: NET-SNMP 5.9 ==================================DEBUG! Updating os_def.cache Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/LibreNMS/Util/OS.php on line 108 Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'inrows1s2.hq.nerd.lan' ORDER BY `device_id` ASC [0;33m[][0m 0.6ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[300][0m 0.63ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[300][0m 0.34ms] Attempting to initialize OS: apc OS initialized: LibreNMS\OS\Apc Hostname: inrows1s2.hq.nerd.lan Device ID: 300 OS: apc Resolved IP: 10.40.249.20 SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["inrows1s2.hq.nerd.lan"][0m 0.41ms] [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'inrows1s2.hq.nerd.lan' response: {"xmt":3,"rcv":3,"loss":0,"min":0.661,"max":0.73,"avg":0.696,"dup":0,"exitcode":0} SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[300][0m 0.56ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[67][0m 0.28ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-07-22T09:56:05.718317Z","2021-07-22T09:56:05.718317Z",0,1,"09:56:05","09:56:05","09:56:05","09:56:05","[44m%","device",300,"location",67][0m 0.62ms] SQL[[1;33mINSERT 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) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":0.661,"max":0.73,"avg":0.696,"device_id":300,"debug":"[]"}[0m 0.58ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-07-22 11:56:05",0.696,300][0m 0.4ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 59706860 .*.*.0 = inrows1s2.hq .*.*.0 = .*.4.1.3*.23 .*.*.0 = APC InRow DX 300mm (MB:v4.1.0 PF:v6.9.6 PN:apc_hw06_aos_696.bin AF1:v6.7.0 AN1:apc_hw06_rd3xx_670.bin MN:0N-9580AC HR:06 SN: JK2048002640 MD:11/20/2020) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] snmpEngineTime.0 = 597068 hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 597069 Uptime: 6 days 21 hours 51 minutes 9 seconds >> Runtime for poller module 'core': 0.0396 seconds with 4360 bytes >> SNMP: [2/0.04s] MySQL: [0/0.00s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[300][0m 0.5ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[300][0m 0.47ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1626861365][0m 0.37ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,545][0m 0.29ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1626342965][0m 0.33ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.855,546][0m 0.27ms] 7 days : 99.855% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1624355765][0m 0.3ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.957,547][0m 0.28ms] 30 days : 99.957% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[300,1595411765][0m 0.34ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.996,548][0m 0.23ms] 365 days : 99.996% >> Runtime for poller module 'availability': 0.0060 seconds with 29952 bytes >> SNMP: [0/0.00s] MySQL: [5/0.00s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module unix-agent #### >> Runtime for poller module 'unix-agent': 0.0006 seconds with 5712 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module unix-agent #### Modules status: Global+ OS Device #### Load poller module os #### Generic :( Location: Salle NERD-HQ Hardware: InRow DX 300mm OS Version: AOS v6.9.6 / App v6.7.0 OS Features: Serial: >> Runtime for poller module 'os': 0.0023 seconds with 5024 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[300][0m 0.39ms] array ( ) >> Runtime for poller module 'ipmi': 0.0009 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[300][0m 0.37ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["airflow",300][0m 0.35ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.6' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.21'[0m] .*.4.1.3*.*.* = 1606 .*.4.1.3*.*.* = 0 Checking (snmp) airflow Total Airflow... Checking (snmp) airflow Airflow... 1606 cfm SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[1606,1609,"airflow",104873][0m 0.72ms] 0 cfm SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["fanspeed",300][0m 0.54ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.66'[0m] .*.4.1.3*.*.* = 0 Checking (snmp) fanspeed Condenser Fan Speed... 0 rpm SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["power",300][0m 0.65ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.7' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.8' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.24' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.25'[0m] .*.4.1.3*.*.* = 109 .*.4.1.3*.*.* = 117 .*.4.1.3*.*.* = 0 .*.4.1.3*.*.* = 0 Checking (snmp) power Total Air Side Cooling Demand... Checking (snmp) power Total Sensible Cooling Power... Checking (snmp) power Cool Demand... Checking (snmp) power Cool Output... 10.9 W SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[10.9,11.1,"power",104876][0m 0.71ms] 11.7 W SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[11.7,10.1,"power",104877][0m 0.38ms] 0 W 0 W SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["state",300][0m 0.48ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.1' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.2' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.3' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.4' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.5' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.6' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.7' '.1.3.6.1.4.1.318.1.1.27.1.4.2.2.1.4.1.8'[0m] .*.4.1.3*.*.* = 4 .*.4.1.3*.*.* = 3 .*.4.1.3*.*.* = 0 .*.4.1.3*.*.* = 0 .*.4.1.3*.*.* = 0 .*.4.1.3*.*.* = 0 .*.4.1.3*.*.* = 0 .*.4.1.3*.*.* = 0 Checking (snmp) state Active Flow Control Status... Checking (snmp) state Mode... Checking (snmp) state Shutdown Input State... Checking (snmp) state Alarm Relay 1... Checking (snmp) state Alarm Relay 2... Checking (snmp) state Alarm Relay 3... Checking (snmp) state Alarm Relay 4... Checking (snmp) state Active Power Source... 4 # 3 # 0 # 0 # 0 # 0 # 0 # 0 # SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["temperature",300][0m 0.8ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.1' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.3' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.9' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.11' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.13' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.16' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.18' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.26' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.28' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.30'[0m] .*.4.1.3*.*.* = 215 .*.4.1.3*.*.* = 236 .*.4.1.3*.*.* = 254 .*.4.1.3*.*.* = 229 .*.4.1.3*.*.* = 309 .*.4.1.3*.*.* = No Such Instance currently exists at this OID .*.4.1.3*.*.* = No Such Instance currently exists at this OID .*.4.1.3*.*.* = 288 .*.4.1.3*.*.* = 220 .*.4.1.3*.*.* = 350 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.32' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.34' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.36' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.38' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.40' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.50' '.1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.52'[0m] .*.4.1.3*.*.* = 267 .*.4.1.3*.*.* = No Such Instance currently exists at this OID .*.4.1.3*.*.* = No Such Instance currently exists at this OID .*.4.1.3*.*.* = No Such Instance currently exists at this OID .*.4.1.3*.*.* = 229 .*.4.1.3*.*.* = 236 .*.4.1.3*.*.* = 293 Checking (snmp) temperature Group Minimum Rack Temperature... Checking (snmp) temperature Group Maximum Rack Temperature... Checking (snmp) temperature Supply Temperature... Checking (snmp) temperature Maximum Rack Inlet Temperature... Checking (snmp) temperature Return Temperature... Checking (snmp) temperature Room Temperature... Checking (snmp) temperature Dew Point Temperature... Checking (snmp) temperature Upper Supply Temperature... Checking (snmp) temperature Lower Supply Temperature... Checking (snmp) temperature Upper Return Temperature... Checking (snmp) temperature Lower Return Temperature... Checking (snmp) temperature Rack Inlet Temperature 1... Checking (snmp) temperature Rack Inlet Temperature 2... Checking (snmp) temperature Rack Inlet Temperature 3... Checking (snmp) temperature Rack Inlet Temperature 4... Checking (snmp) temperature Inlet Evap Coil Temperature... Checking (snmp) temperature Outlet Evap Coil Temperature... 21.5 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[21.5,22.4,"temperature",104888][0m 0.99ms] 23.6 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[23.6,23.9,"temperature",104889][0m 0.41ms] 25.4 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[25.4,25.6,"temperature",104890][0m 0.37ms] 22.9 C 30.9 C 0 C 0 C 28.8 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[28.8,29,"temperature",104895][0m 0.37ms] 22 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[22,22.2,"temperature",104896][0m 0.36ms] 35 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[35,35.1,"temperature",104897][0m 0.44ms] 26.7 C SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[26.7,26.8,"temperature",104898][0m 0.36ms] 0 C 0 C 0 C 22.9 C 23.6 C 29.3 C >> Runtime for poller module 'sensors': 0.4965 seconds with 2512 bytes >> SNMP: [6/0.48s] MySQL: [16/0.01s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: apc OS initialized: LibreNMS\OS\Apc SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[300][0m 0.35ms] >> Runtime for poller module 'processors': 0.0021 seconds with 3824 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[300][0m 0.32ms] >> Runtime for poller module 'mempools': 0.0018 seconds with 25192 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[300][0m 0.43ms] >> Runtime for poller module 'storage': 0.0007 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'icmp'[0m] icmpInMsgs.0 = 38150 icmpInErrors.0 = 0 icmpInDestUnreachs.0 = 10 icmpInTimeExcds.0 = 0 icmpInParmProbs.0 = 0 icmpInSrcQuenchs.0 = 0 icmpInRedirects.0 = 0 icmpInEchos.0 = 35927 icmpInEchoReps.0 = 2209 icmpInTimestamps.0 = 0 icmpInTimestampReps.0 = 0 icmpInAddrMasks.0 = 3 icmpInAddrMaskReps.0 = 0 icmpOutMsgs.0 = 38242 icmpOutErrors.0 = 0 icmpOutDestUnreachs.0 = 106 icmpOutTimeExcds.0 = 0 icmpOutParmProbs.0 = 0 icmpOutSrcQuenchs.0 = 0 icmpOutRedirects.0 = 0 icmpOutEchos.0 = 2209 icmpOutEchoReps.0 = 35927 icmpOutTimestamps.0 = 0 icmpOutTimestampReps.0 = 0 icmpOutAddrMasks.0 = 0 icmpOutAddrMaskReps.0 = 0 icmpStatsInMsgs.ipv4 = 38150 icmpStatsInMsgs.ipv6 = 888 icmpStatsInErrors.ipv4 = 0 icmpStatsInErrors.ipv6 = 0 icmpStatsOutMsgs.ipv4 = 38242 icmpStatsOutMsgs.ipv6 = 4 icmpStatsOutErrors.ipv4 = 0 icmpStatsOutErrors.ipv6 = 0 icmpMsgStatsInPkts.ipv4.0 = 2209 icmpMsgStatsInPkts.ipv4.3 = 10 icmpMsgStatsInPkts.ipv4.4 = 0 icmpMsgStatsInPkts.ipv4.5 = 0 icmpMsgStatsInPkts.ipv4.8 = 35927 icmpMsgStatsInPkts.ipv4.9 = 0 icmpMsgStatsInPkts.ipv4.10 = 0 icmpMsgStatsInPkts.ipv4.11 = 0 icmpMsgStatsInPkts.ipv4.12 = 0 icmpMsgStatsInPkts.ipv4.13 = 0 icmpMsgStatsInPkts.ipv4.14 = 0 icmpMsgStatsInPkts.ipv4.15 = 0 icmpMsgStatsInPkts.ipv4.16 = 0 icmpMsgStatsInPkts.ipv4.17 = 3 icmpMsgStatsInPkts.ipv4.18 = 0 icmpMsgStatsInPkts.ipv6.1 = 0 icmpMsgStatsInPkts.ipv6.2 = 0 icmpMsgStatsInPkts.ipv6.3 = 0 icmpMsgStatsInPkts.ipv6.4 = 0 icmpMsgStatsInPkts.ipv6.128 = 0 icmpMsgStatsInPkts.ipv6.129 = 0 icmpMsgStatsInPkts.ipv6.130 = 0 icmpMsgStatsInPkts.ipv6.131 = 0 icmpMsgStatsInPkts.ipv6.132 = 0 icmpMsgStatsInPkts.ipv6.133 = 0 icmpMsgStatsInPkts.ipv6.134 = 0 icmpMsgStatsInPkts.ipv6.135 = 426 icmpMsgStatsInPkts.ipv6.136 = 462 icmpMsgStatsInPkts.ipv6.137 = 0 icmpMsgStatsOutPkts.ipv4.0 = 35927 icmpMsgStatsOutPkts.ipv4.3 = 106 icmpMsgStatsOutPkts.ipv4.4 = 0 icmpMsgStatsOutPkts.ipv4.5 = 0 icmpMsgStatsOutPkts.ipv4.8 = 2209 icmpMsgStatsOutPkts.ipv4.9 = 0 icmpMsgStatsOutPkts.ipv4.10 = 0 icmpMsgStatsOutPkts.ipv4.11 = 0 icmpMsgStatsOutPkts.ipv4.12 = 0 icmpMsgStatsOutPkts.ipv4.13 = 0 icmpMsgStatsOutPkts.ipv4.14 = 0 icmpMsgStatsOutPkts.ipv4.15 = 0 icmpMsgStatsOutPkts.ipv4.16 = 0 icmpMsgStatsOutPkts.ipv4.17 = 0 icmpMsgStatsOutPkts.ipv4.18 = 0 icmpMsgStatsOutPkts.ipv6.1 = 0 icmpMsgStatsOutPkts.ipv6.2 = 0 icmpMsgStatsOutPkts.ipv6.3 = 0 icmpMsgStatsOutPkts.ipv6.4 = 0 icmpMsgStatsOutPkts.ipv6.128 = 0 icmpMsgStatsOutPkts.ipv6.129 = 0 icmpMsgStatsOutPkts.ipv6.130 = 0 icmpMsgStatsOutPkts.ipv6.131 = 4 icmpMsgStatsOutPkts.ipv6.132 = 0 icmpMsgStatsOutPkts.ipv6.133 = 0 icmpMsgStatsOutPkts.ipv6.134 = 0 icmpMsgStatsOutPkts.ipv6.135 = 0 icmpMsgStatsOutPkts.ipv6.136 = 0 icmpMsgStatsOutPkts.ipv6.137 = 0 IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m] ipForwDatagrams.0 = 0 ipInDelivers.0 = 227113 ipInReceives.0 = 352656 ipOutRequests.0 = 166704 ipInDiscards.0 = 0 ipOutDiscards.0 = 0 ipOutNoRoutes.0 = 0 ipReasmReqds.0 = 0 ipReasmOKs.0 = 0 ipReasmFails.0 = 0 ipFragOKs.0 = 0 ipFragFails.0 = 0 ipFragCreates.0 = 0 ipInUnknownProtos.0 = 0 ipInHdrErrors.0 = 0 ipInAddrErrors.0 = 125540 IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] No Such Object available on this agent at this OID SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'snmp'[0m] snmpInPkts.0 = 123703 snmpOutPkts.0 = 123702 snmpInBadVersions.0 = 0 snmpInBadCommunityNames.0 = 0 snmpInBadCommunityUses.0 = 46 snmpInASNParseErrs.0 = 0 snmpInTooBigs.0 = 0 snmpInNoSuchNames.0 = 0 snmpInBadValues.0 = 0 snmpInReadOnlys.0 = 0 snmpInGenErrs.0 = 0 snmpInTotalReqVars.0 = 175788 snmpInTotalSetVars.0 = 0 snmpInGetRequests.0 = 36364 snmpInGetNexts.0 = 17043 snmpInSetRequests.0 = 0 snmpInGetResponses.0 = 0 snmpInTraps.0 = 0 snmpOutTooBigs.0 = 0 snmpOutNoSuchNames.0 = 16 snmpOutBadValues.0 = 0 snmpOutGenErrs.0 = 0 snmpOutGetRequests.0 = 0 snmpOutGetNexts.0 = 0 snmpOutSetRequests.0 = 0 snmpOutGetResponses.0 = 123704 snmpOutTraps.0 = 0 snmpEnableAuthenTraps.0 = enabled snmpSilentDrops.0 = 0 snmpProxyDrops.0 = 0 TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m] tcpActiveOpens.0 = 0 tcpPassiveOpens.0 = 874 tcpAttemptFails.0 = 3 tcpEstabResets.0 = 767 tcpCurrEstab.0 = 0 tcpInSegs.0 = 6125 tcpOutSegs.0 = 2981 tcpRetransSegs.0 = 0 tcpInErrs.0 = 0 tcpOutRsts.0 = 974 TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] tcpHCOutSegs.0 = 2981 mib-* = 123738 UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m] udpInDatagrams.0 = 123739 udpOutDatagrams.0 = 128720 udpInErrors.0 = 0 udpNoPorts.0 = 536195 >> Runtime for poller module 'netstats': 0.5185 seconds with 1544 bytes >> SNMP: [7/0.52s] MySQL: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 0.0178 seconds with 1208 bytes >> SNMP: [1/0.02s] MySQL: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'systemStats'[0m] systemStats = No Such Object available on this agent at this OID Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0734 seconds with 832 bytes >> SNMP: [2/0.07s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsInReceives.ipv4 = 0 ipSystemStatsInReceives.ipv6 = 491655 ipSystemStatsHCInReceives.ipv4 = 0 ipSystemStatsHCInReceives.ipv6 = 491655 ipSystemStatsInOctets.ipv4 = 124488621 ipSystemStatsInOctets.ipv6 = 0 ipSystemStatsHCInOctets.ipv4 = 124488621 ipSystemStatsHCInOctets.ipv6 = 0 ipSystemStatsInHdrErrors.ipv4 = 0 ipSystemStatsInHdrErrors.ipv6 = 0 ipSystemStatsInNoRoutes.ipv4 = 0 ipSystemStatsInNoRoutes.ipv6 = 0 ipSystemStatsInAddrErrors.ipv4 = 0 ipSystemStatsInAddrErrors.ipv6 = 0 ipSystemStatsInUnknownProtos.ipv4 = 0 ipSystemStatsInUnknownProtos.ipv6 = 0 ipSystemStatsInTruncatedPkts.ipv4 = 0 ipSystemStatsInTruncatedPkts.ipv6 = 0 ipSystemStatsInForwDatagrams.ipv4 = 0 ipSystemStatsInForwDatagrams.ipv6 = 0 ipSystemStatsHCInForwDatagrams.ipv4 = 0 ipSystemStatsHCInForwDatagrams.ipv6 = 0 ipSystemStatsReasmReqds.ipv4 = 0 ipSystemStatsReasmReqds.ipv6 = 0 ipSystemStatsReasmOKs.ipv4 = 0 ipSystemStatsReasmOKs.ipv6 = 0 ipSystemStatsReasmFails.ipv4 = 0 ipSystemStatsReasmFails.ipv6 = 0 ipSystemStatsInDiscards.ipv4 = 0 ipSystemStatsInDiscards.ipv6 = 0 ipSystemStatsInDelivers.ipv4 = 227129 ipSystemStatsInDelivers.ipv6 = 477976 ipSystemStatsHCInDelivers.ipv4 = 0 ipSystemStatsHCInDelivers.ipv6 = 491655 ipSystemStatsOutRequests.ipv4 = 166720 ipSystemStatsOutRequests.ipv6 = 5832 ipSystemStatsHCOutRequests.ipv4 = 166720 ipSystemStatsHCOutRequests.ipv6 = 5832 ipSystemStatsOutNoRoutes.ipv4 = 0 ipSystemStatsOutNoRoutes.ipv6 = 0 ipSystemStatsOutForwDatagrams.ipv4 = 0 ipSystemStatsOutForwDatagrams.ipv6 = 0 ipSystemStatsHCOutForwDatagrams.ipv4 = 0 ipSystemStatsHCOutForwDatagrams.ipv6 = 0 ipSystemStatsOutDiscards.ipv4 = 0 ipSystemStatsOutDiscards.ipv6 = 0 ipSystemStatsOutFragReqds.ipv4 = 0 ipSystemStatsOutFragReqds.ipv6 = 0 ipSystemStatsOutFragOKs.ipv4 = 0 ipSystemStatsOutFragOKs.ipv6 = 0 ipSystemStatsOutFragFails.ipv4 = 0 ipSystemStatsOutFragFails.ipv6 = 0 ipSystemStatsOutFragCreates.ipv4 = 0 ipSystemStatsOutFragCreates.ipv6 = 0 ipSystemStatsOutTransmits.ipv4 = 0 ipSystemStatsOutTransmits.ipv6 = 0 ipSystemStatsHCOutTransmits.ipv4 = 0 ipSystemStatsHCOutTransmits.ipv6 = 0 ipSystemStatsOutOctets.ipv4 = 32660374 ipSystemStatsOutOctets.ipv6 = 0 ipSystemStatsHCOutOctets.ipv4 = 32660631 ipSystemStatsHCOutOctets.ipv6 = 0 ipSystemStatsInMcastPkts.ipv4 = 0 ipSystemStatsInMcastPkts.ipv6 = 477138 ipSystemStatsHCInMcastPkts.ipv4 = 0 ipSystemStatsHCInMcastPkts.ipv6 = 477138 ipSystemStatsInMcastOctets.ipv4 = 0 ipSystemStatsInMcastOctets.ipv6 = 0 ipSystemStatsHCInMcastOctets.ipv4 = 0 ipSystemStatsHCInMcastOctets.ipv6 = 0 ipSystemStatsOutMcastPkts.ipv4 = 2 ipSystemStatsOutMcastPkts.ipv6 = 4992 ipSystemStatsHCOutMcastPkts.ipv4 = 2 ipSystemStatsHCOutMcastPkts.ipv6 = 4992 ipSystemStatsOutMcastOctets.ipv4 = 0 ipSystemStatsOutMcastOctets.ipv6 = 0 ipSystemStatsHCOutMcastOctets.ipv4 = 0 ipSystemStatsHCOutMcastOctets.ipv6 = 0 ipSystemStatsInBcastPkts.ipv4 = 184535 ipSystemStatsInBcastPkts.ipv6 = 0 ipSystemStatsHCInBcastPkts.ipv4 = 184535 ipSystemStatsHCInBcastPkts.ipv6 = 0 ipSystemStatsOutBcastPkts.ipv4 = 6 ipSystemStatsOutBcastPkts.ipv6 = 0 ipSystemStatsHCOutBcastPkts.ipv4 = 6 ipSystemStatsHCOutBcastPkts.ipv6 = 0 ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00 ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00 ipSystemStatsRefreshRate.ipv4 = 0 ipSystemStatsRefreshRate.ipv6 = 0 ipv4 ipv6 >> Runtime for poller module 'ipSystemStats': 0.3241 seconds with 16656 bytes >> SNMP: [1/0.32s] MySQL: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[300][0m 0.95ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifDescr.1 = LOOPBACK ifDescr.2 = vmac0 ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifMtu.1 = 1500 ifMtu.2 = 1500 ifSpeed.1 = 0 ifSpeed.2 = 100000000 ifPhysAddress.1 = ifPhysAddress.2 = 28:29:86:45:c6:6a ifAdminStatus.1 = up ifAdminStatus.2 = up ifOperStatus.1 = up ifOperStatus.2 = up ifLastChange.1 = 0 ifLastChange.2 = 25 ifInOctets.1 = 0 ifInOctets.2 = 124489757 ifInUcastPkts.1 = 0 ifInUcastPkts.2 = 183182 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 184535 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInErrors.1 = 0 ifInErrors.2 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifOutOctets.1 = 0 ifOutOctets.2 = 32662835 ifOutUcastPkts.1 = 0 ifOutUcastPkts.2 = 186791 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 8 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[300][0m 0.64ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'LOOPBACK', 'ifType' => 'softwareLoopback', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'vmac0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '28:29:86:45:c6:6a', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '25', 'ifInOctets' => '124489757', 'ifInUcastPkts' => '183182', 'ifInNUcastPkts' => '184535', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '32662835', 'ifOutUcastPkts' => '186791', 'ifOutNUcastPkts' => '8', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid Port LOOPBACK: LOOPBACK (1 / #1655326) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName LOOPBACK ifInOctets (0 B) 0 Bps 282 secs ifOutOctets (0 B) 0 Bps 282 secs ifInErrors (0 B) 0 Bps 282 secs ifOutErrors (0 B) 0 Bps 282 secs ifInUcastPkts (0 B) 0 Bps 282 secs ifOutUcastPkts (0 B) 0 Bps 282 secs ifInNUcastPkts (0 B) 0 Bps 282 secs ifOutNUcastPkts (0 B) 0 Bps 282 secs ifInDiscards (0 B) 0 Bps 282 secs ifOutDiscards (0 B) 0 Bps 282 secs ifInUnknownProtos (0 B) 0 Bps 282 secs ifInBroadcastPkts (0 B) 0 Bps 282 secs ifOutBroadcastPkts (0 B) 0 Bps 282 secs ifInMulticastPkts (0 B) 0 Bps 282 secs ifOutMulticastPkts (0 B) 0 Bps 282 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1626947767,1626947485,282,1655326][0m 0.56ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1655326][0m 0.31ms] 1 updated Port vmac0: vmac0 (2 / #1655327) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName vmac0 ifInOctets (85287 B) 302.43617021277 Bps 282 secs ifOutOctets (78605 B) 278.74113475177 Bps 282 secs ifInErrors (0 B) 0 Bps 282 secs ifOutErrors (0 B) 0 Bps 282 secs ifInUcastPkts (373 B) 1.322695035461 Bps 282 secs ifOutUcastPkts (375 B) 1.3297872340426 Bps 282 secs ifInNUcastPkts (87 B) 0.30851063829787 Bps 282 secs ifOutNUcastPkts (0 B) 0 Bps 282 secs ifInDiscards (0 B) 0 Bps 282 secs ifOutDiscards (0 B) 0 Bps 282 secs ifInUnknownProtos (0 B) 0 Bps 282 secs ifInBroadcastPkts (0 B) 0 Bps 282 secs ifOutBroadcastPkts (0 B) 0 Bps 282 secs ifInMulticastPkts (0 B) 0 Bps 282 secs ifOutMulticastPkts (0 B) 0 Bps 282 secs bps(2.42 Kbps/2.23 Kbps)bytes(83.29 KiB/76.76 KiB)pkts(1.32 pps/1.33 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["124489757",124404470,302.43617021276594,85287,"32662835",32584230,278.7411347517731,78605,"0",0,0,0,"0",0,0,0,"183182",182809,1.322695035460993,373,"186791",186416,1.3297872340425532,375,1626947767,1626947485,282,1655327][0m 0.38ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["184535",184448,0.30851063829787234,87,"8",8,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1655327][0m 0.42ms] 2 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1626947767,1626947485,null][0m 0.27ms] 0 updated >> Runtime for poller module 'ports': 0.3995 seconds with 9184 bytes >> SNMP: [4/0.39s] MySQL: [5/0.00s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[300][0m 0.37ms] array ( 'customoid_id' => 8, 'device_id' => 300, 'customoid_descr' => 'Superheat C°', 'customoid_deleted' => 0, 'customoid_current' => 5.7, 'customoid_prev' => 5.7, 'customoid_oid' => '1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.54', 'customoid_datatype' => '', 'customoid_unit' => 'C°', 'customoid_divisor' => 10, 'customoid_multiplier' => 1, 'customoid_limit' => NULL, 'customoid_limit_warn' => NULL, 'customoid_limit_low' => 1.0, 'customoid_limit_low_warn' => NULL, 'customoid_alert' => 0, 'customoid_passed' => 1, 'lastupdate' => '2021-07-22 11:51:25', 'user_func' => NULL, ) SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/apc' '-t' '30' 'udp:HOSTNAME:161' '1.3.6.1.4.1.318.1.1.27.1.4.1.2.1.3.1.54'[0m] 58 Custom OID Superheat C°: 5.8 C° SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[5.8,5.7,8][0m 0.59ms] >> Runtime for poller module 'customoid': 0.0325 seconds with 2304 bytes >> SNMP: [1/0.03s] MySQL: [2/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS Device- Module [ bgp-peers ] disabled on host. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[300][0m 0.3ms] >> Runtime for poller module 'ucd-diskio': 0.0007 seconds with 1160 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device- Module [ wireless ] disabled on host. Modules status: Global+ OS Device- Module [ ospf ] disabled on host. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ cisco-sla ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global+ OS Device- Module [ aruba-controller ] disabled on host. Modules status: Global+ OS Device #### Load poller module entity-physical #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[300][0m 0.27ms] >> Runtime for poller module 'entity-physical': 0.0007 seconds with 1304 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device- Module [ entity-state ] disabled on host. Modules status: Global+ OS Device- Module [ applications ] disabled on host. Modules status: Global+ OS Device #### Load poller module mib #### Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 317 Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/php7') in /opt/librenms/includes/polling/functions.inc.php on line 317 >> Runtime for poller module 'mib': 0.0000 seconds with 0 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mib #### Modules status: Global+ OS Device- Module [ stp ] disabled on host. Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 80 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device- Module [ mpls ] disabled on host. Modules status: Global- OS Device Module [ toner ] disabled globally. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[300][0m 0.37ms] SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[597069,0.696,2.971,300][0m 0.74ms] Updating inrows1s2.hq.nerd.lan Polled in 2.971 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[300][0m 0.44ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.26ms] SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (2, 3, 4) [0;33m[][0m 0.59ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` REGEXP ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".*riv.*",300][0m 0.39ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` REGEXP ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".*nik.*",300][0m 0.26ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` REGEXP ? OR `devices`.`hostname` REGEXP ? OR `devices`.`hostname` REGEXP ? OR `devices`.`location_id` REGEXP ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".*tlc.*",".*tc.*",".*pa6.*",".*Waldeck.*",300][0m 0.26ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[300][0m 0.26ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0092s ### #### Start Alerts #### SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-07-22T09:56:07.688412Z","2021-07-22T09:56:07.688412Z",0,1,"09:56:07","09:56:07","09:56:07","09:56:07","[44m%","device",300,"location",67][0m 0.59ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[300][0m 0.35ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL)) ) [0;33m[300,300,300,300,300,300,300,300][0m 0.99ms] Rule [0;35m#1 (Devices up/down):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[300][0m 0.32ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,300][0m 0.3ms] Status: [0;34mNOCHG[0m Rule [0;35m#2 (Device rebooted):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed>= "85" ) [0;33m[300][0m 0.43ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,300][0m 0.32ms] Status: [0;34mNOCHG[0m Rule [0;35m#7 (Sensor over limit):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit [0;33m[300][0m 0.52ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,300][0m 0.27ms] Status: [0;34mNOCHG[0m Rule [0;35m#8 (Sensor under limit):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= 95 [0;33m[300][0m 0.52ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,300][0m 0.3ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php inrows1s2.hq.nerd.lan 2021-07-22 11:56:07 - 1 devices polled in 3.160 secs SNMP [25/1.90s]: Get[13/0.65s] Getnext[4/0.13s] Walk[8/1.12s] MySQL [46/0.03s]: Cell[10/0.00s] Row[-10/-0.00s] Rows[23/0.01s] Column[1/0.00s] Update[21/0.01s] Insert[1/0.00s] Delete[0/0.00s]