DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.0086s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/branches/stable
Relative URL: ^/observium/branches/stable
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 8697
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 8697
Last Changed Date: 2017-07-14 12:41:22 +0200 (Fri, 14 Jul 2017)

]

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

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

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

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

CMD[/bin/hostname -f]

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

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


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

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

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

CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0082s]
STDOUT[
Linux|4.4.0-81-generic|amd64|Ubuntu|16.04|vmware
]

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

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

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

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

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

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

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

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

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

CMD[date "+%:z"]

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

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

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

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

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

 o OS                   Linux 4.4.0-81-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.18-0ubuntu0.16.04.1 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.18-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                 Wednesday, 19-Jul-17 11:32:23 CEST
 o PHP                  +02:00
 o MySQL                +02:00


SQL[SELECT * FROM `alerts_maint` WHERE `maint_start` < '1500456743' AND `maint_end` > '1500456743']
SQL RUNTIME[0.00046802s]
#####  Starting polling run at 2017-07-19 11:32:23  #####


SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'er01-fra01' ORDER BY `device_id` ASC]
SQL RUNTIME[0.00042391s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '77']
SQL RUNTIME[0.00031090s]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.01s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
21958 21954     0     0 ?        S    00:00:00 Wed Jul 19 11:30:01 2017 php /opt/observium/poller.php -q -h 77
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.01s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
25947 24162     0     0 pts/0    S+   00:00:00 Wed Jul 19 11:32:22 2017 php ./poller.php -d -h er01-fra01
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0101s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
24162 24045     0     0 pts/0    Ss   00:00:00 Wed Jul 19 11:31:20 2017 -bash
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('25947','poller.php','24162','0','php ./poller.php -d -h er01-fra01','1500456742','77')]
SQL RUNTIME[0.00161600s]

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

SQL[SELECT * FROM  `alert_table` WHERE `device_id` = '77']
SQL RUNTIME[0.00137997s]
#####  er01-fra01 [77]  #####

 o OS                   ironware
 o Last poll duration   258.37 seconds
 o Last Polled          2017-07-19 11:29:20
 o SNMP Version         v2c

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

CMD EXITCODE[0]
CMD RUNTIME[0.0157s]
STDOUT[
10.100.1.254 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 14.1/14.1/14.1
]

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[1]
CMD RUNTIME[6.0104s]
STDOUT[

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

SQL[UPDATE `devices` set `status` ='0' WHERE device_id = '77']
SQL RUNTIME[0.00162697s]

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('77','77','device',NOW(),'3','Device status changed to Down (snmp)')]
SQL RUNTIME[0.00121808s]
RRD /opt/observium/rrd/er01-fra01/status.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/er01-fra01/status.rrd N:0]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:6.07]
RRD_STATUS[TRUE]

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

RRD CMD[update /opt/observium/rrd/er01-fra01/ping.rrd N:14.1]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:6.07]
RRD_STATUS[TRUE]

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

RRD CMD[update /opt/observium/rrd/er01-fra01/ping_snmp.rrd N:U]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:6.07]
RRD_STATUS[TRUE]


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

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

RRD CMD[update /opt/observium/rrd/er01-fra01/alert-17.rrd N:0:2]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:6.07]
RRD_STATUS[TRUE]


SQL[UPDATE `alert_table` set `state` ='{\"metrics\":{\"mempool_perc\":null}}',`count` ='0',`alert_status` ='1',`last_message` ='Checks OK',`last_checked` ='1500456749',`last_ok` ='1500456749' WHERE `alert_table_id` = '1963']
SQL RUNTIME[0.00109601s]
RRD /opt/observium/rrd/er01-fra01/alert-1963.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/er01-fra01/alert-1963.rrd N:1:1]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:6.08]
RRD_STATUS[TRUE]



SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '25947' AND `process_name` = 'poller.php' AND `device_id` = '77']
SQL RUNTIME[0.00055289s]

SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('poll','er01-fra01','1500456743.0516','6.158','1')]
SQL RUNTIME[0.00100398s]
./poller.php: er01-fra01 - 1 devices polled in 6.158 secs
#####  Completed polling run at 2017-07-19 11:32:29  #####

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.158 secs
 o Memory usage         12MB (peak: 12MB)
 o MySQL Usage          Insert[4/0.006s] Update[3/0.004s] Delete[1/0.001s] Cell[4/0.002s] Row[6/0.002s] Rows[8/0.021s] Col[0/0s] (0.035s 
                        0.571%)
 o RRDTool Usage        update[5/0.005s] (0.005s 0.089%)
 o SNMP Usage           snmpget[1/6.012s] (6.012s 97.625%)