DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.0115s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 10377
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 10377
Last Changed Date: 2020-04-16 16:38:29 +0200 (Thu, 16 Apr 2020)

]

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

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

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00004506s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

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

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

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


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

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

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

CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0119s]
STDOUT[
Linux|3.10.0-1062.18.1.el7.x86_64|amd64|CentOS|7|vmware|
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0026s]
STDOUT[
Python 2.7.5
]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0046s]
STDOUT[
NET-SNMP version: 5.7.2
]

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

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

CMD[/usr/sbin/fping -v 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0019s]
CMD EXITDELAY[10ms]
STDOUT[
/usr/sbin/fping: Version 3.10
/usr/sbin/fping: comments to david@schweikert.ch
]

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

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

]

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

CMD EXITCODE[0]
CMD RUNTIME[0.025s]
STDOUT[
Apache/2.4.6
]

CMD[date "+%:z"]

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

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

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

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

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

 o OS                   Linux 3.10.0-1062.18.1.el7.x86_64 [amd64] (CentOS 7)
 o Apache               2.4.6
 o PHP                  7.3.16
 o Python               2.7.5
 o MySQL                10.3.21-MariaDB-log (extension: mysqli 5.0.12-dev)
 o SNMP                 NET-SNMP 5.7.2
 o RRDtool              1.4.8
 o Fping                3.10 (IPv4 only)

#####  Memory Limit  #####

 o PHP                  512MB

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

 o MySQL                NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Monday, 20-Apr-20 13:34:04 CEST
 o PHP                  +02:00
 o MySQL                +02:00


SQL[SELECT * FROM `alerts_maint` WHERE `maint_start` < '1587382444' AND `maint_end` > '1587382444']
SQL RUNTIME[0.00019002s]
#####  Starting polling run at 2020-04-20 13:34:04  #####


SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'ipcam-wlan-master.fqdn.net' AND `poller_id` = '0' ORDER BY `device_id` ASC]
SQL RUNTIME[0.00028396s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '1839']
SQL RUNTIME[0.00023603s]

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

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

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('12469','poller.php','7753','0','php ./poller.php -h ipcam-wlan-master.fqdn.net -m os -d','1587382444','1839')]
SQL RUNTIME[0.00134015s]

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

SQL[SELECT * FROM  `alert_table` WHERE `device_id` = '1839']
SQL RUNTIME[0.00016499s]
#####  ipcam-wlan-master.fqdn.net [1839]  #####

 o OS                   unifi
 o Last poll duration   0.39 seconds
 o Last Polled          2020-04-20 13:33:35
 o SNMP Version         v2c

CMD[/usr/sbin/fping -t 2000 -c 1 -q 10.10.23.90 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0323s]
CMD EXITDELAY[10ms]
STDOUT[
10.10.23.90 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 29.9/29.9/29.9
]

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0329s]
STDOUT[
sysObjectID.0 = enterprises.8072.3.2.10
sysUpTime.0 = 32:0:22:12.49
]
SNMP STATUS[TRUE]
 o Device status        Device is reachable by PING (29.9ms) and SNMP (32.95ms)
RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/status.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/ipcam-wlan-master.fqdn.net/status.rrd N:1]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.08]
RRD_STATUS[TRUE]

RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping.rrd N:29.9]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.08]
RRD_STATUS[TRUE]

RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping_snmp.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/ipcam-wlan-master.fqdn.net/ping_snmp.rrd N:32.95]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.08]
RRD_STATUS[TRUE]


SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '1839']
SQL RUNTIME[0.00023103s]


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


SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '1839' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00020909s]
 o SNMPv2-MIB           
CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0329s]
STDOUT[
sysUpTime.0 = 32:0:22:12.53
sysLocation.0 = Unknown
sysContact.0 = root@localhost
sysName.0 = APMesh-PRO
]
SNMP STATUS[TRUE]
Timeticks converted 32:0:22:12.53 -> 2766132

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0325s]
STDOUT[
UAP-AC-Mesh-Pro 4.0.80.10875
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' sysObjectID.0]

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

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' snmpEngineID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0323s]
STDOUT[
"80 00 1F 88 80 39 FD 6D 87 5E 6D 01 98 "
]
SNMP STATUS[TRUE]


CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m UBNT-UniFi-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'ipcam-wlan-master.fqdn.net':'161' unifiApSystemUptime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0336s]
STDOUT[
2766169
]
SNMP STATUS[TRUE]
Added System Uptime from SNMP definition walk: 'device_uptime' = '2766169'
Using device MIB poller sysUpTime: UBNT-UniFi-MIB::unifiApSystemUptime.0 (2766169 sec. => 32 days, 22m 49s)
RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/uptime.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/ipcam-wlan-master.fqdn.net/uptime.rrd N:2766169]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.25]
RRD_STATUS[TRUE]

 o Uptime               32 days, 22m 49s
 o Last reboot          2020-03-19 13:11:52


  /opt/observium/includes/polling/system.inc.php:314 
array(
  [use]           => string(13) "device_uptime"
  [sysUpTime]     => int(2766132)
  [message]       => string(72) "Using device MIB poller sysUpTime: UBNT-UniFi-MIB::unifiApSystemUptime.0"
  [device_uptime] => double(2766169)
  [uptime]        => double(2766169)
  [formatted]     => string(16) "32 days, 22m 49s"
  [previous]      => string(7) "2766140"
  [diff]          => double(-29)
  [last_rebooted] => string(10) "1584616312"
  [rebooted]      => int(0)
)

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUsn -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ipcam-wlan-master.fqdn.net':'161' .1.3.6.1.4.1.2021.10.1.5.1 .1.3.6.1.4.1.2021.10.1.5.2 .1.3.6.1.4.1.2021.10.1.5.3]

CMD EXITCODE[0]
CMD RUNTIME[0.0337s]
STDOUT[
.1.3.6.1.4.1.2021.10.1.5.1 = 11
.1.3.6.1.4.1.2021.10.1.5.2 = 15
.1.3.6.1.4.1.2021.10.1.5.3 = 13
]
SNMP STATUS[TRUE]
RRD old file not found: '/opt/observium/rrd/ipcam-wlan-master.fqdn.net/ucd_load.rrd'
RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/la.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/ipcam-wlan-master.fqdn.net/la.rrd N:11:15:13]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.29]
RRD_STATUS[TRUE]

 o Load average         0.11, 0.15, 0.13
 o sysObjectID          .1.3.6.1.4.1.8072.3.2.10
 o snmpEngineID         80001F888039FD6D875E6D0198
 o sysDescr             UAP-AC-Mesh-Pro 4.0.80.10875
 o sysName              APMesh-PRO
 o Location             Unknown

SQL[SELECT * FROM `devices_locations` WHERE `device_id` = '1839']
SQL RUNTIME[0.00020099s]
 o Module time          0.2090s


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


CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m UBNT-UniFi-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'ipcam-wlan-master.fqdn.net':'161' unifiApSystemVersion.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0337s]
STDOUT[
4.0.80.10875
]
SNMP STATUS[TRUE]
Added OS param from SNMP definition walk: 'version' = '4.0.80.10875'

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUv -m UBNT-UniFi-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ubiquiti 'udp':'ipcam-wlan-master.fqdn.net':'161' unifiApSystemModel.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0341s]
STDOUT[
UAP-AC-Mesh-Pro
]
SNMP STATUS[TRUE]
  String 'UAP-AC-Mesh-Pro' transformed by action [regex_replace] to: 'UniFi AP-AC-Mesh-Pro'
Added OS param from SNMP definition walk: 'hardware' = 'UniFi AP-AC-Mesh-Pro'
 o OS Poller            OS
 o Vendor               Ubiquiti
 o Hardware             UniFi AP-AC-Mesh-Pro
 o Version              4.0.80.10875
 o Features             <empty>
 o Serial               <empty>
 o Asset                <empty>

 o Module time          0.0712s

#####  ipcam-wlan-master.fqdn.net [1839] completed poller modules at 2020-04-20 13:34:04  #####

 o Graphs [checked]     availability, ping, ping_snmp, uptime, la
 o Poller time          0.3655 seconds
Updating ipcam-wlan-master.fqdn.net - 

 > $update_array /opt/observium/includes/polling/functions.inc.php:468 
array(
  [uptime]                => double(2766169)
  [last_polled]           => array(
                               [0] => string(5) "NOW()"
                             )
  [last_polled_timetaken] => double(0.3655)
)
 

SQL[UPDATE `devices` set `uptime` ='2766169',`last_polled` =NOW(),`last_polled_timetaken` ='0.3655' WHERE `device_id` = '1839']
SQL RUNTIME[0.00180101s]
 o Updated Data         uptime, last_polled, last_polled_timetaken

SQL[UPDATE `alert_table` set `state` ='{\"metrics\":{\"device_status\":\"1\"}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1587382444',`last_ok` ='1587382444' WHERE `alert_table_id` = '465923']
SQL RUNTIME[0.00132012s]
RRD /opt/observium/rrd/ipcam-wlan-master.fqdn.net/alert-465923.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/ipcam-wlan-master.fqdn.net/alert-465923.rrd N:1:1]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.36]
RRD_STATUS[TRUE]



SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '12469' AND `process_name` = 'poller.php' AND `device_id` = '1839']
SQL RUNTIME[0.00120902s]
./poller.php: ipcam-wlan-master.fqdn.net - 1 devices polled in 0.459 secs
#####  Completed polling run at 2020-04-20 13:34:04  #####

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.459 secs
 o Memory usage         16MB (peak: 16MB)
 o MySQL Usage          Insert[1/0.001s] Update[2/0.003s] Delete[1/0.001s] Cell[4/0.001s] Row[7/0.001s] Rows[10/0.003s] Col[1/0s] (0.011s 
                        2.459%)
 o RRDTool Usage        update[6/0.006s] (0.006s 1.411%)
 o SNMP Usage           snmpget[9/0.298s] (0.298s 64.957%)