LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.41ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.27ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.78ms] =================================== 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.1 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.60.240' ORDER BY `device_id` ASC [0;33m[][0m 816.11ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[347][0m 0.23ms] Hostname: 192.168.60.240 Device ID: 347 OS: zyxel-vmg Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 249 (zyxel) [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.60.240 array ( 'xmt' => '3', 'rcv' => '3', 'loss' => '0', 'min' => '2.82', 'max' => '3.45', 'avg' => '3.05', '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":"2.82","max":"3.45","avg":"3.05","device_id":347,"debug":"[]"}[0m 11.17ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 1196161539 .*.*.0 = .*.*.0 = .*.*.0 = Storage Center 247360-SCV2080hayes-FYQZWM2 .*.*.0 = .*.4.1.8* .*.*.0 = FreeBSD sn247361.BLADES.QUBICGROUP.NET 10.0-RELEASE-p11 FreeBSD 10.0-RELEASE-p11 #0: Mon Jun 25 17:25:29 CDT 2018 root@es-vb100-1:/work/buildmaster/r07.02.51/R*/07_02_51_004/work/buildmaster/r07.02.51/R*/src/sys/COMPELLENT amd64 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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: 11961615 RRD[[0;32mupdate 192.168.60.240/uptime.rrd N:11961615 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Uptime: 138 days, 10h 40m 15s SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[250][0m 2.12ms] >> Runtime for poller module 'core': 0.0302 seconds with 506376 bytes >> SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module core #### RRD[[0;32mupdate 192.168.60.240/poller-perf-core.rrd N:0.030232906341553 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module unix-agent #### >> Runtime for poller module 'unix-agent': 0.0004 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.60.240/poller-perf-unix-agent.rrd N:0.00040197372436523 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module os #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnt' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.890.1.15.3.1.11.0' '.1.3.6.1.4.1.890.1.15.3.1.6.0' '.1.3.6.1.4.1.890.1.15.3.1.12.0'[0m] .*.4.1.8*.1.11.0 = No Such Object available on this agent at this OID .*.4.1.8*.1.6.0 = No Such Object available on this agent at this OID .*.4.1.8*.1.12.0 = No Such Object available on this agent at this OID Hardware: Version: Features: Serial: >> Runtime for poller module 'os': 0.0082 seconds with 2480 bytes >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module os #### RRD[[0;32mupdate 192.168.60.240/poller-perf-os.rrd N:0.008202075958252 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.87ms] 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.60.240/poller-perf-ipmi.rrd N:0.0014081001281738 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.44ms] >> Runtime for poller module 'sensors': 0.0009 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.60.240/poller-perf-sensors.rrd N:0.00086092948913574 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: zyxel-vmg Attempting to initialize OS: zyxel OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[347][0m 0.99ms] >> Runtime for poller module 'processors': 0.0033 seconds with 91448 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module processors #### RRD[[0;32mupdate 192.168.60.240/poller-perf-processors.rrd N:0.0032908916473389 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[347][0m 0.42ms] >> Runtime for poller module 'mempools': 0.0008 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.60.240/poller-perf-mempools.rrd N:0.00081300735473633 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[347][0m 0.39ms] >> Runtime for poller module 'storage': 0.0007 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.60.240/poller-perf-storage.rrd N:0.00071191787719727 --daemon unix:/var/run/rrdcached.sock[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:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'icmp'[0m] icmpInMsgs.0 = 98777 icmpInErrors.0 = 128 icmpInDestUnreachs.0 = 34 icmpInTimeExcds.0 = 0 icmpInParmProbs.0 = 0 icmpInSrcQuenchs.0 = 0 icmpInRedirects.0 = 0 icmpInEchos.0 = 98614 icmpInEchoReps.0 = 0 icmpInTimestamps.0 = 0 icmpInTimestampReps.0 = 0 icmpInAddrMasks.0 = 0 icmpInAddrMaskReps.0 = 0 icmpOutMsgs.0 = 139052 icmpOutErrors.0 = 0 icmpOutDestUnreachs.0 = 40439 icmpOutTimeExcds.0 = 0 icmpOutParmProbs.0 = 0 icmpOutSrcQuenchs.0 = 0 icmpOutRedirects.0 = 0 icmpOutEchos.0 = 0 icmpOutEchoReps.0 = 98613 icmpOutTimestamps.0 = 0 icmpOutTimestampReps.0 = 0 icmpOutAddrMasks.0 = 0 icmpOutAddrMaskReps.0 = 0 RRD[[0;32mupdate 192.168.60.240/netstats-icmp.rrd N:98777:139052:128:0:98614:0:0:98613:34:40439:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m] IPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmp'[0m] snmp = No Such Object available on this agent at this OID TCPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-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.0866 seconds with 2976 bytes >> SNMP: [6/0.08s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netstats #### RRD[[0;32mupdate 192.168.60.240/poller-perf-netstats.rrd N:0.086579084396362 --daemon unix:/var/run/rrdcached.sock[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:/opt/librenms/mibs/zyxel' '-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.0165 seconds with 1472 bytes >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module hr-mib #### RRD[[0;32mupdate 192.168.60.240/poller-perf-hr-mib.rrd N:0.016503095626831 --daemon unix:/var/run/rrdcached.sock[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:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-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.0391 seconds with 2496 bytes >> SNMP: [3/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-mib #### RRD[[0;32mupdate 192.168.60.240/poller-perf-ucd-mib.rrd N:0.039093971252441 --daemon unix:/var/run/rrdcached.sock[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:/opt/librenms/mibs/zyxel' '-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.0312 seconds with 1872 bytes >> SNMP: [1/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ipSystemStats #### RRD[[0;32mupdate 192.168.60.240/poller-perf-ipSystemStats.rrd N:0.031224966049194 --daemon unix:/var/run/rrdcached.sock[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[347][0m 8.3ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.3 = 3 ifIndex.4 = 4 ifDescr.1 = eth1 ifDescr.2 = pf0 ifDescr.3 = lo0 ifDescr.4 = eth0 ifType.1 = ethernetCsmacd ifType.2 = ethernetCsmacd ifType.3 = softwareLoopback ifType.4 = ethernetCsmacd ifMtu.1 = 16384 ifMtu.2 = 9000 ifMtu.3 = 16384 ifMtu.4 = 1500 ifSpeed.1 = 10000000 ifSpeed.2 = 1410065408 ifSpeed.3 = 0 ifSpeed.4 = 1000000000 ifPhysAddress.1 = 0:0:0:1:0:0 ifPhysAddress.2 = 0:50:cc:7f:22:80 ifPhysAddress.3 = ifPhysAddress.4 = 0:50:cc:7f:22:80 ifAdminStatus.1 = up ifAdminStatus.2 = down ifAdminStatus.3 = up ifAdminStatus.4 = up ifOperStatus.1 = up ifOperStatus.2 = down ifOperStatus.3 = up ifOperStatus.4 = up ifLastChange.1 = 52577 ifLastChange.2 = 0 ifLastChange.3 = 0 ifLastChange.4 = 3772089 ifInOctets.1 = 4182532641 ifInOctets.2 = 1085150169 ifInOctets.3 = 1155845277 ifInOctets.4 = 2904944618 ifInUcastPkts.1 = 3 ifInUcastPkts.2 = 618793806 ifInUcastPkts.3 = 15716988 ifInUcastPkts.4 = 618793835 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 0 ifInNUcastPkts.3 = 0 ifInNUcastPkts.4 = 0 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 0 ifInDiscards.4 = 0 ifInErrors.1 = 0 ifInErrors.2 = 21244 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifInUnknownProtos.3 = 0 ifInUnknownProtos.4 = 0 ifOutOctets.1 = 1445518151 ifOutOctets.2 = 1088987960 ifOutOctets.3 = 1155845264 ifOutOctets.4 = 898134408 ifOutUcastPkts.1 = 0 ifOutUcastPkts.2 = 32185225 ifOutUcastPkts.3 = 15716987 ifOutUcastPkts.4 = 31838084 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 0 ifOutNUcastPkts.3 = 0 ifOutNUcastPkts.4 = 0 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifOutQLen.3 = 0 ifOutQLen.4 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero ifSpecific.3 = zeroDotZero ifSpecific.4 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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:/opt/librenms/mibs/zyxel' '-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[347][0m 0.88ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'eth1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '16384', 'ifSpeed' => '10000000', 'ifPhysAddress' => '0:0:0:1:0:0', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '52577', 'ifInOctets' => '4182532641', 'ifInUcastPkts' => '3', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1445518151', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'pf0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '9000', 'ifSpeed' => '1410065408', 'ifPhysAddress' => '0:50:cc:7f:22:80', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '1085150169', 'ifInUcastPkts' => '618793806', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '21244', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1088987960', 'ifOutUcastPkts' => '32185225', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 3 => array ( 'ifIndex' => '3', 'ifDescr' => 'lo0', 'ifType' => 'softwareLoopback', 'ifMtu' => '16384', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '1155845277', 'ifInUcastPkts' => '15716988', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1155845264', 'ifOutUcastPkts' => '15716987', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 4 => array ( 'ifIndex' => '4', 'ifDescr' => 'eth0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '1000000000', 'ifPhysAddress' => '0:50:cc:7f:22:80', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '3772089', 'ifInOctets' => '2904944618', 'ifInUcastPkts' => '618793835', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '898134408', 'ifOutUcastPkts' => '31838084', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid valid valid Port eth1: eth1 (1 / #269398) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName eth1 ifInOctets (2131639 B) 7129.2274247492 Bps 299 secs ifOutOctets (2250218 B) 7525.8127090301 Bps 299 secs ifInErrors (0 B) 0 Bps 299 secs ifOutErrors (0 B) 0 Bps 299 secs ifInUcastPkts (0 B) 0 Bps 299 secs ifOutUcastPkts (0 B) 0 Bps 299 secs ifInNUcastPkts (0 B) 0 Bps 299 secs ifOutNUcastPkts (0 B) 0 Bps 299 secs ifInDiscards (0 B) 0 Bps 299 secs ifOutDiscards (0 B) 0 Bps 299 secs ifInUnknownProtos (0 B) 0 Bps 299 secs ifInBroadcastPkts (0 B) 0 Bps 299 secs ifOutBroadcastPkts (0 B) 0 Bps 299 secs ifInMulticastPkts (0 B) 0 Bps 299 secs ifOutMulticastPkts (0 B) 0 Bps 299 secs bps(57.03 kbps/60.21 kbps)bytes(2.03 MB/2.15 MB)pkts(0 pps/0 pps)RRD[[0;32mupdate 192.168.60.240/port-id269398.rrd N:4182532641:1445518151:0:0:3:0:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1550744737,1550744438,299,"52577","4182532641",4180401002,7129.2274247492,2131639,"1445518151",1443267933,7525.8127090301,2250218,"0",0,0,0,"0",0,0,0,"3",3,0,0,"0",0,0,0,269398][0m 9.26ms] 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,269398][0m 11ms] 1 updated Port pf0: pf0 (2 / #269399) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName pf0 ifInOctets (2655644 B) 8881.7525083612 Bps 299 secs ifOutOctets (165672 B) 554.08695652174 Bps 299 secs ifInErrors (0 B) 0 Bps 299 secs ifOutErrors (0 B) 0 Bps 299 secs ifInUcastPkts (18072 B) 60.441471571906 Bps 299 secs ifOutUcastPkts (896 B) 2.9966555183946 Bps 299 secs ifInNUcastPkts (0 B) 0 Bps 299 secs ifOutNUcastPkts (0 B) 0 Bps 299 secs ifInDiscards (0 B) 0 Bps 299 secs ifOutDiscards (0 B) 0 Bps 299 secs ifInUnknownProtos (0 B) 0 Bps 299 secs ifInBroadcastPkts (0 B) 0 Bps 299 secs ifOutBroadcastPkts (0 B) 0 Bps 299 secs ifInMulticastPkts (0 B) 0 Bps 299 secs ifOutMulticastPkts (0 B) 0 Bps 299 secs bps(71.05 kbps/4.43 kbps)bytes(2.53 MB/161.79 kB)pkts(60.44 pps/3 pps)RRD[[0;32mupdate 192.168.60.240/port-id269399.rrd N:1085150169:1088987960:21244:0:618793806:32185225:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1550744737,1550744438,299,"0","1085150169",1082494525,8881.7525083612,2655644,"1088987960",1088822288,554.08695652174,165672,"21244",21244,0,0,"0",0,0,0,"618793806",618775734,60.441471571906,18072,"32185225",32184329,2.9966555183946,896,269399][0m 12.34ms] 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,269399][0m 10.95ms] 1 updated Port lo0: lo0 (3 / #269400) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName lo0 ifInOctets (24775 B) 82.859531772575 Bps 299 secs ifOutOctets (24775 B) 82.859531772575 Bps 299 secs ifInErrors (0 B) 0 Bps 299 secs ifOutErrors (0 B) 0 Bps 299 secs ifInUcastPkts (338 B) 1.1304347826087 Bps 299 secs ifOutUcastPkts (338 B) 1.1304347826087 Bps 299 secs ifInNUcastPkts (0 B) 0 Bps 299 secs ifOutNUcastPkts (0 B) 0 Bps 299 secs ifInDiscards (0 B) 0 Bps 299 secs ifOutDiscards (0 B) 0 Bps 299 secs ifInUnknownProtos (0 B) 0 Bps 299 secs ifInBroadcastPkts (0 B) 0 Bps 299 secs ifOutBroadcastPkts (0 B) 0 Bps 299 secs ifInMulticastPkts (0 B) 0 Bps 299 secs ifOutMulticastPkts (0 B) 0 Bps 299 secs bps(663 bps/663 bps)bytes(24.19 kB/24.19 kB)pkts(1.13 pps/1.13 pps)RRD[[0;32mupdate 192.168.60.240/port-id269400.rrd N:1155845277:1155845264:0:0:15716988:15716987:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1550744737,1550744438,299,"0","1155845277",1155820502,82.859531772575,24775,"1155845264",1155820489,82.859531772575,24775,"0",0,0,0,"0",0,0,0,"15716988",15716650,1.1304347826087,338,"15716987",15716649,1.1304347826087,338,269400][0m 54.37ms] 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,269400][0m 45.48ms] 1 updated Port eth0: eth0 (4 / #269401) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed VLAN = Using ifDescr as ifAlias Using ifDescr as ifName eth0 ifInOctets (2582620 B) 8637.525083612 Bps 299 secs ifOutOctets (156953 B) 524.92642140468 Bps 299 secs ifInErrors (0 B) 0 Bps 299 secs ifOutErrors (0 B) 0 Bps 299 secs ifInUcastPkts (18066 B) 60.421404682274 Bps 299 secs ifOutUcastPkts (873 B) 2.9197324414716 Bps 299 secs ifInNUcastPkts (0 B) 0 Bps 299 secs ifOutNUcastPkts (0 B) 0 Bps 299 secs ifInDiscards (0 B) 0 Bps 299 secs ifOutDiscards (0 B) 0 Bps 299 secs ifInUnknownProtos (0 B) 0 Bps 299 secs ifInBroadcastPkts (0 B) 0 Bps 299 secs ifOutBroadcastPkts (0 B) 0 Bps 299 secs ifInMulticastPkts (0 B) 0 Bps 299 secs ifOutMulticastPkts (0 B) 0 Bps 299 secs bps(69.1 kbps/4.2 kbps)bytes(2.46 MB/153.27 kB)pkts(60.42 pps/2.92 pps)RRD[[0;32mupdate 192.168.60.240/port-id269401.rrd N:2904944618:898134408:0:0:618793835:31838084:0:0:0:0:0:U:U:U:U --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1550744737,1550744438,299,"3772089","2904944618",2902361998,8637.525083612,2582620,"898134408",897977455,524.92642140468,156953,"0",0,0,0,"0",0,0,0,"618793835",618775769,60.421404682274,18066,"31838084",31837211,2.9197324414716,873,269401][0m 161.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,"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,269401][0m 22.96ms] 1 updated >> Runtime for poller module 'ports': 0.4641 seconds with 37544 bytes >> SNMP: [4/0.11s] MySQL: [9/0.34s] RRD: [0/0.00s] #### Unload poller module ports #### RRD[[0;32mupdate 192.168.60.240/poller-perf-ports.rrd N:0.4641170501709 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.54ms] >> Runtime for poller module 'bgp-peers': 0.0017 seconds with 11256 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module bgp-peers #### RRD[[0;32mupdate 192.168.60.240/poller-perf-bgp-peers.rrd N:0.0017108917236328 --daemon unix:/var/run/rrdcached.sock[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[347][0m 1.13ms] >> Runtime for poller module 'junose-atm-vp': 0.0015 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.60.240/poller-perf-junose-atm-vp.rrd N:0.0014979839324951 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.24ms] >> Runtime for poller module 'ucd-diskio': 0.0005 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.60.240/poller-perf-ucd-diskio.rrd N:0.00052499771118164 --daemon unix:/var/run/rrdcached.sock[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: zyxel-vmg Attempting to initialize OS: zyxel OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[347][0m 1.03ms] >> Runtime for poller module 'wireless': 0.0025 seconds with 167872 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module wireless #### RRD[[0;32mupdate 192.168.60.240/poller-perf-wireless.rrd N:0.0025148391723633 --daemon unix:/var/run/rrdcached.sock[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[347][0m 17.93ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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[347][0m 0.46ms] 0 >> Runtime for poller module 'ospf': 0.0432 seconds with 161120 bytes >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ospf #### RRD[[0;32mupdate 192.168.60.240/poller-perf-ospf.rrd N:0.043230056762695 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-cisco-ipsec-flow-monitor.rrd N:0.00024986267089844 --daemon unix:/var/run/rrdcached.sock[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.0002 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.60.240/poller-perf-cisco-remote-access-monitor.rrd N:0.00018310546875 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-cef #### >> Runtime for poller module 'cisco-cef': 0.0004 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.60.240/poller-perf-cisco-cef.rrd N:0.00035786628723145 --daemon unix:/var/run/rrdcached.sock[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[347][0m 1.35ms] >> Runtime for poller module 'cisco-sla': 0.0018 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.60.240/poller-perf-cisco-sla.rrd N:0.0017869472503662 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-mac-accounting #### >> Runtime for poller module 'cisco-mac-accounting': 0.0004 seconds with 1064 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-mac-accounting #### RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-mac-accounting.rrd N:0.00036191940307617 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cipsec-tunnels #### >> Runtime for poller module 'cipsec-tunnels': 0.0003 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.60.240/poller-perf-cipsec-tunnels.rrd N:0.00029516220092773 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-ace-loadbalancer #### >> Runtime for poller module 'cisco-ace-loadbalancer': 0.0002 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.60.240/poller-perf-cisco-ace-loadbalancer.rrd N:0.00019216537475586 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-ace-serverfarms #### >> Runtime for poller module 'cisco-ace-serverfarms': 0.0004 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.60.240/poller-perf-cisco-ace-serverfarms.rrd N:0.0003809928894043 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-asa-firewall #### >> Runtime for poller module 'cisco-asa-firewall': 0.0025 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.60.240/poller-perf-cisco-asa-firewall.rrd N:0.0025429725646973 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module cisco-voice #### >> Runtime for poller module 'cisco-voice': 0.0001 seconds with 288 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module cisco-voice #### RRD[[0;32mupdate 192.168.60.240/poller-perf-cisco-voice.rrd N:8.0108642578125E-5 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-cisco-cbqos.rrd N:0.0002140998840332 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-cisco-otv.rrd N:0.00031709671020508 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-cisco-vpdn.rrd N:0.00012612342834473 --daemon unix:/var/run/rrdcached.sock[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.0003 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.60.240/poller-perf-netscaler-vsvr.rrd N:0.00032687187194824 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module aruba-controller #### >> Runtime for poller module 'aruba-controller': 0.0007 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.60.240/poller-perf-aruba-controller.rrd N:0.0007169246673584 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.37ms] >> Runtime for poller module 'entity-physical': 0.0008 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.60.240/poller-perf-entity-physical.rrd N:0.00084710121154785 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.47ms] >> Runtime for poller module 'entity-state': 0.0009 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.60.240/poller-perf-entity-state.rrd N:0.00086402893066406 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[347][0m 6.37ms] >> Runtime for poller module 'applications': 0.0068 seconds with 1472 bytes >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[[0;32mupdate 192.168.60.240/poller-perf-applications.rrd N:0.00677490234375 --daemon unix:/var/run/rrdcached.sock[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[347,"poll_mib"][0m 6.69ms] MIB: polling SQL[[1;33mSELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [0;33m[347][0m 0.34ms] >> Runtime for poller module 'mib': 0.0078 seconds with 1232 bytes >> SNMP: [0/0.00s] MySQL: [2/0.01s] RRD: [0/0.00s] #### Unload poller module mib #### RRD[[0;32mupdate 192.168.60.240/poller-perf-mib.rrd N:0.0077519416809082 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[347][0m 8.49ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/zyxel' '-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.0225 seconds with 5624 bytes >> SNMP: [1/0.01s] MySQL: [1/0.01s] RRD: [0/0.00s] #### Unload poller module stp #### RRD[[0;32mupdate 192.168.60.240/poller-perf-stp.rrd N:0.022543907165527 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-ntp.rrd N:0.0001218318939209 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-loadbalancers.rrd N:5.2928924560547E-5 --daemon unix:/var/run/rrdcached.sock[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[347][0m 0.86ms] >> Runtime for poller module 'mef': 0.0013 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.60.240/poller-perf-mef.rrd N:0.0012760162353516 --daemon unix:/var/run/rrdcached.sock[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.60.240/poller-perf-services.rrd N:5.2928924560547E-5 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]### Start Device Groups ### SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.32ms] SQL[[1;33mSELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME LIKE "%\_id" [0;33m["ports"][0m 1.42ms] 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[347][0m 1.44ms] 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[347][0m 0.44ms] 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[347][0m 0.37ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 3.5ms] 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[347][0m 0.4ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 1.41ms] 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[347][0m 0.33ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 0.97ms] 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[347][0m 0.37ms] SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.96ms] 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[347][0m 6.13ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.hardware REGEXP ".*iDRAC.*") LIMIT 1 [0;33m[347][0m 0.54ms] 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[347][0m 0.71ms] SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "pfSense") LIMIT 1 [0;33m[347][0m 0.46ms] 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[347][0m 0.39ms] 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[347][0m 0.38ms] SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[347][0m 0.28ms] Groups Added: Groups Removed: ### End Device Groups ### Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[347][0m 0.26ms] uptime netstat_icmp netstat_icmp_info RRD[[0;32mupdate 192.168.60.240/ping-perf.rrd N:3.05 --daemon unix:/var/run/rrdcached.sock[0m] [[0;31mRRD Disabled[0m]RRD[[0;32mupdate 192.168.60.240/poller-perf.rrd N:1.874 --daemon unix:/var/run/rrdcached.sock[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[11961615,"3.05",1.874,347][0m 15.53ms] Updating 192.168.60.240 Polled in 1.874 seconds #### Start Alerts #### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[347][0m 0.73ms] 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[347][0m 0.39ms] 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 `alert_schedulable_id` in (?)))) as `exists` [0;33m[0,1,"0000-00-00","","","device",347,"device_group",12][0m 1.45ms] 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[347,347][0m 0.47ms] 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[347][0m 0.64ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,347][0m 0.53ms] 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[347][0m 1.11ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,347][0m 0.38ms] 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[347][0m 0.81ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,347][0m 0.43ms] 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[347][0m 0.81ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,347][0m 0.36ms] 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[347][0m 0.76ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,347][0m 0.38ms] 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[347][0m 0.97ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,347][0m 0.38ms] 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[347][0m 0.62ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,347][0m 0.36ms] 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[347,13][0m 0.55ms] SQL[[1;33mUPDATE `alert_log` set `details`=? WHERE id = ? [0;33m[0m 9.46ms] [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[347][0m 0.67ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,347][0m 0.36ms] 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.60.240","start":1550744734.9573,"duration":"3.077","devices":1,"poller":"UBUNTU-MONITOR"}[0m 11.82ms] ./poller.php 192.168.60.240 2019-02-21 10:25:38 - 1 devices polled in 3.077 secs SNMP [21/0.36s]: Get[12/0.14s] Getnext[0/0.00s] Walk[9/0.22s] MySQL [49/1.26s]: Cell[30/0.04s] Row[-27/-0.02s] Rows[33/0.86s] Column[1/0.00s] Update[10/0.36s] Insert[2/0.02s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]