From nobody Sat Nov 11 00:50:10 2023 X-Original-To: freebsd-perl@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 4SRxtY11yfz503Yj for ; Sat, 11 Nov 2023 00:50:13 +0000 (UTC) (envelope-from joey@joeykelly.net) Received: from marsh.redfishnetworks.com (redfishnetworks.com [45.56.101.157]) (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 mx1.freebsd.org (Postfix) with ESMTPS id 4SRxtX32n8z4JWd for ; Sat, 11 Nov 2023 00:50:12 +0000 (UTC) (envelope-from joey@joeykelly.net) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=redfishnetworks.com header.s=default header.b=DDCw9GbM; spf=pass (mx1.freebsd.org: domain of joey@joeykelly.net designates 45.56.101.157 as permitted sender) smtp.mailfrom=joey@joeykelly.net; dmarc=pass (policy=none) header.from=joeykelly.net Received: from marsh.redfishnetworks.com (localhost [127.0.0.1]) by marsh.redfishnetworks.com (Postfix) with ESMTP id F0A8127B0CD for ; Fri, 10 Nov 2023 18:50:11 -0600 (CST) Received: from marsh.redfishnetworks.com ([127.0.0.1]) by marsh.redfishnetworks.com (marsh.redfishnetworks.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 39wFZ6R6X9kN for ; Fri, 10 Nov 2023 18:50:11 -0600 (CST) Received: from nathan.bibleheroes (ip70-186-127-118.no.no.cox.net [70.186.127.118]) by marsh.redfishnetworks.com (Postfix) with ESMTPSA id 5AE9727B0C8 for ; Fri, 10 Nov 2023 18:50:11 -0600 (CST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=redfishnetworks.com; s=default; t=1699663811; bh=OTWHyKnwpSOfr+RRgRrtawXngHIW0Ww87jGuK7xheZ8=; h=From:To:Subject:Date; b=DDCw9GbMthJQk6U2dxwGj/k67ryX6flAZRYdaM3KsbtQGI0LXNexzfp/i2EvzsmYm MOEtEo4ilr4JD2TqwOhWK6K1a/Cw6Mx4WAZgwhxcp/0V1qcdn7qX5W8Enh/9BeEJR/ RvZGITfAT1gqZohxDN/7mi/xsumSJUM1U+uRawmc= From: Joey Kelly To: freebsd-perl@freebsd.org Subject: old version problem with p5-DBD-MariaDB Date: Fri, 10 Nov 2023 18:50:10 -0600 Message-ID: <2254169.4jQFfv3LO4@nathan.bibleheroes> List-Id: maintainer of a number of perl-related ports List-Archive: https://lists.freebsd.org/archives/freebsd-perl List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-perl@freebsd.org X-BeenThere: freebsd-perl@freebsd.org MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="us-ascii" X-Spamd-Result: default: False [-3.48 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.98)[-0.981]; DMARC_POLICY_ALLOW(-0.50)[joeykelly.net,none]; CTE_CASE(0.50)[]; R_SPF_ALLOW(-0.20)[+mx:c]; R_DKIM_ALLOW(-0.20)[redfishnetworks.com:s=default]; MIME_GOOD(-0.10)[text/plain]; ARC_NA(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; MLMMJ_DEST(0.00)[freebsd-perl@freebsd.org]; DKIM_TRACE(0.00)[redfishnetworks.com:+]; RCPT_COUNT_ONE(0.00)[1]; ASN(0.00)[asn:63949, ipnet:45.56.96.0/20, country:SG]; FROM_HAS_DN(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; RCVD_COUNT_THREE(0.00)[3]; TO_MATCH_ENVRCPT_ALL(0.00)[]; TO_DN_NONE(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-perl@freebsd.org]; RCVD_TLS_LAST(0.00)[] X-Rspamd-Queue-Id: 4SRxtX32n8z4JWd X-Spamd-Bar: --- Hey folks, I'm trying to install DBD-MySQL or DBD-MariaDB, I really don't care which one, but as you can see it wants to downgrade me from mariadb1011-server-10.11.5 to mysql80-*-8.0.33_3, something I am really unwilling to do as I depend on MariaDB-specific features/bugs. Might the dependency list be updated to include a MariaDB client option? Or is there an existing flag or workaround? Thanks for looking into this. The relevant data is here: freehawk:~/hawk/bin# uname -a FreeBSD freehawk 13.2-RELEASE-p4 FreeBSD 13.2-RELEASE-p4 GENERIC amd64 freehawk:~/hawk/bin# freehawk:~/hawk/bin# qpkglist.pl maria mariadb1011-client-10.11.5 mariadb1011-server-10.11.5 freehawk:~/hawk/bin# freehawk:~/hawk/bin#pkg search dbd | ggrep -Ei 'mysql|maria' p5-DBD-MariaDB-1.21 MariaDB driver for the Perl5 Database Interface (DBI) p5-DBD-mysql-4.050_1 MySQL driver for the Perl5 Database Interface (DBI) freehawk:~/hawk/bin# freehawk:~/hawk/bin# freehawk:~/hawk/bin# pkg install p5-DBD-MariaDB Updating FreeBSD repository catalogue... FreeBSD repository is up to date. All repositories are up to date. Checking integrity... done (2 conflicting) - mysql80-client-8.0.33_3 conflicts with mariadb1011-client-10.11.5 on /usr/ local/bin/my_print_defaults - mysql80-client-8.0.33_3 conflicts with mariadb1011-server-10.11.5 on /usr/ local/bin/perror Checking integrity... done (0 conflicting) The following 5 package(s) will be affected (of 0 checked): Installed packages to be REMOVED: mariadb1011-client: 10.11.5 mariadb1011-server: 10.11.5 New packages to be INSTALLED: mysql80-client: 8.0.33_3 p5-DBD-MariaDB: 1.21 Installed packages to be REINSTALLED: basu-0.2.1 Number of packages to be removed: 2 Number of packages to be installed: 2 Number of packages to be reinstalled: 1 The operation will free 225 MiB. 198 KiB to be downloaded. Proceed with this action? [y/N]: n freehawk:~/hawk/bin# freehawk:~/hawk/bin# freehawk:~/hawk/bin# pkg install p5-DBD-mysql Updating FreeBSD repository catalogue... FreeBSD repository is up to date. All repositories are up to date. The following 13 package(s) will be affected (of 0 checked): New packages to be INSTALLED: mysql80-client: 8.0.33_3 p5-Authen-NTLM: 1.09_1 p5-Crypt-SSLeay: 0.72_3 p5-DBD-mysql: 4.050_1 p5-File-Listing: 6.16 p5-HTTP-CookieJar: 0.014 p5-HTTP-Cookies: 6.10 p5-HTTP-Negotiate: 6.01_1 p5-LWP-Protocol-https: 6.11 p5-Net-HTTP: 6.23 p5-Try-Tiny: 0.31 p5-WWW-RobotRules: 6.02_1 p5-libwww: 6.70 Number of packages to be installed: 13 The process will require 119 MiB more space. 438 KiB to be downloaded. Proceed with this action? [y/N]: y [1/12] Fetching p5-WWW-RobotRules-6.02_1.pkg: 100% 13 KiB 13.3kB/s 00:01 [2/12] Fetching p5-Authen-NTLM-1.09_1.pkg: 100% 13 KiB 13.8kB/s 00:01 [3/12] Fetching p5-HTTP-Negotiate-6.01_1.pkg: 100% 13 KiB 13.2kB/s 00:01 [4/12] Fetching p5-DBD-mysql-4.050_1.pkg: 100% 99 KiB 101.7kB/s 00:01 [5/12] Fetching p5-libwww-6.70.pkg: 100% 149 KiB 152.5kB/s 00:01 [6/12] Fetching p5-Crypt-SSLeay-0.72_3.pkg: 100% 38 KiB 39.2kB/s 00:01 [7/12] Fetching p5-HTTP-CookieJar-0.014.pkg: 100% 16 KiB 16.3kB/s 00:01 [8/12] Fetching p5-HTTP-Cookies-6.10.pkg: 100% 26 KiB 26.7kB/s 00:01 [9/12] Fetching p5-Try-Tiny-0.31.pkg: 100% 17 KiB 17.7kB/s 00:01 [10/12] Fetching p5-Net-HTTP-6.23.pkg: 100% 27 KiB 27.8kB/s 00:01 [11/12] Fetching p5-LWP-Protocol-https-6.11.pkg: 100% 12 KiB 11.9kB/s 00:01 [12/12] Fetching p5-File-Listing-6.16.pkg: 100% 15 KiB 15.1kB/s 00:01 Checking integrity... done (2 conflicting) - mysql80-client-8.0.33_3 conflicts with mariadb1011-client-10.11.5 on /usr/ local/bin/my_print_defaults - mysql80-client-8.0.33_3 conflicts with mariadb1011-server-10.11.5 on /usr/ local/bin/perror Checking integrity... done (0 conflicting) Conflicts with the existing packages have been found. One more solver iteration is needed to resolve them. The following 15 package(s) will be affected (of 0 checked): Installed packages to be REMOVED: mariadb1011-client: 10.11.5 mariadb1011-server: 10.11.5 New packages to be INSTALLED: mysql80-client: 8.0.33_3 p5-Authen-NTLM: 1.09_1 p5-Crypt-SSLeay: 0.72_3 p5-DBD-mysql: 4.050_1 p5-File-Listing: 6.16 p5-HTTP-CookieJar: 0.014 p5-HTTP-Cookies: 6.10 p5-HTTP-Negotiate: 6.01_1 p5-LWP-Protocol-https: 6.11 p5-Net-HTTP: 6.23 p5-Try-Tiny: 0.31 p5-WWW-RobotRules: 6.02_1 p5-libwww: 6.70 Number of packages to be removed: 2 Number of packages to be installed: 13 The operation will free 224 MiB. Proceed with this action? [y/N]: n -- Joey Kelly Minister of the Gospel and Linux Consultant http://joeykelly.net 504-239-6550