Re: [MonetDB-users] openssl not found when it is present

On Thu, Aug 04, 2011 at 01:35:34PM +0300, Michael Sioutis wrote:

From the MonetDB manpage: http://www.monetdb.org/Documentation/mclient-man-page

Indeed. Thanks! Also, (on systems that do support manpages; basically all but Windows,) MonetDB comes with man pages for mclient, monetdb, monetdbd, mserver5, msqldump. `man mclient` also yiels the below:

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 ^^^ ^^ "-lx" (aka. --language=xquery) is only avaiable with the frozen Mar2011 release of MonetDB/XQuery.

"-t" is no longer available. Timing information is available in the interactive mclient: ======== $ mclient Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.5.0, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.586ms) sql>\q ======== and if a non-interactive mclients sends SQL statements "interactively" (line-wise, one statement at a time) used the "-i" swithc in the following cases: ======== $ echo 'select 1;' > /tmp/1.sql ======== $ echo 'select 1;' | mclient -i +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.506ms) ^^^^^^^ ======== $ mclient -i < /tmp/1.sql +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.490ms) ^^^^^^^ ======== but not in these cases: ======== $ mclient -i /tmp/1.sql Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.5.0, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple sql>\q ======== $ mclient -i -s'select 1;' Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.5.0, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple sql>\q ======== Stefan

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 wrote:

...

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

------------------------------------------------------------------------------ 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

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |