10-03-2011 04:31 AM
Got an problem with LMS 3.2/Solaris.
See no devices both in DCR and RME, besides, in RME device counters (Normal/Pending/etc) are equal to current device count, but then you try to select them for any operation, you unsucceed - 0 device selected, no list of devices, unable to export, no ability to do anything.
Upgraded to 3.2 SP1, no change. Spend a lot of time digging through logs at /usr/adm/CSCOpx/logs, find no problems at all. Seems, that some database parts were corrupted.
I decided to reinstall LMS from the scratch, but to do so I need to export the DCR device data and credentials.
Database is alive (dbaccess.pl install going smoothly, then connection with user lmsdatafeed works and allows to connect and select data from any SQL tool), but this view is not enough for getting from the DCR both device data and credentials.
I have the DB password I set up during installation.
Is there any way to get data I need connecting to LMS database directly with some kind of sysdba SQL database user?
Solved! Go to Solution.
10-04-2011 01:35 AM
These are the DBA users/DBnames for the various applications that make up LMS 3.2:
Common Services Database
--Database name (dsn)
cmf
--Database login
cmfDBA
RME Database
--Database name (dsn)
rmeng
--Database login
DBA
ANI Database
--Database name (dsn)
ani
--Database login
cwsiSA
Inventory Database
--Database name (dsn)
dfmInv
--Database login
itemInvUser
Event Database
--Database name (dsn)
dfmEpm
--Database login
itemEpmUser
Fault History Database
--Database name (dsn)
dfmFh
--Database login
itemFhUser
Passwords would be what was assigned during the installation of LMS. If you need to change these, then the following would apply:
For Solaris:-
/opt/CSCOpx/bin/dbpasswd.pl
Running the above command will reset database password to default.
Usage:
Format1: dbpasswd.pl all
Change all database passwords.
Format2: dbpasswd.pl listdsn
List all available data sources in the product.
Format3: dbpasswd.pl dsn=odbc_datasource
Change the database password.
Format4: dbpasswd.pl dsn=odbc_datasource npwd=new_password
Change the database password to new_password.
Format5: dbpasswd.pl dsn=odbc_datasource encryption=yes
Encrypt the database password.
Format6: dbpasswd.pl dsn=odbc_datasource encryption=yes npwd=new_password
Change the database password and encrypt the database password.
Hth,
Cary
10-04-2011 12:32 AM
Review this guide:
http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html
This gives some insights as to what is possible.
Hth,
Cary
Sent from Cisco Technical Support iPad App
10-04-2011 12:37 AM
It's already reviewed.
If you'll check the initial post, you'll find that "connection with user lmsdatafeed works and allows to connect and select data from any SQL tool), but this view is not enough for getting from the DCR both device data and credentials".
I need the DBA-level username(s) to connect to DB, I have DBA password but have no DBA usernames for LMS components. Also, the hints on device credential location in DB and tables would be useful.
10-04-2011 01:35 AM
These are the DBA users/DBnames for the various applications that make up LMS 3.2:
Common Services Database
--Database name (dsn)
cmf
--Database login
cmfDBA
RME Database
--Database name (dsn)
rmeng
--Database login
DBA
ANI Database
--Database name (dsn)
ani
--Database login
cwsiSA
Inventory Database
--Database name (dsn)
dfmInv
--Database login
itemInvUser
Event Database
--Database name (dsn)
dfmEpm
--Database login
itemEpmUser
Fault History Database
--Database name (dsn)
dfmFh
--Database login
itemFhUser
Passwords would be what was assigned during the installation of LMS. If you need to change these, then the following would apply:
For Solaris:-
/opt/CSCOpx/bin/dbpasswd.pl
Running the above command will reset database password to default.
Usage:
Format1: dbpasswd.pl all
Change all database passwords.
Format2: dbpasswd.pl listdsn
List all available data sources in the product.
Format3: dbpasswd.pl dsn=odbc_datasource
Change the database password.
Format4: dbpasswd.pl dsn=odbc_datasource npwd=new_password
Change the database password to new_password.
Format5: dbpasswd.pl dsn=odbc_datasource encryption=yes
Encrypt the database password.
Format6: dbpasswd.pl dsn=odbc_datasource encryption=yes npwd=new_password
Change the database password and encrypt the database password.
Hth,
Cary
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: