How to configure datasource with encrypted password
bessen Dec 6, 2011 9:29 PMJBoss 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.