[BALUG-Admin] lot of really nice command-line tools to use in dumping and editing various pck databases

[Michael Paoli]

Thanks, slick, noted.

I also noticed there's package (mailman-api)for a REST API for Mailman.
I also found a very promising mmclient (which uses Mailman's REST API),
but alas, don't see a corresponding package by Debian.

Also thought of something else highly practical ... but, topic drift,
will post that separately.

> From: "Rick Moen" <rick@linuxmafia.com>
> Subject: Re: lot of really nice command-line tools to use in dumping  
> and editing various pck databases
> Date: Sun, 30 Jul 2017 04:12:23 -0700

> Quoting Michael Paoli (Michael.Paoli@cal.berkeley.edu):
>
>> Ooooh, yes!  I'd be highly interested in such CLI tools/programs.
>> Any particular pointers on what/where to look for such?
>> (Debian packages or names or name pattern, or term to search on?)
>
> Well, I don't remember, exactly.  Your better source would be asking
> Marc Merlin <marc@merlins.org> .  But, that having been said, I _used_
> to know something about that, and grabbed a bunch of those that Marc
> collected on the SVLUG mailing list server.  Thus, they are here on
> linuxmafia.com as part of my safety backup, ergo accessible to you:
>
> /usr/local/src/rickstuff/svlug/var-local-scr/scr $ ls -al
> total 244
> drwxr-sr-x 2 root root  4096 Jul 31  2004 .
> drwxr-sr-x 3 root rick  4096 May 28  2015 ..
> -rwxr-xr-x 1 root root  3152 Aug 25  2000 addsize
> -rwxr-xr-x 1 root root   165 Feb 20  2002 base64dec
> -rwxr-xr-x 1 root root   165 Feb 20  2002 base64enc
> -rwxr-xr-x 1 root root  1406 Jul 27  1998 bz2grep
> -rwxr-xr-x 1 root root   301 Jul 27  1998 bzcat
> -rwxr-xr-x 1 root root  1399 Jul 27  1998 bzgrep
> -rwxr-xr-x 1 root root   737 Oct 20  1998 catdb
> -rwxr-xr-x 1 root root  2814 May 23  1998 cdda2mp3
> -rwxr-xr-x 1 root root   559 Sep 24  2001 checkaliases
> -rwxr-xr-x 1 root root   201 May 23  1998 clean
> -rwxr-xr-x 1 root root  1085 Jul 28  2000 cleanfile
> -rwxr-xr-x 1 root root   364 Jan  8  1999 cleanss
> -rwxr-xr-x 1 root root   605 Jul 27  1998 color_test
> -rwxr-xr-x 1 root root   332 Jul 27  1998 color_test2
> -rwxr-xr-x 1 root root   211 Sep 27  1999 copyaudiocd
> -rwxr-xr-x 1 root root  2594 Nov 12  2001 copysafe
> -rwxr-xr-x 1 root root   230 May 23  1998 count
> -rwxr-xr-x 1 root root   541 Feb 14  2000 disp
> -rwxr-xr-x 1 root root   206 May 23  1998 dup2
> -r-xr-xr-x 1 root root   884 Jul 31  2004 evim
> -rwxr-xr-x 1 root root 37200 Jun  6  2001 expn
> -rwxr-xr-x 1 root root   926 May 23  1998 findcust
> -rwxr-xr-x 1 root root   889 May 23  1998 findcustc
> -rwxr-xr-x 1 root root  1010 May 23  1998 findman
> -rwxr-xr-x 1 root root  1148 Oct 18  1998 findstr
> -rwxr-xr-x 1 root root   434 Jun  1  1999 gendnstables
> -rwxr-xr-x 1 root root  1013 Jul 27  1998 kall
> -rwxr-xr-x 1 root root  1063 Mar 14  2000 killanims
> -rwxr-xr-x 1 root root    37 Jan 24  2000 listmp3tags
> -rwxr-xr-x 1 root root   925 May 23  1998 lock
> -rwxr-xr-x 1 root root   843 May 23  1998 mem
> -rwxr-xr-x 1 root root  2432 May 23  1998 multidecode
> -rwxr-xr-x 1 root root   174 Jul 27  1998 playau
> -rwxr-xr-x 1 root root    59 Jul  4  1999 qpdecode
> -rwxr-xr-x 1 root root    99 Jul  4  1999 qpencode
> -rwxr-xr-x 1 root root   389 Jun 23  2000 recompress
> -rwxr-xr-x 1 root root  1017 Apr 13  1999 redocheckconfig
> -rwxr-xr-x 1 root root   588 May 23  1998 ren
> -rwxr-xr-x 1 root root   341 Jun 13  1999 rename
> -rwxr-xr-x 1 root root  3252 Aug  7  2001 rescanscsi
> -rwxr-xr-x 1 root root   687 Feb 13  1999 reset
> -rwxr-xr-x 1 root root   371 Jul 27  1998 ro
> -rwxr-xr-x 1 root root   179 Jul 27  1998 rot13
> -rwxr-xr-x 1 root root   372 Jul 27  1998 rw
> -rwxr-xr-x 1 root root   478 Jul 28  2000 savephoto
> -rwxr-xr-x 1 root root  1627 Jul 28  2000 setmp3tag
> -rwxr-xr-x 1 root root  5356 Jan 21  2000 ssh-ppp
> -rwxr-xr-x 1 root root   446 May 30  2000 symbolsearch
> -rwxr-xr-x 1 root root   352 May 23  1998 termreset
> [rick@linuxmafia]
> /usr/local/src/rickstuff/svlug/var-local-scr/scr
>
> In fact, tell you what:
>
> [rick@linuxmafia]
> /usr/local/src/rickstuff/svlug/var-local-scr/scr $ cd ..
> [rick@linuxmafia]
> /usr/local/src/rickstuff/svlug/var-local-scr $ tar czf /tmp/scr.tar.gz scr
> [rick@linuxmafia]
> /usr/local/src/rickstuff/svlug/var-local-scr $
>
> Attached.
>
>> I've got nice web scraping bit (had a wee bit more time this A.M.),
>> so now I can grab *all* the member data *except* for their password
>> (and the relatively trivial bit that Mailman also saves their
>> email as subscriber enters/submits it - which might contain
>> uppercase letters - but Mailman canonicalizes it to lowercase
>> and mostly or entirely uses that - though it does also save the original
>> form).  At least I think that's *all* the data - I'll double-check that
>> there's nothing else Mailman saves beyond that (at least of
>> relevance/significance) that's not obtainable from the individual
>> subscriber settings web pages.  That then also frees us up from
>> trying to get that data from DreamHost.com (and them possibly mucking
>> it up or saying "no" anyway).
>
> More than good enough.  Nobody cares much about their Mailman
> per-subscription passwords, fortunately.  If they bitch, just tell 'em
> they can change them to suit.
>
> It's the usual thing:  Optimise for the common case.
>
>