Websites unable to connect to database with localhost

Issue

Websites are unable to connect to a database with localhost.

Error:

Error establishing a database connection

Environment

• CageFS

Solution

1. Check that /var/lib/mysql is present in your cagefs.mp file:

   #  grep mysql /etc/cagefs/cagefs.mp

   In case it is not, please add it and execute the

   # cagefsctl --force-update

2. Check if your mysql.sock file is configured to a custom location in /etc/my.cnf file. If so, create a symlink to the file in /var/lib/mysql to your current mysql.sock file using command (for example, if your current mysql.sock is in the /home/mysql/ folder):

   # ln -s /home/mysql/mysql.sock /var/lib/mysql/mysql.sock

   Note: If you have specified another location for mysql.sock, then update the aforementioned command accordingly.
   
   

3. Update CageFS using the command:

   # cagefsctl --force-update

   Note: You may change the address from localhost to 127.0.0.1 as a workaround.
   This solution, however, is not recommended as it may confuse the customers.

Cause

• MySQL directory might be missing from the CageFS configuration, thus websites have trouble connecting to MySQL from inside the CageFS.
• Another option is that mysql.sock file is displaced elsewhere.

Useful Links

https://docs.cloudlinux.com/cloudlinux_os_components/#mount-points