[Maas-devel] juju's private-address, DNS, MAAS and postgresql

[Andreas Hasenack]

On Fri, Nov 8, 2013 at 9:57 AM, Andreas Hasenack <andreas at canonical.com>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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/maas-devel/attachments/20131108/0663b35b/attachment.html>