{"id":162,"date":"2006-12-14T21:47:21","date_gmt":"2006-12-14T20:47:21","guid":{"rendered":"http:\/\/mattiesworld.gotdns.org\/weblog\/2006\/12\/14\/mailman-chronicles\/"},"modified":"2006-12-14T21:47:21","modified_gmt":"2006-12-14T20:47:21","slug":"mailman-chronicles","status":"publish","type":"post","link":"https:\/\/mattiesworld.gotdns.org\/weblog\/2006\/12\/14\/mailman-chronicles\/","title":{"rendered":"Mailman chronicles"},"content":{"rendered":"

ok, so you know mailman<\/a>? But how to fetch a subscribers list without using the admin interface?<\/p>\n

Mailman does not use a database nor does it store a list’s subscribers in some plain text format. So how to start? I searched the mailman mailinglist archive and didn’t find a clue. I looked a bit at the code, but it’s hard to get started if you’re not into python. \ud83d\ude09
\nBy searching the mailman dir I found a .pck file.. It’s a pickled file. \ud83d\ude42 This seems to be the Python term for serialization<\/a>. So I found a mailinglist in its pickled state which seemed to contain the subscribers. Mmm, okay, let’s download the mailman source and find the usages of the pickle library.. Got it! \ud83d\ude42 So hooray, fire up that python eclipse plugin<\/a> that I’ve been eager to try out on a real piece of code, open up those nice python<\/a> references<\/a> and let’s unpickle!<\/p>\n

Ehrm.. wait a second.. Apparently, downloading the source code can reveal other interesting parts of mailman. Like, for example, a script that lists all subscribers? =)<\/p>\n

Another lesson learned with open source projects: FIRST download the source, before you try to hack it in yourself \ud83d\ude09 Okay, looking at the mailman installation dir would have been sufficient too, but who likes to search some custom installed linux distro over some crappy remote connection<\/a>? \ud83d\ude09<\/p>\n

There is still one step to do: how to get that script’s output on a webpage? One could try cgi or php for example. I looked at how mailman does it, but I guess it uses some precompiled ‘trusted’ executables for that hooked up to apache. After writing a php script, I realised it wouldn’t run on a normal user account, d’oh \ud83d\ude42
\nThe problem is not the mailman script itself, but the mailman databases it tries to open. The pickled mailing lists are only readable for users in the mailman group. I didn’t want to open a security hole (everyone has already enough spam), so I set up a cron<\/a> job which executes the mailman script and puts the output readable to the normal user. It is not as cool as having the actual data, but having it on a daily basis is sufficient.<\/p>\n","protected":false},"excerpt":{"rendered":"

ok, so you know mailman? But how to fetch a subscribers list without using the admin interface? Mailman does not use a database nor does it store a list’s subscribers in some plain text format. So how to start? I searched the mailman mailinglist archive and didn’t find a clue. I looked a bit at … Continue reading Mailman chronicles<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,2],"tags":[],"class_list":["post-162","post","type-post","status-publish","format-standard","hentry","category-linux","category-web"],"_links":{"self":[{"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/posts\/162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/comments?post=162"}],"version-history":[{"count":0,"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/posts\/162\/revisions"}],"wp:attachment":[{"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/media?parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/categories?post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mattiesworld.gotdns.org\/weblog\/wp-json\/wp\/v2\/tags?post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}