On Tue, Sep 09, 2008 at 01:36:21AM -0700, sylver_b wrote:

...

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 à : monetdb-developers@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

Hi For the one wondering why the Perl lib doesn't work with monetdb , this is the answer from the developer : 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@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 - 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@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@cwi.nl

On 09-09-2008 01:36:21 -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.

I think we should remove MapiPP, it can't and won't work any more. It seems like a relatively large investment to /make/ it work. In contrast, Mapi.pm seems to be up-to-date to the latest protocol, while also being a pure perl implementation. Can you use Mapi.pm for your application?