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.