<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v7.0.1-28479">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>mysql-server-5.1 no debian-sys-maint?</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif ! important;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<p>Hi all,</p><p> </p><p>This is my first post so maybe this issue has been mentioned before, I've tried to find out via Google but haven't been able to verify that it has been mentioned tot this list before, if so please don't shoot me ;-)</p><p> </p><p>After installing the mysql-server-5.1 package in natty (11.04) I got an error form the cron job the next day stating:</p><p>-------------------------</p><p>/etc/cron.daily/logrotate: error: error running shared postrotate script for '/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log ' run-parts: /etc/cron.daily/logrotate exited with return code 1</p><p>----------------</p><p>While researching I found that the account debian-sys-maint mentioned in /etc/mysql/debian.cnf was not created in mysql and logrotate was therefore not able to rotate the logs. When creating the user debian-sys-maint@localhost in mysql by hand I got an error stating the username was to long (over 16 chars). When leaving off the @localhost part the user was created and I was able to set permissions and logrotate seems to be happy now.</p><p> </p><p>Kind regards,</p><p>Jeroen</p>
</body>
</html>