June 2005 - developers-list

[Monetdb-developers] FYI: DBD::monetdb test suite via MonetDB ODBC Driver
by Steffen Goeldner 29 Jun '05

29 Jun '05

FYI, I'm using the DBD::monetdb test suite to test the MonetDB ODBC Driver: set DBI_DSN=dbi:ODBC:driver=MonetDB ODBC Driver dmake test Here is the test summary: Failed Test Stat Wstat Total Fail Failed List of Failed --------------------------------------------------------- t\02cxn.t 5 1280 8 4 50.00% 7-8 t\12bind.t 1 256 6 1 16.67% 3 t\13count.t 16 4096 30 16 53.33% 12-27 t\23null.t 255 65280 14 22 157.14% 4-14 1 test and 2 subtests skipped. Failed 4/22 test scripts, 81.82% okay. 30/382 subtests failed, 92.15% okay. In light of all the additional layers, this is an unexpected good result. (Admittedly, my tests are not very aggressive.) And, even better, all is on the mend: t\02cxn.t This is a bug in DBD::ODBC: <http://www.xray.mpe.mpg.de/mailing-lists/dbi/2005-02/msg00061.html> fixed in svn: <http://svn.perl.org/viewcvs/modules/dbd-odbc/trunk/dbdimp.c?rev=858&r1=561&…> t\12bind.t This is bug #1229018: <http://sourceforge.net/tracker/index.php?func=detail&aid=1229018&group_id=5…> t\13count.t This is a bug in DBD::ODBC. It looks like DBD::ODBC doesn't expect that an ODBC driver is able to return the number of rows of a result set. t\23null.t This is bug #1225455: <http://sourceforge.net/tracker/index.php?func=detail&aid=1225455&group_id=5…> Steffen

1 0

[Monetdb-developers] MonetDB.conf contains path on developer's machine
by Roger Erens 25 Jun '05

25 Jun '05

I don"t know whether MonetDB.conf in CWI\MonetDB\etc is used, but it contains the following lines: # Where MonetDB is installed prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT exec_prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT Roger

2 1

[Monetdb-developers] (no subject)
by Roger Erens 24 Jun '05

24 Jun '05

Hi, I had some problems installing MonetDB-4.8.0 on MS Windows XP: the Duesseldorf sourceforge mirror still serves the installer that misses the pqueue stuff. Removing the wrong version via the Add or Remove Programs left a filled folder CWI in the Program Files folder and also a filled folder in my home folder's Application Data folder called MonetDB. Only after removing these and using the installer from the Paris sourceforge mirror I was freed from a lot of strange messages. All in all, the installer should have its version number upped, I think. Hopefully this will lead to up-to-date mirrors. Also, the installer should notify the user of the old files and folders, giving the choice of backing those up, or overwrite them, or whatever seems best. ===================================================================== Choosing MonetDB SQL Server and MonetDB SQL Client from the Start Menu: # Monet Database Server V4.8.0 # Copyright (c) 1993-2005, CWI. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB> copying from the documentation->Front ends->SQL web page (http://monetdb.cwi.nl/TechDocs/FrontEnds/SQL/index.html): CREATE USER "voc" WITH PASSWORD 'voc' NAME 'VOC Explorer' SCHEMA "sys"; results in a dialog window, containing: Mserver.exe has encountered a problem and needs to close. We are sorry for the inconvenience. AppName: mserver.exe AppVer: 0.0.0.0 ModName: lib_sql_server.dll ModVer: 0.0.0.0 Offset: 00057cfa If you need to have more info, I'll be happy to try to get it for you... ======================================================================= I don't know whether MonetDB.conf in CWI\MonetDB\etc is used, but it contains the following lines: # Where MonetDB is installed prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT exec_prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT which is not right on my system, of course. ======================================================================== = Met vriendelijke groet, Roger Erens Euroned Systems 0900-3876633 r.erens(a)eurosys.nl

2 1

[Monetdb-developers] Re: FW: Returned mail: see transcript for details
by Fabian (MonetDB Project) 16 Jun '05

16 Jun '05

Ignacio Hernandez-Ros wrote: > Hello, > > I'll try to send a patch. > > This is what happens when the query is executed in MapiClient. > > [ihr@jo-con-el FRTA2]$ cat > test.xq > <hello>hola</hello> > [ihr@jo-con-el FRTA2]$ MapiClient -lxquery test.xq > <hello>hola</hello> > [ihr@jo-con-el FRTA2]$ > > And this is what happens when the query is executed in MapiClient using mil > language. > > [ihr@jo-con-el FRTA2]$ MapiClient -lmil > # Monet Database Server V4.9.0 > # Copyright (c) 1993-2005, CWI. All rights reserved. > # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > mil>xquery("xml","<hello>hola</hello>"); > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult> > <hello>hola</hello> > </XQueryResult> > mil> > > The result of an xquery is not a table with rows and columns. Is another > piece of XML that I don't know how to get it back into the PHP code. As far as I know, this should be represented as one column. Maybe it isn't. Sjoerd will know the answer. Perhaps it works better for you in this case if you use the xquery language, instead of mil from your PHP script. Again, I think Sjoerd knows for sure how the response is given shape. > > What you sent me didn't work. Thank you for your support. Are there more > alternatives? > > Regards, > IHR > > Ignacio Hernandez-Ros > XBRL International Inc. - Technology Development > ihr(a)xbrl.org > Cell: +34 609027754

2 1

[Monetdb-developers] Re: FW: Returned mail: see transcript for details
by Fabian (MonetDB Project) 16 Jun '05

16 Jun '05

Ignacio Hernandez-Ros wrote: > Hello, > > I've successfully moved the source to work with PHP5. The only change that I > made was to replace occurrences of OnUpdateInt to OnUpdateLong (two > occurrences) Can you supply a patch easily? Would be great to have it. > > Now I'm in the next problem: > > I wish to execute an xquery and receive the XML output back in the php. > This is the example that I'm doing: > > <?php > if (!extension_loaded('monetdb')) { > $loadedOk = dl('monetdb.so'); > if (!loadedOk) { > die('Module not loaded'); > } > } > $link = monetdb_connect('mil'); > if (!$link) { > die('Could not connect: ' . monetdb_error()); > } > $res = monetdb_query('xquery("xml","<hello>hola</hello>");'); > echo $res; > > while($row = monetdb_fetch_row($res)) { > printf("name=%s htype=%s ttype=%s \n",$row[0],$row[1],$row[2]); > } I'm not sure here, but you can try: $cols = monetdb_num_fields($result); while ($row = @monetdb_fetch_row($res)) { for ($i = 0; $i < $cols; $i++) { print htmlspecialchars($row[$i]); } print "<br />"; } have you tried the query you're executing using MapiClient to see if it results in what you expect? You might need to connect using xquery otherwise, but I'm not sure on that. Regards, Fabian > monetdb_close(); > ?> > > The query is executed but I don't find a way to obtain the xml back to the > php. > > What shall I do? > > Ignacio Hernandez-Ros > XBRL International Inc. - Technology Development > ihr(a)xbrl.org > Cell: +34 609027754 >

1 0

[Monetdb-developers] Re: FW: Returned mail: see transcript for details
by Sjoerd Mullender 16 Jun '05

16 Jun '05

Ignacio Hernandez-Ros wrote: > Does the developers list works? Yes. I just sent a test mail and it arrived promptly. >> I tried to compile MonetDB with php 5.0.4 and I get compilation errors. We have only tried compiling agains PHP version 4 so far. Is it possible for you to use PHP 4? >> I wish to use MonetDB to execute xquery against XBRL taxonomies. You >> can see www.xbrl.org <http://www.xbrl.org/> if you wish. >> >> >> >> In file included from ../../../../common/monet_utils.h:5, >> >> from ../../../../common/stream.h:17, >> >> from ../../C/Mapi.h:6, >> >> from >> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:52: >> >> ../../../../../monetdb_config.h:637:1: warning: "_POSIX_C_SOURCE" >> redefined This doesn look quite right, but my guess is that it doesn't matter too much. For what it's worth, I get this also. >> In file included from >> /usr/lib/gcc-lib/i686-pc-linux-gnu/3.2.2/include/stdio.h:37, >> >> from /usr/include/php/Zend/zend.h:37, >> >> from /usr/include/php/main/php.h:34, >> >> from >> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:44: >> >> /usr/include/features.h:131:1: warning: this is the location of the >> previous definition >> >> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:109: >> warning: missing initializer >> >> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:109: >> warning: (near initialization for `monetdb_functions[22].num_args') >> >> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:178: >> `OnUpdateInt' undeclared here (not in a function) This is the real error. In PHP 4, OnUpdateInt is declared in Zend/zend_ini.h, in the same block which also declares OnUpdateString. Note that in your output there is no indication that OnUpdateString is not defined. zend_ini.h is include by php_ini.h which is included by php_monetdb.c. -- Sjoerd Mullender

1 0

[Monetdb-developers] test
by Sjoerd Mullender 16 Jun '05

16 Jun '05

test, please ignore. -- Sjoerd Mullender

1 0

[Monetdb-developers] license issues
by Sjoerd Mullender 13 Jun '05

13 Jun '05

There is a problem with the MonetDB and Pathfinder licenses. - The new (1.1) license is not yet available on the main web site; - On the staging web site (stem), the license is available with the wrong URL: .../Legal/MonetDBLicense-1.1/index.html instead of .../Legal/MonetDBLicense-1.1.html. I don't know whether the Development that is also stuck into the stem URL is a problem (that depends on how the URLs get translated when this moves to the real web site), but the ending is certainly a problem. The URL must end with MonetDBLicense-1.1.html and not MonetDBLicense-1.1/index.html. And the same for the Pathfinder license. -- Sjoerd Mullender

1 0

[Monetdb-developers] Installation on Windows
by Harry van Lamoen 03 Jun '05

03 Jun '05

I tried to install the binary (.msi) on XP professional. After installation and trying to start the server I get a message Monet Database Server V4.8.0 !ERROR: module/Client: module(pqueue) load error !ERROR: mvc_init: unable to create system tables !WARNING: BBPincref: range error 178 Any idea. Met vriendelijke groet Harry van Lamoen KORÈN Information Technology http://www.koren.nl

2 1

[Monetdb-developers] About MonetDB's modules
by Rodrigo Schmidt 01 Jun '05

01 Jun '05

Hello, I am PhD student at EPFL, Switzerland, and I am working on database replication. I just started looking at MonetDB and I have a simple doubt. Are modules like the SQL module written in MIL or in C/C++? I downloaded the sources of the SQL front end and I found some files whose extension is ".mx" and which seem to implement the SQL translator into MIL. The code looks pretty much like C++. Moreover, I read somewhere in your web page that two-phase-locking is implemented outside the database kernel. Where exactly is it implemented for the SQL front end? Thank you very much in advance! Best regards, Rodrigo Schmidt

3 5