Page 1 of 1

[SOLVED] Having some mysql issues when installing opencard

Posted: Fri Apr 20, 2018 11:56 pm
by fadey
Warning: mysqli::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in C:\Apache24\htdocs\system\library\db\mysqli.php on line 7Warning: mysqli::__construct(): (HY000/2054): The server requested authentication method unknown to the client in C:\Apache24\htdocs\system\library\db\mysqli.php on line 7Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in C:\Apache24\htdocs\system\library\db\mysqli.php on line 10Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in C:\Apache24\htdocs\system\library\db\mysqli.php on line 10Notice: Undefined variable: mysql in C:\Apache24\htdocs\install\controller\install\step_3.php on line 280Notice: Trying to get property 'connect_error' of non-object in C:\Apache24\htdocs\install\controller\install\step_3.php on line 280
I've been trying all day to solve this but honestly, I don't really know what I'm doing in the first place.
PHP version 7
Mysql 8.0.11
Apache 2.4.33

I double checked database/ username and password, everything seem to check out.
I do not work with mysql or php and I don't really know what those warnings and errors mean.

Thank you!

Re: Having some mysql issues

Posted: Sat Apr 21, 2018 7:39 am
by acx
Are you trying to install?

If so, select PDO instead of MySQLi and see if that works.

Re: Having some mysql issues

Posted: Sat Apr 21, 2018 11:44 pm
by fadey
I am trying to install, corrent.

Here's what happened when I did what you told me to:

Code: Select all

Failed to connect to database. Reason: 'SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client' 

Re: Having some mysql issues when installing opencard

Posted: Sun Apr 22, 2018 12:55 am
by fadey
I reinstalled everything and this time wen't with php5 because .. maybe it helps?
I had some problems with windows env PATH variable, I managed to fix it.

Now we're getting this:

Code: Select all

Warning: mysqli::mysqli(): Server sent charset (255) unknown to the client. Please, report to the developers in C:\Apache24\htdocs\system\library\db\mysqli.php on line 7Warning: mysqli::mysqli(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in C:\Apache24\htdocs\system\library\db\mysqli.php on line 7Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in C:\Apache24\htdocs\system\library\db\mysqli.php on line 10Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in C:\Apache24\htdocs\system\library\db\mysqli.php on line 10Notice: Undefined variable: mysql in C:\Apache24\htdocs\install\controller\install\step_3.php on line 280Notice: Trying to get property of non-object in C:\Apache24\htdocs\install\controller\install\step_3.php on line 280

Re: [SOLVED] Having some mysql issues when installing opencard

Posted: Sun Apr 22, 2018 5:16 am
by fadey
Solved.
Had to downgrade mysql from 8.x to 5.x.