Re: unable to locate DBI.pm

Hi,

I'm sorry that I posted this same question twice because I thought it did not go through the first time.

Thank you in advance


Hi 
On Wednesday, 21 May 2014 10:11 AM, Daminto Lie <[email protected]> wrote:
 


Hi,

I've been getting the following errors after installing DBI and DBD-mysql manually from source.

Can't locate DBI.pm in @INC (@INC contains: 
/etc/perl
/usr/local/lib/perl/5.14.2
/usr/local/share/perl/5.14.2
/usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.14
/usr/share/perl/5.14
/usr/local/lib/site_perl .)

This was how I installed the DBI-1.631.

- perl Makefile.PL
- make
- make test
- make test
 TEST_VERBOSE=1
- make install


And this was how I installed DBD-mysql-4.027

- perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd
- make -j3
- make test
- checkinstall -D make install


I
 also noticed that during the completion of the installation of DBI, it 
actually installed it in the /root directory as follows:

Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbipport.h
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.so
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.bs
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbivport.h
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver.xst
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbd_xsh.h
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbi_sql.h
Installing
 /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBIXS.h
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbixs_rev.h
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/dbixs_rev.pl
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileData.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProxyServer.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Profile.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileSubs.pm
Installing
 /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/W32ODBC.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/FAQ.pm
Installing
 /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Changes.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/PurePerl.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Execute.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Response.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Request.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/pipeone.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/stream.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/Base.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/DataDumper.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Storable.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Base.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoReturn.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoType.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ANSI.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ODBC.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/_accessor.pm
Installing
 /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/CacheMemory.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/SQL/Nano.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/Metadata.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/Developers.pod
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/HowTo.pod
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper/Apache.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/DBM.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/NullP.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Sponge.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/ExampleP.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Proxy.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Developers.pod
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Roadmap.pod
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/HowTo.pod
Installing
 /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/corostream.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/null.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/pipeone.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/stream.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/Base.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/classic.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/pedantic.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/rush.pm
Installing
 /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/Base.pm
Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Win32/DBIODBC.pm
Installing /root/perl5/man/man1/dbiprof.1p
Installing /root/perl5/man/man1/dbilogstrip.1p
Installing /root/perl5/man/man1/dbiproxy.1p
Installing /root/perl5/man/man3/DBD::Gofer::Transport::pipeone.3pm
Installing /root/perl5/man/man3/DBI::DBD.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Policy::pedantic.3pm
Installing /root/perl5/man/man3/DBI::SQL::Nano.3pm
Installing /root/perl5/man/man3/DBI::Const::GetInfo::ODBC.3pm
Installing /root/perl5/man/man3/DBI::PurePerl.3pm
Installing /root/perl5/man/man3/DBI::ProxyServer.3pm
Installing
 /root/perl5/man/man3/DBD::Gofer::Transport::null.3pm
Installing /root/perl5/man/man3/DBI::ProfileData.3pm
Installing /root/perl5/man/man3/DBD::Sponge.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Policy::Base.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Policy::classic.3pm
Installing /root/perl5/man/man3/DBI::Util::CacheMemory.3pm
Installing /root/perl5/man/man3/DBI::Const::GetInfoType.3pm
Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::HowTo.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Serializer::DataDumper.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Transport::pipeone.3pm
Installing /root/perl5/man/man3/DBI::ProfileSubs.3pm
Installing /root/perl5/man/man3/DBI::DBD::Metadata.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Execute.3pm
Installing /root/perl5/man/man3/DBI.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Transport::Base.3pm
Installing /root/perl5/man/man3/DBI::Const::GetInfo::ANSI.3pm
Installing /root/perl5/man/man3/DBI::ProfileDumper::Apache.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Transport::corostream.3pm
Installing /root/perl5/man/man3/DBI::W32ODBC.3pm
Installing /root/perl5/man/man3/DBD::File::Developers.3pm
Installing /root/perl5/man/man3/DBI::FAQ.3pm
Installing /root/perl5/man/man3/DBD::Proxy.3pm
Installing /root/perl5/man/man3/DBI::ProfileDumper.3pm
Installing /root/perl5/man/man3/Win32::DBIODBC.3pm
Installing
 /root/perl5/man/man3/DBD::DBM.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Request.3pm
Installing /root/perl5/man/man3/DBD::File::Roadmap.3pm
Installing /root/perl5/man/man3/DBI::Profile.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Transport::Base.3pm
Installing /root/perl5/man/man3/DBD::Gofer.3pm
Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::Developers.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Transport::stream.3pm
Installing /root/perl5/man/man3/DBD::File::HowTo.3pm
Installing /root/perl5/man/man3/Bundle::DBI.3pm
Installing /root/perl5/man/man3/DBI::Const::GetInfoReturn.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Serializer::Base.3pm
Installing
 /root/perl5/man/man3/DBI::Gofer::Serializer::Storable.3pm
Installing /root/perl5/man/man3/DBI::DBD::SqlEngine.3pm
Installing /root/perl5/man/man3/DBD::File.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Transport::stream.3pm
Installing /root/perl5/man/man3/DBI::Gofer::Response.3pm
Installing /root/perl5/man/man3/DBD::Gofer::Policy::rush.3pm
Installing /root/perl5/bin/dbiprof
Installing /root/perl5/bin/dbiproxy
Installing /root/perl5/bin/dbilogstrip


And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.

Thus, now, my DBI.pm is located in the following location:
/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm
/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm

This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error

For
 spamassassin, the error is Can't locate DBI.pm in @INC (@INC contains: 
lib /usr/local/share/perl/5.14.2 /etc/perl /usr/local/lib/perl/5.14.2 
/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 
/usr/local/lib/site_perl) at 
/usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line 
82.

For
 amavis, the error is Can't locate DBI.pm in @INC (@INC contains: lib 
/etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 
/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 
/usr/local/lib/site_perl) at
 /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/SQL.pm line 
50.

Can't
 locate DBI.pm in @INC (@INC contains: lib /etc/perl 
/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 
/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 
/usr/local/lib/site_perl) at 
/usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/MySQL.pm line 
51.

For
 sqlgrey, it is Can't locate DBI.pm in @INC (@INC contains: /etc/perl 
/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 
/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 
/usr/local/lib/site_perl .) at /usr/sbin/sqlgrey line 34.
BEGIN failed--compilation aborted at /usr/sbin/sqlgrey line 34.

I was wondering if there is any way of pointing it to the right location of DBI and DBD-mysql so that it would be able to load
 the DBI.pm (without having to rebuild my system from scratch)

Thank you in advance