On Debian systems mysql_install_db may change file permissions when upgrade

Bug #735423 reported by Aleksandr Kuzminsky on 2011-03-15
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Aleksandr Kuzminsky

Bug Description

When upgrading percona-server-server-5.1 "percona-server-server-5.1.postinst" runs /bin/bash /usr/bin/mysql_install_db --rpm 2>&1 | $ERR_LOGGER to ensure system tables exist.
I may create bin-log files if they were enabled in my.cnf before.
If there is no "user=mysql" option in [mysqld] section, the bin-logs are owned by root.

However when MySQL is started by mysql.server (e.g. /etc/init.d/mysql) group [mysql.server] is processed where "user=mysql" may be specified.

Root owner of the log files prevents mysqld to start. It can't read the last log due to "permission denied" error.

Related branches

By the way, chown -R mysql $mysql_statedir is not processed when $mysql_statedir is a symlink

Changed in percona-server:
assignee: nobody → Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
status: New → Fix Committed
Stewart Smith (stewart) wrote :

a fix seems to be merged. marking as fix released. please reopen if this isn't the case.

Changed in percona-server:
status: Fix Committed → Fix Released

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2617

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers