LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.78ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.68ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.64ms] =================================== Version info: Commit SHA: a880643ba447c907bd86d71216fe2a6900bab245 Commit Date: 1621427246 DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208) PHP: 7.4.16 MySQL: 10.5.10-MariaDB-0ubuntu0.21.04.1 RRDTool: 1.7.2 SNMP: NET-SNMP 5.9 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.100.6.152' ORDER BY `device_id` ASC [0;33m[][0m 1.75ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[74][0m 1.06ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[74][0m 0.81ms] Attempting to initialize OS: serverscheck OS initialized as Generic Hostname: 10.100.6.152 Device ID: 74 OS: serverscheck SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["10.100.6.152"][0m 0.84ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '10.100.6.152' response: {"xmt":3,"rcv":3,"loss":0,"min":0.453,"max":0.533,"avg":0.499,"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[74][0m 1.64ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[14][0m 0.94ms] 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-06-09T16:43:31.223224Z","2021-06-09T16:43:31.223224Z",0,1,"16:43:31","16:43:31","16:43:31","16:43:31","[43m%","device",74,"location",14][0m 2.16ms] 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.453,"max":0.533,"avg":0.499,"device_id":74,"debug":"[]"}[0m 1.44ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-06-09 19:43:31",0.499,74][0m 1.25ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 3002592 .*.*.0 = Controlbox .*.*.0 = .*.4.1.17095.2 .*.*.0 = TH-332B SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemUptime.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: snmpEngineTime.0.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemUptime.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: snmpEngineTime.0.0.0 Uptime seconds: 30026 Uptime: 8 hours 20 minutes 26 seconds >> Runtime for poller module 'core': 0.0615 seconds with 25496 bytes >> SNMP: [2/0.06s] 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[74][0m 1.24ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[74][0m 0.93ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1623170611][0m 1.01ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,273][0m 0.73ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1622652211][0m 0.89ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,274][0m 0.86ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1620665011][0m 0.92ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,275][0m 1.12ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[74,1591721011][0m 0.93ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,276][0m 0.72ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0159 seconds with 39112 bytes >> SNMP: [0/0.00s] MySQL: [5/0.01s] #### 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: Varna Bulgaria Hardware: OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0046 seconds with 93248 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[74][0m 1.08ms] array ( ) >> Runtime for poller module 'ipmi': 0.0021 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[74][0m 0.99ms] >> Runtime for poller module 'sensors': 0.0015 seconds with 1584 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: serverscheck OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[74][0m 0.95ms] >> Runtime for poller module 'processors': 0.0038 seconds with 125928 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[74][0m 1.13ms] >> Runtime for poller module 'mempools': 0.0039 seconds with 75032 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[74][0m 0.98ms] >> Runtime for poller module 'storage': 0.0016 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/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'icmp'[0m] Exitcode: 1 Error: OID not increasing: icmp >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: icmp >= sysDescr.0 IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m] sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B sysDescr.0 = TH-332B IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0.0 SNMPSNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'snmp'[0m] Exitcode: 1 Error: OID not increasing: snmp >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: snmp >= sysDescr.0 TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m] mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] mib-* = "TH-332B" mib-* = "TH-332B" UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m] mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" mib-* = "TH-332B" >> Runtime for poller module 'netstats': 0.2178 seconds with 3856 bytes >> SNMP: [7/0.21s] MySQL: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemNumUsers.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemProcesses.0.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemNumUsers.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: hrSystemProcesses.0.0.0 >> Runtime for poller module 'hr-mib': 0.0321 seconds with 1640 bytes >> SNMP: [1/0.03s] MySQL: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'systemStats'[0m] SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.3.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.2.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.1.0.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.3.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.2.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: laLoadInt.1.0.0.0 >> Runtime for poller module 'ucd-mib': 0.0589 seconds with 1936 bytes >> SNMP: [2/0.06s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] Exitcode: 1 Error: OID not increasing: ipSystemStatsTable >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ipSystemStatsTable >= sysDescr.0 0 >> Runtime for poller module 'ipSystemStats': 0.0385 seconds with 11456 bytes >> SNMP: [1/0.04s] 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[74][0m 2.24ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ifXEntry'[0m] Exitcode: 1 Error: OID not increasing: ifXEntry >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ifXEntry >= sysDescr.0 SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'ifEntry'[0m] Exitcode: 1 Error: OID not increasing: ifEntry >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ifEntry >= sysDescr.0 dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] Exitcode: 1 Error: OID not increasing: dot3StatsDuplexStatus >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: dot3StatsDuplexStatus >= sysDescr.0 SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] Exitcode: 1 Error: OID not increasing: dot1qPvid >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: dot1qPvid >= sysDescr.0 SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[74][0m 1.2ms] array ( 0 => array ( 'sysDescr' => 'TH-332B', ), ) ignored: empty ifDescr, ifAlias and ifName SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.55ms] SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1623257011,null,1623257011][0m 0.5ms] 0 updated >> Runtime for poller module 'ports': 0.1448 seconds with 27696 bytes >> SNMP: [4/0.13s] MySQL: [2/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[74][0m 1.04ms] array ( 'customoid_id' => 1, 'device_id' => 74, 'customoid_descr' => 'controlboxTemperature', 'customoid_deleted' => 0, 'customoid_current' => 22.9, 'customoid_prev' => 22.9, 'customoid_oid' => '.1.3.6.1.4.1.17095.2.1.3.0', 'customoid_datatype' => '', 'customoid_unit' => 'Temp', 'customoid_divisor' => 1, 'customoid_multiplier' => 1, 'customoid_limit' => 30.0, 'customoid_limit_warn' => 30.0, 'customoid_limit_low' => 15.0, 'customoid_limit_low_warn' => 15.0, 'customoid_alert' => 1, 'customoid_passed' => 1, 'lastupdate' => '2021-06-09 19:40:43', 'user_func' => NULL, ) SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.17095.2.1.3.0'[0m] "22.8" Custom OID controlboxTemperature: 22.8 Temp SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[22.8,22.9,1][0m 1.49ms] array ( 'customoid_id' => 2, 'device_id' => 74, 'customoid_descr' => 'Current Temperature', 'customoid_deleted' => 0, 'customoid_current' => 22.9, 'customoid_prev' => 22.9, 'customoid_oid' => '.1.3.6.1.4.1.17095.2.1.3.0', 'customoid_datatype' => '', 'customoid_unit' => 'Temp', 'customoid_divisor' => 1, 'customoid_multiplier' => 1, 'customoid_limit' => 30.0, 'customoid_limit_warn' => 30.0, 'customoid_limit_low' => 15.0, 'customoid_limit_low_warn' => 15.0, 'customoid_alert' => 1, 'customoid_passed' => 1, 'lastupdate' => '2021-06-09 19:40:43', 'user_func' => NULL, ) SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.17095.2.1.3.0'[0m] "22.8" Custom OID Current Temperature: 22.8 Temp SQL[[1;33mUPDATE `customoids` set `customoid_current`=?,`lastupdate`=NOW(),`customoid_prev`=? WHERE `customoid_id` = ? [0;33m[22.8,22.9,2][0m 1.08ms] >> Runtime for poller module 'customoid': 0.0539 seconds with 3288 bytes >> SNMP: [2/0.05s] MySQL: [3/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[74][0m 1.33ms] >> Runtime for poller module 'bgp-peers': 0.0054 seconds with 15272 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[74][0m 0.74ms] >> Runtime for poller module 'ucd-diskio': 0.0013 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: serverscheck OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[74][0m 0.91ms] >> Runtime for poller module 'wireless': 0.0041 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/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] Exitcode: 1 Error: OID not increasing: ospfGeneralGroup >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ospfGeneralGroup >= sysDescr.0 array ( 0 => array ( 'sysDescr' => 'TH-332B', ), ) SQL[[1;33mselect * from `ospf_instances` where (`device_id` = ? and `ospf_instance_id` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.38ms] SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,2][0m 0.68ms] 1 Areas: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfAreaEntry'[0m] Exitcode: 1 Error: OID not increasing: ospfAreaEntry >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ospfAreaEntry >= sysDescr.0 array ( 0 => array ( 'sysDescr' => 'TH-332B', ), ) SQL[[1;33mselect * from `ospf_areas` where (`device_id` = ? and `ospfAreaId` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.15ms] SQL[[1;33mdelete from `ospf_areas` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,1][0m 0.65ms] 1 Ports: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfIfEntry'[0m] Exitcode: 1 Error: OID not increasing: ospfIfEntry >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ospfIfEntry >= sysDescr.0 array ( 0 => array ( 'sysDescr' => 'TH-332B', ), ) SQL[[1;33mselect `port_id` from `ipv4_addresses` where `ipv4_address` is null and `context_name` is null limit 1 [0;33m[][0m 0.84ms] SQL[[1;33mselect * from `ospf_ports` where (`device_id` = ? and `ospf_port_id` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.19ms] SQL[[1;33mdelete from `ospf_ports` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,1][0m 0.68ms] 1 Neighbours: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfNbrEntry'[0m] Exitcode: 1 Error: OID not increasing: ospfNbrEntry >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ospfNbrEntry >= sysDescr.0 array ( 0 => array ( 'sysDescr' => 'TH-332B', ), ) SQL[[1;33mselect `port_id` from `ipv4_addresses` where `ipv4_address` is null and `context_name` is null limit 1 [0;33m[][0m 0.85ms] SQL[[1;33mselect * from `ospf_nbrs` where (`device_id` = ? and `ospf_nbr_id` = ? and `context_name` is null) limit 1 [0;33m[74,0][0m 1.04ms] SQL[[1;33mdelete from `ospf_nbrs` where (`device_id` = ? and `context_name` is null) and `id` not in (?) [0;33m[74,1][0m 0.64ms] 1 TOS Metrics: SNMP[[0;36m'/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfIfMetricEntry'[0m] Exitcode: 1 Error: OID not increasing: ospfIfMetricEntry >= sysDescr.0 sysDescr.0 = TH-332B Error: OID not increasing: ospfIfMetricEntry >= sysDescr.0 array ( 0 => array ( 'sysDescr' => 'TH-332B', ), ) SQL[[1;33mselect `ospf_port_id` from `ospf_ports` where `ospfIfIpAddress` is null and `context_name` is null limit 1 [0;33m[][0m 0.87ms] SQL[[1;33mselect * from `ospf_ports` where (`device_id` = ? and `ospf_port_id` is null and `context_name` is null) limit 1 [0;33m[74][0m 0.79ms] #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\Database\Connection->runQueryCallback() #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(472): Illuminate\Database\Connection->run() #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(424): Illuminate\Database\Connection->statement() #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert() #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2882): Illuminate\Database\Query\Processors\Processor->processInsertGetId() #5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1560): Illuminate\Database\Query\Builder->insertGetId() #6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1052): Illuminate\Database\Eloquent\Builder->__call() #7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1017): Illuminate\Database\Eloquent\Model->insertAndSetId() #8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(858): Illuminate\Database\Eloquent\Model->performInsert() #9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(485): Illuminate\Database\Eloquent\Model->save() #10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/helpers.php(263): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}() #11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(486): tap() #12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate() #13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1890): Illuminate\Database\Eloquent\Model->forwardCallTo() #14 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1902): Illuminate\Database\Eloquent\Model->__call() #15 /opt/librenms/includes/polling/ospf.inc.php(152): Illuminate\Database\Eloquent\Model::__callStatic() #16 /opt/librenms/includes/polling/functions.inc.php(317): include('/opt/librenms/i...') #17 /opt/librenms/poller.php(140): poll_device() #18 {main} [0;31mError in ospf module.[0m SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ospf_port_id' cannot be null (SQL: insert into `ospf_ports` (`device_id`, `ospf_port_id`, `context_name`) values (74, ?, ?)) >> Runtime for poller module 'ospf': 0.1891 seconds with 237176 bytes >> SNMP: [5/0.16s] 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[74][0m 1.19ms] >> Runtime for poller module 'entity-physical': 0.0020 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[74][0m 0.95ms] >> Runtime for poller module 'applications': 0.0015 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module applications #### 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/php') in /opt/librenms/includes/polling/functions.inc.php on line 317 >> Runtime for poller module 'mib': 0.0001 seconds with 0 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mib #### Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[74][0m 1.01ms] SNMP[[0;36m'/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] Exitcode: 2 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: BRIDGE-MIB::dot1dStpProtocolSpecification.0.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: BRIDGE-MIB::dot1dStpProtocolSpecification.0.0 >> Runtime for poller module 'stp': 0.0316 seconds with 5784 bytes >> SNMP: [1/0.03s] MySQL: [1/0.00s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0003 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.0009 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[74][0m 1.26ms] SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[30026,0.499,1.977,74][0m 1.65ms] Updating 10.100.6.152 Polled in 1.977 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[74][0m 1.31ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.86ms] 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 (1, 2, 3, 4, 5, 6) [0;33m[][0m 1.71ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[74][0m 1.12ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0157s ### #### 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-06-09T16:43:32.198327Z","2021-06-09T16:43:32.198327Z",0,1,"16:43:32","16:43:32","16:43:32","16:43:32","[43m%","device",74,"location",14][0m 1.96ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[74][0m 1.1ms] 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[74,74,74,74,74,74,74,74][0m 3.71ms] 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[74][0m 1.12ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,74][0m 0.77ms] 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 xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed> sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.29ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,74][0m 1.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.22ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,74][0m 0.64ms] Status: [0;34mNOCHG[0m Rule [0;35m#11 (Wireless Sensor under limit):[0m SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[74][0m 1.19ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,74][0m 0.63ms] Status: [0;34mNOCHG[0m Rule [0;35m#12 (State Sensor Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [0;33m[74][0m 1.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,74][0m 0.64ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php 10.100.6.152 2021-06-09 19:43:32 - 1 devices polled in 2.481 secs SNMP [26/0.80s]: Get[9/0.26s] Getnext[4/0.12s] Walk[13/0.42s] MySQL [36/0.06s]: Cell[13/0.01s] Row[-12/-0.01s] Rows[24/0.04s] Column[1/0.00s] Update[9/0.01s] Insert[1/0.00s] Delete[0/0.00s]