> What version of linux must be installed that Carob was work with perl

Currently you can find precompiled binaries for Redhat Enterprise Linux
4, SuSE Enterprise Server 9 and Debian Sarge 3.1
http://carob.continuent.org/repo/

If you have another Linux distribution please recompile the packages.
The source tarball can be downloaded from
http://carob.continuent.org/Download

> Please explain me that it means:
> LD_PRELOAD=/usr/lib/libmysequoia.so perl TestCarob03.pl

libmysequoia is providing a MySQL C API interface to the client
programs. This means that you can connect to a Sequoia cluster using
perl DBD::mysql in your case. Your *backend* can be *postgreSQL* or
*any* other database what you want.

Let suppose that in your virtual database xml file you have the
following values:

VirtualDatabase name = db1
vLogin="user"
vPassword=""
the controller is running on host = node1
you have a "product" table in the database

Then the correct TestCarob03.pl perl program is:

#!/usr/bin/perl -w

use DBI;
use DBD::mysql;

my $dsn = "dbi:mysql:db1;host=node1";
my $dbh = DBI->connect($dsn, "user","") or die print $DBI::errstr;

my $sth = $dbh->prepare("select id, name from product");
$sth->execute;
my ($id,$name);
while(($id,$name)=$sth->fetchrow_array){
        print "  $id  |  $name\n";
}

Execute this program as:

LD_PRELOAD=/usr/lib/libmysequoia.so perl TestCarob03.pl

Hope that it was helpful.

Regards,
Csaba


_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob

Reply via email to