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

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.

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

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