Comment 16 for bug 1281758

I ran into this issue (FATAL: password authentication failed for user "maas") by running the command 'maas-region createadmin --username admin --password kNab4Q9fSa --email <email address hidden>' today as well. I solved the problem in the following way.

1, confirm database_pass is wQ3fxcdSH1aI

root@maas-ha-2:~# grep -r 'pass' /etc/maas/regiond.conf
database_pass: wQ3fxcdSH1aI

2, change md5 into trust temporarily, then restart postgresql by 'systemctl restart pacemaker'
/etc/postgresql/9.5/main/pg_hba.conf
local all all trust

3, change the password of the user maas to wQ3fxcdSH1aI

sudo su - maas
psql -d maasdb -U maas
maasdb=> alter user maas with password 'wQ3fxcdSH1aI';

4, ok