After running mysql_config_editor Archive Manager and DDMDB Backups are failing

book

Article ID: 145293

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

After running the mysql_config_editor on our Spectrum installation ddm_backup and ddm_save fails to run with access denied errors.

Environment

Release : 10.4

Resolution

The password set using the mysql_config_editor is wrong.

Just run it again and specify the right password.

1. Navigate into $SPECROOT/mysql/bin as the "caadmin" user.

2. Type:

./mysql_config_editor set --login-path=client --host=localhost --user=spectrum --password

./mysql_config_editor set --login-path=client --host=localhost --user=caadmin --password

Enter caadmin as the password.

Your applications should start working successfully.

Change user to the user ID used to install Spectrum.
By default the username and password are the same.  So "caadmin" would be the password set.