12-21-2009 02:26 PM
Hi Team,
I Have a LMS 3.1 on Solaris 10, I have a some problems, from the origin DFM. When I try Backup this say me :
[Mon Dec 14 12:39:12 2009] ERROR(969): Fatal error: Could not connect to engine 'dfmFhEng' on 'dfmFhDb' in Bulk mode. Check user id and passwords.
[Mon Dec 14 12:39:12 2009] Backup failed: 2009/12/14 12:39:12
I try Validate the database:
/opt/CSCOpx/bin/perl ./configureDb.pl action=validate dsn=dfmFh
SQL Anywhere Command File Hiding Utility Version 10.0.1.3694
SQL Anywhere Validation Utility Version 10.0.1.3694
SQL error (-816) -- Specified database file already in use
SQL error (-816) -- Specified database file already in use
ERROR: [StandardDbUpgrade] Validation of dfmFh database failed
I try the change password or Recreate my Database DFMFH, but I can not make this
Can some one help me?
12-21-2009 04:09 PM
Why are you validating the DFM database with the services running ? In order to validate any LMS database, the CiscoWorks daemon manager must be shutdown. Use the following steps to shutdown.
- Verify the server is shutdown by doing an "/etc/init.d/dmgtd stop" then run "/opt/CSCOpx/bin/perl /opt/CSCOpx/db/conf/configureDb.pl action=validate dsn=dfmFh
Also to change the password for the database, you need to shutdown the daemon manager as well. The run the following sytax:
/opt/CSCOpx/bin/perl /opt/CSCOpx/bin/dbpasswd.pl dsn=dfmFh
Below is an example to complete the task:
Format1: dbpasswd.pl all
Change all database passwords.
Format2: dbpasswd.pl listdsn
List all available data sources in the product.
Format3: dbpasswd.pl dsn=odbc_datasource
Change the database password.
Format4: dbpasswd.pl dsn=odbc_datasource npwd=new_password
Change the database password to new_password.
Format5: dbpasswd.pl dsn=odbc_datasource encryption=yes
Encrypt the database password.
Format6: dbpasswd.pl dsn=odbc_datasource encryption=yes npwd=new_password
Change the database password and encrypt the database password.
-nael
12-21-2009 04:27 PM
Hi Nael,
Thanks, but I make this steps with Daemon Stop, Inclusive I validate other databases for example dfmInv and this can make the validation, but I can Problems with DFMFH, Inclusive I make self test from Gui and the result is Fail to connect because bad userid or password.
Why I can not see your answer?
Thanks
12-21-2009 09:34 PM
Thanks for the update. When stopping the CiscoWorks LMS services using "/etc/init.d/dmgtd stop", verify that all the process are completely shutdown by doing a "ps -ef | grep CSCOpx". If the processes are not shutdown, use the PID to kill the processes and try running the validation command. I guess the real question is why are you validating the database to begin with?
I'm assuming when mentioning DFMFH, you are using the correct dsn name which is "dfmFh" because its case sensitive. And what do you mean by making a selftest from the gui? Where are you getting the bad user ID or password error? Is it at the login page for the webui ? If so, then all you need to run is the "/opt/CSCOpx/bin/resetpasswd" when LMS daemon is shutdown.
It would be easier to understand your issue if you can provide screenshots and upload it here.
-nael
12-22-2009 09:50 AM
Hi Nael,
Thanks for your time,
My problem is because I can not make a Backup, and Faul History is fail. In the log for Backup here a message:
Starting database engine dfmFhEng
SQL Anywhere Command File Hiding Utility Version 10.0.1.3694
Communication error
ERROR(969): Fatal error: Could not connect to engine 'dfmFhEng' on 'dfmFhDb' in Bulk mode. Check user id and passwords.
Backup failed: 2009/12/17 19:40:14
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Inclusive when I try down the daemon, here a error:
/etc/init.d # ./dmgtd stop
Daemon Management stopping. This may take a few minutes.
INFO : Stopping DBEngine processes registered to Daemon Manager
WARNING: Daemon Manager could not stop DBEngine processes.
WARNING: Please run the command "/opt/CSCOpx/bin/dbstop.pl all"
WARNING: to stop DBEngine processes manually.
I try dbstop and this is "successfull" apparently. I say apparently because I try apply a patch for DFM and I can not make this because this say me that Daemon Manager can not stop.
I apply the command that you say me, and this is tha result:
uxm910v5:/opt/CSCOpx/bin # ps -ef | grep CSCOpx
root 13263 29143 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 133
root 13283 13281 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 131
root 13278 13272 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 131
root 13264 29143 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 133
root 13272 13270 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_authority
casuser 2595 29143 0 Dec 17 ? 15:04 /opt/CSCOpx/objects/db/bin64/dbsrv10 -x tcpip{HOST=localhost;DOBROADCAST=NO;Ser
root 4014 8847 0 11:26:31 pts/10 0:00 grep CSCOpx
root 13281 13280 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_authority
I do not know how use PID to kill the process, can you say me how use PID
The self test: is not for login in to CWLMS, the user and pwd is for dfmFh Database :
database.pl
FAIL Self Test Fail to query dfmFh.DbVersion, Error: Invalid user ID or password (DBD: login failed)
Self Test Fail to query dfmFh.SYSTABLE, Error: Invalid user ID or password (DBD: login failed)
I try restore the database for dfmFh, but I can not make this can not change the password.
Thanks
Mario Cerrillos García
Internetworking
NextiraOne Mexico S.A de C.V
12-22-2009 10:00 AM
The database has not shutdown and is still running based the process output provided.
Do the following step root/superuser "kill -9 13263 13283 13278 13264 13272 2595 13281".
uxm910v5:/opt/CSCOpx/bin # ps -ef | grep CSCOpx
root 13263 29143 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 133
root 13283 13281 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 131
root 13278 13272 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 131
root 13264 29143 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_logerror 133
root 13272 13270 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_authority
casuser 2595 29143 0 Dec 17 ? 15:04 /opt/CSCOpx/objects/db/bin64/dbsrv10 -x tcpip{HOST=localhost;DOBROADCAST=NO;Ser
root 4014 8847 0 11:26:31 pts/10 0:00 grep CSCOpx
root 13281 13280 0 Dec 17 ? 0:00 /opt/CSCOpx/objects/smarts/bin/system/sm_authority
Now attempt to apply the patch, validate, and backup .
-nael
12-22-2009 11:08 AM
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