From: Wietse Venema (no email)
Date: Mon Oct 01 2007 - 11:01:59 EDT
Gary Lundquest:
> 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
You can't list another lookup table inside an aliases table. You
can specify a MySQL aliases table IN ADDITION TO the system aliases
table.
However, I strongly suggest using a mailing list manager instead.
Wietse
> 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
|
|
|