Installing PC Portal 21.2.11 but seeing the following errors. All other PC services are installed without error. Only MySql shows errors.
The MySql errors are these from the MySql_Install_<Date>_<Time>.log file. It shows two FatalError entries.
Summary
-------
Installation: Unsuccessful.
417 Successes
0 Warnings
0 NonFatalErrors
2 FatalErrors
The first error is:
Execute Script/Batch file: Initializing...
Status: SUCCESSFUL
Custom Action: com.ca.im.installanywhere.action.GenerateInstallFailure
Status: FATAL ERROR
Additional Notes: FATAL ERROR - class com.ca.im.installanywhere.action.GenerateInstallFailure FatalInstallException: MySql DB initialization failed!
Checking /etc/profile to see if any PATH= line contains :/opt/CA/MySql/bin"
Looking up version property in file: /etc/my.cnf
Looking up version property in file: /tmp/017285.tmp/MySql/my.cnf
Current MySQL configuration version is latest - no install needed.
Then a short bit further down in the log:
Execute Script/Batch file: Install UDF as script
Status: SUCCESSFUL
Custom Action: com.ca.im.installanywhere.action.GenerateInstallFailure
Status: FATAL ERROR
Additional Notes: FATAL ERROR - class com.ca.im.installanywhere.action.GenerateInstallFailure FatalInstallException: Error loading UDF plugin. v6_* functions will be unavailable for GlobalSync, etc!!!
Execute Script/Batch file: Restart MySql
Status: SUCCESSFUL
All supported DX NetOps Performance Management releases
The umask value is set wrong for the root user. The system had the root user umask set to 0027. We require 022. This setting was propagated to the mysql user as well.
This prevented the mysql user from accessing the /opt/CA/MySql directory and any other directories or files within it. Without that ability the install would fail.
To resolve this take the following steps. This assumes a new install so no need to back anything up.
In some situations the umask may be reset due to internal requirements. In these cases set the umask in the .profile for each affected user.