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: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
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.
_______________________________________________
gnome-infrastructure mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-infrastructure
