Bug#540132: [UDD] has some strange information in the upload_history table
On Wed, Aug 05, 2009 at 07:41:17PM -0700, Ryan Niebur wrote:
> Package: qa.debian.org
> Severity: normal
> User: email@example.com
> Usertags: udd
> 23:08 < Ryan52> lucas: I was trying to find a list of all the people who have sponsored my uploads, and noticed that UDD's upload_history table has some strange data, could you please take a look at (or tell me w
> ho to complain to) the output of: SELECT * FROM upload_history WHERE changed_by_name LIKE 'Ryan Niebur' AND signed_by_name = ''
> 23:09 < Ryan52> ;
> 23:10 < Ryan52> lucas: oh, the problem with signed_by_name being empty for libopenid-ruby's upload was that a DM sponsored it. so I guess UDD (or wherever UDD gets this data from) does not take into account the D
> M keyring and it should?
> 23:14 < Ryan52> lucas: hm, and for the crip one, it seems that all uploads signed by phil do that. I'm guessing that because signed_by doesn't include his email address, the (presumably) regexp splitting it into
> signed_by_* is parsing it wrong. why it doesn't include his email address, I dunno...
> 23:26 * Ryan52 wonders if there's a place where bugs about UDD are supposed to be reported...
the upload-history data is taken (for now) from
http://qa.debian.org/~filippo/ddc/ and I couldn't find the wrong libopenid-ruby
you were talking about, DM keyring should be accounted for
$ zgrep -A12 libopenid-ruby * | grep -i signed
debian-devel-changes.200712.gz:Signed-By: Paul van Tilburg <firstname.lastname@example.org>
debian-devel-changes.200803.gz:Signed-By: Antonio Terceiro <email@example.com>
debian-devel-changes.200807.gz:Signed-By: Antonio Terceiro <firstname.lastname@example.org>
debian-devel-changes.200905.gz:Signed-By: Antonio Terceiro <email@example.com>
debian-devel-changes.200907.gz:Signed-By: Lucas Nussbaum <firstname.lastname@example.org>
for the other problem you are correct, the first uid for ED1A3933B2CFCDD8
doesn't contain an email:
$ gpg --list-keys ED1A3933B2CFCDD8
pub 1024D/B2CFCDD8 2003-01-08
uid Philipp Kern
uid Philipp Kern <email@example.com>
uid Philipp Kern <firstname.lastname@example.org>
uid Philipp Kern <email@example.com>
uid Philipp Kern <firstname.lastname@example.org>
uid Philipp Kern <email@example.com>
I'm not sure how to fix this though, I'm relying on gpgv output
Filippo Giunchedi - http://esaurito.net - 0x6B79D401
It is easier to write an incorrect program than understand a correct one.
-- Alan Perlis