2014-10-31 14:57:30 |
Przemek |
bug |
|
|
added bug |
2014-10-31 14:59:45 |
Przemek |
description |
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 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:55:29 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/bin/innobackupex line 2945 |
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 |
|
2014-11-07 12:01:06 |
Miguel Angel Nieto |
percona-xtrabackup: status |
New |
Confirmed |
|
2014-12-01 17:35:33 |
Peter Schwaller |
percona-xtrabackup: assignee |
|
Sergei Glushchenko (sergei.glushchenko) |
|
2014-12-01 17:35:40 |
Peter Schwaller |
percona-xtrabackup: importance |
Undecided |
High |
|
2014-12-02 10:15:37 |
Alexey Kopytov |
summary |
Innobackupex does not work with .mylogin.cnf on some Linux versions |
Innobackupex does not work with .mylogin.cnf |
|
2014-12-02 10:15:45 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.1 |
|
2014-12-02 10:15:45 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.1 |
|
2014-12-02 10:15:45 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.3 |
|
2014-12-02 10:15:45 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.3 |
|
2014-12-02 10:15:45 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.2 |
|
2014-12-02 10:15:45 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.2 |
|
2014-12-02 10:15:54 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
New |
Won't Fix |
|
2014-12-02 10:15:58 |
Alexey Kopytov |
percona-xtrabackup/2.2: status |
New |
Triaged |
|
2014-12-02 10:16:00 |
Alexey Kopytov |
percona-xtrabackup/2.2: importance |
Undecided |
High |
|
2014-12-02 10:16:02 |
Alexey Kopytov |
percona-xtrabackup/2.3: status |
Confirmed |
Triaged |
|
2014-12-02 10:16:08 |
Alexey Kopytov |
percona-xtrabackup/2.2: assignee |
|
Sergei Glushchenko (sergei.glushchenko) |
|
2014-12-08 02:27:30 |
Launchpad Janitor |
branch linked |
|
lp:~sergei.glushchenko/percona-xtrabackup/2.2-ST47405-xb-bug1388122 |
|
2014-12-08 02:31:26 |
Launchpad Janitor |
branch linked |
|
lp:~sergei.glushchenko/percona-xtrabackup/2.3-ST47405-xb-bug1388122 |
|
2014-12-08 02:33:09 |
Sergei Glushchenko |
percona-xtrabackup/2.2: status |
Triaged |
Fix Committed |
|
2014-12-08 02:33:11 |
Sergei Glushchenko |
percona-xtrabackup/2.3: status |
Triaged |
Fix Committed |
|
2014-12-24 13:06:24 |
Sergei Glushchenko |
percona-xtrabackup/2.2: status |
Fix Committed |
Won't Fix |
|
2014-12-24 13:06:27 |
Sergei Glushchenko |
percona-xtrabackup/2.3: status |
Fix Committed |
Triaged |
|
2014-12-24 13:06:38 |
Sergei Glushchenko |
percona-xtrabackup/2.2: importance |
High |
Undecided |
|
2014-12-24 13:08:33 |
Sergei Glushchenko |
percona-xtrabackup/2.2: assignee |
Sergei Glushchenko (sergei.glushchenko) |
|
|
2015-05-15 01:57:38 |
Sergei Glushchenko |
percona-xtrabackup/2.3: milestone |
|
2.3.1-beta1 |
|
2015-05-15 01:57:46 |
Sergei Glushchenko |
percona-xtrabackup/2.3: status |
Triaged |
Fix Released |
|