Using dbmail-pgsql, yesterday's debian pkg :) Sendmail inserts and anti-spam header into my inbound mail like this:
X-milter-siq-Report: pass=YES or X-milter-siq-Report: pass=NO I would like to use the simplest method to cause mail with a pass=NO to be stored in the dbmail tables so that it will appear in an IMAP folder named "bulk" while the pass=YES mail goes as usual to the inbox folder. My thoughts on how to do it are mainly based on guesses or functioning of other mail stores: 1. modify dbmail's INSERT statements with an IF for folder name, depending on which header value is found 2. modify my milter to rewrite the RCPT depending on pass=YES or NO - if dbmail recognizes some format for [EMAIL PROTECTED] (The mail server I am migrating away from, delivers mail to [EMAIL PROTECTED], putting the mail into folder "anything") 3. add another program between sendmail and dbmail - not sure how this would help unless LMTP makes it possible to insert to a particular folder and SMTP doesn't. (sounds silly) 4. use a trigger or other "after the insert" method in postgres to change the folder for pass=NO messages (sounds dreadful) Thanks for any insight! - April Lorenzen
