From: Gary Lundquest (no email)
Date: Mon Oct 01 2007 - 10:41:33 EDT
I'm looking for a way to use Postfix and MySQL for a simple email newsletter. My user periodically sends an email newsletter to a few hundred of his organization's members who have signed up for it. I have a crude setup now, where the user changes the contents (email addresses) of the text file pointed to in the /etc/aliases file.
I would like the aliases file to map to a MySQL query instead of the :include: file. I see where Postfix does this for lookup tables but I haven't seen a way to use a MySQL query to replace the include file of email addresses. Is this a matter of getting the syntax right in the right config file, or is this a different kind of thing that Postfix is not designed to do with MySQL? Is there a way to do this using something besides mapping MySQL to the aliases include file?
My goal is for the user to send the newsletter to a a specified address (like ) and have Postfix send it to everyone in the MySQL query. Dealing with MySQL is not a problem, but I am not an expert on Postfix.
Postfix version 2.4.5, Mysql version 5.0.27, on CentOS 4. Postfix is only sending mail, not receiving.
Thanks for any info.
-Gary
|
|
|