list of maintainers in dm acl that no longer are in the keyring:

last update: Sun, 19 May 2024 07:52:01 +0000


  SELECT f.fingerprint, f.keyring IS NOT NULL AS in_a_keyring, u.name, u.uid
    FROM fingerprint f
    LEFT JOIN uid u ON f.uid = u.id
   WHERE
       EXISTS (SELECT 1 FROM acl_per_source
                WHERE fingerprint_id = f.id
                  AND acl_id = (SELECT id FROM acl WHERE name = 'dm'))
   AND (f.keyring != (SELECT id FROM keyrings WHERE name = '/srv/keyring.debian.org/keyrings/debian-maintainers.gpg') OR f.keyring IS NULL)
   ORDER BY f.fingerprint


               fingerprint                | in_a_keyring |            name            |              uid               
------------------------------------------+--------------+----------------------------+--------------------------------
 16AD29CF574AD0206F9961E02CF0F17C43474B6F | t            | Raúl Benencia             | rul@kalgan.cc
 2C429F5DD6B7F023BD300993453F8D999F113609 | t            | Phil Morrell               | debian@emorrp1.name
 3A20813CA57946868C5152115AC61074C5E81BC4 | t            | Hugh McMaster              | hugh.mcmaster@outlook.com
 496AC6E814424B348508352959F187CA156EB076 | t            | Holger Wansing             | holgerw
 5792F66164D057EFC6D06FAF5B8AD6F4C26ADDDD | f            | Thomas Ward                | teward@ubuntu.com
 59472423E07FE30FD47A8BB7925252C459797A1D | t            | Hanno Wagner               | wagner
 6E58CA48BEAEF11C0345205EEC3C80BC57319B7E | t            | Timothy Pearson            | tpearson@raptorengineering.com
 7A1FB5279B88D54BD4F42300F536AA70111D5716 | t            | Judit Foglszinger          | urbec
 86A5ABD6FFDB0A0C7F5057D34797FA721C351C9E | t            | Francois Mazen             | francois@mzf.fr
 8F930BD1934C3E2140A258790747BD39BCFCAAAA | f            | Rogério Theodoro de Brito | rbrito@ime.usp.br
 8FB9C5D6AE7BA82B7BB1D887C51EA7006E6BDC0D | f            | Taowa                      | taowa
 B008D750B6B78361ED5356F0DAB389329A4CFA16 | t            | Ross Vandegrift            | rvandegrift
 C603FC4E600F1CECD1C8D97C4B53D931E4D3E863 | t            | Andrew Ruthven             | andrew@etc.gen.nz
 D5D568B2D34AB32A337944D22EC3F60DE71C0B9D | t            | James Lu                   | james@overdrivenetworks.com
 DB667AE2E7C792EF6374EFDF39C9A0B640262AF0 | f            | Sergey B Kirpichev         | skirpichev@gmail.com
 FED5434845287DF262931489CFBBFCE0B74F1B14 | t            | Yao Wei                    | mwei@lxde.org
(16 rows)