On Sun, Aug 09, 2009 at 09:52:23AM +0100, Filippo Giunchedi wrote: > On Wed, Aug 05, 2009 at 07:41:17PM -0700, Ryan Niebur wrote: > > Package: qa.debian.org > > Severity: normal > > User: qa.debian.org@packages.debian.org > > 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 > I was talking about the one that that SQL query shows. > $ zgrep -A12 libopenid-ruby * | grep -i signed > debian-devel-changes.200712.gz:Signed-By: Paul van Tilburg <paul@luon.net> > debian-devel-changes.200803.gz:Signed-By: Antonio Terceiro <terceiro@softwarelivre.org> > debian-devel-changes.200807.gz:Signed-By: Antonio Terceiro <terceiro@softwarelivre.org> > debian-devel-changes.200905.gz:Signed-By: Antonio Terceiro <terceiro@softwarelivre.org> > debian-devel-changes.200907.gz:Signed-By: Lucas Nussbaum <lucas@lucas-nussbaum.net> > > 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 <phil@0x539.de> > uid Philipp Kern <phil@philkern.de> > uid Philipp Kern <pkern@debian.org> > uid Philipp Kern <pkern@ubuntu.com> > uid Philipp Kern <philipp.kern@fsmi.uni-karlsruhe.de> > > I'm not sure how to fix this though, I'm relying on gpgv output > well the parsing is clearly broken... the name should be "Philipp Kern" and the email address should be empty. -- _________________________ Ryan Niebur ryanryan52@gmail.com
Attachment:
signature.asc
Description: Digital signature