extract properties from certificates

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?

regards, tom lane

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.

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?

Beste Regards Johannes

Am 24.02.2018 um 19:07 schrieb jotpe:

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

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!

On 02/25/2018 10:11 AM, jotpe wrote:

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!

The thanks is due to Evan Carroll:

https://github.com/EvanCarroll

Beste Regards Johannes

--
Adrian Klaver
adrian.klaver@aklaver.com