search

haiwen / seafile

High performance file syncing and sharing, with also Markdown WYSIWYG editing, Wiki, file label and other knowledge management features.
http://seafile.com/
Other
12.36k stars 1.55k forks source link

mysql8.0 Not compatible, Cannot create user #2371

Open forsaken628 opened 4 years ago

forsaken628 commented 4 years ago 
../common/seaf-db.c(589): Failed to connect to MySQL: Plugin caching_sha2_password could not be loaded: lib/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

may fix with

CREATE USER 'seafile'@'%.%.%.%' IDENTIFIED WITH mysql_native_password BY '111';

profy12 commented 4 years ago

I confirm the bug with default installation of mysql-server-8.0 on Ubuntu 20.04.

fixed with alter statement manually like that :

ALTER USER 'seafile'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'XXXXXXXXXXXXX';
dafdafdafdaf commented 3 years ago

Still not fixed it seems.

ldwnt commented 3 years ago

I confirm the bug with default installation of mysql-server-8.0 on Ubuntu 20.04.

fixed with alter statement manually like that :

ALTER USER 'seafile'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'XXXXXXXXXXXXX';

It works for creating the admin account of seahub. However, next seahub fails to start up and I find this in logs/seafile.log:

[02/11/2021 09:19:55 AM] ../common/seaf-db.c(709): Failed to connect to MySQL: Plugin caching_sha2_password could not be loaded: lib/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

So seafile tries to use mysql_native_password first and then caching_sha2_password? quite funny