CLI variant fails connecting to MySql server via caching_sha2_password
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 55/100
Research direction
Inspect Dockerfile.template around the suggested location and compare it with the reported Dockerfile workaround. Add the mariadb-connector-c package to the wordpress:cli image, then build the CLI variant and verify it connects to MySQL 8 using caching_sha2_password without the missing-plugin error.
Written by the indexing model from the issue text.
Description
I'm using a docker-compose setup consisting of a mysql:8.0, a wordpress:6 and a wordpress:cli container. Wordpress itself works fine, but the CLI failed to connect to the server saying:
Failed to get current SQL modes. Reason: ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory
I dug deeper and found out that the underlying php:8.x-alpine image doesn't seem to include the necessary libraries per default, but they can be added by installing the mariadb-connector-c package (see: https://github.com/arey/mysql-client/issues/5)
I can confirm; it now works, using the following hacky Dockerfile for the cli:
FROM wordpress:cli
USER root
RUN apk add --no-cache mariadb-connector-c
USER www-data
I'd suggest that the package be included in the wordpress:cli variant. Supposedly it could be added in https://github.com/docker-library/wordpress/blob/master/Dockerfile.template after line 17 – I don't feel competent enough for a PR…
- Dominant language
- Shell
- Stars
- 2k
- Forks
- 1.1k
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from docker-library/wordpress
-
Difficulty 5/5 Over a week Newbie friendliness 25/100
docker-library/wordpress#959 · 1 comment · 2 reactions ·
-
New php-latest tag Open
Difficulty 3/5 1-2 days Newbie friendliness 45/100
docker-library/wordpress#930 · 6 comments · 4 reactions ·
-
Difficulty 3/5 1-2 days Newbie friendliness 45/100
docker-library/wordpress#927 · 3 comments · 1 reaction ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
docker-library/wordpress#835 · 2 comments · 2 reactions ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
docker-library/wordpress#792 · 2 comments · 1 reaction ·
All issues in docker-library/wordpress
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug easy help wanted
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
lacs-project/sysknife#503 ·
-
help wanted kind/documentation
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
liquidmetal-dev/flintlock#1239 ·