Hello,
I am trying to get Piwigo up and running in a docker container, but I can't get it to install: https://imgur.com/a/EYC4FwH
I have a mysql server up and running and used for many other things. I can connect to it using the chosen user just fine outside of the installation. I don't see anything in the logs. What could I be doing wrong?
Piwigo version: 2.10.2 (linuxserver/piwigo)
PHP version: 7
MySQL version: 8
Piwigo URL:
nginx error log:
2020/06/30 18:43:35 [error] 326#326: *1 FastCGI sent in stderr: "PHP message: PHP Warning: mysqli::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in /config/www/gallery/include/dblayer/functions_mysqli.inc.php on line 52PHP message: PHP Warning: mysqli::set_charset(): Couldn't fetch mysqli in /config/www/gallery/include/dblayer/functions_mysqli.inc.php on line 88" while reading response header from upstream, client: 192.168.1.242, server: _, request: "POST /install.php?language=en_US HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.1.204:8888", referrer: "http://192.168.1.204:8888/install.php?language=en_US"
Last edited by hobbes487 (2020-06-30 21:07:52)
Offline
Added logs.
Any help would be appreciated. I can post any other info if necessary.
Offline
Figured it out. MySql 8 changes the default auth plugin. Found the solution here: [Github] laradock issue #1390
Offline
Mentioning the actual solution not just pointing to the issue might be appreciated by whoever gets caught in the same trap I guess. In case you tried to post an #issuecomment-... fragment URL this forum here has the nasty behaviour of cutting those off..
I assume one of these methods will help:
#issuecomment-433503473
Sign into mysql using a terminal program:
mysql -u root -p
my_password
alter user 'username'@'localhost' identified with mysql_native_password by 'password';
#issuecomment-638453312 (the currently last)
You can also fix this issue using phpmyadmin:
navigate to users->
change password->
enter your new password
make sure to select "Native MYSQL authentication" on the drop down "password hashing" menu
Thanks for pointing out.
Offline