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