Re: pgcrypto: PGP signatures

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgcrypto: PGP signatures
Date: 2014-09-03 21:13:46
Message-ID: 5407848A.6020909@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2014-09-03 10:33 PM, Jeff Janes wrote:
> On Wed, Sep 3, 2014 at 12:43 PM, Marko Tiikkaja <marko(at)joh(dot)to> wrote:
>> Right. This patch only adds support for signing data when encrypting it
>> at the same time. There's no support for detached signatures, nor is there
>> support for anything other than signatures of encrypted data. I should
>> have been more clear on that in my initial email. :-(
>>
>>
> OK, thanks. How hard do you think it would to allow NULL (or empty
> string?) passwords to gpg_sym_signatures and gpg_sym_decrypt_verify to
> accommodate this?

To sign without encrypting? I think those should really be a different
set of functions altogether. But this patch is already humongous (on my
standards, at least), so I think that should be done separately.

> I think docs section F.25.3 needs to be re-titled and expanded to reflect
> signatures as well as encryption, and an explanation added about signatures
> only being processed on encrypted data if that restriction can't be removed.

I don't have an objection to that. I fully acknowledge that the
documentation doesn't state the limitations of signing should this patch
be applied.

> I've switched to using a signed plus symmetrically encrypted message for
> testing.
>
> One surprising thing so far is that the 3rd argument to
> gpg_sym_decrypt_verify must be dearmored. I thought it would detect and
> dearmor automatically.

I can't see that as an improvement to be honest.

> Once I wrap it in dearmor, I get the ERROR: No signature matching the key
> id present in the message
>
> The public key block I am giving it is for the keyid that is reported
> by pgp_sym_signatures, so I don't know what the problem might be.

Have you tried with the debug=1 option? (It's undocumented, but it was
like that before this patch and I didn't touch it).

> When I get more time, I'll look at your examples from the regression tests
> to see if I can figure it out.

Thanks! I'm happy to help if you run into any trouble!

.marko

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2014-09-03 21:14:17 Re: delta relations in AFTER triggers
Previous Message Peter Geoghegan 2014-09-03 21:13:00 Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}