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
    Commented Dec 21, 2018 at 21:39
  • yes, I mean MySQL 5.7.24 Commented Dec 21, 2018 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
    Commented Dec 21, 2018 at 21:45
  • yes, it's the path where server_audit.so is. and I guaranteed 775 privilege to the file Commented Dec 21, 2018 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? Commented Dec 21, 2018 at 21:54

1 Answer 1

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 and acknowledge you have read our privacy policy.

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