SQL statement: "UPDATE mysql.user SET Password=PASSWORD('${PASS}') WHERE User='root';" fails under MySQL 8

freenas / iocage-plugin-nextcloud

Artifact file(s) for nextcloud iocage plugin

18 stars 33 forks source link

SQL statement: "UPDATE mysql.user SET Password=PASSWORD('${PASS}') WHERE User='root';" fails under MySQL 8 #39

Open EliasGabrielsson opened 3 years ago

EliasGabrielsson commented 3 years ago

Nextcloud 21 requires MySQL 8 which have been solved in this patch: https://github.com/freenas/iocage-ix-plugins/commit/66c2a15237316c4541bf2df6926b88fae3a64776#diff-dc0257b7d5f992ca8b298c39c494585a212f9a18472c316957e41e37769332c4

However the current installation script fails when using version 8 of MySQL. The statement UPDATE mysql.user SET Password=PASSWORD('${PASS}') WHERE User='root'; fails, found here: https://github.com/freenas/iocage-plugin-nextcloud/blob/ff30b09bdf71491b102630c957abe1e8f8d35381/post_install.sh#L85

EliasGabrielsson commented 3 years ago

https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/

KSEGIT commented 3 years ago

I'm wondering can I somehow install this plugin with this fix on my nas? or do I need to wait until your commit is pushed to master?

Cooper-Dale commented 3 years ago

unable to finish instalation, I hope the reason is the same on NextCloud setup page I have: Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

xilmen commented 3 years ago

unable to finish instalation, I hope the reason is the same on NextCloud setup page I have: Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Hi, you can follow https://help.nextcloud.com/t/nextcloud-error-on-truenas/115791/7 :) (works for me :))