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