May 8 04:47:01 ctxit004.nmi.dom CROND[23851]: (root) CMD (/opt/observium/housekeeping.php -yrptb)
May 8 04:47:01 ctxit004.nmi.dom CROND[23849]: (root) CMDOUT (#033[0;32mObservium 23.5.12788)
May 8 04:47:01 ctxit004.nmi.dom CROND[23849]: (root) CMDOUT (#033[1;37mHouseKeeping#033[0m)
May 8 04:47:01 ctxit004.nmi.dom CROND[23849]: (root) CMDOUT (#033[0m)
May 8 04:48:27 ctxit004.nmi.dom CROND[23849]: (root) CMDOUT (#033[0m)
May 8 05:13:01 ctxit004.nmi.dom CROND[10321]: (root) CMD (/opt/observium/housekeeping.php -ysel)
May 8 05:13:01 ctxit004.nmi.dom CROND[10320]: (root) CMDOUT (#033[0;32mObservium 23.5.12788)
May 8 05:13:01 ctxit004.nmi.dom CROND[10320]: (root) CMDOUT (#033[1;37mHouseKeeping#033[0m)
May 8 05:13:01 ctxit004.nmi.dom CROND[10320]: (root) CMDOUT (#033[0m)
May 8 05:13:01 ctxit004.nmi.dom CROND[10320]: (root) CMDOUT (#033[0m)
# ./housekeeping.php -yselTdd
DEBUG!
Load class 'Console_Color2' from '/opt/observium/libs/pear/Console/Color2.php': OK
DEBUG: is_cli() == TRUE, PHP_SAPI: 'cli', REMOTE_ADDR: ''
CMD[/usr/bin/svn info /opt/observium]
CMD EXITCODE[0]
CMD RUNTIME[0.0087s]
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: 12788
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 12788
Last Changed Date: 2023-05-04 10:52:40 -0500 (Thu, 04 May 2023)
]
> $observium_version /opt/observium/includes/definitions/version.inc.php:82
string(10) "23.5.12788"
> $observium_version_long /opt/observium/includes/definitions/version.inc.php:83
string(20) "23.5.12788 (rolling)"
> $svn_train /opt/observium/includes/definitions/version.inc.php:84
string(7) "rolling"
DEFINITIONS Time : 0.0640872 ms
DEFINITIONS Memory: 15.1MB
SQL[Load class 'Doctrine\SqlFormatter\SqlFormatter' from '/opt/observium/libs/Doctrine/SqlFormatter/SqlFormatter.php': OK
Load class 'Doctrine\SqlFormatter\Tokenizer' from '/opt/observium/libs/Doctrine/SqlFormatter/Tokenizer.php': OK
Load class 'Doctrine\SqlFormatter\Highlighter' from '/opt/observium/libs/Doctrine/SqlFormatter/Highlighter.php': OK
Load class 'Doctrine\SqlFormatter\CliHighlighter' from '/opt/observium/libs/Doctrine/SqlFormatter/CliHighlighter.php': OK
Load class 'Doctrine\SqlFormatter\Token' from '/opt/observium/libs/Doctrine/SqlFormatter/Token.php': OK
Load class 'Doctrine\SqlFormatter\Cursor' from '/opt/observium/libs/Doctrine/SqlFormatter/Cursor.php': OK
SELECT * FROM `observium_attribs`]
ROWS[21]
SQL RUNTIME[0.00032806s]
SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00016594s]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
ROWS[1]
SQL RUNTIME[0.00015998s]
SQL[SELECT * FROM `config`]
ROWS[2]
SQL RUNTIME[0.00019407s]
CMD[/usr/sbin/fping -v 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0014s]
STDOUT[
/usr/sbin/fping: Version 3.10
/usr/sbin/fping: comments to david@schweikert.ch
]
SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)]
ROWS[1]
SQL RUNTIME[0.00024104s]
Observium 23.5.12788
HouseKeeping
CMD[/opt/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0145s]
STDOUT[
Linux|3.10.0-1160.88.1.el7.x86_64|amd64|CentOS|7||
]
CMD[/usr/bin/env python --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
Python 2.7.5
]
SQL[SELECT version();]
ROWS[1]
SQL RUNTIME[0.00018406s]
CMD[/usr/bin/snmpget --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0034s]
STDOUT[
NET-SNMP version: 5.7.2
]
CMD[/usr/bin/rrdtool --version | head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0039s]
STDOUT[
RRDtool 1.7.1 Copyright by Tobias Oetiker
]
CMD[/usr/bin/rrdcached -h | head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0039s]
STDOUT[
RRDCacheD 1.7.1
]
CMD[/usr/sbin/fping -v 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0013s]
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.0018s]
STDOUT[
]
CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0]
CMD RUNTIME[0.0329s]
STDOUT[
Apache/2.4.6
]
SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00021005s]
SQL[SHOW VARIABLES LIKE 'log_bin']
ROWS[1]
SQL RUNTIME[0.00047588s]
SQL[SHOW VARIABLES LIKE 'character_set_connection']
ROWS[1]
SQL RUNTIME[0.00044012s]
##### Software versions #####
o OS Linux 3.10.0-1160.88.1.el7.x86_64 [amd64] (CentOS 7)
o Apache 2.4.6
o PHP 8.1.18 (OPcache: DISABLED)
o Python 2.7.5
o MariaDB 10.11.2-MariaDB (extension: mysqli 8.1.18)
o SNMP NET-SNMP 5.7.2
o RRDtool 1.7.1 (rrdcached 1.7.1: unix:/run/rrdcached.sock)
o Fping 3.10 (IPv4 only)
o Fetch cURL 7.29.0 (NSS/3.53.1, LibZ 1.2.7, LibIDN 1.28)
##### Memory Limit #####
o PHP 512MB
##### DB info #####
o DB schema 483
o MariaDB binlog OFF
o MariaDB mode NO_ENGINE_SUBSTITUTION
##### Charset info #####
o PHP UTF-8
o MariaDB utf8mb3
##### Timezones info #####
o Date Monday, 08-May-23 09:01:15 CDT
o PHP -05:00
o MariaDB -05:00
SQL[SELECT COUNT(*) FROM `syslog` WHERE `timestamp` < FROM_UNIXTIME(1680926475)]
ROWS[1]
SQL RUNTIME[0.00025320s]
SQL[SELECT COUNT(*) FROM `eventlog` WHERE `timestamp` < FROM_UNIXTIME(1667786475)]
ROWS[1]
SQL RUNTIME[0.00025797s]
SQL[DELETE FROM `eventlog` WHERE `timestamp` < FROM_UNIXTIME(1667786475)]
ROWS[183]
SQL RUNTIME[0.00333023s]
Event log housekeeping: deleted 183 entries
SQL[SELECT COUNT(*) FROM `alert_log` WHERE `timestamp` < FROM_UNIXTIME(1667786475)]
ROWS[1]
SQL RUNTIME[0.00024915s]
SQL[DELETE FROM `alert_log` WHERE `timestamp` < FROM_UNIXTIME(1667786475)]
ROWS[17]
SQL RUNTIME[0.00100899s]
Alert log housekeeping: deleted 17 entries