On Debian systems mysql_install_db may change file permissions when upgrade

Bug #735423 reported by Aleksandr Kuzminsky
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
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

Revision history for this message
Aleksandr Kuzminsky (akuzminsky) wrote :

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
Revision history for this message
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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.