-=| Damyan Ivanov, Wed, Aug 10, 2011 at 02:42:51PM +0300 |=-
> Since I replaced my key in the debian keyring, I am unable to 
> complete uploads to the archive. I gen the 'Processing' mail, but 
> then get neither 'ACCEPTED' nor 'REJECTED' mails.
> 
> Ansgar was kind to point me to the following anomaly in projectb:

A shorter dump (six keys have no associated uid):

dmn@ries:~$ psql service=projectb -c 'SELECT fingerprint FROM fingerprint WHERE 
uid IS NULL'
               fingerprint                
------------------------------------------
 F099A5F4B77CD6F66A992E6C7B9DBAD42A7E0F3D
 AEA0C44ECB056E93630D9D33DBBE9D4D99D2A004
 BF18695797741DB24E59188FC61A64DCF1393998
 4900707DDC5C07F2DECB02839C31503C6D866396
 CC1A2FE476FE444ACD23A5CD26E98AEAFA1E5292
 2655978EA053D586597FE5D63FB9C78A53C854DF
(6 rows)

The root cause was in the import of the new keys in LDAP (see 
rt.debian.org #3344). That got fixed now, but projectb still needs to 
be updated, it seems.

Here is the SQL (please verify before running :) )

-- this key is unknown to LDAP :|
-- keyservers and debian-keyring.gpg say it belongs to Shane Wegner
-- <[email protected]>, for whom LDAP has a different key (belonging
-- to another DD, oh my! I'll -- file yet another ticket with
-- keyring-maint)
-- update projectb set uid='shane'
-- where fingerprint='F099A5F4B77CD6F66A992E6C7B9DBAD42A7E0F3D';

-- Damyan Ivanov
update projectb set uid='dmn'
where fingerprint='AEA0C44ECB056E93630D9D33DBBE9D4D99D2A004';

-- Pierre Chifflier
update projectb set uid='pollux'
where fingerprint='BF18695797741DB24E59188FC61A64DCF1393998';

-- Stefano Zacchiroli
update projectb set uid='zack'
where fingerprint='4900707DDC5C07F2DECB02839C31503C6D866396';

-- Julien Blache
update projectb set uid='jblache'
where fingerprint='CC1A2FE476FE444ACD23A5CD26E98AEAFA1E5292';

-- Andres Mejia
update projectb set uid='amejia'
where fingerprint='2655978EA053D586597FE5D63FB9C78A53C854DF';


I hope this saves you some time.

Attachment: signature.asc
Description: Digital signature

Reply via email to