awesome! why isn't this kind of stuff documented anywhere? or is it and i just missed it?
thanks, shon > 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 > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- "power off einstein" - moe syzlak
