DEBUG! SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00031590s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00011086s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00005984s] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.16.1.7535 http://www.observium.org CMD[/opt/observium/scripts/distro] EXITCODE[0] CMD RUNTIME[0.048s] STDOUT[ Linux|3.19.0-25-generic|amd64|Ubuntu|14.04 ] CMD[/usr/bin/env python --version 2>&1] EXITCODE[0] CMD RUNTIME[0.002s] STDOUT[ Python 2.7.6 ] SQL[SELECT version();] SQL RUNTIME[0.00027394s] CMD[/usr/bin/snmpget --version 2>&1] EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ NET-SNMP version: 5.7.2 ] CMD[/usr/bin/rrdtool --version |head -n1] EXITCODE[0] CMD RUNTIME[0.0038s] STDOUT[ RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00024104s] CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}'] EXITCODE[0] CMD RUNTIME[0.0231s] STDOUT[ Apache/2.4.7 ] SQL[SELECT @@sql_mode;] SQL RUNTIME[0.00020099s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00051880s] ##### Software versions ##### o OS Linux 3.19.0-25-generic [amd64] (Ubuntu 14.04) o Apache 2.4.7 o PHP 5.5.9-1ubuntu4.14 o Python 2.7.6 o MySQL 5.5.47-0ubuntu0.14.04.1 (extension: mysqli 5.5.47) o SNMP NET-SNMP 5.7.2 o RRDtool 1.4.7 ##### MySQL mode ##### o MySQL ##### Charset info ##### o PHP UTF-8 o MySQL utf8 ##### Timezones info ##### o Date Friday, 12-Feb-16 20:10:07 IST o PHP +05:30 o MySQL +05:30 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00023985s] SQL[SELECT COUNT(*) FROM ports] SQL RUNTIME[0.00059319s] SQL[SELECT COUNT(*) FROM devices] SQL RUNTIME[0.00014997s] SQL[SELECT COUNT(*) FROM `sensors`] SQL RUNTIME[0.00024509s] SQL[SELECT COUNT(*) FROM `services`] SQL RUNTIME[0.00013900s] SQL[SELECT COUNT(*) FROM `applications`] SQL RUNTIME[0.00012422s] SQL[SELECT COUNT(*) FROM `bgpPeers`] SQL RUNTIME[0.00012088s] SQL[SELECT COUNT(*) FROM `ospf_ports`] SQL RUNTIME[0.00013208s] SQL[SELECT COUNT(*) FROM `eigrp_ports`] SQL RUNTIME[0.00011492s] SQL[SELECT COUNT(*) FROM `ipsec_tunnels`] SQL RUNTIME[0.00012493s] SQL[SELECT COUNT(*) FROM `munin_plugins`] SQL RUNTIME[0.00021005s] SQL[SELECT COUNT(*) FROM `pseudowires`] SQL RUNTIME[0.00010204s] SQL[SELECT COUNT(*) FROM `vrfs`] SQL RUNTIME[0.00012517s] SQL[SELECT COUNT(*) FROM `vminfo`] SQL RUNTIME[0.00012207s] SQL[SELECT COUNT(*) FROM `users`] SQL RUNTIME[0.00011706s] SQL[SELECT COUNT(*) FROM `bills`] SQL RUNTIME[0.00012088s] SQL[SELECT COUNT(*) FROM `alert_table`] SQL RUNTIME[0.00035596s] SQL[SELECT COUNT(*) FROM `alert_tests`] SQL RUNTIME[0.00004482s] SQL[SELECT COUNT(*) FROM `slas`] SQL RUNTIME[0.00011802s] SQL[SELECT COUNT(*) FROM `status`] SQL RUNTIME[0.00015020s] SQL[SELECT COUNT(*) FROM `groups`] SQL RUNTIME[0.00010300s] SQL[SELECT COUNT(*) FROM `group_table`] SQL RUNTIME[0.00010300s] SQL[SELECT SUM(`last_polled_timetaken`) FROM devices] SQL RUNTIME[0.00013399s] SQL[SELECT SUM(`last_discovered_timetaken`) FROM devices] SQL RUNTIME[0.00012589s] CMD[DISTROFORMAT=export /opt/observium/scripts/distro] EXITCODE[0] CMD RUNTIME[0.0461s] STDOUT[ OS=Linux KERNEL=3.19.0-25-generic ARCH=amd64 DISTRO=Ubuntu VERSION=14.04 DISTROVER=14.04 SCRIPTVER=1.1.0 ] SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`] SQL RUNTIME[0.00056505s] SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`] SQL RUNTIME[0.00015116s] SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`] SQL RUNTIME[0.00027299s] SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`] SQL RUNTIME[0.00016689s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'unique_id';] SQL RUNTIME[0.00014901s] REQUEST[http://www.observium.org/versions.php] REQUEST STATUS[200 OK] REQUEST RUNTIME[2.1115s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';] SQL RUNTIME[0.00033379s] SQL[UPDATE `observium_attribs` set `attrib_value` ='0.16.1.7535' WHERE `attrib_type` = 'latest_ver'] SQL RUNTIME[0.00911808s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00020480s] SQL[UPDATE `observium_attribs` set `attrib_value` ='7535' WHERE `attrib_type` = 'latest_rev'] SQL RUNTIME[0.01329589s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';] SQL RUNTIME[0.00020719s] SQL[UPDATE `observium_attribs` set `attrib_value` ='2016-01-27' WHERE `attrib_type` = 'latest_rev_date'] SQL RUNTIME[0.01320696s] SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00015807s] SQL[UPDATE `observium_attribs` set `attrib_value` ='1455288009' WHERE `attrib_type` = 'last_versioncheck'] SQL RUNTIME[0.01333499s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00015306s] ##### Starting discovery run at 2016-02-12 20:10:09 ##### SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'o2-hua-s6720' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00050092s] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'o2-hua-s6720':'161' sysObjectID.0 sysUpTime.0] EXITCODE[0] CMD RUNTIME[0.0466s] STDOUT[ sysObjectID.0 = enterprises.2011.2.23.343 sysUpTime.0 = 303257160 ] SNMP_STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '5'] SQL RUNTIME[0.00013185s] ##### o2-hua-s6720 [5] ##### o OS Type vrp o OS Group vrp o SNMP Version v2c o Last discovery 2016-02-12 18:34:30 o Last duration 11.90 seconds ##### Module Start: os ##### CMD[/usr/bin/snmpget -v2c -c *** -Pu -Ovq -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'o2-hua-s6720':'161' sysDescr.0] EXITCODE[0] CMD RUNTIME[0.011s] STDOUT[ S6720-54C-EI-48S-AC Huawei Versatile Routing Platform Software VRP (R) software,Version 5.160 (S6720 V200R008C00SPC500) Copyright (C) 2007 Huawei Technologies Co., Ltd. ] SNMP_STATUS[TRUE] CMD[/usr/bin/snmpget -v2c -c *** -Pu -Ovqn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'o2-hua-s6720':'161' sysObjectID.0] EXITCODE[0] CMD RUNTIME[0.0129s] STDOUT[ .1.3.6.1.4.1.2011.2.23.343 ] SNMP_STATUS[TRUE] | S6720-54C-EI-48S-AC Huawei Versatile Routing Platform Software VRP (R) software,Version 5.160 (S6720 V200R008C00SPC500) Copyright (C) 2007 Huawei Technologies Co., Ltd. | .1.3.6.1.4.1.2011.2.23.343 | o Duration 0.028s SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.030',`force_discovery` ='0' WHERE `device_id` = '5'] SQL RUNTIME[0.00884509s] SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('5','discover','1455288010.0091','0.030155897140503')] SQL RUNTIME[0.01379490s] ##### o2-hua-s6720 [5] completed discovery modules at 2016-02-12 20:10:10 ##### o Discovery time 0.030 seconds ##### Finished discovery run at 2016-02-12 20:10:10 ##### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','o2-hua-s6720','1455288007.6408','2.422','1')] SQL RUNTIME[0.01287198s] ./discovery.php: o2-hua-s6720 - 1 devices discovered in 2.422 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 2.422 secs o Memory usage 6.5MB (peak: 6.75MB) o MySQL Usage Cell[30/0.013s] Row[5/0.003s] Rows[8/0.005s] Column[0/0s] Update[5/0.059s] Insert[2/0.027s] Delete[0/0s] o RRDTool Usage