DEBUG!

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

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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00013685s]

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

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0013s]
STDOUT[
observium.dom.prodware.net
]

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0604s]
STDOUT[
Linux|4.4.0-38-generic|amd64|Ubuntu|16.04
]

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0015s]
STDOUT[
NET-SNMP version: 5.7.3
]

CMD[/usr/bin/rrdtool --version | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0052s]
STDOUT[
RRDtool 1.5.5  Copyright by Tobias Oetiker <tobi@oetiker.ch>
]

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

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

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0011s]
STDOUT[
+01:00
]

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

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

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

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

 o OS                   Linux 4.4.0-38-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.8-0ubuntu0.16.04.3 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.16-0ubuntu0.16.04.1 (extension: mysqli 5.0.12-dev)
 o SNMP                 NET-SNMP 5.7.3
 o RRDtool              1.5.5

#####  MySQL mode  #####

 o MySQL                

#####  Charset info  #####

 o PHP                  UTF-8
 o MySQL                utf8

#####  Timezones info  #####

 o Date                 Wednesday, 28-Dec-16 09:15:04 CET
 o PHP                  +01:00
 o MySQL                +01:00


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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00016713s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
SQL RUNTIME[0.00014305s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00015092s]
There is a newer revision of Observium available!
Version 0.16.12.8292 (28th December 2016) is 111 revisions ahead.

#####  Starting discovery run at 2016-12-28 09:15:04  #####


SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'na02-par01' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00053811s]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0093s]
STDOUT[
sysObjectID.0 = enterprises.789.2.3
sysUpTime.0 = 897286998
]
SNMP STATUS[TRUE]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0107s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
24337  9694     0     0 pts/0    S+   00:00:00 Wed Dec 28 09:15:04 2016 php ./discovery.php -h na02-par01 -m sensors -d
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('24337','discovery.php','9694','0','php ./discovery.php -h na02-par01 -m sensors -d','1482912904','164')]
SQL RUNTIME[0.00192404s]
#####  na02-par01 [164]  #####

 o OS Type              netapp
 o SNMP Version         v2c
 o Last discovery       2016-12-28 06:34:20
 o Last duration        1.53 seconds

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


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

SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00020504s]
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':'na02-par01':'161' entPhySensorValue]

CMD EXITCODE[0]
CMD RUNTIME[0.0319s]
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` = '164' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00062299s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00025702s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024104s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00023890s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00023818s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'current' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00031900s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'power' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00028706s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00039506s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00025296s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00026798s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00025606s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00025010s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024819s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024199s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024891s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024199s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024199s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'load' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024319s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00028706s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024891s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024486s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00023890s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00025010s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00023913s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '164' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00024009s]

SQL[SELECT * FROM `status` WHERE `device_id` = '164' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00030303s]


 o Duration             0.0469s


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='storage',`last_discovered_timetaken` ='0.062',`force_discovery` ='0' WHERE `device_id` = '164']
SQL RUNTIME[0.00169992s]

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('164','discover','1482912904.9891','0.062312841415405')]
SQL RUNTIME[0.00155497s]
#####  na02-par01 [164] completed discovery modules at 2016-12-28 09:15:05  #####

 o Discovery time       0.062 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '24337' AND `process_name` = 'discovery.php' AND `device_id` = '164']
SQL RUNTIME[0.00082302s]
#####  Finished discovery run at 2016-12-28 09:15:05  #####


SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','na02-par01','1482912904.5794','0.476','1')]
SQL RUNTIME[0.00059891s]
./discovery.php: na02-par01 - 1 devices discovered in 0.476 secs
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.476 secs
 o Memory usage         10MB (peak: 10MB)
 o MySQL Usage          Cell[4/0.001s] Row[7/0.003s] Rows[32/0.304s] Column[0/0s] Update[1/0.002s] Insert[3/0.005s] Delete[1/0.001s] 
 o RRDTool Usage