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.