unable to create ACTIVEMQ_* tables in Oracle with encrypted password

[Clay Stovall <cl...@pneuron.com>]

I have configured AMQ to use Oracle 11 to persist messages. The setup works
correctly. The 3 tables (ACTIVEMQ_ACKS,ACTIVEMQ_LOCK,ACTIVEMQ_MSGS) are
created in Oracle when the AMQ is started (bin\activemq start). 

I am unable to create the tables when I encrypt the password for the Oracle
user --  
using bin\activemq start xbean:conf/activemq-security.xml to start AMQ.

This issue occurs in Windows 7 and CentOS 5.8
JDK 1.6
AMQ 5.5 and 5.7

The following modifications were based on the document
http://activemq.apache.org/encrypted-passwords.html

credentials-enc.properties - added the encrypted jdbc.password 
activemq.username=system
activemq.password=ENC(mYRkg+4Q4hua1kvpCCI2hg==)
guest.password=ENC(Cf3Jf3tM+UrSOoaKU50od5CuBa8rxjoL)
jdbc.password=ENC(U7XRG1nscLEST1LVUI5nsznCOqtZYrEB)

ActiveMQ.xml - added
<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@localhost:1521:active"/>
    <property name="username" value="active"/>
    <property name="password" value="${jdbc.password}"/>
    <property name="maxActive" value="200"/>
    <property name="poolPreparedStatements" value="true"/>
  </bean>
  
activemq-security.xml
  
  <bean id="environmentVariablesConfiguration"
class="org.jasypt.encryption.pbe.config.EnvironmentStringPBEConfig">
    <property name="algorithm" value="PBEWithMD5AndDES" />
    <property name="passwordEnvName" value="ACTIVEMQ_ENCRYPTION_PASSWORD" />
  </bean>
                                                                     
  <bean id="configurationEncryptor"
class="org.jasypt.encryption.pbe.StandardPBEStringEncryptor">
    <property name="config" ref="environmentVariablesConfiguration" />
  </bean>  
    
  <bean id="propertyConfigurer"
class="org.jasypt.spring.properties.EncryptablePropertyPlaceholderConfigurer"> 
      <constructor-arg ref="configurationEncryptor" /> 
  	 <property name="location"
value="file:${activemq.conf}/credentials-enc.properties"/>
  </bean> 
  
The environment variable ACTIVEMQ_ENCRYPTION_PASSWORD is set
  ACTIVEMQ_ENCRYPTION_PASSWORD=activemq




--
View this message in context: http://activemq.2283324.n4.nabble.com/unable-to-create-ACTIVEMQ-tables-in-Oracle-with-encrypted-password-tp4667110.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.