Untitled

From qubic, 5 Years ago, written in Plain Text.
URL https://p.libren.ms/view/a24dfb3f
Embed
Download Paste or View Raw
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 6.2ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 3.31ms]
  5.  
  6. SQL[[1;33mSELECT version() [0;33m[][0m 1.67ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: 21192a9cf2a3226e1a06bf69e5688242c5903dfa
  11. Commit Date: 1549635449
  12. DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
  13. PHP: 7.0.33-0ubuntu0.16.04.2
  14. MySQL: 10.0.38-MariaDB-0ubuntu0.16.04.1
  15. RRDTool: 1.5.5
  16. SNMP: NET-SNMP 5.7.3
  17. ==================================DEBUG!
  18. Updating os_def.cache...  
  19. Done  
  20. Starting polling run:
  21.  
  22. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.61.250' ORDER BY `device_id` ASC [0;33m[][0m 13.42ms]
  23.  
  24. SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[306][0m 0.33ms]
  25.  
  26. Hostname: 192.168.61.250
  27. Device ID: 306
  28. OS: sonus-sbc
  29. Warning: inet_pton(): Unrecognized address  in /opt/librenms/includes/polling/functions.inc.php on line 249
  30.  
  31.  
  32. [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 192.168.61.250  
  33. array (
  34.   'xmt' => '3',
  35.   'rcv' => '3',
  36.   'loss' => '0',
  37.   'min' => '5.00',
  38.   'max' => '8.71',
  39.   'avg' => '6.46',
  40.   'exitcode' => 0,
  41. )  
  42. 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":"5.00","max":"8.71","avg":"6.46","device_id":306,"debug":"[]"}[0m 305.98ms]
  43.  
  44. SNMP Check response code: 0  
  45. Modules status: Global+  
  46. OS  
  47. Device  
  48.  
  49. #### Load poller module core ####
  50. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  51. .*.*.0 = 687370439
  52. .*.*.0 =
  53. .*.*.0 =
  54. .*.*.0 =
  55. .*.*.0 = .*.4.1.28*
  56. .*.*.0 = Sonus SBC 5000 version sbc-V07.02.00-R000.x86_64  
  57.  
  58. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
  59. snmpEngineTime.0 = No Such Object available on this agent at this OID
  60. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  61.  
  62. Uptime seconds: 6873704  
  63. RRD[[0;32mupdate 192.168.61.250/uptime.rrd N:6873704 --daemon 127.0.0.1:42217[0m]
  64. [[0;31mRRD Disabled[0m]Uptime: 79 days, 13h 21m 44s
  65. SQL[[1;33mselect * from `locations` where `locations`.`id` is null limit 1 [0;33m[][0m 0.37ms]
  66.  
  67.  
  68. >> Runtime for poller module 'core': 0.0406 seconds with 43936 bytes
  69. >> SNMP: [2/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  70. #### Unload poller module core ####
  71.  
  72. RRD[[0;32mupdate 192.168.61.250/poller-perf-core.rrd N:0.040635824203491 --daemon 127.0.0.1:42217[0m]
  73. [[0;31mRRD Disabled[0m]Modules status: Global+  
  74. OS  
  75. Device  
  76.  
  77. #### Load poller module unix-agent ####
  78.  
  79. >> Runtime for poller module 'unix-agent': 0.0006 seconds with 8256 bytes
  80. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  81. #### Unload poller module unix-agent ####
  82.  
  83. RRD[[0;32mupdate 192.168.61.250/poller-perf-unix-agent.rrd N:0.00055408477783203 --daemon 127.0.0.1:42217[0m]
  84. [[0;31mRRD Disabled[0m]Modules status: Global+  
  85. OS  
  86. Device  
  87.  
  88. #### Load poller module os ####
  89. Generic :(
  90. Hardware:
  91. Version:
  92. Features:
  93. Serial:
  94.  
  95. >> Runtime for poller module 'os': 0.0002 seconds with 496 bytes
  96. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  97. #### Unload poller module os ####
  98.  
  99. RRD[[0;32mupdate 192.168.61.250/poller-perf-os.rrd N:0.00023603439331055 --daemon 127.0.0.1:42217[0m]
  100. [[0;31mRRD Disabled[0m]Modules status: Global+  
  101. OS  
  102. Device  
  103.  
  104. #### Load poller module ipmi ####
  105. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[306][0m 0.69ms]
  106.  
  107. array (
  108. )  
  109.  
  110. >> Runtime for poller module 'ipmi': 0.0014 seconds with 2552 bytes
  111. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  112. #### Unload poller module ipmi ####
  113.  
  114. RRD[[0;32mupdate 192.168.61.250/poller-perf-ipmi.rrd N:0.0013620853424072 --daemon 127.0.0.1:42217[0m]
  115. [[0;31mRRD Disabled[0m]Modules status: Global+  
  116. OS  
  117. Device  
  118.  
  119. #### Load poller module sensors ####
  120. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[306][0m 1.28ms]
  121.  
  122.  
  123. >> Runtime for poller module 'sensors': 0.0017 seconds with 1464 bytes
  124. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  125. #### Unload poller module sensors ####
  126.  
  127. RRD[[0;32mupdate 192.168.61.250/poller-perf-sensors.rrd N:0.0017039775848389 --daemon 127.0.0.1:42217[0m]
  128. [[0;31mRRD Disabled[0m]Modules status: Global+  
  129. OS  
  130. Device  
  131.  
  132. #### Load poller module processors ####
  133. Attempting to initialize OS: sonus-sbc  
  134. OS initialized as Generic  
  135. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[306][0m 0.61ms]
  136.  
  137.  
  138. >> Runtime for poller module 'processors': 0.0024 seconds with 91392 bytes
  139. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  140. #### Unload poller module processors ####
  141.  
  142. RRD[[0;32mupdate 192.168.61.250/poller-perf-processors.rrd N:0.0023939609527588 --daemon 127.0.0.1:42217[0m]
  143. [[0;31mRRD Disabled[0m]Modules status: Global+  
  144. OS  
  145. Device  
  146.  
  147. #### Load poller module mempools ####
  148. SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[306][0m 0.34ms]
  149.  
  150.  
  151. >> Runtime for poller module 'mempools': 0.0006 seconds with 1720 bytes
  152. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  153. #### Unload poller module mempools ####
  154.  
  155. RRD[[0;32mupdate 192.168.61.250/poller-perf-mempools.rrd N:0.00063514709472656 --daemon 127.0.0.1:42217[0m]
  156. [[0;31mRRD Disabled[0m]Modules status: Global+  
  157. OS  
  158. Device  
  159.  
  160. #### Load poller module storage ####
  161. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[306][0m 0.81ms]
  162.  
  163.  
  164. >> Runtime for poller module 'storage': 0.0011 seconds with 1704 bytes
  165. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  166. #### Unload poller module storage ####
  167.  
  168. RRD[[0;32mupdate 192.168.61.250/poller-perf-storage.rrd N:0.0010788440704346 --daemon 127.0.0.1:42217[0m]
  169. [[0;31mRRD Disabled[0m]Modules status: Global+  
  170. OS  
  171. Device  
  172.  
  173. #### Load poller module netstats ####
  174.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'icmp'[0m]
  175. icmp = No Such Object available on this agent at this OID  
  176.  
  177.  IPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]
  178.  
  179. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  180.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  181. No Such Object available on this agent at this OID  
  182.  
  183.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'snmp'[0m]
  184. snmpInPkts.0 = 1013401
  185. snmpInBadVersions.0 = 0
  186. snmpInBadCommunityNames.0 = 136007
  187. snmpInBadCommunityUses.0 = 0
  188. snmpInASNParseErrs.0 = 0
  189. snmpEnableAuthenTraps.0 = enabled
  190. snmpSilentDrops.0 = 0
  191. snmpProxyDrops.0 = 0  
  192.  
  193. RRD[[0;32mupdate 192.168.61.250/netstats-snmp.rrd N:1013401:U:0:136007:0:0:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:0:0 --daemon 127.0.0.1:42217[0m]
  194. [[0;31mRRD Disabled[0m] TCPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
  195.  
  196. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  197.  UDPSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' '' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]
  198.  
  199. : Unknown Object Identifier (Sub-id not found: (top) -> )  
  200.  
  201.  
  202. >> Runtime for poller module 'netstats': 0.0918 seconds with 3552 bytes
  203. >> SNMP: [6/0.09s] MySQL: [0/0.00s] RRD: [0/0.00s]
  204. #### Unload poller module netstats ####
  205.  
  206. RRD[[0;32mupdate 192.168.61.250/poller-perf-netstats.rrd N:0.091756105422974 --daemon 127.0.0.1:42217[0m]
  207. [[0;31mRRD Disabled[0m]Modules status: Global+  
  208. OS  
  209. Device  
  210.  
  211. #### Load poller module hr-mib ####
  212. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  213. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  214. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  215.  
  216.  
  217.  
  218. >> Runtime for poller module 'hr-mib': 0.0149 seconds with 1472 bytes
  219. >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s]
  220. #### Unload poller module hr-mib ####
  221.  
  222. RRD[[0;32mupdate 192.168.61.250/poller-perf-hr-mib.rrd N:0.014887094497681 --daemon 127.0.0.1:42217[0m]
  223. [[0;31mRRD Disabled[0m]Modules status: Global+  
  224. OS  
  225. Device  
  226.  
  227. #### Load poller module ucd-mib ####
  228. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'systemStats'[0m]
  229. systemStats = No Such Object available on this agent at this OID  
  230.  
  231. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'[0m]
  232. memTotalSwap.0 = No Such Object available on this agent at this OID
  233. memAvailSwap.0 = No Such Object available on this agent at this OID
  234. memTotalReal.0 = No Such Object available on this agent at this OID
  235. memAvailReal.0 = No Such Object available on this agent at this OID
  236. memTotalFree.0 = No Such Object available on this agent at this OID
  237. memShared.0 = No Such Object available on this agent at this OID
  238. memBuffer.0 = No Such Object available on this agent at this OID
  239. memCached.0 = No Such Object available on this agent at this OID  
  240.  
  241. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  242. laLoadInt.1 = No Such Object available on this agent at this OID
  243. laLoadInt.2 = No Such Object available on this agent at this OID
  244. laLoadInt.3 = No Such Object available on this agent at this OID  
  245.  
  246.  
  247. >> Runtime for poller module 'ucd-mib': 0.0518 seconds with 2496 bytes
  248. >> SNMP: [3/0.05s] MySQL: [0/0.00s] RRD: [0/0.00s]
  249. #### Unload poller module ucd-mib ####
  250.  
  251. RRD[[0;32mupdate 192.168.61.250/poller-perf-ucd-mib.rrd N:0.051810026168823 --daemon 127.0.0.1:42217[0m]
  252. [[0;31mRRD Disabled[0m]Modules status: Global+  
  253. OS  
  254. Device  
  255.  
  256. #### Load poller module ipSystemStats ####
  257. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  258. ipSystemStatsTable = No Such Object available on this agent at this OID  
  259.  
  260.  
  261.  
  262. >> Runtime for poller module 'ipSystemStats': 0.0404 seconds with 1872 bytes
  263. >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  264. #### Unload poller module ipSystemStats ####
  265.  
  266. RRD[[0;32mupdate 192.168.61.250/poller-perf-ipSystemStats.rrd N:0.04041600227356 --daemon 127.0.0.1:42217[0m]
  267. [[0;31mRRD Disabled[0m]Modules status: Global+  
  268. OS  
  269. Device  
  270.  
  271. #### Load poller module ports ####
  272. 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[306][0m 21.46ms]
  273.  
  274. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  275. ifXEntry = No Such Object available on this agent at this OID  
  276.  
  277. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  278. ifEntry = No Such Object available on this agent at this OID  
  279.  
  280. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  281. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  282.  
  283. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  284. dot1qPvid = No Such Object available on this agent at this OID  
  285.  
  286. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[306][0m 0.71ms]
  287.  
  288. array (
  289. )  
  290.  
  291.  
  292. >> Runtime for poller module 'ports': 0.1597 seconds with 20744 bytes
  293. >> SNMP: [4/0.14s] MySQL: [1/0.02s] RRD: [0/0.00s]
  294. #### Unload poller module ports ####
  295.  
  296. RRD[[0;32mupdate 192.168.61.250/poller-perf-ports.rrd N:0.15971708297729 --daemon 127.0.0.1:42217[0m]
  297. [[0;31mRRD Disabled[0m]Modules status: Global+  
  298. OS  
  299. Device  
  300.  
  301. #### Load poller module bgp-peers ####
  302. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[306][0m 0.94ms]
  303.  
  304.  
  305. >> Runtime for poller module 'bgp-peers': 0.0020 seconds with 11304 bytes
  306. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  307. #### Unload poller module bgp-peers ####
  308.  
  309. RRD[[0;32mupdate 192.168.61.250/poller-perf-bgp-peers.rrd N:0.00201416015625 --daemon 127.0.0.1:42217[0m]
  310. [[0;31mRRD Disabled[0m]Modules status: Global+  
  311. OS  
  312. Device  
  313.  
  314. #### Load poller module junose-atm-vp ####
  315. SQL[[1;33mSELECT * FROM `ports` AS P, `juniAtmVp` AS J WHERE P.`device_id` = ? AND J.port_id = P.port_id [0;33m[306][0m 0.95ms]
  316.  
  317.  
  318. >> Runtime for poller module 'junose-atm-vp': 0.0013 seconds with 2448 bytes
  319. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  320. #### Unload poller module junose-atm-vp ####
  321.  
  322. RRD[[0;32mupdate 192.168.61.250/poller-perf-junose-atm-vp.rrd N:0.0012960433959961 --daemon 127.0.0.1:42217[0m]
  323. [[0;31mRRD Disabled[0m]Modules status: Global-  
  324. OS  
  325. Device  
  326. Module [ toner ] disabled globally.
  327.  
  328. Modules status: Global+  
  329. OS  
  330. Device  
  331.  
  332. #### Load poller module ucd-diskio ####
  333. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[306][0m 2.45ms]
  334.  
  335.  
  336. >> Runtime for poller module 'ucd-diskio': 0.0028 seconds with 1824 bytes
  337. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  338. #### Unload poller module ucd-diskio ####
  339.  
  340. RRD[[0;32mupdate 192.168.61.250/poller-perf-ucd-diskio.rrd N:0.0028059482574463 --daemon 127.0.0.1:42217[0m]
  341. [[0;31mRRD Disabled[0m]Modules status: Global-  
  342. OS  
  343. Device  
  344. Module [ wifi ] disabled globally.
  345.  
  346. Modules status: Global+  
  347. OS  
  348. Device  
  349.  
  350. #### Load poller module wireless ####
  351. Attempting to initialize OS: sonus-sbc  
  352. OS initialized as Generic  
  353. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[306][0m 13.48ms]
  354.  
  355.  
  356. >> Runtime for poller module 'wireless': 0.0150 seconds with 167904 bytes
  357. >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [0/0.00s]
  358. #### Unload poller module wireless ####
  359.  
  360. RRD[[0;32mupdate 192.168.61.250/poller-perf-wireless.rrd N:0.014981985092163 --daemon 127.0.0.1:42217[0m]
  361. [[0;31mRRD Disabled[0m]Modules status: Global+  
  362. OS  
  363. Device  
  364.  
  365. #### Load poller module ospf ####
  366. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[306][0m 3.92ms]
  367.  
  368.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
  369. ospfGeneralGroup = No Such Object available on this agent at this OID  
  370.  
  371. array (
  372. )  
  373. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[306][0m 35.81ms]
  374.  
  375. 0
  376. >> Runtime for poller module 'ospf': 0.0780 seconds with 160800 bytes
  377. >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
  378. #### Unload poller module ospf ####
  379.  
  380. RRD[[0;32mupdate 192.168.61.250/poller-perf-ospf.rrd N:0.078013896942139 --daemon 127.0.0.1:42217[0m]
  381. [[0;31mRRD Disabled[0m]Modules status: Global+  
  382. OS  
  383. Device  
  384.  
  385. #### Load poller module cisco-ipsec-flow-monitor ####
  386.  
  387. >> Runtime for poller module 'cisco-ipsec-flow-monitor': 0.0002 seconds with 2368 bytes
  388. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  389. #### Unload poller module cisco-ipsec-flow-monitor ####
  390.  
  391. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-ipsec-flow-monitor.rrd N:0.0002140998840332 --daemon 127.0.0.1:42217[0m]
  392. [[0;31mRRD Disabled[0m]Modules status: Global+  
  393. OS  
  394. Device  
  395.  
  396. #### Load poller module cisco-remote-access-monitor ####
  397.  
  398. >> Runtime for poller module 'cisco-remote-access-monitor': 0.0001 seconds with 600 bytes
  399. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  400. #### Unload poller module cisco-remote-access-monitor ####
  401.  
  402. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-remote-access-monitor.rrd N:0.00010514259338379 --daemon 127.0.0.1:42217[0m]
  403. [[0;31mRRD Disabled[0m]Modules status: Global+  
  404. OS  
  405. Device  
  406.  
  407. #### Load poller module cisco-cef ####
  408.  
  409. >> Runtime for poller module 'cisco-cef': 0.0002 seconds with 2104 bytes
  410. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  411. #### Unload poller module cisco-cef ####
  412.  
  413. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-cef.rrd N:0.00020098686218262 --daemon 127.0.0.1:42217[0m]
  414. [[0;31mRRD Disabled[0m]Modules status: Global+  
  415. OS  
  416. Device  
  417.  
  418. #### Load poller module cisco-sla ####
  419. SQL[[1;33mSELECT * FROM `slas` WHERE `device_id` = ? AND `deleted` = 0 [0;33m[306][0m 0.8ms]
  420.  
  421.  
  422. >> Runtime for poller module 'cisco-sla': 0.0012 seconds with 4312 bytes
  423. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  424. #### Unload poller module cisco-sla ####
  425.  
  426. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-sla.rrd N:0.0012099742889404 --daemon 127.0.0.1:42217[0m]
  427. [[0;31mRRD Disabled[0m]Modules status: Global+  
  428. OS  
  429. Device  
  430.  
  431. #### Load poller module cisco-mac-accounting ####
  432.  
  433. >> Runtime for poller module 'cisco-mac-accounting': 0.0002 seconds with 1112 bytes
  434. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  435. #### Unload poller module cisco-mac-accounting ####
  436.  
  437. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-mac-accounting.rrd N:0.00023388862609863 --daemon 127.0.0.1:42217[0m]
  438. [[0;31mRRD Disabled[0m]Modules status: Global+  
  439. OS  
  440. Device  
  441.  
  442. #### Load poller module cipsec-tunnels ####
  443.  
  444. >> Runtime for poller module 'cipsec-tunnels': 0.0002 seconds with 1728 bytes
  445. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  446. #### Unload poller module cipsec-tunnels ####
  447.  
  448. RRD[[0;32mupdate 192.168.61.250/poller-perf-cipsec-tunnels.rrd N:0.0001990795135498 --daemon 127.0.0.1:42217[0m]
  449. [[0;31mRRD Disabled[0m]Modules status: Global+  
  450. OS  
  451. Device  
  452.  
  453. #### Load poller module cisco-ace-loadbalancer ####
  454.  
  455. >> Runtime for poller module 'cisco-ace-loadbalancer': 0.0001 seconds with 968 bytes
  456. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  457. #### Unload poller module cisco-ace-loadbalancer ####
  458.  
  459. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-ace-loadbalancer.rrd N:0.00011682510375977 --daemon 127.0.0.1:42217[0m]
  460. [[0;31mRRD Disabled[0m]Modules status: Global+  
  461. OS  
  462. Device  
  463.  
  464. #### Load poller module cisco-ace-serverfarms ####
  465.  
  466. >> Runtime for poller module 'cisco-ace-serverfarms': 0.0001 seconds with 936 bytes
  467. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  468. #### Unload poller module cisco-ace-serverfarms ####
  469.  
  470. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-ace-serverfarms.rrd N:0.00011420249938965 --daemon 127.0.0.1:42217[0m]
  471. [[0;31mRRD Disabled[0m]Modules status: Global+  
  472. OS  
  473. Device  
  474.  
  475. #### Load poller module cisco-asa-firewall ####
  476.  
  477. >> Runtime for poller module 'cisco-asa-firewall': 0.0001 seconds with 648 bytes
  478. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  479. #### Unload poller module cisco-asa-firewall ####
  480.  
  481. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-asa-firewall.rrd N:0.00010514259338379 --daemon 127.0.0.1:42217[0m]
  482. [[0;31mRRD Disabled[0m]Modules status: Global+  
  483. OS  
  484. Device  
  485.  
  486. #### Load poller module cisco-voice ####
  487.  
  488. >> Runtime for poller module 'cisco-voice': 0.0000 seconds with 336 bytes
  489. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  490. #### Unload poller module cisco-voice ####
  491.  
  492. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-voice.rrd N:4.6968460083008E-5 --daemon 127.0.0.1:42217[0m]
  493. [[0;31mRRD Disabled[0m]Modules status: Global+  
  494. OS  
  495. Device  
  496.  
  497. #### Load poller module cisco-cbqos ####
  498.  
  499. >> Runtime for poller module 'cisco-cbqos': 0.0002 seconds with 1296 bytes
  500. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  501. #### Unload poller module cisco-cbqos ####
  502.  
  503. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-cbqos.rrd N:0.00015091896057129 --daemon 127.0.0.1:42217[0m]
  504. [[0;31mRRD Disabled[0m]Modules status: Global+  
  505. OS  
  506. Device  
  507.  
  508. #### Load poller module cisco-otv ####
  509.  
  510. >> Runtime for poller module 'cisco-otv': 0.0003 seconds with 4336 bytes
  511. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  512. #### Unload poller module cisco-otv ####
  513.  
  514. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-otv.rrd N:0.00027608871459961 --daemon 127.0.0.1:42217[0m]
  515. [[0;31mRRD Disabled[0m]Modules status: Global+  
  516. OS  
  517. Device  
  518.  
  519. #### Load poller module cisco-vpdn ####
  520.  
  521. >> Runtime for poller module 'cisco-vpdn': 0.0001 seconds with 520 bytes
  522. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  523. #### Unload poller module cisco-vpdn ####
  524.  
  525. RRD[[0;32mupdate 192.168.61.250/poller-perf-cisco-vpdn.rrd N:8.5115432739258E-5 --daemon 127.0.0.1:42217[0m]
  526. [[0;31mRRD Disabled[0m]Modules status: Global-  
  527. OS  
  528. Device  
  529. Module [ nac ] disabled globally.
  530.  
  531. Modules status: Global+  
  532. OS  
  533. Device  
  534.  
  535. #### Load poller module netscaler-vsvr ####
  536.  
  537. >> Runtime for poller module 'netscaler-vsvr': 0.0002 seconds with 1560 bytes
  538. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  539. #### Unload poller module netscaler-vsvr ####
  540.  
  541. RRD[[0;32mupdate 192.168.61.250/poller-perf-netscaler-vsvr.rrd N:0.00024604797363281 --daemon 127.0.0.1:42217[0m]
  542. [[0;31mRRD Disabled[0m]Modules status: Global+  
  543. OS  
  544. Device  
  545.  
  546. #### Load poller module aruba-controller ####
  547.  
  548. >> Runtime for poller module 'aruba-controller': 0.0003 seconds with 2616 bytes
  549. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  550. #### Unload poller module aruba-controller ####
  551.  
  552. RRD[[0;32mupdate 192.168.61.250/poller-perf-aruba-controller.rrd N:0.00025701522827148 --daemon 127.0.0.1:42217[0m]
  553. [[0;31mRRD Disabled[0m]Modules status: Global+  
  554. OS  
  555. Device  
  556.  
  557. #### Load poller module entity-physical ####
  558. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[306][0m 0.95ms]
  559.  
  560.  
  561. >> Runtime for poller module 'entity-physical': 0.0014 seconds with 1960 bytes
  562. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  563. #### Unload poller module entity-physical ####
  564.  
  565. RRD[[0;32mupdate 192.168.61.250/poller-perf-entity-physical.rrd N:0.0013549327850342 --daemon 127.0.0.1:42217[0m]
  566. [[0;31mRRD Disabled[0m]Modules status: Global+  
  567. OS  
  568. Device  
  569.  
  570. #### Load poller module entity-state ####
  571. SQL[[1;33mSELECT S.entity_state_id, S.entStateLastChanged, P.entPhysicalIndex FROM entityState AS S LEFT JOIN entPhysical AS P USING (entPhysical_id) WHERE S.device_id=? [0;33m[306][0m 0.61ms]
  572.  
  573.  
  574. >> Runtime for poller module 'entity-state': 0.0010 seconds with 2224 bytes
  575. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  576. #### Unload poller module entity-state ####
  577.  
  578. RRD[[0;32mupdate 192.168.61.250/poller-perf-entity-state.rrd N:0.00095796585083008 --daemon 127.0.0.1:42217[0m]
  579. [[0;31mRRD Disabled[0m]Modules status: Global+  
  580. OS  
  581. Device  
  582.  
  583. #### Load poller module applications ####
  584. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[306][0m 0.64ms]
  585.  
  586.  
  587. >> Runtime for poller module 'applications': 0.0009 seconds with 1472 bytes
  588. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  589. #### Unload poller module applications ####
  590.  
  591. RRD[[0;32mupdate 192.168.61.250/poller-perf-applications.rrd N:0.00086808204650879 --daemon 127.0.0.1:42217[0m]
  592. [[0;31mRRD Disabled[0m]Modules status: Global+  
  593. OS  
  594. Device  
  595.  
  596. #### Load poller module mib ####
  597. SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ?  [0;33m[306,"poll_mib"][0m 0.25ms]
  598.  
  599. MIB: polling  
  600. SQL[[1;33mSELECT `mib`, `module` FROM device_mibs WHERE device_id = ? [0;33m[306][0m 0.38ms]
  601.  
  602.  
  603.  
  604. >> Runtime for poller module 'mib': 0.0010 seconds with 1232 bytes
  605. >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s]
  606. #### Unload poller module mib ####
  607.  
  608. RRD[[0;32mupdate 192.168.61.250/poller-perf-mib.rrd N:0.0010049343109131 --daemon 127.0.0.1:42217[0m]
  609. [[0;31mRRD Disabled[0m]Modules status: Global+  
  610. OS  
  611. Device  
  612.  
  613. #### Load poller module stp ####
  614. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[306][0m 0.43ms]
  615.  
  616. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' '-t' '1' '-r' '2' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
  617. No Such Object available on this agent at this OID  
  618.  
  619.  
  620.  
  621. >> Runtime for poller module 'stp': 0.0177 seconds with 5624 bytes
  622. >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s]
  623. #### Unload poller module stp ####
  624.  
  625. RRD[[0;32mupdate 192.168.61.250/poller-perf-stp.rrd N:0.017656803131104 --daemon 127.0.0.1:42217[0m]
  626. [[0;31mRRD Disabled[0m]Modules status: Global+  
  627. OS  
  628. Device  
  629.  
  630. #### Load poller module ntp ####
  631.  
  632. >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes
  633. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  634. #### Unload poller module ntp ####
  635.  
  636. RRD[[0;32mupdate 192.168.61.250/poller-perf-ntp.rrd N:0.00011205673217773 --daemon 127.0.0.1:42217[0m]
  637. [[0;31mRRD Disabled[0m]Modules status: Global+  
  638. OS  
  639. Device  
  640.  
  641. #### Load poller module loadbalancers ####
  642.  
  643. >> Runtime for poller module 'loadbalancers': 0.0001 seconds with 240 bytes
  644. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  645. #### Unload poller module loadbalancers ####
  646.  
  647. RRD[[0;32mupdate 192.168.61.250/poller-perf-loadbalancers.rrd N:5.6982040405273E-5 --daemon 127.0.0.1:42217[0m]
  648. [[0;31mRRD Disabled[0m]Modules status: Global+  
  649. OS  
  650. Device  
  651.  
  652. #### Load poller module mef ####
  653. MEF Links: SQL[[1;33mSELECT id, mefID, mefType, mefIdent, mefMTU, mefAdmState, mefRowState FROM mefinfo WHERE device_id = ? [0;33m[306][0m 0.53ms]
  654.  
  655.  
  656.  
  657. >> Runtime for poller module 'mef': 0.0009 seconds with 2272 bytes
  658. >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
  659. #### Unload poller module mef ####
  660.  
  661. RRD[[0;32mupdate 192.168.61.250/poller-perf-mef.rrd N:0.00088691711425781 --daemon 127.0.0.1:42217[0m]
  662. [[0;31mRRD Disabled[0m]Modules status: Global+  
  663. OS  
  664. Device  
  665.  
  666. #### Load poller module services ####
  667.  
  668. Warning: include(includes/polling/services.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 303
  669.  
  670. Warning: include(): Failed opening 'includes/polling/services.inc.php' for inclusion (include_path='.:/usr/share/php') in /opt/librenms/includes/polling/functions.inc.php on line 303
  671.  
  672. >> Runtime for poller module 'services': 0.0001 seconds with 0 bytes
  673. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
  674. #### Unload poller module services ####
  675.  
  676. RRD[[0;32mupdate 192.168.61.250/poller-perf-services.rrd N:5.793571472168E-5 --daemon 127.0.0.1:42217[0m]
  677. [[0;31mRRD Disabled[0m]### Start Device Groups ###  
  678. SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.52ms]
  679.  
  680. SQL[[1;33mSELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME LIKE "%\_id" [0;33m["ports"][0m 2.24ms]
  681.  
  682. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,ports WHERE (( ports.device_id = devices.device_id )) && devices.device_id=? AND (devices.sysName REGEXP ".*adsl.*" || ports.portName REGEXP "adsl" ) LIMIT 1 [0;33m[306][0m 2.58ms]
  683.  
  684. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.sysDescr REGEXP ".*BT FTTP.*"  && devices.sysDescr REGEXP "BT FTTP" ) LIMIT 1 [0;33m[306][0m 5.02ms]
  685.  
  686. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "IOS"  && devices.hostname != "5.159.210.4" ) LIMIT 1 [0;33m[306][0m 1.76ms]
  687.  
  688. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 1.34ms]
  689.  
  690. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*E14 9YY.*") LIMIT 1 [0;33m[306][0m 0.91ms]
  691.  
  692. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.67ms]
  693.  
  694. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*UB4 0SL.*") LIMIT 1 [0;33m[306][0m 1.67ms]
  695.  
  696. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.18ms]
  697.  
  698. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*SL1 4UF.*") LIMIT 1 [0;33m[306][0m 1.39ms]
  699.  
  700. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 3.12ms]
  701.  
  702. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*EC1V 0AB.*") LIMIT 1 [0;33m[306][0m 2.24ms]
  703.  
  704. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hardware REGEXP ".*iDRAC.*") LIMIT 1 [0;33m[306][0m 1.57ms]
  705.  
  706. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname NOT REGEXP "^5.159.208..*" && devices.hostname NOT REGEXP "^5.159.209..*" && devices.hostname NOT REGEXP "^5.159.210..*" && devices.hostname NOT REGEXP "^5.159.211..*" && devices.hostname NOT REGEXP "^5.159.212..*" && devices.hostname NOT REGEXP "^10.1.51..*" && devices.hostname NOT REGEXP "^5.159.215..*" && devices.hostname NOT REGEXP "^195.88.8..*" && devices.hostname NOT REGEXP "^195.88.9..*" && devices.hostname NOT REGEXP "^217.156.156..*" && devices.hostname NOT REGEXP "^217.156.209..*" && devices.hostname NOT REGEXP "^192.168..*" ) LIMIT 1 [0;33m[306][0m 3.54ms]
  707.  
  708. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "pfSense") LIMIT 1 [0;33m[306][0m 2.34ms]
  709.  
  710. SQL[[1;33mSELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = ? && COLUMN_NAME = ? [0;33m["locations","device_id"][0m 5.05ms]
  711.  
  712. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices,locations WHERE (( locations.id = devices.location_id && devices.device_id = devices.device_id )) && devices.device_id=? AND (locations.location REGEXP ".*E14 9YY.*" || locations.location REGEXP ".*UB4 0SL.*" || locations.location REGEXP ".*SL1 4UF.*" ) LIMIT 1 [0;33m[306][0m 0.96ms]
  713.  
  714. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.hostname REGEXP ".*192.168.200..*") LIMIT 1 [0;33m[306][0m 2.9ms]
  715.  
  716. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.os = "IOS" && devices.hostname = "5.159.210.4" ) LIMIT 1 [0;33m[306][0m 2.42ms]
  717.  
  718. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.sysName REGEXP ".*rico.*" || devices.sysDescr REGEXP ".*rico.*" ) LIMIT 1 [0;33m[306][0m 2.71ms]
  719.  
  720. SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id=? AND (devices.notes REGEXP ".*Umbee.*") LIMIT 1 [0;33m[306][0m 0.3ms]
  721.  
  722. SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[306][0m 3.04ms]
  723.  
  724. Groups Added:  
  725. Groups Removed:  
  726. ### End Device Groups ###  
  727. Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[306][0m 23ms]
  728.  
  729. uptime netstat_snmp netstat_snmp_pkt
  730. RRD[[0;32mupdate 192.168.61.250/ping-perf.rrd N:6.46 --daemon 127.0.0.1:42217[0m]
  731. [[0;31mRRD Disabled[0m]RRD[[0;32mupdate 192.168.61.250/poller-perf.rrd N:1.971 --daemon 127.0.0.1:42217[0m]
  732. [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[6873704,"6.46",1.971,306][0m 18.62ms]
  733.  
  734. Updating 192.168.61.250  
  735.  
  736. Polled in 1.971 seconds
  737. #### Start Alerts ####
  738. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[306][0m 1.71ms]
  739.  
  740. 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[306][0m 0.58ms]
  741.  
  742. SQL[[1;33mselect exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`start_recurring_dt` <= date_format(NOW(), '[1;33m-[0;35m-%d') and (`end_recurring_dt` >= date_format(NOW(), '[1;33m-[0;35m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '[0;37m'), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and 0 = 1))) as `exists` [0;33m[0,1,"0000-00-00","","","device",306,"device_group"][0m 0.66ms]
  743.  
  744. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  745.   LEFT JOIN alert_device_map d ON a.id=d.rule_id
  746.   LEFT JOIN alert_group_map g ON a.id=g.rule_id
  747.   LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  748.   WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [0;33m[306,306][0m 0.38ms]
  749.  
  750. Rule [0;35m#1 (Devices up/down):[0m  
  751. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.64ms]
  752.  
  753. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,306][0m 0.68ms]
  754.  
  755. Status: [0;34mNOCHG[0m
  756. Rule [0;35m#2 (Device rebooted):[0m  
  757. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[306][0m 1.57ms]
  758.  
  759. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,306][0m 0.45ms]
  760.  
  761. Status: [0;34mNOCHG[0m
  762. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
  763. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.6ms]
  764.  
  765. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,306][0m 0.36ms]
  766.  
  767. Status: [0;34mNOCHG[0m
  768. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
  769. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current &lt; sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.69ms]
  770.  
  771. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,306][0m 0.31ms]
  772.  
  773. Status: [0;34mNOCHG[0m
  774. Rule [0;35m#9 (Service up/down):[0m  
  775. SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 0.51ms]
  776.  
  777. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,306][0m 0.35ms]
  778.  
  779. Status: [0;34mNOCHG[0m
  780. Rule [0;35m#12 (State Sensor Critical):[0m  
  781. SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 [0;33m[306][0m 1.46ms]
  782.  
  783. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,306][0m 0.35ms]
  784.  
  785. Status: [0;34mNOCHG[0m
  786. Rule [0;35m#13 (Device up down):[0m  
  787. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.status = 1 [0;33m[306][0m 0.49ms]
  788.  
  789. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,306][0m 0.33ms]
  790.  
  791. Status: [0;34mNOCHGSQL[[1;33mSELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = ? && alert_log.rule_id = ? && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1 [0;33m[306,13][0m 0.47ms]
  792.  
  793. SQL[[1;33mUPDATE `alert_log` set `details`=? WHERE id = ? [0;33m[0m 14.59ms]
  794.  
  795. [0m
  796. Rule [0;35m#15 (BGP Session down all):[0m  
  797. SQL[[1;33mSELECT * FROM devices,bgpPeers WHERE (devices.device_id = ? AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerState != "established" AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[306][0m 1.09ms]
  798.  
  799. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,306][0m 0.87ms]
  800.  
  801. Status: [0;34mNOCHG[0m
  802. #### End Alerts ####
  803. SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"192.168.61.250","start":1554899632.8358,"duration":"2.317","devices":1,"poller":"UBUNTU-MONITOR"}[0m 71.21ms]
  804.  
  805. ./poller.php 192.168.61.250 2019-04-10 13:33:55 - 1 devices polled in 2.317 secs  
  806. SNMP [20/0.43s]: Get[11/0.14s] Getnext[0/0.00s] Walk[9/0.29s]
  807. MySQL [41/0.52s]: Cell[34/0.07s] Row[-31/-0.07s] Rows[33/0.10s] Column[1/0.00s] Update[2/0.03s] Insert[2/0.38s] Delete[0/0.00s]
  808. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
  809.  


Reply to "Untitled"