DEBUG!
CMD[/usr/bin/svn info /opt/observium]
CMD EXITCODE[0]
CMD RUNTIME[0.0082s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/trunk
Relative URL: ^/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 9840
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 9840
Last Changed Date: 2019-04-17 23:55:20 +0200 (Wed, 17 Apr 2019)
]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00029516s]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00014210s]
SQL[SET SESSION `sql_mode` = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00008798s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00018907s]
SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00016403s]
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|
Observium Professional 19.4.9840
http://www.observium.org
CMD[/opt/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0339s]
STDOUT[
Linux|4.4.0-142-generic|amd64|Ubuntu|16.04|qemu|
]
CMD[/usr/bin/env python --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0021s]
STDOUT[
Python 2.7.12
]
SQL[SELECT version();]
SQL RUNTIME[0.00016212s]
CMD[/usr/bin/snmpget --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
NET-SNMP version: 5.7.3
]
CMD[/usr/bin/rrdtool --version | head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0086s]
STDOUT[
RRDtool 1.5.5 Copyright by Tobias Oetiker <tobi@oetiker.ch>
]
CMD[/usr/bin/rrdcached -h | head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0078s]
STDOUT[
RRDCacheD 1.5.5
]
CMD[/usr/bin/fping -v 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0015s]
STDOUT[
/usr/bin/fping: Version 3.13
/usr/bin/fping: comments to david@schweikert.ch
]
CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0]
CMD RUNTIME[0.0337s]
STDOUT[
Apache/2.4.18
]
CMD[date "+%:z"]
CMD EXITCODE[0]
CMD RUNTIME[0.0012s]
CMD EXITDELAY[10ms]
STDOUT[
+02:00
]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00016189s]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00018692s]
SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00184107s]
##### Software versions #####
o OS Linux 4.4.0-142-generic [amd64] (Ubuntu 16.04)
o Apache 2.4.18
o PHP 7.0.33-0ubuntu0.16.04.3 (OPcache: ENABLED)
o Python 2.7.12
o MySQL 5.7.25-0ubuntu0.16.04.2 (extension: mysqli 5.0.12-dev)
o SNMP NET-SNMP 5.7.3
o RRDtool 1.5.5 (rrdcached 1.5.5: unix:/var/run/rrdcached.sock)
o Fping 3.13 (IPv4 and IPv6)
##### Memory Limit #####
o PHP Unlimited
##### MySQL mode #####
o MySQL NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
##### Charset info #####
o PHP UTF-8
o MySQL utf8
##### Timezones info #####
o Date Thursday, 18-Apr-19 15:26:33 CEST
o PHP +02:00
o MySQL +02:00
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00025511s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00015616s]
##### Starting discovery run at 2019-04-18 15:26:33 #####
SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '1046' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00041699s]
CMD[/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'10.129.10.95':'161' sysObjectID.0 sysUpTime.0]
CMD EXITCODE[0]
CMD RUNTIME[0.0067s]
STDOUT[
sysObjectID.0 = enterprises.21695.1
sysUpTime.0 = 17:4:04:34.81
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1046']
SQL RUNTIME[0.00045896s]
SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '1046']
SQL RUNTIME[0.00025201s]
SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('24419','discovery.php','27783','0','php ./discovery.php -h 1046 -d -m sensors','1555593993','1046')]
SQL RUNTIME[0.03996992s]
##### 10.129.10.95 [1046] #####
o OS Type e3meter
o SNMP Version v2c
o Last discovery 2019-04-18 15:18:06
o Last duration 1.33 seconds
##### Module Start: sensors #####
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1046' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00035620s]
SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '1046' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00037003s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00032020s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00023389s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00025702s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00026202s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00021505s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028396s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'charge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00027704s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'energy' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028586s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'aenergy' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024796s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'renergy' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00025702s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024009s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00022912s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00023293s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00023103s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024986s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00032997s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030994s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00031495s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030708s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00025105s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024199s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028086s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00025296s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024295s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00026011s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00031185s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030613s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00035095s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00032997s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029302s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00027800s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '1046' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00031304s]
SQL[SELECT * FROM `status` WHERE `device_id` = '1046' AND `poller_type` = 'snmp' AND `status_deleted` = '0']
SQL RUNTIME[0.00028896s]
o Duration 0.0168s
SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='0.0583',`force_discovery` ='0' WHERE `device_id` = '1046']
SQL RUNTIME[0.03172803s]
##### 10.129.10.95 [1046] completed discovery modules at 2019-04-18 15:26:33 #####
o Discovery time 0.0583 seconds
SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '24419' AND `process_name` = 'discovery.php' AND `device_id` = '1046']
SQL RUNTIME[0.03693700s]
##### Finished discovery run at 2019-04-18 15:26:33 #####
./discovery.php: 10.129.10.95 - 1 devices discovered in 0.258 secs
SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1555579593']
SQL RUNTIME[0.00048900s]
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 0.258 secs
o Memory usage 4MB (peak: 4MB)
o MySQL Usage Cell[4/0.001s] Row[5/0.002s] Rows[41/0.02s] Column[1/0.001s] Update[1/0.032s] Insert[1/0.04s] Delete[1/0.037s]
o RRDTool Usage