Per Jessen wrote:
Lars Vogdt wrote:
Am May 6, 2021 2:16:45 PM UTC schrieb Per Jessen <per@opensuse.org>:
https://progress.opensuse.org/news/89 ... => 10,000 locked accounts in Jan 2020 and growing
That was really my only concern, but I figured it would easy to set up some regular clean-up job. What is the database, galera ?
Yes. In the end, it should be an easy sql query to generate a list for our spam filter...
That too, yes. It would also show if blocking any address is worth it :-)
I'll check it out.
I looked at the redmine database and made some educated guesses - we have some 50'000 addresses, but only actually 17'000 users - somehow many are triplicated in table 'email_addresses'. In the 'users' table I have assumed status=3 to mean 'blocked', which is 12697 users. Of those, I see 20 with suse.com, 64 with opensuse.org (mostly lists) and 13 with suse.de and suse.cz addresses. I have taken the 12'697 addresses, excluded the various suse/opensuse addresses and created warnings on mx[12] for those addresses - let us check back in a month or so. -- Per Jessen, Zürich (10.3°C) Member, openSUSE Heroes