trellix-enterprise / mysql-audit

AUDIT Plugin for MySQL. See wiki and readme for description. If you find the plugin useful, please star us on GitHub. We love stars and it's a great way to show your feedback.
Other
239 stars 57 forks source link

McAfee audit plugin cannot be installed on MySQL Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - GPL) #237

Open pooh06 opened 3 years ago

pooh06 commented 3 years ago

Installation failed:

mysql> install plugin audit soname 'libaudit_plugin.so'; ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/libaudit_plugin.so' (errno: 2 /usr/lib/mysql/plugin/libaudit_plugin.so: undefined symbol: command_name)

GDB failed:

/opt/audit-plugin-mysql-8.0-1.1.9-974/utils/offset-extract.sh /usr/sbin/mysqld GDB failed!!!

Manual population for the offsets failed:

vi my.cnf plugin-load=AUDIT=libaudit_plugin.so audit_offsets=8544, 8584, 4064, 5536, 520, 0, 0, 32, 64, 160, 608, 8700, 5168, 4208, 4216, 4220, 6840, 1656, 32, 7800, 7840, 7824, 11624, 140, 664, 320

MySQL will not start

8.0.27 MySQL Community Server - GPL Chassis: vm Virtualization: kvm Operating System: Ubuntu 20.04.3 LTS Kernel: Linux 5.11.0-1021-gcp Architecture: x86-64

caiChoi commented 2 years ago

I have a similar problem. mysql> install plugin AUDIT soname 'libaudit_plugin.so'; ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/libaudit_plugin.so' (errno: 2 /usr/lib64/mysql/plugin/libaudit_plugin.so: undefined symbol: command_name)