I have tried installing MariaDB audit plugin for MySQL 5.7.24. I have downloaded the 'server_audit.so' from MariaDB-10.3.11 and I think it is compatible with MySQL 5.7.24. But I have encountered this error while running command

INSTALL PLUGIN server_audit SONAME 'server_audit';

ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/server_audit' (errno: 2 /usr/lib/mysql/plugin/server_audit: cannot open shared object file: No such file or directory)

thanks for any help

  • Do you mean MySQL 5.7.24? – dbdemon Dec 21 '18 at 21:39
  • yes, I mean MySQL 5.7.24 – mahmoud aghvami Dec 21 '18 at 21:40
  • Is /usr/lib/mysql/plugin/ the directory where you placed the server_audit.so file? Is the file readable to the mysql user? – dbdemon Dec 21 '18 at 21:45
  • yes, it's the path where server_audit.so is. and I guaranteed 775 privilege to the file – mahmoud aghvami Dec 21 '18 at 21:49
  • I tried another plugin and I found the same error. I think you are right. MYSQL cannot see the plugin files. But I have no idea how to fix it? – mahmoud aghvami Dec 21 '18 at 21:54
INSTALL PLUGIN server_audit SONAME 'server_audit.so';

According to the documentation, the SONAME should include the extension - '.so' in this case.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.