I think you have to change the encoding on the dbmail database. Try
SQL_ASCII instead.
A wrote:
> Hello,
>
> I am using dbmail version 2.0.4.
> I have a problem: most of the incoming e-mail failes with the same
> error, but some of them arrive. Here I send a sample from the log.
>
>
> May 9 12:42:21 mail dbmail/lmtpd[16790]: dbpgsql.c, db_query: Error
> executing query [INSERT INTO dbmail_messageblks (is_header, messageblk,
> blocksize, physmessage_id) VALUES ('0',' qqqq www.sgmail.hu - Ingyenes
> webmail 100 MByte tárhellyel! ', '62', '78495')] : [ERROR: invalid byte
> sequence for encoding "UNICODE": 0xe17268 ] May 9 12:42:21 mail
> dbmail/lmtpd[16790]: db.c,db_insert_message_block_physmessage: dbquery
> failed
> May 9 12:42:21 mail dbmail/lmtpd[16790]: db.c,db_insert_message_block:
> error inserting messageblks for physmessage [78495]
> May 9 12:42:21 mail dbmail/lmtpd[16790]:
> pipe.c,store_message_in_blocks: db_insert_message_block() failed
> May 9 12:42:21 mail dbmail/lmtpd[16790]: store_message_temp():
> db_insert_message_block failed
> May 9 12:42:21 mail dbmail/lmtpd[4548]: pool.c,manage_restart_children:
> child [16790] exited. Restarting...
> May 9 12:42:21 mail dbmail/lmtpd[16899]: pool.c,child_register:
> register child [16899]
> May 9 12:42:21 mail dbmail/lmtpd[16899]: pool.c,child_register:
> initializing child_state [16899] using slot [6]
> May 9 12:42:21 mail postfix/lmtp[16871]: 208A31200B7ED:
> to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1], delay=1802,
> status=deferred (lost connection with 127.0.0.1[127.0.0.1] while sending
> end of data -- message may be sent more than once)
>
> Thank You for your help!
>
> Aron
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
