[libmariadb] Missing caching_sha2_password.so for Linux/MacOs build

[ludekvodicka]

---

There are missing dynamic files for libMariaDB in the case of build on Linux and MacOS.

MariaDB connector needs for example caching_sha2_password when connecting to MySQL 8.0. Without this file, MariaDB library returns error "Plugin caching_sha2_password could not be loaded: dlopen(PATH/caching_sha2_password.so.2) image not found

• Windows: This file (together with others) is correctly built and installed for windows to "plugin" directory.
• Linux: some of these files are built but not installed. Files can be found at `vcpkg/buildtrees/libmariadb/x64-linux-dbg/caching_sha2_password.so
• MacOS: these files are completely missing and not build

I'm installing it via vcpkg install libmariadb

[JackBoosY]

buildtrees/libmariadb/x64-osx-dbg/mysql_clear_password.so
buildtrees/libmariadb/x64-osx-dbg/caching_sha2_password.so
buildtrees/libmariadb/x64-osx-dbg/dialog.so
buildtrees/libmariadb/x64-osx-dbg/client_ed25519.so
buildtrees/libmariadb/x64-osx-dbg/sha256_password.so

The issues is not install them.
They are installed, but were removed when building static.
Wrong fix in #7396.

[JackBoosY]

@ludekvodicka Can you please provide me the reproduce steps? I think we also need to patch the load plugin path.

Thanks.

[JackBoosY]

@ludekvodicka Ping for response.

[ludekvodicka]

I believe it's already fixed. I already worked on this with someone else.

[JackBoosY]

Okay, please reopen this PR when it happened again.