[Bug 606668] New: Fix mysql logging

["sysadmin" (bugzilla.gnome.org) <bugzilla gnome org>]

https://bugzilla.gnome.org/show_bug.cgi?id=606668
  sysadmin | Other | unspecified

           Summary: Fix mysql logging
    Classification: Infrastructure
           Product: sysadmin
           Version: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: Normal
         Component: Other
        AssignedTo: sysadmin-maint gnome bugs
        ReportedBy: otaylor redhat com
         QAContact: sysadmin-maint gnome bugs
      GNOME target: ---
     GNOME version: ---


Two problems, both will require fixing in the mysql puppet module:

 1) We don't have log rotation on for mysql - this isn't a big deal
    because we log almost nothing, but we should be rotating all log
    files - unrotated log files are asking for problems.

 2) The slow query logging isn't working - from mysqld.log

 /usr/libexec/mysqld: File '/var/log/mysqld-slow.log' not found (Errcode: 13)
 [ERROR] Could not use /var/log/mysqld-slow.log for logging (error 13). Turning
logging off for the whole duration of the MySQL server process. To turn it on
again: fix the cause, shutdown the MySQL server and restart it.

I think it's a permissions problem - mysql can't create a file on /var/log - so
the puppet config needs to pre-create this file as mysql:mysql, and the
logrotate confiugration needs to leave a file there. Not sure quite the magic
in puppet to touch a file if it doesn't exist, but presumably it's a fairly
common need.

Could also move the mysql logging to a mysql-owned subdir of /var/log to make
things simpler.

-- 
Configure bugmail: https://bugzilla.gnome.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching the QA contact of the bug.
You are watching the assignee of the bug.