wsrep_sst_auth don't work in Percona-XtraDB-Cluster-56-5.6.25-25.12.1.el7
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Medium
|
Krunal Bauskar |
Bug Description
I wrote a dockerfile for Percona-
> RUN yum -y install Percona-
to
> RUN yum -y install Percona-
> Percona-
> Percona-
> Percona-
> percona-xtrabackup
then everything went back to normal.
innobackup.
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://
151012 17:27:17 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:
ault_group=
innobackupex: got a fatal error with the following stacktrace: at /usr//bin/
innobackupex: Error: Failed to connect to MySQL server: DBI connect(
p=xtrabackup;
YES) at /usr//bin/
for me it seems like innobackupex script didn't get the password from /etc/my.cnf.
affects: | percona-server → percona-xtradb-cluster |
Changed in percona-xtradb-cluster: | |
milestone: | future-5.6 → 5.6.27-25.13 |
Changed in percona-xtradb-cluster: | |
status: | Fix Committed → Fix Released |
Able to reproduce the issue with PXC-5.6.25. Backup script is not picking wsrep_sst_auth value as expected.
** Error info
151020 06:32:07 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql: ;mysql_ read_default_ file=/etc/ my.cnf; mysql_read_ default_ group=xtrabacku p;mysql_ socket= /var/lib/ mysql/mysql. sock' as 'sstuser' (using password: NO). innobackupex line 3011. mysql_connect( 'abort_ on_error' , 1) called at /usr//bin/ innobackupex line 1570 ';mysql_ read_default_ file=/etc/ my.cnf; mysql_read_ default_ group=xtrabacku p;mysql_ socket= /var/lib/ mysql/mysql. sock',' sstuser' ,...) failed: Access denied for user 'sstuser' @'localhost' (using password: NO) at /usr//bin/ innobackupex line 2995.
innobackupex: got a fatal error with the following stacktrace: at /usr//bin/
main::
innobackupex: Error: Failed to connect to MySQL server: DBI connect(
[root@Dock1 mysql]#
** my.cnf
wsrep_sst_ auth="sstuser: s3cret"