The following Server Error is displayed when attempting to login:
javax.servlet.ServletException: org.apache.jasper.JasperException: An exception occurred processing JSP page
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.
Release : 20.2
Component : IM Reporting / Admin / Configuration
The two directories that MUST be owned by the mysql user are data and tmp. To change permissions back to their proper values: