host parameter in .my.cnf is ignored

Bug #1703427 reported by Francesco
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Expired
Undecided
Unassigned

Bug Description

I have a .my.cnf in my home directory which sets the default host to 127.0.0.1.
I can connect to mysql if I type just "mysql" in the console, but it doesn't work with the percona-toolkit tools.
(in my case, I can't connect to localhost because I have skip_name_resolve=1)

root@db01:~# cat ~/.my.cnf
[client]
user=root
password=xxxx
host=127.0.0.1

root@db01:~# pt-deadlock-logger
DBI connect(';host=localhost;mysql_read_default_group=client','',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/bin/pt-deadlock-logger line 2435.

root@db01:~# pt-deadlock-logger -h 127.0.0.1
server ts thread txn_id txn_time user hostname ip db tbl idx lock_type lock_mode wait_hold victim query

Revision history for this message
Jericho Rivera (jericho-rivera) wrote :

which specific version of pt-deadlock-logger are you using? does other toolkit tools able to connect using you .my.cnf or only pt-deadlock-logger has this type of issue?

Changed in percona-toolkit:
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for Percona Toolkit because there has been no activity for 60 days.]

Changed in percona-toolkit:
status: Incomplete → Expired
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/PT-1433

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.