I'm nog a merovingian expert, but to quickly try out monet after install, you can also start and use an mserver without merovingian (after having killed any existing erovingian process):

----- in terminal 1 -------- $ mserver5 # MonetDB server v5.22.2, based on kernel v1.40.2 # Not released # Serving database 'demo', using 4 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # Found 7.750 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /.../monet-install/candidate/debug/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.40.2 loaded # MonetDB/GIS module v0.20.2 loaded

----- in terminal 2 -------- $ mclient -lsql Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v5.22.2, 'demo' Type \q to quit, ? for a list of available commands auto commit mode: on sql>select name from tables limit 5; +-----------+ | name | +===========+ | schemas | | types | | functions | | args | | sequences | +-----------+ 5 tuples (3.461ms) sql>

On Nov 25, 2010, at 16:28 , Andreas Harth wrote:

Hi,

I'd like to use Lefteris' RDF package on Debian. What do I have to do to create and connect to a database as user on Debian?

I've installed the following packages:

# dpkg -l | grep -e monetdb ii libmonetdb-client1 1.40.1-20101110 MonetDB database client libraries ii libmonetdb1 1.40.1-20101110 database system for high-performance applications, libraries ii libmonetdb5-server5 5.22.1-20101110 MonetDB database server version 5, libraries ii libmonetdb5-sql2 2.40.1-20101110 MonetDB SQL libraries for monetdb5-server ii monetdb-client 1.40.1-20101110 MonetDB database client ii monetdb5-server 5.22.1-20101110 MonetDB database server version 5 ii monetdb5-sql 2.40.1-20101110 MonetDB SQL support for monetdb5

I can start MonetDB:

# /etc/init.d/monetdb5-sql start Starting MonetDB SQL server: merovingian.

When I try do create the tables (as a user):

$ mclient -lsql create_tables.sql user(aharth): password: merovingian: please specify a database $ $ mclient -lsql create_tables.sql -d demo user(aharth): password: merovingian: internal error while starting mserver, please refer to the logs $

The log says: 2010-11-25 16:20:19 MSG merovingian[3685]: starting database 'demo', up min/avg/max: 3s/4s/5s, crash average: 0.00 0.00 0.00 (2-2=0) 2010-11-25 16:20:19 ERR merovingian[3685]: client error: cannot start database 'demo': no .vaultkey found (did you create the database with `monetdb create demo`?)

I'm stuck here. How can I create a database as a user?

$ monetdb create demo2 permission denied $

As root, I only can create a database in maintainance mode:

# monetdb create demo2 created database in maintenance mode: demo2 #

Any pointers to howto's that'll help?

Cheers, Andreas.

---

Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Hi Ying,

On 11/25/2010 05:22 PM, Ying Zhang wrote:

I'm nog a merovingian expert, but to quickly try out monet after install, you can also start and use an mserver without merovingian (after having killed any existing erovingian process):

if I try that recepie I get:

$ mclient -lsql user(aharth): password: InvalidCredentialsException:checkCredentials:invalid credentials for user 'aharth' $

Couldn't find any descriptions (that'd work with my setup) on user management for Linux on the website.

Best regards, Andreas.

Fabien, Ying,

many thanks for your input! After some tinkering I'm now able to connect to MonetDB and execute "mclient -lsql create_tables.sql".

Cheers, Andreas.