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

Simple Postfix Newsletter wity MySQL

Expand Messages
  • 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
    Message 1 of 6 , Oct 1, 2007
    • 0 Attachment
      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
    • Jason Pruim
      ... 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
      Message 2 of 6 , Oct 1, 2007
      • 0 Attachment

        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


      • 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 3 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 4 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 5 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 6 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.