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

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

Bug #1396868 reported by Nilnandan Joshi
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
Percona Toolkit moved to https://jira.percona.com/projects/PT 2.2.13

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

lp:~percona-toolkit-dev/percona-toolkit/pt-online-schema-change--doesnt-honor--ask-pass-1396868
Daniel Nichter: Needs Fixing
Diff: 359 lines (+179/-16)
8 files modified
bin/pt-config-diff (+2/-2)
bin/pt-deadlock-logger (+2/-2)
bin/pt-fk-error-logger (+2/-2)
bin/pt-kill (+2/-2)
bin/pt-online-schema-change (+165/-2)
bin/pt-table-checksum (+2/-2)
bin/pt-upgrade (+2/-2)
lib/Cxn.pm (+2/-2)
Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Verify myself as per forum request. Setting to confirmed.

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

Thanks for reporting this Joshi.

Frank Cizmich (frank-cizmich)
tags: added: pt-online-schema-change
Revision history for this message
Kenny Gryp (gryp) wrote :

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

Frank Cizmich (frank-cizmich)
Changed in percona-toolkit:
status: In Progress → Fix Committed
Hrvoje Matijakovic (hrvojem)
Changed in percona-toolkit:
status: Fix Committed → Fix Released
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-383

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

Other bug subscribers

Remote bug watches

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