cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
992
Views
5
Helpful
7
Replies

Problems for connect database with lmddatafeed user

Luis Vicente
Level 1
Level 1

Hi,

I connected to cmfDb with cmfDBA user but  I can't reach with lmsdatafeed user.

I launched dbpasswd.pl dsn=cmf npwd=******** to change user password beacuse I was thinking that I was changing password for lmsdatafeed. Finally I can connect with db but only withcmfDBA.

Using SSQL Anywhere client I can see users but I don't  find lmsdatafeed on list.

I can't understand whats the matter, I don't know if there're a problem with db installation and I must launch dbaccess.pl install or how I can change password to user lmsdatafeed.

Regards,

1 Accepted Solution

Accepted Solutions

could it be that an anti-virus software is preventing the execution of dbaccess.pl?

View solution in original post

7 Replies 7

AFROJ AHMAD
Cisco Employee
Cisco Employee

Hi,

Enabling Access to Database

To enable the access to applications database, you must run the dbaccess.pl utility from the command line.

You must run:

NMSROOT/bin/perl NMSROOT/bin/dbaccess.pl {install|clean} [debug] on Solaris systems

NMSROOT\bin\perl NMSROOT\bin\dbaccess.pl {install|clean} [debug] — on Windows systems

where,

NMSROOT — Default CiscoWorks installation directory

install Command line parameter that cleans the existing views, creates new views and provides access to databases

clean Command line parameter that cleans the existing views

debug Prints the debug and warning messages on the screen

The default database view user name is lmsdatafeed. The CLI utility prompts you to enter the database view password.

You can enter password of length between 5 to 30 characters.

A few warning messages appear while running the utility with the debug option. These messages appear when the view definitions are not in the database.

For example, you may get the following warning messages while the utility enables access to Common Services database:

WARN: User ID 'lmsdatafeed' does not exist (DBD: execute failed).
WARN: Table 'Network_Devices' not found (DBD: execute failed).
WARN: Table 'Job_Details' not found (DBD: execute failed).

You can ignore these warning messages.

I hope this will help you !!!

for more information you can chekc the below link :

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html

Thanks--

Afroj

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****

Martin Ermel
VIP Alumni
VIP Alumni

to reset the password of lmsdatafeed you can just re-run
NMSROOT\bin\perl NMSROOT\bin\dbaccess.pl install

you will be asked to set the password for user lmsdatafeed and the views will be dropped and regenerated. You wont loose any data in the database.
Details on the process can be found here:
http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp69517

also keep in mind, that with dbaccess.pl you will not gain access to the databases (like cmd, ani, rmeng, ...) you just generate certain predefined views and the user "lmsdatafeed" who has READ access only to these views. The views themselves provide you structured data from different tables of the different databases - and the schema of these views is published - so you can make use of this data.

Direct database access is still not supported by Cisco.

With dbpasswd.pl you do NOT change the password of the user "lmsdatafeed" but of the internally used user (as you mentioned, for cmf it is cmfDBA)

Hi,

We launch dbaccess.pl install debug yesterday. There aren't response yet.

We must stop any service? Whats matter?

Regards,

do I understand correctly, that you executed dbaccess.pl and you did not get a response back from the script ?

No services needs to be stopped.

can you please open another DOS box and provide the output of "pdshow" and "pdshow -brief"

Exactly, dbaccess.pl doesn't work and there aren't response.

We executed "pdshow -brief" and this is the response:

C:\Program Files (x86)\CSCOpx\bin>pdshow -brief

  Process               State                                     Pid

  *******               *****                                     ***

  Tomcat                Program started - No mgt msgs received    2380

  TomcatMonitor         Running normally                          2652

  Apache                Program started - No mgt msgs received    2900

  RMEDbEngine           Program started - No mgt msgs received    4700

  Proxy                 Program started - No mgt msgs received    4808

  ProcSysBus            Program started - No mgt msgs received    4816

  OpsxmlDbEngine        Program started - No mgt msgs received    4860

  OpsXMLRuntime         Program started - No mgt msgs received    4956

  CWAPublisher          Administrator has shut down this server   0

  NameServer            Program started - No mgt msgs received    5028

  NameServiceMonitor    Running normally                          5432

  EDS                   Running normally                          5676

  LicenseServer         Program started - No mgt msgs received    12

  IpmDbEngine           Program started - No mgt msgs received    5964

  INVDbEngine           Program started - No mgt msgs received    6288

  FHPurgeTask           Never started                             0

  FHDbEngine            Program started - No mgt msgs received    6392

  ESS                   Program started - No mgt msgs received    6496

  EssMonitor            Running normally                          6592

  EventFramework        Program started - No mgt msgs received    6808

  PMServer              Running normally                          6816

  SyslogCollector       Program started - No mgt msgs received    6248

  EPMDbEngine           Program started - No mgt msgs received    6256

  EPMServer             Running normally                          7328

  FHServer              Running normally                          7832

  diskWatcher           Running normally                          7840

  DFMMultiProcLogger    Program started - No mgt msgs received    7848

  DFMLogServer          Program started - No mgt msgs received    7856

  DFMCTMStartup         Administrator has shut down this server   0

  DfmBroker             Program started - No mgt msgs received    7876

  DfmServer             Running normally                          7984

  DfmServer1            Running normally                          7992

  DCRDevicePoll         Program started - No mgt msgs received    8572

  CSSCPServer           Program started - No mgt msgs received    8000

  CSRegistryServer      Running normally                          8008

  CSDiscovery           Never started                             0

  CmfDbEngine           Program started - No mgt msgs received    8124

  CmfDbMonitor          Running normally                          8368

  DCRServer             Running normally                          8436

  CMFOGSServer          Program started - No mgt msgs received    8624

  CampusOGSServer       Program started - No mgt msgs received    9212

  EssentialsDM          Running normally                          8256

  ConfigMgmtServer      Program started - No mgt msgs received    8564

  ICServer              Running normally                          8248

  RMEOGSServer          Program started - No mgt msgs received    8616

  PMCOGSServer          Program started - No mgt msgs received    9400

  TISServer             Program started - No mgt msgs received    9408

  DFMOGSServer          Program started - No mgt msgs received    9772

  InventoryCollector    Running normally                          9252

  Interactor            Program started - No mgt msgs received    9260

  InventoryCollector1   Program started - No mgt msgs received    8700

  Interactor1           Program started - No mgt msgs received    10496

  NOSServer             Running normally                          10504

  PTMServer             Running normally                          10512

  EDS-GCF               Running normally                          10520

  jrm                   Running normally                          10528

  CTMJrmServer          Running normally                          11448

  ChangeAudit           Program started - No mgt msgs received    11292

  SyslogAnalyzer        Program started - No mgt msgs received    12180

  DataPurge             Administrator has shut down this server   0

  IPMProcess            Program started - No mgt msgs received    12192

  IPMOGSServer          Program started - No mgt msgs received    9364

  1806                  Program started - No mgt msgs received    16184

  ANIDbEngine           Program started - No mgt msgs received    10120

  ANIServer             Running with busy flag set                11400

  UTMajorAcquisition    Transient terminated                      0

  MACUHIC               Running normally                          12548

  UTLITE                Running normally                          12556

  UTManager             Running normally                          12564

  VNMServer             Program started - No mgt msgs received    12572

  WlseUHIC              Running normally                          12580

  AdapterServer1        Program started - No mgt msgs received    12588

  AdapterServer         Program started - No mgt msgs received    12596

could it be that an anti-virus software is preventing the execution of dbaccess.pl?

There aren't antivirus installed.

[Edited]

Finally Reboot the server and the command worked : O

Thanks you very much!!

Best regards.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: