Installation of package p5-DBD-MariaDB removes mariadb105-client and -server

Hello,

I use a software (Webmin) which in turn uses Perl modules for database management. My FreeBSD 13.1 server is running MariaDB 10.5.

In Webmin, when I call the MariaDB Database Server module, I get the following message: "Warning: The Perl module DBD::mysql is not installed on your system, so Webmin will not be able to reliably access your MariaDB database. Click here to install it now."

When I want to install the required Perl module using pkg install "p5-DBD-MariaDB", I am told every time that in addition to "p5-DBD-MariaDB-1.21.pkg" also "mysql80-client: 8.0.32_2" would be required, which in turn would allegedly (cf. below) conflict with mariadb105 client and server, whereupon it is then announced that maria-db must be uninstalled, which is exactly what I do not want. By the way, the same game is experienced with MariaDB 10.6.

Does anyone have an idea how I can install the p5-DBD-MariaDB or DBD::mysql required for MariaDB version 10.5.20 without the supposedly required mysql80-client: 8.0.32_2 coming into play every time, since the mariadb105-client-10.5.20 is already installed?

Kind regards
Sidney2017

Code:
13.1-RELEASE-p2 FreeBSD 13.1-RELEASE-p2 GENERIC amd64

# pkg info | grep -i maria

mariadb105-client-10.5.20 Multithreaded SQL database (client)
mariadb105-server-10.5.20 Multithreaded SQL database (server)

pkg install p5-DBD-MariaDB[/B]

Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
The following 2 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:

mysql80-client: 8.0.32_2
p5-DBD-MariaDB: 1.21

Number of packages to be installed: 2

The process will require 108 MiB more space.
103 KiB to be downloaded.

Proceed with this action? [y/N]: y

[1/1] Fetching p5-DBD-MariaDB-1.21.pkg: 100% 103 KiB 105.5kB/s 00:01

Checking integrity... done (2 conflicting)

- mysql80-client-8.0.32_2 conflicts with mariadb105-client-10.5.20 on /usr/local/bin/my_print_defaults
- mysql80-client-8.0.32_2 conflicts with mariadb105-server-10.5.20 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 4 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
mariadb105-client: 10.5.20
mariadb105-server: 10.5.20

New packages to be INSTALLED:

mysql80-client: 8.0.32_2
p5-DBD-MariaDB: 1.21

Number of packages to be removed: 2
Number of packages to be installed: 2

The operation will free 130 MiB.

Proceed with this action? [y/N]
...
 
Packages are built with the default settings, which means mysql is set to MySQL 8.0. Any package requiring the client will therefor be depending on the MySQL 8.0 client.

Set in /etc/make.conf:
Code:
DEFAULT_VERSIONS+= mysql=105m
And build from ports.
 
Everything that would require a mysql client would need to be build from ports. That DEFAULT_VERSIONS setting only works for building ports, once a package has been built its dependencies cannot be changed.
 
Back
Top