
From the MonetDB manpage: http://www.monetdb.org/Documentation/mclient-man-page
Before mclient starts parsing command line options, it reads a .monetdb
file. If the environment variable DOTMONETDBFILE is set, it reads the
file pointed to by that variable. When unset, mclient searches for a
.monetdb file in the current working directory, and if that doesn't
exist, in the current user's home directory. This file can contain
defaults for the flags user, password and language. For example, an
entry in a .monetdb file that sets the default language for mclient to
sql looks like this: language=sql. To disable reading the .monetdb
file, set the variable DOTMONETDBFILE to the empty string in the envi‐
ronment.
Also:
Timing
You can investigate the performance of mclient queries in some detail
by switching on timing using the mclient -lx -t
command-line switch. Also, while in an interactive mclient session,
timing can be toggled on or off with the \t command
Mike
On Tue, Aug 2, 2011 at 5:00 PM, Medha Atre
Thanks. Installing libssl-dev, libpcre3-dev, and libxml2-dev worked. I have compiled and installed MonetDB server successfully.
A couple of things unresolved --
-> When I try to run "mclient", it asks me for user and password. Long back when I had used MonetDB v5.14.* this was not the case. With some trial and error, I could figure out default user and password (couldn't find in documentation or manpages). I want to do some kind of regression/repetitive queries on MonetDB server, so I was wondering if there is any way to disable user/password checking or is there a way to provide password also at the command line of "mclient"? (No one else is going to connect to this monetdb so I am not very much concerned abt security at this point!)
-> Older mclient had a "-t / --time" option to time the queries/commands when mclient is not run in an interactive mode. The current mclient version doesn't seem to have that. Is there any other way to know time taken to execute queries/commands without going into the interactive session of mclient?
Thanks.
On Tue, Aug 2, 2011 at 3:48 AM, Fabian Groffen
wrote: On 02-08-2011 02:18:42 -0400, Medha Atre wrote:
I am trying to compile MonetDB-11.3.7 on Ubuntu 10.04 distribution (2.6.32-33 64 bit kernel). It fails with "openssl" not found error:
I am running configure script with following options:
$ ./configure --prefix=/work2/MonetDB-install-11.3.7 --enable-optimize --enable-sql --enable-monetdb5 <snip> checking for iconv... yes checking for working iconv... yes checking for iconv declaration... extern size_t iconv (iconv_t cd, char * *inbuf, size_t *inbytesleft, char * *outbuf, size_t *outbytesleft); checking for library containing uuid_generate... no checking for openssl... no configure: error: OpenSSL library not found but required for MonetDB5 $
openssl libraries are present on my system. I tried:
you probably need openssl-dev or something alike installed, see http://www.monetdb.org/Developers/SourceCompile on the paragraph right above the "Make" section.
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users