PipTigger has asked for the wisdom of the Perl Monks concerning the following question:

I've done the 'perl -MCPAN -e "install Bundle::CPAN"' which got the new Perl 5.6 ... everything seemed fine until I tried to "install Bundle::DBD::mysql" which resulted in tons of errors and unfindable libraries etc. The README says that this is a common problem. All I need to do is recompile Perl and MySQL with the same version of gcc so they both use the same library or something. How do I go about doing that? Do I need to retrieve special sources for the latest Perl and MySQL? Please help. I don't know how to get DBI running and I need it. TTFN & Shalom.

-PipTigger

p.s. The legend will never die.

Replies are listed 'Best First'.
RE: Perl 5.6 && DBD::mysql?
by le (Friar) on Jun 15, 2000 at 17:15 UTC
    Well, if you need to recompile Perl and MySQL, why don't you do it (if you're sitting in front of a Unix box)? Grab the sources from Perl.com and MySQL.com and issue the classic "./configure ; make ; make install" triology.
[reply]
Re: Perl 5.6 && DBD::mysql?
by Shendal (Hermit) on Jun 15, 2000 at 18:39 UTC
    I don't know if you are on NT or UNIX, but the ppm included with Activestate's perl 5.6 added an interactive ppm. Here's the FAQ.

    I have used this to install many different modules on my machine -- it has made it much easier.

    HTH!
[reply]
Re: Perl 5.6 && DBD::mysql?
by elwarren (Priest) on Jun 16, 2000 at 00:09 UTC

    I'm going to assume that you're running unix because you're using the MCPAN method to install modules. I'm also going to assume that since you're running mysql but didn't set it up that you're on an rpm style linux machine. Probably redhat.

    You either need to install the mysql client rpm or the else the mysql src rpm.

    This is one of those situations that the redhat rpm architecture just doesn't handle very well. I think it's more the fault of the package maintainers not including useful files. Normally I install apache and perl by hand just to avoid these problems. Same with the perl modules. Take the default rpm install and install your packages via cpan, not with rpms.

    No flames intended, but do debian or slackware packages (deb and pkg) have the same issues?

[reply]
      I am using RedHat6.2 on one box and Debian on another... both configured almost identically. Everything I've done has been through CPAN either with the .pm or directly d/l'ing and the whole `perl Makefile.PM;make;make test;make install;` routine. I've been away for the entire weekend and just got back now... so I'll try to get the latest sources for each of Perl 5.6 and MySQL and compile them directly on each box. Hopefully I'll be able to do this by just reading README's and other accompanying help texts. One of the servers crashed during the update with a pretty gross assertion and the other one werks great (ie. Perl runs fine and MySQL is running too) but DBD::mysql won't install on it because the make fails. I'm dismayed that no other monk has encountered this and I've done it twice. I must've done something in a really rotten order I guess. I'll try to relate my further travails if I am unsuccessful tonight. Thanks very much for the help all. TTFN & Shalom.

      -PipTigger

      p.s. Initiate Nail Removal Immediately!
[reply]
RE: Perl 5.6 && DBD::mysql?
by PipTigger (Hermit) on Jun 21, 2000 at 14:33 UTC
    I've finally gotten both of the boxes running okay again! Whew! I had to install each of the components manually and on the Debian box I recompiled Perl5.6 and MySQL from source (and copied .so files all over the place for the make test to succeed) but they're werking now quite happily. Thanks muchly helpful monks. TTFN & Shalom.

    -PipTigger

    p.s. This Victory Strengthened the Soul of Mitsurugi...
[reply]

Back to Seekers of Perl Wisdom