Installation issue on Apache2

Hi again Dev

Sorry if you see my first post about installation in OLS. Anyway, I made separate discussion to keep things simple. This time I tried using Apache2 and I am stuck again even after success installing mod_rewrite for apache and php. Please check my progress below:

I use apache2 which then set its webroot to point to where I copy LeanTime:
/Tech/Leantime/public

I ran the apache after installing php7.4 dan mod_rewrite and test with php info and some simple html and apache and php works fine.

http:///info.php --> works
http:///index.html --> works
http:///install --> Error No database connection, check your database credentials in your configuration file.

My System is:
a. Debian 10
b. MySQL 8.0.21 --> I suspect this new version of mysql encryption for the user table using sha could be the culprit
c. PHP 7.4
d. Apache 2.4.46

I checked the apache log and no error were shown

I changed the configuration.php as follow:
/* Database */
public $dbHost=“localhost”; //Database host
public $dbUser=“leantimemgr”; //Database username
public $dbPassword=“mypass”; //Database password
public $dbDatabase=“leantimedb”; //Database name

I tested mysql server and database directly using console mysql command and Aquadata database client and it worked. Even after setting my root user account to the configuration.php, it is still showing Error No database connection, check your database credentials in your configuration file.

Can you please help? Thank you

EDIT: Nevermind, I found out that the dbhost is not supposed to be localhost as php is weird. You should use 127.0.0.1

1 Like

Glad it got resolved. I just answered on the OpenLite discussion as well.