Hello shon, Reprising my post from mid-January, 2002. The following assumes you're using dbmail with MySQL; if you're using Postgres, you will need to build Postfix with Postgres support, and the 'mynetworks' line will be changed to match, and the SQL in the 'additional_conditions' portion of my_net.cf is different:
---- To make POP/IMAP-before-SMTP work with Postfix, you must first make sure that Postfix speaks MySQL... hopefully, you'll already know how to do that, 'cuz I'm not going to tell you here. B-) In your postfix main.cf file, you need a line like: mynetworks = 192.168.0.0/16, mysql:/etc/postfix/my_net.cf The file /etc/postfix/my_net.cf will contain: user = postfix password = [password] dbname = dbmail table = pbsp select_field = since where_field = ipnumber additional_conditions = and unix_timestamp() - unix_timestamp(since) <= 18000 With these parameters, any user who has done a POP/IMAP authorization within the past 1800 seconds (30 minutes) will have their IP validated for Postfix. At 1801 seconds, the IP will not be validated... Oh, and, of course, you need to enable DBMail's daemons to feed this, with the following two settings in dbmail.conf: DBMAIL_POP_BEFORE_SMTP = yes DBMAIL_IMAP_BEFORE_SMTP = yes --- Hope this helps... I've been using it for over a year now, and the only problem has been that not all my users have configured their mail clients to check their mail before sending more... -- Jeff Brenton President, Engineered Software Products, Inc http://espi.com Questionable web page: http://dididahdahdidit.com Liberalism grants you the freedom to advocate any idea*. * Please see http://www.dididahdahdidit.com/except.php for a current list of exceptions
