DEBUG! CMD[/usr/bin/svn info /opt/observium] CMD EXITCODE[0] CMD RUNTIME[0.0087s] STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: http://svn.observium.org/svn/observium/branches/stable Relative URL: ^/observium/branches/stable Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 8929 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 8889 Last Changed Date: 2017-10-11 17:36:10 +0100 (Wed, 11 Oct 2017) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00026393s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00007892s] 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.00006509s] 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.00010800s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00013089s] CMD[/bin/hostname -f] CMD EXITCODE[0] CMD RUNTIME[0.0003s] STDOUT[ monitoring.[HOSTNAME REMOVED BY ALEX WINDER] ] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 17.10.8889 http://www.observium.org CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0218s] STDOUT[ Linux|3.16.0-4-amd64|amd64|Debian|8.9|vmware ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0012s] STDOUT[ Python 2.7.9 ] SQL[SELECT version();] SQL RUNTIME[0.00017595s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0025s] STDOUT[ NET-SNMP version: 5.7.2.1 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0031s] STDOUT[ RRDtool 1.4.8 Copyright 1997-2013 by Tobias Oetiker ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.0233s] STDOUT[ Apache/2.4.10 ] CMD[date "+%:z"] CMD EXITCODE[0] CMD RUNTIME[0.0001s] STDOUT[ +01:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00023890s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00010300s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00269508s] ##### Software versions ##### o OS Linux 3.16.0-4-amd64 [amd64] (Debian 8.9) o Apache 2.4.10 o PHP 7.0.24-1~dotdeb+8.1 (OPcache: DISABLED) o Python 2.7.9 o MySQL 5.7.20 (extension: mysqli 5.0.12-dev) o SNMP NET-SNMP 5.7.2.1 o RRDtool 1.4.8 ##### 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 Wednesday, 25-Oct-17 15:13:17 BST o PHP +01:00 o MySQL +01:00 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00032806s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00014114s] ##### Starting discovery run at 2017-10-25 15:13:17 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]' AND `status` = '1' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00052404s] CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' sysObjectID.0 sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0234s] STDOUT[ sysObjectID.0 = enterprises.318.1.3.8.4 sysUpTime.0 = 76478760 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '124'] SQL RUNTIME[0.00050116s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '124'] SQL RUNTIME[0.00021911s] CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 26325] CMD EXITCODE[0] CMD RUNTIME[0.0071s] STDOUT[ PID PPID UID GID TT STAT TIME STARTED COMMAND 26325 27435 0 0 pts/0 S+ 00:00:00 Wed Oct 25 15:13:16 2017 php ./discovery.php -d -m sensors -h room1-environment.[HOSTNAME REMOVED BY ALEX WINDER] ] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('26325','discovery.php','27435','0','php ./discovery.php -d -m sensors -h room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]','1508940796','124')] SQL RUNTIME[0.00141501s] ##### room1-environment.[HOSTNAME REMOVED BY ALEX WINDER] [124] ##### o OS Type netbotz o OS Group apc o SNMP Version v2c o Last discovery 2017-10-25 15:13:09 o Last duration 3.64 seconds ##### Module Start: sensors ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '124' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00042582s] SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00019288s] o NETBOTZV2-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m NETBOTZ410-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/apc 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' tempSensorEntry] CMD EXITCODE[0] CMD RUNTIME[0.0786s] STDOUT[ tempSensorEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m NETBOTZ410-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/apc 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' humiSensorEntry] CMD EXITCODE[0] CMD RUNTIME[0.0807s] STDOUT[ humiSensorEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m NETBOTZ410-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/apc 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' dewPointSensorEntry] CMD EXITCODE[0] CMD RUNTIME[0.0737s] STDOUT[ dewPointSensorEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m NETBOTZ410-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/apc 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' airFlowSensorEntry] CMD EXITCODE[0] CMD RUNTIME[0.0741s] STDOUT[ airFlowSensorEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m NETBOTZ410-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/apc 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' ampDetectSensorEntry] CMD EXITCODE[0] CMD RUNTIME[0.076s] STDOUT[ ampDetectSensorEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o ENTITY-SENSOR-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]':'161' entPhySensorValue] CMD EXITCODE[0] CMD RUNTIME[0.1198s] STDOUT[ entPhySensorValue = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00084615s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033307s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024104s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023103s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024700s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00035214s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00038004s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033593s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024509s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023794s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023389s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024104s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023198s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023317s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00032091s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00033998s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023508s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025702s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024605s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00029397s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00029302s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00028896s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024199s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025511s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023699s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023293s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023198s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '124' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00037003s] SQL[SELECT * FROM `status` WHERE `device_id` = '124' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00022388s] o Duration 0.537s SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='environment',`last_discovered_timetaken` ='0.550',`force_discovery` ='0' WHERE `device_id` = '124'] SQL RUNTIME[0.00596309s] SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('124','discover','1508940797.4712','0.55031609535217')] SQL RUNTIME[0.00478697s] ##### room1-environment.[HOSTNAME REMOVED BY ALEX WINDER] [124] completed discovery modules at 2017-10-25 15:13:18 ##### o Discovery time 0.550 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '26325' AND `process_name` = 'discovery.php' AND `device_id` = '124'] SQL RUNTIME[0.00090814s] ##### Finished discovery run at 2017-10-25 15:13:18 ##### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','room1-environment.[HOSTNAME REMOVED BY ALEX WINDER]','1508940797.373','0.660','1')] SQL RUNTIME[0.00035715s] ./discovery.php: room1-environment.[HOSTNAME REMOVED BY ALEX WINDER] - 1 devices discovered in 0.660 secs SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1508926397'] SQL RUNTIME[0.00020194s] 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.660 secs o Memory usage 12MB (peak: 14MB) o MySQL Usage Cell[4/0.001s] Row[5/0.002s] Rows[36/0.018s] Column[0/0s] Update[1/0.006s] Insert[3/0.007s] Delete[1/0.001s] o RRDTool Usage