Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

open cmf database

hello

to connect to the database cmfDb, I need a default database username for cmf database (Commom Services) in ciscoworks LMS 2.6

for exemple we have: user ID= cwsiSA for aniDb database

some can help me

thanks

2 REPLIES

Re: open cmf database

This should help you for most of the DB's

if ($dsn eq 'ani'   ){$uid = 'cwsiSA'     ; }
if ($dsn eq 'cmf'   ){$uid = 'cmfDBA'     ; }
if ($dsn eq 'rmeng' ){$uid = 'DBA'        ; }
if ($dsn eq 'dfmEpm'){$uid = 'itemEpmUser'; }
if ($dsn eq 'dfmInv'){$uid = 'itemInvUser'; }
if ($dsn eq 'dfmFh' ){$uid = 'itemFhUser' ; }
if ($dsn eq 'opsxml'){$uid = 'DBA'        ; }
if ($dsn eq 'upm'   ){$uid = 'dba'        ; }

Make a complete backup before you change anything!

Cheers,

Michel

Cisco Employee

Re: open cmf database

The main cmf database username is cmfDBA.  However, direct database access is not supported in LMS 2.6.  Support was added in LMS 3.2 via special read-only data views.

244
Views
0
Helpful
2
Replies