| 1 |
Hi, I have a problem with mysql 5.0.71-r1 and utf8 charset. I have a |
| 2 |
lighttpd v1.4.20 web server using php v5.2.9-r2 that provides several |
| 3 |
websites. |
| 4 |
|
| 5 |
I set up the DB server default charset to utf-8 into file /etc/my.cnf |
| 6 |
|
| 7 |
[mysqld] |
| 8 |
character-set-server = utf8 |
| 9 |
default-character-set = utf8 |
| 10 |
|
| 11 |
|
| 12 |
since I want a utf8 box: |
| 13 |
|
| 14 |
~$ locale |
| 15 |
LANG=fr_FR.UTF-8 |
| 16 |
LC_CTYPE="fr_FR.UTF-8" |
| 17 |
LC_NUMERIC="fr_FR.UTF-8" |
| 18 |
LC_TIME="fr_FR.UTF-8" |
| 19 |
LC_COLLATE="fr_FR.UTF-8" |
| 20 |
LC_MONETARY="fr_FR.UTF-8" |
| 21 |
LC_MESSAGES="fr_FR.UTF-8" |
| 22 |
LC_PAPER="fr_FR.UTF-8" |
| 23 |
LC_NAME="fr_FR.UTF-8" |
| 24 |
LC_ADDRESS="fr_FR.UTF-8" |
| 25 |
LC_TELEPHONE="fr_FR.UTF-8" |
| 26 |
LC_MEASUREMENT="fr_FR.UTF-8" |
| 27 |
LC_IDENTIFICATION="fr_FR.UTF-8" |
| 28 |
LC_ALL= |
| 29 |
|
| 30 |
|
| 31 |
but I changed the previous en_GB language to fr_FR.UTF-8 a few days |
| 32 |
ago, and now my web sites can't connect to the DBs and I face the |
| 33 |
following error: |
| 34 |
|
| 35 |
Can't initialize character set utf-8 (path: /usr/share/mysql/charsets/) |
| 36 |
|
| 37 |
I have 'unicode' in my USE flags, try to emerge -uDN my whole world |
| 38 |
but I cannot get any /usr/share/mysql/charsets/utf-8.xml file ! |
| 39 |
|
| 40 |
What can I do ? Any support is welcome.. |
| 41 |
|
| 42 |
Hereafter my box settings: |
| 43 |
|
| 44 |
~ # emerge --info |
| 45 |
Portage 2.1.6.11 (default/linux/x86/2008.0, gcc-4.1.2, |
| 46 |
glibc-2.8_p20080602-r1, 2.6.24.5-grsec-xxxx-grs-ipv4-32 i686) |
| 47 |
================================================================= |
| 48 |
System uname: Linux-2.6.24.5-grsec-xxxx-grs-ipv4-32-i686-Intel-R-_Pentium-R-_Dual_CPU_E2180_@_2.00GHz-with-glibc2.0 |
| 49 |
Timestamp of tree: Wed, 29 Apr 2009 05:00:01 +0000 |
| 50 |
distcc 3.0 i686-pc-linux-gnu [disabled] |
| 51 |
app-shells/bash: 3.2_p39 |
| 52 |
dev-lang/python: 2.4.4-r6, 2.5.4-r2 |
| 53 |
dev-python/pycrypto: 2.0.1-r6 |
| 54 |
sys-apps/baselayout: 1.12.11.1 |
| 55 |
sys-apps/sandbox: 1.6-r2 |
| 56 |
sys-devel/autoconf: 2.63 |
| 57 |
sys-devel/automake: 1.10.2 |
| 58 |
sys-devel/binutils: 2.18-r3 |
| 59 |
sys-devel/gcc-config: 1.4.0-r4 |
| 60 |
sys-devel/libtool: 1.5.26 |
| 61 |
virtual/os-headers: 2.6.27-r2 |
| 62 |
ACCEPT_KEYWORDS="x86" |
| 63 |
CBUILD="i686-pc-linux-gnu" |
| 64 |
CFLAGS="-O2 -march=i686 -pipe" |
| 65 |
CHOST="i686-pc-linux-gnu" |
| 66 |
CONFIG_PROTECT="/etc /var/bind" |
| 67 |
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/gconf |
| 68 |
/etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ |
| 69 |
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d |
| 70 |
/etc/terminfo /etc/udev/rules.d" |
| 71 |
CXXFLAGS="-O2 -march=i686 -pipe" |
| 72 |
DISTDIR="/usr/portage/distfiles" |
| 73 |
FEATURES="distlocks fixpackages parallel-fetch protect-owned sfperms |
| 74 |
strict unmerge-orphans userfetch" |
| 75 |
GENTOO_MIRRORS="http://mirror.ovh.net/gentoo-distfiles/ |
| 76 |
ftp://mirror.ovh.net/gentoo-distfiles/" |
| 77 |
LANG="fr_FR.utf8@euro" |
| 78 |
LDFLAGS="-Wl,-O1" |
| 79 |
LINGUAS="fr en" |
| 80 |
MAKEOPTS="-j3" |
| 81 |
PKGDIR="/usr/portage/packages" |
| 82 |
PORTAGE_CONFIGROOT="/" |
| 83 |
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times |
| 84 |
--compress --force --whole-file --delete --stats --timeout=180 |
| 85 |
--exclude=/distfiles --exclude=/local --exclude=/packages" |
| 86 |
PORTAGE_TMPDIR="/var/tmp" |
| 87 |
PORTDIR="/usr/portage" |
| 88 |
PORTDIR_OVERLAY="/usr/portage/local/layman/ovh-overlay" |
| 89 |
SYNC="rsync://rsync.gentoo.org/gentoo-portage" |
| 90 |
USE="acl berkdb bzip2 cgi cli cracklib crypt cups dri fastcgi fortran |
| 91 |
gd gdbm gif gpm iconv ipv6 isdnlog jpeg midi mmx mudflap mysql ncurses |
| 92 |
nls nptlonly openmp pam pcre perl png pppd python readline reflection |
| 93 |
session spl sse sse2 ssl sysfs tcpd unicode x86 xml xorg zlib" |
| 94 |
ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci |
| 95 |
emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel |
| 96 |
intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem |
| 97 |
ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop |
| 98 |
empty extplug file hooks iec958 ioplug ladspa lfloat linear meter |
| 99 |
mmap_emul mulaw multi null plug rate route share shm softvol" |
| 100 |
APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon |
| 101 |
authn_dbm authn_default authn_file authz_dbm authz_default |
| 102 |
authz_groupfile authz_host authz_owner authz_user autoindex cache dav |
| 103 |
dav_fs dav_lock deflate dir disk_cache env expires ext_filter |
| 104 |
file_cache filter headers include info log_config logio mem_cache mime |
| 105 |
mime_magic negotiation rewrite setenvif speling status unique_id |
| 106 |
userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard |
| 107 |
mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk |
| 108 |
hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="fr en" |
| 109 |
USERLAND="GNU" VIDEO_CARDS="fbdev glint i810 intel mach64 mga neomagic |
| 110 |
nv r128 radeon savage sis tdfx trident vesa vga via vmware voodoo" |
| 111 |
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, |
| 112 |
LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, |
| 113 |
PORTAGE_RSYNC_EXTRA_OPTS |
| 114 |
|
| 115 |
Galevsky |
Archives