Re: Re : Cannot get perl talking to monetdb5 nightly stable
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@...>
> Ã : monetdb-developers@...
> 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 <at> 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 <at> 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@...
> 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@...
-------------------------------------------------------------------------
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=/
RSS Feed