Yeah hey sorry got distracted with the end-of-summer back-to-school holidays here. Let me poke at it and I will reach out to you again.
- PHP version: 7.2.21-1+ubuntu18.04.1+deb.sury.org+1
ok all the var dumps look good...
i am not much of a PHP guy. any way to get any better idea of where this is failing when it calls that library?
What line number should I add that to the file?
So I made a php script to test PDO
$servername = "xxxx.myhostname.com";
$username = "dbuser";
$password = "dbpassword";
$conn = new PDO("mysql:host=$servername;port=3306;dbname=eqdkp", $username, $password);
// set the PDO error mode to exception
echo "Connected successfully";
echo "Connection failed: " . $e->getMessage();
When I run it...
if I typo the password I get a SQLSTATE[HY0000]  Access Denied, what is interesting is if I typo the hostname eventually it will kick out a SQLSTATE[HY0000] connection timed out.
Is EQDKP somehow failing a hostname lookup or could i be exceeding a string length in the hostname field and its truncating? Could it be ignoring the non-standard port? Any logging get kicked out during install?
Maybe you did it wrong?
But I cannot see any problem here with Eqdkp. It is not long ago that I have checked compatibility with mysql8.
Its a remote-db but using phpmyadmin off my server with the same credentials i am using for the eqdkp installation works as expected (pypmyadmin also does not support SHA2) . That is where i am questioning whats wrong.
Maybe you have misconfigured your php installation. As EQdkp uses the pdo drivers of php, we do nothing directly on databases, but using the PDO abstraction builtin php.
It says its using PHP 7.2 and 7.2 PDO doesnt have an issues talking to MYSQL8 as long as you use the legacy password types on your DB users (which i did).
phpmyadmin works properly it seems.
Right thats why I changed it to use legacy for that user instead of the new SHA2 but it still times out.
On a related note. I am trying to install eqdkp on a Mysql8 instance. I have setup the DB user to use traditional login not SHA2 but I keep getting this error when trying to access the DB:
I can login to mysql fine from the linux mysql client, and from mysql workbench.
SQLSTATE[HY000]  Connection timed out