API tools faq
paste
Guest User

Untitled

a guest
Apr 27th, 2016
203
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.78 KB | None | 0 0
raw download clone embed print report
  1. ./discovery.php -d -m bgp-peers -h usasr01
  2. DEBUG!
  3.  
  4. SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
  5. SQL RUNTIME[0.00027800s]
  6.  
  7. SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
  8. SQL RUNTIME[0.00018907s]
  9.  
  10. SQL[SELECT * FROM `config`]
  11. SQL RUNTIME[0.00019598s]
  12.  
  13. ___ _ _
  14. / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
  15. | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
  16. | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
  17. \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|
  18. Observium Professional 0.16.3.7703
  19. http://www.observium.org
  20.  
  21.  
  22. CMD[/opt/observium/scripts/distro]
  23.  
  24. CMD EXITCODE[0]
  25. CMD RUNTIME[0.0304s]
  26. STDOUT[
  27. Linux|2.6.32-573.12.1.el6.x86_64|amd64|CentOS|6.7
  28. ]
  29.  
  30. CMD[/usr/bin/env python --version 2>&1]
  31.  
  32. CMD EXITCODE[0]
  33. CMD RUNTIME[0.0021s]
  34. CMD EXITDELAY[10ms]
  35. STDOUT[
  36. Python 2.6.6
  37. ]
  38.  
  39. SQL[SELECT version();]
  40. SQL RUNTIME[0.00025105s]
  41.  
  42. CMD[/usr/bin/snmpget --version 2>&1]
  43.  
  44. CMD EXITCODE[0]
  45. CMD RUNTIME[0.0026s]
  46. CMD EXITDELAY[10ms]
  47. STDOUT[
  48. NET-SNMP version: 5.5
  49. ]
  50.  
  51. CMD[/usr/bin/rrdtool --version |head -n1]
  52.  
  53. CMD EXITCODE[0]
  54. CMD RUNTIME[0.02s]
  55. CMD EXITDELAY[10ms]
  56. STDOUT[
  57. RRDtool 1.3.8 Copyright 1997-2009 by Tobias Oetiker <[email protected]>
  58. ]
  59.  
  60. CMD[date "+%:z"]
  61.  
  62. CMD EXITCODE[0]
  63. CMD RUNTIME[0.0024s]
  64. CMD EXITDELAY[10ms]
  65. STDOUT[
  66. +02:00
  67. ]
  68.  
  69. SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
  70. SQL RUNTIME[0.00028205s]
  71.  
  72. CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
  73.  
  74. CMD EXITCODE[0]
  75. CMD RUNTIME[0.0462s]
  76. CMD EXITDELAY[10ms]
  77. STDOUT[
  78.  
  79. ]
  80.  
  81. CMD[/usr/bin/env httpd -v | awk '/Server version:/ {print $3}']
  82.  
  83. CMD EXITCODE[0]
  84. CMD RUNTIME[0.0689s]
  85. CMD EXITDELAY[10ms]
  86. STDOUT[
  87. Apache/2.2.15
  88. ]
  89.  
  90. SQL[SELECT @@sql_mode;]
  91. SQL RUNTIME[0.08323383s]
  92.  
  93. SQL[SHOW VARIABLES LIKE 'character_set_connection']
  94. SQL RUNTIME[0.06521893s]
  95.  
  96. ##### Software versions #####
  97.  
  98. o OS Linux 2.6.32-573.12.1.el6.x86_64 [amd64] (CentOS 6.7)
  99. o Apache 2.2.15
  100. o PHP 5.3.3
  101. o Python 2.6.6
  102. o MySQL 5.1.73-14.12 (extension: mysqli 5.1.73)
  103. o SNMP NET-SNMP 5.5
  104. o RRDtool 1.3.8
  105.  
  106. ##### MySQL mode #####
  107.  
  108. o MySQL
  109.  
  110. ##### Charset info #####
  111.  
  112. o PHP UTF-8
  113. o MySQL utf8
  114.  
  115. ##### Timezones info #####
  116.  
  117. o Date Wednesday, 27-Apr-16 14:18:58 CEST
  118. o PHP +02:00
  119. o MySQL +02:00
  120.  
  121.  
  122. SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
  123. SQL RUNTIME[0.00021100s]
  124.  
  125. SQL[SELECT COUNT(*) FROM ports]
  126. SQL RUNTIME[0.00044107s]
  127.  
  128. SQL[SELECT COUNT(*) FROM devices]
  129. SQL RUNTIME[0.00009418s]
  130.  
  131. SQL[SELECT COUNT(*) FROM `sensors`]
  132. SQL RUNTIME[0.00016499s]
  133.  
  134. SQL[SELECT COUNT(*) FROM `services`]
  135. SQL RUNTIME[0.00014496s]
  136.  
  137. SQL[SELECT COUNT(*) FROM `applications`]
  138. SQL RUNTIME[0.00011301s]
  139.  
  140. SQL[SELECT COUNT(*) FROM `bgpPeers`]
  141. SQL RUNTIME[0.00009012s]
  142.  
  143. SQL[SELECT COUNT(*) FROM `ospf_ports`]
  144. SQL RUNTIME[0.00009584s]
  145.  
  146. SQL[SELECT COUNT(*) FROM `eigrp_ports`]
  147. SQL RUNTIME[0.00009418s]
  148.  
  149. SQL[SELECT COUNT(*) FROM `ipsec_tunnels`]
  150. SQL RUNTIME[0.00008297s]
  151.  
  152. SQL[SELECT COUNT(*) FROM `munin_plugins`]
  153. SQL RUNTIME[0.00012803s]
  154.  
  155. SQL[SELECT COUNT(*) FROM `pseudowires`]
  156. SQL RUNTIME[0.00009513s]
  157.  
  158. SQL[SELECT COUNT(*) FROM `vrfs`]
  159. SQL RUNTIME[0.00008202s]
  160.  
  161. SQL[SELECT COUNT(*) FROM `vminfo`]
  162. SQL RUNTIME[0.00007296s]
  163.  
  164. SQL[SELECT COUNT(*) FROM `users`]
  165. SQL RUNTIME[0.00013304s]
  166.  
  167. SQL[SELECT COUNT(*) FROM `bills`]
  168. SQL RUNTIME[0.00012183s]
  169.  
  170. SQL[SELECT COUNT(*) FROM `alert_table`]
  171. SQL RUNTIME[0.00021386s]
  172.  
  173. SQL[SELECT COUNT(*) FROM `alert_tests`]
  174. SQL RUNTIME[0.00009799s]
  175.  
  176. SQL[SELECT COUNT(*) FROM `slas`]
  177. SQL RUNTIME[0.00008607s]
  178.  
  179. SQL[SELECT COUNT(*) FROM `status`]
  180. SQL RUNTIME[0.00010419s]
  181.  
  182. SQL[SELECT COUNT(*) FROM `groups`]
  183. SQL RUNTIME[0.00008798s]
  184.  
  185. SQL[SELECT COUNT(*) FROM `group_table`]
  186. SQL RUNTIME[0.00007892s]
  187.  
  188. SQL[SELECT SUM(`last_polled_timetaken`) FROM devices]
  189. SQL RUNTIME[0.00012302s]
  190.  
  191. SQL[SELECT SUM(`last_discovered_timetaken`) FROM devices]
  192. SQL RUNTIME[0.00015306s]
  193.  
  194. CMD[DISTROFORMAT=export /opt/observium/scripts/distro]
  195.  
  196. CMD EXITCODE[0]
  197. CMD RUNTIME[0.0331s]
  198. STDOUT[
  199. OS=Linux
  200. KERNEL=2.6.32-573.12.1.el6.x86_64
  201. ARCH=amd64
  202. DISTRO=CentOS
  203. VERSION=6.7
  204. DISTROVER=6.7
  205. SCRIPTVER=1.1.0
  206. ]
  207.  
  208. SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`]
  209. SQL RUNTIME[0.00088501s]
  210.  
  211. SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`]
  212. SQL RUNTIME[0.00025916s]
  213.  
  214. SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`]
  215. SQL RUNTIME[0.00042796s]
  216.  
  217. SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`]
  218. SQL RUNTIME[0.00020099s]
  219.  
  220. SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'unique_id';]
  221. SQL RUNTIME[0.00012803s]
  222.  
  223. REQUEST[http://www.observium.org/versions.php]
  224. REQUEST STATUS[200 OK]
  225. REQUEST RUNTIME[0.2761s]
  226.  
  227. SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
  228. SQL RUNTIME[0.00033498s]
  229.  
  230. SQL[UPDATE `observium_attribs` set `attrib_value` ='0.16.3.7703' WHERE `attrib_type` = 'latest_ver']
  231. SQL RUNTIME[0.00104904s]
  232.  
  233. SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
  234. SQL RUNTIME[0.00018716s]
  235.  
  236. SQL[UPDATE `observium_attribs` set `attrib_value` ='7703' WHERE `attrib_type` = 'latest_rev']
  237. SQL RUNTIME[0.00092506s]
  238.  
  239. SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
  240. SQL RUNTIME[0.00023103s]
  241.  
  242. SQL[UPDATE `observium_attribs` set `attrib_value` ='2016-03-22' WHERE `attrib_type` = 'latest_rev_date']
  243. SQL RUNTIME[0.00078106s]
  244.  
  245. SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
  246. SQL RUNTIME[0.00030518s]
  247.  
  248. SQL[UPDATE `observium_attribs` set `attrib_value` ='1461759539' WHERE `attrib_type` = 'last_versioncheck']
  249. SQL RUNTIME[0.00085902s]
  250.  
  251. SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
  252. SQL RUNTIME[0.00017619s]
  253. ##### Starting discovery run at 2016-04-27 14:18:59 #####
  254.  
  255.  
  256. SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'usasr01' ORDER BY `last_discovered_timetaken` ASC]
  257. SQL RUNTIME[0.00066996s]
  258.  
  259. CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n "" -x *** -X *** -a *** -A *** -u *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'usasr01':'161' sysObjectID.0 sysUpTime.0]
  260.  
  261. CMD EXITCODE[0]
  262. CMD RUNTIME[0.0368s]
  263. CMD EXITDELAY[10ms]
  264. STDOUT[
  265. sysObjectID.0 = enterprises.9.1.1639
  266. sysUpTime.0 = 3816435740
  267. ]
  268. SNMP STATUS[TRUE]
  269.  
  270. SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1']
  271. SQL RUNTIME[0.00049210s]
  272.  
  273. SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '1']
  274. SQL RUNTIME[0.00025010s]
  275.  
  276. CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 29772]
  277.  
  278. CMD EXITCODE[0]
  279. CMD RUNTIME[0.0101s]
  280. CMD EXITDELAY[10ms]
  281. STDOUT[
  282. PID PPID UID GID TT STAT TIME STARTED COMMAND
  283. 29772 29587 0 0 pts/0 S+ 00:00:00 Wed Apr 27 14:18:58 2016 php ./discovery.php -d -m bgp-peers -h usasr01
  284. ]
  285.  
  286. SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('29772','discovery.php','29587','0','php ./discovery.php -d -m bgp-peers -h usasr01','1461759538','1')]
  287. SQL RUNTIME[0.00220299s]
  288. ##### usasr01 [1] #####
  289.  
  290. o OS Type iosxr
  291. o OS Group cisco
  292. o SNMP Version v3
  293. o Last discovery 2016-04-27 12:44:41
  294. o Last duration 28.82 seconds
  295.  
  296. ##### Module Start: bgp-peers #####
  297.  
  298.  
  299. SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1' AND `attrib_type` = 'sysORID']
  300. SQL RUNTIME[0.00026584s]
  301.  
  302. SQL[SELECT * FROM `observium_attribs`]
  303. SQL RUNTIME[0.00013804s]
  304.  
  305. CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n "" -x *** -X *** -a *** -A *** -u *** -Pu -OUQvn -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'usasr01':'161' bgpLocalAs.0]
  306.  
  307. CMD EXITCODE[0]
  308. CMD RUNTIME[0.0387s]
  309. CMD EXITDELAY[10ms]
  310. STDOUT[
  311. 0
  312. ]
  313. SNMP STATUS[TRUE]
  314. No BGP on host
  315. SQL[SELECT * FROM bgpPeers WHERE device_id = '1']
  316. SQL RUNTIME[0.00041485s]
  317.  
  318. o Duration 0.056s
  319.  
  320.  
  321. SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.086',`force_discovery` ='0' WHERE `device_id` = '1']
  322. SQL RUNTIME[0.00113487s]
  323.  
  324. SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('1','discover','1461759539.3667','0.086280822753906')]
  325. SQL RUNTIME[0.00088501s]
  326. ##### usasr01 [1] completed discovery modules at 2016-04-27 14:18:59 #####
  327.  
  328. o Discovery time 0.086 seconds
  329.  
  330.  
  331. SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '29772' AND `process_name` = 'discovery.php' AND `device_id` = '1']
  332. SQL RUNTIME[0.00105500s]
  333. ##### Finished discovery run at 2016-04-27 14:18:59 #####
  334.  
  335.  
  336. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','usasr01','1461759538.5638','0.895','1')]
  337. SQL RUNTIME[0.00082111s]
  338. ./discovery.php: usasr01 - 1 devices discovered in 0.895 secs
  339. NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
  340. o Devices Discovered 1
  341. o Discovery Time 0.895 secs
  342. o Memory usage 10.25MB (peak: 11MB)
  343. o MySQL Usage Cell[30/0.098s] Row[6/0.005s] Rows[11/0.075s] Column[0/0s] Update[5/0.008s] Insert[3/0.006s] Delete[1/0.002s]
  344. o RRDTool Usage
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!