- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal bpm.mx, , 1.137, 1.138 mal_mapi.mx, , 1.16, 1.17
by Stefan Manegold 11 Sep '08

11 Sep '08

On Wed, Sep 10, 2008 at 07:06:16PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20655 > > Modified Files: > bpm.mx mal_mapi.mx > Log Message: > bpm- defense against failed BATextend As mentioned before, proper error handling would be the better solution than an assert in such cases --- recall and be aware the assertions are disabled in released versions; hence, case of a failing BATextend the released version will react with a segfault! Stefan > > > U bpm.mx > Index: bpm.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/bpm.mx,v > retrieving revision 1.137 > retrieving revision 1.138 > diff -u -d -r1.137 -r1.138 > --- bpm.mx 25 Aug 2008 16:12:42 -0000 1.137 > +++ bpm.mx 10 Sep 2008 19:06:14 -0000 1.138 > @@ -1535,7 +1535,8 @@ > bn= BATdescriptor(px->bid); > if( bn== NULL) > throw(MAL,"bpm.addPartition","Partition BAT not found"); > - BATappend(bn,b,TRUE); > + bn= BATappend(bn,b,TRUE); > + assert(bn!=NULL); ^^^^^^^^^^^^^^^^^ > px ->cnt += BATcount(b); > BBPunfix(bn->batCacheid); > #ifdef _DEBUG_BPM_ > @@ -2266,7 +2267,8 @@ > b= BATdescriptor(i); > if( b== NULL) > throw(MAL,"bpm.fold","Partitioned BAT not found"); > - BATappend(bn,b,FALSE); > + bn= BATappend(bn,b,FALSE); > + assert(bn!=NULL); ^^^^^^^^^^^^^^^^^ > /* remove its persistency counter */ > BBPdecref(b->batCacheid,TRUE); > BBPunfix(b->batCacheid); > > > ------------------------------------------------------------------------- > 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-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 2

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal tablet.mx, , 1.170, 1.171
by Stefan Manegold 10 Sep '08

10 Sep '08

On Wed, Sep 10, 2008 at 10:36:27AM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17819 > > Modified Files: > tablet.mx > Log Message: > More defenses. > > > U tablet.mx > Index: tablet.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/tablet.mx,v > retrieving revision 1.170 > retrieving revision 1.171 > diff -u -d -r1.170 -r1.171 > --- tablet.mx 10 Sep 2008 09:30:16 -0000 1.170 > +++ tablet.mx 10 Sep 2008 10:36:19 -0000 1.171 > @@ -1964,10 +1964,12 @@ > for( i=0; i< (int)as->nr_attrs; i++) { > if (as->format[i].c) { > /* prepare enough space */ > - BATextend( as->format[i].c, cnt ); > + as->format[i].c = BATextend( as->format[i].c, cnt ); > + assert(as->format[i].c != NULL); Assertions are (usually) ment for ensuring consistency of the code and its usage and (hence) to detect situations that may/must ("can") not occur under "normal" circumstances; A BATextend (i.e., a malloc) can very well fail in normal circumstance (e.g., when running out of memory); hence, such a situation should (must?) better be detected and handled by some error handling code, not by an assertion; Recall and be aware that assertions are disabled in the release production version, i.e., in this case a failing BATextend (e.g., due to shortage of memory or address space) will lead to undefined behavor of the code, potentially a segmentation fault. This is IMHO not desired ... Stefan > for (j=0; j<nway; j++) { > assert (partition[j]->format[i].c); > - BATappend(as->format[i].c, partition[j]->format[i].c,TRUE); > + as->format[i].c= BATappend(as->format[i].c, partition[j]->format[i].c,TRUE); > + assert(as->format[i].c!= NULL); > BATsave(as->format[i].c); > /* Throw away the temporary bats a.s.a.p. without saveing */ > BBPunfix(partition[j]->format[i].c->batCacheid); > > > ------------------------------------------------------------------------- > 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-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

[Monetdb-developers] Re : Re : ODBC, no database selected
by sylver_b 10 Sep '08

10 Sep '08

That will do fine and i can scrap the perl tool all together if this can do the job - I will try that . any idea for the ODBC issue ? is it maintained by you guys (cwi ) ? Thanks ----- Message d'origine ---- De : Stefan Manegold <Stefan.Manegold(a)cwi.nl> À : sylver_b <sylver_b(a)yahoo.com> Cc : monetdb-developers(a)lists.sourceforge.net Envoyé le : Mercredi, 10 Septembre 2008, 9h06mn 57s Objet : Re : [Monetdb-developers] ODBC, no database selected On Wed, Sep 10, 2008 at 12:21:46AM -0700, sylver_b wrote: > Hi Stefan, > > I've started the DB with the following commands : > 1. merovingian > 2. monetdb create demo > 3. monetdb start demo > 3. mclient -lsql --time -d demo > > I get the prompt straight away, but i have to specify the db - mclient > -lsql , says: !please specify a database - i don't have any other DB at > the moment, just evaluating monetdb to migrate a call detail records > application ; for that purpose i've developed a simple ETL tool in perl > that extract specific fields from a CSV file and insert them in the DB. > Maybe there is a better way to do that ? In case you need the perl part only for extracting and loading, a simple work around to get a quick start, in case you/we do not manage to get the perl interface working for you quickly, would be to either load all fields from your CSV file using sql "COPY ... INTO .. FROM ..." command (cf., http://monetdb.cwi.nl/SQL/Documentation/Data-Manipulation.html) or extract the desired fileds into a separate CSV file, first, and then load using "COPY ... INTO .. FROM ..." (e.g., via mclient) ... Stefan > by the way , ps faux gives me : > root 11224 0.0 0.0 63160 1816 pts/2 Sl 00:17 0:00 merovingian > root 11229 0.0 1.7 107680 69816 ? Ssl 00:17 0:00 \_ /root/MonetDB/bin/mserver5 --config=/root/MonetD > B/etc/monetdb5.conf --dbname=demo --dbinit=include sql; --set monet_daemon yes --set mapi_open true --set mapi_port 0 > --set monet_vault_key /root/MonetDB/var/MonetDB5/dbfarm/demo/.vaultkey > > Please advise, > Thanks > SB > > > > > ----- Message d'origine ---- > De : Stefan Manegold <Stefan.Manegold(a)cwi.nl> > À : sylver_b <sylver_b(a)yahoo.com> > Cc : monetdb-developers(a)lists.sf.net > Envoyé le : Mercredi, 10 Septembre 2008, 6h19mn 03s > Objet : Re: [Monetdb-developers] ODBC, no database selected > > Hi "sylver_b", > > just a simple & quick saniy check: > > How did you start your MonetDB server? > > Can you connect with `mclient -lsql`? > > Stefan > > On Tue, Sep 09, 2008 at 04:56:47PM -0700, sylver_b wrote: > > Hi Eveyone, > > > > I'm trying to connect to monetdb with this time, ODBC - but still no luck. > > > > Here is the output of my script : > > > > ./monetdb2.pl > > DBI connect('DSN_MonetDB','monetdb',...) failed: [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) at ./monetdb2.pl line 6 > > [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) > > > > cat monetdb2.pl > > #!/usr/bin/perl > > > > use DBI(); > > > > > > my $dbh = DBI-> connect('dbi:ODBC:DSN_MonetDB', 'monetdb', 'monetdb', {database => demo}) or die ($DBI::errstr . "\n"); > > > > if (!$dbh) > > { > > print "$DBI::err\n$DBI::errstr\n$DBI::state"; > > } > > else > > { > > $dbh->disconnect if ($dbh); > > } > > > > my $sth = $dbh->prepare('SELECT * FROM env() env'); > > $sth->execute; > > $sth->dump_results; > > > > This the merovingian output : > > tail -f /root/MonetDB/var/log/merovingian.log > > MSG demo[11229]: # MonetDB server v5.6.0, based on kernel v1.24.0 > > MSG demo[11229]: # Serving database 'demo' > > MSG demo[11229]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked > > MSG demo[11229]: # Copyright (c) 1993-2008 CWI, all rights reserved > > MSG demo[11229]: # Visit http://monetdb.cwi.nl/ for further information > > MSG demo[11229]: # Listening for connection requests on mapi:monetdb://ulys:50001/ > > ERR merovingian[11224]: client error: no database specified > > MSG merovingian[11224]: database 'demo' already running since 2008-09-10 00:17:32, up min/avg/max: 30/2181/7036, crash average: 0.00 0.00 0.00 (6-5=0) > > MSG merovingian[11224]: proxying client 127.0.0.1:59244 for database 'demo' to mapi:monetdb://ulys:50001/ > > MSG merovingian[11224]: client has 127.0.0.1:59244 disconnected from proxy > > > > ERR merovingian[11224]: client error: no database specified > > > > This is the content of my odbc.ini & odbcinst.ini : > > > > [DSN_MonetDB] > > Description = ODBC Driver for MonetDB SQL Server > > Driver = /root/MonetDB/lib/libMonetODBC.so > > Port = 50000 > > Host = localhost > > Database = demo > > User = monetdb > > Password = monetdb > > Debug = 1 > > Trace = 1 > > DebugFile = /var/log/odbc-debugfile.log > > TraceFile = /var/log/odbc-tracefile.log > > > > odbcinst.ini > > [DSN_MonetDB] > > Description = ODBC Driver for MonetDB SQL Server > > Driver = /root/MonetDB/lib/libMonetODBC.so > > Setup = /root/MonetDB/lib/libMonetODBCs.so > > FileUsage = 1 > > CommLog = 1 > > Debug = 1 > > > > I also tried with PHP odbc, same result - how to specify the DB right from the script ? > > > > > > > > ------------------------------------------------------------------------- > > 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(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > > > -- > | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | > | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | > | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | > | The Netherlands | Fax : +31 (20) 592-4312 | > > > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 1

[Monetdb-developers] Re : Re : Cannot get perl talking to monetdb5 nightly stable
by sylver_b 10 Sep '08

10 Sep '08

Hi Yes i've contacted Steffen- this was his complete answer : On Tue, Sep 9, 2008 at 9:21 AM, Steffen Goeldner wrote: Hi Steffen, I'm experiencing some difficulties with the Perl lib - 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'm really unhappy that I found no time to maintain the perl modules lately. 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. Steffen ----- Message d'origine ---- De : Fabian Groffen <Fabian.Groffen(a)cwi.nl> À : monetdb-developers(a)lists.sourceforge.net Envoyé le : Mercredi, 10 Septembre 2008, 8h11mn 45s Objet : Re: [Monetdb-developers] Re : Cannot get perl talking to monetdb5 nightly stable 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 : You had contact with Steffen Goeldner? > >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 am trying to come up with a patch for MapiPP, since it's clearly useless in its current state. ------------------------------------------------------------------------- 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(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

3 3

[Monetdb-developers] Re : ODBC, no database selected
by sylver_b 10 Sep '08

10 Sep '08

Hi Stefan, I've started the DB with the following commands : 1. merovingian 2. monetdb create demo 3. monetdb start demo 3. mclient -lsql --time -d demo I get the prompt straight away, but i have to specify the db - mclient -lsql , says: !please specify a database - i don't have any other DB at the moment, just evaluating monetdb to migrate a call detail records application ; for that purpose i've developed a simple ETL tool in perl that extract specific fields from a CSV file and insert them in the DB. Maybe there is a better way to do that ? by the way , ps faux gives me : root 11224 0.0 0.0 63160 1816 pts/2 Sl 00:17 0:00 merovingian root 11229 0.0 1.7 107680 69816 ? Ssl 00:17 0:00 \_ /root/MonetDB/bin/mserver5 --config=/root/MonetD B/etc/monetdb5.conf --dbname=demo --dbinit=include sql; --set monet_daemon yes --set mapi_open true --set mapi_port 0 --set monet_vault_key /root/MonetDB/var/MonetDB5/dbfarm/demo/.vaultkey Please advise, Thanks SB ----- Message d'origine ---- De : Stefan Manegold <Stefan.Manegold(a)cwi.nl> À : sylver_b <sylver_b(a)yahoo.com> Cc : monetdb-developers(a)lists.sf.net Envoyé le : Mercredi, 10 Septembre 2008, 6h19mn 03s Objet : Re: [Monetdb-developers] ODBC, no database selected Hi "sylver_b", just a simple & quick saniy check: How did you start your MonetDB server? Can you connect with `mclient -lsql`? Stefan On Tue, Sep 09, 2008 at 04:56:47PM -0700, sylver_b wrote: > Hi Eveyone, > > I'm trying to connect to monetdb with this time, ODBC - but still no luck. > > Here is the output of my script : > > ./monetdb2.pl > DBI connect('DSN_MonetDB','monetdb',...) failed: [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) at ./monetdb2.pl line 6 > [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) > > cat monetdb2.pl > #!/usr/bin/perl > > use DBI(); > > > my $dbh = DBI-> connect('dbi:ODBC:DSN_MonetDB', 'monetdb', 'monetdb', {database => demo}) or die ($DBI::errstr . "\n"); > > if (!$dbh) > { > print "$DBI::err\n$DBI::errstr\n$DBI::state"; > } > else > { > $dbh->disconnect if ($dbh); > } > > my $sth = $dbh->prepare('SELECT * FROM env() env'); > $sth->execute; > $sth->dump_results; > > This the merovingian output : > tail -f /root/MonetDB/var/log/merovingian.log > MSG demo[11229]: # MonetDB server v5.6.0, based on kernel v1.24.0 > MSG demo[11229]: # Serving database 'demo' > MSG demo[11229]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked > MSG demo[11229]: # Copyright (c) 1993-2008 CWI, all rights reserved > MSG demo[11229]: # Visit http://monetdb.cwi.nl/ for further information > MSG demo[11229]: # Listening for connection requests on mapi:monetdb://ulys:50001/ > ERR merovingian[11224]: client error: no database specified > MSG merovingian[11224]: database 'demo' already running since 2008-09-10 00:17:32, up min/avg/max: 30/2181/7036, crash average: 0.00 0.00 0.00 (6-5=0) > MSG merovingian[11224]: proxying client 127.0.0.1:59244 for database 'demo' to mapi:monetdb://ulys:50001/ > MSG merovingian[11224]: client has 127.0.0.1:59244 disconnected from proxy > > ERR merovingian[11224]: client error: no database specified > > This is the content of my odbc.ini & odbcinst.ini : > > [DSN_MonetDB] > Description = ODBC Driver for MonetDB SQL Server > Driver = /root/MonetDB/lib/libMonetODBC.so > Port = 50000 > Host = localhost > Database = demo > User = monetdb > Password = monetdb > Debug = 1 > Trace = 1 > DebugFile = /var/log/odbc-debugfile.log > TraceFile = /var/log/odbc-tracefile.log > > odbcinst.ini > [DSN_MonetDB] > Description = ODBC Driver for MonetDB SQL Server > Driver = /root/MonetDB/lib/libMonetODBC.so > Setup = /root/MonetDB/lib/libMonetODBCs.so > FileUsage = 1 > CommLog = 1 > Debug = 1 > > I also tried with PHP odbc, same result - how to specify the DB right from the script ? > > > > ------------------------------------------------------------------------- > 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(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 1

[Monetdb-developers] Re : Re : Cannot get perl talking to monetdb5 nightly stable
by sylver_b 10 Sep '08

10 Sep '08

Hi To make this successful, I think ODBC is the best bet here, as i also would like to migrate a PHP application that use Propel (symfony framework) - they don't have monetdb implemented but they do have ODBC. SB ----- Message d'origine ---- De : Fabian Groffen <Fabian.Groffen(a)cwi.nl> À : monetdb-developers(a)lists.sourceforge.net Envoyé le : Mercredi, 10 Septembre 2008, 8h23mn 34s Objet : Re: [Monetdb-developers] Re : Cannot get perl talking to monetdb5 nightly stable 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? ------------------------------------------------------------------------- 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(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

1 0

[Monetdb-developers] Re : ODBC, no database selected
by sylver_b 10 Sep '08

10 Sep '08

Hi Fabian, Effectively , successful connections are from the mclient. SB ----- Message d'origine ---- De : Fabian Groffen <Fabian.Groffen(a)cwi.nl> À : monetdb-developers(a)lists.sourceforge.net Envoyé le : Mercredi, 10 Septembre 2008, 7h55mn 38s Objet : Re: [Monetdb-developers] ODBC, no database selected Hi Sylver, On 09-09-2008 16:56:47 -0700, sylver_b wrote: [snip] > my $dbh = DBI-> connect('dbi:ODBC:DSN_MonetDB', 'monetdb', 'monetdb', > {database => demo}) or die ($DBI::errstr . "\n"); My perl is pretty much non-existant. However, it looks as if you *do* specify that you want to use a database, "demo" in this case. > This the merovingian output : > tail -f /root/MonetDB/var/log/merovingian.log > MSG demo[11229]: # MonetDB server v5.6.0, based on kernel v1.24.0 > MSG demo[11229]: # Serving database 'demo' > MSG demo[11229]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs > dynamically linked > MSG demo[11229]: # Copyright (c) 1993-2008 CWI, all rights reserved > MSG demo[11229]: # Visit http://monetdb.cwi.nl/ for further information > MSG demo[11229]: # Listening for connection requests on mapi:monetdb:// > ulys:50001/ > ERR merovingian[11224]: client error: no database specified > MSG merovingian[11224]: database 'demo' already running since > 2008-09-10 00:17:32, up min/avg/max: 30/2181/7036, crash average: 0.00 > 0.00 0.00 (6-5=0) > MSG merovingian[11224]: proxying client 127.0.0.1:59244 for database > 'demo' to mapi:monetdb://ulys:50001/ > MSG merovingian[11224]: client has 127.0.0.1:59244 disconnected from > proxy > > ERR merovingian[11224]: client error: no database specified Merovingian here sees no database requested. The other successful calls in this log snippet are from mclient or something? > I also tried with PHP odbc, same result - how to specify the DB right > from the script ? Weird. Maybe the odbc driver doesn't catch up the database argument (yet). Sjoerd, any idea on this one? ------------------------------------------------------------------------- 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(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

1 0

[Monetdb-developers] Re : Cannot get perl talking to monetdb5 nightly stable
by sylver_b 10 Sep '08

10 Sep '08

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(a)yahoo.com> À : monetdb-developers(a)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'); $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=HASH(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 stableFrom: Rt Ibmer <rtibmx@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 http://homepages.cwi.nl/~mk/MonetDB/The-Perl-Library.html 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.

3 3

[Monetdb-developers] ODBC, no database selected
by sylver_b 10 Sep '08

10 Sep '08

Hi Eveyone, I'm trying to connect to monetdb with this time, ODBC - but still no luck. Here is the output of my script : ./monetdb2.pl DBI connect('DSN_MonetDB','monetdb',...) failed: [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) at ./monetdb2.pl line 6 [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) cat monetdb2.pl #!/usr/bin/perl use DBI(); my $dbh = DBI-> connect('dbi:ODBC:DSN_MonetDB', 'monetdb', 'monetdb', {database => demo}) or die ($DBI::errstr . "\n"); if (!$dbh) { print "$DBI::err\n$DBI::errstr\n$DBI::state"; } else { $dbh->disconnect if ($dbh); } my $sth = $dbh->prepare('SELECT * FROM env() env'); $sth->execute; $sth->dump_results; This the merovingian output : tail -f /root/MonetDB/var/log/merovingian.log MSG demo[11229]: # MonetDB server v5.6.0, based on kernel v1.24.0 MSG demo[11229]: # Serving database 'demo' MSG demo[11229]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked MSG demo[11229]: # Copyright (c) 1993-2008 CWI, all rights reserved MSG demo[11229]: # Visit http://monetdb.cwi.nl/ for further information MSG demo[11229]: # Listening for connection requests on mapi:monetdb://ulys:50001/ ERR merovingian[11224]: client error: no database specified MSG merovingian[11224]: database 'demo' already running since 2008-09-10 00:17:32, up min/avg/max: 30/2181/7036, crash average: 0.00 0.00 0.00 (6-5=0) MSG merovingian[11224]: proxying client 127.0.0.1:59244 for database 'demo' to mapi:monetdb://ulys:50001/ MSG merovingian[11224]: client has 127.0.0.1:59244 disconnected from proxy ERR merovingian[11224]: client error: no database specified This is the content of my odbc.ini & odbcinst.ini : [DSN_MonetDB] Description = ODBC Driver for MonetDB SQL Server Driver = /root/MonetDB/lib/libMonetODBC.so Port = 50000 Host = localhost Database = demo User = monetdb Password = monetdb Debug = 1 Trace = 1 DebugFile = /var/log/odbc-debugfile.log TraceFile = /var/log/odbc-tracefile.log odbcinst.ini [DSN_MonetDB] Description = ODBC Driver for MonetDB SQL Server Driver = /root/MonetDB/lib/libMonetODBC.so Setup = /root/MonetDB/lib/libMonetODBCs.so FileUsage = 1 CommLog = 1 Debug = 1 I also tried with PHP odbc, same result - how to specify the DB right from the script ?

3 2

Re: [Monetdb-developers] Cannot get perl talking to monetdb5 nightly stable
by sylver_b 09 Sep '08

09 Sep '08

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'); $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=HASH(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 stableFrom: Rt Ibmer <rtibmx@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 http://homepages.cwi.nl/~mk/MonetDB/The-Perl-Library.html 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.

1 0