121129 – Incorrect `character-sets-dir' in default my.cnf

Bug 121129 - Incorrect `character-sets-dir' in default my.cnf

Summary: Incorrect `character-sets-dir' in default my.cnf

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	High minor
Assignee:	Gentoo Linux MySQL bugs team

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2006-01-31 21:42 UTC by Leonid Kabanov
Modified:	2006-05-05 12:53 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Leonid Kabanov 2006-01-31 21:42:08 UTC

I have some problems using diffrent charsets in mysql-4.1.14. After some research I found that my `character-sets-dir' in /etc/mysql/my.cnf is incorrect - value should be `/usr/share/mysql/charsets' but it's `utf8' (or to `latin1' if `utf8' USE flag isn't set). More info here - http://dev.mysql.com/doc/refman/4.1/en/problems-with-character-sets.html

Comment 1 Oleg Stopolenko 2006-04-22 03:17:20 UTC

The reported issue applies to mysql-4.1.18-r60 too. There is an incorrect value of 'character-sets-dir', thus changing 'default-character-set' to anything except built-in 'latin1' and 'utf8' values makes mysql client to produce this warning and exit:

mysql: Character set 'koi8r' is not a compiled character set and is not specified in the 'utf8/Index.xml' file

Removing 'character-sets-dir' definition from my.cnf solves this.

Good people, fix the default my.cnf file please.

Comment 2 Luca Longinotti (RETIRED) gentoo-dev

2006-05-05 12:53:24 UTC

The my.cnf's were fixed, they now have the correct path in them.
Best regards, CHTEKK.