Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#31437 - [mysql] Plugin installation fails

Attached to Project: Arch Linux
Opened by Daniel S: Reichenbach (marenkay) - Thursday, 06 September 2012, 09:59 GMT
Last edited by Andrea Scarpino (BaSh) - Thursday, 06 September 2012, 20:54 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Andrea Scarpino (BaSh)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description: When installing MySQL plugins using the values from mysql_config provides for includes, libs, and plugin-directory, MySQL will use the wrong path upon loading a plugin.


Additional info:
* mysql_config reports a plugindir of mysql_config --plugindir
* when adding a function in a plugin using e.g. "CREATE FUNCTION lib_mysql_myplugin_dostuff RETURNS string SONAME 'lib_mysql_myplugin.so';" MySQL replies with ERROR 1126 (HY000) at line 4: Can't open shared library 'lib_mysql_myplugin.so' (errno: 0 /usr/usr/lib/mysql/plugin/lib_mysql_myplugin.so: cannot open shared object file: No such file or directory)

As seen above, MySQL reports a plugindir of /usr/lib/mysql/plugin/, but uses /usr/usr/lib/mysql/plugin/.
This task depends upon

Closed by  Andrea Scarpino (BaSh)
Thursday, 06 September 2012, 20:54 GMT
Reason for closing:  Fixed
Additional comments about closing:  mysql 5.5.27-4
Comment by Daniel S: Reichenbach (marenkay) - Thursday, 06 September 2012, 10:04 GMT
Just noticed a plugin_dir directive also is missing from the default my.cnf file.

Adding the plugin_dir directive in the [mysqld] section fixes the issue. Not sure though if this is the proper way. Perhaps making MySQL compile with the proper plugin directory would be better.

Loading...