DEBUG!

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

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

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

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

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0043s]
STDOUT[
OBSERVIUS.domain.local
]

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


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

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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00020695s]

CMD[/opt/observium/scripts/distro]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0043s]
STDOUT[
Python 2.7.11+
]

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0078s]
STDOUT[
RRDtool 1.4.9  Copyright 1997-2013 by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[date "+%:z"]

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

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

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

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

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

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

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

 o OS                   Linux 4.4.0-28-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.4-7ubuntu2.1 (OPcache: DISABLED)
 o Python               2.7.11+
 o MySQL                5.7.12-0ubuntu1.1 (extension: mysqli 5.0.12-dev)
 o SNMP                 NET-SNMP 5.7.3
 o RRDtool              1.4.9 (rrdcached: unix:/var/run/rrdcached.sock)

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

 o MySQL                

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Friday, 08-Jul-16 08:07:49 BST
 o PHP                  +01:00
 o MySQL                +01:00


SQL[SELECT * FROM `alerts_maint` WHERE `maint_start` < '1467961669' AND `maint_end` > '1467961669']
SQL RUNTIME[0.00045300s]
#####  Starting polling run at 2016-07-08 08:07:49  #####


SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'localhost' ORDER BY `device_id` ASC]
SQL RUNTIME[0.00046301s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '76']
SQL RUNTIME[0.00034690s]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0172s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
40973 35835     0     0 pts/0    S+   00:00:00 Fri Jul  8 08:07:48 2016 php poller.php -h localhost -m system -d
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0178s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
35835 35696     0     0 pts/0    Ss   00:00:00 Fri Jul  8 08:07:14 2016 -bash
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('40973','poller.php','35835','0','php poller.php -h localhost -m system -d','1467961668','76')]
SQL RUNTIME[0.00103784s]

SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00043392s]
Cached 31 alert rules.

SQL[SELECT * FROM  `alert_table` WHERE `device_id` = '76']
SQL RUNTIME[0.00057697s]
#####  localhost [76]  #####

 o OS                   linux
 o OS Group             unix
 o Last poll duration   3.26 seconds
 o Last Polled          2016-07-08 08:03:24
 o SNMP Version         v2c

CMD[/usr/bin/fping -t 500 -c 1 -q 127.0.0.1 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0033s]
STDOUT[
127.0.0.1 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 0.07/0.07/0.07
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0386s]
STDOUT[
sysObjectID.0 = enterprises.8072.3.2.10
sysUpTime.0 = 22748636
]
SNMP STATUS[TRUE]
 o Device status        Device is reachable by PING (0.07ms) and SNMP (38.63ms)
RRD /opt/observium/rrd/localhost/status.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/localhost/status.rrd N:1 --daemon unix:/var/run/rrdcached.sock]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.09]
RRD_STATUS[TRUE]

RRD /opt/observium/rrd/localhost/ping.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/localhost/ping.rrd N:0.07 --daemon unix:/var/run/rrdcached.sock]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.09]
RRD_STATUS[TRUE]

RRD /opt/observium/rrd/localhost/ping_snmp.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/localhost/ping_snmp.rrd N:38.63 --daemon unix:/var/run/rrdcached.sock]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.09]
RRD_STATUS[TRUE]


SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '76']
SQL RUNTIME[0.00046992s]
 o Modules Enabled      system, os


including: includes/polling/system.inc.php
#####  Module Start: system  #####


CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'localhost':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0381s]
STDOUT[
sysUpTime.0 = 2:15:11:26.40
sysLocation.0 = MAID
sysContact.0 = support@domain.com
sysName.0 = OBSERVIUS
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'localhost':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0392s]
STDOUT[
Linux OBSERVIUS 4.4.0-28-generic #47-Ubuntu SMP Fri Jun 24 10:09:13 UTC 2016 x86_64
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'localhost':'161' sysObjectID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0388s]
STDOUT[
.1.3.6.1.4.1.8072.3.2.10
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Ovqn -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'localhost':'161' snmpEngineID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.039s]
STDOUT[
"80 00 1F 88 80 4E CD EE 4B 1D 5E 6E 53 00 00 00 
00 "
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00034881s]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqv -m HOST-RESOURCES-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'localhost':'161' hrSystemUptime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0405s]
STDOUT[
2:15:11:37.52
]
SNMP STATUS[TRUE]
Using SNMP Agent hrSystemUptime (227497 sec. => 2 days, 15h 11m 37s)
RRD /opt/observium/rrd/localhost/uptime.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/localhost/uptime.rrd N:227497 --daemon unix:/var/run/rrdcached.sock]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.30]
RRD_STATUS[TRUE]

 o Uptime               2 days, 15h 11m 37s


> $uptimes - /opt/observium/poller.php:170
/opt/observium/includes/polling/system.inc.php:188
===============================================
array(
  [sysUpTime]      => int(227486)
  [hrSystemUptime] => int(227497)
  [use]            => string(14) "hrSystemUptime"
  [uptime]         => int(227497)
  [formatted]      => string(19) "2 days, 15h 11m 37s"
  [message]        => string(31) "Using SNMP Agent hrSystemUptime"
  [previous]       => string(6) "227229"
  [diff]           => int(-268)
  [rebooted]       => int(0)
)
 o sysObjectID          .1.3.6.1.4.1.8072.3.2.10
 o snmpEngineID         80001F88804ECDEE4B1D5E6E5300000000
 o sysDescr             Linux OBSERVIUS 4.4.0-28-generic #47-Ubuntu SMP Fri Jun 24 10:09:13 UTC 2016 x86_64
 o sysName              observius
 o Location             MAID

SQL[SELECT * FROM `devices_locations` WHERE `device_id` = '76']
SQL RUNTIME[0.00045919s]
 o Module time          0.2075s


including: includes/polling/os.inc.php
#####  Module Start: os  #####


SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '76' AND `entPhysicalContainedIn` = '0']
SQL RUNTIME[0.00028610s]
 o OS Poller            Group

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqv -m MIB-Dell-10892 -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/dell 'udp':'localhost':'161' chassisModelName.1]

CMD EXITCODE[0]
CMD RUNTIME[0.0518s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = '76' AND `error_code` = '1000' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-Oqv' AND `mib` = 'MIB-Dell-10892' AND `oid` = 'chassisModelName.1';]
SQL RUNTIME[0.00041699s]

SQL[UPDATE `snmp_errors` set `error_count` ='75746',`updated` ='1467961669' WHERE `error_id` = '1352']
SQL RUNTIME[0.00150990s]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqv -m CPQSINFO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hp 'udp':'localhost':'161' cpqSiProductName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0478s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = '76' AND `error_code` = '1000' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-Oqv' AND `mib` = 'CPQSINFO-MIB' AND `oid` = 'cpqSiProductName.0';]
SQL RUNTIME[0.00026894s]

SQL[UPDATE `snmp_errors` set `error_count` ='75746',`updated` ='1467961669' WHERE `error_id` = '1355']
SQL RUNTIME[0.00206614s]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqv -m UCD-SNMP-MIB -M /opt/observium/mibs 'udp':'localhost':'161' .1.3.6.1.4.1.2021.7890.1.3.1.1.6.100.105.115.116.114.111]

CMD EXITCODE[0]
CMD RUNTIME[0.0385s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = '76' AND `error_code` = '1000' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-Oqv' AND `mib` = 'UCD-SNMP-MIB' AND `oid` = '.1.3.6.1.4.1.2021.7890.1.3.1.1.6.100.105.115.116.114.111';]
SQL RUNTIME[0.00035906s]

SQL[UPDATE `snmp_errors` set `error_count` ='75746',`updated` ='1467961669' WHERE `error_id` = '1356']
SQL RUNTIME[0.00179195s]

CMD[/usr/bin/snmpget -t '5' -r '3' -v2c -c *** -Pu -Oqv -m UCD-SNMP-MIB -M /opt/observium/mibs 'udp':'localhost':'161' .1.3.6.1.4.1.2021.7890.1.101.1]

CMD EXITCODE[0]
CMD RUNTIME[0.0427s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = '76' AND `error_code` = '1000' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-Oqv' AND `mib` = 'UCD-SNMP-MIB' AND `oid` = '.1.3.6.1.4.1.2021.7890.1.101.1';]
SQL RUNTIME[0.00039315s]

SQL[UPDATE `snmp_errors` set `error_count` ='75746',`updated` ='1467961669' WHERE `error_id` = '1358']
SQL RUNTIME[0.00264883s]
 o Hardware             Generic x86 [64bit]
 o Version              4.4.0-28-generic
 o Features             <empty>
 o Serial               <empty>
 o Asset                <empty>


SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('76','76','device',NOW(),'6','Arch -> ')]
SQL RUNTIME[0.00201106s]
 o Module time          0.2057s

#####  localhost [76] completed poller modules at 2016-07-08 08:07:49  #####

 o Graphs [checked]     ping, ping_snmp, uptime
 o Poller time          0.464 seconds
Updating localhost - 

> $update_array
========
array(
  [uptime]                => int(227497)
  [arch]                  => null
  [last_polled]           => array(
                               [0] => string(5) "NOW()"
                             )
  [last_polled_timetaken] => double(0.464)
  [device_state]          => string(101) "a:1:{s:15:"poller_mod_perf";a:2:{s:6:"system";d:0.20749999999999999;s:2:"os";d:0.20569999999999999;}}"
)
 

SQL[UPDATE `devices` set `uptime` ='227497',`arch` ='',`last_polled` =NOW(),`last_polled_timetaken` ='0.464',`device_state` ='a:1:{s:15:\"poller_mod_perf\";a:2:{s:6:\"system\";d:0.20749999999999999;s:2:\"os\";d:0.20569999999999999;}}' WHERE `device_id` = '76']
SQL RUNTIME[0.00285101s]
 o Updated Data         uptime, arch, last_polled, last_polled_timetaken, device_state


> $data - /opt/observium/poller.php:170
/opt/observium/includes/alerts.inc.php:61
=========================================
array(
  [device_status]        => string(1) "1"
  [device_status_type]   => string(0) ""
  [device_ping]          => string(4) "0.07"
  [device_snmp]          => string(5) "38.63"
  [device_uptime]        => string(6) "227229"
  [device_rebooted]      => int(0)
  [device_duration_poll] => string(4) "3.26"
)

SQL[UPDATE `alert_table` set `state` ='{\"metrics\":{\"device_duration_poll\":\"3.26\"}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1467961669',`last_ok` ='1467961669' WHERE `alert_table_id` = '52575']
SQL RUNTIME[0.00257111s]
RRD /opt/observium/rrd/localhost/alert-52575.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/localhost/alert-52575.rrd N:1:1 --daemon unix:/var/run/rrdcached.sock]
RRD RUNTIME[0.0012s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.51]
RRD_STATUS[TRUE]



SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '40973' AND `process_name` = 'poller.php' AND `device_id` = '76']
SQL RUNTIME[0.00295496s]

SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('poll','localhost','1467961669.0871','0.682','1')]
SQL RUNTIME[0.00160718s]
poller.php: localhost - 1 devices polled in 0.682 secs
#####  Completed polling run at 2016-07-08 08:07:49  #####

NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
 o Devices Polled       1
 o Poller Time          0.682 secs
 o Memory usage         8MB (peak: 8MB)
 o MySQL Usage          Cell[4/0.002s] Row[12/0.007s] Rows[10/0.013s] Column[0/0s] Update[6/0.014s] Insert[3/0.005s] Delete[1/0.003s] 
 o RRDTool Usage        update[5/0.006s]