Re: extract properties from certificates

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.

> 
> 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
>>>
>>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com