On Wed, Apr 7, 2010 at 11:37 AM, Dave Howorth
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 also do not use control port either. 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. This has the advantage of giving your control resource limits via that users login profile, and 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. HTH, m