I am on Ubuntu 11.10. PDI version is 4.2.1. I am using a database repository.
I have created a JNDI connection in /opt/pentaho/data-integration/simple-jndi/jdbc.properties to a mysql database. The password is unencrypted this time (NOT encrypted). Then went into Tools > Repository > Explore - Click on Connections tab, and created a new connection using JNDI. Clicked on Test Connection, and it works fine.
Next, created an Obfuscated password as follows:
/opt/pentaho/data-integration/encr.sh -kettle gigagroup
Edited the jdbc.properties as follows:
Test Connection does not work.
Restored the unencrypted password back in the file, restarted Spoon, and it works fine again. Did this several time to check if I was doing any simple mistake, but it consistently does not work with encrypted password.
Is this a bug? Am I doing something wrong? Anyone tried it?
Any help is greatly appreciated.