Fabian Groffen wrote:
On 07-04-2010 16:37:45 +0100, Dave Howorth wrote:
Thanks for that. I'd rather not set up the control port until I'm more confident of the admin and/or until I really need to access it from another machine. I didn't try to run as the monetdb user since that seems to be set up to prevent login. I guess I can set up another user who can sudo or somesuch. Is the security/adminstrator setup philosophy described somewhere?
I'm affraid not. We assume a user (non-root) that is the administrator of the entire database farm to create necessary databases and initialise them properly, much like most PostgreSQL installations are done by vendors, IIRC.
It sounds like you used some packages to install MonetDB, perhaps they need to be changed a bit to allow the monetdb user to actually perform the administrative commands.
Well I used the packages from your site :) http://monetdb.cwi.nl/downloads/Ubuntu/ I used synaptic rather than using apt-get directly but I don't think that makes any difference. As well as being new to MonetDB I'm also fairly new to ubuntu and sudo (I regularly use opensuse, which allows root login, but the last time I used sudo was when SysV was current) so it may be the packages are designed to suit a particular admin style but I don't know enough to recognize it. I haven't used PostgreSQL either, I'm afraid, only MySQL. I'll experiment a bit. Thanks, Dave