From owner-freebsd-ports-bugs@freebsd.org Fri Mar 26 16:00:52 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 C31E757B21C for ; Fri, 26 Mar 2021 16:00:52 +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 4F6RXN4sffz4rQT for ; Fri, 26 Mar 2021 16:00:52 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id A6F8257AFEF; Fri, 26 Mar 2021 16:00:52 +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 A6BB857B21A for ; Fri, 26 Mar 2021 16:00:52 +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 4F6RXN4F8qz4r8j for ; Fri, 26 Mar 2021 16:00:52 +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 84CA21D007 for ; Fri, 26 Mar 2021 16:00:52 +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 12QG0qWr057890 for ; Fri, 26 Mar 2021 16:00:52 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 12QG0qoE057889 for ports-bugs@FreeBSD.org; Fri, 26 Mar 2021 16:00:52 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: Fri, 26 Mar 2021 16:00:52 +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: tz@freebsd.org 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: Fri, 26 Mar 2021 16:00:52 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D252420 --- Comment #31 from Torsten Zuehlsdorff --- > But let's also not forget that something is already broken here. MySQL i= s very popular, and not working with its default password scheme is a kind = of 'broken' too. Yes, that is right, but it is not that bad. ;) MySQL works just fine right = now. If you choose to pick MySQL 8.0 however, it is "broken". The other "but" he= re: it is easily fixable by changing the config of MySQL. So yes, it is kind of broken and kind of usable at the same moment. It is unsatisfying but not trivial to fix. Especially not with different PHP and MySQL versions at the same time. Not to mention the really hard stuff around SSL. > Perhaps some numerical quantification would help measure the tradeoffs he= re. i.e. How much bigger? 1%? 10%? 100%? I can give you one, but this would be false by default. I get way fewer mails/issues/complaints than there are PHP+MySQL installations out there. :D Over the last years, I was constantly surprised by what issues came up and = how PHP+MySQL is used. But it is nothing I can judge while being fair. For exam= ple, I can name several contacts naming some specific config, which sound rare -= but all of them have a hosting business which hundreds or thousands of clients. --=20 You are receiving this mail because: You are the assignee for the bug.=