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

LP #1511451: innobackupex permission error; --defaults-extra-file ignored?

    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 Jeroen Pulles last update 11-12-2015 01:49:24

      Upgraded percona-xtrabackup to 2.3.2-1.trusty from 2.2.12-1.trusty.

      Backup now fails.

      The error notice below gives the impressions that " --defaults-extra-file=/etc/mysql/debian.cnf" is ignored. That's the file where debian/ubuntu keep the maintainer authentication credentials.

      innobackupex --no-timestamp --compress --defaults-extra-file=/etc/mysql/debian.cnf --defaults-group=client --incremental-basedir /mysql-backup/005 --incremental /mysql-backup/006
      151029 17:13:03 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!".

      151029 17:13:03 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/var/run/mysqld/mysqld.sock' as 'mysql' (using password: NO).
      Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/var/run/mysqld/mysqld.sock','mysql',...) failed: Access denied for user 'mysql'@'localhost' (using password: NO) at - line 1314.
      151029 17:13:03 Connecting to MySQL server host: localhost, user: mysql, password: not set, port: 3306, socket: /var/run/mysqld/mysqld.sock
      Failed to connect to MySQL server: Access denied for user 'mysql'@'localhost' (using password: NO).

        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: