Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04

[Karsten Hilbert]

> Seems the gm-bootstrap_server did NOT ask me for a password ...

Not sure off the top of my head, but bootstrapping might set
the password (if told so in a config file).

> got this after bootstrap of a new gnumed_v19 in a NEW main cluster(after 
>pg_dumpcluster / pg_createcluster)
>
>                                List of databases
>    Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access 
>privileges  
>------------+----------+----------+-------------+-------------+-----------------------
> gnumed_v18 | gm-dbo   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
> gnumed_v19 | gm-dbo   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
> postgres   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
> template0  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres    
>      +
>            |          |          |             |             | 
>postgres=CTc/postgres
> template1  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres    
>       +
>            |          |          |             |             | 
> postgres=CTc/postgres
> (5 rows)

Looks spot on. First things would be to

- re-check pg_hba.conf for the proper position of the "samerole gm-logins md5" 
line
- dropdb gnumed_v19 (because we want to restore)
- check out whether any password is set for gm-dbo:
   psql -d gnumed_v18 -U gm-dbo
- if an unknown password is set, reset it to something known
   connect as user postgres
   alter role 'gm-dbo' encrypted password 'your-new-password';
- try connecting as gm-dbo
- try connecting as any-doc (default password should be any-doc)

and check back here.

Karsten