On 08-05-2009 09:16:43 +0100, Tom H wrote:

I need to reset some passwords on a monetDB5 installation, and I am not clear on how to do it. Currently I can't login at all.

Is there a way to enter single-user mode, or something so I can reset the monetDB user password?

Also, I really don't understand the difference between running monet as mserver5 and Merovingian. Basically I want to run the server from an init.d script, which should I use?

Merovingian is an intelligent wrapper around multiple mserver5 processes. It can start an mserver5 instance on the fly, and is better suited for init.d script than the plain mserver5 itself.

At the moment I am running the server like so; [root@localhost ~]# mserver5 --dbinit="include sql;" # MonetDB server v5.10.4, based on kernel v1.28.4 # Serving database 'demo', using 2 threads # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 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 /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.28.4 loaded

...

Can I reset the password using MAL commands from the prompt?

Yes.

clients.setPassword("user", "password");

For the monetdb superuser, you will have to use

clients.changePassword("old", "new");