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

Re: Simple Postfix Newsletter wity MySQL

Expand Messages
  • 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 1 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 2 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 3 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 4 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 5 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.