|
Posted by smallpond on March 14, 2008, 11:22 am
Please log in for more thread options
> Can someone tell me what's going wrong with my perl operation? I
> recently started over my Linux, Apache, Mysql, and Perl on a new hard
> drive when I had a drive failure. Everything on the system is freshly
> installed. At present everything works except for my scripts that
> uses DBD::mysql. I used cpan to install DBD::mysql. It appears to be
> installed okay, but still fail to work.
>
> Please look at the information itemized below.
>
> Thanks in advance for any suggestions or comments.
>
> Simplest code to reproduce the error:
>
> commandline: perl -MDBD::mysql -e 1
> Can't load '/usr/local/lib/perl5/site_perl/5.10.0/i686-linux/auto/DBD/
> mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot
> open shared object file: No such file or directory at /usr/local/lib/
> perl5/5.10.0/i686-linux/DynaLoader.pm line 203.
> at -e line 0
> Compilation failed in require.
> BEGIN failed--compilation aborted.
>
> Attempt to install/verify module via CPAN:
>
> cpan[1]> install DBD::mysql
> CPAN: Storable loaded ok (v2.18)
> Going to read /root/.cpan/Metadata
> Database was generated on Fri, 14 Mar 2008 10:31:09 GMT
> CPAN: YAML loaded ok (v0.65)
> DBD::mysql is up to date (4.006).
>
> Perl's Search Path:
>
> commandline: perl -e "print qq(@INC)" | sed "s/ /\n/g"
> /usr/local/lib/perl5/5.10.0/i686-linux
> /usr/local/lib/perl5/5.10.0
> /usr/local/lib/perl5/site_perl/5.10.0/i686-linux
> /usr/local/lib/perl5/site_perl/5.10.0
> /usr/local/lib/perl5/site_perl/5.8.8
> /usr/local/lib/perl5/site_perl/5.6.1
> /usr/local/lib/perl5/site_perl
>
> Location of installed mysql files from the /usr/local/lib hierarchy:
>
> commandline: find -name mysql\*
> ./site_perl/5.8.8/i686-linux/Bundle/DBD/mysql.pm
> ./site_perl/5.8.8/i686-linux/DBD/mysql
> ./site_perl/5.8.8/i686-linux/DBD/mysql.pm
> ./site_perl/5.8.8/i686-linux/auto/DBD/mysql
> ./site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.bs
> ./site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so
> ./site_perl/5.8.8/CGI/Session/Driver/mysql.pm
> ./site_perl/5.10.0/i686-linux/Bundle/DBD/mysql.pm
> ./site_perl/5.10.0/i686-linux/DBD/mysql
> ./site_perl/5.10.0/i686-linux/DBD/mysql.pm
> ./site_perl/5.10.0/i686-linux/auto/DBD/mysql
> ./site_perl/5.10.0/i686-linux/auto/DBD/mysql/mysql.bs
> ./site_perl/5.10.0/i686-linux/auto/DBD/mysql/mysql.so
> ./site_perl/5.6.1/i686-linux/Bundle/DBD/mysql.pm
> ./site_perl/5.6.1/i686-linux/DBD/mysql
> ./site_perl/5.6.1/i686-linux/DBD/mysql.pod
> ./site_perl/5.6.1/i686-linux/DBD/mysql.pm
> ./site_perl/5.6.1/i686-linux/auto/DBD/mysql
> ./site_perl/5.6.1/i686-linux/auto/DBD/mysql/mysql.bs
> ./site_perl/5.6.1/i686-linux/auto/DBD/mysql/mysql.so
>
> -- L. James
>
> --
> L. D. James
> lja...@apollo3.comwww.apollo3.com/~ljames
Your perl is OK. It needs to interface to the mysql library
which is part of mysql.
On my system, this is loaded by the mysql-libs rpm.
rpm -qf /usr/lib/mysql/libmysqlclient.so.15
mysql-libs-5.0.45-6.fc8
--S
|