1 Reply Latest reply: Feb 25, 2008 2:21 PM by Vincent RIEDWEG RSS

SLM Collector DB Password Change

Axton Grams

Our db passwords change on a schedule.  The BMC SLM Collector stores the db password in daytona.war/WEB-INF/classes/bmcslm.propertiesusing the parameter ArDbPassword.  How does one go about changing thisvalue after the db password is changed?  The jboss instance wasrestarted without updating the daytona configuration, now the only wayI can get the jboss instance up is to remove the daytona.war from thedeploy directory.  Leaving doytona.war so it is deployed at jbossstartup never lets jboss fully initialize because the slmcollectercontinues retrying the creation of the db session and never exits it'sinit routine:


11:08:21,256 INFO  2008-02-25 11:08:21,255 ERROR com.bmc.daytona.datastore.DaoFactory  - java.sql.SQLException: ORA-01017: invalid username/password; logon denied
11:08:21,255 ERROR java.sql.SQLException: ORA-01017: invalid username/password; logon denied

11:08:21,266 INFO  2008-02-25 11:08:21,257 ERROR com.bmc.daytona.util.DaytonaInit  - Unable to create the SLM Collector Connection pool.
com.bmc.daytona.datastore.api.DaytonaDaoException: Data Source not initialized.
        at com.bmc.daytona.datastore.DaoFactory.testDataSource(Unknown Source)
        at com.bmc.daytona.util.DaytonaInit.createConnectionPool(Unknown Source)
        at com.bmc.daytona.util.DaytonaInit.init(Unknown Source)
        at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:1158)
...
11:08:21,257 ERROR Unable to create the SLM Collector Connection pool.
com.bmc.daytona.datastore.api.DaytonaDaoException: Data Source not initialized.
        at com.bmc.daytona.datastore.DaoFactory.testDataSource(Unknown Source)
        at com.bmc.daytona.util.DaytonaInit.createConnectionPool(Unknown Source)
        at com.bmc.daytona.util.DaytonaInit.init(Unknown Source)
        at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:1158)
...

Just repeats and repeats.

Movingdaytona.war out of the deploy directory, starting jboss, then movingdaytona to the deploy directory does not make the app available becauseit never inits.

Thanks,
Axton Grams