From: Jason Pruim (japruimraoset.com)
Date: Mon Oct 01 2007 - 09:50:01 CDT

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

On Oct 1, 2007, at 10:41 AM, Gary Lundquest wrote:

> 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
>

Hi Gary,

Would it be possible to install a program like MailMan to do the
newsletter distribution? I use MailMan internally for a few very
simple/small distribution lists, and it works wonderfully. I'm pretty
sure there is even MySQL support just never needed to pursue since my
needs are very simple at this point.

Anyway... Just my 2¢ :)

>

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruimraoset.com

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