Unable to access GUI while using MySQL SSL
How to solve HTTP 500 error while accessing Ezeelogin GUI?
Overview: This article helps to troubleshoot and resolve the HTTP 500 error encountered while accessing the Ezeelogin GUI when using MySQL SSL, by adjusting the permissions of the /etc/certs directory.
Step 1: Check for the latest messages from the application log. Navigate to the log directory and tail the latest log.
root@gateway:~# cd $(awk ’/^system_folder/ {print $2}’ /usr/local/etc/ezlogin/ez.conf)/application/logs/
root@gateway:/var/www/ezlogin/application/logs# tail log-2024-09-24.php
ERROR - 2024-09-24 15:15:06 --> Severity: Warning --> mysqli::real_connect(): Unable to set local cert chain file `/etc/certs/client-cert.pem’; Check that your cafile/capath settings include details of your certificate and its issuer /var/www/ezlogin/system/database/drivers/mysqli/mysqli_driver.php 211
Step 2: Check and correct the permission of /etc/certs directory and client-cert.pem.
root@gateway:~# chmod 755 /etc/certs/
root@gateway:~# chmod 644 /etc/certs/client-cert.pem
Step 3: If you have a cluster setup ensure that the same certificates and keys are used for both the primary and secondary nodes. Copy the certificates and keys from the primary node to the /etc/certs/ directory on the secondary node. The following certificates and keys should be copied:
root@gateway:~# cd /etc/certs
root@gateway:/etc/certs# ls
ca-key.pem client-cert.pem server-key.pem
ca.pem client-key.pem server-cert.pem
Related Articles:
Configure jump server to use SSL for MySQL
Configure ssh jump server to use SSL for Mariadb