LibreNMS Poller =================================== Version info: Commit SHA: 7eb107acb961e2e67b648581ce0842728ab5f73c Commit Date: 1528326046 DB Schema: 251 PHP: 7.2.5 MySQL: 5.5.56-MariaDB RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! Updating os_def.cache... Done Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'snmp.meraki.com' ORDER BY `device_id` ASC] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '24'] Hostname: snmp.meraki.com Device ID: 24 OS: generic SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','37.8','37.9','37.8','24',NOW())] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0] .*.*.0 = 1369364400 .*.*.0 = 500 Terry A Francois Blvd, San Francisco, CA 94158, USA .*.*.0 = support@meraki.com .*.*.0 = dashboard.meraki.com .*.*.0 = .*.4.1.29671.1 .*.*.0 = Cisco Meraki Cloud Controller SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 snmpEngineTime.0 hrSystemUptime.0] 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: 13693644 RRD[update snmp.meraki.com/uptime.rrd N:13693644 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Uptime: 158 days, 11h 47m 24s SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='500 Terry A Francois Blvd, San Francisco, CA 94158, USA' LIMIT 1] Using cached lat/lng from other device >> Runtime for poller module 'core': 0.1735 seconds with 16840 bytes >> SNMP: [2/0.17s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module core #### RRD[update snmp.meraki.com/poller-perf-core.rrd N:0.17346000671387 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Hardware: Version: Features: Serial: >> Runtime for poller module 'os': 0.0002 seconds with 512 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module os #### RRD[update snmp.meraki.com/poller-perf-os.rrd N:0.00019311904907227 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = '24' AND poller_type='ipmi'] Array ( ) >> Runtime for poller module 'ipmi': 0.0005 seconds with 2360 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ipmi #### RRD[update snmp.meraki.com/poller-perf-ipmi.rrd N:0.00050878524780273 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '24' GROUP BY `sensor_class`] >> Runtime for poller module 'sensors': 0.0005 seconds with 1336 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module sensors #### RRD[update snmp.meraki.com/poller-perf-sensors.rrd N:0.00048494338989258 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM processors WHERE device_id='24'] >> Runtime for poller module 'processors': 0.0020 seconds with 100608 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module processors #### RRD[update snmp.meraki.com/poller-perf-processors.rrd N:0.0020442008972168 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module mempools #### SQL[SELECT * FROM mempools WHERE device_id = '24'] >> Runtime for poller module 'mempools': 0.0004 seconds with 1760 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module mempools #### RRD[update snmp.meraki.com/poller-perf-mempools.rrd N:0.00043392181396484 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = '24'] >> Runtime for poller module 'storage': 0.0004 seconds with 1824 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module storage #### RRD[update snmp.meraki.com/poller-perf-storage.rrd N:0.00042915344238281 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module netstats #### ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 icmp] icmp = No Such Object available on this agent at this OID IPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 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] ipForwDatagrams.0 = No Such Object available on this agent at this OID ipInDelivers.0 = No Such Object available on this agent at this OID ipInReceives.0 = No Such Object available on this agent at this OID ipOutRequests.0 = No Such Object available on this agent at this OID ipInDiscards.0 = No Such Object available on this agent at this OID ipOutDiscards.0 = No Such Object available on this agent at this OID ipOutNoRoutes.0 = No Such Object available on this agent at this OID ipReasmReqds.0 = No Such Object available on this agent at this OID ipReasmOKs.0 = No Such Object available on this agent at this OID ipReasmFails.0 = No Such Object available on this agent at this OID ipFragOKs.0 = No Such Object available on this agent at this OID ipFragFails.0 = No Such Object available on this agent at this OID ipFragCreates.0 = No Such Object available on this agent at this OID ipInUnknownProtos.0 = No Such Object available on this agent at this OID ipInHdrErrors.0 = No Such Object available on this agent at this OID ipInAddrErrors.0 = No Such Object available on this agent at this OID IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs udp:HOSTNAME:16100 IP-FORWARD-MIB::ipCidrRouteNumber.0] No Such Object available on this agent at this OID SNMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 snmp] snmp = No Such Object available on this agent at this OID TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 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] tcpActiveOpens.0 = No Such Object available on this agent at this OID tcpPassiveOpens.0 = No Such Object available on this agent at this OID tcpAttemptFails.0 = No Such Object available on this agent at this OID tcpEstabResets.0 = No Such Object available on this agent at this OID tcpCurrEstab.0 = No Such Object available on this agent at this OID tcpInSegs.0 = No Such Object available on this agent at this OID tcpOutSegs.0 = No Such Object available on this agent at this OID tcpRetransSegs.0 = No Such Object available on this agent at this OID tcpInErrs.0 = No Such Object available on this agent at this OID tcpOutRsts.0 = No Such Object available on this agent at this OID tcpHCInSegs.0 = No Such Object available on this agent at this OID tcpHCOutSegs.0 = No Such Object available on this agent at this OID UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0] udpInDatagrams.0 = No Such Object available on this agent at this OID udpOutDatagrams.0 = No Such Object available on this agent at this OID udpInErrors.0 = No Such Object available on this agent at this OID udpNoPorts.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'netstats': 0.6888 seconds with 3600 bytes >> SNMP: [6/0.69s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module netstats #### RRD[update snmp.meraki.com/poller-perf-netstats.rrd N:0.68881511688232 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 hrSystemProcesses.0 hrSystemNumUsers.0] 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.0908 seconds with 1584 bytes >> SNMP: [1/0.09s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module hr-mib #### RRD[update snmp.meraki.com/poller-perf-hr-mib.rrd N:0.09080982208252 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 systemStats] systemStats = No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0] 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[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 laLoadInt.1 laLoadInt.2 laLoadInt.3] 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.3319 seconds with 2760 bytes >> SNMP: [3/0.33s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-mib #### RRD[update snmp.meraki.com/poller-perf-ucd-mib.rrd N:0.33192014694214 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 ipSystemStats] ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.1645 seconds with 1920 bytes >> SNMP: [1/0.16s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ipSystemStats #### RRD[update snmp.meraki.com/poller-perf-ipSystemStats.rrd N:0.16453385353088 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ports #### Caching Oids: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 ifXEntry] ifXEntry = No Such Object available on this agent at this OID SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 ifEntry] ifEntry = No Such Object available on this agent at this OID dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 dot3StatsDuplexStatus] dot3StatsDuplexStatus = No Such Object available on this agent at this OID SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '24' AND `ifType` in ('adsl','vdsl')] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 dot1qPvid] dot1qPvid = No Such Object available on this agent at this OID Array ( ) SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1'] SQL[SELECT *, `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` = '24' ORDER BY ports.port_id] >> Runtime for poller module 'ports': 0.6620 seconds with 25216 bytes >> SNMP: [4/0.66s] MySQL: [3/0.00s] RRD: [0/0.00s] #### Unload poller module ports #### RRD[update snmp.meraki.com/poller-perf-ports.rrd N:0.66204404830933 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[SELECT * FROM bgpPeers WHERE device_id = '24'] >> Runtime for poller module 'bgp-peers': 0.0021 seconds with 10144 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module bgp-peers #### RRD[update snmp.meraki.com/poller-perf-bgp-peers.rrd N:0.0020971298217773 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ toner ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '24'] >> Runtime for poller module 'ucd-diskio': 0.0008 seconds with 1856 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module ucd-diskio #### RRD[update snmp.meraki.com/poller-perf-ucd-diskio.rrd N:0.00078701972961426 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = '24'] >> Runtime for poller module 'wireless': 0.0026 seconds with 98672 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module wireless #### RRD[update snmp.meraki.com/poller-perf-wireless.rrd N:0.0025589466094971 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ospf #### Processes: SQL[SELECT * FROM `ospf_instances` WHERE `device_id` = '24' AND `context_name` = ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfGeneralGroup] ospfGeneralGroup = No Such Object available on this agent at this OID Polled: Array ( ) Database: Areas: SQL[SELECT * FROM `ospf_areas` WHERE `device_id` = '24' AND `context_name`= ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfAreaEntry] ospfAreaEntry = No Such Object available on this agent at this OID Polled: Array ( ) Database: Ports: SQL[SELECT * FROM `ospf_ports` WHERE `device_id` = '24' AND `context_name` = ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfIfEntry] ospfIfEntry = No Such Object available on this agent at this OID Polled: Array ( ) Database: Neighbours: SQL[SELECT * FROM `ospf_nbrs` WHERE `device_id` = '24' AND `context_name` = ''] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 OSPF-MIB::ospfNbrEntry] ospfNbrEntry = No Such Object available on this agent at this OID Polled: Array ( ) Database: RRD[update snmp.meraki.com/ospf-statistics.rrd N:0:0:0:0 --daemon unix:/run/rrdcached.sock] [RRD Disabled] >> Runtime for poller module 'ospf': 0.6571 seconds with 6984 bytes >> SNMP: [4/0.65s] MySQL: [4/0.00s] RRD: [0/0.00s] #### Unload poller module ospf #### RRD[update snmp.meraki.com/poller-perf-ospf.rrd N:0.65705680847168 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ cisco-sla ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = '24'] >> Runtime for poller module 'entity-physical': 0.0012 seconds with 1944 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module entity-physical #### RRD[update snmp.meraki.com/poller-perf-entity-physical.rrd N:0.0012400150299072 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[SELECT * FROM `applications` WHERE `device_id` = '24'] >> Runtime for poller module 'applications': 0.0007 seconds with 1496 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module applications #### RRD[update snmp.meraki.com/poller-perf-applications.rrd N:0.00074291229248047 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS Device #### Load poller module stp #### SQL[SELECT * FROM `stp` WHERE `device_id` = '24'] SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs udp:HOSTNAME:16100 dot1dStpProtocolSpecification.0] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0926 seconds with 5672 bytes >> SNMP: [1/0.09s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload poller module stp #### RRD[update snmp.meraki.com/poller-perf-stp.rrd N:0.092577934265137 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0002 seconds with 320 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload poller module ntp #### RRD[update snmp.meraki.com/poller-perf-ntp.rrd N:0.00022602081298828 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global+ OS Device #### Load poller module services #### >> 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[update snmp.meraki.com/poller-perf-services.rrd N:8.0108642578125E-5 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. ### Start Device Groups ### SQL[SELECT * FROM device_groups ORDER BY name] SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='24' AND (devices.hostname REGEXP "fw0") LIMIT 1] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='24'] Groups Added: Groups Removed: ### End Device Groups ### SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '24'] uptime RRD[update snmp.meraki.com/ping-perf.rrd N:37.8 --daemon unix:/run/rrdcached.sock] [RRD Disabled]RRD[update snmp.meraki.com/poller-perf.rrd N:4.112 --daemon unix:/run/rrdcached.sock] [RRD Disabled]Polled in 4.112 seconds Updating snmp.meraki.com SQL[UPDATE `devices` set `uptime` ='13693644',`last_ping` =NOW(),`last_ping_timetaken` ='37.8',`last_polled` =NOW(),`last_polled_timetaken` ='4.112' WHERE `device_id` = '24'] UPDATED! #### Start Alerts #### SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='24'] SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '24' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1] SQL[SELECT 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='24' OR dg.device_id='24')] Rule #1 (Devices up/down): SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices WHERE (devices.device_id = '24') AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1] Status: NOCHG Rule #2 (Device rebooted): SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices WHERE (devices.device_id = '24') AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1] Status: NOCHG Rule #3 (BGP Session down): SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,bgpPeers WHERE (devices.device_id = '24' AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerState != "established" AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1] Status: NOCHG Rule #4 (BGP Session established): SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,bgpPeers WHERE (devices.device_id = '24' AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerFsmEstablishedTime < 300 AND bgpPeers.bgpPeerState = "established" AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1] Status: NOCHG Rule #8 (Sensor under limit - Check Device Health Settings): SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = '24' 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] Status: NOCHG Rule #9 (Service up/down): SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,services WHERE (devices.device_id = '24' AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1] Status: NOCHG Rule #12 (State Sensor Critical): SQL[SELECT state FROM alerts WHERE rule_id = '12' && device_id = '24' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = '24' 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] Status: NOCHG #### End Alerts #### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','snmp.meraki.com','1528400843.4421','4.264','1','nj1-off-net02')] /opt/librenms/poller.php snmp.meraki.com 2018-06-07 15:47:27 - 1 devices polled in 4.264 secs SNMP [23/3.00s]: Get[11/1.04s] Getnext[0/0.00s] Walk[12/1.96s] MySQL [49/0.03s]: Cell[6/0.00s] Row[9/0.00s] Rows[29/0.01s] Column[2/0.00s] Update[1/0.00s] Insert[2/0.01s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]