I needed to install MySQL 5.5 on my CentOS 5.6. I found it on the remi repo and went ahead and installed it using yum along with mysql-libs, devel, dbd etc.
Everything is installed and working great! My problem is now I need to update DBD::MySQL and yum only comes back with version 3x when 4.0 is the latest. When I tried via CPAN, make test fails with:
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t .................. 1/6
# Failed test 'use DBD::mysql;'
# at t/00base.t line 21.
Bailout called. Further testing stopped: Unable to load DBD::mysql
# Tried to use 'DBD::mysql'.
# Error: Can't load '/root/.cpan/build/DBD-mysql-4.019-mC9aro/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-4.019-mC9aro/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: is_prefix at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
# at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 255
/usr/bin/make test -- NOT OK
I've been searching these forums and the web in general and I've founds a couple of answers that didn't work for me (putting a simlink from the libmysqlclient to /usr/lib, including the lz compression library etc).
On another note, in my searching around I've seen a lot of references of dbd::mysql 4.x appearing in standard yum repo's, so does that mean that there is something else wrong entirely? I did need to put the data dir in a non-default location and had to update those dir to make SELinux happy, but like I said everything is running great, its just a old version of DBD::mysql that I want to update.
Any ideas? It would be awesome if there were some way to get um to update.