Hi, after the last recommendation to use UTF8 instead of
SQL-ASCII, I
finally made the transfer last night. It was a hard issue,
as the only
utility I know is "iconv", but it has the problem
that it needs to have
the whole file in memory. So I split my backup into each
table, and ran
iconv (dbmail_messageblks still had 6 GB so you need 6GB
free RAM
during the conversion), then reimported everything on a
64bit SUSE10.2
instead 32bit SUSE10.2, for the increased memory footprint
needed by
the DB.
I did NOT import all those cache tables like dbmail_tofield
etc., but
instead I ran "dbmail-util" afterwards, which
recreated those caches.
Well, at least most, but now everytime I run it, it lets 15
physmessages untouched:
Repairing DBMAIL for cached header values...
Ok. Found [15] un-cached physmessages.
...............
The output look good, but the log says:
dbmail/maintenance[10985]: Error:[sql]
dbpgsql.c,db_query(+284): query
failed [INSERT INTO dbmail_headervalue (headername_id,
physmessage_id,
headervalue) VALUES (9,642245,'Germanwings
Buchungsbestätigung und
Rechn?ßUTF-8?Q?ung L6D2QM')] : [FEHLER: ungültige
Byte-Sequenz für
Kodierung »UTF8«: 0xdf55 HINT: Dieser Fehler kann
auch auftreten,
wenn die Bytesequenz nicht mit der Kodierung
übereinstimmt, die der
Server erwartet, welche durch »client_encoding«
bestimmt wird. ]
(see full log at http://zmi.at/x/dbmai
l-utf8.txt )
It looks to me as if there's an UTF8 encoding issue, but how
can that
be? The DB is created as UTF8, I imported the db fresh after
conversion
with iconv (using iconv -f iso-8859-1 -t utf-8), which did
not give me
any errors,
I have encoding = utf8 in dbmail.conf also. What should I do
now?
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0676/846 914 666
.network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg
--import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F
1C6F E6B0
// Keyserver: www.keyserver.net Key-ID:
1C6FE6B0
_______________________________________________
DBmail mailing list
DBmail dbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|