- developers-list - monetdb.org

[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

[Monetdb-developers] DBD::monetdb: DBI registration
by Steffen Goeldner 01 Jun '05

01 Jun '05

I'd like to register DBD::monetdb as an official DBI driver: <http://search.cpan.org/~timb/DBI-1.48/lib/DBI/DBD.pm#Registering_a_new_driv…> Of course, the driver and prefix names should be stable. I think, after the last change from 'monet' to 'monetdb', this is the case. Any objections? Steffen

2 1

[Monetdb-developers] SQL upgrade instructions
by Sjoerd Mullender 27 May '05

27 May '05

I wrote the following text to help with upgrading the SQL database. I think something like this should be prominently displayed (or a prominently displayed pointer to the text) so that people read it *before* attempting to upgrade. Comments? Dumping the SQL database. ------------------------- Start the SQL Server and SQL Client as usual. In the SQL Client, type the following three commands. Type them without any extra white space: >.../dump.sql \D > That is, first a line consisting of a greater than symbol followed by the full (!) name of the file in which you want to store the dump. This will redirect future output to the file mentioned. Then a line consisting of just backslash-capital D. This command does the actual dump which is, because of the previous line, stored in the dump file. And finally a line with just a greater than symbol. This closes the file and redirects the output again to the screen. It is also possible to dump from the command line. Start a SQL Server, and then issue the command MapiClient -lsql -umonetdb -Pmonetdb --dump > dump.sql This command will connect to the SQL Server and dump the database into the file dump.sql in the current directory. Restoring the SQL database. --------------------------- After having dumped the database per the preceding instructions, it is possible to restore the database using the following commands. Start the SQL Server and SQL Client as usual. In the SQL Client, type the following command. <.../dump.sql That is, a less than symbol followed by the full (!) path name of the dump file that was produced using the dump instructions. It is also possible to restore from the command line. Start a SQL Server, and then issue the command MapiClient -lsql -umonetdb -Pmonetdb < dump.sql

3 5