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.
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.
Feedback