open cmf database

Unanswered Question
Jun 6th, 2010
User Badges:

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Michel Hegeraat Sun, 06/06/2010 - 23:24
User Badges:
  • Gold, 750 points or more

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

Joe Clarke Sun, 06/06/2010 - 23:25
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

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.

Actions

This Discussion