Access denied for user debian-sys-maint
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Low
|
Hrvoje Matijakovic | ||
5.1 |
Fix Released
|
Low
|
Hrvoje Matijakovic | ||
5.5 |
Fix Released
|
Low
|
Hrvoje Matijakovic | ||
5.6 |
Fix Released
|
Low
|
Hrvoje Matijakovic | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Undecided
|
Raghavendra D Prabhu |
Bug Description
I get the following error when starting mysqld from latest PXC 5.5 on Ubuntu Precise.
ERROR 1045 (28000): Access denied for user 'debian-
For this reason, stopping MySQL also fails:
/etc/init.d/mysql stop
* Stopping MySQL (Percona XtraDB Cluster) mysqld [fail]
Debian MySQL packages create their own debian-sys-maint user for administrative tasks. The password is generated randomly by dpkg install scripts and stored in /etc/mysql/
I was using mysqldump sst. I can imagine the same happens with other sst methods too.
To fix this, it would be necessary to copy the debian.cnf file from the donor. Alternatively the sst script would have to somehow regenerate a new password for debian-sys-maint user at the completion of sst.
I did not check if Codership deb packages have the same issue.
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 52 lines (+13/-2)3 files modifieddoc/source/diagnostics/user_stats.rst (+6/-0)
doc/source/faq.rst (+5/-0)
doc/source/scalability/innodb_io.rst (+2/-2)
- Laurynas Biveinis (community): Approve
-
Diff: 80 lines (+20/-3)5 files modifieddoc/source/diagnostics/user_stats.rst (+6/-0)
doc/source/faq.rst (+5/-0)
doc/source/release-notes/Percona-Server-5.5.30-30.2.rst (+1/-1)
doc/source/scalability/innodb_io_55.rst (+2/-2)
doc/source/upstream-bug-fixes.rst (+6/-0)
- Laurynas Biveinis (community): Approve
-
Diff: 94 lines (+47/-0)4 files modifieddoc/source/diagnostics/user_stats.rst (+6/-0)
doc/source/faq.rst (+5/-0)
doc/source/scalability/innodb_io.rst (+30/-0)
doc/source/upstream-bug-fixes.rst (+6/-0)
tags: | added: pkg |
Changed in percona-xtradb-cluster: | |
milestone: | none → 5.5.30-24.8 |
Changed in percona-xtradb-cluster: | |
status: | Confirmed → Fix Committed |
assignee: | nobody → Raghavendra D Prabhu (raghavendra-prabhu) |
tags: | added: doc |
Changed in percona-xtradb-cluster: | |
status: | Fix Committed → Fix Released |
More info, via Alex: Codership deb packages use a different init script, which doesn't use the debian.cnf file in any way. You should probably copy that from upstream and the problem goes away.