Page 1 of 1

[SOLVED] mysql DBD install woes

Posted: 2011/05/09 19:12:15
by Analog2112
Folks,

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:

[quote]
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
CAPTTOFU/DBD-mysql-4.019.tar.gz
/usr/bin/make test -- NOT OK

[/quote]

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.

TIA!

Re: mysql DBD install woes

Posted: 2011/05/10 15:45:36
by pschaff
Welcome to the CentOS fora. Reading [url=https://www.centos.org/modules/newbb/viewforum.php?forum=47]FAQ & Readme First[/url] is recommended for new users.

[code]# alias yumlist
alias yumlist='yum --noplugins --showduplicates --enablerepo \* --disablerepo \*-source --disablerepo \*debug\* --disablerepo c5-media list'
# yumlist perl-DBD-MySQL
...
Available Packages
perl-DBD-MySQL.x86_64 3.0007-2.el5 base
perl-DBD-MySQL.x86_64 4.004-1.el5s2 c5-testing
perl-DBD-MySQL.x86_64 4.006-1.el5s2 c5-testing
perl-DBD-MySQL.x86_64 4.010-1.el5.centos c5-testing
perl-DBD-MySQL.x86_64 4.012-1.el5.centos c5-testing
perl-DBD-MySQL.x86_64 4.014-1.el5.rfx rpmforge-extras[/code]
I'd go for the one from [url=http://wiki.centos.org/Repositories/RPMForge]RPMforge repo[/url]; although I can't guaranteed compatibility of any of the above with your Remi packages.

Re: mysql DBD install woes

Posted: 2011/05/10 16:28:45
by Analog2112
Phil, thanks so much, that totally solved my problem! I still don't understand why CPAN couldn't do it but I'm not complaining.

Now not only is the latest driver installed but the SP's we have work again too!

-A

Re: [SOLVED] mysql DBD install woes

Posted: 2011/05/10 16:49:44
by pschaff
You are welcome, and for future reference, use of a package is preferred to CPAN whenever possible.

I presume the thread can now be marked [SOLVED] for posterity, so I am doing so on your behalf. Please let me know if I have presumed too much. :-)

Re: [SOLVED] mysql DBD install woes

Posted: 2011/05/10 22:59:35
by Analog2112
[quote]
pschaff wrote:
You are welcome, and for future reference, use of a package is preferred to CPAN whenever possible.

I presume the thread can now be marked [SOLVED] for posterity, so I am doing so on your behalf. Please let me know if I have presumed too much. :-)[/quote]

Not at all, it is solved.

I actually looked for something to mark the thread solved and I didn't see anything.

Thanks again!

Re: [SOLVED] mysql DBD install woes

Posted: 2011/05/10 23:09:42
by pschaff
You didn't miss anything - the forum software is brain-damaged such that only a moderator can mark the thread by editing the initial post. Just reply with [SOLVED] in the subject and somebody will take care of it. One day we'll get [url=http://qaweb.dev.centos.org/websitever2/]Website 2.0[/url] and a new set of problems. :-)

Re: [SOLVED] mysql DBD install woes

Posted: 2011/07/19 07:19:03
by george22
I'm looking to possibly use CentOS instead of RedHat Enterprise Linux Application Server. I would like to run Open-Xchange (COMMERCIAL EDITION). But the folks over at Open-Xchange.com say their commercial version works on either SUSE or RedHat Enterprise Application Server (AS). A friend of mine said he thought CentOS was based on RedHat's Application Server.
[Moderator edit: Links removed.]

[SOLVED] mysql DBD install woes

Posted: 2011/07/19 14:52:47
by gerald_clark
george22
Do not hijack threads.

Re: [SOLVED] mysql DBD install woes

Posted: 2011/07/19 15:16:02
by pschaff
Also, stop with the spam links! They will be removed from your 6 messages.