[jboss-dev-forums] [JBoss AS 7 Development] - How to configure datasource with encrypted password

[brian essen]

brian essen [http://community.jboss.org/people/bessen] created the discussion

"How to configure datasource with encrypted password"

To view the discussion, visit: http://community.jboss.org/message/640189#640189

--------------------------------------------------------------
JBoss AS 7.1.Beta1

I want to configure an Oracle datasource with an encrypted password but always receives invalid username/password error. Here is my configuration:

|              | <datasource jndi-name="java:/oracleds" pool-name="oracleds" enabled="true" jta="false" use-ccm="false"> |
|                  | <connection-url> |
|                      | jdbc:oracle:thin:@host:1521:sid |
|                  | </connection-url> |
|                  | <driver> |
|                      | oracle |
|                  | </driver> |
|                  | <security> |
|              | <security-domain> |
|                  | encrypted-oracleds |
|              | </security-domain> |
|                  | </security> |
|              | </datasource> |

password encrypted with PicketBox's SecureIdentifyLoginModule
|              | <security-domain name="encrypted-oracleds" cache-type="default"> |
|                  | <authentication> |
|                      | <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> |
|                          | <module-option name="username" value="dbuser"/> |
|                          | <module-option name="password" value="1db2c949438bd043ed413fe8bbfc9ec6"/> |
|                          | <module-option name="managedConnectionFactoryName" value="jboss.jca:service=LocalTxCM,name=oracleds"/> |
|                      | </login-module> |
|                  | </authentication> |
|              | </security-domain> |

I keep getting the following Oracle error. I think somehow the passed-in username/password does not match the one I provided.

Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:384)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:657)
        at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:433)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:365)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:812)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:547)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:225)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:556)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnect
ionFactory.java:249)
        ... 139 more

If I use username and password in the datasource config, everything works fine. 
Please let me know what I have done incorrectly.
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/640189#640189]

Start a new discussion in JBoss AS 7 Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2225]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20111206/edba83b6/attachment.html