NOTE: Problems presently exist, I’m seeking the expert help of the community and Perl Gurus
I have the need to do some quick benchmarking, I use MyBench as it’s effective in being able to plug in a query, some randomness and 2 minutes later (with a correctly configured Perl/MySQL environment) you have multi-threaded load testing.
However, when the environment you are on is not configured, and you only know the basics for Perl Operation and Installation, (code is just code, that’s the easy part) and the box is not accessible to the outside world say for cpan, it gets more complicated. I’ve attempted to install and configure DBI , DBD::mysql and Time::HiRes but without success.
DBI
DBI
was straightforward, a download, make, install worked without issue. a make install was performed.
DBD:mysql
DBD::mysql
didn’t need an compile, mysql.pm already existed and make said it was all up to date. However then running mybench gave the first error.
<br /> failed: Can't locate DBD/mysql.pm in @INC<br />
Ok, so it wasn’t installed as ‘root’. Some small Perl Pathing.
<br /> PERL5LIB=~/DBD-mysql-4.004/lib;export PERL5LIB<br />
Let to the next error:
<br /> failed: Can't locate loadable object for module DBD::mysql in @INC (@INC<br />
Hmmm, a little more complicated. So going back to the compiling part, I realized I could force compile it, and this also confirmed one possible issue, the libmysqlclient library.
<br /> perl Makefile.PL<br /> I will use the following settings for compiling and testing:<br /> cflags (mysql_config) = -I/path/to/mysql/include<br /> embedded (mysql_config) =<br /> libs (mysql_config) = -L/path/to/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm<br /> ..<br />
Both the mysql.h and libmysqlclient software correctly located and valid, but still no luck.
Moving in parallel I then managed a SA that could install the rpm’s (being RHEL). Problem is, MySQL is not installed via RPM, so the only possible means of installing DBD::mysql is to force no dependencies. This did not prove successful be added clues to the problem.
<br /> failed: Can't load '/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230.<br />
So it used the installed DBD::mysql, and it couldn’t find the expected library path. This gives some confident that perhaps the earlier version is right, and that some other dependancy is missing.
I’ve not found any good resource to work though this online in my environmental situation, but surely this is pain that somebody else has experienced.
Thanks for those friends that have already contributed small parts to getting someway here, however it just ain’t working, and I need it to just work.
Any input appreciated.
