Thanks for the quick response.
What is the other output from dbinstall.php before database connection error?
WEB-INF/templates_c/ directory is writable.
WEB-INF/config.php file exists.
DSN is defined.
PHP version: 5.6.40-47+ubuntu20.04.1+deb.sury.org+1, good enough.
mysqli PHP extension is loaded.
mbstring PHP extension is loaded.
gd PHP extension is loaded.
Error: connection to database failed. MDB2 Error: unknown error
Version of Time Tracker?
Confirm that you have mysql extension installed, also try using mysqli instead (which is the default).
Confirmed, both mysqli and mysql report the same error
Are there any special characters used in password such as the @ sign? Try another password without special characters.
I've changed the mysql password to all lowercase no specials no numbers.
User is 'ttuser'@'%' and again, verified I can auth and use the database with mysql via cli
Code: Select all
mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))