Unable to start MySql service in Performance Center for Performance Management


Article ID: 195683


Updated On:


CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps


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

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

[[email protected] /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:

[[email protected] /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.


Incorrect permissions on the top level /opt directory.

The directory had 750 permissions leaving Other without access.


All supported Performance Management releases


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