[SOLVED] mysql DBD install woes

Issues related to software problems.

[SOLVED] mysql DBD install woes

Postby Analog2112 » 2011/05/09 19:12:15

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:

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



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!
Analog2112
 
Posts: 5
Joined: 2011/05/09 18:49:53

Re: mysql DBD install woes

Postby pschaff » 2011/05/10 15:45:36

Welcome to the CentOS fora. Reading FAQ & Readme First is recommended for new users.

Code: Select all
# 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

I'd go for the one from RPMforge repo; although I can't guaranteed compatibility of any of the above with your Remi packages.
pschaff
Retired Moderator
 
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America

Re: mysql DBD install woes

Postby Analog2112 » 2011/05/10 16:28:45

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
Analog2112
 
Posts: 5
Joined: 2011/05/09 18:49:53

Re: [SOLVED] mysql DBD install woes

Postby pschaff » 2011/05/10 16:49:44

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. :-)
pschaff
Retired Moderator
 
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America

Re: [SOLVED] mysql DBD install woes

Postby Analog2112 » 2011/05/10 22:59:35

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. :-)


Not at all, it is solved.

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

Thanks again!
Analog2112
 
Posts: 5
Joined: 2011/05/09 18:49:53

Re: [SOLVED] mysql DBD install woes

Postby pschaff » 2011/05/10 23:09:42

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 Website 2.0 and a new set of problems. :-)
pschaff
Retired Moderator
 
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America

Re: [SOLVED] mysql DBD install woes

Postby george22 » 2011/07/19 07:19:03

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.]
george22
 
Posts: 2
Joined: 2011/07/19 07:10:50

[SOLVED] mysql DBD install woes

Postby gerald_clark » 2011/07/19 14:52:47

george22
Do not hijack threads.
gerald_clark
 
Posts: 9240
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: [SOLVED] mysql DBD install woes

Postby pschaff » 2011/07/19 15:16:02

Also, stop with the spam links! They will be removed from your 6 messages.
pschaff
Retired Moderator
 
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America


Return to CentOS 5 - Software Support

Who is online

Users browsing this forum: No registered users and 3 guests