Loading ...
Sorry, an error occurred while loading the content.

Re: Simple Postfix Newsletter wity MySQL

Expand Messages
  • Wietse Venema
    ... 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
    Message 1 of 6 , Oct 1, 2007
    • 0 Attachment
      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 newsletter@...) 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
    • Gary Lundquest
      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
      Message 2 of 6 , Oct 1, 2007
      • 0 Attachment
        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 -----
        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 newsletter@...) 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


      • Gary Lundquest
        Wietse ... 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
        Message 3 of 6 , Oct 1, 2007
        • 0 Attachment
          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" <wietse@...>
          To: "Postfix users" <postfix-users@...>
          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 newsletter@...) 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
          >
        • Wietse Venema
          Gary Lundquest: [ Charset ISO-8859-1 unsupported, converting... ] ... One copy of the data is sufficient. Nuke the SQL database. Wietse
          Message 4 of 6 , Oct 1, 2007
          • 0 Attachment
            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" <wietse@...>
            > To: "Postfix users" <postfix-users@...>
            > 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 newsletter@...) 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
            > >
            >
            >
            >
            >
          Your message has been successfully submitted and would be delivered to recipients shortly.