[root@olab5g ~]# /var/observium/discovery.php -d -m bgp-peers -h rtr5a1.example.com
DEBUG!
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00026417s]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00006199s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00008702s]
SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00011301s]
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|
Observium Professional 0.16.5.7901
http://www.observium.org
CMD[/var/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0345s]
STDOUT[
Linux|2.6.32-431.20.3.el6.x86_64|amd64|CentOS|6.5
]
CMD[/usr/bin/env python --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0046s]
STDOUT[
Python 2.6.6
]
SQL[SELECT version();]
SQL RUNTIME[0.00018311s]
CMD[/usr/bin/snmpget --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0044s]
STDOUT[
NET-SNMP version: 5.5
]
CMD[/usr/bin/rrdtool --version |head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0053s]
STDOUT[
RRDtool 1.3.8 Copyright 1997-2009 by Tobias Oetiker <tobi@oetiker.ch>
]
CMD[date "+%:z"]
CMD EXITCODE[0]
CMD RUNTIME[0.0037s]
STDOUT[
-04:00
]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00017905s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0]
CMD RUNTIME[0.0044s]
STDOUT[
]
CMD[/usr/bin/env httpd -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0]
CMD RUNTIME[0.0166s]
STDOUT[
Apache/2.2.15
]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00019693s]
SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00042796s]
##### Software versions #####
o OS Linux 2.6.32-431.20.3.el6.x86_64 [amd64] (CentOS 6.5)
o Apache 2.2.15
o PHP 5.6.21 (OPcache: DISABLED)
o Python 2.6.6
o MySQL 5.1.73 (extension: mysqli 5.1.73)
o SNMP NET-SNMP 5.5
o RRDtool 1.3.8
##### MySQL mode #####
o MySQL
##### Charset info #####
o PHP UTF-8
o MySQL utf8
##### Timezones info #####
o Date Monday, 20-Jun-16 17:56:58 UTC
o PHP +00:00
o MySQL -04:00
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00032496s]
SQL[SELECT COUNT(*) FROM ports]
SQL RUNTIME[0.00034285s]
SQL[SELECT COUNT(*) FROM devices]
SQL RUNTIME[0.00007892s]
SQL[SELECT COUNT(*) FROM `sensors`]
SQL RUNTIME[0.00012183s]
SQL[SELECT COUNT(*) FROM `services`]
SQL RUNTIME[0.00039911s]
SQL[SELECT COUNT(*) FROM `applications`]
SQL RUNTIME[0.00007010s]
SQL[SELECT COUNT(*) FROM `bgpPeers`]
SQL RUNTIME[0.00009704s]
SQL[SELECT COUNT(*) FROM `ospf_ports`]
SQL RUNTIME[0.00006890s]
SQL[SELECT COUNT(*) FROM `eigrp_ports`]
SQL RUNTIME[0.00006795s]
SQL[SELECT COUNT(*) FROM `ipsec_tunnels`]
SQL RUNTIME[0.00006700s]
SQL[SELECT COUNT(*) FROM `munin_plugins`]
SQL RUNTIME[0.00009584s]
SQL[SELECT COUNT(*) FROM `pseudowires`]
SQL RUNTIME[0.00018597s]
SQL[SELECT COUNT(*) FROM `vrfs`]
SQL RUNTIME[0.00016308s]
SQL[SELECT COUNT(*) FROM `vminfo`]
SQL RUNTIME[0.00016594s]
SQL[SELECT COUNT(*) FROM `users`]
SQL RUNTIME[0.00009704s]
SQL[SELECT COUNT(*) FROM `bills`]
SQL RUNTIME[0.00009894s]
SQL[SELECT COUNT(*) FROM `alert_table`]
SQL RUNTIME[0.00006700s]
SQL[SELECT COUNT(*) FROM `alert_tests`]
SQL RUNTIME[0.00006485s]
SQL[SELECT COUNT(*) FROM `slas`]
SQL RUNTIME[0.00006604s]
SQL[SELECT COUNT(*) FROM `status`]
SQL RUNTIME[0.00008202s]
SQL[SELECT COUNT(*) FROM `groups`]
SQL RUNTIME[0.00009394s]
SQL[SELECT COUNT(*) FROM `group_table`]
SQL RUNTIME[0.00009418s]
SQL[SELECT SUM(`last_polled_timetaken`) FROM devices]
SQL RUNTIME[0.00010395s]
SQL[SELECT SUM(`last_discovered_timetaken`) FROM devices]
SQL RUNTIME[0.00011301s]
CMD[DISTROFORMAT=export /var/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.034s]
STDOUT[
OS=Linux
KERNEL=2.6.32-431.20.3.el6.x86_64
ARCH=amd64
DISTRO=CentOS
VERSION=6.5
DISTROVER=6.5
SCRIPTVER=1.1.0
]
SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`]
SQL RUNTIME[0.00155282s]
SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`]
SQL RUNTIME[0.00013304s]
SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`]
SQL RUNTIME[0.00034404s]
SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`]
SQL RUNTIME[0.00010395s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'unique_id';]
SQL RUNTIME[0.00009799s]
REQUEST[http://www.observium.org/versions.php]
REQUEST STATUS[200 OK]
REQUEST RUNTIME[0.711s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
SQL RUNTIME[0.00029802s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='0.16.6.7932' WHERE `attrib_type` = 'latest_ver']
SQL RUNTIME[0.01044202s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00010014s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='7932' WHERE `attrib_type` = 'latest_rev']
SQL RUNTIME[0.01214099s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00008893s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='2016-06-17' WHERE `attrib_type` = 'latest_rev_date']
SQL RUNTIME[0.00196505s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00008702s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='1466445418' WHERE `attrib_type` = 'last_versioncheck']
SQL RUNTIME[0.00526214s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00008798s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
SQL RUNTIME[0.00007987s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00007892s]
There is a newer revision of Observium available!
Version 0.16.6.7932 (20th June 2016) is 31 revisions ahead.
##### Starting discovery run at 2016-06-20 17:56:58 #####
SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'rtr5a1.example.com' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00053787s]
CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /var/observium/mibs/rfc:/var/observium/mibs/net-snmp 'udp':'rtr5a1.example.com':'161' sysObjectID.0 sysUpTime.0]
CMD EXITCODE[0]
CMD RUNTIME[0.0108s]
STDOUT[
sysObjectID.0 = enterprises.9.1.925
sysUpTime.0 = 25004685
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '26']
SQL RUNTIME[0.00042295s]
SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '26']
SQL RUNTIME[0.00013995s]
CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 12644]
CMD EXITCODE[0]
CMD RUNTIME[0.0826s]
STDOUT[
PID PPID UID GID TT STAT TIME STARTED COMMAND
12644 12365 0 0 pts/0 S+ 00:00:00 Mon Jun 20 13:56:56 2016 php /var/observium/discovery.php -d -m bgp-peers -h rtr5a1.example.com
]
SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('12644','discovery.php','12365','0','php /var/observium/discovery.php -d -m bgp-peers -h rtr5a1.example.com','1466445416','26')]
SQL RUNTIME[0.00243807s]
##### rtr5a1.example.com [26] #####
o OS Type iosxe
o OS Group cisco
o SNMP Version v2c
o Last discovery 2016-06-20 12:33:27
o Last duration 7.85 seconds
##### Module Start: bgp-peers #####
o Duration 0.0017s
SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.093',`force_discovery` ='0' WHERE `device_id` = '26']
SQL RUNTIME[0.01522684s]
SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('26','discover','1466445418.8649','0.093835115432739')]
SQL RUNTIME[0.00203919s]
##### rtr5a1.example.com [26] completed discovery modules at 2016-06-20 17:56:58 #####
o Discovery time 0.093 seconds
SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '12644' AND `process_name` = 'discovery.php' AND `device_id` = '26']
SQL RUNTIME[0.00203395s]
##### Finished discovery run at 2016-06-20 17:56:58 #####
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','rtr5a1.example.com','1466445417.9438','1.036','1')]
SQL RUNTIME[0.00199795s]
/var/observium/discovery.php: rtr5a1.example.com - 1 devices discovered in 1.036 secs
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
o Devices Discovered 1
o Discovery Time 1.036 secs
o Memory usage 8.5MB (peak: 8.5MB)
o MySQL Usage Cell[31/0.015s] Row[7/0.004s] Rows[9/0.007s] Column[0/0s] Update[5/0.047s] Insert[3/0.008s] Delete[1/0.002s]
o RRDTool Usage