AWX fails to connect to my external postgres server

Archives AWX Project
1

Hello there,

If anyone can help

here some logs after issuing ansible-playbook -i inventory install.yml

[root@PA-PGL-VMNO-0 installer]# docker logs -f awx_task
Using /etc/ansible/ansible.cfg as config file
127.0.0.1 | SUCCESS => {
“changed”: false,
“elapsed”: 0,
“path”: null,
“port”: 5432,
“search_regex”: null,
“state”: “started”
}
Using /etc/ansible/ansible.cfg as config file
127.0.0.1 | SUCCESS => {
“changed”: false,
“elapsed”: 0,
“path”: null,
“port”: 11211,
“search_regex”: null,
“state”: “started”
}
Using /etc/ansible/ansible.cfg as config file
127.0.0.1 | SUCCESS => {
“changed”: false,
“elapsed”: 0,
“path”: null,
“port”: 5672,
“search_regex”: null,
“state”: “started”
}
Using /etc/ansible/ansible.cfg as config file
[DEPRECATION WARNING]: The sudo command line option has been deprecated in
favor of the “become” command line arguments. This feature will be removed in
version 2.6. Deprecation warnings can be disabled by setting
deprecation_warnings=False in ansible.cfg.
An exception occurred during task execution. To see the full traceback, use -vvv. The error was: OperationalError: FATAL: no pg_hba.conf entry for host “10.100.10.139”, user “awx”, database “postgres”, SSL off
127.0.0.1 | FAILED! => {
“changed”: false,
“msg”: “unable to connect to database: FATAL: no pg_hba.conf entry for host "10.100.10.139", user "awx", database "postgres", SSL off\n”
}
^C

In my inventory file:

pg_hostname=10.100.10.180
pg_username=awx
pg_password=awxpass
pg_database=awx
pg_port=5432

As a reminder, in my awx server (redhat VM), the docker containers awx_web, awx_task, rabbitmq and memcached ran as well, but it can’t connect to my external postgresql server (another redhat VM) which I installed without launched any docker.

I pointed the address of my awx server in pg_hba.conf file in postgres machine (/pgqdata/pgserver01/data/pg_hba.conf),

Below the pg_hba.conf in postgrsql server :

local all postgres trust
hostnossl all all 0.0.0.0/0 trust

IPv4 local connections:

host all all 0.0.0.0/0 md5
host awx postgres 10.100.10.139/32 md5

Thanks in advance,

2

Check the logs on the postgres side, make sure there isn’t a firewall blocking the connection. This issue doesn’t appear to be strictly related to AWX itself so it just comes down to figuring out postgres.

3

Yes, it was a postgres issue.

I upgraded the postgres (9.4 to 9.6) and now everything works as well.

Thanks