maas-devel team mailing list archive

[Andreas Hasenack <andreas@xxxxxxxxxxxxx>]

On Fri, Nov 8, 2013 at 9:57 AM, Andreas Hasenack <andreas@xxxxxxxxxxxxx>wrote:

> This is the issue:
> 2013-11-07 13:47:02 UTC FATAL:  no pg_hba.conf entry for host
> "10.0.5.100", user "landscape", database "landscape-standalone-main", SSL
> off
> 2013-11-07 13:47:02 UTC DETAIL:  Client IP address resolved to
> "10-0-5-100.maaslocal", forward lookup not checked.
>
>
To reproduce, deploy the following services with juju using the maas
provider:
juju deploy postgresql
juju deploy postgresql-psql psql
juju add-relation postgresql:db psql:db

Now try it:
juju ssh psql/0
ubuntu@k8q9m:~$ psql-db-postgresql-0 -l
psql: FATAL:  no pg_hba.conf entry for host "10.0.5.103", user "db_1_psql",
database "postgres", SSL on
FATAL:  no pg_hba.conf entry for host "10.0.5.103", user "db_1_psql",
database "postgres", SSL off
ubuntu@k8q9m:~$

The postgresql/0 server will log:
2013-11-08 12:54:14 UTC FATAL:  no pg_hba.conf entry for host "10.0.5.103",
user "db_1_psql", database "postgres", SSL on
2013-11-08 12:54:14 UTC DETAIL:  Client IP address resolved to
"10-0-5-103.maaslocal", forward lookup not checked.

Its pg_hba.conf will contain:
# db:1 from psql/0
host psql db_1_psql k8q9m.maaslocal md5

host psql db_1_psql_schema k8q9m.maaslocal md5
# replication:0 from postgresql/0
host postgres juju_replication kmkxr.maaslocal md5