MySQL 8.0.33: undefined symbol: my_charset_utf8_general_ci

[tapochkin]

Greetings. I'm getting the following error trying to install libaudit_plugin.so. Any ideas what to do?

2023-07-06T08:59:59.694768Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib64/mysql/plugin/libaudit_plugin.so' (errno: 0 /usr/lib64/mysql/plugin/libaudit_plugin.so: undefined symbol: my_charset_utf8_general_ci).
2023-07-06T08:59:59.694855Z 0 [ERROR] [MY-010736] [Server] Couldn't load plugin named 'AUDIT' with soname 'libaudit_plugin.so'.

OS distribution and version:

cat /etc/os-release
NAME="AlmaLinux"
VERSION="8.8 (Sapphire Caracal)"
ID="almalinux"
ID_LIKE="rhel centos fedora"
VERSION_ID="8.8"
PLATFORM_ID="platform:el8"
PRETTY_NAME="AlmaLinux 8.8 (Sapphire Caracal)"
ANSI_COLOR="0;34"
LOGO="fedora-logo-icon"
CPE_NAME="cpe:/o:almalinux:almalinux:8::baseos"
HOME_URL="https://almalinux.org/"
DOCUMENTATION_URL="https://wiki.almalinux.org/"
BUG_REPORT_URL="https://bugs.almalinux.org/"

ALMALINUX_MANTISBT_PROJECT="AlmaLinux-8"
ALMALINUX_MANTISBT_PROJECT_VERSION="8.8"
REDHAT_SUPPORT_PRODUCT="AlmaLinux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.8"

MySQL version:

yum list installed | grep mysql
mysql-community-client.x86_64               8.0.33-1.el7                                 @mysql80-community
mysql-community-client-plugins.x86_64       8.0.33-1.el7                                 @mysql80-community
mysql-community-common.x86_64               8.0.33-1.el7                                 @mysql80-community
mysql-community-icu-data-files.x86_64       8.0.33-1.el7                                 @mysql80-community
mysql-community-libs.x86_64                 8.0.33-1.el7                                 @mysql80-community
mysql-community-server.x86_64               8.0.33-1.el7                                 @mysql80-community
mysql80-community-release.noarch            el7-7                                        @mysql80-community

Tested plugin versions (MariaDB and 5.7 versions return different errors):

audit-plugin-mariadb-10.5.4-1.1.13-1008-linux-x86_64.zip
audit-plugin-mysql-5.7-1.1.12-999-linux-x86_64.zip
audit-plugin-mysql-8.0-1.1.11-985-linux-x86_64.zip
audit-plugin-mysql-8.0-1.1.12-999-linux-x86_64.zip
audit-plugin-mysql-8.0-1.1.13-1008-linux-x86_64.zip

[sekarcinfosec]

@tapochkin You found fix for this ?

[tapochkin]

Unfortunately, no. Personally I have some time before I really need audit module to work. In case I come up with solution, I post it here.

[andrei1058]

Unfortunately, no. Personally I have some time before I really need audit module to work. In case I come up with solution, I post it here.

up

[zhangguangrui1991]

The same issue also appeared in MySQL version 8.0.34.

[kubo]

my_charset_utf8_general_ci was renamed to my_charset_utf8mb3_general_ci by mysql/mysql-server@83f688b, which affects MySQL 8.0.31 or later.
my_charset_utf8_bin referred by src/audit_handler.cc was also renamed.

[WKupper]

It is really critical that a new version get built utilizing this fix. Plugin is currently unusable for MySQL 8.0

[zhaopinglu]

I wrote a step-by-step page for this.
https://github.com/zhaopinglu/mysql-audit/blob/master/Note_for_MySQL8.0.33.md

[djkerya]

I had a kind of script for building with 8.0.36 tested on Rocky 8.9

took @zhaopinglu note as the base

https://techblog.kerya.net/74-mysql-audit-plugin-build-script