Matthew, I think I've solved this once and for all. Could you please test dbmail_2_2_branch (rev 2332) and let me know if that helps.
If not: please provide me with a test-message that breaks for you. Matthew O'Connor wrote: > I think I may have found a bug that needs to be fixed. Someone has been > trying to send me an email that was constantly getting bounced by our > mail server. What's going on here (I think) is just a garden variety > encoding conflict. The issue, is that since we converted the > message_body data type to bytea to avoid encoding issues, shouldn't we > also convert all the header cache columns to bytea? > > DBMail version Info: > svn info > Path: . > URL: https://svn.ic-s.nl/svn/dbmail/trunk/dbmail > Repository Root: https://svn.ic-s.nl/svn/dbmail > Repository UUID: 7b491191-dbf0-0310-aff6-d879d4d69008 > Revision: 2259 > Node Kind: directory > Schedule: normal > Last Changed Author: aaron > Last Changed Rev: 2259 > Last Changed Date: 2006-09-08 15:48:57 -0400 (Fri, 08 Sep 2006) > > PostgreSQL 8.1 on CentOS 4.4 > > > From /var/log/maillog: > > Oct 26 16:54:05 stayman postfix/pipe[30325]: C7731116D9C0: > to=<[EMAIL PROTECTED]>, relay=dbmail-smtp, delay=4, status=bounced (user > unknown. Command output: Error dbpgsql.c, db_query: Error executing > query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, > headervalue) VALUES (8,1429221,'FW: Terrie O''Connor Real Estate Picture > Path account is now active to link virtual tours to REALTOR.com_')] : > [ERROR: invalid byte sequence for encoding "UTF8": 0xae ] > Error dbmail-message.c,_header_cache: insert headervalue failed Error > dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_tofield > (physmessage_id, toname, toaddr) VALUES (1429221,'','matthew@zeut.net')] > : [ERROR: current transaction is aborted, commands ignored until end of > transaction block ] Error dbmail-message.c,insert_address_cache: insert > tofield failed [INSERT INTO dbmail_tofield (physmessage_id, toname, > toaddr) VALUES (1429221,'','matthew@zeut.net')] Error dbpgsql.c, > db_query: Error executing query [INSERT INTO dbmail_ccfield ( > > The Details of the Bounced message: > > <[EMAIL PROTECTED]>: user unknown. Command output: Error dbpgsql.c, > db_query:Error executing query [INSERT INTO dbmail_headervalue > (headername_id, physmessage_id, headervalue) VALUES (8,1429212,'RE: > Terrie O''Connor Real Estate Picture Path account is now active to link > virtual tours to REALTOR.com_')] : [ERROR: invalid byte sequence for > encoding "UTF8": 0xae] > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
