Mailman 3 January 2008 - Mailman-Users

Re: [Mailman-Users] DB > mailman import script?
by Barry Finkel 28 Jan '08

28 Jan '08

"Zbigniew Szalbot" <zszalbot(a)gmail.com> wrote: >Hello, > >Is there a script to insert users from a mysql database into mailman? > >I can do it manually but I am wondering if there is a script to load a >list of subscribers from a mysql database to a specific mailman list >and if it is one which can be automated? > >Thank you in advance! > >Zbigniew Szalbot You can create a flat file from the database and use sync_members -w=no -g=no -d=no -a=no -f flatfile $listname to synch the membership list quietly (without any notification to new subscribers or those who are unsubscribed). I do this for many of my lists every day via cron. ---------------------------------------------------------------------- Barry S. Finkel Computing and Information Systems Division Argonne National Laboratory Phone: +1 (630) 252-7277 9700 South Cass Avenue Facsimile:+1 (630) 252-4601 Building 222, Room D209 Internet: BSFinkel(a)anl.gov Argonne, IL 60439-4828 IBMMAIL: I1004994

1 0

DB > mailman import script?
by Zbigniew Szalbot 28 Jan '08

28 Jan '08

Hello, Is there a script to insert users from a mysql database into mailman? I can do it manually but I am wondering if there is a script to load a list of subscribers from a mysql database to a specific mailman list and if it is one which can be automated? Thank you in advance! Zbigniew Szalbot

1 0

Mailing list continues to lock
by Matt Zimmerman 28 Jan '08

28 Jan '08

I am using mailman 2.1.8. We seemed to have a issue today with messages being queued up in the qfiles/in. After looking more into it it seems like one of the mailing lists and the qrunner was locked. So I removed the both locks. But they continued to lock up. So I brute force removed all of the locks until the messages were dequeued. The messages seem not to be queuing any more and the qrunner is not locking. The mailing list is still locking though. The lock logs from earlier in the day say "unexpected linkcount:-1". Any Ideas? Thanks, Matt

2 1

Re: [Mailman-Users] Ghost Moderator Requests
by Dennis Putnam 27 Jan '08

27 Jan '08

Thanks for the reply. At 04:07 PM 1/26/2008, you wrote: >First of all, it is not clear from your prior posts whether or not you >recognize that these held messages are all from the 'mailman' site list, >not from your other list. Sorry I wasn't clear but yes, I knew they were from the mailman list. >Also this (the 'mailman' list) list's web_page_url attribute which >reflects its url host is http://dap002.dap.localnet/mailman/ which may >or may not be valid, but is certainly not accessable from the internet. That is correct since I don't have a static IP. I can access the admin functions from the LAN. My users must do everything via email. >Finally, these all appear to have been 'owner' bounces delivered to the >site list last April 17. I can see that but I have no idea what is significant about that date since it did not show up until after I did this restore thing. >If you go to the admindb interface for the 'mailman' list, you should >see these messages and be able to discard them - go to the same URL as >the admindb interface for your other list, but with 'mailman' as the >list name. As I said, it tells me there are no pending requests. >Or, you can discard them by running. > >path/to/mailmans/bin/discard /var/lib/mailman/data/heldmsg-mailman-* I thought I'd give this a try and here's what I get: [root@dap002 bin]# discard /var/lib/mailman/data/heldmsg-mailman-* Traceback (most recent call last): File "/usr/sbin/discard", line 120, in ? main() File "/usr/sbin/discard", line 110, in main mlist.HandleRequest(id, mm_cfg.DISCARD, '', False, False, '') File "/usr/lib/mailman/Mailman/ListAdmin.py", line 164, in HandleRequest rtype, data = self.__db[id] KeyError: 113 [root@dap002 bin]# Must be a remnant of the restore fiasco. >Do NOT just remove the heldmsg-mailman-* files since that will remove >the message files, but it won't stop the notices. If you have already >removed the files, you need to either go to the admindb interface for >the mailman list and discard them or remove the >/var/lib/mailman/lists/mailman/request.pck file which will be >automatically recreated when necessary. Even though the above didn't work, can I do this anyway? I don't use that mailing list so there are no messages in it that I care about. Is there a way to just wipe everything manually? I guess this list is necessary but is there a way to wipe everything and have it rebuild what it needs? That should clean everything up, right? >-- >Mark Sapiro <mark(a)msapiro.net> The highway is for gamblers, >San Francisco Bay Area, California better use your sense - B. Dylan

2 1

korean error
by Obantec Support 27 Jan '08

27 Jan '08

Hi FC3 running python 2.3.4 & trying to install Mailman-2.1.9 ./configure (using default settings) make install produces just this error Traceback (most recent call last): File "bin/update", line 46, in ? import paths File "/usr/local/mailman/bin/paths.py", line 60, in ? import korean ImportError: No module named korean make: *** [update] Error 1 I have googled and read the FAQ's but not found a solution. Mark

1 0

Promotion
by Khalil Abbas 27 Jan '08

27 Jan '08

Hello mailman guys.. ok, I have a dedicated server .. and I use mailman to send a daily newsletter.. I recenly got a list of 1,000,000 email addresses that I want to use to promote my website and mailing list .. can I create another mailman installation and add these addresses to it and use it to send an invitation to visit my website and join my mailing list without the risk of getting blocked by hotmail or yahoo or others because these emails I bought will have many faulty ones and will generate excessive bounces.. is mailman programmed in a way to avoid getting blocked by hotmail and others?? or do u think it's better to buy another server and use it for promotion? Thanks mailman unknown soldiers ;) _________________________________________________________________ Need to know the score, the latest news, or you need your Hotmail®-get your "fix". http://www.msnmobilefix.com/Default.aspx

10 14

Customizing by adding fields to Listinfo page
by Kathy Gee 27 Jan '08

27 Jan '08

Hello, Can I customize the Listinfo page by adding one or two fields to prompt for more information from a subscriber? If yes, what python script(s) do I need to also modify to make this work so the web admin interface can display the information entered for these new fields when the form is submitted? Thanks! Kathy Gee IT Project Specialist Anita Borg Institute for Women and Technology "Connecting Women and Technology" www.anitaborg.org <http://www.anitaborg.org> | www.gracehopper.org <http://www.gracehopper.org> | www.systers.org <http://www.systers.org> | www.anitaborg.org/techleaders <http://www.anitaborg.org/techleaders> _________________________________________________________ 1501 Page Mill Road, MS 1105, Palo Alto, CA 94304 Email: kathyg(a)anitaborg.org <mailto:kathyg@anitaborg.org> Office: 1.650.857.3901 Fax: 1.650.852.8172

2 1

Re: [Mailman-Users] spamassassin sendmail virtualusers and mail lists
by Noah 27 Jan '08

27 Jan '08

Hi there Shane and Mailman list users. this is a great idea indeed but the last part of the delivery to mailman aint working and trying to figure out a work around to keep the gid set to mailnull. I am getting the error "Mailman mail-wrapper: Group mismatch error. Mailman expected the mail wrapper script to be executed as group "mailnull", but the system's mail server executed the mail script as group "wheel". Try tweaking the mail server to run the script as group "mailnull", or re-run configure, providing the command line option `--with-mail-gid=wheel'." any clues how I can get my specific procmailrc file to run the mailman mail-wrapper with the group mailnull. Is there something funky I can do to my /etc/groups ? Maybe I could recompile my program with the mailman wrapper with two mailman gids? Why does the entry: friends-owner: "|/usr/local/mailman/mail/mailman owner friends" in my /etc/mail/aliases.mailman work fine without a group error message in /var/log/maillog? weird? Here is the script that calls the mailman mail-wrapper proggie: --- snip ---- # cat /usr/local/etc/procmailrcs/friends-owner.rc #procmail recipe for getting rid of high-scoring mail-list spam :0fw * |/usr/local/bin/spamc -f :0e { EXITCODE=$? } :0: * ^X-Spam-Level:.*\*\*\*\*\*\* /usr/local/mailman/mail/spam-mail :0 * |/usr/local/mailman/mail/mailman owner friends ---- snip ---- Here are my mailman compilation settings in /etc/make.conf --- snip ---- MM_USERNAME=mailman MM_USERID=89 MM_GROUPNAME=mailman MM_GROUPID=89 CGI_GID=www MAIL_GID=mailnull ---- snip ---- Cheers, Noah Shane Williams wrote: > On Tue, 8 Jan 2008, Noah wrote: > >> Thanks John, >> >> the problem is that our moderators are getting way too much mail and >> just want to trash the high-scoring meesages. > > We filter on mailman mailing lists in a roundabout way. > > We changed the mailman "post" alias to invoke a procmail script, like: > list-blah: "|/usr/bin/procmail -m /etc/procmailrcs/list-blah.rc" > > Then, the procmail recipe 1. runs spamc, 2. /dev/nulls anything over > 10, and 3. calls mailman "post" the way the alias used to. I've > included an example below. > > Then, in the mailman config for that list, under privacy option -> > Spam Filters, we added a line to the "Legacy anti-spam filter" section > that says "X-Spam-Flag: YES" causing anything between our default > score and 10 to get held for moderation. You could of course, change > these levels and take different actions if you have a more recent > version of mailman. > > Maybe that helps... > > ---------------------------------------------------------- > #procmail recipe for getting rid of high-scoring mail-list spam > > :0fw > * > |spamc -f > > :0e > { > EXITCODE=$? > } > > :0: > * ^X-Spam-Level:.*\*\*\*\*\*\*\*\*\*\*\* > /dev/null > > :0 > * > |/home/mailman/mail/mailman post list-blah > ------------------------------------------------------- > > > > >> >> Cheers, >> >> Noah >> >> >> John D. Hardin wrote: >>> On Tue, 8 Jan 2008, Noah wrote: >>> >>> > We want to run spamassassin on mail lists >>> >>> If you're managing your mailing lists using Mailman, there are patches >>> floating around that will make mailman pass messages through SA and >>> hold high-scoring messages for moderation. >>> >>> -- >>> John Hardin KA7OHZ http://www.impsec.org/~jhardin/ >>> jhardin(a)impsec.org FALaholic #11174 pgpk -a jhardin(a)impsec.org >>> key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 >>> ----------------------------------------------------------------------- >>> Liberals love sex ed because it teaches kids to be safe around their >>> sex organs. Conservatives love gun education because it teaches kids >>> to be safe around guns. However, both believe that the other's >>> education goals lead to dangers too terrible to contemplate. >>> ----------------------------------------------------------------------- >>> 9 days until Benjamin Franklin's 302nd Birthday >> >> >

2 1

Having the Web interface show the same lists with or without the "www." prefix
by Paul Kleeberg 27 Jan '08

27 Jan '08

Here is my question: Is there anything I can do so that the mailman web interface will show the same lists whether or not the "www." prefix appears? Background: Migrated and upgraded a from MacOSX Server 10.4 to 10.5 which included an upgrade of Mailman to 2.1.9. Everything functioned well. I have 2 virtual domains and the lists on the two domains have remained distinct and functioning. Mailman's web interface responded to www.domain1.com and domain1.com with one set of mailing lists and www.domain2.com and domain2.com as the other site. Now that I have upgraded to Apache 2.2. it appears that it the 2 web pages with the lists will only respond to the web pages if the "www." is not included. Is there anything I can do so that the web interface for each sets of lists will work with or without the "www." prefix? -- Paul Kleeberg paul(a)fpen.org

2 3

content type
by Con Wieland 26 Jan '08

26 Jan '08

Can someone explain why I got this message with no additional text in the message. Skipped content of type multipart/alternative-------------- next part --------------

2 1