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/dbmail-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
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
