DEBUG!

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

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

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

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

CMD[/bin/hostname -f]

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

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0557s]
STDOUT[
Linux|4.4.0-72-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.00018287s]

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.005s]
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.022s]
STDOUT[
Apache/2.4.18
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.001s]
STDOUT[
+02:00
]

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

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

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

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

 o OS                   Linux 4.4.0-72-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.15-0ubuntu0.16.04.4 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.17-0ubuntu0.16.04.1 (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                

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Saturday, 15-Apr-17 17:04:57 CEST
 o PHP                  +02:00
 o MySQL                +02:00


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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00014091s]
#####  Starting discovery run at 2017-04-15 17:04:57  #####


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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0062s]
STDOUT[
sysObjectID.0 = enterprises.1991.1.3.55.3.2
sysUpTime.0 = 3987678990
]
SNMP STATUS[TRUE]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0075s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
26219 25507     0     0 pts/0    S+   00:00:00 Sat Apr 15 17:04:56 2017 php ./discovery.php -d -h er01-par01 -m bgp
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('26219','discovery.php','25507','0','php ./discovery.php -d -h er01-par01 -m bgp','1492268696','76')]
SQL RUNTIME[0.00179386s]
#####  er01-par01 [76]  #####

 o OS Type              ironware
 o SNMP Version         v2c
 o Last discovery       2017-04-15 17:04:15
 o Last duration        0.01 seconds

#####  Module Start: bgp  #####


 o Duration             0.0001s


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.011',`force_discovery` ='0' WHERE `device_id` = '76']
SQL RUNTIME[0.00068998s]

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('76','discover','1492268697.4123','0.011287927627563')]
SQL RUNTIME[0.00138712s]
#####  er01-par01 [76] completed discovery modules at 2017-04-15 17:04:57  #####

 o Discovery time       0.011 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '26219' AND `process_name` = 'discovery.php' AND `device_id` = '76']
SQL RUNTIME[0.00061703s]
#####  Finished discovery run at 2017-04-15 17:04:57  #####


SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','er01-par01','1492268697.3051','0.121','1')]
SQL RUNTIME[0.00164890s]
./discovery.php: er01-par01 - 1 devices discovered in 0.121 secs

SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1492254297']
SQL RUNTIME[0.00015306s]
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.121 secs
 o Memory usage         10MB (peak: 12MB)
 o MySQL Usage          Cell[4/0.001s] Row[4/0.002s] Rows[6/0.003s] Column[0/0s] Update[1/0.001s] Insert[3/0.005s] Delete[1/0.001s] 
 o RRDTool Usage        
DEBUG!

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

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

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

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

CMD[/bin/hostname -f]

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

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


CMD[/opt/observium/scripts/distro]

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

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

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

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

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.0054s]
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.0233s]
STDOUT[
Apache/2.4.18
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.001s]
STDOUT[
+02:00
]

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

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

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

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

 o OS                   Linux 4.4.0-72-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.15-0ubuntu0.16.04.4 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.17-0ubuntu0.16.04.1 (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                

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Saturday, 15-Apr-17 17:05:07 CEST
 o PHP                  +02:00
 o MySQL                +02:00


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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00014687s]
#####  Starting discovery run at 2017-04-15 17:05:07  #####


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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0158s]
STDOUT[
sysObjectID.0 = enterprises.1991.1.3.51.5
sysUpTime.0 = 4049388297
]
SNMP STATUS[TRUE]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0163s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
28978 25507     0     0 pts/0    S+   00:00:00 Sat Apr 15 17:05:06 2017 php ./discovery.php -d -h er01-fra01 -m bgp
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('28978','discovery.php','25507','0','php ./discovery.php -d -h er01-fra01 -m bgp','1492268706','77')]
SQL RUNTIME[0.00174212s]
#####  er01-fra01 [77]  #####

 o OS Type              ironware
 o SNMP Version         v2c
 o Last discovery       2017-04-15 12:57:18
 o Last duration        112.80 seconds

#####  Module Start: bgp  #####


 o Duration             0.0001s


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.020',`force_discovery` ='0' WHERE `device_id` = '77']
SQL RUNTIME[0.00104117s]

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('77','discover','1492268707.1583','0.020284175872803')]
SQL RUNTIME[0.00067592s]
#####  er01-fra01 [77] completed discovery modules at 2017-04-15 17:05:07  #####

 o Discovery time       0.020 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '28978' AND `process_name` = 'discovery.php' AND `device_id` = '77']
SQL RUNTIME[0.00154805s]
#####  Finished discovery run at 2017-04-15 17:05:07  #####


SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','er01-fra01','1492268707.0362','0.146','1')]
SQL RUNTIME[0.00087786s]
./discovery.php: er01-fra01 - 1 devices discovered in 0.146 secs

SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1492254307']
SQL RUNTIME[0.00025797s]
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.146 secs
 o Memory usage         10MB (peak: 12MB)
 o MySQL Usage          Cell[4/0.001s] Row[4/0.002s] Rows[6/0.003s] Column[0/0s] Update[1/0.001s] Insert[3/0.004s] Delete[1/0.002s] 
 o RRDTool Usage        
DEBUG!

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

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

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

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

CMD[/bin/hostname -f]

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

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0919s]
CMD EXITDELAY[10ms]
STDOUT[
Linux|4.4.0-72-generic|amd64|Ubuntu|16.04
]

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0073s]
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.0237s]
STDOUT[
Apache/2.4.18
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0011s]
CMD EXITDELAY[10ms]
STDOUT[
+02:00
]

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

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

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

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

 o OS                   Linux 4.4.0-72-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.15-0ubuntu0.16.04.4 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.17-0ubuntu0.16.04.1 (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                

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Saturday, 15-Apr-17 17:05:11 CEST
 o PHP                  +02:00
 o MySQL                +02:00


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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00148296s]
#####  Starting discovery run at 2017-04-15 17:05:11  #####


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

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

CMD EXITCODE[0]
CMD RUNTIME[0.1163s]
CMD EXITDELAY[10ms]
STDOUT[
sysObjectID.0 = enterprises.1991.1.3.55.3.2
sysUpTime.0 = 3987680420
]
SNMP STATUS[TRUE]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0157s]
CMD EXITDELAY[10ms]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
30803 25507     0     0 pts/0    S+   00:00:00 Sat Apr 15 17:05:10 2017 php ./discovery.php -d -h er01-par01 -m bgp
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('30803','discovery.php','25507','0','php ./discovery.php -d -h er01-par01 -m bgp','1492268710','76')]
SQL RUNTIME[0.00267482s]
#####  er01-par01 [76]  #####

 o OS Type              ironware
 o SNMP Version         v2c
 o Last discovery       2017-04-15 17:04:57
 o Last duration        0.01 seconds

#####  Module Start: bgp  #####


 o Duration             0.0001s


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.031',`force_discovery` ='0' WHERE `device_id` = '76']
SQL RUNTIME[0.00340891s]

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('76','discover','1492268711.6951','0.031763076782227')]
SQL RUNTIME[0.00516415s]
#####  er01-par01 [76] completed discovery modules at 2017-04-15 17:05:11  #####

 o Discovery time       0.031 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '30803' AND `process_name` = 'discovery.php' AND `device_id` = '76']
SQL RUNTIME[0.00315785s]
#####  Finished discovery run at 2017-04-15 17:05:11  #####


SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','er01-par01','1492268711.3951','0.344','1')]
SQL RUNTIME[0.00860977s]
./discovery.php: er01-par01 - 1 devices discovered in 0.344 secs

SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1492254311']
SQL RUNTIME[0.00030899s]
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.344 secs
 o Memory usage         10MB (peak: 12MB)
 o MySQL Usage          Cell[4/0.004s] Row[4/0.005s] Rows[6/0.004s] Column[0/0s] Update[1/0.004s] Insert[3/0.017s] Delete[1/0.003s] 
 o RRDTool Usage