X-Git-Url: http://ftp.carnet.hr/carnet-debian/scm?a=blobdiff_plain;f=files%2Fetc%2Flogrotate.d%2Fmysql-server;fp=files%2Fetc%2Flogrotate.d%2Fmysql-server;h=6d0f02d2f53d839161960885fd1a138a251d7711;hb=d76524eb23710a7326e9633ab4df800d65449c5d;hp=0000000000000000000000000000000000000000;hpb=a26fded43562e80021ad20d6066a6667fa78e0e8;p=carnet-upgrade.git

diff --git a/files/etc/logrotate.d/mysql-server b/files/etc/logrotate.d/mysql-server
new file mode 100644
index 0000000..6d0f02d
--- /dev/null
+++ b/files/etc/logrotate.d/mysql-server
@@ -0,0 +1,34 @@
+#
+# - This script rotates the normal query-log and the slow-log files. 
+#   Binary-log rotation is configured in /etc/mysql/debian-log-rotate.conf
+# - All files should be in one block so that only one flush-logs is neccessary.
+# - The error log is obsolete, messages go to syslog now.
+/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql.err /var/log/mysql/mysql.err /var/log/mysql/mysql-slow.log {
+	daily
+	rotate 7
+	missingok
+	create 640 mysql adm
+	compress
+	sharedscripts
+	postrotate
+		test -x /usr/bin/mysqladmin || exit 0
+
+		# If this fails, check debian.conf! 
+		export HOME=/etc/mysql/my.cnf
+		MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
+		if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then
+		  # Really no mysqld or rather a missing debian-sys-maint user?
+		  # If this occurs and is not a error please report a bug.
+		  if ps cax | grep -q mysqld; then
+ 		    exit 1
+		  fi 
+		else
+		  $MYADMIN flush-logs
+		fi
+		errlogs=`ls /var/log/mysql.err* /var/log/mysql/mysql.err* 2>/dev/null`
+		if [ -n "$errlogs" ]; then 
+		  chown root:adm $errlogs
+		  chmod 640 $errlogs
+		fi
+	endscript
+}