ports/135670: [PATCH] databases/mysql50-server: in mysql-client mysqldump isn't working with option --default-character-set

[Alexander Kriventsov]

>Number:         135670
>Category:       ports
>Synopsis:       [PATCH] databases/mysql50-server: in mysql-client mysqldump isn't working with option --default-character-set
>Confidential:   no
>Severity:       serious
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Wed Jun 17 14:40:03 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Alexander Kriventsov
>Release:        FreeBSD 7.2
>Organization:
.masterhost
>Environment:
FreeBSD bex71.masterhost.ru 7.2-i386-20090504-RELENG_7_2 FreeBSD 7.2-i386-20090504-RELENG_7_2 #0: Thu May  7 15:14:18 UTC 2009     root at svc12.masterhost.ru:/usr/obj/usr/src/sys/SERVER7  i386

>Description:
add files with charsets and langs.
This files are need to work with mysqldump.
for example
mysqldump --default-character-set=cp1251
mysqldump: Character set 'cp1251' is not a compiled character set and is not specified in the '/usr/local/share/mysql/charsets/Index.xml' file

$ pkg_info -W `which mysqldump`
/usr/local/bin/mysqldump was installed by package mysql-client-5.0.77_1

At this time file '/usr/local/share/mysql/charsets/Index.xml' doesn't install with this port? and install only in mysql-server.
>How-To-Repeat:

>Fix:


Patch attached with submission follows:

diff -urN mysql50-server/Makefile mysql50-server/Makefile
--- mysql50-server/Makefile	2009-06-08 10:03:20.000000000 +0400
+++ mysql50-server/Makefile	2009-06-17 18:06:39.000000000 +0400
@@ -199,7 +199,7 @@
 CONFIGURE_ARGS+=--without-server
 
 post-patch:
-	@${REINPLACE_CMD} -e "s|SUBDIRS =|SUBDIRS = include scripts strings mysys dbug extra regex libmysql_r libmysql client @man_dirs@|g" ${WRKSRC}/Makefile.in
+	@${REINPLACE_CMD} -e "s|SUBDIRS =|SUBDIRS = include scripts strings sql/share mysys dbug extra regex libmysql_r libmysql client @man_dirs@|g" ${WRKSRC}/Makefile.in
 	@${REINPLACE_CMD} -e "s|install-exec-am: install-pkglibLIBRARIES|install-exec-am:|g" ${WRKSRC}/strings/Makefile.in ${WRKSRC}/mysys/Makefile.in ${WRKSRC}/dbug/Makefile.in
 	@${REINPLACE_CMD} -e "s|all: config.h|all: config.h all-local|g" ${WRKSRC}/Makefile.in
 	@${REINPLACE_CMD} -e "s|bin_SCRIPTS =|bin_SCRIPTS = mysql_config mysql_fix_privilege_tables mysqlbug|g" ${WRKSRC}/scripts/Makefile.in
diff -urN mysql50-server/pkg-plist.client mysql50-server/pkg-plist.client
--- mysql50-server/pkg-plist.client	2009-06-17 18:05:12.000000000 +0400
+++ mysql50-server/pkg-plist.client	2009-06-17 18:12:59.000000000 +0400
@@ -52,7 +52,81 @@
 lib/mysql/libmysqlclient_r.la
 lib/mysql/libmysqlclient_r.so
 lib/mysql/libmysqlclient_r.so.15
+%%DATADIR%%/charsets/Index.xml
+%%DATADIR%%/charsets/README
+%%DATADIR%%/charsets/armscii8.xml
+%%DATADIR%%/charsets/ascii.xml
+%%DATADIR%%/charsets/cp1250.xml
+%%DATADIR%%/charsets/cp1251.xml
+%%DATADIR%%/charsets/cp1256.xml
+%%DATADIR%%/charsets/cp1257.xml
+%%DATADIR%%/charsets/cp850.xml
+%%DATADIR%%/charsets/cp852.xml
+%%DATADIR%%/charsets/cp866.xml
+%%DATADIR%%/charsets/dec8.xml
+%%DATADIR%%/charsets/geostd8.xml
+%%DATADIR%%/charsets/greek.xml
+%%DATADIR%%/charsets/hebrew.xml
+%%DATADIR%%/charsets/hp8.xml
+%%DATADIR%%/charsets/keybcs2.xml
+%%DATADIR%%/charsets/koi8r.xml
+%%DATADIR%%/charsets/koi8u.xml
+%%DATADIR%%/charsets/latin1.xml
+%%DATADIR%%/charsets/latin2.xml
+%%DATADIR%%/charsets/latin5.xml
+%%DATADIR%%/charsets/latin7.xml
+%%DATADIR%%/charsets/macce.xml
+%%DATADIR%%/charsets/macroman.xml
+%%DATADIR%%/charsets/swe7.xml
+%%DATADIR%%/czech/errmsg.sys
+%%DATADIR%%/danish/errmsg.sys
+%%DATADIR%%/dutch/errmsg.sys
+%%DATADIR%%/english/errmsg.sys
+%%DATADIR%%/errmsg.txt
+%%DATADIR%%/estonian/errmsg.sys
+%%DATADIR%%/french/errmsg.sys
+%%DATADIR%%/german/errmsg.sys
+%%DATADIR%%/greek/errmsg.sys
+%%DATADIR%%/hungarian/errmsg.sys
+%%DATADIR%%/italian/errmsg.sys
+%%DATADIR%%/japanese/errmsg.sys
+%%DATADIR%%/korean/errmsg.sys
+%%DATADIR%%/norwegian-ny/errmsg.sys
+%%DATADIR%%/norwegian/errmsg.sys
+%%DATADIR%%/polish/errmsg.sys
+%%DATADIR%%/portuguese/errmsg.sys
+%%DATADIR%%/romanian/errmsg.sys
+%%DATADIR%%/russian/errmsg.sys
+%%DATADIR%%/serbian/errmsg.sys
+%%DATADIR%%/slovak/errmsg.sys
+%%DATADIR%%/spanish/errmsg.sys
+%%DATADIR%%/swedish/errmsg.sys
+%%DATADIR%%/ukrainian/errmsg.sys
 %%DATADIR%%/mysql_fix_privilege_tables.sql
 @dirrm include/mysql
 @dirrm lib/mysql
+ at dirrm %%DATADIR%%/charsets
+ at dirrm %%DATADIR%%/czech
+ at dirrm %%DATADIR%%/danish
+ at dirrm %%DATADIR%%/dutch
+ at dirrm %%DATADIR%%/english
+ at dirrm %%DATADIR%%/estonian
+ at dirrm %%DATADIR%%/french
+ at dirrm %%DATADIR%%/german
+ at dirrm %%DATADIR%%/greek
+ at dirrm %%DATADIR%%/hungarian
+ at dirrm %%DATADIR%%/italian
+ at dirrm %%DATADIR%%/japanese
+ at dirrm %%DATADIR%%/korean
+ at dirrm %%DATADIR%%/norwegian
+ at dirrm %%DATADIR%%/norwegian-ny
+ at dirrm %%DATADIR%%/polish
+ at dirrm %%DATADIR%%/portuguese
+ at dirrm %%DATADIR%%/romanian
+ at dirrm %%DATADIR%%/russian
+ at dirrm %%DATADIR%%/serbian
+ at dirrm %%DATADIR%%/slovak
+ at dirrm %%DATADIR%%/spanish
+ at dirrm %%DATADIR%%/swedish
+ at dirrm %%DATADIR%%/ukrainian
 @dirrm %%DATADIR%%


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