Re: [Gnumed-devel] settings for gm-dbo

[Karsten Hilbert]

On Fri, Jul 09, 2010 at 01:47:26PM +0200, Hilbert, Sebastian wrote:

> It turns out that gm-bootstrap_server does not ask for the gm-dbo password.

That can't be true just like this. See
bootstrap_gm_db_system.py::__create_db_owner().

> It 
> seems to set a password (maybe blank one)

Only if the .conf files contain a password (even a blank
one).

> So the user is left in the dark about it.

True enough but this is an issue in the respective package.

> Could someone supply the psql commands to alter the password ?

        ALTER ROLE "gm-dbo" ENCRYPTED PASSWORD 'a secret string';

> Maybe a script 
> could be written that will ask for the root password (sudo su), switch to 
> postgres and after requesting a password for gm-dbo on the cmd line set this 
> password.

server/gm-set_gm-dbo_password <NEW_PASSWORD>

Must be run as root.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346