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.
