From nobody Sun Sep 03 03:54:53 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 4RddFY5pnqz4s4vN for ; Sun, 3 Sep 2023 03:54:57 +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 4RddFX5h4Sz4HLQ for ; Sun, 3 Sep 2023 03:54:56 +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 3833sruk076064 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Sun, 3 Sep 2023 05:54:54 +0200 Message-ID: Subject: postgresql pg_curl bug? From: ft Reply-To: ml@ft-c.de To: stable@FreeBSD.org Date: Sun, 03 Sep 2023 05:54:53 +0200 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 [-0.08 / 15.00]; SUBJECT_ENDS_QUESTION(1.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_SPAM_MEDIUM(0.92)[0.923]; NEURAL_HAM_SHORT(-0.60)[-0.601]; 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]; ONCE_RECEIVED(0.10)[]; RCVD_IN_DNSWL_LOW(-0.10)[192.109.42.8:from]; TO_MATCH_ENVRCPT_ALL(0.00)[]; FROM_HAS_DN(0.00)[]; HAS_REPLYTO(0.00)[ml@ft-c.de]; PREVIOUSLY_DELIVERED(0.00)[stable@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; DMARC_NA(0.00)[ft-c.de]; ARC_NA(0.00)[]; ASN(0.00)[asn:29670, ipnet:192.109.42.0/24, country:DE]; MLMMJ_DEST(0.00)[stable@FreeBSD.org]; TO_DN_NONE(0.00)[]; REPLYTO_ADDR_EQ_FROM(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; R_DKIM_NA(0.00)[]; RCVD_COUNT_ONE(0.00)[1]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; MID_RHS_MATCH_FROM(0.00)[]; RCVD_TLS_ALL(0.00)[] X-Rspamd-Queue-Id: 4RddFX5h4Sz4HLQ 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=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 -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=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 -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=20 '/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=3D# create extension pg_curl; FEHLER: konnte Bibliothek =C2=BB/usr/local/lib/postgresql/pg_curl.so=C2=AB= 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