Mark Bucciarelli wrote:
Note that there is a difference between admin actions (such as start, stop, status) and database actions (like select from).
For the former, I create the user mero and run merovingian as that user. I put the dbfarm files under that user's home directory.
Well the http://monetdb.cwi.nl/downloads/Ubuntu/ packages set up a monetdb user so I set up merovingian to run as that user, by adding this command in /etc/rc.local: sudo -u monetdb merovingian
This has the advantage of giving your control resource limits via that users login profile, and
The packages set up the monetdb user with a 'nologin' profile, which I think means that the only way to run as that user is via sudo. So I think I must need to create a user who can login and who is allowed to sudo -u monetdb. Just like I have a system admin account that can sudo -u root. But the packages didn't set up such a user, so I was wondering if I'd missed some other, better way of administering MonetDB.
other unixy things like the user's crontab to do backups, etc. It also means merovingian is not running as root.
For the latter, it's SQL access permissions, schema's and such, and you can login with mclient from any unix user; the sql user/pass is orthogonal.
That's good to know :) Thanks, Dave