Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6.7
-
Ubuntu 22.04 LTS
Description
After updating Ubuntu from 20.04 LTS to 22.04 LTS mariadb-server was automatically updated to 10.6.7. Now mysqlreport produces this:
install_driver(MariaDB) failed: Can't locate DBD/MariaDB.pm in @INC (you may need to install the DBD::MariaDB module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.34.0 /usr/local/share/perl/5.34.0 /usr/lib/x86_64-linux-gnu/perl5/5.34 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.34 /usr/share/perl/5.34 /usr/local/lib/site_perl) at (eval 9) line 3.
|
Perhaps the DBD::MariaDB perl module hasn't been fully installed,
|
or perhaps the capitalisation of 'MariaDB' isn't right.
|
Available drivers: DBM, ExampleP, File, Gofer, Mem, Proxy, Sponge, mysql.
|
at /usr/bin/mysqlreport line 261.
|
The reason is libdbd-mariadb-perl is not shipping with Ubuntu 22.04 (jammy). So mysqlreport is unusable now. The solution would be to ship and install libdbd-mariadb-perl alongside with mariadb-server, I guess.
Attachments
Activity
Correct, I just tried to install libdbd-mariadb-perl, but there is no installation candidate. So mariadb-server needs to ship that in the future, right?
notably the debian/control dependency on Recommends: libdbd-mariadb-perl | libdbd-mysql-perl, is a lie, it can't work with mysql-perl as the DSN url is $dsn = "DBI:MariaDB:....
So we probably should just drop it on Ubuntu-22.04+
Drop the wrong recommendation to libdbd-mysql-perl, you mean? That was entered intentionally here: MDEV-20298. So Otto Kekäläinen should have a say in this.
Drop mysqlreport? Please don't, I use that very often. There must be a way, don't you think?
I filed a bug report.
You could close this here, the reason is outside mariadb-server. But the wrong dependency recommendation is still open, perhaps we wait for Otto to answer this.
Debian bug report is: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1002093
Yes, but it its fixed now, so we could have it in jammy-repository or in mariadb-server.
Ok I reword myself as I checked Debian Salsa where this problem comes from. I have to create small PR to test if there is DBI:MariaDB or DBI:mysql available and hopefully Ubuntu will pick that up.
JJworx Can you test if https://salsa.debian.org/mariadb-team/mariadb-server/-/blob/debian/latest/debian/additions/mariadb-report works for you? Now it detects if you have DBD:MariaDB or DBD:mysql available and uses that driver for connection.
Debian Salsa merge request: https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/14.
JJworx it's merged to Debian 10.6 (Salsa debian/latest) and if Ubuntu picks patch to Jammy (which I hope) it'll will be update to there soon. Before that use version from git. Should we wait for Ubuntu before closing this? What do you think danblack?
I'm fine with the downloaded version. Closing this topic will leave the download
link intact. So close it, IMHO.
It seem that it removed branch
as I didn't unmark remove branch. Could you update link to official location. Which will be there as merge request is in.
illuusio The commit https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/8e4109842fbbb20196ce5da4b7e586ead3fe8885 is currently only in Debian, right? Please submit a PR for upstream MariaDB too so that Debian and upstream `debian/*` contents would be as identical as possible.
As this also in upstream commit PR to merge change in upstream also. First appearance is 10.5
So its not in obvious ubuntu-22.04 packages, and libdbd-mariadb-perl isn't in 22.04 Jammy.