openSUSE admin

mailman=> select address_id,delivery_status,ml.list_id from member m,preferences p,address a,mailinglist ml where m.preferences_id=p.id and m.address_id=a.id and ml.list_id=m.list_id and email='redacted@gmail.com';
 address_id | delivery_status |             list_id             
------------+-----------------+---------------------------------
       1342 |               1 | announce.lists.opensuse.org
       1342 |               1 | programming.lists.opensuse.org
       1342 |               4 | support.lists.opensuse.org
       1342 |               1 | virtual.lists.opensuse.org
       1342 |               1 | buildservice.lists.opensuse.org
       1342 |               1 | users.lists.opensuse.org
       1342 |               3 | arm.lists.opensuse.org
       1342 |               3 | factory.lists.opensuse.org
       1342 |               3 | offtopic.lists.opensuse.org
(9 rows)

The 'delivery_status 3' above is disabled by bounces.

Hi,

someone joined #opensuse-admin stating the following:

10:20 <kilian> i somehow got unregistered from opensuse factory

Is it related to this?

crameleon wrote in #note-3:

Hi,

someone joined #opensuse-admin stating the following:

10:20 <kilian> i somehow got unregistered from opensuse factory

Is it related to this?

"kilian" here. Yes.

I received the following email on 08.12 17.22 German time.:

Your subscription has been disabled on the factory@lists.opensuse.org mailing list
because it has received a number of bounces indicating that there may
be a problem delivering messages to ${EMAIL}  You may want to
check with your mail administrator for more help.

If you have any questions or problems, you can contact the mailing
list owner at

    factory-owner@lists.opensuse.org

pjessen wrote in #note-1:

I feel fairly certain people will be asked to confirm, which is a slight nuisance. I'm going to have a look at maybe just updating the database.

Just sending a join request does nothing - it confirms if the sender is already a member.
In mailman2, there was a way to do this via listname-request with subject set delivery on.

These updates will reset all "Disabled by bounces" subscriptions to 'unset':

awk '{print $9}'  mailman3-disabled.lst | sort -u |\
xargs printf "update preferences set delivery_status=null where id in (select p.id from member m,preferences p,address a,mailinglist ml where m.preferences_id=p.id and m.address_id=a.id and ml.list_id=m.list_id and email='%s' and delivery_status=3);\n"