search

standardnotes / forum

Support from other community members. For 1-on-1 help, please contact help@standardnotes.com.
https://forum.standardnotes.org
196 stars 9 forks source link

[Help Wanted] After docker-image update mysql container exiting with error and is restarting #3587

Closed mpmario closed 4 months ago

mpmario commented 5 months ago

Describe the issue A few weeks ago I installed StandardNotes via Docker as described in the manual. Everything worked fine. Then I updated the mysql image (inside the 8.x version, as described by docker compose). After starting all the containers, the mysql one is restarted every few seconds. The log of the container shows the following:

2024-05-12T20:38:42.960638Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-05-12T20:38:43.233908Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1 2024-05-12T20:38:43.249760Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-05-12T20:38:43.729480Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-05-12T20:38:44.122160Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-05-12T20:38:44.122202Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-05-12T20:38:44.124451Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-05-12T20:38:44.127128Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'. 2024-05-12T20:38:44.127514Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-05-12T20:38:45.730444Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL. 2024-05-12T20:38:45.730458Z 0 [System] [MY-015016] [Server] MySQL Server - end.

To Reproduce Steps to reproduce the behavior: Start the up to date containers like in the manual.

Expected behavior All container should run without error.

Has anyone an idea, what to do? Thanks in advance!!

jpbaril commented 4 months ago

I changed that line: command: --default-authentication-plugin=mysql_native_password --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci to: command: --mysql-native-password=ON --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci

mpmario commented 4 months ago

It works! Many thanks! :)