pt-stalk --log fills logfile with password Warning

[Tim Vaillancourt]

Hi Percona,

Thanks a lot for pt-stalk! I am sure this has already been reported, but I was not able to find another ticket. Apologies if this is a duplicate.

When using pt-stalk with --daemonize and --log, the logfile specified is filled with Warnings from the 'mysql' binary due to passwords being used on the command line.

Here is an example:

-bash-4.1$ tail /var/log/pt-stalk.log
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

And you can see here that all but 24 lines of my log file are this warning:

-bash-4.1$ grep -c 'Warning: Using a password on the command line interface can be insecure.' /var/log/pt-stalk.log
336
-bash-4.1$ grep -vc 'Warning: Using a password on the command line interface can be insecure.' /var/log/pt-stalk.log
24

While the 'mysql' binary Warning is valid, I don't think it is useful here. Could this be suppressed?

Thanks!

Tim

[Tim Vaillancourt (tim.vaillancourt)]

My environment/version:

-bash-4.1$ rpm -qa|grep percona
percona-toolkit-2.2.15-1.noarch

Cheers,

Tim

[Nilnandan Joshi (nilnandan-joshi)]

Confirmed with 2.2.15

nilnandan@desktop:/var/log$ tail -f /var/log/pt-stalk.log
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
^C
nilnandan@desktop:/var/log$ pt-stalk --version
pt-stalk 2.2.15
nilnandan@desktop:/var/log$

[Shahriyar Rzayev (rzayev-sehriyar)]

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