From: Wietse Venema (wietseporcupine.org)
Date: Mon Oct 01 2007 - 19:54:19 CDT

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

Gary Lundquest:
[ Charset ISO-8859-1 unsupported, converting... ]
> 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

One copy of the data is sufficient. Nuke the SQL database.

        Wietse

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