Perldbd-Mysql Error

Question

[yogi.bioinfo]

Hello all , i am working on orthomcl ..when i use the command [cdac@nbri bin]$ orthomclLoadBlast my_orthomcl/orthomcl.config my_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 share d 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

But usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so file is present in its directory then why it is showing this error and what i need to do to solve this error ??

Answer 1

[SES]

This answer is a little late, but maybe it will be helpful to someone. The missing file that cannot be loaded is libmysqlclient.so.15 (part of mysqlclient), not mysql.so. Therefore, you need to install MySQL-client and MySQL-devel for your system and a Perl package called DBD::mysql to resolve this issue. This is required to load the BLAST results in the database and create the ortholog tables. Of course, you should confirm you have a working installation of MySQL before proceeding with the installation of the Perl MySQL driver. The easiest way to install the Perl package is to just use the CPAN shell or the like, and all of the dependencies will be handled when you try to install DBD::mysql.