There are times where a user needs to update the Hub schema password. There can occasions where the oracle password is updated, but this change is not made in the Hub application itself. This will cause the services to shutdown and lock all users out of the application.
This can be fixed by finding the Foundation app-config.groovy file. This folder can usually be found in the following folder path:
C:\Program Files\BIOVIA\Foundation\conf
You will want to open this file in notepad (preferably notepad++). Once it is opened the top entry shows:
dataSource {
url = '
driverClassName = 'oracle.jdbc.driver.OracleDriver'
username = '
password = '
passwordEncryptionCodec='com.accelrys.platform.utils.DatasourceCodec'
dbCreate = '' // Do not want standard Hibernate schema population
}
The two key lines here are:
password = '
passwordEncryptionCodec='com.accelrys.platform.utils.DatasourceCodec'
To fix this replace the encrypted hub password with the current schema password for Hub. Then, comment out the passwordEncryptionCodec line by add two slashes before it. For example say the schema password was changed to "password". To implement the fix the updatee to file will look like:
password = 'password'
//passwordEncryptionCodec='com.accelrys.platform.utils.DatasourceCodec'
Once done, restart the hub services and users should be able to regain access. As a final step update the Hub Schema password in the Hub configuration page under admin and settings. Once changed here do one last restart on the services. From here the hub password should be fixed.
