Ok, Mailman is looking like the solution to my problems. To get this going I need to create mailman lists from my existing email addresses to vendor mappings in the MySQL DB (I don't want everyone already signed up to have to re-subscribe). Is it easy to import a list to Mailman?
Once I have my lists in place I think the following is required: 1. Create a customized welcome message that avoids mentioning how to post to the list so new people joining. 2. Restrict the list so only authorized persons can post. My java program will be this "person". Not sure how to configure this from a Mailman point of view yet. 3. Modify my DB table to map the Mailman send list addresses to a vendors. Thus my program sends a mail to that address and Mailman distributes it to the members. Does all this sound reasonable? Thanks for all the help thus far :-) Luke >From: Mark Sapiro <[EMAIL PROTECTED]> >To: "Luke Shannon" <[EMAIL PROTECTED]>,mailman-users@python.org >Subject: Re: [Mailman-Users] (no subject) >Date: Thu, 16 Feb 2006 13:04:53 -0800 >MIME-Version: 1.0 >Received: from mail.value.net ([205.208.202.10]) by >bay0-mc6-f3.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Thu, 16 >Feb 2006 13:05:47 -0800 >Received: from msapiro [209.182.169.133] by mail.value.net with ESMTP >(SMTPD32-8.15) id A8F722F70152; Thu, 16 Feb 2006 14:04:55 -0700 >X-Message-Info: JGTYoYF78jEHjJx36Oi8+Z3TmmkSEdPtfpLB7P/ybN8= >X-Mailer: Ultrafunk Popcorn 1.74 (11-May-2005) >Organization: Not Very Much >Return-Path: [EMAIL PROTECTED] >X-OriginalArrivalTime: 16 Feb 2006 21:05:48.0488 (UTC) >FILETIME=[C2BD5480:01C6333C] > >Luke Shannon wrote: > > >Actually it doesn't really need to be in MySQL. As long as Mailman >handles > >the add and removing of addresses to a list and creates an alias for each > >list, my java program could be tweaked to send mail to all alias rather >than > >a set of email addresses (as it does now). > > >Mailman does not create an alias per se. It does provide a list posting >address and receives posts at that address and sends them to the list >members. > >If the only purpose of your MySQL database is to provide a list of >people/addresses to deliver to, you could use Mailman without >modification and let it maintain it's own membership list and handle >bounce processing and subscribe/unsubscribe, etc. > >See ><http://www.python.org/cgi-bin/faqw-mm.py?req=show&file=faq03.011.htp> >for information about setting up announcement (one-way) lists. > >-- >Mark Sapiro <[EMAIL PROTECTED]> The highway is for gamblers, >San Francisco Bay Area, California better use your sense - B. Dylan > ------------------------------------------------------ Mailman-Users mailing list Mailman-Users@python.org http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=show&file=faq01.027.htp
