LMS 2.5 database password change

[m.hephner]

I tried to change my password for rmeng using the following command:

./dbpasswd.pl dsn=rmeng encryption=yes npwd=NEWPASSWORD

Here is the output from the dbpwdChange.log

INFO: Start changing password for database 'rmeng'...

Thu Sep 29 14:51:18 GMT 2011> INFO: New userinfo updated into database successfully.
Thu Sep 29 14:51:49 GMT 2011> DEBUG: Contents of /opt/CSCOpx/databases/rmeng/orig/odbc.tmpl before change
Thu Sep 29 14:51:49 GMT 2011> ERROR: /opt/CSCOpx/databases/rmeng/orig/odbc.tmpl does not exist.
Thu Sep 29 14:51:49 GMT 2011> ERROR: Failed to update odbc template file.
Thu Sep 29 14:51:49 GMT 2011> DEBUG: Contents of /opt/CSCOpx/databases/rmeng/orig/odbc.tmpl after change
Thu Sep 29 14:51:49 GMT 2011> ERROR: /opt/CSCOpx/databases/rmeng/orig/odbc.tmpl does not exist.
Thu Sep 29 14:51:49 GMT 2011> ERROR: Failed change password for database 'rmeng'.
Please see log file /var/adm/CSCOpx/log/dbpwdChange.log for details.

running it a second time gives me:

INFO: Start changing password for database 'rmeng'...

    Starting database engine rmengEng

ERROR: Failed to Start Database 'rmeng' because: Could not connect to engine 'rmengEng' on 'rmengdb' in Bulk mode. Check user id and passwords

ERROR: Failed to connect to database 'rmeng' with current password.

INFO: Trying the factory password for the database 'rmeng'.

ERROR: Failed to open the odbc template file for database rmeng

Use of uninitialized value at /opt/CSCOpx/lib/perl/db/Cisco/DbUtils.pm line 1879.

ERROR: Failed to stop the database engine with old password: Invalid parameters to StopDb..

ERROR: Failed change password for database 'rmeng'. INFO: Start changing password for database 'rmeng'...
    Starting database engine rmengEng
ERROR: Failed to Start Database 'rmeng' because: Could not connect to engine 'rmengEng' on 'rmengdb' in Bulk mode. Check user id and passwords
ERROR: Failed to connect to database 'rmeng' with current password.
INFO: Trying the factory password for the database 'rmeng'.
ERROR: Failed to open the odbc template file for database rmeng
Use of uninitialized value at /opt/CSCOpx/lib/perl/db/Cisco/DbUtils.pm line 1879.
ERROR: Failed to stop the database engine with old password: Invalid parameters to StopDb..
ERROR: Failed change password for database 'rmeng'.

[ngoldwat]

Hi,

1) stop daemon

2) Go to NMSROOT\bin (where NMSROOT is the installation path of Ciscoworks, by default opt/CSCOpx for Solaris, or Program Files\CSCOpx on Windows)

3) perl dbpasswd.pl dsn=rmeng encryption=yes npwd=NEWPASSWORD

Have you tried dbpasswd.pl all?

As a point of interest LMS 2.5 is EOL as of March 26, 2010:

The last date to receive service and support for  the product. After this date, all support services for the product are  unavailable, and the product becomes obsolete.

http://www.cisco.com/en/US/prod/collateral/netmgtsw/ps6504/ps6528/ps2425/prod_end-of-life_notice0900aecd8069ce98.html

Thanks

[m.hephner]

That is what I did.  It seemed to change the password in the database but not in the application.  It gave me these errors.

INFO: Start changing password for database 'rmeng'...

Thu Sep 29 14:51:18 GMT 2011> INFO: New userinfo updated into database successfully.
Thu Sep 29 14:51:49 GMT 2011> ERROR: /opt/CSCOpx/databases/rmeng/orig/odbc.tmpl does not exist.
Thu Sep 29 14:51:49 GMT 2011> ERROR: Failed to update odbc template file.
Thu Sep 29 14:51:49 GMT 2011> ERROR: /opt/CSCOpx/databases/rmeng/orig/odbc.tmpl does not exist.
Thu Sep 29 14:51:49 GMT 2011> ERROR: Failed change password for database 'rmeng'.
Please see log file /var/adm/CSCOpx/log/dbpwdChange.log for details.

After that the application couldn't talk to the database.  I had to restore the rme database to get it working again.