cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1726
Views
0
Helpful
3
Replies

LMS 3.2 - how to connect to SQL DB and export DCR data?

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?

1 Accepted Solution

Accepted Solutions

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

View solution in original post

3 Replies 3

ccube
Level 1
Level 1

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

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.

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

Getting Started

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: