From nobody Mon Apr 27 21:33:52 2026 X-Original-To: questions@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 4g4GzY5WsTz6bfYM for ; Mon, 27 Apr 2026 21:34:17 +0000 (UTC) (envelope-from freebsd@gushi.org) Received: from prime.gushi.org (prime.gushi.org [IPv6:2620:137:6000:10::142]) (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 ECDSA (secp384r1) client-digest SHA384) (Client CN "prime.gushi.org", Issuer "E8" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 4g4GzY21twz3cGs for ; Mon, 27 Apr 2026 21:34:17 +0000 (UTC) (envelope-from freebsd@gushi.org) Authentication-Results: mx1.freebsd.org; none Received: from smtpclient.apple (not.afront.org [50.126.75.182]) (authenticated bits=0) by prime.gushi.org (8.18.2/8.18.2) with ESMTPSA id 63RLY34w021284 (version=TLSv1.2 cipher=ECDHE-ECDSA-AES256-GCM-SHA384 bits=256 verify=NOT); Mon, 27 Apr 2026 21:34:03 GMT (envelope-from freebsd@gushi.org) DKIM-Filter: OpenDKIM Filter v2.10.3 prime.gushi.org 63RLY34w021284 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gushi.org; s=prime2014; t=1777325644; bh=b5Ctmacu1sh//2CE0sGYKHCLSj1/C7sYJQVs+No8Wk4=; h=Subject:From:In-Reply-To:Date:Cc:References:To; z=Subject:=20Re:=20HELP!=20mysql-server=20broken=20on=20FreeBSD=201 3=20Release=20p12|From:=20"Dan=20Mahoney=20(Ports)"=20|In-Reply-To:=20|Date:=20Mon,=2027=20Apr=202026=2014:33 :52=20-0700|Cc:=20Christos=20Chatzaras=20,=0D =0A=20questions@freebsd.org|References:=20=0D=0A=20=0D=0A=20|To:=20William =20Dudley=20; b=f5TtMB3Nnt3QTmQZTxsswDDieGgO9dfZxPczoWt1v4QENVaKHega13XWhhS7IA6C1 3KlWHKDvVgXIyGBFiQ5Tx7W3TOq+fzqhB/ZtPQWHraO6kk36dmZvw8JLdCmdl48+zD YFJRhyXwlNIN/51d+NAcZv5IF4lkHZMPeDyUdKsqHtT+WTKKxW286n3lOFCRWyPFQn jUS3bi+Jb8U3EhKO5mc/JGDJ1Sh4806eO9n0mYj/w252zNR/mtlTpJPfLKPh678Ldb ACX+nK2jo5sEo+M07ipE+H8f5tgqlENsLoImCxTyY0WLozWlQ3CsE8UyaaDeJPlh10 CGUqLvwg+qkDA== X-Authentication-Warning: prime.gushi.org: Host not.afront.org [50.126.75.182] claimed to be smtpclient.apple Content-Type: text/plain; charset=utf-8 List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.org Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\)) Subject: Re: HELP! mysql-server broken on FreeBSD 13 Release p12 From: "Dan Mahoney (Ports)" In-Reply-To: Date: Mon, 27 Apr 2026 14:33:52 -0700 Cc: Christos Chatzaras , questions@freebsd.org Content-Transfer-Encoding: quoted-printable Message-Id: <753D431B-5820-4A03-8D91-4E9FAFE498EB@gushi.org> References: To: William Dudley X-Mailer: Apple Mail (2.3864.500.181) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.6.4 (prime.gushi.org [149.20.68.142]); Mon, 27 Apr 2026 21:34:04 +0000 (UTC) X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:393507, ipnet:2620:137:6000::/44, country:US] X-Rspamd-Queue-Id: 4g4GzY21twz3cGs X-Spamd-Bar: ---- > On Apr 27, 2026, at 1:47=E2=80=AFPM, William Dudley = wrote: >=20 > I have good nightly backups, so that's covered. Good thing, since I = couldn't run the server. >=20 > I turned on the native password hack, so now the server is running and = I can talk to it. >=20 > So, disaster averted. The problem occurred because p5-Class-DBI-mysql = and/or > p5-DBD-mysql-5.008 are incompatible with mysql80-server. So FreeBSD = pkg just > helpfully nuked my mysql server rather than raise a BIG ALARM. This is not my first time complaining about the fact that a very simple = shim package like p5-DBD-myxxx should not require that you build a = custom port for this, and should not force a major DB version upgrade. The complication comes with things that *depend* on that version of the = shim package. (My example was with p5-RT50, which does not directly = depend on any database package, but when you install p5-DBD-Pg, that = forces you to whatever the default version of postgres is, which changes = about once a year). I'll note that there probably should have been a note about this = password incompatibility in /usr/ports/UPDATING. I'd also still love it = if pkg updating had some magic way to fetch things affected by only your = current ports and display them. Right now, it depends on having a = checked out ports tree, which...defeats the point of using pkg? While I'm ranting: if you fix this by pkg locking your DB server = package, pkg is completely silent about not touching those locked = versions. Anyway, glad you're up and running again. -Dan=