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 <tobi@oetiker.ch>
]
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