Error running porgram
 

Hi all, any idea about the error below?

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.

Followup,

Here's the content of my script. When I run it, I got an or as in my previous post. Any ideas?


#!/usr/bin/perl
use DBI;

my $dbh = DBI->connect ("DBI:mysql:vpopmail:localhost", "username","password")
|| die "Could not connect to database:"
. DBI-> errstr;

my $sql_stmnt = "SELECT pw_name, pw_clear_passwd FROM kids_table";
my $sth = $dbh->prepare($sql_stmnt);
$sth->execute();

while (my($pw_name, $pw_clear_passwd) = $sth->fetchrow_array()) {
system "/home/vpopmail/bin/vadduser $pw_name\@domain.com.ph $pw_clear_passwd\n";
}