Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 13 Sep 2023 05:10:12 +0200
From:      ft <ml@ft-c.de>
To:        stable@FreeBSD.org
Subject:   Re: postgresql pg_curl bug? (solved)
Message-ID:  <777dbb239c8c5b39168c1f75beeb499c56953b3c.camel@ft-c.de>
In-Reply-To: <ddb8888cae16ed64029056f0a030039f4897c139.camel@ft-c.de>
References:  <ddb8888cae16ed64029056f0a030039f4897c139.camel@ft-c.de>

next in thread | previous in thread | raw e-mail | index | archive | help
Hallo,=20

the solution:
today I have deinstall all dependencies and=C2=A0
reinstall the package libidn2 from ports.


On Sun, 2023-09-03 at 05:54 +0200, ft wrote:
> Hello,
>=20
> I have install postgresql15 in jail.
> I need the postgresql extension pg_curl.
>=20
> cd pg_curl-2.1.1/
> gmake install
> cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-
> statement -Werror=3Dvla -Werror=3Dunguarded-availability-new -Wendif-
> labels
> -Wmissing-format-attribute -Wcast-function-type -Wformat-security -
> fno-
> strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-
> compound-token-split-by-macro -O2 -pipe=C2=A0 -fstack-protector-strong -
> fno-
> strict-aliasing=C2=A0 -fPIC -DPIC -I. -I./ -
> I/usr/local/include/postgresql/server -
> I/usr/local/include/postgresql/internal=C2=A0 -I/usr/local/include -
> I/usr/local/include -I/usr/local/include=C2=A0 -c -o pg_curl.o pg_curl.c
> cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-
> statement -Werror=3Dvla -Werror=3Dunguarded-availability-new -Wendif-
> labels
> -Wmissing-format-attribute -Wcast-function-type -Wformat-security -
> fno-
> strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-
> compound-token-split-by-macro -O2 -pipe=C2=A0 -fstack-protector-strong -
> fno-
> strict-aliasing=C2=A0 -fPIC -DPIC -shared -o pg_curl.so pg_curl.o -
> L/usr/local/lib=C2=A0=C2=A0 -L/usr/local/lib -lpthread -L/usr/local/lib=
=C2=A0 -
> fstack-
> protector-strong=C2=A0=C2=A0 -L/usr/local/lib -Wl,--as-needed -Wl,-
> R'/usr/local/lib'=C2=A0 -lcurl
> /bin/mkdir -p '/usr/local/lib/postgresql'
> /bin/mkdir -p '/usr/local/share/postgresql/extension'
> /bin/mkdir -p '/usr/local/share/postgresql/extension'
> /usr/bin/install -c -m 755=C2=A0 pg_curl.so
> '/usr/local/lib/postgresql/pg_curl.so'
> /usr/bin/install -c -m 644 .//pg_curl.control
> '/usr/local/share/postgresql/extension/'
> /usr/bin/install -c -m 644 .//pg_curl--1.0--2.0.sql .//pg_curl--
> 1.0.sql
> .//pg_curl--2.0--2.1.sql .//pg_curl--2.0.sql .//pg_curl--2.1.sql=20
> '/usr/local/share/postgresql/extension/'
>=20
> find /usr -name "*pg_curl*"
> /usr/local/share/postgresql/extension/pg_curl--2.0.sql
> /usr/local/share/postgresql/extension/pg_curl.control
> /usr/local/share/postgresql/extension/pg_curl--2.1.sql
> /usr/local/share/postgresql/extension/pg_curl--2.0--2.1.sql
> /usr/local/share/postgresql/extension/pg_curl--1.0.sql
> /usr/local/share/postgresql/extension/pg_curl--1.0--2.0.sql
>=20
>=20
> In postgresql, the command:
> =C2=A0create extension pg_curl;
> get the errormessage:
>=20
> ftc=3D# create extension pg_curl;
> FEHLER:=C2=A0 konnte Bibliothek =C2=BB/usr/local/lib/postgresql/pg_curl.s=
o=C2=AB
> nicht
> laden: /usr/local/lib/libidn2.so.0: Undefined symbol "strversc
> mp@FBSD_1.7"
>=20
> libidn2 is installed:
>=20
> ls -l /usr/local/lib/libidn2*
> root=C2=A0 wheel=C2=A0 281986 Feb=C2=A0 9=C2=A0 2023 /usr/local/lib/libid=
n2.a
> root=C2=A0 wheel=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 16 Feb=C2=A0 9=C2=A0 2023 =
/usr/local/lib/libidn2.so ->
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 libidn2.so.0.3.8
> root=C2=A0 wheel=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 16 Feb=C2=A0 9=C2=A0 2023 =
/usr/local/lib/libidn2.so.0 ->
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 libidn2.so.0.3.8
> root=C2=A0 wheel=C2=A0 202256 Feb=C2=A0 9=C2=A0 2023 /usr/local/lib/libid=
n2.so.0.3.8
>=20
> uname -a
> FreeBSD ftc 13.2-RELEASE-p2 FreeBSD 13.2-RELEASE-p2 GENERIC amd64
>=20
> Do you need more information?
> What should I do?
>=20
> Franz
>=20
>=20
>=20
>=20




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?777dbb239c8c5b39168c1f75beeb499c56953b3c.camel>