Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
mpmario opened this issue May 12, 2024 · 2 comments
Labels
help wanted Support request

Comments

@mpmario
Copy link

mpmario commented May 12, 2024

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!!

@mpmario mpmario added the help wanted Support request label May 12, 2024
@jpbaril
Copy link

jpbaril commented May 18, 2024

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
Copy link
Author

mpmario commented May 21, 2024

It works! Many thanks! :)

@mpmario mpmario closed this as completed May 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Support request
Projects
None yet
Development

No branches or pull requests

2 participants