From: Gary Lundquest (garylund-listaustin.rr.com)
Date: Mon Oct 01 2007 - 17:28:02 CDT

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

Wietse

> However, I strongly suggest using a mailing list manager instead.

Thanks for the response.

Why do suggest using a mailing list manager?

I'm open to doing whatever will make the newsletter user's life easier, and
that does not take a lot of time to install.

The newsletter user is currently using Mailman from an ISP, and it is very
clumsy to use for his purpose, and he has to do dual entry of each address
change - once in Mailman and once in the in-house database (MySQL). The
newsletter recipients do not self subscribe or unsubscribe - they contact
the user and he adds or deletes them. It seems to me that it would save the
user a lot of work if he could just send out the newsletter to the members
already in his database.

Please let me know if I am missing something here. I don't claim to be an
expert in Postfix.

Thanks.

-Gary

----- Original Message -----
From: "Wietse Venema" <wietseporcupine.org>
To: "Postfix users" <postfix-userspostfix.org>
Sent: Monday, October 01, 2007 10:01 AM
Subject: Re: Simple Postfix Newsletter wity MySQL

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