Re: postgresql pg_curl bug? (solved)

Hallo, 

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


On Sun, 2023-09-03 at 05:54 +0200, ft wrote:
> Hello,
> 
> I have install postgresql15 in jail.
> I need the postgresql extension pg_curl.
> 
> cd pg_curl-2.1.1/
> gmake install
> cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-
> statement -Werror=vla -Werror=unguarded-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  -fstack-protector-strong -
> fno-
> strict-aliasing  -fPIC -DPIC -I. -I./ -
> I/usr/local/include/postgresql/server -
> I/usr/local/include/postgresql/internal  -I/usr/local/include -
> I/usr/local/include -I/usr/local/include  -c -o pg_curl.o pg_curl.c
> cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-
> statement -Werror=vla -Werror=unguarded-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  -fstack-protector-strong -
> fno-
> strict-aliasing  -fPIC -DPIC -shared -o pg_curl.so pg_curl.o -
> L/usr/local/lib   -L/usr/local/lib -lpthread -L/usr/local/lib  -
> fstack-
> protector-strong   -L/usr/local/lib -Wl,--as-needed -Wl,-
> R'/usr/local/lib'  -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  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 
> '/usr/local/share/postgresql/extension/'
> 
> 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
> 
> 
> In postgresql, the command:
>  create extension pg_curl;
> get the errormessage:
> 
> ftc=# create extension pg_curl;
> FEHLER:  konnte Bibliothek »/usr/local/lib/postgresql/pg_curl.so«
> nicht
> laden: /usr/local/lib/libidn2.so.0: Undefined symbol "strversc
> mp@FBSD_1.7"
> 
> libidn2 is installed:
> 
> ls -l /usr/local/lib/libidn2*
> root  wheel  281986 Feb  9  2023 /usr/local/lib/libidn2.a
> root  wheel      16 Feb  9  2023 /usr/local/lib/libidn2.so ->
>         libidn2.so.0.3.8
> root  wheel      16 Feb  9  2023 /usr/local/lib/libidn2.so.0 ->
>         libidn2.so.0.3.8
> root  wheel  202256 Feb  9  2023 /usr/local/lib/libidn2.so.0.3.8
> 
> uname -a
> FreeBSD ftc 13.2-RELEASE-p2 FreeBSD 13.2-RELEASE-p2 GENERIC amd64
> 
> Do you need more information?
> What should I do?
> 
> Franz
> 
> 
> 
>