[cobalt-users] RE: [RAQ 4] MySQL, RPM's and PKG

["Alex Lee" <alex@xxxxxxxxxx>]

I don't understand - here's a simple perl script from the DBI FAQ that I
used to test a working MySQL database.


//begin

#!/usr/bin/perl -w

use DBI;

$user = "root";
$password = "cobalt-mysql";

my $dbh = DBI->connect("dbi:mysql:mysql", $user, $password)
      || die "Can't connect to database: $DBI::errstr";

my $sth = $dbh->prepare( q{SELECT user,host FROM user LIMIT 5})
  	  || die "Can't prepare statement: $DBI::errstr";
my $rc = $sth->execute
      || die "Can't execute statement: $DBI::errstr";

print "Query will return $sth->{NUM_OF_FIELDS} fields.\n";
print "Field names: @{ $sth->{NAME} }\n\n";

while (($user, $host) = $sth->fetchrow_array) {
    print "$user: $host\n";
}
# check for problems which may have terminated the fetch early
die $sth->errstr if $sth->err;

$dbh->disconnect;

//end

> -----Original Message-----
> From: Stephan Whelan [mailto:stephan.whelan@xxxxxxxxxxxxxx]
> Sent: Tuesday, November 28, 2000 8:43 AM
> To: cobalt-users@xxxxxxxxxxxxxxx
> Cc: alex@xxxxxxxxxx
> Subject: [RAQ 4] MySQL, RPM's and PKG
>
>
> Alex,
>
> > MySQL-3.22.32-1
> > MySQL-client-3.22.32-1
> > MySQL-shared-3.22.32-1
> > perl-Msql-Mysql-modules-1.2214-1
> > perl-DBI-1.14-1
>
> I concur that these modules have been installed, although I run a test
> script for HyperSeek (which requires the DBD and DBI modules) at
> http://www.deeperblue.net/servertest.cgi and it is reporting that no
> DBD::mysql is installed, only the DBI!
>
> Any further thoughts on this?
>
> Stephan Whelan
> Publisher/Director
>
> Deeper Blue [http://deeperblue.net]
> The Online Resource for the Underwater World
>