Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-750

LP #1546872: Backing up with SSL user doesn't work on PXB 2.3.3

    XMLWordPrintable

    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 Jericho Rivera last update 13-02-2017 08:59:23

      It's either a change in behavior but undocumented or really a bug on PXB 2.3.3.

      Backing up with SSL user on PXB 2.2.13 works:
      -----------------------------------------------------------------------------------------------------------------------------

      Grants for ssluser@%

      -----------------------------------------------------------------------------------------------------------------------------

      GRANT ALL PRIVILEGES ON . TO 'ssluser'@'%' IDENTIFIED BY PASSWORD '*10E6721481D186D916AF39BF5D9767CF494DFF7B' REQUIRE SSL

      -----------------------------------------------------------------------------------------------------------------------------
      1 row in set (0.00 sec)

      [root@centos1 ~]# cat .my.cnf
      [client]
      user=ssluser
      password=ssl1
      ssl-ca=/etc/mysql-ssl/ca.pem
      socket=/opt/mysql/mysql.sock

      [root@centos1 ~]# xtrabackup --version
      xtrabackup version 2.2.13 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 70f4be3)
      [root@centos1 ~]# innobackupex /opt/backup

      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

      160218 00:00:14 innobackupex: Executing a version check against the server...
      160218 00:00:14 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
      160218 00:00:14 innobackupex: Connected to MySQL server
      160218 00:00:14 innobackupex: Done.
      160218 00:00:14 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
      160218 00:00:14 innobackupex: Connected to MySQL server
      160218 00:00:14 innobackupex: Starting the backup operation

      IMPORTANT: Please check that the backup run completes successfully.
      At the end of a successful backup run innobackupex
      prints "completed OK!".

      ....

      innobackupex: Backup created in directory '/opt/backup/2016-02-18_00-00-14'
      innobackupex: MySQL binlog position: filename 'binarylog.000004', position 120
      160218 00:00:19 innobackupex: Connection to database server closed
      160218 00:00:19 innobackupex: completed OK!
      [root@centos1 ~]# ls -l /opt/backup
      total 0
      drwxr-xr-x 6 root root 0 Feb 18 00:00 2016-02-18_00-00-14

      After upgrading to PXB 2.3.3 it fails with:

      root@centos1 ~]# xtrabackup --version
      xtrabackup version 2.3.3 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 525ca7d)
      [root@centos1 ~]# innobackupex /opt/backup/
      160218 00:01:32 innobackupex: Starting the backup operation

      IMPORTANT: Please check that the backup run completes successfully.
      At the end of a successful backup run innobackupex
      prints "completed OK!".

      160218 00:01:33 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/opt/mysql/mysql.sock' as 'ssluser' (using password: YES).
      160218 00:01:33 version_check Connected to MySQL server
      160218 00:01:33 version_check Executing a version check against the server...
      160218 00:01:33 version_check Done.
      160218 00:01:33 Connecting to MySQL server host: localhost, user: ssluser, password: set, port: 0, socket: /opt/mysql/mysql.sock
      Failed to connect to MySQL server: Access denied for user 'ssluser'@'localhost' (using password: YES).

      Same .my.cnf file, same PS version, same openssl version, only difference was Xtrabackup upgraded from 2.2.13 to 2.3.3.

      Also tried to add socket/host/port options on .my.cnf but to no avail.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: