Unable to start MySql service in Performance Center for Performance Management

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The attempt to start the MySql service fails with an error.

Trying to start MySql at the CLI with systemctl returns this message:

[user@hostName /Path]$ systemctl start mysql
Job for mysql.service failed because the control process exited with error code. See "systemctl tatus mysql.service" and "journalctl -xe" for details.

Running the recommended status command reveals the key error:

[user@hostName /Path]$ systemctl status mysql
...
<Date_Time> <HostName> mysql.server[##]: Starting MySQL. ERROR! The server quit without updating PID file (/opt/CAPM/MySql/data/hostName.pid).
<Date_Time> <HostName> systemd[##]: mysql.service: control process exited, code=exited stauts=1
<Date_Time> <HostName> systemd[##]: Failed to start MySQL daemon.

Environment

All supported Performance Management releases

Cause

Incorrect permissions on the top level /opt directory.

The directory had 750 permissions leaving Other without access.

Resolution

The /opt directory requires 755 permissions to ensure other users that should have access, can access it to utilize it.

Running the following as the root or install owner user resolved the problem and allowed the MySql service to start properly.

chmod 755 /opt