Xtrabackup 2.3.3 does not authenticate on old passwords (pre 4.1)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
It is recommended to update passwords to use longer hashed passwords but for cases where it is not possible and mysql user accounts are still using old passwords Xtrabackup 2.3.3 will fail to connect.
[root@mysql55 ~]# xtrabackup --version
xtrabackup version 2.3.3 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 525ca7d)
[root@mysql55 ~]# vim ~/.my.cnf
[root@mysql55 ~]# innobackupex --user=backup --password=pass /opt/backups
160219 22:16:44 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!".
160219 22:16:44 version_check Connecting to MySQL server with DSN 'dbi:mysql:
160219 22:16:44 version_check Connected to MySQL server
160219 22:16:44 version_check Executing a version check against the server...
160219 22:16:44 version_check Done.
160219 22:16:44 Connecting to MySQL server host: localhost, user: backup, password: set, port: 0, socket: /tmp/mysql.sock
Failed to connect to MySQL server: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled).
[root@mysql55 ~]# xtrabackup --version
xtrabackup version 2.3.3 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 525ca7d)
While on 2.2.13 it works.
[root@mysql55 ~]# innobackupex --user=backup --password=pass /opt/backups
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://
160219 22:29:15 innobackupex: Executing a version check against the server...
160219 22:29:15 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:
160219 22:29:15 innobackupex: Connected to MySQL server
160219 22:29:15 innobackupex: Done.
160219 22:29:15 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:
160219 22:29:15 innobackupex: Connected to MySQL server
160219 22:29:15 innobackupex: Starting the backup operation
...
innobackupex: Backup created in directory '/opt/backups/
innobackupex: MySQL binlog position: filename 'mysql-bin.000004', position 1412
160219 22:29:21 innobackupex: Connection to database server closed
160219 22:29:21 innobackupex: completed OK!
[root@mysql55 ~]# xtrabackup --version
xtrabackup version 2.2.13 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 70f4be3)
Changed in percona-xtrabackup: | |
status: | New → Confirmed |