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