Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1127

LP #1505184: wsrep_sst_auth don't work in Percona-XtraDB-Cluster-56-5.6.25-25.12.1.el7

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Zheng, Ping last update 11-01-2016 11:10:37

      I wrote a dockerfile for Percona-XtraDB-Cluster-56, and build a cluster on it. Today I upgrade my cluster from 5.6.24 to 5.6.25, then I notice that sst failed. I have to downgrade my percona cluster, change lines from

      > RUN yum -y install Percona-XtraDB-Cluster-56

      to

      > RUN yum -y install Percona-XtraDB-Cluster-client-56-5.6.24 \
      > Percona-XtraDB-Cluster-server-56-5.6.24 \
      > Percona-XtraDB-Cluster-shared-56-5.6.24 \
      > Percona-XtraDB-Cluster-galera-3-3.9-1 \
      > percona-xtrabackup

      then everything went back to normal.

      innobackup.backup.log

      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://www.percona.com/xb/p

      151012 17:27:17 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_def
      ault_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'sst' (using password: NO).
      innobackupex: got a fatal error with the following stacktrace: at /usr//bin/innobackupex line 3011.
      main::mysql_connect('abort_on_error', 1) called at /usr//bin/innobackupex line 1570
      innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file=/etc/my.cnf;mysql_read_default_grou
      p=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock','sst',...) failed: Access denied for user 'sst'@'localhost' (using password:
      YES) at /usr//bin/innobackupex line 2995.

      for me it seems like innobackupex script didn't get the password from /etc/my.cnf.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: