6 messages in com.mysql.lists.packagersRe: [packagers] /var/lib/mysql permis...
FromSent OnAttachments
David Garamond15 Dec 2002 08:05 
Christian Hammers16 Dec 2002 01:12 
David Garamond16 Dec 2002 06:04 
Dmitry V. Levin16 Dec 2002 07:58 
Christian Hammers16 Dec 2002 08:13 
Lenz Grimmer16 Dec 2002 11:43 
Subject:Re: [packagers] /var/lib/mysql permission in recent mysql rpms
From:Christian Hammers (ch@debian.org)
Date:12/16/2002 08:13:21 AM
List:com.mysql.lists.packagers

On Mon, Dec 16, 2002 at 06:58:58PM +0300, Dmitry V. Levin wrote:

Better stick with FHS, /var/lib/mysql is just for the databases, /var/run/mysqld/ for the .pid and the .sock and /var/log/mysql/ for the log files (owned 0700 for security reasons).

This scheme is not always acceptable so it should be optional. For example, we (ALT GNU/*/Linux) distribute MySQL server chrooted by default, so creating logs outside chroot is not an option for this configuration (mysql doesn't use syslog(3)).

In this case I would seperate the dirs in the chroot and then symlink /var/log/mysql and /var/run/mysql to this chroot so that apps from outside could connect via /var/run/mysql to this chrooted mysql.

(btw hello mysql: error (or general) logging via syslog would be very nice as most people have setup a kind of logcheck anyway. Maybe some kind of optional "log = syslog://myhost/local6")

bye,

-christian-