- LibreNMS Poller
- SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.19ms]
- SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 2.52ms]
- SQL[[1;33mSELECT version() [0;33m[][0m 0.22ms]
- ===================================
- Version info:
- Commit SHA: db73b8fadecfdfee8ad27dcbc3cac01f995dddc6
- Commit Date: 1610320954
- DB Schema: 2020_11_02_164331_add_powerstate_enum_to_vminfo (191)
- PHP: 7.4.13
- MySQL: 10.3.27-MariaDB-0+deb10u1
- RRDTool: 1.7.1
- SNMP: NET-SNMP 5.7.3
- ==================================DEBUG!
- Updating os_def.cache
- Starting polling run:
- SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'proxmox-node-2.home.lan' ORDER BY `device_id` ASC [0;33m[][0m 0.59ms]
- SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[36][0m 0.38ms]
- SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[36][0m 0.18ms]
- Attempting to initialize OS: proxmox
- Attempting to initialize OS: unix
- OS initialized: LibreNMS\OS\Shared\Unix
- Hostname: proxmox-node-2.home.lan
- Device ID: 36
- OS: proxmox
- Resolved IP: 192.168.30.3
- (unix)
- SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["proxmox-node-2.home.lan"][0m 0.56ms]
- [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'proxmox-node-2.home.lan'
- response: {"xmt":3,"rcv":3,"loss":0,"min":0.5,"max":0.62,"avg":0.57,"dup":0,"exitcode":0}
- SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[36][0m 0.27ms]
- SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[4][0m 0.14ms]
- SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and 0 = 1) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-01-11T10:55:05.445798Z","2021-01-11T10:55:05.445798Z",0,1,"10:55:05","10:55:05","10:55:05","10:55:05","[41m%","device",36,"device_group","location",4][0m 0.61ms]
- SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":0.5,"max":0.62,"avg":0.57,"device_id":36,"debug":"[]"}[0m 0.93ms]
- SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-01-11 12:55:05",0.57,36][0m 0.79ms]
- 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' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
- .*.*.0 = 32710223
- .*.*.0 = Kristian Kirilov
- .*.*.0 = proxmox-node-2.home.lan
- .*.*.0 = .*.4.1.8*
- .*.*.0 = Linux proxmox-node-2.home.lan 5.4.78-2-pve #1 SMP PVE 5.4.78-2 (Thu, 03 Dec 2020 14:26:17 +0100) x86_64
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
- snmpEngineTime.0 = No Such Object available on this agent at this OID
- hrSystemUptime.0 = 32711102
- Uptime seconds: 327111
- Uptime: 3 days 18 hours 51 minutes 51 seconds
- >> Runtime for poller module 'core': 0.0251 seconds with 25608 bytes
- >> SNMP: [2/0.02s] MySQL: [0/0.00s]
- #### Unload poller module core ####
- Modules status: Global+
- OS
- Device
- #### Load poller module availability ####
- SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[36][0m 0.33ms]
- Availability:
- SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[36][0m 0.15ms]
- SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1610276105][0m 0.32ms]
- SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,41][0m 0.2ms]
- 1 day : 100%
- SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1609757705][0m 0.25ms]
- SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,42][0m 0.25ms]
- 7 days : 100%
- SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1607770505][0m 0.21ms]
- SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,43][0m 0.14ms]
- 30 days : 100%
- SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1578826505][0m 0.18ms]
- SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,44][0m 0.16ms]
- 365 days : 100%
- >> Runtime for poller module 'availability': 0.0045 seconds with 38432 bytes
- >> SNMP: [0/0.00s] MySQL: [5/0.00s]
- #### Unload poller module availability ####
- Modules status: Global-
- OS
- Device
- Module [ unix-agent ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module os ####
- Generic :(
- Location: (PVE) Sofia
- Hardware: Generic x86 64-bit
- OS Version: 5.4.78-2-pve
- OS Features:
- Serial:
- >> Runtime for poller module 'os': 0.0013 seconds with 91472 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module os ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ipmi ####
- SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[36][0m 0.25ms]
- array (
- )
- >> Runtime for poller module 'ipmi': 0.0005 seconds with 2872 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module ipmi ####
- Modules status: Global+
- OS
- Device
- #### Load poller module sensors ####
- SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[36][0m 0.21ms]
- >> Runtime for poller module 'sensors': 0.0004 seconds with 1584 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module sensors ####
- Modules status: Global+
- OS
- Device
- #### Load poller module processors ####
- Attempting to initialize OS: proxmox
- Attempting to initialize OS: unix
- OS initialized: LibreNMS\OS\Shared\Unix
- SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[36][0m 0.31ms]
- >> Runtime for poller module 'processors': 0.0012 seconds with 125976 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module processors ####
- Modules status: Global+
- OS
- Device
- #### Load poller module mempools ####
- SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[36][0m 0.31ms]
- >> Runtime for poller module 'mempools': 0.0011 seconds with 75864 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module mempools ####
- Modules status: Global+
- OS
- Device
- #### Load poller module storage ####
- SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[36][0m 0.21ms]
- >> Runtime for poller module 'storage': 0.0004 seconds with 2032 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module storage ####
- Modules status: Global+
- OS
- Device
- #### Load poller module netstats ####
- ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m]
- icmp = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID
- IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m]
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- mib-*.0 = 3:18:51:51.06
- IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' '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' 'udp:HOSTNAME:161' 'snmp'[0m]
- snmp = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID
- TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m]
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- mib-*.0 = 3:18:51:51.10
- TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
- mib-*.0 = 3:18:51:51.11
- mib-*.0 = 3:18:51:51.11
- UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m]
- mib-*.0 = 3:18:51:51.13
- mib-*.0 = 3:18:51:51.13
- mib-*.0 = 3:18:51:51.13
- mib-*.0 = 3:18:51:51.13
- >> Runtime for poller module 'netstats': 0.0946 seconds with 3824 bytes
- >> SNMP: [7/0.09s] MySQL: [0/0.00s]
- #### Unload poller module netstats ####
- 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' '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.0123 seconds with 1640 bytes
- >> SNMP: [1/0.01s] MySQL: [0/0.00s]
- #### Unload poller module hr-mib ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ucd-mib ####
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
- systemStats = No more variables left in this MIB View (It is past the end of the MIB tree)
- SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '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.0250 seconds with 2000 bytes
- >> SNMP: [2/0.02s] MySQL: [0/0.00s]
- #### Unload poller module ucd-mib ####
- 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' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
- ipSystemStatsTable = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID
- >> Runtime for poller module 'ipSystemStats': 0.0162 seconds with 1976 bytes
- >> SNMP: [1/0.02s] MySQL: [0/0.00s]
- #### Unload poller module ipSystemStats ####
- Modules status: Global+
- OS
- Device
- #### Load poller module ports ####
- SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[36][0m 0.62ms]
- Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
- ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree)
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
- ifEntry = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = 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' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
- dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
- dot1qPvid = No Such Object available on this agent at this OID
- Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID
- SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[36][0m 0.42ms]
- array (
- )
- Warning: max(): Array must contain at least one element in /opt/librenms/includes/polling/ports.inc.php on line 521
- SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1610362505,false,1610362505][0m 0.23ms]
- 0 updated
- >> Runtime for poller module 'ports': 0.0610 seconds with 34480 bytes
- >> SNMP: [4/0.06s] MySQL: [1/0.00s]
- #### Unload poller module ports ####
- Modules status: Global+
- OS
- Device
- #### Load poller module customoid ####
- SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[36][0m 0.23ms]
- >> Runtime for poller module 'customoid': 0.0005 seconds with 2488 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module customoid ####
- Modules status: Global+
- OS-
- Device
- Module [ bgp-peers ] disabled on os.
- 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[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[36][0m 0.14ms]
- >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1944 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module ucd-diskio ####
- Modules status: Global-
- OS
- Device
- Module [ wifi ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module wireless ####
- Attempting to initialize OS: proxmox
- Attempting to initialize OS: unix
- OS initialized: LibreNMS\OS\Shared\Unix
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[36][0m 0.23ms]
- >> Runtime for poller module 'wireless': 0.0013 seconds with 103008 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module wireless ####
- Modules status: Global+
- OS-
- Device
- Module [ ospf ] disabled on os.
- Modules status: Global-
- OS
- Device
- Module [ cisco-ipsec-flow-monitor ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-remote-access-monitor ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-cef ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-sla ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-mac-accounting ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cipsec-tunnels ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-ace-loadbalancer ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-ace-serverfarms ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-asa-firewall ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-voice ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-cbqos ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-otv ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-qfp ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ cisco-vpdn ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ nac ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ netscaler-vsvr ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ aruba-controller ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module entity-physical ####
- SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[36][0m 0.12ms]
- >> Runtime for poller module 'entity-physical': 0.0004 seconds with 2152 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module entity-physical ####
- Modules status: Global-
- OS
- Device
- Module [ entity-state ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module applications ####
- SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[36][0m 0.11ms]
- >> Runtime for poller module 'applications': 0.0002 seconds with 1592 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s]
- #### Unload poller module applications ####
- Modules status: Global-
- OS
- Device
- Module [ mib ] disabled globally.
- Modules status: Global+
- OS-
- Device
- Module [ stp ] disabled on os.
- Modules status: Global+
- OS
- Device
- #### Load poller module ntp ####
- >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module ntp ####
- Modules status: Global-
- OS
- Device
- Module [ loadbalancers ] disabled globally.
- Modules status: Global-
- OS
- Device
- Module [ mef ] disabled globally.
- Modules status: Global+
- OS
- Device
- #### Load poller module mpls ####
- >> Runtime for poller module 'mpls': 0.0002 seconds with 24080 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s]
- #### Unload poller module mpls ####
- Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[36][0m 0.18ms]
- SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[327111,0.57,1.305,36][0m 1.71ms]
- Updating proxmox-node-2.home.lan
- Polled in 1.305 seconds
- ### Start Device Groups ###
- SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[36][0m 0.38ms]
- SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.19ms]
- SQL[[1;33mselect * from `device_group_device` where `device_id` = ? [0;33m[36][0m 0.19ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups, runtime: 0.0014s ###
- #### Start Alerts ####
- SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and 0 = 1) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2021-01-11T10:55:05.721537Z","2021-01-11T10:55:05.721537Z",0,1,"10:55:05","10:55:05","10:55:05","10:55:05","[41m%","device",36,"device_group","location",4][0m 0.5ms]
- SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[36][0m 0.21ms]
- SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
- LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
- LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
- LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
- LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
- WHERE a.disabled = 0 AND (
- (d.device_id IS NULL AND g.group_id IS NULL)
- OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
- OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL))
- ) [0;33m[36,36,36,36,36,36,36,36][0m 1.03ms]
- 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[36][0m 0.32ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,36][0m 0.13ms]
- 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":"proxmox-node-2.home.lan","start":1610362504.0339,"duration":"1.691","devices":1,"poller":"\/"}[0m 0.82ms]
- ./poller.php proxmox-node-2.home.lan 2021-01-11 12:55:05 - 1 devices polled in 1.691 secs
- SNMP [18/0.24s]: Get[6/0.07s] Getnext[4/0.05s] Walk[8/0.11s]
- MySQL [22/0.01s]: Cell[3/0.00s] Row[-3/-0.00s] Rows[13/0.01s] Column[1/0.00s] Update[6/0.00s] Insert[2/0.00s] Delete[0/0.00s]