AWX install issue with external postgres

Archives AWX Project
,
1
ISSUE TYPE

Web UI not working after trying to access the hostname url.

SUMMARY

So , I have installed AWX and it is connected to an external DB which also on a RHEL 8 VM.
After installing the awx , I am trying to connect to the UI but it showing as the awx box refused to connect.

I am able to telnet from my host vm to the database server but somehow awx install is not able to talk to DB

Please Help

ENVIRONMENT- AWX version: latest
  • AWX install method: docker on linux
  • Ansible version: 2.9.3
  • Operating System: RHEL 8.1
  • Web Browser: google chrome
2

Seeing similar errors as in https://groups.google.com/forum/#!topic/awx-project/s87bZ64HLIQ

Admittedly, there are differences in the installation (e.g. CentOS 8 vs RHEL 8, External Postgres vs PG Container), however, the thread discusses the fact that there are communication issues between awx_task and Postgres.

Take a look at the firewall settings for the AWX Docker network (awxcompose_default) by default.

Hope that helps.

3

I did the changes, I will post my findings on the below thread

4

Hi Bharat,

We are also getting the same error. May I know how did you fix it?

Regards,
Ajit

5

I remember using an external PG DB on a different RHEL server. I also remember allowing incoming connection in the Db config files when i was able to see connection errors to db.

Try validating if the following files are configured to accept incoming connections:

/var/lib/pgsql/12/data/postgresql.conf

listen_addresses = '*'

/var/lib/pgsql/12/data/pg_hba.conf

host all all 0.0.0.0/0 md5

If no, make the changes and restart db service.

systemctl restart postgresql-12

Here, my pg version is 12.x