Re: extract properties from certificates

Am 25.02.2018 um 16:42 schrieb Adrian Klaver:
> On 02/25/2018 12:26 AM, jotpe wrote:
>> I could compile the pg-cert extension package, but postgresql 9.6
>> refused to install it.
>>
>> create extension cert;
>> FEHLER:  geschachteltes CREATE EXTENSION wird nicht unterstützt
>> means "ERROR: nested CREATE EXTENSION is not supported"
>>
>> At line 12 in /usr/share/postgresql/9.6/extension/cert--0.1.1.sql
>> another extension called bignum is created.
>> As a short try, I tryed to install in seperatly. I commentent that
>> out, git cloned the https://github.com/beargiles/pg-bignum project,
>> make and make install leads to an error, but the extension files are
>> available in the extensions directory:
>>
>>   sudo make install
>> /bin/mkdir -p '/usr/share/postgresql/9.6/extension'
>> /bin/mkdir -p '/usr/share/postgresql/9.6/extension'
>> /bin/mkdir -p '/usr/lib/postgresql/9.6/lib'
>> /bin/mkdir -p '/usr/share/doc/postgresql-doc-9.6/extension'
>> /usr/bin/install -c -m 644 .//bignum.control
>> '/usr/share/postgresql/9.6/extension/'
>> /usr/bin/install -c -m 644 .//sql/bignum--0.8.0.sql
>> .//sql/bignum--0.8.0.sql  '/usr/share/postgresql/9.6/extension/'
>> /usr/bin/install: Neu erstelltes
>> '/usr/share/postgresql/9.6/extension/bignum--0.8.0.sql' wird nicht mit
>> './/sql/bignum--0.8.0.sql' überschrieben.
>> /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk:114: die Regel
>> für Ziel „install“ scheiterte
>> make: *** [install] Fehler 1
>>
>> I could not create the bignum extension in my database:
>>
>> create extension bignum;
>> FEHLER:  konnte nicht auf Datei »bignum« zugreifen: Datei oder
>> Verzeichnis nicht gefunden
>> means "ERROR: could not access file "bignum": File or directory not
>> found"
>>
>>
>> Has anybody anybody an idea, how to fix this,
>> or maybe another aproach to extract properties from X.509 certificates?
>
> See here:
>
> https://github.com/beargiles/pg-bignum/pull/3
>
> in particular:
>
> https://github.com/beargiles/pg-bignum/pull/3/commits/d496a091929b15dbc0cc6ece40b0ba7bf091c8ec
>
>
> which changes line 21 in Makefile from
>
> DATA = $(wildcard sql/*--*.sql) sql/$(EXTENSION)--$(EXTVERSION).sql
>
> to
>
> DATA = $(wildcard sql/*--*.sql)
>
> This should eliminate this:
>
> /usr/bin/install: Neu erstelltes
> '/usr/share/postgresql/9.6/extension/bignum--0.8.0.sql' wird nicht mit
> './/sql/bignum--0.8.0.sql' überschrieben.
> /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk:114: die Regel
> für Ziel „install“ scheiterte
> make: *** [install] Fehler 1
>
> and allow the install to complete.

That worked. Thank you!

>
>>
>> Beste Regards Johannes
>>
>>
>>
>> Am 24.02.2018 um 19:07 schrieb jotpe:
>>>
>>>
>>> Am 24.02.2018 um 16:58 schrieb Tom Lane:
>>>> jotpe <jotpe(at)posteo(dot)de> writes:
>>>>> I found the pg-cert extension at https://github.com/beargiles/pg-cert
>>>>> I have trouble to compile it. When I enter "make" following error
>>>>> message appears:
>>>>> Makefile:29: /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk:
>>>>> Datei oder Verzeichnis nicht gefunden
>>>>> make: *** Keine Regel, um
>>>>> „/usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk“ zu erstellen.
>>>>> Schluss.
>>>>
>>>>> What am I missing?
>>>>
>>>> I'd expect pgxs.mk to be packaged in a postgresql-devel (or
>>>> postgresql-dev, depending on local culture) subpackage.  Maybe you
>>>> didn't
>>>> install that?
>>>
>>> Guessed right. postgresql-server-dev-all for debian 9 did it. Thanks.
>>>
>>>>             regards, tom lane
>>>>
>>>
>>
>>
>
>