06-06-2010 09:49 PM
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
06-06-2010 11:24 PM
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
06-06-2010 11:25 PM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide