DEBUG!

CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0073s]
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: 9014
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 9014
Last Changed Date: 2018-01-28 20:58:07 +0000 (Sun, 28 Jan 2018)

]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00079513s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00063992s]

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.00055790s]
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.00064492s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00061798s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0018s]
STDOUT[
monitoring01.c.leafspace-183416.internal
]

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                           Observium Professional 18.1.9014
                                   http://www.observium.org


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0076s]
STDOUT[
Linux|4.13.0-31-generic|amd64|Ubuntu|16.04|kvm
]

CMD[/usr/bin/env python --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0018s]
STDOUT[
Python 2.7.12
]

SQL[SELECT version();]
SQL RUNTIME[0.00096607s]

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.0068s]
STDOUT[
RRDtool 1.5.5  Copyright by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.032s]
STDOUT[
Apache/2.4.18
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0019s]
STDOUT[
+00:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00099993s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00087810s]

SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00240898s]

#####  Software versions  #####

 o OS                   Linux 4.13.0-31-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.22-0ubuntu0.16.04.1 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.14-google-log (extension: mysqli 5.0.12-dev)
 o SNMP                 NET-SNMP 5.7.3
 o RRDtool              1.5.5

#####  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                 Monday, 29-Jan-18 09:43:32 UTC
 o PHP                  +00:00
 o MySQL                +00:00


SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00081992s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00076103s]
#####  Starting discovery run at 2018-01-29 09:43:32  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '45' AND `status` = '1' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00142097s]

CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sw01.italia1.gs.leaf.space':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0802s]
STDOUT[
sysObjectID.0 = enterprises.11863.5.33
sysUpTime.0 = 169021264
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '45']
SQL RUNTIME[0.00133705s]

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '45']
SQL RUNTIME[0.00080919s]

CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 10056]

CMD EXITCODE[0]
CMD RUNTIME[0.0074s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
10056 27450     0     0 pts/0    S+   00:00:00 Mon Jan 29 09:43:31 2018 php ./discovery.php -d -m sensors -h 45
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('10056','discovery.php','27450','0','php ./discovery.php -d -m sensors -h 45','1517219011','45')]
SQL RUNTIME[0.00590611s]
#####  sw01.italia1.gs.leaf.space [45]  #####

 o OS Type              tplink
 o SNMP Version         v2c
 o Last discovery       2018-01-29 09:29:09
 o Last duration        148.77 seconds

#####  Module Start: sensors  #####


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '45' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00099015s]

SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00062799s]
 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':'sw01.italia1.gs.leaf.space':'161' entPhySensorValue]

CMD EXITCODE[0]
CMD RUNTIME[10.8815s]
STDOUT[

]
SNMP STATUS[TRUE]

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':'sw01.italia1.gs.leaf.space':'161' entPhySensorType]

CMD EXITCODE[1]
CMD RUNTIME[6.0136s]
STDOUT[

]
STDERR[
Timeout: No Response from udp:sw01.italia1.gs.leaf.space:161
]
SNMP STATUS[FALSE]
SNMP ERROR[#1002 - Request timeout]

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':'sw01.italia1.gs.leaf.space':'161' entPhySensorScale]

CMD EXITCODE[1]
CMD RUNTIME[6.0131s]
STDOUT[

]
STDERR[
Timeout: No Response from udp:sw01.italia1.gs.leaf.space:161
]
SNMP STATUS[FALSE]
SNMP ERROR[#1002 - Request timeout]

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':'sw01.italia1.gs.leaf.space':'161' entPhySensorPrecision]

CMD EXITCODE[1]
CMD RUNTIME[6.0106s]
STDOUT[

]
STDERR[
Timeout: No Response from udp:sw01.italia1.gs.leaf.space:161
]
SNMP STATUS[FALSE]
SNMP ERROR[#1002 - Request timeout]

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':'sw01.italia1.gs.leaf.space':'161' entPhySensorOperStatus]

CMD EXITCODE[1]
CMD RUNTIME[6.0188s]
STDOUT[

]
STDERR[
Timeout: No Response from udp:sw01.italia1.gs.leaf.space:161
]
SNMP STATUS[FALSE]
SNMP ERROR[#1002 - Request timeout]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw01.italia1.gs.leaf.space':'161' entPhysicalDescr]

CMD EXITCODE[1]
CMD RUNTIME[6.0765s]
STDOUT[

]
STDERR[
Timeout: No Response from udp:sw01.italia1.gs.leaf.space:161
]
SNMP STATUS[FALSE]
SNMP ERROR[#1002 - Request timeout]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sw01.italia1.gs.leaf.space':'161' entAliasMappingIdentifier]

CMD EXITCODE[1]
CMD RUNTIME[6.0147s]
STDOUT[

]
STDERR[
Timeout: No Response from udp:sw01.italia1.gs.leaf.space:161
]
SNMP STATUS[FALSE]
SNMP ERROR[#1002 - Request timeout]


SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00212908s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00078797s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00071907s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00080013s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00074005s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00076604s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00070786s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00074601s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00066805s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00066185s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00068402s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00072002s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00077391s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00094604s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00081992s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00072598s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00076699s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00073600s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00071001s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00076485s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00076199s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00077415s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00087094s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00074697s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00085378s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00086904s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00075507s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '45' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00084591s]

SQL[SELECT * FROM `status` WHERE `device_id` = '45' AND `poller_type` = 'snmp' AND `status_deleted` = '0']
SQL RUNTIME[0.00074697s]


 o Duration             47.0836s


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='47.1013',`force_discovery` ='0' WHERE `device_id` = '45']
SQL RUNTIME[0.00593090s]
#####  sw01.italia1.gs.leaf.space [45] completed discovery modules at 2018-01-29 09:44:19  #####

 o Discovery time       47.1013 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '10056' AND `process_name` = 'discovery.php' AND `device_id` = '45']
SQL RUNTIME[0.00479913s]
#####  Finished discovery run at 2018-01-29 09:44:19  #####

./discovery.php: sw01.italia1.gs.leaf.space - 1 devices discovered in 47.27 secs

SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1517204612']
SQL RUNTIME[0.00070882s]
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       47.27 secs
 o Memory usage         12MB (peak: 14MB)
 o MySQL Usage          Cell[4/0.004s] Row[5/0.005s] Rows[36/0.035s] Column[0/0s] Update[1/0.006s] Insert[1/0.006s] Delete[1/0.005s] 
 o RRDTool Usage