Bug #72847 Audit_log does fails with Oracle's MySQL build
Submitted: 3 Jun 2014 11:31 Modified: 3 Jun 2014 11:47
Reporter: Muhammad Irfan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Linux
Assigned to: CPU Architecture:Any

[3 Jun 2014 11:31] Muhammad Irfan
Description:
MySQL 5.5.37:
===================

mysql> show global variables like '%version%';
+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| innodb_version          | 5.5.37           |
| protocol_version        | 10               |
| slave_type_conversions  |                  |
| version                 | 5.5.37-0+wheezy1 |
| version_comment         | (Debian)         |
| version_compile_machine | x86_64           |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+
7 rows in set (0.00 sec)

mysql> INSTALL PLUGIN audit_log SONAME 'audit_log.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/audit_log.so' (errno: 2 /usr/lib/mysql/plugin/audit_log.so: cannot open shared object file: No such file or directory)

Same appears to with MySQL 5.5.38:

mysql> show global variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.5.38                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.38                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | debian6.0                    |
+-------------------------+------------------------------+

mysql> INSTALL PLUGIN audit_log SONAME 'audit_log.so';
ERROR 1126 (HY000): Can't open shared library '/opt/mysql/server-5.5/lib/plugin/audit_log.so' (errno: 13 /opt/mysql/server-5.5/lib/plugin/audit_log.so: cannot open shared object file: No such file or directory)

# ls -la /opt/mysql/server-5.5/lib/plugin/audit_log.so
ls: cannot access /opt/mysql/server-5.5/lib/plugin/audit_log.so: No such file or directory

How to repeat:
mysql> show global variables like '%version%';
+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| innodb_version          | 5.5.37           |
| protocol_version        | 10               |
| slave_type_conversions  |                  |
| version                 | 5.5.37-0+wheezy1 |
| version_comment         | (Debian)         |
| version_compile_machine | x86_64           |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+
7 rows in set (0.00 sec)

mysql> INSTALL PLUGIN audit_log SONAME 'audit_log.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/audit_log.so' (errno: 2 /usr/lib/mysql/plugin/audit_log.so: cannot open shared object file: No such file or directory)
[3 Jun 2014 11:47] Muhammad Irfan
Not a bug