DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.0151s]
STDOUT[
Path: .
Working Copy Root Path: /u1/observium
URL: http://svn.observium.org/svn/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 9750
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 9750
Last Changed Date: 2019-03-08 09:59:52 -0500 (Fri, 08 Mar 2019)

]

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

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

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

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

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


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

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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00008321s]
There is a newer revision of Observium available!

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0024s]
CMD EXITDELAY[10ms]
STDOUT[
-05:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00011778s]
Version 19.3.9752 (8th March 2019) is 2 revisions ahead.


CMD[/u1/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0263s]
STDOUT[
Linux|3.10.0-862.3.3.el7.x86_64|amd64|CentOS|7||
]

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

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

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0024s]
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.0035s]
STDOUT[

]

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

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

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

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

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

 o OS                   Linux 3.10.0-862.3.3.el7.x86_64 [amd64] (CentOS 7)
 o Apache               2.4.6
 o PHP                  7.0.31 (OPcache: DISABLED)
 o Python               2.7.5
 o MySQL                5.5.56-MariaDB (extension: mysqli 5.5.56-MariaDB)
 o SNMP                 NET-SNMP 5.7.2
 o RRDtool              1.6.0
 o Fping                3.10 (IPv4 only)

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

 o PHP                  1GB

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

 o MySQL                

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Friday, 08-Mar-19 15:50:44 EST
 o PHP                  -05:00
 o MySQL                -05:00


SQL[SELECT * FROM `alerts_maint` WHERE `maint_start` < '1552078244' AND `maint_end` > '1552078244']
SQL RUNTIME[0.00021696s]
#####  Starting polling run at 2019-03-08 15:50:44  #####


SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `device_id` = '204' AND `poller_id` = '0' ORDER BY `device_id` ASC]
SQL RUNTIME[0.00021601s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '204']
SQL RUNTIME[0.00026798s]

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

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

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('52229','poller.php','52228','48','php ./poller.php -h 204 -d','1552078244','204')]
SQL RUNTIME[0.00022292s]

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

SQL[SELECT * FROM  `alert_table` WHERE `device_id` = '204']
SQL RUNTIME[0.00016379s]
#####  sfpdu04-01a [204]  #####

 o OS                   poweralert
 o Last poll duration   84.49 seconds
 o Last Polled          2019-03-08 15:46:26
 o SNMP Version         v2c

CMD[/usr/sbin/fping -t 500 -c 1 -q 172.20.3.89 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0036s]
CMD EXITDELAY[10ms]
STDOUT[
172.20.3.89 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 1.07/1.07/1.07
]

CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /u1/observium/mibs/rfc:/u1/observium/mibs/net-snmp 'udp':'sfpdu04-01a':'161' sysObjectID.0 sysUpTime.0]

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

]
STDERR[
Timeout: No Response from udp:sfpdu04-01a:161.
]
SNMP STATUS[FALSE]
 o Device status        Device is not responding to SNMP requests

SQL[UPDATE `devices` set `status` ='0' WHERE device_id = '204']
SQL RUNTIME[0.00051594s]

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('204','204','device',NOW(),'3','Device status changed to Down (snmp)')]
SQL RUNTIME[0.00037503s]
RRD /u1/observium/rrd/sfpdu04-01a/status.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/status.rrd N:0]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.04]
RRD_STATUS[TRUE]

RRD /u1/observium/rrd/sfpdu04-01a/ping.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/ping.rrd N:1.07]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.04]
RRD_STATUS[TRUE]

RRD /u1/observium/rrd/sfpdu04-01a/ping_snmp.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/ping_snmp.rrd N:U]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.04]
RRD_STATUS[TRUE]

 o Poller time          6.0488 seconds
RRD /u1/observium/rrd/sfpdu04-01a/perf-poller.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/perf-poller.rrd N:6.0488]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.04]
RRD_STATUS[TRUE]


SQL[INSERT INTO `alert_log` (`alert_test_id`,`device_id`,`entity_type`,`entity_id`,`timestamp`,`log_type`,`message`)  VALUES ('2','204','device','204',NOW(),'FAIL_DELAYED','Checks failed but alert delayed')]
SQL RUNTIME[0.00051689s]

SQL[UPDATE `alert_table` set `state` ='{\"metrics\":{\"device_status\":\"0\"},\"failed\":[{\"value\":\"0\",\"condition\":\"equals\",\"metric\":\"device_status\"}]}',`count` ='1',`alert_status` ='2',`last_message` ='Checks failed (delayed)',`last_checked` ='1552078250',`last_changed` ='1552078250',`last_failed` ='1552078250' WHERE `alert_table_id` = '57200']
SQL RUNTIME[0.00027704s]
RRD /u1/observium/rrd/sfpdu04-01a/alert-57200.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/alert-57200.rrd N:0:2]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.05]
RRD_STATUS[TRUE]



SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '52229' AND `process_name` = 'poller.php' AND `device_id` = '204']
SQL RUNTIME[0.00038886s]
./poller.php: sfpdu04-01a - 1 devices polled in 6.171 secs
#####  Completed polling run at 2019-03-08 15:50:50  #####

RRD /u1/observium/rrd/sfpdu04-01a/perf-pollerdb.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/perf-pollerdb.rrd N:3:0.00155616:2:0.00107527:1:0.00051403:4:0.00086307525634766:0:0:6:0.0015537738800049:8:0.0027379989624023:24:0.0083003080987549]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.05]
RRD_STATUS[TRUE]

RRD /u1/observium/rrd/sfpdu04-01a/perf-pollermemory.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/perf-pollermemory.rrd N:12582912:12582912]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.05]
RRD_STATUS[TRUE]

RRD /u1/observium/rrd/sfpdu04-01a/perf-pollersnmp.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/perf-pollersnmp.rrd N:1:6.0239288806915:U:U:U:U:1:6.0239288806915]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.05]
RRD_STATUS[TRUE]

RRD /u1/observium/rrd/sfpdu04-01a/perf-pollersnmp_errors.rrd already exists - no need to create.

RRD CMD[update /u1/observium/rrd/sfpdu04-01a/perf-pollersnmp_errors.rrd N:2:12.047857761383:U:U:2:12.047857761383]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:6.05]
RRD_STATUS[TRUE]

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          6.171 secs
 o Memory usage         12MB (peak: 12MB)
 o MySQL Usage          Insert[3/0.002s] Update[2/0.001s] Delete[1/0.001s] Cell[4/0.001s] Row[6/0.002s] Rows[8/0.003s] Col[0/0s] (0.008s 
                        0.135%)
 o RRDTool Usage        update[9/0.01s] (0.01s 0.158%)
 o SNMP Usage           errors[/0s] snmpget[1/6.024s] (6.024s 97.617%)