password encryption does not work
---------------------------------
Key: MSQL-51
URL: http://jira.codehaus.org/browse/MSQL-51
Project: Maven 2.x SQL Plugin
Issue Type: Bug
Affects Versions: 1.4
Environment: windows xp, intelliJ IDEA 8.1.4, java 1.6
Reporter: Adjoa Poku
Priority: Critical
Running into trouble using encrypted passwords with the maven-sql-plugin. I am
currently "hiding the password" in my settings.xml file as described here:
http://mojo.codehaus.org/sql-maven-plugin/examples/settings.html
Everything works fine if I put the password in plain text, but in our
department we are not allowed to store passwords in plain text.
We do use the password encryption technique for access to our maven
repositories on a remote server.
(http://maven.apache.org/guides/mini/guide-encryption.html)
With the sql-plugin, my plain text password works, but once I swap it with the
encrypted representation generated by "mvn -ep" I get MojoExecutionExceptions.
Meanwhile, I am still able to access our maven repository using my encrypted
passwords (I did regenerate all passwords I am using to make sure all were
produced from the same "master" password)
More details of the error I get:
Caused by: org.apache.maven.plugin.MojoExecutionException: Access denied for
user 'xxxx'@'localhost' (using password: YES)
at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:583)
at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:579)
... 22 more
Caused by: java.sql.SQLException: Access denied for user 'xxxx'@'localhost'
(using password: YES)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email