Hi, Alexander Clouter <ac56@soas.ac.uk> [20070906 14:15:58 +0100]:
Hi,
[snipped]
====== USE cheese-database; LOCK TABLES chedder READ; DELETE........; UNLOCK TABLES; ======
replace 'READ' with 'WRITE', or even 'LOW_PRIORITY WRITE'. D'oh :)
Then 'echo -e "[client]\npassword=<password>\n" > ~/.my.cnf' and then you run (in a cron job):
$ cat cmds.sql | mysql -u <user>
just so you know, this all came from: http://dev.mysql.com/doc/refman/5.1/en/password-security.html Cheers Alex
-----Original Message----- From: syslog-ng-bounces@lists.balabit.hu [mailto:syslog-ng-bounces@lists.balabit.hu] On Behalf Of Geller, Sandor (IT) Sent: Thursday, September 06, 2007 6:10 AM To: Syslog-ng users' and developers' mailing list Subject: Re: [syslog-ng] Log Rotation
Hello,
I am logging locally to
destination hosts { file("/opt/log/HOSTS/$YEAR/$MONTH/$DAY/$HOST/$PROGRAM" owner(root) group(root) perm(0600) dir_perm(0700) create_dirs(yes));};
Why do you want to rotate these??? New files will be created every day. Simply delete the old ones if you need to reclaim space.
I am also logging to a mysql database
destination d_mysql { pipe("/tmp/mysql.pipe" template("INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ('$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG');\n") template-escape(yes)); };
Sorry, I still don't understand what do you want to achieve.
Log rotation or log retention ?
regards,
Sandor --------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
_______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
_______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html