LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-30-2013, 08:29 AM   #1
Aghori
LQ Newbie
 
Registered: Jul 2013
Posts: 5

Rep: Reputation: Disabled
Question perl error in using DBD::mysql


Hello all , i amworking on orthomcl software which requirs mysql , when i give the command
[cdac@nbri bin]$ orthomclLoadBlast my_orthomcl/orthomcl.configmy_orthomcl/similarSequence.txt

it gives

Can't load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230, <F> line 5.
at /storage/home/cdac/OrthoMCL/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 48
Compilation failed in require at /storage/home/cdac/OrthoMCL/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 48, <F> line 5.


mysql.so file is present then why it is giving this error??and how to solve this ?
 
Old 07-30-2013, 08:42 AM   #2
daniel w.
LQ Newbie
 
Registered: Jul 2013
Location: EU
Distribution: Slackware
Posts: 20

Rep: Reputation: Disabled
Does perl exists in Your system?

Which distro do You use?

perl -v paste it here


regards
 
Old 07-30-2013, 08:46 AM   #3
Aghori
LQ Newbie
 
Registered: Jul 2013
Posts: 5

Original Poster
Rep: Reputation: Disabled
[cdac@nbri ~]$ perl -v

This is perl, v5.8.8 built for x86_64-linux-thread-multi

Copyright 1987-2006, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
 
Old 07-30-2013, 08:54 AM   #4
daniel w.
LQ Newbie
 
Registered: Jul 2013
Location: EU
Distribution: Slackware
Posts: 20

Rep: Reputation: Disabled
What disibution are u using?

Meybe there are missing perl-mysql modules in your system?

Thats a shot, im not an expert. And in addition my english isnt that good.
Sorry then.


regards
D.W
 
Old 07-30-2013, 09:07 AM   #5
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian i686 (solaris)
Posts: 8,104

Rep: Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267
does this file exist? '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so'. Yes, you may need to install a few perl modules
 
Old 07-30-2013, 09:10 AM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,926

Rep: Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690
Quote:
Originally Posted by Aghori View Post
Hello all , i amworking on orthomcl software which requirs mysql , when i give the command
[cdac@nbri bin]$ orthomclLoadBlast my_orthomcl/orthomcl.configmy_orthomcl/similarSequence.txt
it gives
Code:
Can't load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230, <F> line 5.
 at /storage/home/cdac/OrthoMCL/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 48
Compilation failed in require at /storage/home/cdac/OrthoMCL/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 48, <F> line 5.
mysql.so file is present then why it is giving this error??and how to solve this ?
There may be a mysql.so file, but is it for Perl, and is it in the path referenced above?

Go to CPAN.org, download the package and install it:
http://search.cpan.org/~capttofu/DBD-mysql-4.023/
 
Old 07-30-2013, 09:13 AM   #7
Aghori
LQ Newbie
 
Registered: Jul 2013
Posts: 5

Original Poster
Rep: Reputation: Disabled
yes.. /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so file is there but it is unable to load @ pan64

Last edited by Aghori; 07-30-2013 at 09:30 AM.
 
Old 07-30-2013, 09:19 AM   #8
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian i686 (solaris)
Posts: 8,104

Rep: Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267Reputation: 2267
file '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so'
 
Old 07-30-2013, 09:38 AM   #9
Aghori
LQ Newbie
 
Registered: Jul 2013
Posts: 5

Original Poster
Rep: Reputation: Disabled
which modules i need to install in my machine to run it properly ?? (mysql is already installed)
 
Old 07-30-2013, 11:41 AM   #10
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,926

Rep: Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690
Quote:
Originally Posted by Aghori View Post
which modules i need to install in my machine to run it properly ?? (mysql is already installed)
I posted a link to the missing perl module above. Did you not see it? There is a DOWNLOAD link on it...click it, save it to your system, and follow the installation instructions. Typically:
  • perl Makefile.PL
  • make
  • make test
  • make install
That's it. If it complains about any missing prerequisites, then download them and install them first. Simple.
 
  


Reply

Tags
centos, mysql, perl


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem amchargue Linux - Software 3 09-10-2008 01:01 AM
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
Perl DBD::mysql - Clean a scalar, keep running after error. exodist Programming 1 02-07-2007 07:52 AM
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 05:28 PM
Error with Perl DBD::mysql ginda Programming 3 03-04-2005 07:20 PM


All times are GMT -5. The time now is 04:33 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration