pt-online-schema-change ver 2.2.12 doesn't honor --ask-pass anymore

Bug #1396868 reported by Nilnandan Joshi on 2014-11-27
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
High
Frank Cizmich

Bug Description

pt-online-schema-change doesn't honor the command line option --ask-pass anymore.

nilnandan@Dell-XPS:~$ pt-online-schema-change --version
pt-online-schema-change 2.2.12
nilnandan@Dell-XPS:~$
nilnandan@Dell-XPS:~$ pt-online-schema-change --user=root --ask-pass --alter "add column phone int" D=nil,t=test
Cannot connect to MySQL: DBI connect('nil;;mysql_read_default_group=client','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/pt-online-schema-change line 2261.

nilnandan@Dell-XPS:~$ cd /home/nilnandan/Downloads/percona-toolkit-2.2.11/
nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11$
nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11$ cd bin/
nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$ ./pt-online-schema-change --user=root --ask-pass --alter "add column phone int" D=nil,t=test
Enter MySQL password: # Exiting on SIGINT.
nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$ nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$ nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$ nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$ nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$ nilnandan@Dell-XPS:~/Downloads/percona-toolkit-2.2.11/bin$

Originally reported here:
http://www.percona.com/forums/questions-discussions/percona-toolkit/26690-pt-online-schema-change-in-version-2-2-12-doesn-t-honour-ask-pass-anymore

Related branches

Verify myself as per forum request. Setting to confirmed.

Changed in percona-toolkit:
status: New → Confirmed
Changed in percona-toolkit:
importance: Undecided → High
assignee: nobody → Frank Cizmich (frank-cizmich)
status: Confirmed → In Progress
milestone: none → 2.2.13
Frank Cizmich (frank-cizmich) wrote :

Thanks for reporting this Joshi.

tags: added: pt-online-schema-change
Kenny Gryp (gryp) wrote :

I have the same problem, with pt-table-checksum.
I suppose all tools are affected

Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released

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

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

Other bug subscribers