3454 2004-01-09 23:42:55 +0300 Initscript fails to find proper charset 2005-08-29 14:49:40 +0400 1 1 4 Development Sisyphus MySQL-server unstable all Linux CLOSED FIXED P2 major --- 1 dav mouse ldv mike nickel rider shaba svgol qa-sisyphus oldest_to_newest 11125 0 dav 2004-01-09 23:42:55 +0300 LC_COLLATE value showed by the locale command is not necessarily quoted. And if it's not mysqld initscript always sets charset to latin1. $ rpm -q MySQL-server MySQL-server-4.0.17-alt1 11126 1 327 dav 2004-01-09 23:44:33 +0300 Created attachment 327 initscript-charset.patch 11134 2 mouse 2004-01-10 16:54:51 +0300 if you setup locale from /etc/sysconfig/i18n or by LC_ALL var, LC_COLLATE var would be always quoted. But if you run LC_COLLATE=ru_RU.KOI8-R service mysqld start, charset detection would failed - it's incorrect. How do you run mysqld? How to reproduce this bug? Latin1 sets up always in follow cases: if didn't set CHSET var in mysqld initscript or autodetection didn't find proper charset. 11135 3 dav 2004-01-10 20:57:14 +0300 $ service mysqld start Adjusting environment for mysqld: [ DONE ] Unable to find proper charset from system locale, setting 'latin1'. Please edit mysqld init script and set proper charset. Starting safe_mysqld service: [ DONE ] $ cat /etc/sysconfig/i18n SYSFONT=UniCyr_8x16 LC_CTYPE=ru_RU.KOI8-R LC_MONETARY=ru_RU.KOI8-R LANGUAGE=ru_RU.KOI8-R LC_TIME=ru_RU.KOI8-R LC_NUMERIC=ru_RU.KOI8-R LC_COLLATE=ru_RU.KOI8-R LC_MESSAGES=ru_RU.KOI8-R LANG=ru_RU.KOI8-R SYSFONTACM=koi8-r $ locale LANG=ru_RU.KOI8-R LC_CTYPE=ru_RU.KOI8-R LC_NUMERIC=ru_RU.KOI8-R LC_TIME=ru_RU.KOI8-R LC_COLLATE=ru_RU.KOI8-R LC_MONETARY=ru_RU.KOI8-R LC_MESSAGES=ru_RU.KOI8-R LC_PAPER="ru_RU.KOI8-R" LC_NAME="ru_RU.KOI8-R" LC_ADDRESS="ru_RU.KOI8-R" LC_TELEPHONE="ru_RU.KOI8-R" LC_MEASUREMENT="ru_RU.KOI8-R" LC_IDENTIFICATION="ru_RU.KOI8-R" LC_ALL= 11187 4 mouse 2004-01-12 16:18:31 +0300 It won't to reproduce. I'll apply this patch as workaround. Wait for alt2. And what is your system name/version? 11198 5 dav 2004-01-13 09:18:44 +0300 Originally it was Master 2.0 long ago. Now it's partly old Sisyphus, partly current Sisyphus. $ rpm -q glibc-locales sh glibc-locales-2.2.6-alt0.11 sh-2.05b-alt6 11199 6 dav 2004-01-13 09:34:28 +0300 BTW, look what I've found: $ locale | fgrep LC_COLLATE LC_COLLATE=ru_RU.KOI8-R $ unset LC_COLLATE $ . /etc/sysconfig/i18n $ locale | fgrep LC_COLLATE LC_COLLATE="ru_RU.KOI8-R" Weird, isn't it? 11831 7 ldv 2004-02-17 19:06:10 +0300 Proposed change from Alexey Morozov default_charset="$(. /etc/sysconfig/i18n && locale | sed -ne 's/^LC_COLLATE="\?[^".]\+\.\([^"]\+\)"\?$/\1/p')" 11833 8 ldv 2004-02-17 19:08:47 +0300 *** Bug 3709 has been marked as a duplicate of this bug. *** 11840 9 mouse 2004-02-18 17:00:06 +0300 fixed in 4.0.18-alt1 327 2004-01-09 23:44:33 +0300 2004-01-09 23:44:33 +0300 initscript-charset.patch MySQL-server-4.0.17-alt1-init-charset.patch text/plain 474 dav LS0tIG15c3FsZH4JMjAwMy0xMS0yOCAxOToyNDowOSArMDMwMAorKysgbXlzcWxkCTIwMDQtMDEt MDkgMjM6MzI6NDQgKzAzMDAKQEAgLTMwLDcgKzMwLDcgQEAKIAkJWyAtZiAiL3Vzci9zaGFyZS9t eXNxbC9jaGFyc2V0cy8kQ0hTRVQuY29uZiIgXSAmJiByZXR1cm4KIAkJZWNobyAiVW5hYmxlIHRv IGZpbmQgY2hhcnNldDogJENIU0VUIgogCWZpCi0JZGVmYXVsdF9jaGFyc2V0PSIkKC4gL2V0Yy9z eXNjb25maWcvaTE4biAmJiBsb2NhbGUgfHNlZCAtbmUgJ3MvXkxDX0NPTExBVEU9IlteIi5dXCtc LlwoW14iXVwrXCkiJC9cMS9wJykiCisJZGVmYXVsdF9jaGFyc2V0PSIkKC4gL2V0Yy9zeXNjb25m aWcvaTE4biAmJiBsb2NhbGUgfHNlZCAtbmUgJ3MvXkxDX0NPTExBVEU9IipbXiIuXVwrXC5cKFte Il1cK1wpIiokL1wxL3AnKSIKIAljYXNlICIkZGVmYXVsdF9jaGFyc2V0IiBpbgogCQlDUDEyNTEp CiAJCQlDSFNFVD1jcDEyNTEK