From nobody Wed Sep 13 03:10:12 2023 X-Original-To: stable@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4RllnV5y17z4t2C8 for ; Wed, 13 Sep 2023 03:10:22 +0000 (UTC) (envelope-from ml@ft-c.de) Received: from einhorn-mail-out.in-berlin.de (einhorn.in-berlin.de [192.109.42.8]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mail.in-berlin.de", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4RllnT1jpGz4Yhn for ; Wed, 13 Sep 2023 03:10:21 +0000 (UTC) (envelope-from ml@ft-c.de) Authentication-Results: mx1.freebsd.org; dkim=none; spf=pass (mx1.freebsd.org: domain of ml@ft-c.de designates 192.109.42.8 as permitted sender) smtp.mailfrom=ml@ft-c.de; dmarc=none X-Envelope-From: ml@ft-c.de X-Envelope-To: Received: from authenticated.user (localhost [127.0.0.1]) by einhorn.in-berlin.de with ESMTPSA id 38D3AHs21669863 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Wed, 13 Sep 2023 05:10:17 +0200 Message-ID: <777dbb239c8c5b39168c1f75beeb499c56953b3c.camel@ft-c.de> Subject: Re: postgresql pg_curl bug? (solved) From: ft Reply-To: ml@ft-c.de To: stable@FreeBSD.org Date: Wed, 13 Sep 2023 05:10:12 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4 FreeBSD GNOME Team List-Id: Production branch of FreeBSD source code List-Archive: https://lists.freebsd.org/archives/freebsd-stable List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-stable@freebsd.org X-BeenThere: freebsd-stable@freebsd.org MIME-Version: 1.0 X-Spamd-Bar: --- X-Spamd-Result: default: False [-3.30 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-1.00)[-0.999]; NEURAL_HAM_MEDIUM(-0.91)[-0.906]; R_SPF_ALLOW(-0.20)[+ip4:192.109.42.0/24]; RWL_MAILSPIKE_GOOD(-0.10)[192.109.42.8:from]; MIME_GOOD(-0.10)[text/plain]; RCVD_IN_DNSWL_LOW(-0.10)[192.109.42.8:from]; ONCE_RECEIVED(0.10)[]; ARC_NA(0.00)[]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[stable@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; DMARC_NA(0.00)[ft-c.de]; MIME_TRACE(0.00)[0:+]; HAS_REPLYTO(0.00)[ml@ft-c.de]; SUBJECT_HAS_QUESTION(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; TO_DN_NONE(0.00)[]; REPLYTO_ADDR_EQ_FROM(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; MLMMJ_DEST(0.00)[stable@FreeBSD.org]; RCVD_COUNT_ONE(0.00)[1]; R_DKIM_NA(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; ASN(0.00)[asn:29670, ipnet:192.109.42.0/24, country:DE]; RCVD_TLS_ALL(0.00)[] X-Rspamd-Queue-Id: 4RllnT1jpGz4Yhn 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