[MonetDB-users] vaultkey, embedded, and merovingian.
Hi. I've been creating a database from a call to monetdb_sql() from libembeddedsql5.so, from my OCaml binding. After that, I start up a merovingian process and I do the following:
yziquel@seldon:~/git/ocaml-monetdb5$ monetdb status name state uptime health last crash testdb stopped 100%, 49s - yziquel@seldon:~/git/ocaml-monetdb5$ monetdb start testdb starting database 'testdb'... FAILED start: starting 'testdb' failed: cannot start database 'testdb': no .vaultkey found (did you create the database with `monetdb create testdb`?)
I'm quite baffled by the error I just got. What is this .vaultkey problem? All the best, -- Guillaume Yziquel http://yziquel.homelinux.org/
On 04-01-2010 21:02:16 +0100, Guillaume Yziquel wrote:
Hi.
I've been creating a database from a call to monetdb_sql() from libembeddedsql5.so, from my OCaml binding.
After that, I start up a merovingian process and I do the following:
yziquel@seldon:~/git/ocaml-monetdb5$ monetdb status name state uptime health last crash testdb stopped 100%, 49s - yziquel@seldon:~/git/ocaml-monetdb5$ monetdb start testdb starting database 'testdb'... FAILED start: starting 'testdb' failed: cannot start database 'testdb': no .vaultkey found (did you create the database with `monetdb create testdb`?)
I'm quite baffled by the error I just got. What is this .vaultkey problem?
Merovingian(1) and monetdb(1) enable increased security features of mserver5. If you start mserver5 manually, you do not enable this. In short, you mix the usage of merovingian(1) and mserver5, that's asking for problems. If you want to create databases with merovingian(1), you best make a connection to merovingian(1)'s control channel to tell it to create a database.
Fabian Groffen a écrit :
On 04-01-2010 21:02:16 +0100, Guillaume Yziquel wrote:
Hi.
I've been creating a database from a call to monetdb_sql() from libembeddedsql5.so, from my OCaml binding.
After that, I start up a merovingian process and I do the following:
yziquel@seldon:~/git/ocaml-monetdb5$ monetdb status name state uptime health last crash testdb stopped 100%, 49s - yziquel@seldon:~/git/ocaml-monetdb5$ monetdb start testdb starting database 'testdb'... FAILED start: starting 'testdb' failed: cannot start database 'testdb': no .vaultkey found (did you create the database with `monetdb create testdb`?)
I'm quite baffled by the error I just got. What is this .vaultkey problem?
Merovingian(1) and monetdb(1) enable increased security features of mserver5. If you start mserver5 manually, you do not enable this.
In short, you mix the usage of merovingian(1) and mserver5, that's asking for problems.
I'm not mixing the use of merovingian and mserver5, but mixing the use of merovingian and monetdb_sql(). Or maybe I misunderstood you.
If you want to create databases with merovingian(1), you best make a connection to merovingian(1)'s control channel to tell it to create a database.
OK. So is it possible to create a database via a call to monetdb_sql(), and to access it via a command line tool such as mclient? If yes, how? All the best, -- Guillaume Yziquel http://yziquel.homelinux.org/
I'm unclear why you're attempting external connections with an embedded server but it's for the vault issue at least it's trivial to avoid the dependency on an external file, e.g. in embeddedclient.c unlock the vault like this: char* secret = (char*)"somehardcodedstring"; if (AUTHunlockVault(&secret) != MAL_SUCCEED) return 0; On Mon, Jan 4, 2010 at 3:23 PM, Guillaume Yziquel < guillaume.yziquel@citycable.ch> wrote:
On 04-01-2010 21:02:16 +0100, Guillaume Yziquel wrote:
Hi.
I've been creating a database from a call to monetdb_sql() from libembeddedsql5.so, from my OCaml binding.
After that, I start up a merovingian process and I do the following:
yziquel@seldon:~/git/ocaml-monetdb5$ monetdb status name state uptime health last crash testdb stopped 100%, 49s - yziquel@seldon:~/git/ocaml-monetdb5$ monetdb start testdb starting database 'testdb'... FAILED start: starting 'testdb' failed: cannot start database 'testdb': no .vaultkey found (did you create the database with `monetdb create testdb`?)
I'm quite baffled by the error I just got. What is this .vaultkey
Fabian Groffen a écrit : problem?
Merovingian(1) and monetdb(1) enable increased security features of mserver5. If you start mserver5 manually, you do not enable this.
In short, you mix the usage of merovingian(1) and mserver5, that's asking for problems.
I'm not mixing the use of merovingian and mserver5, but mixing the use of merovingian and monetdb_sql(). Or maybe I misunderstood you.
If you want to create databases with merovingian(1), you best make a connection to merovingian(1)'s control channel to tell it to create a database.
OK. So is it possible to create a database via a call to monetdb_sql(), and to access it via a command line tool such as mclient? If yes, how?
All the best,
-- Guillaume Yziquel http://yziquel.homelinux.org/
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi. Jason Kinzer a écrit :
I'm unclear why you're attempting external connections with an embedded server
To check if my binding is doing nonsense inside the embedded server. I would simply like an mclient interface to look inside interactively.
but it's for the vault issue at least it's trivial to avoid the dependency on an external file, e.g. in embeddedclient.c unlock the vault like this: char* secret = (char*)"somehardcodedstring"; if (AUTHunlockVault(&secret) != MAL_SUCCEED) return 0;
I'll keep that in mind. Thanks. -- Guillaume Yziquel http://yziquel.homelinux.org/
On 04-01-2010 22:23:20 +0100, Guillaume Yziquel wrote:
Merovingian(1) and monetdb(1) enable increased security features of mserver5. If you start mserver5 manually, you do not enable this.
In short, you mix the usage of merovingian(1) and mserver5, that's asking for problems.
I'm not mixing the use of merovingian and mserver5, but mixing the use of merovingian and monetdb_sql(). Or maybe I misunderstood you.
That is the same. "Embedded" in MonetDB terminology means nothing more than to start a full server in single threaded mode, hence without locks. You connect to it using a mapi connection, which is the same as e.g. mclient does. "Embedded" doesn't necessarily mean that you just access the data using a library. Calling monetdb_sql() is roughly the same as running `mserver5 --dbinit="include sql;"` on the console.
If you want to create databases with merovingian(1), you best make a connection to merovingian(1)'s control channel to tell it to create a database.
OK. So is it possible to create a database via a call to monetdb_sql(), and to access it via a command line tool such as mclient? If yes, how?
I'm not sure, but in principle as long as the thing remains running and you don't have any connections to it, you can just connect to it using e.g. mclient.
participants (3)
-
Fabian Groffen -
Guillaume Yziquel -
Jason Kinzer