 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
2 messages in net.sourceforge.lists.courier-maildropRe: [maildropl] Maildrop and MySQL?| From | Sent On | Attachments |
|---|---|---|
| Rob Hudson | Nov 20, 2006 11:20 am | |
| Dobkin Anton | Nov 20, 2006 10:19 pm |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | Re: [maildropl] Maildrop and MySQL? | Actions... |
|---|---|---|
| From: | Dobkin Anton (adob...@viansib.ru) | |
| Date: | Nov 20, 2006 10:19:03 pm | |
| List: | net.sourceforge.lists.courier-maildrop | |
Rob Hudson ?????:
Hi,
I've got Postfix installed and configured with all virtual users (meaning no users have an actual account login) and configuration in a MySQL database.
I recently added dspam filtering.
I'd like dspam to hand off to maildrop to deliver to the virtual mailboxes. But I'm not sure how to configure maildrop to read from the MySQL tables.
All of my mailboxes are of the form: /home/vmail/$domain/$user/.maildir
So it may be that I don't need to read from the mysql tables and simply parse the destination email?
Any help or guidance would be much appreciated.
Thanks, Rob
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Courier-maildrop mailing list Cour...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/courier-maildrop
Hi!
I too have the installed mail system on the basis of Postfix. Postfix is configured with all virtual users. Users are stored in mysql database. And as I have the dspam filter and maildrop the local agent of delivery.
You are not to read from the mysql tables. You need simply parse the the destination email.
For me it is made so:
*DSPAM configure:* DeliveryHost 127.0.0.1 DeliveryPort 10026 DeliveryIdent localhost DeliveryProto SMTP ......... ServerPID /var/run/dspam/dspam.pid ServerMode auto ServerParameters "--deliver=innocent" ServerIdent "localhost.localdomain" ServerDomainSocketPath "/var/run/dspam/dspam.sock" ............ *Postfix configure:* master.cf: smtp inet n - n - - smtpd -o content_filter=lmtp:unix:/var/run/dspam/dspam.sock ............. localhost:10026 inet n - n - - smtpd -o content_filter= -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks -o smtpd_helo_restrictions= -o smtpd_client_restrictions= -o smtpd_sender_restrictions= -o smtpd_recipient_restrictions=permit_mynetworks,reject -o mynetwworks=127.0.0.1/8 -o smtpd_authorized_xforward_hosts=127.0.0.0/8 ..............
*Maildrop example simple: *maildroprc or .mailfilter: .........* * if ( /^X-DSPAM-Result: Spam/:h ) { #Creating the .Spam subfolder, if it is not present `test -d $HOME$DEFAULT/.Spam` if ($RETURNCODE!=0) { `maildirmake $HOME$DEFAULT/.Spam` } to "$HOME$DEFAULT/.Spam" } ......
Good luck!
------------------------------ Dobkin Anton VIAN, Inc.