Re: strange lmtp error

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=<x.ydomain.hu>, 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
> Dbmaildbmail.org
> htt
ps://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
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Hi,

The e-mails we get frequently/ /contains special characters
like these: 
éáõúóûí. Will they work properly with SQL_ASCII?

Aron

Paul J Stevens wrote:

>I think you have to change the encoding on the dbmail
database. Try
>SQL_ASCII instead.
>
>  
>
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail