[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 ] 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