Solved: Ciscoworks - Database Ad-hoc Retrieval

sometechguy · ‎06-25-2008

I am trying to use the Ad-hoc Retrieval page on our Ciscoworks (LMS 2.6) implementation. I have been getting the failed login (bad username/password) message when attempt to pull table data.

I have tried the default (sa/c2kY2k) but I get the same results.

The /rmeng/orig/odbc.tmpl file contains a CWUID and CWPWD but they do not work (I'm assuming they are encrypted).

Any ideas or other password combinations for the database?

Joe Clarke · ‎06-25-2008

This tool is not supported for customer use. Changes to the database using this tool could require you to reinitialize your database, thus causing data loss.

That said, the database passwords are random in LMS 2.6. You can use the NMSROOT/bin/dbpasswd.pl utility to set the database password to a known value.

View solution in original post

Joe Clarke · ‎06-25-2008

This tool is not supported for customer use. Changes to the database using this tool could require you to reinitialize your database, thus causing data loss.

That said, the database passwords are random in LMS 2.6. You can use the NMSROOT/bin/dbpasswd.pl utility to set the database password to a known value.