From: Gary Lundquest (garylund-listaustin.rr.com)
Date: Mon Oct 01 2007 - 09:41:33 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 newslettermyoffice.org) 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]