Mailing list with dynamically generated addresses
- by Joe Tomasone
I am trying to implement a dynamic mailing list from a database that changes quite often.
Conditions:
Postfix is the MTA
Email addresses are in a MySql Database
Postfix only allows senders whose emails are in that database (via smtpd_sender_restrictions)
Cron job extracts the current emails from the database nightly and puts them into an alias file, then runs postalias on it.
This works well, but since the sender remains the same, many domains are rejecting the email since my server is not a DNS listed mail server for the sender's domain.
So, I either have to find a way to re-write the outgoing address as "listserv@mydomain" or find some mailing list package that will use database-retrieved emails (either queried directly or in a flat file) as the subscriber list, with that list replaced daily.
I've tried Sympa and am pretty much ready to give up on it - it's a nightmare to get working right - but that's the only open source listserver that I have seen that works with dynamic mail lists.
Does anyone have any ideas?
Thanks, Joe