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