LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 6.2ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 3.31ms] SQL[[1;33mSELECT version() [0;33m[][0m 1.67ms] =================================== Version info: Commit SHA: 21192a9cf2a3226e1a06bf69e5688242c5903dfa Commit Date: 1549635449 DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131) PHP: 7.0.33-0ubuntu0.16.04.2 MySQL: 10.0.38-MariaDB-0ubuntu0.16.04.1 RRDTool: 1.5.5 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache... Done Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.61.250' ORDER BY `device_id` ASC [0;33m[][0m 13.42ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[306][0m 0.33ms] Hostname: 192.168.61.250 Device ID: 306 OS: sonus-sbc Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 249 [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.61.250 array ( 'xmt' => '3', 'rcv' => '3', 'loss' => '0', 'min' => '5.00', 'max' => '8.71', 'avg' => '6.46', 'exitcode' => 0, ) 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":"5.00","max":"8.71","avg":"6.46","device_id":306,"debug":"[]"}[0m 305.98ms] 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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 687370439 .*.*.0 = .*.*.0 = .*.*.0 = .*.*.0 = .*.4.1.28* .*.*.0 = Sonus SBC 5000 version sbc-V07.02.00-R000.x86_64 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] snmpEngineTime.0 = No Such Object available on this agent at this OID hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 6873704 RRD[[0;32mupdate 192.168.61.250/uptime.rrd N:6873704 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Uptime: 79 days, 13h 21m 44s SQL[[1;33mselect * from `locations` where `locations`.`id` is null limit 1 [0;33m[][0m 0.37ms] >> Runtime for poller module 'core': 0.0406 seconds with 43936 bytes >> SNMP: [2/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module core #### RRD[[0;32mupdate 192.168.61.250/poller-perf-core.rrd N:0.040635824203491 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module unix-agent #### >> Runtime for poller module 'unix-agent': 0.0006 seconds with 8256 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module unix-agent #### RRD[[0;32mupdate 192.168.61.250/poller-perf-unix-agent.rrd N:0.00055408477783203 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module os #### Generic :( Hardware: Version: Features: Serial: >> Runtime for poller module 'os': 0.0002 seconds with 496 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module os #### RRD[[0;32mupdate 192.168.61.250/poller-perf-os.rrd N:0.00023603439331055 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[306][0m 0.69ms] array ( ) >> Runtime for poller module 'ipmi': 0.0014 seconds with 2552 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ipmi #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ipmi.rrd N:0.0013620853424072 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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[306][0m 1.28ms] >> Runtime for poller module 'sensors': 0.0017 seconds with 1464 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module sensors #### RRD[[0;32mupdate 192.168.61.250/poller-perf-sensors.rrd N:0.0017039775848389 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: sonus-sbc OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[306][0m 0.61ms] >> Runtime for poller module 'processors': 0.0024 seconds with 91392 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module processors #### RRD[[0;32mupdate 192.168.61.250/poller-perf-processors.rrd N:0.0023939609527588 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[306][0m 0.34ms] >> Runtime for poller module 'mempools': 0.0006 seconds with 1720 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module mempools #### RRD[[0;32mupdate 192.168.61.250/poller-perf-mempools.rrd N:0.00063514709472656 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[306][0m 0.81ms] >> Runtime for poller module 'storage': 0.0011 seconds with 1704 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module storage #### RRD[[0;32mupdate 192.168.61.250/poller-perf-storage.rrd N:0.0010788440704346 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'icmp'[0m] icmp = No Such Object available on this agent at this OID IPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m] : Unknown Object Identifier (Sub-id not found: (top) -> ) IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' '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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmp'[0m] snmpInPkts.0 = 1013401 snmpInBadVersions.0 = 0 snmpInBadCommunityNames.0 = 136007 snmpInBadCommunityUses.0 = 0 snmpInASNParseErrs.0 = 0 snmpEnableAuthenTraps.0 = enabled snmpSilentDrops.0 = 0 snmpProxyDrops.0 = 0 RRD[[0;32mupdate 192.168.61.250/netstats-snmp.rrd N:1013401:U:0:136007:0:0:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:0:0 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m] TCPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] : Unknown Object Identifier (Sub-id not found: (top) -> ) UDPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] : Unknown Object Identifier (Sub-id not found: (top) -> ) >> Runtime for poller module 'netstats': 0.0918 seconds with 3552 bytes >> SNMP: [6/0.09s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netstats #### RRD[[0;32mupdate 192.168.61.250/poller-perf-netstats.rrd N:0.091756105422974 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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' '-t' '1' '-r' '2' '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.0149 seconds with 1472 bytes >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module hr-mib #### RRD[[0;32mupdate 192.168.61.250/poller-perf-hr-mib.rrd N:0.014887094497681 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'systemStats'[0m] 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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'[0m] memTotalSwap.0 = No Such Object available on this agent at this OID memAvailSwap.0 = No Such Object available on this agent at this OID memTotalReal.0 = No Such Object available on this agent at this OID memAvailReal.0 = No Such Object available on this agent at this OID memTotalFree.0 = No Such Object available on this agent at this OID memShared.0 = No Such Object available on this agent at this OID memBuffer.0 = No Such Object available on this agent at this OID memCached.0 = 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' '-t' '1' '-r' '2' '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.0518 seconds with 2496 bytes >> SNMP: [3/0.05s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-mib #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ucd-mib.rrd N:0.051810026168823 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0404 seconds with 1872 bytes >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ipSystemStats #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ipSystemStats.rrd N:0.04041600227356 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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[306][0m 21.46ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifXEntry'[0m] 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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifEntry = No Such Object available on this agent at this OID dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] 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' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] 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[306][0m 0.71ms] array ( ) >> Runtime for poller module 'ports': 0.1597 seconds with 20744 bytes >> SNMP: [4/0.14s] MySQL: [1/0.02s] RRD: [0/0.00s] #### Unload poller module ports #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ports.rrd N:0.15971708297729 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]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[306][0m 0.94ms] >> Runtime for poller module 'bgp-peers': 0.0020 seconds with 11304 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module bgp-peers #### RRD[[0;32mupdate 192.168.61.250/poller-perf-bgp-peers.rrd N:0.00201416015625 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module junose-atm-vp #### SQL[[1;33mSELECT * FROM `ports` AS P, `juniAtmVp` AS J WHERE P.`device_id` = ? AND J.port_id = P.port_id [0;33m[306][0m 0.95ms] >> Runtime for poller module 'junose-atm-vp': 0.0013 seconds with 2448 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module junose-atm-vp #### RRD[[0;32mupdate 192.168.61.250/poller-perf-junose-atm-vp.rrd N:0.0012960433959961 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ toner ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[306][0m 2.45ms] >> Runtime for poller module 'ucd-diskio': 0.0028 seconds with 1824 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-diskio #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ucd-diskio.rrd N:0.0028059482574463 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: sonus-sbc OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[306][0m 13.48ms] >> Runtime for poller module 'wireless': 0.0150 seconds with 167904 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [0/0.00s] #### Unload poller module wireless #### RRD[[0;32mupdate 192.168.61.250/poller-perf-wireless.rrd N:0.014981985092163 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ospf #### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[306][0m 3.92ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] 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[306][0m 35.81ms] 0 >> Runtime for poller module 'ospf': 0.0780 seconds with 160800 bytes >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ospf #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ospf.rrd N:0.078013896942139 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-ipsec-flow-monitor #### >> Runtime for poller module 'cisco-ipsec-flow-monitor': 0.0002 seconds with 2368 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-ipsec-flow-monitor #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-ipsec-flow-monitor.rrd N:0.0002140998840332 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-remote-access-monitor #### >> Runtime for poller module 'cisco-remote-access-monitor': 0.0001 seconds with 600 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-remote-access-monitor #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-remote-access-monitor.rrd N:0.00010514259338379 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-cef #### >> Runtime for poller module 'cisco-cef': 0.0002 seconds with 2104 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-cef #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-cef.rrd N:0.00020098686218262 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-sla #### SQL[[1;33mSELECT * FROM `slas` WHERE `device_id` = ? AND `deleted` = 0 [0;33m[306][0m 0.8ms] >> Runtime for poller module 'cisco-sla': 0.0012 seconds with 4312 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-sla #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-sla.rrd N:0.0012099742889404 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-mac-accounting #### >> Runtime for poller module 'cisco-mac-accounting': 0.0002 seconds with 1112 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-mac-accounting #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-mac-accounting.rrd N:0.00023388862609863 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cipsec-tunnels #### >> Runtime for poller module 'cipsec-tunnels': 0.0002 seconds with 1728 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cipsec-tunnels #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cipsec-tunnels.rrd N:0.0001990795135498 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-ace-loadbalancer #### >> Runtime for poller module 'cisco-ace-loadbalancer': 0.0001 seconds with 968 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-ace-loadbalancer #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-ace-loadbalancer.rrd N:0.00011682510375977 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-ace-serverfarms #### >> Runtime for poller module 'cisco-ace-serverfarms': 0.0001 seconds with 936 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-ace-serverfarms #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-ace-serverfarms.rrd N:0.00011420249938965 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-asa-firewall #### >> Runtime for poller module 'cisco-asa-firewall': 0.0001 seconds with 648 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-asa-firewall #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-asa-firewall.rrd N:0.00010514259338379 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-voice #### >> Runtime for poller module 'cisco-voice': 0.0000 seconds with 336 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-voice #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-voice.rrd N:4.6968460083008E-5 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-cbqos #### >> Runtime for poller module 'cisco-cbqos': 0.0002 seconds with 1296 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-cbqos #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-cbqos.rrd N:0.00015091896057129 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-otv #### >> Runtime for poller module 'cisco-otv': 0.0003 seconds with 4336 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-otv #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-otv.rrd N:0.00027608871459961 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-vpdn #### >> Runtime for poller module 'cisco-vpdn': 0.0001 seconds with 520 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-vpdn #### RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-vpdn.rrd N:8.5115432739258E-5 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global+ OS Device #### Load poller module netscaler-vsvr #### >> Runtime for poller module 'netscaler-vsvr': 0.0002 seconds with 1560 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netscaler-vsvr #### RRD[[0;32mupdate 192.168.61.250/poller-perf-netscaler-vsvr.rrd N:0.00024604797363281 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module aruba-controller #### >> Runtime for poller module 'aruba-controller': 0.0003 seconds with 2616 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module aruba-controller #### RRD[[0;32mupdate 192.168.61.250/poller-perf-aruba-controller.rrd N:0.00025701522827148 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module entity-physical #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[306][0m 0.95ms] >> Runtime for poller module 'entity-physical': 0.0014 seconds with 1960 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module entity-physical #### RRD[[0;32mupdate 192.168.61.250/poller-perf-entity-physical.rrd N:0.0013549327850342 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module entity-state #### SQL[[1;33mSELECT S.entity_state_id, S.entStateLastChanged, P.entPhysicalIndex FROM entityState AS S LEFT JOIN entPhysical AS P USING (entPhysical_id) WHERE S.device_id=? [0;33m[306][0m 0.61ms] >> Runtime for poller module 'entity-state': 0.0010 seconds with 2224 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module entity-state #### RRD[[0;32mupdate 192.168.61.250/poller-perf-entity-state.rrd N:0.00095796585083008 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[306][0m 0.64ms] >> Runtime for poller module 'applications': 0.0009 seconds with 1472 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[[0;32mupdate 192.168.61.250/poller-perf-applications.rrd N:0.00086808204650879 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module mib #### SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[306,"poll_mib"][0m 0.25ms] MIB: polling SQL[[1;33mSELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [0;33m[306][0m 0.38ms] >> Runtime for poller module 'mib': 0.0010 seconds with 1232 bytes >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload poller module mib #### RRD[[0;32mupdate 192.168.61.250/poller-perf-mib.rrd N:0.0010049343109131 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[306][0m 0.43ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0177 seconds with 5624 bytes >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module stp #### RRD[[0;32mupdate 192.168.61.250/poller-perf-stp.rrd N:0.017656803131104 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ntp #### RRD[[0;32mupdate 192.168.61.250/poller-perf-ntp.rrd N:0.00011205673217773 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module loadbalancers #### >> Runtime for poller module 'loadbalancers': 0.0001 seconds with 240 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module loadbalancers #### RRD[[0;32mupdate 192.168.61.250/poller-perf-loadbalancers.rrd N:5.6982040405273E-5 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module mef #### MEF Links: SQL[[1;33mSELECT id, mefID, mefType, mefIdent, mefMTU, mefAdmState, mefRowState FROM mefinfo WHERE device_id = ? [0;33m[306][0m 0.53ms] >> Runtime for poller module 'mef': 0.0009 seconds with 2272 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module mef #### RRD[[0;32mupdate 192.168.61.250/poller-perf-mef.rrd N:0.00088691711425781 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module services #### Warning: include(includes/polling/services.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 303 Warning: include(): Failed opening 'includes/polling/services.inc.php' for inclusion (include_path='.:/usr/share/php') in /opt/librenms/includes/polling/functions.inc.php on line 303 >> Runtime for poller module 'services': 0.0001 seconds with 0 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module services #### RRD[[0;32mupdate 192.168.61.250/poller-perf-services.rrd N:5.793571472168E-5 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]### Start Device Groups ### SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.52ms] SQL[[1;33mSELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME LIKE "%\_id" [0;33m["ports"][0m 2.24ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,ports WHERE (( ports.device_id = devices.device_id )) && devices.device_id=? AND (devices.sysName REGEXP ".*adsl.*" || ports.portName REGEXP "adsl" ) LIMIT 1 [0;33m[306][0m 2.58ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysDescr REGEXP ".*BT FTTP.*" && devices.sysDescr REGEXP "BT FTTP" ) LIMIT 1 [0;33m[306][0m 5.02ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "IOS" && devices.hostname != "5.159.210.4" ) LIMIT 1 [0;33m[306][0m 1.76ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 1.34ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*E14 9YY.*") LIMIT 1 [0;33m[306][0m 0.91ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.67ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*UB4 0SL.*") LIMIT 1 [0;33m[306][0m 1.67ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.18ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*SL1 4UF.*") LIMIT 1 [0;33m[306][0m 1.39ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 3.12ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*EC1V 0AB.*") LIMIT 1 [0;33m[306][0m 2.24ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware REGEXP ".*iDRAC.*") LIMIT 1 [0;33m[306][0m 1.57ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname NOT REGEXP "^5.159.208..*" && devices.hostname NOT REGEXP "^5.159.209..*" && devices.hostname NOT REGEXP "^5.159.210..*" && devices.hostname NOT REGEXP "^5.159.211..*" && devices.hostname NOT REGEXP "^5.159.212..*" && devices.hostname NOT REGEXP "^10.1.51..*" && devices.hostname NOT REGEXP "^5.159.215..*" && devices.hostname NOT REGEXP "^195.88.8..*" && devices.hostname NOT REGEXP "^195.88.9..*" && devices.hostname NOT REGEXP "^217.156.156..*" && devices.hostname NOT REGEXP "^217.156.209..*" && devices.hostname NOT REGEXP "^192.168..*" ) LIMIT 1 [0;33m[306][0m 3.54ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "pfSense") LIMIT 1 [0;33m[306][0m 2.34ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.05ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*E14 9YY.*" || locations.location REGEXP ".*UB4 0SL.*" || locations.location REGEXP ".*SL1 4UF.*" ) LIMIT 1 [0;33m[306][0m 0.96ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hostname REGEXP ".*192.168.200..*") LIMIT 1 [0;33m[306][0m 2.9ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "IOS" && devices.hostname = "5.159.210.4" ) LIMIT 1 [0;33m[306][0m 2.42ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP ".*rico.*" || devices.sysDescr REGEXP ".*rico.*" ) LIMIT 1 [0;33m[306][0m 2.71ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.notes REGEXP ".*Umbee.*") LIMIT 1 [0;33m[306][0m 0.3ms] SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[306][0m 3.04ms] Groups Added: Groups Removed: ### End Device Groups ### Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[306][0m 23ms] uptime netstat_snmp netstat_snmp_pkt RRD[[0;32mupdate 192.168.61.250/ping-perf.rrd N:6.46 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]RRD[[0;32mupdate 192.168.61.250/poller-perf.rrd N:1.971 --daemon 127.0.0.1:42217[0m] [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[6873704,"6.46",1.971,306][0m 18.62ms] Updating 192.168.61.250 Polled in 1.971 seconds #### Start Alerts #### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[306][0m 1.71ms] 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[306][0m 0.58ms] SQL[[1;33mselect exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`start_recurring_dt` <= date_format(NOW(), '[1;33m-[0;35m-%d') and (`end_recurring_dt` >= date_format(NOW(), '[1;33m-[0;35m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '[0;37m'), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and 0 = 1))) as `exists` [0;33m[0,1,"0000-00-00","","","device",306,"device_group"][0m 0.66ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id LEFT JOIN alert_group_map g ON a.id=g.rule_id LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [0;33m[306,306][0m 0.38ms] 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[306][0m 0.64ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,306][0m 0.68ms] 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>= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[306][0m 1.57ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,306][0m 0.45ms] Status: [0;34mNOCHG[0m Rule [0;35m#7 (Sensor over 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.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.6ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,306][0m 0.36ms] 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.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.69ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,306][0m 0.31ms] Status: [0;34mNOCHG[0m Rule [0;35m#9 (Service up/down):[0m SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.51ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,306][0m 0.35ms] 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 [0;33m[306][0m 1.46ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,306][0m 0.35ms] Status: [0;34mNOCHG[0m Rule [0;35m#13 (Device up down):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.status = 1 [0;33m[306][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,306][0m 0.33ms] Status: [0;34mNOCHGSQL[[1;33mSELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ? && alert_log.rule_id = ? && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1 [0;33m[306,13][0m 0.47ms] SQL[[1;33mUPDATE `alert_log` set `details`=? WHERE id = ? [0;33m[0m 14.59ms] [0m Rule [0;35m#15 (BGP Session down all):[0m SQL[[1;33mSELECT * FROM devices,bgpPeers WHERE (devices.device_id = ? AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerState != "established" AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 1.09ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,306][0m 0.87ms] Status: [0;34mNOCHG[0m #### End Alerts #### SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"192.168.61.250","start":1554899632.8358,"duration":"2.317","devices":1,"poller":"UBUNTU-MONITOR"}[0m 71.21ms] ./poller.php 192.168.61.250 2019-04-10 13:33:55 - 1 devices polled in 2.317 secs SNMP [20/0.43s]: Get[11/0.14s] Getnext[0/0.00s] Walk[9/0.29s] MySQL [41/0.52s]: Cell[34/0.07s] Row[-31/-0.07s] Rows[33/0.10s] Column[1/0.00s] Update[2/0.03s] Insert[2/0.38s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]