I need use data from CiscoWorks database

Unanswered Question
Dec 15th, 2008
User Badges:

Hello,


I need use data from CiscoWorks database(CiscoWorks Sybase Server).


CiscoWorks LMS 3.1 run on Windows 2003, with database Sybase SQL Anywhere 11.


I tried connecting through ODBC (port 43441). For test I installed new

CiscoWorks server. I tried all combination of user/password data which I set

during installation process. Unfortunately it doesn't work.


ODBC Client send information - [OpenLink][ODBC][SQL Server]Login incorrect.

(20014).


Anyone knows where can I find correct information about login and password?


Thanks for any ideas,


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Joe Clarke Mon, 12/15/2008 - 11:49
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Direct access to the CiscoWorks databases is not supported. We offer some tools to get at some of the data (cwcli for RME data and cmexport for Campus Manager data). We are considering some level of direct ODBC/JDBC access for the next release of LMS due out in the summer of 2009.

Anything new on this topic? We are waiting to upgrade to the latest version if we can have xDBC access to the store. Is the Summer 2009 in beta available where we can demo/try it to get justification? We are currently at the old 2.5 and plan to just start over with a fresh install. Also - with roughly >5K devices, what would be the recommended platform to run the latest code on?


Thanks

JIM

srego4 Wed, 04/15/2009 - 06:33
User Badges:

default user ids and pwds for LMS


Campus Manager


ANIc2

UID=cwsiSA

PWD=cwsiPWD

DatabaseName=ani


Common Services


CMF

UID=cmfDBA

PWD=c2ky2k

DatabaseName=cmf


Resource Manager Essentials


RME

UID=dba

PWD=c2ky2k

DatabaseName=rmeng



--------------------


default Cisco user ids for LMS 3.1


Database Username

cmf cmfDBA

rmeng dba

ani cwsiSA

dfmEpm itemEpmUser

dfmFH itemFhUser

dfmInv itemInvUser

Joe Clarke Wed, 04/15/2009 - 09:15
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

This is wrong. There are no default passwords for these databases. The passwords are randomly generated, or chosen by the user.

Actions

This Discussion