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

LP #1388122: Innobackupex does not work with .mylogin.cnf

    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 Przemek last update 15-05-2015 01:57:48

      I am creating hashed authentication file - .mylogin.cnf using
      mysql_config_editor set --login-path=client --host=localhost --user=root --password

      After making it:

      root@ubuntu-14:~# mysql_config_editor print --all
      [client]
      user = root
      password = *****
      host = localhost

      The Innobackupex (from both Xtrabackup 2.2.5 and 2.1.9) works well on latest Ubuntu and Fedora, but does not work on Centos 6 and Debian 7.

      Systems, where this works:

      root@ubuntu-14:~# cat /etc/issue
      Ubuntu 14.04.1 LTS \n \l

      root@ubuntu-14:~# dpkg -l|grep -i mysql
      ii libdbd-mysql-perl 4.025-1 amd64 Perl5 database interface to the MySQL database
      ii libmysqlclient-dev 5.6.21-1ubuntu14.04 amd64 MySQL development headers
      ri libmysqlclient18:amd64 5.6.21-1ubuntu14.04 amd64 MySQL shared client libraries
      ii mysql-apt-config 0.3.1-1ubuntu14.04 all Auto configuration for MySQL APT Repo.
      ii mysql-common 5.6.21-1ubuntu14.04 amd64 MySQL Common
      ii mysql-community-client 5.6.21-1ubuntu14.04 amd64 MySQL Client
      ii mysql-community-server 5.6.21-1ubuntu14.04 amd64 MySQL Server

      ii percona-xtrabackup-21 2.1.9-746-1.trusty amd64 Open source backup tool for InnoDB and XtraDB

      root@ubuntu-14:~# innobackupex back/

      (...)
      141031 14:48:47 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
      141031 14:48:47 innobackupex: Connected to MySQL server
      141031 14:48:47 innobackupex: Executing a version check against the server...
      141031 14:48:47 innobackupex: Done.
      IMPORTANT: Please check that the backup run completes successfully.
      At the end of a successful backup run innobackupex
      prints "completed OK!".

      innobackupex: Using mysql server version 5.6.21

      innobackupex: Created backup directory /root/back/2014-10-31_14-48-47

      141031 14:48:47 innobackupex: Starting ibbackup with command: xtrabackup_56 --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/root/back/2014-10-31_14-48-47 --tmpdir=/tmp
      innobackupex: Waiting for ibbackup (pid=15135) to suspend
      (...)
      141031 14:48:51 innobackupex: completed OK!

      on Fedora:
      [root@pmlap ~]# cat /etc/issue
      Fedora release 20 (Heisenbug)

      [root@pmlap ~]# rpm -qa|grep -i mysql
      mysql-community-libs-5.6.21-1.fc20.x86_64
      mysql-connector-python-2.0.1-1.fc20.noarch
      mysql-community-common-5.6.21-1.fc20.x86_64
      perl-DBD-MySQL-4.024-1.fc20.x86_64
      mysql-community-server-5.6.21-1.fc20.x86_64
      mysql-community-client-5.6.21-1.fc20.x86_64
      mysql-community-release-fc20-5.noarch

      On Centos6:

      [root@vagrant-centos65 ~]# rpm -qa|grep -i mysql
      mysql-community-release-el6-5.noarch
      mysql-community-common-5.6.21-2.el6.x86_64
      mysql-community-client-5.6.21-2.el6.x86_64
      mysql-utilities-1.5.2-1.el6.noarch
      perl-DBD-MySQL-4.013-3.el6.x86_64
      mysql-community-libs-5.6.21-2.el6.x86_64
      mysql-community-server-5.6.21-2.el6.x86_64
      mysql-connector-python-2.0.1-1.el6.noarch

      [root@vagrant-centos65 ~]# mysql
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 9
      Server version: 5.6.21-log MySQL Community Server (GPL)

      Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      mysql> show grants;
      ----------------------------------------------------------------------------------------------------------------------------------------

      Grants for root@localhost

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

      GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*D6C8439DDDCD2E078F3F49A6BBBC76E2EEE2455E' WITH GRANT OPTION
      GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

      ----------------------------------------------------------------------------------------------------------------------------------------
      2 rows in set (0.00 sec)

      [root@vagrant-centos65 ~]# innobackupex --socket=/data/mysql/mysql.sock 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

      141031 14:58:47 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/data/mysql/mysql.sock' (using password: NO).
      innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;mysql_socket=/data/mysql/mysql.sock','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/innobackupex line 2945

        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: