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

[Sebastian Hilbert]

Am Freitag 09 Juli 2010, 17:19:25 schrieb 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>

Great thanks. 

Sebastian