From owner-freebsd-ports-bugs@freebsd.org Sat Feb 20 00:30:17 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 D942754691B for ; Sat, 20 Feb 2021 00:30:17 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (mailman.nyi.freebsd.org [IPv6:2610:1c1:1:606c::50:13]) by mx1.freebsd.org (Postfix) with ESMTP id 4Dj8VK5cw0z3qxy for ; Sat, 20 Feb 2021 00:30:17 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id C0E195468E0; Sat, 20 Feb 2021 00:30:17 +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 C0A9954691A for ; Sat, 20 Feb 2021 00:30:17 +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 4Dj8VK516sz3r1l for ; Sat, 20 Feb 2021 00:30:17 +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 9F40515A40 for ; Sat, 20 Feb 2021 00:30:17 +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 11K0UH2h086493 for ; Sat, 20 Feb 2021 00:30:17 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 11K0UHnK086492 for ports-bugs@FreeBSD.org; Sat, 20 Feb 2021 00:30:17 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: Sat, 20 Feb 2021 00:30:18 +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: Sat, 20 Feb 2021 00:30:17 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D252420 --- Comment #6 from Markus Kohlmeyer --- According to PHP Bugtrcker all known related bugs should be fixed since 7.4= .2 (Feb 2020): https://bugs.php.net/bug.php?id=3D79011 https://bugs.php.net/bug.php?id=3D76243 https://bugs.php.net/bug.php?id=3D78981 So even mysqlnd should be able to use caching_sha2_password since 7.4.2. I suggested using the native mysqllib as opposed to mysqlnd, as mysqllib co= mes directly from MySQL and does not have nor had the PHP bugs. And when mysqllib fails, then every other MySQL-Client inclusive MySQLs own= one fails and any related bug would be fixed asap by Oracle. It's always better to use an original than an imitation... To answer your question: No, currently i don't have a spare system to test this, but as i wrote above, Oracle would put such bugs on highest (very fir= st) priority as it would effect every single installation out there, not only s= ome crappy third-party client-implementations. And yes, openssl should be the only (and mandatory) ssl-library to link aga= inst (both PHP and MySQL). openssl from base is enough. --=20 You are receiving this mail because: You are the assignee for the bug.=