From KpuCko, 3 Years ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.19ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 2.52ms]
  5.  
  6. SQL[[1;33mSELECT version() [0;33m[][0m 0.22ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: db73b8fadecfdfee8ad27dcbc3cac01f995dddc6
  11. Commit Date: 1610320954
  12. DB Schema: 2020_11_02_164331_add_powerstate_enum_to_vminfo (191)
  13. PHP: 7.4.13
  14. MySQL: 10.3.27-MariaDB-0+deb10u1
  15. RRDTool: 1.7.1
  16. SNMP: NET-SNMP 5.7.3
  17. ==================================DEBUG!
  18. Updating os_def.cache  
  19. Starting polling run:
  20.  
  21. 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]
  22.  
  23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[36][0m 0.38ms]
  24.  
  25. 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]
  26.  
  27. Attempting to initialize OS: proxmox  
  28. Attempting to initialize OS: unix  
  29. OS initialized: LibreNMS\OS\Shared\Unix  
  30. Hostname:    proxmox-node-2.home.lan
  31. Device ID:   36
  32. OS:          proxmox
  33. Resolved IP: 192.168.30.3
  34.  (unix)
  35.  
  36. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["proxmox-node-2.home.lan"][0m 0.56ms]
  37.  
  38. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'proxmox-node-2.home.lan'
  39.  
  40. response:  {"xmt":3,"rcv":3,"loss":0,"min":0.5,"max":0.62,"avg":0.57,"dup":0,"exitcode":0}
  41. 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]
  42.  
  43. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[4][0m 0.14ms]
  44.  
  45. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) &lt;= ? 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]
  46.  
  47. 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]
  48.  
  49. 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]
  50.  
  51. SNMP Check response code: 0  
  52. Modules status: Global+  
  53. OS  
  54. Device  
  55.  
  56. #### Load poller module core ####
  57. 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]
  58. .*.*.0 = 32710223
  59. .*.*.0 = Kristian Kirilov
  60. .*.*.0 = proxmox-node-2.home.lan
  61. .*.*.0 = .*.4.1.8*
  62. .*.*.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  
  63.  
  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]
  65. snmpEngineTime.0 = No Such Object available on this agent at this OID
  66. hrSystemUptime.0 = 32711102  
  67.  
  68. Uptime seconds: 327111  
  69. Uptime:  3 days 18 hours 51 minutes 51 seconds
  70.  
  71. >> Runtime for poller module 'core': 0.0251 seconds with 25608 bytes
  72. >> SNMP: [2/0.02s] MySQL: [0/0.00s]
  73. #### Unload poller module core ####
  74.  
  75. Modules status: Global+  
  76. OS  
  77. Device  
  78.  
  79. #### Load poller module availability ####
  80. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[36][0m 0.33ms]
  81.  
  82. Availability:
  83. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[36][0m 0.15ms]
  84.  
  85. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1610276105][0m 0.32ms]
  86.  
  87. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,41][0m 0.2ms]
  88.  
  89. 1 day : 100%
  90. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1609757705][0m 0.25ms]
  91.  
  92. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,42][0m 0.25ms]
  93.  
  94. 7 days : 100%
  95. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[36,1607770505][0m 0.21ms]
  96.  
  97. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,43][0m 0.14ms]
  98.  
  99. 30 days : 100%
  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]
  101.  
  102. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,44][0m 0.16ms]
  103.  
  104. 365 days : 100%
  105.  
  106. >> Runtime for poller module 'availability': 0.0045 seconds with 38432 bytes
  107. >> SNMP: [0/0.00s] MySQL: [5/0.00s]
  108. #### Unload poller module availability ####
  109.  
  110. Modules status: Global-  
  111. OS  
  112. Device  
  113. Module [ unix-agent ] disabled globally.
  114.  
  115. Modules status: Global+  
  116. OS  
  117. Device  
  118.  
  119. #### Load poller module os ####
  120. Generic :(
  121. Location: (PVE) Sofia
  122. Hardware: Generic x86 64-bit
  123. OS Version: 5.4.78-2-pve
  124. OS Features:
  125. Serial:
  126.  
  127. >> Runtime for poller module 'os': 0.0013 seconds with 91472 bytes
  128. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  129. #### Unload poller module os ####
  130.  
  131. Modules status: Global+  
  132. OS  
  133. Device  
  134.  
  135. #### Load poller module ipmi ####
  136. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[36][0m 0.25ms]
  137.  
  138. array (
  139. )  
  140.  
  141. >> Runtime for poller module 'ipmi': 0.0005 seconds with 2872 bytes
  142. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  143. #### Unload poller module ipmi ####
  144.  
  145. Modules status: Global+  
  146. OS  
  147. Device  
  148.  
  149. #### Load poller module sensors ####
  150. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[36][0m 0.21ms]
  151.  
  152.  
  153. >> Runtime for poller module 'sensors': 0.0004 seconds with 1584 bytes
  154. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  155. #### Unload poller module sensors ####
  156.  
  157. Modules status: Global+  
  158. OS  
  159. Device  
  160.  
  161. #### Load poller module processors ####
  162. Attempting to initialize OS: proxmox  
  163. Attempting to initialize OS: unix  
  164. OS initialized: LibreNMS\OS\Shared\Unix  
  165. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[36][0m 0.31ms]
  166.  
  167.  
  168. >> Runtime for poller module 'processors': 0.0012 seconds with 125976 bytes
  169. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  170. #### Unload poller module processors ####
  171.  
  172. Modules status: Global+  
  173. OS  
  174. Device  
  175.  
  176. #### Load poller module mempools ####
  177. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[36][0m 0.31ms]
  178.  
  179.  
  180. >> Runtime for poller module 'mempools': 0.0011 seconds with 75864 bytes
  181. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  182. #### Unload poller module mempools ####
  183.  
  184. Modules status: Global+  
  185. OS  
  186. Device  
  187.  
  188. #### Load poller module storage ####
  189. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[36][0m 0.21ms]
  190.  
  191.  
  192. >> Runtime for poller module 'storage': 0.0004 seconds with 2032 bytes
  193. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  194. #### Unload poller module storage ####
  195.  
  196. Modules status: Global+  
  197. OS  
  198. Device  
  199.  
  200. #### Load poller module netstats ####
  201.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp'[0m]
  202. icmp = No Such Object available on this agent at this OID  
  203.  
  204. Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID  
  205.  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]
  206. mib-*.0 = 3:18:51:51.06
  207. mib-*.0 = 3:18:51:51.06
  208. mib-*.0 = 3:18:51:51.06
  209. mib-*.0 = 3:18:51:51.06
  210. mib-*.0 = 3:18:51:51.06
  211. mib-*.0 = 3:18:51:51.06
  212. mib-*.0 = 3:18:51:51.06
  213. mib-*.0 = 3:18:51:51.06
  214. mib-*.0 = 3:18:51:51.06
  215. mib-*.0 = 3:18:51:51.06
  216. mib-*.0 = 3:18:51:51.06
  217. mib-*.0 = 3:18:51:51.06
  218. mib-*.0 = 3:18:51:51.06
  219. mib-*.0 = 3:18:51:51.06
  220. mib-*.0 = 3:18:51:51.06
  221. mib-*.0 = 3:18:51:51.06  
  222.  
  223.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  224. No Such Object available on this agent at this OID  
  225.  
  226.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp'[0m]
  227. snmp = No Such Object available on this agent at this OID  
  228.  
  229. Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID  
  230.  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]
  231. mib-*.0 = 3:18:51:51.10
  232. mib-*.0 = 3:18:51:51.10
  233. mib-*.0 = 3:18:51:51.10
  234. mib-*.0 = 3:18:51:51.10
  235. mib-*.0 = 3:18:51:51.10
  236. mib-*.0 = 3:18:51:51.10
  237. mib-*.0 = 3:18:51:51.10
  238. mib-*.0 = 3:18:51:51.10
  239. mib-*.0 = 3:18:51:51.10
  240. mib-*.0 = 3:18:51:51.10  
  241.  
  242.  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]
  243. mib-*.0 = 3:18:51:51.11
  244. mib-*.0 = 3:18:51:51.11  
  245.  
  246.  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]
  247. mib-*.0 = 3:18:51:51.13
  248. mib-*.0 = 3:18:51:51.13
  249. mib-*.0 = 3:18:51:51.13
  250. mib-*.0 = 3:18:51:51.13  
  251.  
  252.  
  253.  
  254. >> Runtime for poller module 'netstats': 0.0946 seconds with 3824 bytes
  255. >> SNMP: [7/0.09s] MySQL: [0/0.00s]
  256. #### Unload poller module netstats ####
  257.  
  258. Modules status: Global+  
  259. OS  
  260. Device  
  261.  
  262. #### Load poller module hr-mib ####
  263. 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]
  264. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  265. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  266.  
  267.  
  268.  
  269. >> Runtime for poller module 'hr-mib': 0.0123 seconds with 1640 bytes
  270. >> SNMP: [1/0.01s] MySQL: [0/0.00s]
  271. #### Unload poller module hr-mib ####
  272.  
  273. Modules status: Global+  
  274. OS  
  275. Device  
  276.  
  277. #### Load poller module ucd-mib ####
  278. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
  279. systemStats = No more variables left in this MIB View (It is past the end of the MIB tree)  
  280.  
  281. 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]
  282. laLoadInt.1 = No Such Object available on this agent at this OID
  283. laLoadInt.2 = No Such Object available on this agent at this OID
  284. laLoadInt.3 = No Such Object available on this agent at this OID  
  285.  
  286.  
  287. >> Runtime for poller module 'ucd-mib': 0.0250 seconds with 2000 bytes
  288. >> SNMP: [2/0.02s] MySQL: [0/0.00s]
  289. #### Unload poller module ucd-mib ####
  290.  
  291. Modules status: Global+  
  292. OS  
  293. Device  
  294.  
  295. #### Load poller module ipSystemStats ####
  296. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  297. ipSystemStatsTable = No Such Object available on this agent at this OID  
  298.  
  299. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
  300.  
  301.  
  302. >> Runtime for poller module 'ipSystemStats': 0.0162 seconds with 1976 bytes
  303. >> SNMP: [1/0.02s] MySQL: [0/0.00s]
  304. #### Unload poller module ipSystemStats ####
  305.  
  306. Modules status: Global+  
  307. OS  
  308. Device  
  309.  
  310. #### Load poller module ports ####
  311. 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]
  312.  
  313. 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]
  314. ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree)  
  315.  
  316. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  317. ifEntry = No Such Object available on this agent at this OID  
  318.  
  319. Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID  
  320. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  321. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  322.  
  323. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  324. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  325. dot1qPvid = No Such Object available on this agent at this OID  
  326.  
  327. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  328. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[36][0m 0.42ms]
  329.  
  330. array (
  331. )  
  332.  
  333.  
  334. Warning: max(): Array must contain at least one element in /opt/librenms/includes/polling/ports.inc.php on line 521
  335. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1610362505,false,1610362505][0m 0.23ms]
  336.  
  337. 0 updated  
  338.  
  339. >> Runtime for poller module 'ports': 0.0610 seconds with 34480 bytes
  340. >> SNMP: [4/0.06s] MySQL: [1/0.00s]
  341. #### Unload poller module ports ####
  342.  
  343. Modules status: Global+  
  344. OS  
  345. Device  
  346.  
  347. #### Load poller module customoid ####
  348. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[36][0m 0.23ms]
  349.  
  350.  
  351. >> Runtime for poller module 'customoid': 0.0005 seconds with 2488 bytes
  352. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  353. #### Unload poller module customoid ####
  354.  
  355. Modules status: Global+  
  356. OS-  
  357. Device  
  358. Module [ bgp-peers ] disabled on os.
  359.  
  360. Modules status: Global-  
  361. OS  
  362. Device  
  363. Module [ junose-atm-vp ] disabled globally.
  364.  
  365. Modules status: Global-  
  366. OS  
  367. Device  
  368. Module [ toner ] disabled globally.
  369.  
  370. Modules status: Global+  
  371. OS  
  372. Device  
  373.  
  374. #### Load poller module ucd-diskio ####
  375. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[36][0m 0.14ms]
  376.  
  377.  
  378. >> Runtime for poller module 'ucd-diskio': 0.0003 seconds with 1944 bytes
  379. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  380. #### Unload poller module ucd-diskio ####
  381.  
  382. Modules status: Global-  
  383. OS  
  384. Device  
  385. Module [ wifi ] disabled globally.
  386.  
  387. Modules status: Global+  
  388. OS  
  389. Device  
  390.  
  391. #### Load poller module wireless ####
  392. Attempting to initialize OS: proxmox  
  393. Attempting to initialize OS: unix  
  394. OS initialized: LibreNMS\OS\Shared\Unix  
  395. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[36][0m 0.23ms]
  396.  
  397.  
  398. >> Runtime for poller module 'wireless': 0.0013 seconds with 103008 bytes
  399. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  400. #### Unload poller module wireless ####
  401.  
  402. Modules status: Global+  
  403. OS-  
  404. Device  
  405. Module [ ospf ] disabled on os.
  406.  
  407. Modules status: Global-  
  408. OS  
  409. Device  
  410. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  411.  
  412. Modules status: Global-  
  413. OS  
  414. Device  
  415. Module [ cisco-remote-access-monitor ] disabled globally.
  416.  
  417. Modules status: Global-  
  418. OS  
  419. Device  
  420. Module [ cisco-cef ] disabled globally.
  421.  
  422. Modules status: Global-  
  423. OS  
  424. Device  
  425. Module [ cisco-sla ] disabled globally.
  426.  
  427. Modules status: Global-  
  428. OS  
  429. Device  
  430. Module [ cisco-mac-accounting ] disabled globally.
  431.  
  432. Modules status: Global-  
  433. OS  
  434. Device  
  435. Module [ cipsec-tunnels ] disabled globally.
  436.  
  437. Modules status: Global-  
  438. OS  
  439. Device  
  440. Module [ cisco-ace-loadbalancer ] disabled globally.
  441.  
  442. Modules status: Global-  
  443. OS  
  444. Device  
  445. Module [ cisco-ace-serverfarms ] disabled globally.
  446.  
  447. Modules status: Global-  
  448. OS  
  449. Device  
  450. Module [ cisco-asa-firewall ] disabled globally.
  451.  
  452. Modules status: Global-  
  453. OS  
  454. Device  
  455. Module [ cisco-voice ] disabled globally.
  456.  
  457. Modules status: Global-  
  458. OS  
  459. Device  
  460. Module [ cisco-cbqos ] disabled globally.
  461.  
  462. Modules status: Global-  
  463. OS  
  464. Device  
  465. Module [ cisco-otv ] disabled globally.
  466.  
  467. Modules status: Global-  
  468. OS  
  469. Device  
  470. Module [ cisco-qfp ] disabled globally.
  471.  
  472. Modules status: Global-  
  473. OS  
  474. Device  
  475. Module [ cisco-vpdn ] disabled globally.
  476.  
  477. Modules status: Global-  
  478. OS  
  479. Device  
  480. Module [ nac ] disabled globally.
  481.  
  482. Modules status: Global-  
  483. OS  
  484. Device  
  485. Module [ netscaler-vsvr ] disabled globally.
  486.  
  487. Modules status: Global-  
  488. OS  
  489. Device  
  490. Module [ aruba-controller ] disabled globally.
  491.  
  492. Modules status: Global+  
  493. OS  
  494. Device  
  495.  
  496. #### Load poller module entity-physical ####
  497. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[36][0m 0.12ms]
  498.  
  499.  
  500. >> Runtime for poller module 'entity-physical': 0.0004 seconds with 2152 bytes
  501. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  502. #### Unload poller module entity-physical ####
  503.  
  504. Modules status: Global-  
  505. OS  
  506. Device  
  507. Module [ entity-state ] disabled globally.
  508.  
  509. Modules status: Global+  
  510. OS  
  511. Device  
  512.  
  513. #### Load poller module applications ####
  514. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[36][0m 0.11ms]
  515.  
  516.  
  517. >> Runtime for poller module 'applications': 0.0002 seconds with 1592 bytes
  518. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  519. #### Unload poller module applications ####
  520.  
  521. Modules status: Global-  
  522. OS  
  523. Device  
  524. Module [ mib ] disabled globally.
  525.  
  526. Modules status: Global+  
  527. OS-  
  528. Device  
  529. Module [ stp ] disabled on os.
  530.  
  531. Modules status: Global+  
  532. OS  
  533. Device  
  534.  
  535. #### Load poller module ntp ####
  536.  
  537. >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
  538. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  539. #### Unload poller module ntp ####
  540.  
  541. Modules status: Global-  
  542. OS  
  543. Device  
  544. Module [ loadbalancers ] disabled globally.
  545.  
  546. Modules status: Global-  
  547. OS  
  548. Device  
  549. Module [ mef ] disabled globally.
  550.  
  551. Modules status: Global+  
  552. OS  
  553. Device  
  554.  
  555. #### Load poller module mpls ####
  556.  
  557. >> Runtime for poller module 'mpls': 0.0002 seconds with 24080 bytes
  558. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  559. #### Unload poller module mpls ####
  560.  
  561. 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]
  562.  
  563.  
  564. 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]
  565.  
  566. Updating proxmox-node-2.home.lan  
  567.  
  568. Polled in 1.305 seconds
  569. ### Start Device Groups ###
  570. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[36][0m 0.38ms]
  571.  
  572. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.19ms]
  573.  
  574. SQL[[1;33mselect * from `device_group_device` where `device_id` = ? [0;33m[36][0m 0.19ms]
  575.  
  576. Groups Added:  
  577. Groups Removed:  
  578. ### End Device Groups, runtime: 0.0014s ###
  579.  
  580. #### Start Alerts ####
  581. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) &lt;= ? 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]
  582.  
  583. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[36][0m 0.21ms]
  584.  
  585. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  586.         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 = ?)
  587.         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 = ?))
  588.         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 = ?))
  589.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  590.         WHERE a.disabled = 0 AND (
  591.             (d.device_id IS NULL AND g.group_id IS NULL)
  592.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  593.             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))
  594.         ) [0;33m[36,36,36,36,36,36,36,36][0m 1.03ms]
  595.  
  596. Rule [0;35m#1 (Devices up/down):[0m  
  597. 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]
  598.  
  599. 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]
  600.  
  601. Status: [0;34mNOCHG[0m
  602. #### End Alerts ####
  603. 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]
  604.  
  605. ./poller.php proxmox-node-2.home.lan 2021-01-11 12:55:05 - 1 devices polled in 1.691 secs  
  606. SNMP [18/0.24s]: Get[6/0.07s] Getnext[4/0.05s] Walk[8/0.11s]
  607. 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]
  608.