[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Getting ftp-master mails as sponsor

On Tue, May 08, 2007 at 01:18:11AM +0200, Joerg Jaspert wrote:
> On 11013 March 1977, Roberto C. Sánchez wrote:

> >> This would need a new field defined in some sane way and then get
> >> enforced to use to make sense. And then the scripts can start using it.
> >> So the simple(r) option is "subscribe to pts".
> > Doesn't the key used to sign the upload tell you?

> Yes, then I know the key. What do I do with keys like the following
> (which are fine and valid and stuff) where the primary UID is without a
> mail:

> gpg --list-keys 94c09c7f
> pub   1024D/94C09C7F 1999-11-10
> uid                  Peter Palfrader
> uid                  Weasel <weasel@netalive.org>
> uid                  Peter Palfrader <weasel@debian.org>
> uid                  Peter Palfrader <peter@palfrader.org>
> uid                  Peter Palfrader <ppalfrad@cosy.sbg.ac.at>
> uid                  [jpeg image of size 7974]
> sub   1024D/AFA44BDD 2003-07-09 [expires: 2008-08-02]
> sub   2048g/E8F4A328 2003-07-09 [expires: 2008-08-02]

> Pick a random uid? Send no mail? Send mail to all?
> And no, simply "pick @debian.org" doesnt work, people may have chosen to
> deactivate that address because they use something different for all
> their debian activity now.

SELECT m.name
FROM fingerprint f LEFT JOIN uid u ON f.uid=u.id
LEFT JOIN source s ON f.id=s.sig_fpr
LEFT JOIN maintainer m ON s.maintainer=m.id
WHERE f.fingerprint='$yourvarhere' AND m.name LIKE '%' || u.uid || '%'
ORDER BY install_date DESC LIMIT 1;

obviously ;-)

Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
vorlon@debian.org                                   http://www.debian.org/

Reply to: