xtrabackup doesn't read the socket information from the server configuration

Bug #1665305 reported by Hrvoje Matijakovic
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Status tracked in 2.4
2.3
Fix Released
High
EvgeniyPatlan
2.4
Fix Released
High
EvgeniyPatlan

Bug Description

xtrabackup doesn't read the socket information from the server configuration even if it's there:

cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

This requires socket to be specified either in the client config or on the command line, otherwise backup fails:

xtrabackup --backup --target-dir=/tmp/backups --user=root
170216 10:32:53 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: NO).
170216 10:32:53 version_check Connected to MySQL server
170216 10:32:53 version_check Executing a version check against the server...
170216 10:32:53 version_check Done.
170216 10:32:53 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).

Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

xtrabackup will no longer read socket from server config, instead it will replicate behaviour of mysql cli. socket will be read from [client] section or from [xtrabackup] section. Default value will be set at the build time in packaging scripts as it is done for MySQL and PS.

Revision history for this message
EvgeniyPatlan (evgeniy-patlan) wrote :

Done.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-496

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.