Missing caching_sha2_password plugin

[AntoineDewaele]

trafficstars

Hey ! I use this project since 2 years and this is very helpful. I recently upgrade my database to mysql 8 with caching_sha2_password Authentication Plugin to improve security.

And now i have error on backup :

Database backup FAILED for api_hobbies at 26-11-2022 10:54:46. Error: mysqldump: Got error: 1045: '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' when trying to connect

Is there any plan to support caching_sha2_password authentication plugin ?

Thanks a lot ! :pray:

[AntoineDewaele]

I think you can just add this package to the dockerfile : https://pkgs.alpinelinux.org/contents?branch=edge&name=mariadb-connector-c&arch=x86&repo=main

[benjamin-maynard]

Hi @AntoineDewaele,

Thanks for raising this. I am in the middle of working on a pretty big new version of this utility, and will make sure this issue is addressed in the new release.

Thanks!

[hamdallah90]

any update on this? i have the same issue

[AntoineDewaele]

Hey @hamdallah90, i solved this issue by forking this project, adding the missing lib and build my own docker image