standardnotes / server

Server ecosystem for Standard Notes; fully self-hostable.
https://standardnotes.com/help/self-hosting/docker
GNU General Public License v3.0
267 stars 62 forks source link

DB container not starting with current docker-compose.example.yml file #1055

Open jelkose opened 6 months ago

jelkose commented 6 months ago

After updating my local environment, the db-container did not start anymore. The following error is displayed: [Server] unknown variable 'default-authentication-plugin=mysql_native_password'. The update pulled the newest version of mysql:8 (which stands in docker-compose.example.yml) from docker, which currently is 8.4. In this version the native password plugin was removed (see https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html).

A workaround is to replace the --default-authentication-plugin=mysql_native_password flag in https://github.com/standardnotes/server/blob/dbb0e4a9746c022126e719ddbcd31cec9fca12aa/docker-compose.example.yml#L42 by --mysql-native-password=ON which enables the native password plugin again (see https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html). But as this plugin is deprecated and will be removed completely in future releases, I think using a more up-to-date authentication plugin would be better.

Cheers, Jelko

tuxnet commented 6 months ago

I have already created a pull request #1054 which solves the problem until another plugin is implemented