extract properties from certificates
Hello, I want to extract properties from x.509 certificates stored in a bytea column. 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? Best regards Johannes
Re: extract properties from certificates
Am 24.02.2018 um 16:58 schrieb Tom Lane: jotpe 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
Re: extract properties from certificates
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: Am 24.02.2018 um 16:58 schrieb Tom Lane: jotpe 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
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 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
