Mark Sapiro wrote:

On 1/1/21 4:41 PM, Andrew Hodgson wrote:

...

I don't want to add captchas to the form right now but is there any way to clean out these users from the database perhaps periodically based on whether the accounts are subscribed to any list?

I have attached a script that will delete users from Django's user database (the auth_user table) if there is no Mailman user with the Django user's email address or if there is a Mailman user but it's not a member, nonmember, owner or moderator of any lists.

Thanks for this.

The setting DELETE_MAILMAN_USER controls whether it will also delete the corresponding Mailman user that's not a member, nonmember, owner or moderator of any lists. If set to True, it will.

I did set this to true. The majority of users existed only in Django but around 20 existed in Mailman as well and looked like old addresses.

Thanks again. Andrew.

On 2/8/21 1:22 AM, r.woithe@callassoftware.com wrote:

Hello,

i did try the script and unfortunately there is a problem. The script is deleting django-users are not member,nonmember ... of any lists.But thats not the point. Its ok if a user want to be only a django-user to see the archives and work with them.

If a user sign's up for an account at /accounts/signup/ and then confirms her address, she will then be a Mailman user with a user and an address record even though not a member of any lists.

The script should delete django-users who dont confirm your email address.

Change one line in the script from

    if mm_user is None or len(list(mm_user.memberships.members)) == 0:

to

    if mm_user is None:

And it will do what you want.

-- Mark Sapiro mark@msapiro.net The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

Hi.

Has anyone managed to get this script running using the Mailman-Web setup in a venv? It was working when Settings.py was in the /opt/mailman/mm directory but since moving to Mailman-Web has it in /etc/mailman3. I have been trying to import Mailman-Web to get the Django environment running but every time I do this I get a not configured exception raised.

Thanks. Andrew.

Mark Sapiro mark@msapiro.net wrote:

...

First, get the latest version of the script from https://www.msapiro.net/scripts/clean_users.py - not the one in this threat attached to https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/me ssage/YH676B67U24VXXNX2UMJYNVSFEAKAHYG/

Thanks for the updated script it works a charm. Andrew.

On 3/31/23 17:01, Allan Hansen wrote:

Mark,

Will this be part of an upcoming update or micro update to Mailman?

It might be in Mailman's contrib directory at some point, but probably not.

There are many scripts at https://www.msapiro.net/scripts/ (mirrored at https://fog.ccsf.edu/~msapiro/scripts/) that people may find useful. These are mostly things that I have developed in response to mailing list questions or for my own purposes and the majority are Mailman 2.1 specific. They were never intended to be part of a release.

-- Mark Sapiro mark@msapiro.net The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan