LibreNMS Pastebin service

ℹ️ Your data is safe here... unless you make the SNIP gods angry. And let's just say they have a really bad sense of humor.

poller for older card

From dittman, 4 Years ago, written in Plain Text.
URL https://p.libren.ms/view/c76d65ef
Embed
Download Paste or View Raw
  1. -bash-4.2$ ./poller.php -h tlups1 -r -f -d | ./pbin.sh
  2. Paste endpoint: https://p.libren.ms/api/create
  3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.58ms]
  4.  
  5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.46ms]
  6.  
  7. SQL[SELECT version() [] 0.31ms]
  8.  
  9. Updating os_def.cache...  
  10. Done  
  11. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'tlups1' ORDER BY `device_id` ASC [] 4.78ms]
  12.  
  13. SQL[select * from `devices` where `device_id` = ? limit 1 [30] 0.75ms]
  14.  
  15. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [30] 0.58ms]
  16.  
  17. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'tlups1'  
  18. array (
  19.   'xmt' => 3,
  20.   'rcv' => 3,
  21.   'loss' => 0,
  22.   'min' => 1.39,
  23.   'max' => 1.79,
  24.   'avg' => 1.56,
  25.   'dup' => 0,
  26.   'exitcode' => 0,
  27. )  
  28. 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":1.39,"max":1.79,"avg":1.56,"device_id":30,"debug":"[]"} 1.21ms]
  29.  
  30. SNMP Check response code: 0  
  31. Modules status: Global+  
  32. OS  
  33. Device  
  34. .*.*.0 = 54961
  35. .*.*.0 = 1111 W. 35th St., Chicago IL, 60609
  36. .*.*.0 = www.tripplite.com
  37. .*.*.0 = tlup1.int.dittman.net
  38. .*.*.0 = .*.4.1.850.1
  39. .*.*.0 = POWERALERT 12  
  40.  
  41. snmpEngineTime.0 = No Such Object available on this agent at this OID
  42. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  43.  
  44. Uptime seconds: 550  
  45. SQL[select * from `locations` where (`location` = ?) limit 1 ["1111 W. 35th St., Chicago IL, 60609"] 0.67ms]
  46.  
  47. Modules status: Global-  
  48. OS  
  49. Device  
  50. Modules status: Global+  
  51. OS  
  52. Device  
  53. SU1500RTXL2Ua  
  54.  
  55. "home"  
  56.  
  57. tlups1  
  58.  
  59. 9725AY0AC699600158  
  60.  
  61. 12.04.0047  
  62.  
  63. Modules status: Global+  
  64. OS  
  65. Device  
  66. SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [30] 0.96ms]
  67.  
  68. array (
  69. )  
  70. Modules status: Global+  
  71. OS  
  72. Device  
  73. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [30] 0.75ms]
  74.  
  75. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["charge",30] 0.74ms]
  76.  
  77. .*.*.2.4.0 = 100  
  78.  
  79. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["frequency",30] 1.09ms]
  80.  
  81. .*.*.*.1 = 600
  82. .*.*.4.2.0 = 600
  83. .*.*.5.1.0 = 600  
  84.  
  85. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["load",30] 1.01ms]
  86.  
  87. .*.*.*.1 = 24  
  88.  
  89. SQL[UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [24,25,"Load",35] 1.34ms]
  90.  
  91. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["runtime",30] 0.91ms]
  92.  
  93. .*.*.2.2.0 = 0
  94. .*.*.2.3.0 = 31  
  95.  
  96. SQL[UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [31,28,"Runtime",37] 1.36ms]
  97.  
  98. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["state",30] 0.87ms]
  99.  
  100. .*.*.2.1.0 = 2
  101. .*.*.4.1.0 = 3  
  102.  
  103. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["temperature",30] 1.17ms]
  104.  
  105. .*.*.2.7.0 = 42  
  106.  
  107. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["voltage",30] 1.06ms]
  108.  
  109. .*.*.2.5.0 = 540
  110. .*.*.*.1 = 120
  111. .*.*.*.1 = 124
  112. .*.*.*.1 = 124  
  113.  
  114. Modules status: Global+  
  115. OS  
  116. Device  
  117. Attempting to initialize OS: poweralert  
  118. OS initialized as Generic  
  119. SQL[SELECT * FROM processors WHERE device_id=? [30] 0.71ms]
  120.  
  121. Modules status: Global+  
  122. OS  
  123. Device  
  124. SQL[SELECT * FROM mempools WHERE device_id = ? [30] 0.55ms]
  125.  
  126. Modules status: Global+  
  127. OS  
  128. Device  
  129. SQL[SELECT * FROM storage WHERE device_id = ? [30] 0.58ms]
  130.  
  131. Modules status: Global+  
  132. OS  
  133. Device  
  134. icmpInMsgs.0 = 172
  135. icmpInErrors.0 = 0
  136. icmpInDestUnreachs.0 = 1
  137. icmpInTimeExcds.0 = 0
  138. icmpInParmProbs.0 = 0
  139. icmpInSrcQuenchs.0 = 0
  140. icmpInRedirects.0 = 0
  141. icmpInEchos.0 = 171
  142. icmpInEchoReps.0 = 0
  143. icmpInTimestamps.0 = 0
  144. icmpInTimestampReps.0 = 0
  145. icmpInAddrMasks.0 = 0
  146. icmpInAddrMaskReps.0 = 0
  147. icmpOutMsgs.0 = 171
  148. icmpOutErrors.0 = 0
  149. icmpOutDestUnreachs.0 = 0
  150. icmpOutTimeExcds.0 = 0
  151. icmpOutParmProbs.0 = 0
  152. icmpOutSrcQuenchs.0 = 0
  153. icmpOutRedirects.0 = 0
  154. icmpOutEchos.0 = 0
  155. icmpOutEchoReps.0 = 171
  156. icmpOutTimestamps.0 = 0
  157. icmpOutTimestampReps.0 = 0
  158. icmpOutAddrMasks.0 = 0
  159. icmpOutAddrMaskReps.0 = 0  
  160.  
  161. ipForwDatagrams.0 = 0
  162. ipInDelivers.0 = 42625
  163. ipInReceives.0 = 42759
  164. ipOutRequests.0 = 3567
  165. ipInDiscards.0 = 0
  166. ipOutDiscards.0 = 0
  167. ipOutNoRoutes.0 = 0
  168. ipReasmReqds.0 = 0
  169. ipReasmOKs.0 = 0
  170. ipReasmFails.0 = 0
  171. ipFragOKs.0 = 0
  172. ipFragFails.0 = 0
  173. ipFragCreates.0 = 0
  174. ipInUnknownProtos.0 = 0
  175. ipInHdrErrors.0 = 0
  176. ipInAddrErrors.0 = 134  
  177.  
  178. No Such Object available on this agent at this OID  
  179.  
  180. snmpInPkts.0 = 3394
  181. snmpOutPkts.0 = 3393
  182. snmpInBadVersions.0 = 0
  183. snmpInBadCommunityNames.0 = 0
  184. snmpInBadCommunityUses.0 = 0
  185. snmpInASNParseErrs.0 = 0
  186. snmpInTooBigs.0 = 0
  187. snmpInNoSuchNames.0 = 0
  188. snmpInBadValues.0 = 0
  189. snmpInReadOnlys.0 = 0
  190. snmpInGenErrs.0 = 0
  191. snmpInTotalReqVars.0 = 9574
  192. snmpInTotalSetVars.0 = 0
  193. snmpInGetRequests.0 = 2274
  194. snmpInGetNexts.0 = 636
  195. snmpInSetRequests.0 = 0
  196. snmpInGetResponses.0 = 0
  197. snmpInTraps.0 = 0
  198. snmpOutTooBigs.0 = 0
  199. snmpOutNoSuchNames.0 = 503
  200. snmpOutBadValues.0 = 0
  201. snmpOutGenErrs.0 = 0
  202. snmpOutGetRequests.0 = 0
  203. snmpOutGetNexts.0 = 0
  204. snmpOutSetRequests.0 = 0
  205. snmpOutGetResponses.0 = 3395
  206. snmpOutTraps.0 = 0
  207. snmpEnableAuthenTraps.0 = enabled
  208. snmpSilentDrops.0 = 0
  209. snmpProxyDrops.0 = 0  
  210.  
  211. tcpActiveOpens.0 = 0
  212. tcpPassiveOpens.0 = 0
  213. tcpAttemptFails.0 = 0
  214. tcpEstabResets.0 = 0
  215. tcpCurrEstab.0 = 0
  216. tcpInSegs.0 = 0
  217. tcpOutSegs.0 = 0
  218. tcpRetransSegs.0 = 0
  219. tcpInErrs.0 = 0
  220. tcpOutRsts.0 = 0  
  221.  
  222. mib-* = 42412
  223. mib-* = 42412  
  224.  
  225. udpInDatagrams.0 = 42413
  226. udpOutDatagrams.0 = 3404
  227. udpInErrors.0 = 0
  228. udpNoPorts.0 = 39011  
  229.  
  230. Modules status: Global+  
  231. OS  
  232. Device  
  233. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  234. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  235.  
  236. Modules status: Global+  
  237. OS  
  238. Device  
  239. systemStats = No Such Object available on this agent at this OID  
  240.  
  241. memTotalSwap.0 = No Such Object available on this agent at this OID
  242. memAvailSwap.0 = No Such Object available on this agent at this OID
  243. memTotalReal.0 = No Such Object available on this agent at this OID
  244. memAvailReal.0 = No Such Object available on this agent at this OID
  245. memTotalFree.0 = No Such Object available on this agent at this OID
  246. memShared.0 = No Such Object available on this agent at this OID
  247. memBuffer.0 = No Such Object available on this agent at this OID
  248. memCached.0 = No Such Object available on this agent at this OID  
  249.  
  250. laLoadInt.1 = No Such Object available on this agent at this OID
  251. laLoadInt.2 = No Such Object available on this agent at this OID
  252. laLoadInt.3 = No Such Object available on this agent at this OID  
  253.  
  254. Modules status: Global+  
  255. OS  
  256. Device  
  257. ipSystemStatsTable = No Such Object available on this agent at this OID  
  258.  
  259. Modules status: Global+  
  260. OS  
  261. Device  
  262. 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 [30] 1.98ms]
  263.  
  264. ifXEntry = No Such Object available on this agent at this OID  
  265.  
  266. ifIndex.1 = 1
  267. ifIndex.2 = 2
  268. ifIndex.3 = 3
  269. ifIndex.4 = 4
  270. ifDescr.1 = lo
  271. ifDescr.2 = eth0
  272. ifDescr.3 = ppp0
  273. ifDescr.4 = ppp1
  274. ifType.1 = other
  275. ifType.2 = iso88023Csmacd
  276. ifType.3 = ppp
  277. ifType.4 = ppp
  278. ifMtu.1 = 1500
  279. ifMtu.2 = 1500
  280. ifMtu.3 = 1500
  281. ifMtu.4 = 1500
  282. ifSpeed.1 = 0
  283. ifSpeed.2 = 100000000
  284. ifSpeed.3 = 9600
  285. ifSpeed.4 = 9600
  286. ifPhysAddress.1 = 0
  287. ifPhysAddress.2 = 0:6:67:21:54:b1
  288. ifPhysAddress.3 = 0
  289. ifPhysAddress.4 = 0
  290. ifAdminStatus.1 = up
  291. ifAdminStatus.2 = up
  292. ifAdminStatus.3 = down
  293. ifAdminStatus.4 = down
  294. ifOperStatus.1 = up
  295. ifOperStatus.2 = up
  296. ifOperStatus.3 = down
  297. ifOperStatus.4 = down
  298. ifLastChange.1 = 0
  299. ifLastChange.2 = 0
  300. ifLastChange.3 = 0
  301. ifLastChange.4 = 0
  302. ifInOctets.1 = 0
  303. ifInOctets.2 = 6944560
  304. ifInOctets.3 = 0
  305. ifInOctets.4 = 0
  306. ifInUcastPkts.1 = 0
  307. ifInUcastPkts.2 = 3649
  308. ifInUcastPkts.3 = 0
  309. ifInUcastPkts.4 = 0
  310. ifInNUcastPkts.1 = 0
  311. ifInNUcastPkts.2 = 53419
  312. ifInNUcastPkts.3 = 0
  313. ifInNUcastPkts.4 = 0
  314. ifInDiscards.1 = 0
  315. ifInDiscards.2 = 0
  316. ifInDiscards.3 = 0
  317. ifInDiscards.4 = 0
  318. ifInErrors.1 = 0
  319. ifInErrors.2 = 8246
  320. ifInErrors.3 = 0
  321. ifInErrors.4 = 0
  322. ifInUnknownProtos.1 = 0
  323. ifInUnknownProtos.2 = 0
  324. ifInUnknownProtos.3 = 0
  325. ifInUnknownProtos.4 = 0
  326. ifOutOctets.1 = 0
  327. ifOutOctets.2 = 439251
  328. ifOutOctets.3 = 0
  329. ifOutOctets.4 = 0
  330. ifOutUcastPkts.1 = 0
  331. ifOutUcastPkts.2 = 3648
  332. ifOutUcastPkts.3 = 0
  333. ifOutUcastPkts.4 = 0
  334. ifOutNUcastPkts.1 = 0
  335. ifOutNUcastPkts.2 = 4
  336. ifOutNUcastPkts.3 = 0
  337. ifOutNUcastPkts.4 = 0
  338. ifOutDiscards.1 = 0
  339. ifOutDiscards.2 = 0
  340. ifOutDiscards.3 = 0
  341. ifOutDiscards.4 = 0
  342. ifOutErrors.1 = 0
  343. ifOutErrors.2 = 0
  344. ifOutErrors.3 = 0
  345. ifOutErrors.4 = 0
  346. ifOutQLen.1 = 0
  347. ifOutQLen.2 = 0
  348. ifOutQLen.3 = 0
  349. ifOutQLen.4 = 0
  350. ifSpecific.1 = zeroDotZero
  351. ifSpecific.2 = zeroDotZero
  352. ifSpecific.3 = zeroDotZero
  353. ifSpecific.4 = zeroDotZero  
  354.  
  355. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  356.  
  357. dot1qPvid = No Such Object available on this agent at this OID  
  358.  
  359. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [30] 0.87ms]
  360.  
  361. array (
  362.   1 =>
  363.   array (
  364.     'ifIndex' => '1',
  365.     'ifDescr' => 'lo',
  366.     'ifType' => 'other',
  367.     'ifMtu' => '1500',
  368.     'ifSpeed' => '0',
  369.     'ifPhysAddress' => '0',
  370.     'ifAdminStatus' => 'up',
  371.     'ifOperStatus' => 'up',
  372.     'ifLastChange' => '0',
  373.     'ifInOctets' => '0',
  374.     'ifInUcastPkts' => '0',
  375.     'ifInNUcastPkts' => '0',
  376.     'ifInDiscards' => '0',
  377.     'ifInErrors' => '0',
  378.     'ifInUnknownProtos' => '0',
  379.     'ifOutOctets' => '0',
  380.     'ifOutUcastPkts' => '0',
  381.     'ifOutNUcastPkts' => '0',
  382.     'ifOutDiscards' => '0',
  383.     'ifOutErrors' => '0',
  384.     'ifOutQLen' => '0',
  385.     'ifSpecific' => 'zeroDotZero',
  386.   ),
  387.   2 =>
  388.   array (
  389.     'ifIndex' => '2',
  390.     'ifDescr' => 'eth0',
  391.     'ifType' => 'iso88023Csmacd',
  392.     'ifMtu' => '1500',
  393.     'ifSpeed' => '100000000',
  394.     'ifPhysAddress' => '0:6:67:21:54:b1',
  395.     'ifAdminStatus' => 'up',
  396.     'ifOperStatus' => 'up',
  397.     'ifLastChange' => '0',
  398.     'ifInOctets' => '6944560',
  399.     'ifInUcastPkts' => '3649',
  400.     'ifInNUcastPkts' => '53419',
  401.     'ifInDiscards' => '0',
  402.     'ifInErrors' => '8246',
  403.     'ifInUnknownProtos' => '0',
  404.     'ifOutOctets' => '439251',
  405.     'ifOutUcastPkts' => '3648',
  406.     'ifOutNUcastPkts' => '4',
  407.     'ifOutDiscards' => '0',
  408.     'ifOutErrors' => '0',
  409.     'ifOutQLen' => '0',
  410.     'ifSpecific' => 'zeroDotZero',
  411.   ),
  412.   3 =>
  413.   array (
  414.     'ifIndex' => '3',
  415.     'ifDescr' => 'ppp0',
  416.     'ifType' => 'ppp',
  417.     'ifMtu' => '1500',
  418.     'ifSpeed' => '9600',
  419.     'ifPhysAddress' => '0',
  420.     'ifAdminStatus' => 'down',
  421.     'ifOperStatus' => 'down',
  422.     'ifLastChange' => '0',
  423.     'ifInOctets' => '0',
  424.     'ifInUcastPkts' => '0',
  425.     'ifInNUcastPkts' => '0',
  426.     'ifInDiscards' => '0',
  427.     'ifInErrors' => '0',
  428.     'ifInUnknownProtos' => '0',
  429.     'ifOutOctets' => '0',
  430.     'ifOutUcastPkts' => '0',
  431.     'ifOutNUcastPkts' => '0',
  432.     'ifOutDiscards' => '0',
  433.     'ifOutErrors' => '0',
  434.     'ifOutQLen' => '0',
  435.     'ifSpecific' => 'zeroDotZero',
  436.   ),
  437.   4 =>
  438.   array (
  439.     'ifIndex' => '4',
  440.     'ifDescr' => 'ppp1',
  441.     'ifType' => 'ppp',
  442.     'ifMtu' => '1500',
  443.     'ifSpeed' => '9600',
  444.     'ifPhysAddress' => '0',
  445.     'ifAdminStatus' => 'down',
  446.     'ifOperStatus' => 'down',
  447.     'ifLastChange' => '0',
  448.     'ifInOctets' => '0',
  449.     'ifInUcastPkts' => '0',
  450.     'ifInNUcastPkts' => '0',
  451.     'ifInDiscards' => '0',
  452.     'ifInErrors' => '0',
  453.     'ifInUnknownProtos' => '0',
  454.     'ifOutOctets' => '0',
  455.     'ifOutUcastPkts' => '0',
  456.     'ifOutNUcastPkts' => '0',
  457.     'ifOutDiscards' => '0',
  458.     'ifOutErrors' => '0',
  459.     'ifOutQLen' => '0',
  460.     'ifSpecific' => 'zeroDotZero',
  461.   ),
  462. )  
  463.  valid  
  464.  valid  
  465.  valid  
  466.  valid  
  467. ifInOctets  
  468. ifOutOctets  
  469. ifInUcastPkts  
  470. ifOutUcastPkts  
  471. ifInBroadcastPkts  
  472. ifOutBroadcastPkts  
  473. ifInMulticastPkts  
  474. ifOutMulticastPkts  
  475. ifSpeed  
  476.  Using ifDescr as ifAlias  
  477.  Using ifDescr as ifName  
  478.  
  479.  ifInOctets (0 B) 0 Bps 225 secs  
  480.  
  481.  ifOutOctets (0 B) 0 Bps 225 secs  
  482.  
  483.  ifInErrors (0 B) 0 Bps 225 secs  
  484.  
  485.  ifOutErrors (0 B) 0 Bps 225 secs  
  486.  
  487.  ifInUcastPkts (0 B) 0 Bps 225 secs  
  488.  
  489.  ifOutUcastPkts (0 B) 0 Bps 225 secs  
  490.  
  491.  ifInNUcastPkts (0 B) 0 Bps 225 secs  
  492.  
  493.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
  494.  
  495.  ifInDiscards (0 B) 0 Bps 225 secs  
  496.  
  497.  ifOutDiscards (0 B) 0 Bps 225 secs  
  498.  
  499.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
  500.  
  501.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
  502.  
  503.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
  504.  
  505.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
  506.  
  507.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
  508. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,188] 1.26ms]
  509.  
  510. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,188] 1.15ms]
  511.  
  512. 1 updated  
  513. ifInOctets  
  514. ifOutOctets  
  515. ifInUcastPkts  
  516. ifOutUcastPkts  
  517. ifInBroadcastPkts  
  518. ifOutBroadcastPkts  
  519. ifInMulticastPkts  
  520. ifOutMulticastPkts  
  521. ifSpeed  
  522.  Using ifDescr as ifAlias  
  523.  Using ifDescr as ifName  
  524.  
  525.  ifInOctets (324989 B) 1444.3955555556 Bps 225 secs  
  526.  
  527.  ifOutOctets (35777 B) 159.00888888889 Bps 225 secs  
  528.  
  529.  ifInErrors (231 B) 1.0266666666667 Bps 225 secs  
  530.  
  531.  ifOutErrors (0 B) 0 Bps 225 secs  
  532.  
  533.  ifInUcastPkts (257 B) 1.1422222222222 Bps 225 secs  
  534.  
  535.  ifOutUcastPkts (257 B) 1.1422222222222 Bps 225 secs  
  536.  
  537.  ifInNUcastPkts (2602 B) 11.564444444444 Bps 225 secs  
  538.  
  539.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
  540.  
  541.  ifInDiscards (0 B) 0 Bps 225 secs  
  542.  
  543.  ifOutDiscards (0 B) 0 Bps 225 secs  
  544.  
  545.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
  546.  
  547.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
  548.  
  549.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
  550.  
  551.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
  552.  
  553.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
  554. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","6944560",6619571,1444.3955555555556,324989,"439251",403474,159.0088888888889,35777,"8246",8015,1.0266666666666666,231,"0",0,0,0,"3649",3392,1.1422222222222222,257,"3648",3391,1.1422222222222222,257,189] 1.12ms]
  555.  
  556. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["53419",50817,11.564444444444444,2602,"4",4,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,189] 1.03ms]
  557.  
  558. 2 updated  
  559. ifInOctets  
  560. ifOutOctets  
  561. ifInUcastPkts  
  562. ifOutUcastPkts  
  563. ifInBroadcastPkts  
  564. ifOutBroadcastPkts  
  565. ifInMulticastPkts  
  566. ifOutMulticastPkts  
  567. ifSpeed  
  568.  Using ifDescr as ifAlias  
  569.  Using ifDescr as ifName  
  570.  
  571.  ifInOctets (0 B) 0 Bps 225 secs  
  572.  
  573.  ifOutOctets (0 B) 0 Bps 225 secs  
  574.  
  575.  ifInErrors (0 B) 0 Bps 225 secs  
  576.  
  577.  ifOutErrors (0 B) 0 Bps 225 secs  
  578.  
  579.  ifInUcastPkts (0 B) 0 Bps 225 secs  
  580.  
  581.  ifOutUcastPkts (0 B) 0 Bps 225 secs  
  582.  
  583.  ifInNUcastPkts (0 B) 0 Bps 225 secs  
  584.  
  585.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
  586.  
  587.  ifInDiscards (0 B) 0 Bps 225 secs  
  588.  
  589.  ifOutDiscards (0 B) 0 Bps 225 secs  
  590.  
  591.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
  592.  
  593.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
  594.  
  595.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
  596.  
  597.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
  598.  
  599.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
  600. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,190] 1.12ms]
  601.  
  602. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,190] 1.01ms]
  603.  
  604. 1 updated  
  605. ifInOctets  
  606. ifOutOctets  
  607. ifInUcastPkts  
  608. ifOutUcastPkts  
  609. ifInBroadcastPkts  
  610. ifOutBroadcastPkts  
  611. ifInMulticastPkts  
  612. ifOutMulticastPkts  
  613. ifSpeed  
  614.  Using ifDescr as ifAlias  
  615.  Using ifDescr as ifName  
  616.  
  617.  ifInOctets (0 B) 0 Bps 225 secs  
  618.  
  619.  ifOutOctets (0 B) 0 Bps 225 secs  
  620.  
  621.  ifInErrors (0 B) 0 Bps 225 secs  
  622.  
  623.  ifOutErrors (0 B) 0 Bps 225 secs  
  624.  
  625.  ifInUcastPkts (0 B) 0 Bps 225 secs  
  626.  
  627.  ifOutUcastPkts (0 B) 0 Bps 225 secs  
  628.  
  629.  ifInNUcastPkts (0 B) 0 Bps 225 secs  
  630.  
  631.  ifOutNUcastPkts (0 B) 0 Bps 225 secs  
  632.  
  633.  ifInDiscards (0 B) 0 Bps 225 secs  
  634.  
  635.  ifOutDiscards (0 B) 0 Bps 225 secs  
  636.  
  637.  ifInUnknownProtos (0 B) 0 Bps 225 secs  
  638.  
  639.  ifInBroadcastPkts (0 B) 0 Bps 225 secs  
  640.  
  641.  ifOutBroadcastPkts (0 B) 0 Bps 225 secs  
  642.  
  643.  ifInMulticastPkts (0 B) 0 Bps 225 secs  
  644.  
  645.  ifOutMulticastPkts (0 B) 0 Bps 225 secs  
  646. SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,191] 1.17ms]
  647.  
  648. SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,191] 1ms]
  649.  
  650. 1 updated  
  651. Modules status: Global+  
  652. OS  
  653. Device  
  654. SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [30] 0.67ms]
  655.  
  656. Modules status: Global+  
  657. OS  
  658. Device  
  659. SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [30] 0.71ms]
  660.  
  661. Modules status: Global-  
  662. OS  
  663. Device  
  664. Modules status: Global-  
  665. OS  
  666. Device  
  667. Modules status: Global+  
  668. OS  
  669. Device  
  670. SQL[SELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [30] 0.49ms]
  671.  
  672. Modules status: Global-  
  673. OS  
  674. Device  
  675. Modules status: Global+  
  676. OS  
  677. Device  
  678. Attempting to initialize OS: poweralert  
  679. OS initialized as Generic  
  680. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [30] 0.69ms]
  681.  
  682. Modules status: Global+  
  683. OS  
  684. Device  
  685. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 0.7ms]
  686.  
  687. ospfGeneralGroup = No Such Object available on this agent at this OID  
  688.  
  689. array (
  690. )  
  691. SQL[delete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [30] 0.63ms]
  692.  
  693. Modules status: Global-  
  694. OS  
  695. Device  
  696. Modules status: Global-  
  697. OS  
  698. Device  
  699. Modules status: Global-  
  700. OS  
  701. Device  
  702. Modules status: Global-  
  703. OS  
  704. Device  
  705. Modules status: Global-  
  706. OS  
  707. Device  
  708. Modules status: Global-  
  709. OS  
  710. Device  
  711. Modules status: Global-  
  712. OS  
  713. Device  
  714. Modules status: Global-  
  715. OS  
  716. Device  
  717. Modules status: Global-  
  718. OS  
  719. Device  
  720. Modules status: Global-  
  721. OS  
  722. Device  
  723. Modules status: Global-  
  724. OS  
  725. Device  
  726. Modules status: Global-  
  727. OS  
  728. Device  
  729. Modules status: Global-  
  730. OS  
  731. Device  
  732. Modules status: Global-  
  733. OS  
  734. Device  
  735. Modules status: Global-  
  736. OS  
  737. Device  
  738. Modules status: Global-  
  739. OS  
  740. Device  
  741. Modules status: Global-  
  742. OS  
  743. Device  
  744. Modules status: Global+  
  745. OS  
  746. Device  
  747. SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [30] 0.61ms]
  748.  
  749. Modules status: Global-  
  750. OS  
  751. Device  
  752. Modules status: Global+  
  753. OS  
  754. Device  
  755. SQL[SELECT * FROM `applications` WHERE `device_id`  = ? [30] 0.63ms]
  756.  
  757. Modules status: Global-  
  758. OS  
  759. Device  
  760. Modules status: Global+  
  761. OS  
  762. Device  
  763. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [30] 0.61ms]
  764.  
  765. No Such Object available on this agent at this OID  
  766.  
  767. Modules status: Global+  
  768. OS  
  769. Device  
  770. Modules status: Global-  
  771. OS  
  772. Device  
  773. Modules status: Global-  
  774. OS  
  775. Device  
  776. Modules status: Global+  
  777. OS  
  778. Device  
  779. Attempting to initialize OS: poweralert  
  780. OS initialized as Generic  
  781. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 1.01ms]
  782.  
  783. SQL[select * from `device_groups` [] 0.6ms]
  784.  
  785. SQL[select * from `device_group_device` where `device_id` = ? [30] 0.48ms]
  786.  
  787. Groups Added:  
  788. Groups Removed:  
  789. SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [30] 0.58ms]
  790.  
  791. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [550,1.56,3.974,30] 1.3ms]
  792.  
  793. Updating tlups1  
  794. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 0.71ms]
  795.  
  796. 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` = ? [30] 0.61ms]
  797.  
  798. 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 0 = 1))) as `exists` [0,1,"0000-00-00","","","device",30,"device_group"] 1.02ms]
  799.  
  800. SQL[SELECT DISTINCT a.* FROM alert_rules a
  801.         LEFT JOIN alert_device_map d ON a.id=d.rule_id
  802.         LEFT JOIN alert_group_map g ON a.id=g.rule_id
  803.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
  804.         WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [30,30] 2.12ms]
  805.  
  806. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"tlups1","start":1577149451.081733,"duration":"4.470","devices":1,"poller":null} 7.49ms]
  807.  
  808. ./poller.php tlups1 2019-12-23 19:04:15 - 1 devices polled in 4.470 secs  
  809. title:
  810. name: librenms
  811. private: 1
  812. expire: 0
  813. https://p.libren.ms/view/f7f10dc0
  814.  

Reply to "poller for older card"

captcha