From mailanetworks, 5 Years ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2.  
  3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.42ms]
  4.  
  5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.32ms]
  6.  
  7.  
  8. SQL[SELECT version() [] 0.39ms]
  9.  
  10.  
  11. ===================================
  12. Version info:
  13. Commit SHA: 96797aa813c3d183db80aedde7e4b49277379e4c
  14. Commit Date: 1553095069
  15. DB Schema: 2019_02_10_220000_add_dates_to_fdb (132)
  16. PHP: 7.3.3-1+0~20190307202445.32+jessie~1.gbp32ebb2
  17. MySQL: 10.0.38-MariaDB-0+deb8u1
  18. RRDTool: 1.4.8
  19. SNMP: NET-SNMP 5.7.2.1
  20. ==================================DEBUG!
  21.  
  22. Updating os_def.cache...  
  23.  
  24.  
  25. Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/includes/common.php on line 1640
  26.  
  27. Done  
  28.  
  29. Starting polling run:
  30.  
  31.  
  32. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'caraaoltvolt.netcomet.com.br' ORDER BY `device_id` ASC [] 1.5ms]
  33.  
  34.  
  35. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [364] 0.41ms]
  36.  
  37.  
  38. Hostname: caraaoltvolt.netcomet.com.br
  39. Device ID: 364
  40. OS: serverscheck
  41.  
  42.  
  43.  
  44. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 caraaoltvolt.netcomet.com.br  
  45.  
  46. array (
  47.   'xmt' => '3',
  48.   'rcv' => '3',
  49.   'loss' => '0',
  50.   'min' => '4.75',
  51.   'max' => '10.4',
  52.   'avg' => '7.37',
  53.   'exitcode' => 0,
  54. )  
  55.  
  56. SQL[INSERT 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) {"xmt":"3","rcv":"3","loss":"0","min":"4.75","max":"10.4","avg":"7.37","device_id":364,"debug":"[]"} 9.37ms]
  57.  
  58.  
  59. SNMP Check response code: 0  
  60.  
  61. Modules status: Global+  
  62.  
  63. OS  
  64. Device  
  65.  
  66.  
  67. #### Load poller module core ####
  68.  
  69. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
  70.  
  71. .*.*.0 = 9579072
  72. .*.*.0 = Brazil
  73. .*.*.0 = Volt
  74. .*.*.0 = Pop Protect SNMP
  75. .*.*.0 = .*.4.1.17095.1
  76. .*.*.0 = Alarme SNMP  
  77.  
  78.  
  79. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'snmpEngineTime.0' 'hrSystemUptime.0']
  80.  
  81.  
  82. Timeout: No Response from udp:caraaoltvolt.netcomet.com.br:1161.  
  83. Uptime seconds: 95791  
  84.  
  85. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/uptime.rrd N:95791]
  86. [RRD Disabled]
  87. Uptime:  1day 2 hours 36 minutes 31 seconds
  88.  
  89. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [72] 0.66ms]
  90.  
  91.  
  92.  
  93. >> Runtime for poller module 'core': 6.1003 seconds with 49824 bytes
  94. >> SNMP: [2/6.09s] MySQL: [0/0.00s] RRD: [0/0.00s]
  95. #### Unload poller module core ####
  96.  
  97.  
  98. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-core.rrd N:6.1003041267395]
  99. [RRD Disabled]
  100. Modules status: Global-  
  101. OS  
  102.  
  103. Module [ unix-agent ] disabled globally.
  104.  
  105.  
  106. Device  
  107.  
  108.  
  109. #### Load poller module os ####
  110.  
  111. Modules status: Global+  
  112. OS  
  113. Device  
  114.  
  115. Generic :(
  116.  
  117. Hardware:
  118. Version:
  119. Features:
  120. Serial:
  121.  
  122. >> Runtime for poller module 'os': 0.0019 seconds with 44128 bytes
  123. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  124. #### Unload poller module os ####
  125.  
  126.  
  127. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-os.rrd N:0.0018720626831055]
  128. [RRD Disabled]
  129. Modules status: Global+  
  130.  
  131. OS  
  132. Device  
  133.  
  134.  
  135. #### Load poller module ipmi ####
  136.  
  137. SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [364] 0.76ms]
  138.  
  139.  
  140. array (
  141. )  
  142.  
  143.  
  144. >> Runtime for poller module 'ipmi': 0.0015 seconds with 2288 bytes
  145. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  146. #### Unload poller module ipmi ####
  147.  
  148.  
  149. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ipmi.rrd N:0.0014638900756836]
  150. [RRD Disabled]
  151. Modules status: Global+  
  152.  
  153. OS  
  154.  
  155. Device  
  156.  
  157.  
  158. #### Load poller module sensors ####
  159.  
  160. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [364] 0.57ms]
  161.  
  162.  
  163.  
  164. >> Runtime for poller module 'sensors': 0.0010 seconds with 1256 bytes
  165. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  166. #### Unload poller module sensors ####
  167.  
  168. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-sensors.rrd N:0.00095915794372559]
  169. [RRD Disabled]
  170. Modules status: Global+  
  171.  
  172. OS  
  173.  
  174.  
  175. #### Load poller module processors ####
  176.  
  177. Device  
  178.  
  179. Attempting to initialize OS: serverscheck  
  180.  
  181. OS initialized as Generic  
  182.  
  183. SQL[SELECT * FROM processors WHERE device_id=? [364] 0.67ms]
  184.  
  185.  
  186.  
  187. >> Runtime for poller module 'processors': 0.0037 seconds with 143472 bytes
  188. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  189. #### Unload poller module processors ####
  190.  
  191. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-processors.rrd N:0.0036590099334717]
  192. [RRD Disabled]
  193. Modules status: Global+  
  194.  
  195. OS  
  196.  
  197.  
  198. #### Load poller module mempools ####
  199.  
  200. Device  
  201.  
  202. SQL[SELECT * FROM mempools WHERE device_id = ? [364] 0.47ms]
  203.  
  204.  
  205.  
  206. >> Runtime for poller module 'mempools': 0.0009 seconds with 1568 bytes
  207. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  208. #### Unload poller module mempools ####
  209.  
  210. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-mempools.rrd N:0.00087404251098633]
  211. [RRD Disabled]
  212. Modules status: Global+  
  213.  
  214. OS  
  215. Device  
  216.  
  217.  
  218. #### Load poller module storage ####
  219.  
  220. SQL[SELECT * FROM storage WHERE device_id = ? [364] 0.42ms]
  221.  
  222.  
  223.  
  224. >> Runtime for poller module 'storage': 0.0008 seconds with 1528 bytes
  225. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  226. #### Unload poller module storage ####
  227.  
  228. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-storage.rrd N:0.00076007843017578]
  229. [RRD Disabled]
  230. Modules status: Global+  
  231.  
  232. OS  
  233.  
  234.  
  235. #### Load poller module netstats ####
  236.  
  237. Device  
  238.  
  239.  ICMP
  240. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'icmp']
  241.  
  242. icmp.0 = No Such Object available on this agent at this OID  
  243.  
  244.  
  245.  IP
  246. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' "" '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']
  247.  
  248.  
  249. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  250.  
  251.  IP-FORWARD
  252. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0']
  253.  
  254. No Such Object available on this agent at this OID  
  255.  
  256.  
  257.  
  258.  SNMPSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'snmp']
  259.  
  260. snmp.0 = No Such Object available on this agent at this OID  
  261.  
  262.  
  263.  TCPSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' "" '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']
  264.  
  265.  
  266. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  267.  
  268.  UDP
  269. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' "" 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0']
  270.  
  271.  
  272.  
  273. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  274.  
  275.  
  276.  
  277. >> Runtime for poller module 'netstats': 0.3988 seconds with 3456 bytes
  278. >> SNMP: [6/0.40s] MySQL: [0/0.00s] RRD: [0/0.00s]
  279. #### Unload poller module netstats ####
  280.  
  281.  
  282. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-netstats.rrd N:0.39876198768616]
  283. [RRD Disabled]
  284. Modules status: Global+  
  285. OS  
  286.  
  287.  
  288. #### Load poller module hr-mib ####
  289.  
  290. Device  
  291.  
  292. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0']
  293.  
  294. hrSystemProcesses.0.0 = No Such Object available on this agent at this OID
  295. hrSystemNumUsers.0.0 = No Such Object available on this agent at this OID  
  296.  
  297.  
  298.  
  299.  
  300. >> Runtime for poller module 'hr-mib': 1.0382 seconds with 1224 bytes
  301. >> SNMP: [1/1.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  302. #### Unload poller module hr-mib ####
  303.  
  304. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-hr-mib.rrd N:1.038211107254]
  305. [RRD Disabled]
  306. Modules status: Global+  
  307. OS  
  308.  
  309.  
  310. #### Load poller module ucd-mib ####
  311.  
  312. Device  
  313.  
  314. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'systemStats']
  315.  
  316. systemStats.0 = No Such Object available on this agent at this OID  
  317.  
  318.  
  319. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0']
  320.  
  321. memTotalSwap.0.0 = No Such Object available on this agent at this OID
  322. memAvailSwap.0.0 = No Such Object available on this agent at this OID
  323. memTotalReal.0.0 = No Such Object available on this agent at this OID
  324. memAvailReal.0.0 = No Such Object available on this agent at this OID
  325. memTotalFree.0.0 = No Such Object available on this agent at this OID
  326. memShared.0.0 = No Such Object available on this agent at this OID
  327. memBuffer.0.0 = No Such Object available on this agent at this OID
  328. memCached.0.0 = No Such Object available on this agent at this OID  
  329.  
  330.  
  331. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3']
  332.  
  333. laLoadInt.1.0 = No Such Object available on this agent at this OID
  334. laLoadInt.2.0 = No Such Object available on this agent at this OID
  335. laLoadInt.3.0 = No Such Object available on this agent at this OID  
  336.  
  337.  
  338.  
  339. >> Runtime for poller module 'ucd-mib': 0.2410 seconds with 2000 bytes
  340. >> SNMP: [3/0.24s] MySQL: [0/0.00s] RRD: [0/0.00s]
  341. #### Unload poller module ucd-mib ####
  342.  
  343.  
  344. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ucd-mib.rrd N:0.241042137146]
  345. [RRD Disabled]
  346. Modules status: Global+  
  347. OS  
  348.  
  349.  
  350. #### Load poller module ipSystemStats ####
  351.  
  352. Device  
  353.  
  354. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'ipSystemStats']
  355.  
  356. ipSystemStatsTable.0 = No Such Object available on this agent at this OID  
  357.  
  358.  
  359.  
  360.  
  361. >> Runtime for poller module 'ipSystemStats': 0.1254 seconds with 1576 bytes
  362. >> SNMP: [1/0.12s] MySQL: [0/0.00s] RRD: [0/0.00s]
  363. #### Unload poller module ipSystemStats ####
  364.  
  365.  
  366. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ipSystemStats.rrd N:0.12536001205444]
  367. [RRD Disabled]
  368. Modules status: Global+  
  369. OS  
  370.  
  371.  
  372. #### Load poller module ports ####
  373.  
  374. Device  
  375.  
  376. 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` = ? ORDER BY ports.port_id [364] 1.53ms]
  377.  
  378.  
  379. Caching Oids: Full ports polling
  380. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'ifXEntry']
  381.  
  382. ifXEntry.0 = No Such Object available on this agent at this OID  
  383.  
  384.  
  385. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'ifEntry']
  386.  
  387. ifEntry.0 = No Such Object available on this agent at this OID  
  388.  
  389. dot3StatsDuplexStatusSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot3StatsDuplexStatus']
  390.  
  391.  
  392.  
  393. dot3StatsDuplexStatus.0 = No Such Object available on this agent at this OID  
  394.  
  395.  
  396. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot1qPvid']
  397.  
  398. dot1qPvid.0 = No Such Object available on this agent at this OID  
  399.  
  400.  
  401.  
  402. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [364] 1.12ms]
  403.  
  404.  
  405.  
  406.  
  407. >> Runtime for poller module 'ports': 0.5448 seconds with 21016 bytes
  408. >> SNMP: [4/0.54s] MySQL: [1/0.00s] RRD: [0/0.00s]
  409.  
  410. array (
  411. )  
  412.  
  413. #### Unload poller module ports ####
  414.  
  415. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ports.rrd N:0.54478311538696]
  416. [RRD Disabled]
  417. Modules status: Global+  
  418. OS  
  419.  
  420.  
  421. #### Load poller module bgp-peers ####
  422.  
  423. Device  
  424.  
  425.  
  426. >> Runtime for poller module 'bgp-peers': 0.0021 seconds with 9616 bytes
  427. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  428. #### Unload poller module bgp-peers ####
  429.  
  430.  
  431. SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [364] 0.36ms]
  432.  
  433.  
  434. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-bgp-peers.rrd N:0.0021300315856934]
  435. [RRD Disabled]Module [ junose-atm-vp ] disabled globally.
  436.  
  437.  
  438. Modules status: Global-  
  439. OS  
  440. Device  
  441. Modules status: Global-  
  442. OS  
  443. Device  
  444.  
  445. Module [ toner ] disabled globally.
  446.  
  447.  
  448. #### Load poller module ucd-diskio ####
  449.  
  450. Modules status: Global+  
  451. OS  
  452. Device  
  453.  
  454.  
  455. >> Runtime for poller module 'ucd-diskio': 0.0009 seconds with 1608 bytes
  456. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  457. #### Unload poller module ucd-diskio ####
  458.  
  459.  
  460. SQL[SELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [364] 0.49ms]
  461.  
  462.  
  463. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ucd-diskio.rrd N:0.00086688995361328]
  464. [RRD Disabled]Module [ wifi ] disabled globally.
  465.  
  466.  
  467. Modules status: Global-  
  468. OS  
  469. Device  
  470.  
  471.  
  472. #### Load poller module wireless ####
  473.  
  474. Modules status: Global+  
  475. OS  
  476. Device  
  477.  
  478. Attempting to initialize OS: serverscheck  
  479.  
  480. OS initialized as Generic  
  481.  
  482. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [364] 0.57ms]
  483.  
  484.  
  485.  
  486. >> Runtime for poller module 'wireless': 0.0026 seconds with 83552 bytes
  487. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  488. #### Unload poller module wireless ####
  489.  
  490.  
  491. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-wireless.rrd N:0.0025980472564697]
  492. [RRD Disabled]
  493. Modules status: Global+  
  494.  
  495. OS  
  496.  
  497.  
  498. #### Load poller module ospf ####
  499.  
  500. Device  
  501.  
  502. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [364] 0.6ms]
  503.  
  504.  
  505.  Processes:
  506. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'OSPF-MIB::ospfGeneralGroup']
  507.  
  508. ospfGeneralGroup.0 = No Such Object available on this agent at this OID  
  509.  
  510.  
  511. array (
  512. )  
  513.  
  514. 0
  515. >> Runtime for poller module 'ospf': 0.1498 seconds with 141312 bytes
  516. >> SNMP: [1/0.14s] MySQL: [0/0.00s] RRD: [0/0.00s]
  517. #### Unload poller module ospf ####
  518.  
  519. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ospf.rrd N:0.14979100227356]
  520. [RRD Disabled]
  521. SQL[delete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [364] 0.47ms]
  522.  
  523. Modules status: Global-  
  524.  
  525. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  526.  
  527.  
  528. OS  
  529. Device  
  530. Modules status: Global-  
  531. OS  
  532.  
  533. Module [ cisco-remote-access-monitor ] disabled globally.
  534.  
  535.  
  536. Device  
  537.  
  538. Modules status: Global-  
  539.  
  540. OS  
  541.  
  542. Module [ cisco-cef ] disabled globally.
  543.  
  544.  
  545. Device  
  546.  
  547. Modules status: Global-  
  548.  
  549. OS  
  550.  
  551. Device  
  552.  
  553. Module [ cisco-sla ] disabled globally.
  554.  
  555.  
  556. Modules status: Global-  
  557.  
  558. OS  
  559.  
  560. Module [ cisco-mac-accounting ] disabled globally.
  561.  
  562.  
  563. Device  
  564.  
  565. Modules status: Global-  
  566.  
  567. OS  
  568.  
  569. Device  
  570.  
  571. Module [ cipsec-tunnels ] disabled globally.
  572.  
  573.  
  574. Modules status: Global-  
  575.  
  576. OS  
  577.  
  578. Module [ cisco-ace-loadbalancer ] disabled globally.
  579.  
  580.  
  581. Device  
  582.  
  583. Modules status: Global-  
  584.  
  585. OS  
  586.  
  587. Module [ cisco-ace-serverfarms ] disabled globally.
  588.  
  589.  
  590. Device  
  591.  
  592. Modules status: Global-  
  593.  
  594. OS  
  595.  
  596. Device  
  597.  
  598. Module [ cisco-asa-firewall ] disabled globally.
  599.  
  600.  
  601. Modules status: Global-  
  602.  
  603. OS  
  604.  
  605. Module [ cisco-voice ] disabled globally.
  606.  
  607.  
  608. Device  
  609.  
  610. Modules status: Global-  
  611. OS  
  612.  
  613. Module [ cisco-cbqos ] disabled globally.
  614.  
  615.  
  616. Device  
  617.  
  618. Modules status: Global-  
  619.  
  620. OS  
  621.  
  622. Module [ cisco-otv ] disabled globally.
  623.  
  624.  
  625. Device  
  626.  
  627. Modules status: Global-  
  628.  
  629. OS  
  630.  
  631. Module [ cisco-vpdn ] disabled globally.
  632.  
  633.  
  634. Device  
  635.  
  636. Modules status: Global-  
  637. OS  
  638.  
  639. Module [ nac ] disabled globally.
  640.  
  641. Module [ netscaler-vsvr ] disabled globally.
  642.  
  643. Module [ aruba-controller ] disabled globally.
  644.  
  645.  
  646. #### Load poller module entity-physical ####
  647.  
  648. Device  
  649. Modules status: Global-  
  650. OS  
  651. Device  
  652. Modules status: Global-  
  653. OS  
  654. Device  
  655. Modules status: Global+  
  656. OS  
  657. Device  
  658.  
  659.  
  660. >> Runtime for poller module 'entity-physical': 0.0011 seconds with 1760 bytes
  661. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  662.  
  663. SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [364] 0.46ms]
  664.  
  665.  
  666. #### Unload poller module entity-physical ####
  667.  
  668. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-entity-physical.rrd N:0.0011429786682129]
  669. [RRD Disabled]
  670. Module [ entity-state ] disabled globally.
  671.  
  672.  
  673. #### Load poller module applications ####
  674.  
  675. >> Runtime for poller module 'applications': 0.0006 seconds with 1368 bytes
  676. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  677. #### Unload poller module applications ####
  678.  
  679. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-applications.rrd N:0.00062417984008789]
  680. [RRD Disabled]
  681. #### Load poller module mib ####
  682. MIB: polling
  683.  
  684. >> Runtime for poller module 'mib': 0.0011 seconds with 1064 bytes
  685. >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s]
  686. #### Unload poller module mib ####
  687.  
  688. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-mib.rrd N:0.0010931491851807]
  689. [RRD Disabled]
  690. #### Load poller module stp ####
  691. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/serverscheck' 'udp:HOSTNAME:1161' 'dot1dStpProtocolSpecification.0']
  692.  
  693. Modules status: Global-  
  694. OS  
  695. Device  
  696. Modules status: Global+  
  697. OS  
  698. Device  
  699. SQL[SELECT * FROM `applications` WHERE `device_id`  = ? [364] 0.34ms]
  700.  
  701. Modules status: Global-  
  702. OS  
  703. Device+  
  704. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [364,"poll_mib"] 0.26ms]
  705.  
  706.  
  707. SQL[SELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [364] 0.26ms]
  708.  
  709. Modules status: Global+  
  710. OS  
  711. Device  
  712. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [364] 0.3ms]
  713.  
  714.  
  715. No Such Object available on this agent at this OID  
  716.  
  717.  
  718.  
  719.  
  720.  
  721.  
  722. >> Runtime for poller module 'stp': 0.0508 seconds with 4656 bytes
  723.  
  724. >> SNMP: [1/0.05s] MySQL: [1/0.00s] RRD: [0/0.00s]
  725.  
  726. #### Unload poller module stp ####
  727.  
  728.  
  729. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-stp.rrd N:0.050826072692871]
  730.  
  731. [RRD Disabled]
  732. Modules status: Global+  
  733.  
  734. OS  
  735.  
  736. Device  
  737.  
  738.  
  739. #### Load poller module ntp ####
  740.  
  741.  
  742. >> Runtime for poller module 'ntp': 0.0003 seconds with 328 bytes
  743.  
  744. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  745.  
  746. #### Unload poller module ntp ####
  747.  
  748.  
  749. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf-ntp.rrd N:0.00027298927307129]
  750.  
  751. [RRD Disabled]
  752. Modules status: Global-  
  753.  
  754. OS  
  755.  
  756. Device  
  757.  
  758. Module [ loadbalancers ] disabled globally.
  759.  
  760.  
  761. Modules status: Global-  
  762.  
  763. OS  
  764.  
  765. Device  
  766.  
  767. Module [ mef ] disabled globally.
  768.  
  769.  
  770. ### Start Device Groups ###  
  771.  
  772. SQL[SELECT * FROM device_groups ORDER BY name [] 0.38ms]
  773.  
  774.  
  775. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname REGEXP "caraa") LIMIT 1 [364] 0.84ms]
  776.  
  777.  
  778. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname REGEXP "energia"  ) LIMIT 1 [364] 0.39ms]
  779.  
  780.  
  781. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname REGEXP "rolante" ) LIMIT 1 [364] 0.46ms]
  782.  
  783.  
  784. SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname REGEXP "sap") LIMIT 1 [364] 0.42ms]
  785.  
  786.  
  787. SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [364] 0.24ms]
  788.  
  789.  
  790. Groups Added:  
  791.  
  792. Groups Removed:  
  793.  
  794. ### End Device Groups ###  
  795.  
  796. Enabling graphs:
  797. SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [364] 0.35ms]
  798.  
  799.  
  800. uptime
  801.  
  802.  
  803. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/ping-perf.rrd N:7.37]
  804.  
  805. [RRD Disabled]
  806. RRD[update /opt/librenms/rrd/caraaoltvolt.netcomet.com.br/poller-perf.rrd N:9.748]
  807.  
  808. [RRD Disabled]
  809. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [95791,"7.37",9.748,364] 4.53ms]
  810.  
  811.  
  812. Updating caraaoltvolt.netcomet.com.br  
  813.  
  814.  
  815. Polled in 9.748 seconds
  816.  
  817. #### Start Alerts ####
  818.  
  819. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [364] 0.66ms]
  820.  
  821.  
  822. SQL[select `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` = ? [364] 0.38ms]
  823.  
  824.  
  825. SQL[select 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(), '--%d') and (`end_recurring_dt` >= date_format(NOW(), '--%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(), ''), '%') 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,1,"0000-00-00","","","device",364,"device_group",1] 0.98ms]
  826.  
  827.  
  828. SQL[SELECT DISTINCT a.* FROM alert_rules a
  829.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
  830.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
  831.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  832.   WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [364,364] 0.46ms]
  833.  
  834.  
  835. Rule #1 (Falha no Equipamento):
  836.  
  837.  
  838. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [364] 0.57ms]
  839.  
  840.  
  841. Status: NOCHG
  842. Rule #2 (Sensor Acima do Limite):
  843. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,364] 1.86ms]
  844.  
  845.  
  846.  
  847. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Sensors.sensor_current' in 'where clause' (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current > sensors.sensor_limit  &&  sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"     )) (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current > sensors.sensor_limit  &&  sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1"     ))#0 /opt/librenms/includes/alerts.inc.php(187): dbFetchRows('SELECT * FROM s...', Array)
  848. #1 /opt/librenms/poller.php(162): RunRules(364)
  849. #2 {main}  
  850.  
  851. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,364] 0.25ms]
  852.  
  853.  
  854. Status: NOCHG
  855.  
  856.  
  857. Rule #3 (Corrente abaixo do limite):
  858.  
  859.  
  860. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Sensors.sensor_current' in 'where clause' (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current &lt; sensors.sensor_limit_low = ""  &&  sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1" )) (SQL: SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = 364) && (Sensors.sensor_current &lt; sensors.sensor_limit_low = ""  &&  sensors.sensor_alert = "1"  &&  ((devices.status = 1  &&  ((devices.disabled = 0  &&  devices.ignore = 0)))) = "1" ))#0 /opt/librenms/includes/alerts.inc.php(187): dbFetchRows('SELECT * FROM s...', Array)
  861. #1 /opt/librenms/poller.php(162): RunRules(364)
  862. #2 {main}  
  863.  
  864. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [3,364] 0.31ms]
  865.  
  866.  
  867. Status: NOCHG
  868.  
  869.  
  870. #### End Alerts ####
  871.  
  872. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"caraaoltvolt.netcomet.com.br","start":1553217912.413632,"duration":"10.08","devices":1,"poller":"nms"} 4.19ms]
  873.  
  874.  
  875. SNMP [20/8.64s]: Get[11/7.42s] Getnext[0/0.00s] Walk[9/1.22s]
  876. MySQL [23/0.04s]: Cell[9/0.01s] Row[-7/-0.01s] Rows[17/0.02s] Column[1/0.00s] Update[1/0.01s] Insert[2/0.01s] Delete[0/0.00s]
  877. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  878.  
  879. /opt/librenms/poller.php caraaoltvolt.netcomet.com.br 2019-03-22 01:25:22 - 1 devices polled in 10.08 secs  
  880.  
  881.