From 1af0699b39ba1261e6194974978b83ead4657ff9 Mon Sep 17 00:00:00 2001 From: Michael Meckelein Date: Mon, 13 Aug 2007 14:07:49 +0000 Subject: mod /contrib/delete_mysql, prepared docs for release --- contrib/delete_mysql | 14 +++++++++----- 1 file changed, 9 insertions(+), 5 deletions(-) (limited to 'contrib') diff --git a/contrib/delete_mysql b/contrib/delete_mysql index c0d2ce8a..3ed84d17 100644 --- a/contrib/delete_mysql +++ b/contrib/delete_mysql @@ -7,6 +7,8 @@ # This program was original part of of PHPloghost # Copyright (C) 2004 Tuatha de Dana # some modifications for rsyslog by mmeckelein at 2007-08-08 +# 2007-08-13 mmeckelein: added dbhost and some other improvements +# suggested by Michael Mansour - thx a lot! # This program is free software; you can redistribute it and/or # modify it under the terms of the GNU General Public License @@ -23,8 +25,9 @@ # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111- 1307, USA. # Change these variables to reflect your situation. -database=sqlsyslogd -export table=logs +database=sqlrsyslogd +dbhost="localhost" +export table=systemevents sqluser="" password="" @@ -33,16 +36,17 @@ mysqld=/usr/bin/mysql # A couple of steps should be taken to maintain your database. # If not, the number of messages will fill your database. -# By default, logs are deleted after they're one year old. +# By default, logs are deleted after they're 30 days old. # Change this to meet your requirements. # rsyslog's default database template use two date columns # ReceivedAt and DeviceReportedTime. You can use either of # the two and in most cases it doesn't make a huge difference. # See the property replacer doc at http://www.rsyslog.com/doc # for details on the two dates. -SQL_DELETE="DELETE FROM $table WHERE ReceivedAt < CURDATE() - INTERVAL 1 year;" +SQL_DELETE="DELETE FROM $table WHERE ReceivedAt < CURDATE() - INTERVAL 30 DAY;" # After a large amount of rows have been deleted, we should # optimize the table. SQL_OPT="OPTIMIZE TABLE $table;"; -$mysqld -u$sqluser -p$password -e"$SQL_DELETE" -D$database $mysqld -u$sqluser -p$password -e"$SQL_OPT" -D$database +$mysqld -u$sqluser -p$password -h$dbhost -e"$SQL_DELETE" -D$database +$mysqld -u$sqluser -p$password -h$dbhost -e"$SQL_OPT" -D$database -- cgit