DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.0098s]
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: 8843
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 8841
Last Changed Date: 2017-09-12 16:30:58 +0200 (Tue, 12 Sep 2017)

]

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

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

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

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

CMD[/bin/hostname -f]

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

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


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

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

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

CMD[date "+%:z"]

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

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00129604s]
Version 17.9.8859 (15th October 2017) is 18 revisions ahead.


CMD[/opt/observium/scripts/distro]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0033s]
CMD EXITDELAY[10ms]
STDOUT[
Python 2.7.12
]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0027s]
CMD EXITDELAY[10ms]
STDOUT[
NET-SNMP version: 5.7.3
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0096s]
CMD EXITDELAY[10ms]
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.0264s]
CMD EXITDELAY[10ms]
STDOUT[
Apache/2.4.18
]

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

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

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

 o OS                   Linux 4.4.0-93-generic [amd64] (Ubuntu 16.04)
 o Apache               2.4.18
 o PHP                  7.0.22-0ubuntu0.16.04.1 (OPcache: DISABLED)
 o Python               2.7.12
 o MySQL                5.7.19-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                 Sunday, 15-Oct-17 00:05:20 CEST
 o PHP                  +02:00
 o MySQL                +02:00


SQL[SELECT * FROM `alerts_maint` WHERE `maint_start` < '1508018720' AND `maint_end` > '1508018720']
SQL RUNTIME[0.00050688s]
#####  Starting polling run at 2017-10-15 00:05:20  #####


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

SQL[SELECT * FROM `devices` WHERE `device_id` = '92']
SQL RUNTIME[0.00035596s]

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.027s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
21967  9407     0     0 pts/0    S+   00:00:00 Sun Oct 15 00:05:20 2017 php ./poller.php -m os -d -h cons01-fra01
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0212s]
STDOUT[
  PID  PPID   UID   GID TT       STAT     TIME                  STARTED COMMAND
 9407  9376     0     0 pts/0    Ss   00:00:00 Sun Oct 15 00:04:50 2017 -bash
]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('21967','poller.php','9407','0','php ./poller.php -m os -d -h cons01-fra01','1508018720','92')]
SQL RUNTIME[0.00100589s]

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

SQL[SELECT * FROM  `alert_table` WHERE `device_id` = '92']
SQL RUNTIME[0.00053501s]
#####  cons01-fra01 [92]  #####

 o OS                   ios
 o OS Group             cisco
 o Last poll duration   4.61 seconds
 o Last Polled          2017-10-15 00:05:18
 o SNMP Version         v2c

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

CMD EXITCODE[0]
CMD RUNTIME[0.0168s]
CMD EXITDELAY[10ms]
STDOUT[
10.100.1.9 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 14.3/14.3/14.3
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0226s]
STDOUT[
sysObjectID.0 = enterprises.9.1.471
sysUpTime.0 = 28696554
]
SNMP STATUS[TRUE]
 o Device status        Device is reachable by PING (14.3ms) and SNMP (22.59ms)
RRD /opt/observium/rrd/cons01-fra01/status.rrd already exists - no need to create.

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

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

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

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

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


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


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


SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00027180s]
 o SNMPv2-MIB           
CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'cons01-fra01':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0233s]
STDOUT[
sysUpTime.0 = 3:7:42:45.57
sysLocation.0 = Interxion FRA07 (FRA01)
sysContact.0 = noc@prodware.fr 
sysName.0 = cons01-fra01.dom.prodware.net
]
SNMP STATUS[TRUE]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0225s]
STDOUT[
Cisco IOS Software, C2600 Software (C2600-ADVSECURITYK9-M), Version 12.4(15)T14, RELEASE SOFTWARE (fc2)

Technical Support: http://www.cisco.com/techsupport

Copyright (c) 1986-2010 by Cisco Systems, Inc.

Compiled Tue 17-Aug-10 05:40 by prod_rel_team
]
SNMP STATUS[TRUE]

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

CMD EXITCODE[0]
CMD RUNTIME[0.022s]
STDOUT[
.1.3.6.1.4.1.9.1.471
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'cons01-fra01':'161' snmpEngineID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0228s]
STDOUT[
"80 00 00 09 03 00 00 13 19 3B 82 80 "
]
SNMP STATUS[TRUE]


CMD[/usr/bin/snmpget -v2c -c *** -Pu -OUqv -m SNMP-FRAMEWORK-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'cons01-fra01':'161' snmpEngineTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0215s]
STDOUT[
286946
]
SNMP STATUS[TRUE]
Using SNMP Agent sysUpTime (286965 sec. => 3 days, 7h 42m 45s)
RRD /opt/observium/rrd/cons01-fra01/uptime.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/cons01-fra01/uptime.rrd N:286965]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.00 r:0.23]
RRD_STATUS[TRUE]

 o Uptime               3 days, 7h 42m 45s


  /opt/observium/includes/polling/system.inc.php:253 
array(
  [sysUpTime]      => int(286965)
  [use]            => string(9) "sysUpTime"
  [snmpEngineTime] => string(6) "286946"
  [uptime]         => int(286965)
  [formatted]      => string(18) "3 days, 7h 42m 45s"
  [message]        => string(26) "Using SNMP Agent sysUpTime"
  [previous]       => string(6) "286959"
  [diff]           => int(-6)
  [rebooted]       => int(0)
)
 o sysObjectID          .1.3.6.1.4.1.9.1.471
 o snmpEngineID         8000000903000013193B8280
 o sysDescr             Cisco IOS Software, C2600 Software (C2600-ADVSECURITYK9-M), Version 12.4(15)T14, RELEASE SOFTWARE (fc2) 
                        Technical Support: http://www.cisco.com/techsupport
                        Copyright (c) 1986-2010 by Cisco Systems, Inc.
                        Compiled Tue 17-Aug-10 05:40 by prod_rel_team
 o sysName              cons01-fra01.dom.prodware.net
 o Location             Interxion FRA07 (FRA01)

SQL[SELECT * FROM `devices_locations` WHERE `device_id` = '92']
SQL RUNTIME[0.00034618s]
 o Module time          0.1261s


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


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

CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB:CISCO-CONFIG-MAN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'cons01-fra01':'161' sysUpTime.0 ccmHistoryRunningLastChanged.0 ccmHistoryRunningLastSaved.0 ccmHistoryStartupLastChanged.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0349s]
STDOUT[
sysUpTime.0 = 28696571
ccmHistoryRunningLastChanged.0 = 3049
ccmHistoryRunningLastSaved.0 = 0
ccmHistoryStartupLastChanged.0 = 0
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '92' AND `entPhysicalClass` = 'module' AND `entPhysicalContainedIn` = '1' AND `entPhysicalSerialNum` != '']
SQL RUNTIME[0.00043488s]
 o Hardware             ..................
 o Version              12.4(15)T14
 o Features             ADVSECURITYK9
 o Serial               JHY0903K1X2
 o Asset                <empty>

#####  Cisco configuration ages  #####

 o sysUptime            2017-10-11 16:22:35 | 3 days, 7h 42m 45s
 o Running              2017-10-11 16:23:05 | 3 days, 7h 42m 15s
 o Saved                2017-10-11 16:22:35 | 3 days, 7h 42m 45s
 o Startup              2017-10-11 16:22:35 | 3 days, 7h 42m 45s

 o Module time          0.0395s

#####  cons01-fra01 [92] completed poller modules at 2017-10-15 00:05:21  #####

 o Graphs [checked]     ping, ping_snmp, uptime
 o Poller time          0.2253 seconds
Updating cons01-fra01 - 

 > $update_array /opt/observium/includes/polling/functions.inc.php:752 
array(
  [uptime]                => int(286965)
  [last_polled]           => array(
                               [0] => string(5) "NOW()"
                             )
  [last_polled_timetaken] => double(0.2253)
  [device_state]          => string(88) "a:1:{s:15:"poller_mod_perf";a:2:{s:6:"system";d:0.12609999999999999;s:2:"os";d:0.0395;}}"
)
 

SQL[UPDATE `devices` set `uptime` ='286965',`last_polled` =NOW(),`last_polled_timetaken` ='0.2253',`device_state` ='a:1:{s:15:\"poller_mod_perf\";a:2:{s:6:\"system\";d:0.12609999999999999;s:2:\"os\";d:0.0395;}}' WHERE `device_id` = '92']
SQL RUNTIME[0.00898600s]
 o Updated Data         uptime, last_polled, last_polled_timetaken, device_state

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

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


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

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



SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '21967' AND `process_name` = 'poller.php' AND `device_id` = '92']
SQL RUNTIME[0.00141382s]

SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('poll','cons01-fra01','1508018720.6113','0.425','1')]
SQL RUNTIME[0.00059700s]
./poller.php: cons01-fra01 - 1 devices polled in 0.425 secs
#####  Completed polling run at 2017-10-15 00:05:21  #####

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.425 secs
 o Memory usage         12MB (peak: 14MB)
 o MySQL Usage          Insert[2/0.002s] Update[3/0.012s] Delete[1/0.002s] Cell[4/0.002s] Row[9/0.004s] Rows[10/0.007s] Col[0/0s] (0.029s 
                        6.827%)
 o RRDTool Usage        update[6/0.007s] (0.007s 1.571%)
 o SNMP Usage           snmpget[7/0.178s] (0.178s 41.916%)