Percona Toolkit moved to https://jira.percona.com/projects/PT

using --defaults-file can't use host from there

Bug #1314696 reported by Elan Ruusamäe on 2014-04-30

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Percona Toolkit moved to https://jira.percona.com/projects/PT	Confirmed	Undecided	Unassigned

Bug Description

i wish to keep connect credentials in separate file, so it can be shared across applications

there's --defaults-file option, which tells DBI to tell libmysqlclient library to use that file as defaults.

with my credentials file being:
[client]
user = username
pass = password
port = 3314
host = dbhost

$ pt-kill --config /etc/percona-toolkit/pt-kill.conf --print --verbose --defaults-file /etc/credentials.ini

DBI is called with arguments:

DBI connect(';mysql_read_default_file=/etc/credentials.ini;host=localhost;mysql_read_default_group=client','',...)

all params except host work, but host parameter is always enforced to be localhost!

ideally i would like to able to specify different `mysql_read_default_group=client` too (which is another parameter being enforced)

Tags:

Revision history for this message

Elan Ruusamäe (glen666) wrote on 2014-04-30:

bug-1314696.patch Edit (1.1 KiB, text/plain)

solution to remove enforced "localhost"

Frank Cizmich (frank-cizmich) on 2014-05-21

tags:	added: pt-kill
tags:	added: option-parsing removed: pt-kill

Revision history for this message

Nilnandan Joshi (nilnandan-joshi) wrote on 2014-08-04:

Verified.

nilnandan@nilnandan-Dell-XPS:~$ pt-kill --version
pt-kill 2.2.9
nilnandan@nilnandan-Dell-XPS:~$ cat /home/nilnandan/credentials.cnf
[client]
user = root
pass = root
port = 3306
host = dbhost
nilnandan@nilnandan-Dell-XPS:~$ pt-kill --config /etc/percona-toolkit/pt-kill.conf --print --verbose --defaults-file /home/nilnandan/credentials.cnf
DBI connect(';mysql_read_default_file=/home/nilnandan/credentials.cnf;host=localhost;mysql_read_default_group=client','',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/bin/pt-kill line 2059.
nilnandan@nilnandan-Dell-XPS:~$
nilnandan@nilnandan-Dell-XPS:~$