Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Warning message in SQL dump #12

Open
hallodom opened this issue Apr 26, 2014 · 0 comments
Open

Warning message in SQL dump #12

hallodom opened this issue Apr 26, 2014 · 0 comments

Comments

@hallodom
Copy link

Hi,

I found Warning: Using a password on the command line interface can be insecure.
was appearing on line 1 of my staging sql dump file. This was causing SQL syntax error when trying to import locally.

I didn't use SSH host option to connect to the server not sure if this has something to do with the error message?

I found the same problem referenced here: http://stackoverflow.com/questions/20751352/suppress-warning-messages-using-mysql-from-within-terminal-but-password-written which suggests to use mysql_config_editor http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html.

As a temporary fix I removed the warning message by adding:

var preoutput = exports.replace_urls(old_url, new_url, content);
var output = exports.replace_urls("Warning: Using a password on the command line interface can be insecure.", " ", preoutput);

In util.js https://github.com/webrain/grunt-wordpress-deploy/blob/master/tasks/lib/util.js#L89

Am I authenticating wrong which is causing the warning to appear? Authenticating using the ssh_host option seemed to not allow the sqldump to generate due to -jailshell: FkX: command not found errors appearing when trying to dump on the live server.

Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant