This bug was fixed in the package percona-xtrabackup - 2.3.7-0ubuntu0.16.10.2
--------------- percona-xtrabackup (2.3.7-0ubuntu0.16.10.2) yakkety; urgency=medium * Fix regression in default UNIX socket path for MySQL due to missing compilation flags (LP: #1678574). -- James Page <james.p...@ubuntu.com> Tue, 04 Apr 2017 10:56:37 +0100 ** Changed in: percona-xtrabackup (Ubuntu Yakkety) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of नेपाली भाषा समायोजकहरुको समूह, which is subscribed to Xenial. Matching subscriptions: Ubuntu 16.04 Bugs https://bugs.launchpad.net/bugs/1678574 Title: percona-xtrabackup wrong mysql socket path Status in percona-xtrabackup package in Ubuntu: Fix Released Status in percona-xtrabackup source package in Xenial: Fix Released Status in percona-xtrabackup source package in Yakkety: Fix Released Status in percona-xtrabackup source package in Zesty: Fix Released Bug description: [Impact] Default socket path for MySQL switched from /var/run/mysqld/mysqld.sock to /tmp/mysqld.sock which is not the path that any of the MySQL family in Ubuntu actually listens on; workaround via configuration file but needs fixing. [Test Case] sudo apt install percona-xtrabackup mariadb-server sudo mkdir -p /srv/backup sudo xtrabackup --backup --target-dir=/srv/backup Backup fails to connect to mysql with the error in the original bug report [Regression Potential] Limited; we missed this and two other compilation flag changes during the original update - the proposed updates re-sync the Ubuntu packaging with the upstream packaging in terms of compilation flags and value. [Original Bug Report] percona-xtrabackup was upgraded from 2.2.3-2.1build1.1 to 2.3.7-0ubuntu0.16.04.1. It appears that MySQL default socket file path has changed in the new version. After the update my backups started failing with the following: 170402 06:30:04 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Workaround: Add the following in /root/.my.cnf or similar: [client] socket = /run/mysqld/mysqld.sock Version details: root@chmaa ~ # lsb_release -rd Description: Ubuntu 16.04.2 LTS Release: 16.04 root@chmaa ~ # apt-cache policy percona-xtrabackup percona-xtrabackup: Installed: 2.3.7-0ubuntu0.16.04.1 Candidate: 2.3.7-0ubuntu0.16.04.1 Version table: *** 2.3.7-0ubuntu0.16.04.1 500 500 http://de.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 Packages 100 /var/lib/dpkg/status 2.2.3-2.1build1 500 500 http://de.archive.ubuntu.com/ubuntu xenial/universe amd64 Packages To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/percona-xtrabackup/+bug/1678574/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~group.of.nepali.translators Post to : group.of.nepali.translators@lists.launchpad.net Unsubscribe : https://launchpad.net/~group.of.nepali.translators More help : https://help.launchpad.net/ListHelp