RADRaze2KX
Verified User
- Joined
- Jan 4, 2024
- Messages
- 34
I'm still in the testing phase, so this isn't mission critical, but I'm not sure where to start with this one. I have three independent servers:
1.) Our WordPress website, linking to WHMCS (ubuntu 22.04 on a VPS) (irrelevant for this)
2.) WHMCS (ubuntu 22.04 on a VPS)
3.) DirectAdmin + Softacluous (CloudLinux 8.9 with CageFS, MySQL Governor, MySQL 8.0)
I have packages created for WordPress hosting; when a client buys a package from the WHMCS server, it provisions it to the DirectAdmin server. This part is working.
However, when trying to view the site using https : // acmehosting .com / ~userdir (userdir is turned on in DirectAdmin), it comes up to a page with "Error establishing a database connection".
Typically, this is caused by wrong info in the config file or database server is unavailable.
The odd thing is that the info in the config is correct. I can use it to access the DB in phpMyAdmin without issues and I see the database tables are there. I can log in as the test user and go to Softaculous, delete the wordpress installation, and reinstall it, and get the same issue.
The only hint I have is that in WHMCS, when I go to the test account's products and services and do a refresh, I see "MySQL® Databases -" as if there's nothing there. DirectAdmin shows the user has 1 MySQL database, so maybe it's not a hint at all.
I'm not the best with Linux/CloudLinux, so I'm not sure where to start. I checked /var/log (mysql.log) and (mysqld.log) on the DirectAdmin server and both are empty. mysql --version shows "Ver 8.0.35 for Linux on x85_64 (MySQL Community Server - GPL)"
Anybody have an idea of where to start?
1.) Our WordPress website, linking to WHMCS (ubuntu 22.04 on a VPS) (irrelevant for this)
2.) WHMCS (ubuntu 22.04 on a VPS)
3.) DirectAdmin + Softacluous (CloudLinux 8.9 with CageFS, MySQL Governor, MySQL 8.0)
I have packages created for WordPress hosting; when a client buys a package from the WHMCS server, it provisions it to the DirectAdmin server. This part is working.
However, when trying to view the site using https : // acmehosting .com / ~userdir (userdir is turned on in DirectAdmin), it comes up to a page with "Error establishing a database connection".
Typically, this is caused by wrong info in the config file or database server is unavailable.
The odd thing is that the info in the config is correct. I can use it to access the DB in phpMyAdmin without issues and I see the database tables are there. I can log in as the test user and go to Softaculous, delete the wordpress installation, and reinstall it, and get the same issue.
The only hint I have is that in WHMCS, when I go to the test account's products and services and do a refresh, I see "MySQL® Databases -" as if there's nothing there. DirectAdmin shows the user has 1 MySQL database, so maybe it's not a hint at all.
I'm not the best with Linux/CloudLinux, so I'm not sure where to start. I checked /var/log (mysql.log) and (mysqld.log) on the DirectAdmin server and both are empty. mysql --version shows "Ver 8.0.35 for Linux on x85_64 (MySQL Community Server - GPL)"
Anybody have an idea of where to start?
Last edited: