I have finally managed to install DBD::mysql (with the help of previous postings) but am still not 100% sure about its success.

I installed using 'make install' instead of 'make && make test' and finally it seemed to work. After running my dbd script I got the following results so I assume that the driver has been installed?: 
Driver: ExampleP
Data Source is dbi:ExampleP:dir=.
Driver: Proxy
Driver: mysql

[download]
When I attempt to run my DBD test script (I should also add that I have had this run succesfully many times on different systems) it falls over on the 'connect' line. This is my code 
#!/usr/bin/perl

use strict;
use DBI; 

BEGIN {
    $|=1;
    print "Content-type: text/html\n\n";
    use CGI::Carp('fatalsToBrowser');
}

my $dbh = DBI->connect('DBI:mysql:wwf', 'username', 'pass')  || die "c
+ant open db";

my $sql = "SELECT * FROM url WHERE rec_id = 1399863634";

my $sth = $dbh->prepare( $sql );
$sth->execute();
    
my $goodrow = $sth->fetchrow_hashref;

$dbh->disconnect();
    
print "$goodrow->{'url'}";

[download]
Please note that I am %100 sure of my database detail (ie username pass etc). Even if the database details were wrong, the die command should at least give me the error.

Does anyone have any suggestions or further tests for me to use?

Thanks
Costas

In reply to DBD::mysql by costas

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.