Hi,

We have a Perl code via which we are trying to connect to one of the MonetDB instance. Here we are using DBD::monetdb Perl cpan driver for connectivity.

when we run the snippet, it just tries to connect to DB and seems hung, looks like it’s awaiting for user input for password. Also, on the server side logs we see an error (challenge error) can connection will not be established.

Here is a sample snippet which isn’t working. Could anyone help with an idea or code snippet which works with Perl DBI for MonetDB connectivity?

#!/usr/bin/perl

#

use strict;

use warnings;

use DBI();

print "Attempting to connect...\n";

my $dbh = DBI->connect('dbi:monetdb:host=XXXX;port=55555', 'USERNAME', 'Password', { RaiseError => 1 } );

print "Connected.  Trying SQL...\n";

my $sth = $dbh->prepare('SELECT * FROM env');

$sth->execute;

$sth->dump_results;

print "Done\n";

exit 0;

Regards,

Sreejith