MySQL.pm and PERL5LIB

[Hammer2001]

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

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.

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.

[atcroft]

(Hint: <code></code> tags will help with post readability when posting code or error messages.)

It looks like you do not have Moose installed. Either look for a .rpm package (using yum search Moose or your favorite package manager), or look at installing via CPAN (perl -MCPAN -e 'install Moose'). Being a CentOS (RedHat-derivative), I would suggest looking for an RPM package first.

If you want a "clean" perl environment, you can look at installing perlbrew.

Hope that helps.

[Hammer2001]

Thank you, atcroft for the guidance. Moose is not available as a yum package or an RPM. I have done install and force install of Moose multiple times. The errors alternate between Moose.pm and MySQL.pm. Will look into perlbrew and let you know if it gets me out of the Perlhole I am in. Thanks, Hamid.

[atcroft]

You might look at RepoForge.org or one of the other third-party repositories for a Moose RPM package as well.

Hope that helps.

[ikegami]

The errors alternate between Moose.pm and MySQL.pm.

You might be overwriting PERL5LIB when you should be adding to it? What's the full path to Moose.pm?