ADA 11.2 database user account super

Products

• CA Application Delivery Analysis (NetQoS / ADA)

Issue/Introduction

Are there any requirements for the super account used by ADA 11.2 in MySQL?

Cause

The Installation Prerequisites in the documentation does not provide requirements for the password used by the super MySQL account.

Resolution

'super' cannot be the password used for the super MySQL account.

Additional Information

If 'super' has been used for the account and services are not starting, the following steps can be used to fix this:

1. uninstall ADA
2. run this command from mysql prompt login as root
   ALTER USER 'super'@'%' IDENTIFIED BY '<NewPassword>';
3. try to login mysql as super user and check connectivity works
4. install ADA and provide mysql password as NewPassword instead of super
5. After installation, finish rebooting the machine and check all services are up and running as expected.