Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 31st October 2007, 16:20
aws910 aws910 is offline
Junior Member
 
Join Date: Jul 2006
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
 
Question postfix relay_recipient_maps refresh frequency

At my domain we get a lot of dictionary attacks(spammers try to send to everyoneUnderTheSun@mydomain.com). I set up the getadsmtp.pl script - it fetches all valid email addresses from an exchange server over LDAP, and these are used in the relay_recipient_maps table. It worked great, but I wanted something more...

I wanted to integrate the user-list with DSPAM's webUI(for authentication), and afaik to avoid same-system duplication, I'd have to move this list to mysql.... so I installed the postfix-mysql package, created a database for users/passwords(encrypted), and changed my postfix install accordingly:

old main.cf line:
Code:
relay_recipient_maps = hash:/etc/postfix/exchange_recipients
changed to:
Code:
relay_recipient_maps= proxy:mysql:/etc/postfix/mysql-recipients.cf
contents of /etc/postfix/mysql-recipients.cf:
Code:
user = mail_admin
password = ********
dbname = mail
query = SELECT email FROM users WHERE email='%s'
hosts = 127.0.0.1
It works for the relay_recipient_maps purpose, and presumably I can rig it to do the authentication for the DSPAM WebUI, but here's my question: Will it run this mysql query EVERY time an email comes in? and will this tax the system too much? I cron'd the getadsmtp.pl script, but it was pulling certain addresses that I wanted to keep internal, so I'd have to manually prune the list every time I ran the script, impossible if its cron'd to run every hour so not really an option. Has anyone tried any of this this? Are there any other options out there? I'm still kindof a noob....
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix: connection refused error tosin Server Operation 1 30th October 2007 17:30
Issues with Postfix using "Virtual Users And Domains With Postfix, Courier And MySQL" Kyse HOWTO-Related Questions 15 6th January 2007 15:35
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 15:36
postfix starts and stops why lhatle Installation/Configuration 2 21st December 2005 15:20


All times are GMT +2. The time now is 13:45.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.