[Bug 226960] New: error with mysql 5.1.43: Last database error: "Can't initialize character set latin1
Christophe Giboudeaux
cgiboudeaux at gmail.com
Mon Feb 15 10:19:56 GMT 2010
https://bugs.kde.org/show_bug.cgi?id=226960
Summary: error with mysql 5.1.43: Last database error: "Can't
initialize character set latin1
Product: Akonadi
Version: 4.5
Platform: Unlisted Binaries
OS/Version: Linux
Status: NEW
Severity: normal
Priority: NOR
Component: server
AssignedTo: vkrause at kde.org
ReportedBy: cgiboudeaux at gmail.com
CC: kdepim-bugs at kde.org
This was reported several times and seem to affect the 5.1.43 users:
http://forum.kde.org/viewtopic.php?p=147126
from bug 225333#c5:
Here mysql 5.1.43, too and akonadiserver dies this way:
$ akonadiserver start
search paths: ("/home/users/arekm/.vpython/bin", "/sbin", "/usr/sbin",
"/usr/local/sbin", "/home/users/arekm/bin", "/usr/lib64/qt4/bin",
"/usr/local/bin", "/usr/bin", "/bin", "/usr/games", "/usr/X11R6/bin",
"/home/users/arekm/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec",
"/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin")
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
checking table "FlagTable"
checking table "PartTable"
checking table "CollectionAttributeTable"
checking relation "PimItemFlagRelation"
checking relation "CollectionMimeTypeRelation"
checking relation "CollectionPimItemRelation"
DbInitializer::run() done
skipping update 2
skipping update 3
skipping update 4
skipping update 8
skipping update 10
skipping update 12
skipping update 13
skipping update 14
Character set 'latin1' is not a compiled character set and is not specified in
the '/usr/share/mysql/charsets/Index.xml' file
Nepomuk QueryServer interface not available!
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
DataStore::unhideAllPimItems()
Character set 'latin1' is not a compiled character set and is not specified in
the '/usr/share/mysql/charsets/Index.xml' file
Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't initialize character set latin1 (path:
/usr/share/mysql/charsets/)"
Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't initialize character set latin1 (path:
/usr/share/mysql/charsets/)"
Unable to connect to dbus service: ""
"[
0: akonadiserver(_Z11akBacktracev+0x39) [0x40ad19]
1: akonadiserver() [0x40b262]
2: /lib64/libc.so.6(+0x32520) [0x7fbd34dd1520]
3: /lib64/libc.so.6(gsignal+0x35) [0x7fbd34dd14a5]
4: /lib64/libc.so.6(abort+0x180) [0x7fbd34dd2970]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fbd35f7d7c4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c328]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7fbd3600c197]
8: /usr/lib64/libQtCore.so.4(+0x10b529) [0x7fbd3601d529]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7fbd3601e729]
10: akonadiserver(main+0x542) [0x406022]
11: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7fbd34dbdc2d]
12: akonadiserver() [0x4059e9]
]
"
but /usr/share/mysql/charsets/Index.xml contains latin1 definition:
<charset name="latin1">
<family>Western</family>
<description>cp1252 West European</description>
<alias>csisolatin1</alias>
<alias>iso-8859-1</alias>
<alias>iso-ir-100</alias>
<alias>iso_8859-1</alias>
<alias>iso_8859-1:1987</alias>
<alias>l1</alias>
<alias>latin1</alias>
<collation name="latin1_german1_ci" id="5" order="German Duden"/>
<collation name="latin1_swedish_ci" id="8" order="Finnish, Swedish">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="latin1_danish_ci" id="15" order="Danish"/>
<collation name="latin1_german2_ci" id="31" order="German Phonebook"
flag="compiled"/>
<collation name="latin1_spanish_ci" id="94" order="Spanish"/>
<collation name="latin1_bin" id="47" order="Binary">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
<collation name="latin1_general_ci" id="48">
<order>Dutch</order>
<order>English</order>
<order>French</order>
<order>German Duden</order>
<order>Italian</order>
<order>Latin</order>
<order>Portuguese</order>
<order>Spanish</order>
</collation>
<collation name="latin1_general_cs" id="49">
<order>Dutch</order>
<order>English</order>
<order>French</order>
<order>German Duden</order>
<order>Italian</order>
<order>Latin</order>
<order>Portuguese</order>
<order>Spanish</order>
</collation>
</charset>
--
from https://bugs.kde.org/show_bug.cgi?id=225333#c14 :
I'm having the same error:
...
Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't initialize character set latin1 (path:
/usr/share/mysql/charsets/)"
...
Akonadi starts, but is unusable for korganizar and kmail (empty folder list in
resources config, when there are some akonadi calendar sources)
It's not a bad MySQL config. I purged and reinstalled it and removed all
akonadi config files from ~.
Comment #12 works for me, downgrading to .41 in debian solves the problem, but
with .43 is not working.
Debian and Mandriva look affected. Nothing in the mysql changelog:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-43.html
--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
More information about the Kdepim-bugs
mailing list