Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Hostname change in cnf database for LMS 2.6

I renamed Ciscoworks LMS 2.6 hostname, suddenly all application stop working, using netpro post I found the problem, after I revert back the hostname application start working, but I have to change the hostname. As per the procedure I was trying to change the cnf database hostname , it says username or password incorrect. I tried all username and password but no luck, I used this command dbisqlc -c"uid=cmfDBA;pwd=dbpassword;eng=cmfEng;dbf=NMSROOT\databases\cmf\cmf.db" -q update PIDM_app_device_map SET app_hostname=`NewhostName' where app_hostname= `OldhostName' I want to solve this issue, please help me.

2 REPLIES
Cisco Employee

Re: Hostname change in cnf database for LMS 2.6

Hi.

I'm assuming you're following the procedure outlined here:

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_common_services_software/3.0/user/guide/diagnos.html#wp1078582

Did you enter the command exactly like that (where pwd=dbpassword) or did you use the actual database password...or has that been forgotten? If it's still the default, that would be c2ky2k .

If you *have* changed the database password some time in the past and you just don't recall what the password was changed to, you can try resetting the cmf database pw as follows:

1) Stop the Daemon Manager

c:\net stop crmdmgtd

2) Change the CMF database password:

a-Go to the NMSROOT\CSCOpx\bin directory.

b-Run: perl.exe dbpasswd.pl dsn=cmf encryption=yes npwd=your_new_password_here

3) Start the Daemon Manager:

c:\net start crmdmgtd

Hope this helps,

-Joe R.

New Member

Re: Hostname change in cnf database for LMS 2.6

Thanks Joe,

This cisco works installation done by sombody else, and system administrator don't the password.This issue in one of my customer place,When i put this command"perl.exe dbpasswd.pldsn=cmfencryption=yesnpwd=your_new_password_here" System says datbase not found.

Anyway I will try once more.Thanks for your help Regards, Sujesh

140
Views
0
Helpful
2
Replies
CreatePlease login to create content