Public bug reported: The lack of this shared library means MySQL/MariaDB client connectors connecting to a MySQL-8.0 server (which defaults to caching_sha2_password being the default authentication for users, will get a connection rejected message.
This leads to extremely popular work around answers like https://stackoverflow.com/questions/54099722/how-to-connect-r-to-mysql- failed-to-connect-to-database-error-plugin-caching/54101124#54101124 which is very good for popularity scores, but not users. It was reported in Debian https://bugs.debian.org/cgi- bin/bugreport.cgi?bug=962597 ( for perl connectors) but wasn't fixed for buster. As Ubuntu is also linking against gnutls the sha256_password.so probably isn't possible. Something to do with missing OEPC(?) missing from gnutls. This has limited use so its a significant problem if this can't be added. MariaDB is fixing this in their upstream packages (https://jira.mariadb.org/browse/MDEV-24728) from 10.2+ on all debian and ubuntu versions https://github.com/MariaDB/server/commit/57531b32774ffafcd2b8da763c4da859380e3f7d ). This applies to focal only. As this is the distribution that includes MySQL-8.0 this is important for local database connections. groovy includes caching_sha2_password but not sha256_password https://packages.ubuntu.com/groovy/amd64/libmariadb3/filelist bionic is based on connector/c version is 3.0.3 however it wasn't added upstream until 3.0.8 (https://jira.mariadb.org/browse/CONC-312). fix: add to debian/libmariadb3.install /usr/lib/*/mariadb19/plugin/caching_sha2_password.so ** Affects: mariadb-10.3 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1913676 Title: libmariadb3 fails to include caching_sha2_password.so To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.3/+bug/1913676/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs