LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.62ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.45ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.33ms] =================================== Version info: Commit SHA: e782bdbe02a21858a5df6e0a1ee4da5c8da6c71f Commit Date: 1621297073 DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208) PHP: 7.4.12 MySQL: 10.5.9-MariaDB RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '[REMOVED]' ORDER BY `device_id` ASC [0;33m[][0m 0.96ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[240][0m 0.5ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[240][0m 0.35ms] Attempting to initialize OS: vertiv-pdu Attempting to initialize OS: vertiv OS initialized as Generic Hostname: [REMOVED] Device ID: 240 OS: vertiv-pdu Resolved IP: [REMOVED] (vertiv) SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["[REMOVED]"][0m 0.42ms] [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '[REMOVED]' response: {"xmt":3,"rcv":3,"loss":0,"min":0.55000000000000004,"max":2.23,"avg":1.1200000000000001,"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[240][0m 0.67ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[132][0m 0.36ms] 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-05-19T12:28:32.064425Z","2021-05-19T12:28:32.064425Z",0,1,"12:28:32","12:28:32","12:28:32","12:28:32","[43m%","device",240,"location",132][0m 1.21ms] 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.55000000000000004,"max":2.23,"avg":1.1200000000000001,"device_id":240,"debug":"[]"}[0m 0.94ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-05-19 08:28:32",1.1200000000000001,240][0m 0.77ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 260505890 .*.*.0 = [REMOVED] .*.*.0 = .*.4.1.21* .*.*.0 = [REMOVED] SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] snmpEngineTime.0 = 2605059 hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 2605059 Uptime: 30 days 3 hours 37 minutes 39 seconds >> Runtime for poller module 'core': 0.1102 seconds with 25496 bytes >> SNMP: [2/0.11s] 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[240][0m 0.65ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[240][0m 0.36ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1621340912][0m 0.41ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,857][0m 0.28ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1620822512][0m 0.38ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,858][0m 0.26ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1618835312][0m 0.39ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,859][0m 0.26ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1589891312][0m 0.39ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,860][0m 0.25ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0067 seconds with 39112 bytes >> SNMP: [0/0.00s] MySQL: [5/0.00s] #### Unload poller module availability #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Location: [REMOVED] Hardware: MN03EDR1-15P3B8-6PS15D0H10-S OS Version: 5.6.1 OS Features: Serial: [REMOVED] >> Runtime for poller module 'os': 0.0019 seconds with 92608 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[240][0m 0.5ms] array ( ) >> Runtime for poller module 'ipmi': 0.0009 seconds with 2992 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[240][0m 0.54ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["current",240][0m 0.47ms] SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.21239.5.2.3.2.1.8.1' '.1.3.6.1.4.1.21239.5.2.3.2.1.8.2' '.1.3.6.1.4.1.21239.5.2.3.2.1.8.3' '.1.3.6.1.4.1.21239.5.2.3.3.1.4.4' '.1.3.6.1.4.1.21239.5.2.3.3.1.4.5' '.1.3.6.1.4.1.21239.5.2.3.3.1.4.6'[0m] .*.4.1.21*.* = 732 .*.4.1.21*.* = 730 .*.4.1.21*.* = 727 .*.4.1.21*.* = 257 .*.4.1.21*.* = 254 .*.4.1.21*.* = 252 Checking (snmp) current Phase AB... Checking (snmp) current Phase BC... Checking (snmp) current Phase CA... Checking (snmp) current Circuit 4 - Phase AB... Checking (snmp) current Circuit 5 - Phase BC... Checking (snmp) current Circuit 6 - Phase CA... 7.32 A SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[7.3200000000000003,7.2599999999999998,"current",11302][0m 1.2ms] 7.3 A SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[7.2999999999999998,7.2400000000000002,"current",11303][0m 0.78ms] 7.27 A SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[7.2699999999999996,7.2300000000000004,"current",11304][0m 0.79ms] 2.57 A SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[2.5699999999999998,2.5800000000000001,"current",11305][0m 0.88ms] 2.54 A SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[2.54,2.5600000000000001,"current",11306][0m 0.75ms] 2.52 A SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[2.52,2.5800000000000001,"current",11307][0m 0.8ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["voltage",240][0m 0.54ms] SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.21239.5.2.3.2.1.4.1' '.1.3.6.1.4.1.21239.5.2.3.2.1.4.2' '.1.3.6.1.4.1.21239.5.2.3.2.1.4.3'[0m] .*.4.1.21*.* = 2068 .*.4.1.21*.* = 2078 .*.4.1.21*.* = 2062 Checking (snmp) voltage Phase AB... Checking (snmp) voltage Phase BC... Checking (snmp) voltage Phase CA... 20.68 V 20.78 V 20.62 V SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[20.620000000000001,20.629999999999999,"voltage",11310][0m 1.2ms] >> Runtime for poller module 'sensors': 0.1409 seconds with 14488 bytes >> SNMP: [2/0.13s] MySQL: [10/0.01s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: vertiv-pdu Attempting to initialize OS: vertiv OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[240][0m 0.51ms] >> Runtime for poller module 'processors': 0.0023 seconds with 125880 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[240][0m 0.41ms] >> Runtime for poller module 'mempools': 0.0017 seconds with 75592 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[240][0m 0.35ms] >> Runtime for poller module 'storage': 0.0006 seconds with 2032 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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'icmp'[0m] icmp = No Such Object available on this agent at this OID Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m] ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 ifTableLastChange.0 = 0:0:00:00.00 IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'snmp'[0m] snmp = No Such Object available on this agent at this OID Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m] mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m] mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 mib-*.0 = 0:0:00:00.00 >> Runtime for poller module 'netstats': 0.3800 seconds with 3856 bytes >> SNMP: [7/0.38s] MySQL: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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.0708 seconds with 1640 bytes >> SNMP: [1/0.07s] 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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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.1110 seconds with 1936 bytes >> SNMP: [2/0.11s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0882 seconds with 1976 bytes >> SNMP: [1/0.09s] 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[240][0m 1.14ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.3 = 3 ifIndex.4 = 4 ifIndex.12 = 12 ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = port1 ifDescr.4 = port2 ifDescr.12 = br0 ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.12 = ethernetCsmacd ifMtu.1 = 65536 ifMtu.2 = 1500 ifMtu.3 = 1500 ifMtu.4 = 1500 ifMtu.12 = 1500 ifSpeed.1 = 10000000 ifSpeed.2 = 100000000 ifSpeed.3 = 100000000 ifSpeed.4 = 10000000 ifSpeed.12 = 0 ifPhysAddress.1 = ifPhysAddress.2 = 0:19:85:a:dd:9d ifPhysAddress.3 = 0:19:85:a:dd:9d ifPhysAddress.4 = 0:19:85:a:dd:9d ifPhysAddress.12 = 0:19:85:a:dd:9d ifAdminStatus.1 = up ifAdminStatus.2 = up ifAdminStatus.3 = up ifAdminStatus.4 = up ifAdminStatus.12 = up ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = up ifOperStatus.4 = down ifOperStatus.12 = up ifLastChange.1 = 0 ifLastChange.2 = 0 ifLastChange.3 = 0 ifLastChange.4 = 0 ifLastChange.12 = 0 ifInOctets.1 = 4229453885 ifInOctets.2 = 1896870382 ifInOctets.3 = 1713656182 ifInOctets.4 = 0 ifInOctets.12 = 1473122135 ifInUcastPkts.1 = 632194334 ifInUcastPkts.2 = 45803550 ifInUcastPkts.3 = 45803550 ifInUcastPkts.4 = 0 ifInUcastPkts.12 = 17197608 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 0 ifInNUcastPkts.3 = 0 ifInNUcastPkts.4 = 0 ifInNUcastPkts.12 = 0 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 183727 ifInDiscards.4 = 0 ifInDiscards.12 = 7841 ifInErrors.1 = 0 ifInErrors.2 = 481 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInErrors.12 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifInUnknownProtos.3 = 0 ifInUnknownProtos.4 = 0 ifInUnknownProtos.12 = 0 ifOutOctets.1 = 4229453885 ifOutOctets.2 = 1157762642 ifOutOctets.3 = 1135564786 ifOutOctets.4 = 0 ifOutOctets.12 = 1130639924 ifOutUcastPkts.1 = 632194334 ifOutUcastPkts.2 = 5470417 ifOutUcastPkts.3 = 5465635 ifOutUcastPkts.4 = 0 ifOutUcastPkts.12 = 5456916 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 0 ifOutNUcastPkts.3 = 0 ifOutNUcastPkts.4 = 0 ifOutNUcastPkts.12 = 0 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutDiscards.12 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutErrors.12 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifOutQLen.3 = 0 ifOutQLen.4 = 0 ifOutQLen.12 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero ifSpecific.3 = zeroDotZero ifSpecific.4 = zeroDotZero ifSpecific.12 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' '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[240][0m 0.66ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'lo', 'ifType' => 'softwareLoopback', 'ifMtu' => '65536', 'ifSpeed' => '10000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '4229453885', 'ifInUcastPkts' => '632194334', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '4229453885', 'ifOutUcastPkts' => '632194334', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'eth0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '0:19:85:a:dd:9d', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '1896870382', 'ifInUcastPkts' => '45803550', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '481', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1157762642', 'ifOutUcastPkts' => '5470417', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 3 => array ( 'ifIndex' => '3', 'ifDescr' => 'port1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '0:19:85:a:dd:9d', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '1713656182', 'ifInUcastPkts' => '45803550', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '183727', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1135564786', 'ifOutUcastPkts' => '5465635', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 4 => array ( 'ifIndex' => '4', 'ifDescr' => 'port2', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '10000000', 'ifPhysAddress' => '0:19:85:a:dd:9d', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'down', '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', ), 12 => array ( 'ifIndex' => '12', 'ifDescr' => 'br0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '0:19:85:a:dd:9d', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '1473122135', 'ifInUcastPkts' => '17197608', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '7841', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1130639924', 'ifOutUcastPkts' => '5456916', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid valid valid valid Port lo: lo (1 / #12274) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName lo ifInOctets (371537 B) 6405.8103448276 Bps 58 secs ifOutOctets (371537 B) 6405.8103448276 Bps 58 secs ifInErrors (0 B) 0 Bps 58 secs ifOutErrors (0 B) 0 Bps 58 secs ifInUcastPkts (1610 B) 27.758620689655 Bps 58 secs ifOutUcastPkts (1610 B) 27.758620689655 Bps 58 secs ifInNUcastPkts (0 B) 0 Bps 58 secs ifOutNUcastPkts (0 B) 0 Bps 58 secs ifInDiscards (0 B) 0 Bps 58 secs ifOutDiscards (0 B) 0 Bps 58 secs ifInUnknownProtos (0 B) 0 Bps 58 secs ifInBroadcastPkts (0 B) 0 Bps 58 secs ifOutBroadcastPkts (0 B) 0 Bps 58 secs ifInMulticastPkts (0 B) 0 Bps 58 secs ifOutMulticastPkts (0 B) 0 Bps 58 secs bps(51.25 Kbps/51.25 Kbps)bytes(362.83 KiB/362.83 KiB)pkts(27.76 pps/27.76 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["4229453885",4229082348,6405.8103448275861,371537,"4229453885",4229082348,6405.8103448275861,371537,"0",0,0,0,"0",0,0,0,"632194334",632192724,27.758620689655171,1610,"632194334",632192724,27.758620689655171,1610,1621427313,1621427255,58,12274][0m 1.15ms] 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,12274][0m 0.6ms] 1 updated Port eth0: eth0 (2 / #12275) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName eth0 ifInOctets (38392 B) 661.93103448276 Bps 58 secs ifOutOctets (69725 B) 1202.1551724138 Bps 58 secs ifInErrors (0 B) 0 Bps 58 secs ifOutErrors (0 B) 0 Bps 58 secs ifInUcastPkts (348 B) 6 Bps 58 secs ifOutUcastPkts (171 B) 2.948275862069 Bps 58 secs ifInNUcastPkts (0 B) 0 Bps 58 secs ifOutNUcastPkts (0 B) 0 Bps 58 secs ifInDiscards (0 B) 0 Bps 58 secs ifOutDiscards (0 B) 0 Bps 58 secs ifInUnknownProtos (0 B) 0 Bps 58 secs ifInBroadcastPkts (0 B) 0 Bps 58 secs ifOutBroadcastPkts (0 B) 0 Bps 58 secs ifInMulticastPkts (0 B) 0 Bps 58 secs ifOutMulticastPkts (0 B) 0 Bps 58 secs bps(5.3 Kbps/9.62 Kbps)bytes(37.49 KiB/68.09 KiB)pkts(6 pps/2.95 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["1896870382",1896831990,661.93103448275861,38392,"1157762642",1157692917,1202.155172413793,69725,"481",481,0,0,"0",0,0,0,"45803550",45803202,6,348,"5470417",5470246,2.9482758620689653,171,1621427313,1621427255,58,12275][0m 0.78ms] 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,12275][0m 0.34ms] 1 updated Port port1: port1 (3 / #12276) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName port1 ifInOctets (37000 B) 637.93103448276 Bps 58 secs ifOutOctets (69041 B) 1190.3620689655 Bps 58 secs ifInErrors (0 B) 0 Bps 58 secs ifOutErrors (0 B) 0 Bps 58 secs ifInUcastPkts (348 B) 6 Bps 58 secs ifOutUcastPkts (171 B) 2.948275862069 Bps 58 secs ifInNUcastPkts (0 B) 0 Bps 58 secs ifOutNUcastPkts (0 B) 0 Bps 58 secs ifInDiscards (2 B) 0.03448275862069 Bps 58 secs ifOutDiscards (0 B) 0 Bps 58 secs ifInUnknownProtos (0 B) 0 Bps 58 secs ifInBroadcastPkts (0 B) 0 Bps 58 secs ifOutBroadcastPkts (0 B) 0 Bps 58 secs ifInMulticastPkts (0 B) 0 Bps 58 secs ifOutMulticastPkts (0 B) 0 Bps 58 secs bps(5.1 Kbps/9.52 Kbps)bytes(36.13 KiB/67.42 KiB)pkts(6 pps/2.95 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["1713656182",1713619182,637.93103448275861,37000,"1135564786",1135495745,1190.3620689655172,69041,"0",0,0,0,"0",0,0,0,"45803550",45803202,6,348,"5465635",5465464,2.9482758620689653,171,1621427313,1621427255,58,12276][0m 0.87ms] 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,"183727",183725,0.034482758620689655,2,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12276][0m 0.78ms] 2 updated Port port2: port2 (4 / #12277) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName port212277 skipped because port is still down since last polling. Port br0: br0 (12 / #12278) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName br0 ifInOctets (31202 B) 537.96551724138 Bps 58 secs ifOutOctets (69041 B) 1190.3620689655 Bps 58 secs ifInErrors (0 B) 0 Bps 58 secs ifOutErrors (0 B) 0 Bps 58 secs ifInUcastPkts (296 B) 5.1034482758621 Bps 58 secs ifOutUcastPkts (171 B) 2.948275862069 Bps 58 secs ifInNUcastPkts (0 B) 0 Bps 58 secs ifOutNUcastPkts (0 B) 0 Bps 58 secs ifInDiscards (0 B) 0 Bps 58 secs ifOutDiscards (0 B) 0 Bps 58 secs ifInUnknownProtos (0 B) 0 Bps 58 secs ifInBroadcastPkts (0 B) 0 Bps 58 secs ifOutBroadcastPkts (0 B) 0 Bps 58 secs ifInMulticastPkts (0 B) 0 Bps 58 secs ifOutMulticastPkts (0 B) 0 Bps 58 secs bps(4.3 Kbps/9.52 Kbps)bytes(30.47 KiB/67.42 KiB)pkts(5.1 pps/2.95 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","1473122135",1473090933,537.9655172413793,31202,"1130639924",1130570883,1190.3620689655172,69041,"0",0,0,0,"0",0,0,0,"17197608",17197312,5.1034482758620694,296,"5456916",5456745,2.9482758620689653,171,1621427313,1621427255,58,12278][0m 0.77ms] 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,"7841",7841,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,12278][0m 0.35ms] 1 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where `port_id` in (?) [0;33m[1621427313,1621427255,null,12277][0m 0.81ms] 1 updated >> Runtime for poller module 'ports': 0.3557 seconds with 47800 bytes >> SNMP: [4/0.33s] MySQL: [9/0.01s] #### 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[240][0m 0.44ms] >> Runtime for poller module 'customoid': 0.0008 seconds with 2400 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[240][0m 0.47ms] >> Runtime for poller module 'bgp-peers': 0.0021 seconds with 15320 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module bgp-peers #### 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[240][0m 0.42ms] >> Runtime for poller module 'ucd-diskio': 0.0008 seconds with 1944 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 #### Load poller module wireless #### Attempting to initialize OS: vertiv-pdu Attempting to initialize OS: vertiv OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[240][0m 0.39ms] >> Runtime for poller module 'wireless': 0.0018 seconds with 104168 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] ospfGeneralGroup = No Such Object available on this agent at this OID Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID array ( ) SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[240][0m 0.47ms] 0 >> Runtime for poller module 'ospf': 0.0656 seconds with 31392 bytes >> SNMP: [1/0.06s] MySQL: [0/0.00s] #### Unload poller module ospf #### 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 globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[240][0m 0.38ms] >> Runtime for poller module 'entity-physical': 0.0008 seconds with 2152 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[240][0m 0.33ms] >> Runtime for poller module 'applications': 0.0005 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module applications #### Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[240][0m 0.34ms] SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0509 seconds with 5784 bytes >> SNMP: [1/0.05s] MySQL: [1/0.00s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 400 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 #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0004 seconds with 24080 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[240][0m 0.59ms] SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2605059,1.1200000000000001,2.516,240][0m 0.84ms] Updating [REMOVED] Polled in 2.516 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[240][0m 0.67ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.37ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[240][0m 0.39ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0029s ### #### 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-05-19T12:28:33.568591Z","2021-05-19T12:28:33.568591Z",0,1,"12:28:33","12:28:33","12:28:33","12:28:33","[43m%","device",240,"location",132][0m 1.1ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[240][0m 0.65ms] 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[240,240,240,240,240,240,240,240][0m 2.1ms] Rule [0;35m#5 (Device Down! Due to no ICMP response.):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" AND devices.ignore = 0 AND devices.disabled = 0 [0;33m[240][0m 0.67ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,240][0m 0.41ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php [REMOVED] 2021-05-19 08:28:33 - 1 devices polled in 2.775 secs SNMP [22/1.42s]: Get[9/0.56s] Getnext[4/0.20s] Walk[9/0.66s] MySQL [40/0.03s]: Cell[3/0.00s] Row[-2/-0.00s] Rows[16/0.01s] Column[1/0.00s] Update[21/0.02s] Insert[1/0.00s] Delete[0/0.00s]