MySQL.pm and PERL5LIB

Hammer2001 has asked for the wisdom of the Perl Monks concerning the following question:

Greetings to the wise. I have a script that needs to transfer data from CSB files to MySQL. The environment is CentOS 6.4 (64-bit) with Perl 5.18.1. I am using and have installed Text::CSV::Auto::ExportTo::MySQL from CPAN:

[root@uncle /]# find /usr/local/lib/perl5 -name "MySQL.pm" -ls
2102089    8 -r--r--r--   1 root     root         5036 Mar  8  2011 /u
+sr/local/lib/perl5/site_perl/5.18.1/Text/CSV/Auto/ExportTo/MySQL.pm
[download]

When I use this module in my code, I get the error:

Can't locate Moose.pm in @INC (@INC contains: /usr/local/lib/perl5/sit
+e_perl/5.18.1 /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib6
+4/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /us
+r/share/perl5 .) at /usr/local/lib/perl5/site_perl/5.18.1/Text/CSV/Au
+to/ExportTo/MySQL.pm line 5.
BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.
+18.1/Text/CSV/Auto/ExportTo/MySQL.pm line 5.
Compilation failed in require at ./uscb.pl line 13.
BEGIN failed--compilation aborted at ./uscb.pl line 13.
[download]

Clearly the module is there at /usr/local/lib/perl5/site_perl/5.18.1/Text/CSV/Auto/ExportTo/MySQL.pm, but yet Perl can't find it.

When I add use lib "/usr/local/lib/perl5/site_perl/5.18.1/x86_64-linux" to my code, it still can't find.

I have now copied modules all over the place, reinstalled perl & CPAN and done other desperate things which have left my system in a mess. Is there a way to re-install Perl on CentOS6.4 to get a clean Perl environment?

Thank you kindly, Hamid.

Back to Seekers of Perl Wisdom