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....@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 <p...@luon.net> > debian-devel-changes.200803.gz:Signed-By: Antonio Terceiro > <terce...@softwarelivre.org> > debian-devel-changes.200807.gz:Signed-By: Antonio Terceiro > <terce...@softwarelivre.org> > debian-devel-changes.200905.gz:Signed-By: Antonio Terceiro > <terce...@softwarelivre.org> > debian-devel-changes.200907.gz:Signed-By: Lucas Nussbaum > <lu...@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 <p...@0x539.de> > uid Philipp Kern <p...@philkern.de> > uid Philipp Kern <pk...@debian.org> > uid Philipp Kern <pk...@ubuntu.com> > uid Philipp Kern <philipp.k...@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 ryanrya...@gmail.com
signature.asc
Description: Digital signature
