On 4/25/23 6:59 AM, Mark Sapiro wrote:

On 4/25/23 3:02 AM, Andrew Hodgson wrote:

...

You may find this script useful: https://www.msapiro.net/scripts/clean_users.py

I will modify the script to enable deleting Mailman users with no memberships even if they aren't Django users and post here when it's done.

The script at https://www.msapiro.net/scripts/clean_users.py has been updated. As before, it has settings to control whether Django users are deleted if there is a corresponding Mailman user with no memberships or only if there is no corresponding Mailman user, and whether or not Mailman users with no memberships are deleted.

The difference is when deleting Mailman users it will now delete Mailman users with no memberships whether or not there is a corresponding Django user.

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

/ I saw output like:/

<User "Real Name1" (250400693957149667060114911620088407125) at 0x7f9435096640> deleted from Mailman <User "Real Name2" (52978839424924170731978420609240089133) at 0x7f9435096760> deleted from Mailman

So your users had no real names configured?

Cheers, Eggert

Am Dienstag, 25. April 2023, 23:14:27 CEST schrieb Andrew Hodgson:

Mark Sapiro wrote:

...

The script at https://www.msapiro.net/scripts/clean_users.py has been updated. As before, it has settings to control whether Django users are deleted if there is a corresponding Mailman user with no memberships or only if there is no corresponding Mailman user, and whether or not Mailman users with no >memberships are deleted. Thanks, I ran this script and it did delete a load of Mailman users, I got output similar to this: <User "" (47600399411039288509336192576257642185) at 0x7fb17a6a35e0> deleted from Mailman

Why aren't we seeing the actual address here?

Thanks. Andrew.

---

Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message /BTJUT6FGNGK5ARADPD6VW37VMHQG2GWJ/

This message sent to eggert@eehmke.de

Mailman's content filtering has removed the following MIME parts from this message.

Replaced multipart/alternative part with first alternative.

On 4/25/23 2:14 PM, Andrew Hodgson wrote:

Mark Sapiro wrote:

...

The script at https://www.msapiro.net/scripts/clean_users.py has been updated. As before, it has settings to control whether Django users are deleted if there is a corresponding Mailman user with no memberships or only if there is no corresponding Mailman user, and whether or not Mailman users with no >memberships are deleted.

Thanks, I ran this script and it did delete a load of Mailman users, I got output similar to this: <User "" (47600399411039288509336192576257642185) at 0x7fb17a6a35e0> deleted from Mailman

Why aren't we seeing the actual address here?

That was a choice I made. you could change

             with transaction():
                 user_manager.delete_user(mm_user)
                 print(f'{mm_user} deleted from Mailman')

to

             with transaction():
                 try:
                     email = user.preferred_address.email
                 except AttributeError:
                     email = 'no_preferred_address'
                 user_manager.delete_user(mm_user)
                 print(f'{email} deleted from Mailman')

to display the email address from the user's preferred_address if the user has one. All users should have one, but I've seen cases where there isn't one.

It could also be

                     email = user.addresses[0].email

which might be better.

In the above case, the empty string, "", is the user's display_name which in this case is empty, and the number in parentheses is the UUID of the user expressed as a decimal integer which isn't really useful. My thought was the display_name was as useful as anything, but obviously not if it's empty.

I actually started with the preferred_address.email code above, but in testing, I got the 'no_preferred_address' result with the one deleted user so I, perhaps erroneously, went with the representation of the user. I'll probably update the script again.

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

Andrew - The script had:

DELETE_MAILMAN_USER = False

When I set it to True, it got rid of the orphaned email addresses. Thanks! - Mark

On 4/25/2023 6:02 AM, Andrew Hodgson wrote:

Mark London wrote:

...

I added some email addresses manually to a mailing list and then removed them.   But now I can't find how to totally remove them from mailman3. They show up in the Users list. You may find this script useful: https://www.msapiro.net/scripts/clean_users.py

I have it running in a cronjob. Thread discussing the script can be found here:

https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/G...

TLDR you end up with orphaned Django users both from when users subscribe/unsubscribe and due to spam signups using the Postorius form which never get confirmed.

Thanks. Andrew.