ports/162562: [patch] databases/mysql-udf: udf shared objects installed in wrong directory

[Panagiotis Christias]

>Number:         162562
>Category:       ports
>Synopsis:       [patch] databases/mysql-udf: udf shared objects installed in wrong directory
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Nov 14 15:10:06 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator:     Panagiotis Christias
>Release:        8.2-RELEASE
>Organization:
NTUA NOC
>Environment:
FreeBSD broadbandtest.eett.gr 8.2-RELEASE FreeBSD 8.2-RELEASE #0: Thu Feb 17 02:41:51 UTC 2011     root at mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
>Description:
UDF shared objects are installed in /usr/local/lib/mysql instead of /usr/local/lib/mysql/plugin.

Tested on MySQL 5.1 and 5.5.

>How-To-Repeat:
# cd /usr/ports/databases/mysql-udf
# make install
# mysql
mysql> CREATE AGGREGATE FUNCTION median RETURNS REAL SONAME 'udf_median.so';
ERROR 1126 (HY000): Can't open shared library 'udf_median.so' (errno: 0 Cannot open "/usr/local/lib/mysql/plugin/udf_median.so")
>Fix:
See attached patch file.

Patch attached with submission follows:

--- Makefile.orig	2011-10-17 07:34:59.000000000 +0300
+++ Makefile	2011-11-14 16:58:42.000000000 +0200
@@ -23,7 +23,7 @@
 		skewness slope stdnorm_density stdnorm_dist weightedavg
 
 .for MODULE in ${MODULES}
-PLIST_FILES+=	lib/mysql/udf_${MODULE}.so
+PLIST_FILES+=	lib/mysql/plugins/udf_${MODULE}.so
 .endfor
 
 .include <bsd.port.pre.mk>
@@ -41,7 +41,7 @@
 
 do-install:
 .for MODULE in ${MODULES}
-	${INSTALL_PROGRAM} ${WRKSRC}/udf_${MODULE}.so ${PREFIX}/lib/mysql/udf_${MODULE}.so
+	${INSTALL_PROGRAM} ${WRKSRC}/udf_${MODULE}.so ${PREFIX}/lib/mysql/plugins/udf_${MODULE}.so
 .endfor
 
 post-install:


>Release-Note:
>Audit-Trail:
>Unformatted: