[syslog-ng] Log Rotation

[Alexander Clouter]

Hi,

Alexander Clouter <ac56 at 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 at lists.balabit.hu [mailto:syslog-ng-bounces at 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 at 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 at 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 at lists.balabit.hu
> https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
> 
>