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@posteo.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
>>>>
>>>
>>
>>
> 
>