ERROR 1123 (HY000): Can't initialize function 'AUDIT'; Plugin initialization function failed. (env mysql 8.0.29 & rocky8.6 )

[nAnderYang]

mysql version:Server version: 8.0.29 MySQL Community Serve

SELinux

# getenforce
Disabled

MySQL installd rpm

# rpm -qa|grep mysql
mysql-community-client-8.0.29-1.el8.x86_64
mysql-community-common-8.0.29-1.el8.x86_64
mysql-community-client-plugins-8.0.29-1.el8.x86_64
mysql-community-icu-data-files-8.0.29-1.el8.x86_64
mysql-community-libs-8.0.29-1.el8.x86_64
mysql-community-server-8.0.29-1.el8.x86_64
mysql-community-devel-8.0.29-1.el8.x86_64

plugin version: audit-plugin-mysql-8.0-1.1.13-1008-linux-x86_64.zip

install plugin FAIL

log-error

# cat mysql.err
2023-05-22T08:11:41.360253Z 35 [Warning] [MY-000080] [Server] option 'audit-json-file-bufsize': signed value 0 adjusted to 1.
2023-05-22T08:11:41.360358Z 35 [Warning] [MY-000080] [Server] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1.
2023-05-22T08:11:41.360852Z 35 [ERROR] [MY-000000] [Server] Trellix Audit Plugin: unable to init compatibility layer. Aborting.
2023-05-22T08:11:41.360905Z 35 [ERROR] [MY-010202] [Server] Plugin 'AUDIT' init function returned error.
2023-05-22T08:11:41.360940Z 35 [ERROR] [MY-010734] [Server] Plugin 'AUDIT' registration as a AUDIT failed.

Get offset FAIL

# bash offset-extract.sh `which mysqld`
GDB failed!!!

how do i fix it?

[Xuejicha0]

same error mysql8.0.29 on redhat 7.9 ,looking forward for sulation