831316 - do-check-backups failing on backup3.db.phx1 due to bad paths and INC

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Sheeri Cabral [:sheeri]]

Cron <root@backup3> /usr/bin/perl /data/backups/bin/do-check-backups > /var/run/backup-status.new && mv -f /var/run/backup-status.new /var/run/backup-status

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
 at /data/backups/bin/do-check-backups line 44

Comment 1

[Sheeri Cabral [:sheeri]]

DBD::mysql is in /usr/lib64/perl5/DBD

So the fix is to make a softlink to /usr/local/lib64, which there's nothing in currently:

[[e-mail]1 ~]# ls /usr/local/lib64
[[e-mail]1 ~]# 

[[e-mail]1 ~]# ln -s /usr/lib64/perl5/ /usr/local/lib64/
[[e-mail]1 ~]# ls /usr/local/lib64
perl5
[[e-mail]1 ~]#

Comment 2

[Sheeri Cabral [:sheeri]]

Hrm, looks like we're still getting:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
 at /data/backups/bin/do-check-backups line 44

*sadface* Not sure what else to do.

Comment 3

[Sheeri Cabral [:sheeri]]

Adding rtucker because he knows him some Perl.

Comment 4

[Rob Tucker [:rtucker]]

I do not know perl

Comment 5

[Sheeri Cabral [:sheeri]]

sorry! REmoving you, adding gcox.....was he the perl guy?

Comment 6

[Greg Cox [:gcox]]

/usr/lib64/perl5 is in @INC, which means DBD/mysql.pm should be found there without the symlink.

That it's not is probably a PATHing issue buried in DBI as it goes looking for the right DBD.  Once you know what PATH is correct, you may want to consider adding something like
  $ENV{'PATH'} = '/usr/bin:/bin:/usr/sbin:/sbin:/yer/mom';
so that you always have exactly what you need.

Comment 7

[Brandon Johnson [:cyborgshadow]]

Attempted to solve this by setting ENV{'PATH'}. Confirmed it was printing and reading the right PATH but still not working.

Also ensured with a `perl -MDBD::mysql -e 1` and `perl -MDBI -e 1` that both modules were installed.

I'm going to test some cronnables when I get back this evening from my linux meetup.

Comment 8

[Sheeri Cabral [:sheeri]]

FWIW this is still happening.

Comment 9

[Brandon Johnson [:cyborgshadow]]

This was not phx1....I spent like 20+ hours trying to debug this and never found any problems.

This was backup3.db.scl3. I fixed it today. It was missing the perl-DBD-MySQL and perl-DBI packages.