List Info

Thread: transferred dbmail from pgsql 32bit to 64bit, and converted SQL-ASCII to UTF8, now strange




transferred dbmail from pgsql 32bit to 64bit, and converted SQL-ASCII to UTF8, now strange
country flaguser name
Austria
2007-08-26 16:43:13
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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )