open cmf database

abdeldjalil-mergui · ‎06-06-2010

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

Michel Hegeraat · ‎06-06-2010

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 · ‎06-06-2010

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.