[Monetdb-developers] Re : Cannot get perl talking to monetdb5 nightly stable

Niels Nes Niels.Nes at cwi.nl
Tue Sep 9 11:08:42 CEST 2008


On Tue, Sep 09, 2008 at 01:36:21AM -0700, sylver_b wrote:
>    HiÂ
>    For the one wondering why the Perl lib doesn't work with
>    monetdb , this is the answer from the developer :
>    >MonetDB::CLI::MapiPP still speaks protocol version 4, not 5.
>    >Maybe the libMapi based MonetDB::CLI::MapiLib works with the
>    >current version - I didn't test it.
>    SB
>    ----- Message d'origine ----
>    De : sylver_b <sylver_b at yahoo.com>
>    Ã : monetdb-developers at lists.sourceforge.net
>    Envoyé le : Mardi, 9 Septembre 2008, 8h24mn 06s
>    Objet : RE: [Monetdb-developers] Cannot get perl talking to
>    monetdb5 nightly stable
>    Hi Everyone,
>    I'm also experiencing some difficulties with Perl - i've spent
>    the past 3 days trying to get this to work but i can't find any
>    log, any error message etc ...
>    I've installed all the perl libs , but when i run the test
>    script, it's just stay there indefinitely with no output,no
>    error - this is the script :
>    cat monetdb2.pl
>    #!/usr/bin/perl
>    use DBI();
>    Â Â my $dbh = DBI->connect('dbi:monetdb:');
>    Â Â my $sth = $dbh->prepare('SELECT * FROM env');
Sorry the example is wrong here. It should be 'SELECT * FROM env() env',
ie the table env is replaced by a function some time ago.

Also I just needed to add the path 
$prefix/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/
to my PERL5LIB environment variable.

With that it seems to work.

Niels

>    Â Â $sth->execute;
>    Â Â $sth->dump_results;
>    I'm running monetdb with the following command:
>    root at ulys:~# mserver5 --dbinit="include sql;" --dbname=demo
>    --daemon=yes
>    # MonetDB server v5.6.0, based on kernel v1.24.0
>    # Serving database 'demo'
>    # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs
>    dynamically linked
>    # Copyright (c) 1993-2008 CWI, all rights reserved
>    # Visit http://monetdb.cwi.nl/ for further information
>    #warning: please don't forget to set your vault key!
>    #(see /root/MonetDB/etc/monetdb5.conf)
>    # Listening for connection requests on
>    mapi:monetdb://127.0.0.1:50000/
>    # MonetDB/SQL module v2.24.0 loaded
>    when i kill the monetdb daemon, my perl script is throwing this
>    error :
>    # ./monetdb2.pl
>    Caught a SIGPIPE at
>    /usr/local/share/perl/5.8.8/MonetDB/CLI/MapiPP.pm line 93
>    $ = eval {...} called from file
>    `/usr/local/share/perl/5.8.8/MonetDB/CLI/MapiPP.pm' line 93
>    $ =
>    MonetDB::CLI::MapiPP::Req::query('MonetDB::CLI::MapiPP::Req=HAS
>    H(0x83a66e0)', 'SELECT * FROM env') called from file
>    `/usr/local/share/perl/5.8.8/DBD/monetdb.pm' line 567
>    $ = eval {...} called from file
>    `/usr/local/share/perl/5.8.8/DBD/monetdb.pm' line 567
>    $ = DBD::monetdb::st::execute('DBI::st=HASH(0x83a683c)') called
>    from file `./monetdb2.pl' line 8
>    Aborted
>    Also i can connect with no problem with mclient (no password
>    required).
>    Please advise on how to get perl talking to monetdb5.
>    Thanks in advance,
>    SB
>    Â
>    ------ original message -------
>    [Monetdb-developers] Cannot get perl talking to monetdb5
>    nightly stable
>    From: Rt Ibmer <rtibmx at ya...> - 2008-06-17 02:06
>    I am using the nightly stable build of monetdb5. All outside of
>    perl->monetdb seems to
>    be working just fine. I just can't get perl to talk to the db.
>    Here's what I did:
>    - installed from nightly stable source on Fedora 8
>    - copied the source
>    from [1]http://homepages.cwi.nl/~mk/MonetDB/The-Perl-Library.h
>    tml into
>    mytest.pl
>    - tried running: perl /tmp/mytest.pl
>    but it came back complaining about missing libs in @INC.
>    So then I added these steps:
>    - /var/tmp/MonetDB-1213632062/MonetDB-client/clients/src/perl
>    - make install
>    and also ran make instlal in the various subdirs like
>    MonetDB-CLI and others (not sure if
>    this step was necessar)
>    Then I tried running the script and this time it executed
>    without the @INC errors. So this
>    was progress.
>    However all I get is this:
>    -------
>    Start a simple Monet MIL interaction
>    data sources: dbi:monetdb:
>    --------
>    and then nothing. It just sits there indefinitely. In playing
>    with the source of the .pl I
>    see that it is the "my $dbh = DBI->connect( $dsn, ..."
>    that execution stops at.Â
>    I have merovingian running and the db is started. I also tried
>    with merovigan stopped and
>    just using mserver5 --dbinit="include sql;" but I had the same
>    result.
>    Am I doing something wrong? Thanks.
> 
> References
> 
>    1. http://homepages.cwi.nl/~mk/MonetDB/The-Perl-Library.html

> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers


-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the developers-list mailing list