Unable to start MySql service in Performance Center for Performance Management

book

Article ID: 195683

calendar_today

Updated On:

Products

CA Infrastructure Management 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:

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

Cause

Incorrect permissions on the top level /opt directory.

The directory had 750 permissions leaving Other without access.

Environment

All supported Performance Management releases

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