Hey…
Toolic and Davido: I’ve included the entire test below (its short :D) I have tried caps and non-caps and both, I think DBD::mysql is non-caps on the “M” whereas Mysql.pm is caps. I’ve tried (I think) all iterations…but I’ll try them all again.

My other scripts (the ones written against Perl 5.8 use the Mysql.pm module – so maybe the focus should be on trying to get it to load properly through MCPAN. I do want to have the other scripts working with Perl 5.14 (see below).

@Onelesd: I DO in fact have two versions installed in the same system. One in /usr/bin and one in /usr/local/bin. The perl 5.14 install went there by default. I wasn;t sure if this was the issue since …

A) The OTHER MCPAN installs went in fine (except for Mysql) and B) The paths in the @INC statement (error message) all seem to be pointing to the 5.14 paths (although I could be wrong).

----> I updated Perl by doing a fresh config and install from the tar.gz. Is there a way to actuall “update” 5.8?

Thanks for the help!!

SNIPPET #!/usr/local/bin/perl -l

use DBD::Mysql;
use Date::Manip;
use Date::Manip::Date;

# CONFIG VARIABLES
$database = "tapestorage";
$host = "localhost";
$tablename = "tapes";
$user = "root";
$pw = "";

$connect = Mysql->connect($host, $database, $user, $pw);
$connect->selectdb($database);
$mysqlquery = "SELECT * FROM tapes WHERE expdate > '$startdate' AND expdate <= '$enddate';";
$execute = $connect->query($mysqlquery);
while (@results = $execute->fetchrow()) {
print fh "$results[0]|$results1|$results2";
}

$data = qx{rsh
master /usr/openv/netbackup/bin/admincmd/bpmedialist -m SJ9063 -mlist -l};
@bpmedialist = split(/ /,$data);

$test=ParseDateString("epoch $bpmedialist6");
print "Test = $test";
END SNIPPET

In reply to Re: Can't locate DBD/Mysql.pm in @INC by BurningKrome
in thread Can't locate DBD/Mysql.pm in @INC by BurningKrome

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.