DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.0068s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/trunk
Relative URL: ^/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 10542
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 10542
Last Changed Date: 2020-07-01 19:54:24 +0100 (Wed, 01 Jul 2020)

]

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

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

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

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

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

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0629s]
STDOUT[
Linux|5.5.8-1.el7.elrepo.x86_64|amd64|CentOS|7|kvm|
]

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

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

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

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

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0075s]
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.0024s]
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.0034s]
STDOUT[

]

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

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

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0025s]
CMD EXITDELAY[10ms]
STDOUT[
+01:00
]

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

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

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

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

 o OS                   Linux 5.5.8-1.el7.elrepo.x86_64 [amd64] (CentOS 7)
 o Apache               2.4.6
 o PHP                  7.2.28 (OPcache: DISABLED)
 o Python               2.7.5
 o MySQL                5.7.29-32 (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                  128MB

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

 o MySQL                NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

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

 o PHP                  UTF-8
 o MySQL                utf8

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

 o Date                 Thursday, 02-Jul-20 15:29:45 UTC
 o PHP                  +00:00
 o MySQL                +01:00


SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00023794s]
HTTP CURL cmd:
curl --connect-timeout 15 -X POST -H 'Connection: close' -H 'Content-Length: 60' -H 'User-Agent: Observium/20.7.10542' -d 'stats=YToxOntzOjc6InZlcnNpb24iO3M6MTA6IjIwLjcuMTA1NDIiO30%3D' http://www.observium.org/versions.php

REQUEST[http://www.observium.org/versions.php]
REQUEST STATUS[TRUE]
REQUEST RUNTIME[1.0386s]
RESPONSE CODE[200 OK]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver')]
SQL RUNTIME[0.00045705s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='20.7.10542' WHERE `attrib_type` = 'latest_ver']
SQL RUNTIME[0.00102401s]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev')]
SQL RUNTIME[0.00028086s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='10542' WHERE `attrib_type` = 'latest_rev']
SQL RUNTIME[0.00087404s]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date')]
SQL RUNTIME[0.00026989s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='2020-07-01' WHERE `attrib_type` = 'latest_rev_date']
SQL RUNTIME[0.00115299s]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck')]
SQL RUNTIME[0.00033879s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='1593703787' WHERE `attrib_type` = 'last_versioncheck']
SQL RUNTIME[0.00090003s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00027299s]
#####  Starting discovery run at 2020-07-02 15:29:47  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'hostname.tld' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00087810s]

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hostname.tld':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0944s]
STDOUT[
sysObjectID.0 = enterprises.8072.3.2.10
sysUpTime.0 = 8:15:43:42.01
]
SNMP STATUS[TRUE]

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

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '300']
SQL RUNTIME[0.00036907s]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('1550412','discovery.php','1550250','0','php ./discovery.php -d -m mempools -h hostname.tld','1593703787','300')]
SQL RUNTIME[0.00090599s]
#####  hostname.tld [300]  #####

 o OS Type              linux
 o OS Group             unix
 o SNMP Version         v2c
 o Last discovery       2020-07-02 12:37:47
 o Last duration        12.65 seconds

#####  Module Start: mempools  #####


SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '300' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00039816s]
 o UCD-SNMP-MIB
CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hostname.tld':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0795s]
STDOUT[
memTotalReal.0 = 15233916
memAvailReal.0 = 1800104
memBuffer.0 = 3916616
memCached.0 = 6116152
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hostname.tld':'161' versionTag.0 versionCDate.0 versionConfigureOptions.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0691s]
STDOUT[
versionTag.0 = 5.7.2
versionCDate.0 = Thu Jul  2 15:29:46 2020
versionConfigureOptions.0 =  '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--program-prefix=' '--disable-dependency-tracking' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--disable-static' '--enable-shared' '--with-cflags=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -D_RPM_4_4_COMPAT' '--with-ldflags=-Wl,-z,relro -Wl,-z,now' '--with-sys-location=Unknown' '--with-logfile=/var/log/snmpd.log' '--with-persistent-directory=/var/lib/net-snmp' '--with-mib-modules=host agentx smux      ucd-snmp/diskio tcp-mib udp-mib mibII/mta_sendmail      ip-mib/ipv4InterfaceTable ip-mib/ipv6InterfaceTable      ip-mib/ipAddressPrefixTable/ipAddressPrefixTable      ip-mib/ipDefaultRouterTable/ipDef
]
SNMP STATUS[TRUE]

SQL[SELECT EXISTS (SELECT 1 FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '300' AND `attrib_type` = 'ucd_memory_bad')]
SQL RUNTIME[0.00056791s]

SQL[UPDATE `entity_attribs` set `attrib_value` ='1' WHERE `entity_type` = 'device' AND `entity_id` = '300' AND `attrib_type` = 'ucd_memory_bad']
SQL RUNTIME[0.00043321s]
300 -> 0, UCD-SNMP-MIB::, Physical Memory, 1, 15599529984, 13756223488

SQL[SELECT * FROM `mempools` WHERE `device_id` = '300' AND `mempool_index` = '0' AND `mempool_mib` = 'UCD-SNMP-MIB']
SQL RUNTIME[0.00050783s]

 o HOST-RESOURCES-MIB
CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hostname.tld':'161' hrStorageEntry]

CMD EXITCODE[0]
CMD RUNTIME[1.0264s]
STDOUT[
hrStorageIndex.1 = 1
hrStorageIndex.3 = 3
hrStorageIndex.6 = 6
hrStorageIndex.7 = 7
hrStorageIndex.8 = 8
hrStorageIndex.10 = 10
hrStorageIndex.31 = 31
hrStorageIndex.36 = 36
hrStorageIndex.38 = 38
hrStorageIndex.39 = 39
hrStorageIndex.57 = 57
hrStorageIndex.58 = 58
hrStorageIndex.60 = 60
hrStorageIndex.62 = 62
hrStorageIndex.63 = 63
hrStorageIndex.64 = 64
hrStorageIndex.65 = 65
hrStorageIndex.66 = 66
hrStorageIndex.67 = 67
hrStorageIndex.68 = 68
hrStorageIndex.69 = 69
hrStorageIndex.70 = 70
hrStorageIndex.71 = 71
hrStorageIndex.72 = 72
hrStorageIndex.73 = 73
hrStorageIndex.74 = 74
hrStorageIndex.75 = 75
hrStorageIndex.77 = 77
hrStorageIndex.78 = 78
hrStorageIndex.79 = 79
hrStorageType.1 = hrStorageRam
hrStorageType.3 = hrStorageVirtualMemory
hrStorageType.6 = hrStorageOther
hrStorageType.7 = hrStorageOther
hrStorageType.8 = hrStorageOther
hrStorageType.10 = hrStorageVirtualMemory
hrStorageType.31 = hrStorageFixedDisk
hrStorageType.36 = hrStorageFixedDisk
hrStorageType.38 = hrStorageFixedDisk
hrStorageType.39 = hrStorageFixedDisk
hrStorageType.57 = hrStorageFixedDisk
hrStorageType.58 = hrStorageFixedDisk
hrStorageType.60 = hrStorageFixedDisk
hrStorageType.62 = hrStorageFixedDisk
hrStorageType.63 = hrStorageFixedDisk
hrStorageType.64 = hrStorageFixedDisk
hrStorageType.65 = hrStorageFixedDisk
hrStorageType.66 = hrStorageFixedDisk
hrStorageType.67 = hrStorageFixedDisk
hrStorageType.68 = hrStorageFixedDisk
hrStorageType.69 = hrStorageFixedDisk
hrStorageType.70 = hrStorageFixedDisk
hrStorageType.71 = hrStorageFixedDisk
hrStorageType.72 = hrStorageFixedDisk
hrStorageType.73 = hrStorageFixedDisk
hrStorageType.74 = hrStorageFixedDisk
hrStorageType.75 = hrStorageFixedDisk
hrStorageType.77 = hrStorageFixedDisk
hrStorageType.78 = hrStorageFixedDisk
hrStorageType.79 = hrStorageFixedDisk
hrStorageDescr.1 = Physical memory
hrStorageDescr.3 = Virtual memory
hrStorageDescr.6 = Memory buffers
hrStorageDescr.7 = Cached memory
hrStorageDescr.8 = Shared memory
hrStorageDescr.10 = Swap space
hrStorageDescr.31 = /
hrStorageDescr.36 = /dev/shm
hrStorageDescr.38 = /run
hrStorageDescr.39 = /sys/fs/cgroup
hrStorageDescr.57 = /tmp
hrStorageDescr.58 = /var/tmp
hrStorageDescr.60 = /run/user/1016
hrStorageDescr.62 = /home/virtfs/wheels/opt
hrStorageDescr.63 = /home/virtfs/wheels/tmp
hrStorageDescr.64 = /home/virtfs/wheels/usr
hrStorageDescr.65 = /home/virtfs/wheels/var
hrStorageDescr.66 = /home/virtfs/wheels/etc/scl
hrStorageDescr.67 = /home/virtfs/wheels/var/log
hrStorageDescr.68 = /home/virtfs/wheels/var/tmp
hrStorageDescr.69 = /home/virtfs/wheels/etc/mail
hrStorageDescr.70 = /home/virtfs/wheels/usr/sbin
hrStorageDescr.71 = /home/virtfs/wheels/var/spool
hrStorageDescr.72 = /home/virtfs/wheels/etc/apache2
hrStorageDescr.73 = /home/virtfs/wheels/etc/pki/tls
hrStorageDescr.74 = /home/virtfs/wheels/etc/alternatives
hrStorageDescr.75 = /home/virtfs/wheels/etc/pki/ca-trust
hrStorageDescr.77 = /home/virtfs/wheels/var/cpanel/php/sessions
hrStorageDescr.78 = /home/virtfs/wheels/var/cpanel/email_send_limits
hrStorageDescr.79 = /home/virtfs/wheels/home/wheels
hrStorageAllocationUnits.1 = 1024
hrStorageAllocationUnits.3 = 1024
hrStorageAllocationUnits.6 = 1024
hrStorageAllocationUnits.7 = 1024
hrStorageAllocationUnits.8 = 1024
hrStorageAllocationUnits.10 = 1024
hrStorageAllocationUnits.31 = 4096
hrStorageAllocationUnits.36 = 4096
hrStorageAllocationUnits.38 = 4096
hrStorageAllocationUnits.39 = 4096
hrStorageAllocationUnits.57 = 4096
hrStorageAllocationUnits.58 = 4096
hrStorageAllocationUnits.60 = 4096
hrStorageAllocationUnits.62 = 4096
hrStorageAllocationUnits.63 = 4096
hrStorageAllocationUnits.64 = 4096
hrStorageAllocationUnits.65 = 4096
hrStorageAllocationUnits.66 = 4096
hrStorageAllocationUnits.67 = 4096
hrStorageAllocationUnits.68 = 4096
hrStorageAllocationUnits.69 = 4096
hrStorageAllocationUnits.70 = 4096
hrStorageAllocationUnits.71 = 4096
hrStorageAllocationUnits.72 = 4096
hrStorageAllocationUnits.73 = 4096
hrStorageAllocationUnits.74 = 4096
hrStorageAllocationUnits.75 = 4096
hrStorageAllocationUnits.77 = 4096
hrStorageAllocationUnits.78 = 4096
hrStorageAllocationUnits.79 = 4096
hrStorageSize.1 = 15233916
hrStorageSize.3 = 17331064
hrStorageSize.6 = 15233916
hrStorageSize.7 = 6116152
hrStorageSize.8 = 634528
hrStorageSize.10 = 2097148
hrStorageSize.31 = 61894416
hrStorageSize.36 = 1904239
hrStorageSize.38 = 1904239
hrStorageSize.39 = 1904239
hrStorageSize.57 = 999344
hrStorageSize.58 = 999344
hrStorageSize.60 = 380848
hrStorageSize.62 = 61894416
hrStorageSize.63 = 999344
hrStorageSize.64 = 61894416
hrStorageSize.65 = 61894416
hrStorageSize.66 = 61894416
hrStorageSize.67 = 61894416
hrStorageSize.68 = 999344
hrStorageSize.69 = 61894416
hrStorageSize.70 = 61894416
hrStorageSize.71 = 61894416
hrStorageSize.72 = 61894416
hrStorageSize.73 = 61894416
hrStorageSize.74 = 61894416
hrStorageSize.75 = 61894416
hrStorageSize.77 = 61894416
hrStorageSize.78 = 61894416
hrStorageSize.79 = 61894416
hrStorageUsed.1 = 13433812
hrStorageUsed.3 = 13925076
hrStorageUsed.6 = 3916616
hrStorageUsed.7 = 6116152
hrStorageUsed.8 = 634528
hrStorageUsed.10 = 491264
hrStorageUsed.31 = 47324951
hrStorageUsed.36 = 0
hrStorageUsed.38 = 192724
hrStorageUsed.39 = 0
hrStorageUsed.57 = 2295
hrStorageUsed.58 = 2295
hrStorageUsed.60 = 0
hrStorageUsed.62 = 47324951
hrStorageUsed.63 = 2295
hrStorageUsed.64 = 47324951
hrStorageUsed.65 = 47324951
hrStorageUsed.66 = 47324951
hrStorageUsed.67 = 47324951
hrStorageUsed.68 = 2295
hrStorageUsed.69 = 47324951
hrStorageUsed.70 = 47324951
hrStorageUsed.71 = 47324951
hrStorageUsed.72 = 47324951
hrStorageUsed.73 = 47324951
hrStorageUsed.74 = 47324951
hrStorageUsed.75 = 47324951
hrStorageUsed.77 = 47324951
hrStorageUsed.78 = 47324951
hrStorageUsed.79 = 47324951
]
SNMP STATUS[TRUE]
300 -> 3, HOST-RESOURCES-MIB::, Virtual memory, 1024, 17331064, 13925076

SQL[SELECT * FROM `mempools` WHERE `device_id` = '300' AND `mempool_index` = '3' AND `mempool_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00063396s]
300 -> 6, HOST-RESOURCES-MIB::, Memory buffers, 1024, 15233916, 3916616

SQL[SELECT * FROM `mempools` WHERE `device_id` = '300' AND `mempool_index` = '6' AND `mempool_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00048590s]
300 -> 10, HOST-RESOURCES-MIB::, Swap space, 1024, 2097148, 491264

SQL[SELECT * FROM `mempools` WHERE `device_id` = '300' AND `mempool_index` = '10' AND `mempool_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00045705s]


SQL[SELECT * FROM `mempools` WHERE `device_id` = '300']
SQL RUNTIME[0.00043702s]
0 -> UCD-SNMP-MIB
3 -> HOST-RESOURCES-MIB
6 -> HOST-RESOURCES-MIB
10 -> HOST-RESOURCES-MIB


 > $valid['mempool'] /opt/observium/includes/discovery/mempools.inc.php:216
array(
  [UCD-SNMP-MIB]       => array(
                            [0] => int(1)
                          )
  [HOST-RESOURCES-MIB] => array(
                            [3]  => int(1)
                            [6]  => int(1)
                            [10] => int(1)
                          )
)

 o Changes              4 unchanged
 o Duration             1.2089s


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='server',`last_discovered_timetaken` ='1.214',`force_discovery` ='0' WHERE `device_id` = '300']
SQL RUNTIME[0.03041291s]
#####  hostname.tld [300] completed discovery modules at 2020-07-02 15:29:48  #####

 o Discovery time       1.214 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '1550412' AND `process_name` = 'discovery.php' AND `device_id` = '300']
SQL RUNTIME[0.00096393s]
#####  Finished discovery run at 2020-07-02 15:29:48  #####

./discovery.php: hostname.tld - 1 devices discovered in 2.555 secs

SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1593689385']
SQL RUNTIME[0.00033116s]
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
 o Devices Discovered   1
 o Discovery Time       2.555 secs
 o Memory usage         16MB (peak: 16MB)
 o MySQL Usage          Cell[9/0.006s] Row[8/0.006s] Rows[8/0.015s] Column[1/0.001s] Update[6/0.038s] Insert[1/0.002s] Delete[1/0.003s]
 o RRDTool Usage