From owner-freebsd-ports-bugs@freebsd.org Wed Feb 24 11:31:16 2021 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 330D1559432 for ; Wed, 24 Feb 2021 11:31:16 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 4Dltz80mwNz4rWP for ; Wed, 24 Feb 2021 11:31:16 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id 1878855949C; Wed, 24 Feb 2021 11:31:16 +0000 (UTC) Delivered-To: ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 183C7559431 for ; Wed, 24 Feb 2021 11:31:16 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (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 "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Dltz803myz4rYT for ; Wed, 24 Feb 2021 11:31:16 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (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 did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id E97992BA81 for ; Wed, 24 Feb 2021 11:31:15 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 11OBVFC9038032 for ; Wed, 24 Feb 2021 11:31:15 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 11OBVFRp038031 for ports-bugs@FreeBSD.org; Wed, 24 Feb 2021 11:31:15 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 252420] 'caching_sha2_password' support missing in PHP port, limits MySQL 8 compatibility Date: Wed, 24 Feb 2021 11:31:16 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: rootservice@gmail.com X-Bugzilla-Status: In Progress X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 24 Feb 2021 11:31:16 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D252420 --- Comment #19 from Markus Kohlmeyer --- OK, possibly we both misunderstood eaachother a bit, sorry for that. This gives me ldd on my system now: [root@devgate:~] # ldd /usr/local/bin/php /usr/local/bin/php: libcrypt.so.5 =3D> /lib/libcrypt.so.5 (0x80075b000) libargon2.so.0 =3D> /usr/local/lib/libargon2.so.0 (0x80077c000) libutil.so.9 =3D> /lib/libutil.so.9 (0x80078a000) libm.so.5 =3D> /lib/libm.so.5 (0x8007a2000) libthr.so.3 =3D> /lib/libthr.so.3 (0x8007d4000) libxml2.so.2 =3D> /usr/local/lib/libxml2.so.2 (0x800801000) libc.so.7 =3D> /lib/libc.so.7 (0x80099a000) libz.so.6 =3D> /lib/libz.so.6 (0x800d86000) liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x800da2000) libmd.so.6 =3D> /lib/libmd.so.6 (0x800dce000) [root@devgate:~] # ldd /usr/local/lib/php/20200930-zts/mysqli.so /usr/local/lib/php/20200930-zts/mysqli.so: libmysqlclient.so.21 =3D> /usr/local/lib/mysql/libmysqlclient.so.21 (0x801c00000) libz.so.6 =3D> /lib/libz.so.6 (0x8014b2000) libzstd.so.1 =3D> /usr/local/lib/libzstd.so.1 (0x8014ce000) libm.so.5 =3D> /lib/libm.so.5 (0x8015c4000) librt.so.1 =3D> /usr/lib/librt.so.1 (0x8015f6000) libexecinfo.so.1 =3D> /usr/lib/libexecinfo.so.1 (0x8022b2000) libunwind.so.8 =3D> /usr/local/lib/libunwind.so.8 (0x8022b8000) libssl.so.11 =3D> /usr/local/lib/libssl.so.11 (0x8022d2000) libcrypto.so.11 =3D> /usr/local/lib/libcrypto.so.11 (0x802368000) libthr.so.3 =3D> /lib/libthr.so.3 (0x80265b000) libc.so.7 =3D> /lib/libc.so.7 (0x80106f000) libc++.so.1 =3D> /usr/lib/libc++.so.1 (0x802688000) libcxxrt.so.1 =3D> /lib/libcxxrt.so.1 (0x802756000) libgcc_s.so.1 =3D> /lib/libgcc_s.so.1 (0x802778000) libelf.so.2 =3D> /lib/libelf.so.2 (0x802792000) liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x8027ae000) libmd.so.6 =3D> /lib/libmd.so.6 (0x8027da000) [root@devgate:~] # ldd /usr/local/lib/php/20200930-zts/pdo_mysql.so /usr/local/lib/php/20200930-zts/pdo_mysql.so: libmysqlclient.so.21 =3D> /usr/local/lib/mysql/libmysqlclient.so.21 (0x801c00000) libz.so.6 =3D> /lib/libz.so.6 (0x801498000) libzstd.so.1 =3D> /usr/local/lib/libzstd.so.1 (0x8014b4000) libm.so.5 =3D> /lib/libm.so.5 (0x8015aa000) librt.so.1 =3D> /usr/lib/librt.so.1 (0x8015dc000) libexecinfo.so.1 =3D> /usr/lib/libexecinfo.so.1 (0x8015e5000) libunwind.so.8 =3D> /usr/local/lib/libunwind.so.8 (0x8022b2000) libssl.so.11 =3D> /usr/local/lib/libssl.so.11 (0x8022cc000) libcrypto.so.11 =3D> /usr/local/lib/libcrypto.so.11 (0x802362000) libthr.so.3 =3D> /lib/libthr.so.3 (0x802655000) libc.so.7 =3D> /lib/libc.so.7 (0x80106f000) libc++.so.1 =3D> /usr/lib/libc++.so.1 (0x802682000) libcxxrt.so.1 =3D> /lib/libcxxrt.so.1 (0x802750000) libgcc_s.so.1 =3D> /lib/libgcc_s.so.1 (0x802772000) libelf.so.2 =3D> /lib/libelf.so.2 (0x80278c000) liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x8027a8000) libmd.so.6 =3D> /lib/libmd.so.6 (0x8027d4000) [root@devgate:~] # So, if i understand it correct, it means that only the mysqli/pdo_mysql extensions need the OpenSSL and not lang/php[74|80] itself. As you said, that would not be problem, so i suggest to add OpenSSL as a run/build-dependency to only the two extensions, but not php itself. I'm unsure if that also helps for MYSQLND, that should be tested by someone else, but for libmysql it works. Maybe MYSQLND should be switched to non-default by now and libmysql from databases/mysql[57|80]-client should be another run/build-dependency for the mysqli/pdo_mysql extensions instead. HTH --=20 You are receiving this mail because: You are the assignee for the bug.=