[MDEV-28376] mysqlreport missing libdbd-mariadb-perl Created: 2022-04-21  Updated: 2022-05-24  Resolved: 2022-05-24

Status: Closed
Project: MariaDB Server
Component/s: Packaging, Platform Debian
Affects Version/s: 10.6.7
Fix Version/s: 10.5.17, 10.6.9, 10.7.5, 10.8.4, 10.9.2

Type: Bug Priority: Major
Reporter: Jochen Assignee: Tuukka Pasanen
Resolution: Fixed Votes: 0
Labels: debian, packaging
Environment:

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.



 Comments   
Comment by Daniel Black [ 2022-04-21 ]

So its not in obvious ubuntu-22.04 packages, and libdbd-mariadb-perl isn't in 22.04 Jammy.

Comment by Jochen [ 2022-04-21 ]

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?

Comment by Daniel Black [ 2022-04-21 ]

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+

Comment by Jochen [ 2022-04-22 ]

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?

Comment by Daniel Black [ 2022-04-22 ]

Finding why Ubuntu dropped the perl package would be good.

Comment by Jochen [ 2022-04-22 ]

I asked, here

Comment by Jochen [ 2022-04-22 ]

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.

Comment by Tuukka Pasanen [ 2022-04-27 ]

Debian bug report is: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1002093

Comment by Jochen [ 2022-04-27 ]

Yes, but it its fixed now, so we could have it in jammy-repository or in mariadb-server.

Comment by Tuukka Pasanen [ 2022-05-02 ]

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.

Comment by Tuukka Pasanen [ 2022-05-11 ]

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.

Comment by Jochen [ 2022-05-11 ]

yup, works!

Comment by Tuukka Pasanen [ 2022-05-12 ]

Debian Salsa merge request: https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/14.

Comment by Tuukka Pasanen [ 2022-05-12 ]

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?

Comment by Jochen [ 2022-05-12 ]

I'm fine with the downloaded version. Closing this topic will leave the download
link intact. So close it, IMHO.

Comment by Tuukka Pasanen [ 2022-05-12 ]

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.

Comment by Jochen [ 2022-05-17 ]

Thank you, Tuuka!

Comment by Otto Kekäläinen [ 2022-05-22 ]

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.

Comment by Tuukka Pasanen [ 2022-05-23 ]

As this also in upstream commit PR to merge change in upstream also. First appearance is 10.5

Generated at Thu Feb 08 10:00:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.