Bug 29065

Summary:	mysqlhotcopy is failing "Can't locate DBD/MariaDB.pm"
Product:	Mageia	Reporter:	Xuo <xuoy>
Component:	RPM Packages	Assignee:	Marc Krämer <mageia>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	Normal	CC:	ouaurelien, perl, xuoy
Version:	8
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:	mariadb-10.5.10-1.mga8.src.rpm	CVE:
Status comment:
Bug Depends on:	29168
Bug Blocks:

Description Xuo 2021-06-01 09:36:38 CEST

Hi,

I'm using mysqlhotcopy to save some MariaDB databases.
I get the following error message :
install_driver(MariaDB) failed: Can't locate DBD/MariaDB.pm in @INC (you may need to install the DBD::MariaDB module) (@INC contains: /usr/local/lib64/perl5/5.32 /usr/local/share/perl5/5.32 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (eval 12) 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, Sponge, mysql.                                                
 at /bin/mysqlhotcopy line 203.           

I looks very similar to this issue :
https://bugzilla.redhat.com/show_bug.cgi?id=1929106

The package perl-Data-ObjectDriver-0.210.0-1.mga8
contains a Perl module DBD/MariaDB.pm but it does not solve the issue.

Could you please add the required packages for mysqlhotcopy to work under Mageia8.

Steps to reproduce :
mysqlhotcopy -u root -p <root_password> my_db backup_dir

Regards.

Xuo.

Xuo 2021-06-01 09:37:12 CEST

CC: (none) => xuoy
Summary: I need the package perl-DBD-MariaDB => mysqlhotcopy is failing.

Comment 1 Lewis Smith 2021-06-02 09:41:28 CEST

Thank you for the report.
"The package perl-Data-ObjectDriver-0.210.0-1.mga8
contains a Perl module DBD/MariaDB.pm but it does not solve the issue."
Looks important. It is not the only module of this name, so perhaps a special MariaDB version is missing:
$ urpmf MariaDB.pm
perl-Rose-DB:/usr/share/perl5/vendor_perl/Rose/DB/MariaDB.pm
perl-Data-ObjectDriver:/usr/share/perl5/vendor_perl/Data/ObjectDriver/Driver/DBD/MariaDB.pm

'mysqlhotcopy' is in pkg 'mariadb-common'.
Assigning to Marc.

Assignee: bugsquad => mageia
Summary: mysqlhotcopy is failing. => mysqlhotcopy is failing "Can't locate DBD/MariaDB.pm"
Source RPM: (none) => mariadb-10.5.10-1.mga8.src.rpm

Comment 2 Marc Krämer 2021-06-02 11:40:29 CEST

since this is perl related, and I'm not an perl expert, maybe we have some experts around?
I can add the dependancy to mariadb, but I don't know why this does not solve the issue.

CC: (none) => perl

Comment 3 Xuo 2021-06-02 20:21:06 CEST

Hi,

On Mageai7, when I was using mysqlhotcopy, these 2 packages were not installed (perl-Rose-DB and perl-Data-ObjectDriver).
It is this one (perl-DBD-mysql) which was used. So I guess that the perl-DBD-mariadb package should be created starting from the perl-DBD-mysql one (easier to say than to do).

Regards.

Xuo.

Comment 4 Xuo 2021-06-02 20:43:00 CEST

Hi,

I could make it work after I've done the following :
urpmi cpanminus (to get the cpanm command)
urpmi lib64mariadb-devel (to get the mysql.h file)
cpanm DBD::MariaDB (to install the DBD::MariaDB Perl module).

Regards.

Xuo.

Comment 5 Marc Krämer 2021-06-30 13:23:36 CEST

update in mga9, I think I can import this package to mga8 and we will have this fixed with the next release

Comment 6 Marc Krämer 2021-06-30 13:45:52 CEST

updated mariadb package in #29168 to rel 2

Resolution: (none) => FIXED
Status: NEW => RESOLVED

Comment 7 Xuo 2021-07-01 21:16:08 CEST

Hi,

What does "updated mariadb package in #29168 to rel 2" mean ?
The current mariadb package I have is : mariadb-10.5.10-1.mga8
How to get the new one ?

Regards.

Xuo.

Comment 8 Aurelien Oudelet 2021-07-01 21:25:22 CEST

The package is currently in core/updates_testing repo and will be pushed as soon as possible to core/updates when QA did test it. This bug should not be closed.

Don't close bug until the correct one is pushed, please.

CC: (none) => ouaurelien
Status: RESOLVED => REOPENED
Resolution: FIXED => (none)
Depends on: (none) => 29168

Aurelien Oudelet 2021-07-01 21:26:02 CEST

Status comment: (none) => waiting for updates pushed from bug 29168

Comment 9 Aurelien Oudelet 2021-07-09 07:47:45 CEST

An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2021-0144.html

Resolution: (none) => FIXED
Status: REOPENED => RESOLVED

Aurelien Oudelet 2021-07-09 07:48:06 CEST

Status comment: waiting for updates pushed from bug 29168 => (none)

Comment 10 Xuo 2021-07-10 15:48:25 CEST

Hi,

It works fine now.
What I did :
urpmi cpanminus (to get the cpanm command)
urpmi lib64mariadb-devel (to get the mysql.h file)
cpanm DBD::MariaDB (to install the DBD::MariaDB Perl module).


cpanm --uninstall DBD::MariaDB
urpme lib64mariadb-devel
urpme cpanminus

urpmi --auto-update

Now, I get the new mariadb version :
rpm -qa | grep mariadb => mariadb-10.5.11-2.mga8

mysqlhotcopy works.

Thank you for your help.

Regards.

Xuo.