Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 19 Dec 2025 14:49:25 +0300
From:      Washington Odhiambo <odhiambo@gmail.com>
To:        questions <questions@freebsd.org>
Subject:   Completely do away with MySQL dependencies after migrating to MariaDB
Message-ID:  <CAAdA2WPdfje2ZSPVMRLLu36p0Qd9Et5c3ZS%2B%2B8eGVhWdf%2BT1Gg@mail.gmail.com>

index | next in thread | raw e-mail

[-- Attachment #1 --]
I my /etc/make.conf, I have:
DEFAULT_VERSIONS+= python=3.11 python3=3.11 pgsql=15 ssl=openssl
mysql=11.4m mariadb=11.4

I still suffer from some pkgs wanting to install MySQL client libraries by
force :-)

How do I stop them once and for all?


root@gw:/home/wash # pkg upgrade
Updating FreeBSD-ports-kmods repository catalogue...
Fetching data.pkg: 100%   34 KiB  35.1kB/s    00:01
Processing entries: 100%
FreeBSD-ports-kmods repository update completed. 238 packages processed.
Updating FreeBSD-base repository catalogue...
Fetching data.pkg: 100%   80 KiB  81.5kB/s    00:01
Processing entries: 100%
FreeBSD-base repository update completed. 496 packages processed.
Updating FreeBSD-ports repository catalogue...
Fetching data.pkg: 100%   11 MiB   2.8MB/s    00:04
Processing entries: 100%
FreeBSD-ports repository update completed. 36978 packages processed.
All repositories are up to date.
Checking for upgrades (84 candidates): 100%
Processing candidates (84 candidates): 100%
The following 85 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
        mysql80-client: 8.0.44 [FreeBSD-ports]
        p5-DBD-mysql: 5.008 [FreeBSD-ports]

Installed packages to be UPGRADED:
        FreeBSD-kernel-generic: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-rescue: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-runtime: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-src: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-src-sys: 14.2 -> 15.0p1 [FreeBSD-base]
        FreeBSD-utilities: 15.0 -> 15.0p1 [FreeBSD-base]
        apache24: 2.4.65_1 -> 2.4.66 [FreeBSD-ports]
        autoconf: 2.72 -> 2.72_1 [FreeBSD-ports]
        automake: 1.17 -> 1.18.1 [FreeBSD-ports]
        bash: 5.3.8_1 -> 5.3.9 [FreeBSD-ports]
        bastille: 1.2.0.251201 -> 1.2.2.251204 [FreeBSD-ports]
        c-ares: 1.34.5 -> 1.34.6 [FreeBSD-ports]
        cmake: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        cmake-core: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        cmake-doc: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        cmake-man: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        compat14x-amd64: 14.2.1402000.20251120 -> 14.2.1402000.20251120_1
[FreeBSD-ports]
        crowdsec: 1.7.3_2 -> 1.7.4 [FreeBSD-ports]
        cups: 2.4.15_1 -> 2.4.16 [FreeBSD-ports]
        dav1d: 1.5.1_1 -> 1.5.2 [FreeBSD-ports]
        fontconfig: 2.15.0_3,1 -> 2.17.1,1 [FreeBSD-ports]
        gettext-runtime: 0.23.1 -> 0.26 [FreeBSD-ports]
        gettext-tools: 0.23.1_1 -> 0.26 [FreeBSD-ports]
        ghostscript10: 10.06.0 -> 10.06.0_1 [FreeBSD-ports]
        git: 2.51.2 -> 2.52.0 [FreeBSD-ports]
        glslang: 16.0.0 -> 16.1.0 [FreeBSD-ports]
        graphviz: 14.0.5 -> 14.0.5_1 [FreeBSD-ports]
        gstreamer1: 1.26.8 -> 1.26.9 [FreeBSD-ports]
        harfbuzz: 10.3.0 -> 12.2.0 [FreeBSD-ports]
        harfbuzz-icu: 10.3.0 -> 12.2.0 [FreeBSD-ports]
        hwdata: 0.401,1 -> 0.402,1 [FreeBSD-ports]
        libatomic_ops: 7.8.0 -> 7.10.0 [FreeBSD-ports]
        libdatrie: 0.2.14 -> 0.2.14_1 [FreeBSD-ports]
        libdrm: 2.4.123,1 -> 2.4.131,1 [FreeBSD-ports]
        libgit2: 1.9.1 -> 1.9.2 [FreeBSD-ports]
        libgpg-error: 1.56 -> 1.58 [FreeBSD-ports]
        libgsf: 1.14.53_1 -> 1.14.54 [FreeBSD-ports]
        libtextstyle: 0.23.1 -> 0.26 [FreeBSD-ports]
        libthai: 0.1.29_1 -> 0.1.29_2 [FreeBSD-ports]
        libzip: 1.11.2 -> 1.11.4 [FreeBSD-ports]
        luajit: 2.1.0.20251116 -> 2.1.0.20251208 [FreeBSD-ports]
        nss: 3.118.1 -> 3.119.1 [FreeBSD-ports]
        nushell: 0.108.0_1 -> 0.109.1 [FreeBSD-ports]
        oath-toolkit: 2.6.9_2 -> 2.6.13 [FreeBSD-ports]
        openjdk18: 18.0.2+9.1_4 -> 18.0.2+9.1_5 [FreeBSD-ports]
        openjdk19: 19.0.2+7.1_3 -> 19.0.2+7.1_4 [FreeBSD-ports]
        openjdk20: 20.0.2+9.1_2 -> 20.0.2+9.1_3 [FreeBSD-ports]
        openjpeg: 2.5.4 -> 2.5.4_1 [FreeBSD-ports]
        pciids: 20251130 -> 20251206 [FreeBSD-ports]
        pinentry: 1.3.2 -> 1.3.2_1 [FreeBSD-ports]
        png: 1.6.50 -> 1.6.52 [FreeBSD-ports]
        poppler: 25.04.0_2 -> 25.10.0 [FreeBSD-ports]
        poppler-glib: 25.04.0_2 -> 25.10.0 [FreeBSD-ports]
        public_suffix_list: 20251117 -> 20251204 [FreeBSD-ports]
        py311-gi-docgen: 2025.4 -> 2025.5 [FreeBSD-ports]
        py311-greenlet: 3.2.4 -> 3.3.0 [FreeBSD-ports]
        py311-pdftotext: 3.0.0_3 -> 3.0.0_4 [FreeBSD-ports]
        py311-platformdirs: 4.5.0 -> 4.5.1 [FreeBSD-ports]
        py311-psycopg-pool: 3.2.8 -> 3.3.0 [FreeBSD-ports]
        py311-publicsuffix2: 2.20191221_70 -> 2.20191221_71 [FreeBSD-ports]
        py311-python-socks: 2.7.3 -> 2.8.0 [FreeBSD-ports]
        py311-rpds-py: 0.29.0 -> 0.30.0 [FreeBSD-ports]
        py311-trove-classifiers: 2025.11.14.15 -> 2025.12.1.14
[FreeBSD-ports]
        py311-urllib3: 2.5.0,1 -> 2.6.0,1 [FreeBSD-ports]
        pylint-py311: 4.0.3 -> 4.0.4 [FreeBSD-ports]
        qemu-guest-agent: 10.1.2_1 -> 10.1.3 [FreeBSD-ports]
        redis: 8.4.0 -> 8.4.0_1 [FreeBSD-ports]
        rubygem-iconv: 1.1.0 -> 1.1.1 [FreeBSD-ports]
        rubygem-json: 2.16.0 -> 2.17.1 [FreeBSD-ports]
        rubygem-pkg-config: 1.6.4 -> 1.6.5 [FreeBSD-ports]
        rubygem-public_suffix: 7.0.0 -> 7.0.0_1 [FreeBSD-ports]
        rubygem-rubocop-rails: 2.34.1 -> 2.34.2 [FreeBSD-ports]
        rubygem-sqlite3: 2.8.0 -> 2.8.1 [FreeBSD-ports]
        rubygem-stringio: 3.1.8 -> 3.1.9 [FreeBSD-ports]
        texinfo: 7.2_2,1 -> 7.2_3,1 [FreeBSD-ports]
        texlive-base: 20250308_2 -> 20250308_3 [FreeBSD-ports]
        vips: 8.17.3 -> 8.17.3_1 [FreeBSD-ports]

Installed packages to be REINSTALLED:
        opendmarc-1.4.2_4 [FreeBSD-ports] (options changed)
        p5-DBD-MariaDB-1.23 [FreeBSD-ports] (direct dependency changed:
mysql80-client)
        p5-DBD-mysql4-4.052 [FreeBSD-ports] (direct dependency changed:
mysql80-client)
        pure-ftpd-1.0.52_1 [FreeBSD-ports] (options changed)
        sogo-mysql-5.12.4 [FreeBSD-ports] (options changed)
        sope-mysql-5.12.4 [FreeBSD-ports] (direct dependency changed:
mysql80-client)

Number of packages to be installed: 2
Number of packages to be upgraded: 77
Number of packages to be reinstalled: 6

The process will require 120 MiB more space.
985 MiB to be downloaded.

Proceed with this action? [y/N]:

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
 In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions:
http://www.catb.org/~esr/faqs/smart-questions.html]

[-- Attachment #2 --]
<div dir="ltr"><div>I my /etc/make.conf, I have:</div><div>DEFAULT_VERSIONS+= python=3.11 python3=3.11 pgsql=15 ssl=openssl mysql=11.4m mariadb=11.4</div><div><br></div><div>I still suffer from some pkgs wanting to install MySQL client libraries by force :-)</div><div><br></div><div>How do I stop them once and for all?</div><div><br></div><div><br></div><div>root@gw:/home/wash # pkg upgrade<br>Updating FreeBSD-ports-kmods repository catalogue...<br>Fetching data.pkg: 100%   34 KiB  35.1kB/s    00:01<br>Processing entries: 100%<br>FreeBSD-ports-kmods repository update completed. 238 packages processed.<br>Updating FreeBSD-base repository catalogue...<br>Fetching data.pkg: 100%   80 KiB  81.5kB/s    00:01<br>Processing entries: 100%<br>FreeBSD-base repository update completed. 496 packages processed.<br>Updating FreeBSD-ports repository catalogue...<br>Fetching data.pkg: 100%   11 MiB   2.8MB/s    00:04<br>Processing entries: 100%<br>FreeBSD-ports repository update completed. 36978 packages processed.<br>All repositories are up to date.<br>Checking for upgrades (84 candidates): 100%<br>Processing candidates (84 candidates): 100%<br>The following 85 package(s) will be affected (of 0 checked):<br><br>New packages to be INSTALLED:<br>        mysql80-client: 8.0.44 [FreeBSD-ports]<br>        p5-DBD-mysql: 5.008 [FreeBSD-ports]<br><br>Installed packages to be UPGRADED:<br>        FreeBSD-kernel-generic: 15.0 -&gt; 15.0p1 [FreeBSD-base]<br>        FreeBSD-rescue: 15.0 -&gt; 15.0p1 [FreeBSD-base]<br>        FreeBSD-runtime: 15.0 -&gt; 15.0p1 [FreeBSD-base]<br>        FreeBSD-src: 15.0 -&gt; 15.0p1 [FreeBSD-base]<br>        FreeBSD-src-sys: 14.2 -&gt; 15.0p1 [FreeBSD-base]<br>        FreeBSD-utilities: 15.0 -&gt; 15.0p1 [FreeBSD-base]<br>        apache24: 2.4.65_1 -&gt; 2.4.66 [FreeBSD-ports]<br>        autoconf: 2.72 -&gt; 2.72_1 [FreeBSD-ports]<br>        automake: 1.17 -&gt; 1.18.1 [FreeBSD-ports]<br>        bash: 5.3.8_1 -&gt; 5.3.9 [FreeBSD-ports]<br>        bastille: 1.2.0.251201 -&gt; 1.2.2.251204 [FreeBSD-ports]<br>        c-ares: 1.34.5 -&gt; 1.34.6 [FreeBSD-ports]<br>        cmake: 3.31.9 -&gt; 3.31.10 [FreeBSD-ports]<br>        cmake-core: 3.31.9 -&gt; 3.31.10 [FreeBSD-ports]<br>        cmake-doc: 3.31.9 -&gt; 3.31.10 [FreeBSD-ports]<br>        cmake-man: 3.31.9 -&gt; 3.31.10 [FreeBSD-ports]<br>        compat14x-amd64: 14.2.1402000.20251120 -&gt; 14.2.1402000.20251120_1 [FreeBSD-ports]<br>        crowdsec: 1.7.3_2 -&gt; 1.7.4 [FreeBSD-ports]<br>        cups: 2.4.15_1 -&gt; 2.4.16 [FreeBSD-ports]<br>        dav1d: 1.5.1_1 -&gt; 1.5.2 [FreeBSD-ports]<br>        fontconfig: 2.15.0_3,1 -&gt; 2.17.1,1 [FreeBSD-ports]<br>        gettext-runtime: 0.23.1 -&gt; 0.26 [FreeBSD-ports]<br>        gettext-tools: 0.23.1_1 -&gt; 0.26 [FreeBSD-ports]<br>        ghostscript10: 10.06.0 -&gt; 10.06.0_1 [FreeBSD-ports]<br>        git: 2.51.2 -&gt; 2.52.0 [FreeBSD-ports]<br>        glslang: 16.0.0 -&gt; 16.1.0 [FreeBSD-ports]<br>        graphviz: 14.0.5 -&gt; 14.0.5_1 [FreeBSD-ports]<br>        gstreamer1: 1.26.8 -&gt; 1.26.9 [FreeBSD-ports]<br>        harfbuzz: 10.3.0 -&gt; 12.2.0 [FreeBSD-ports]<br>        harfbuzz-icu: 10.3.0 -&gt; 12.2.0 [FreeBSD-ports]<br>        hwdata: 0.401,1 -&gt; 0.402,1 [FreeBSD-ports]<br>        libatomic_ops: 7.8.0 -&gt; 7.10.0 [FreeBSD-ports]<br>        libdatrie: 0.2.14 -&gt; 0.2.14_1 [FreeBSD-ports]<br>        libdrm: 2.4.123,1 -&gt; 2.4.131,1 [FreeBSD-ports]<br>        libgit2: 1.9.1 -&gt; 1.9.2 [FreeBSD-ports]<br>        libgpg-error: 1.56 -&gt; 1.58 [FreeBSD-ports]<br>        libgsf: 1.14.53_1 -&gt; 1.14.54 [FreeBSD-ports]<br>        libtextstyle: 0.23.1 -&gt; 0.26 [FreeBSD-ports]<br>        libthai: 0.1.29_1 -&gt; 0.1.29_2 [FreeBSD-ports]<br>        libzip: 1.11.2 -&gt; 1.11.4 [FreeBSD-ports]<br>        luajit: 2.1.0.20251116 -&gt; 2.1.0.20251208 [FreeBSD-ports]<br>        nss: 3.118.1 -&gt; 3.119.1 [FreeBSD-ports]<br>        nushell: 0.108.0_1 -&gt; 0.109.1 [FreeBSD-ports]<br>        oath-toolkit: 2.6.9_2 -&gt; 2.6.13 [FreeBSD-ports]<br>        openjdk18: 18.0.2+9.1_4 -&gt; 18.0.2+9.1_5 [FreeBSD-ports]<br>        openjdk19: 19.0.2+7.1_3 -&gt; 19.0.2+7.1_4 [FreeBSD-ports]<br>        openjdk20: 20.0.2+9.1_2 -&gt; 20.0.2+9.1_3 [FreeBSD-ports]<br>        openjpeg: 2.5.4 -&gt; 2.5.4_1 [FreeBSD-ports]<br>        pciids: 20251130 -&gt; 20251206 [FreeBSD-ports]<br>        pinentry: 1.3.2 -&gt; 1.3.2_1 [FreeBSD-ports]<br>        png: 1.6.50 -&gt; 1.6.52 [FreeBSD-ports]<br>        poppler: 25.04.0_2 -&gt; 25.10.0 [FreeBSD-ports]<br>        poppler-glib: 25.04.0_2 -&gt; 25.10.0 [FreeBSD-ports]<br>        public_suffix_list: 20251117 -&gt; 20251204 [FreeBSD-ports]<br>        py311-gi-docgen: 2025.4 -&gt; 2025.5 [FreeBSD-ports]<br>        py311-greenlet: 3.2.4 -&gt; 3.3.0 [FreeBSD-ports]<br>        py311-pdftotext: 3.0.0_3 -&gt; 3.0.0_4 [FreeBSD-ports]<br>        py311-platformdirs: 4.5.0 -&gt; 4.5.1 [FreeBSD-ports]<br>        py311-psycopg-pool: 3.2.8 -&gt; 3.3.0 [FreeBSD-ports]<br>        py311-publicsuffix2: 2.20191221_70 -&gt; 2.20191221_71 [FreeBSD-ports]<br>        py311-python-socks: 2.7.3 -&gt; 2.8.0 [FreeBSD-ports]<br>        py311-rpds-py: 0.29.0 -&gt; 0.30.0 [FreeBSD-ports]<br>        py311-trove-classifiers: 2025.11.14.15 -&gt; 2025.12.1.14 [FreeBSD-ports]<br>        py311-urllib3: 2.5.0,1 -&gt; 2.6.0,1 [FreeBSD-ports]<br>        pylint-py311: 4.0.3 -&gt; 4.0.4 [FreeBSD-ports]<br>        qemu-guest-agent: 10.1.2_1 -&gt; 10.1.3 [FreeBSD-ports]<br>        redis: 8.4.0 -&gt; 8.4.0_1 [FreeBSD-ports]<br>        rubygem-iconv: 1.1.0 -&gt; 1.1.1 [FreeBSD-ports]<br>        rubygem-json: 2.16.0 -&gt; 2.17.1 [FreeBSD-ports]<br>        rubygem-pkg-config: 1.6.4 -&gt; 1.6.5 [FreeBSD-ports]<br>        rubygem-public_suffix: 7.0.0 -&gt; 7.0.0_1 [FreeBSD-ports]<br>        rubygem-rubocop-rails: 2.34.1 -&gt; 2.34.2 [FreeBSD-ports]<br>        rubygem-sqlite3: 2.8.0 -&gt; 2.8.1 [FreeBSD-ports]<br>        rubygem-stringio: 3.1.8 -&gt; 3.1.9 [FreeBSD-ports]<br>        texinfo: 7.2_2,1 -&gt; 7.2_3,1 [FreeBSD-ports]<br>        texlive-base: 20250308_2 -&gt; 20250308_3 [FreeBSD-ports]<br>        vips: 8.17.3 -&gt; 8.17.3_1 [FreeBSD-ports]<br><br>Installed packages to be REINSTALLED:<br>        opendmarc-1.4.2_4 [FreeBSD-ports] (options changed)<br>        p5-DBD-MariaDB-1.23 [FreeBSD-ports] (direct dependency changed: mysql80-client)<br>        p5-DBD-mysql4-4.052 [FreeBSD-ports] (direct dependency changed: mysql80-client)<br>        pure-ftpd-1.0.52_1 [FreeBSD-ports] (options changed)<br>        sogo-mysql-5.12.4 [FreeBSD-ports] (options changed)<br>        sope-mysql-5.12.4 [FreeBSD-ports] (direct dependency changed: mysql80-client)<br><br>Number of packages to be installed: 2<br>Number of packages to be upgraded: 77<br>Number of packages to be reinstalled: 6<br><br>The process will require 120 MiB more space.<br>985 MiB to be downloaded.<br><br>Proceed with this action? [y/N]:</div><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254 7 3200 0004/+254 7 2274 3223</div><div><span style="color:rgb(34,34,34)"> In </span><span style="color:rgb(34,34,34)">an Internet failure case, the #1 suspect is a constant: DNS.</span><br>&quot;<span style="font-size:12.8px">Oh, the cruft.</span><span style="font-size:12.8px">&quot;, </span><span style="font-size:12.8px">egrep -v &#39;^$|^.*#&#39; </span><span style="background-color:rgb(34,34,34);color:rgb(238,238,238);font-family:&quot;Lucida Console&quot;,Consolas,&quot;Courier New&quot;,monospace;font-size:13.6px">¯\_(ツ)_/¯</span><span style="font-size:12.8px"> :-)</span></div><div><span style="font-size:12.8px">[How to ask smart questions: </span><span style="font-size:12.8px"><a href="http://www.catb.org/~esr/faqs/smart-questions.html" target="_blank">http://www.catb.org/~esr/faqs/smart-questions.html</a>]</span></div></div></div></div></div>;
help

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAAdA2WPdfje2ZSPVMRLLu36p0Qd9Et5c3ZS%2B%2B8eGVhWdf%2BT1Gg>