Обсуждение: 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
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. > regards, tom lane >
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 <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 >> >
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! > >> >> 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 >>>> >>> >> >> > >
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