Unable to validate DFM database

Mario C. G. · ‎12-21-2009

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?

Nael Mohammad · ‎12-21-2009

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

Mario C. G. · ‎12-21-2009

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

Nael Mohammad · ‎12-21-2009

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

Mario C. G. · ‎12-22-2009

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

Nael Mohammad · ‎12-22-2009

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

Mario C. G. · ‎12-22-2009

Nael,

You are a Master. I can Validate my dfmFh database, apply the patch and make backup.

Thanks for your help.

Mario Cerrillos García

Internetworking

NextiraOne Mexico S.A de C.V