MySQL Bugs: #17230: Can't change character-sets-dir for ndbd

Bug #17230	Can't change character-sets-dir for ndbd
Submitted:	8 Feb 2006 10:51	Modified:	23 Apr 2006 2:33
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.0	OS:	Any (*)
Assigned to:	Tomas Ulin	CPU Architecture:	Any

Description:
With mysqld i can change the searchpath for font description files
using either the --basedir or --character-sets-dir options,
ndbd doesn't seem to support this though, it always searches the
default path (/usr/local/mysql/share/mysql/charsets for our tar.gz
packages) only. 

So it is not possible to install mysql in a different path than
/usr/local/mysql if character sets that are not compiled in 
need to be used

How to repeat:
Install one of our binary packages in a non-standard path,
(in this case mysql-max-5.0.18-solaris8-sparc installed in $HOME/hartmut/mysql)
run mysqld with --basedir set to the install directory, 
try to create a cluster table using a non-standard character set

  > CREATE TABLE test_ascii (i int primary key, c char(10)) charset ascii engine=ndb;

  ERROR 1005 (HY000): Can't create table './test/test_ascii.frm' (errno: 743)

  > perror --ndb 743

  OS error code 743:  Unsupported character set in table or index: Permanent error: Schema error

Suggested fix:
add --character-sets-dir as commandline or config file option for ndbd
(probably both)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2903

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5285

pushed to 5.1.10
and 5.0.21

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented as feature change in 5.0.21 and 5.1.10 changelogs, and as (previously undocumented) limitation in earlier versions (including 4.1). Closed.