[MonetDB-users] MonetDB Debain and RDF
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.
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.
de default user,password is monetdb,monetdb . but to aboid typing this everytime, i have a small file in my $HOME dir: $ cat $HOME/.monetdb user=monetdb password=monetdb would that help? On Nov 25, 2010, at 17:27 , Andreas Harth wrote:
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.
------------------------------------------------------------------------------ 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
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.
On 25-11-2010 16:28:02 +0100, Andreas Harth wrote:
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 think there is no such thing, but I can help you with the rest
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?
Well, obviously, the database demo was created before without merovingian/monetdb.
$ monetdb create demo2 permission denied
are you (user) in the monetdb group?
$
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?
see the manpages for merovingian and monetdb. The simple answer is: # monetdb release demo2
participants (3)
-
Andreas Harth -
Fabian Groffen -
Ying Zhang