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 <[EMAIL PROTECTED]> > à : [email protected] > 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: > [EMAIL PROTECTED]:~# 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 <[EMAIL PROTECTED]> - 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 > [email protected] > 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: [EMAIL PROTECTED] ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
