From: Gary Lundquest (no email)
Date: Mon Oct 01 2007 - 18:18:45 EDT
Jason
Thanks for the response.
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 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.
Thanks.
-Gary
----- Original Message -----
From: Jason Pruim
To: Gary Lundquest
Cc: Postfix Users
Sent: Monday, October 01, 2007 9:50 AM
Subject: Re: Simple Postfix Newsletter wity MySQL
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 ) 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
|
|
|