Unable to logon to NetOps Portal

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

The following Server Error is displayed when attempting to login:

javax.servlet.ServletException: org.apache.jasper.JasperException: An exception occurred processing JSP page

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

Cause

On further investigation, the PCService.log displayed messages such as:

SQL state [HY000]; error code [29]; File './netqosportal/item_types.MYD' not found (Errcode: 13 - Permission denied);

 

Going from there, the MySql hostname.err log showed similar and widespread messages like:

[ERROR] /opt/CA/MySql/bin/mysqld: Can't find file: './mysql/events_l10n.frm' (errno: 13 - Permission denied)
[ERROR] /opt/CA/MySql/bin/mysqld: Can't find file: './netqosportal/events_l10n.frm' (errno: 13 - Permission denied)
[ERROR] /opt/CA/MySql/bin/mysqld: Can't find file: './performance_schema/events_l10n.frm' (errno: 13 - Permission denied)
[ERROR] /opt/CA/MySql/bin/mysqld: Can't find file: './sys/events_l10n.frm' (errno: 13 - Permission denied)

 

Upon checking on these files, they were owned by root:root and should be owned by mysql:mysql.  This is the reason the mysql user (who the MySql database runs as) cannot access the files.

Resolution

The two directories that MUST be owned by the mysql user are data and tmp.  To change permissions back to their proper values:

1. chown -R mysql:mysql /opt/CA/MySql/data
2. chown -R mysql:mysql /opt/CA/MySql/tmp