awx and postgresql external database error

Archives AWX Project
1

Hi all,

I have started to install AWX on Openshift with external database, and the installation failed with error:

this a part of the ansible install log:
…

File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py", line 189, in connect", " self.connection = self.get_new_connection(conn_params)“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/postgresql/base.py", line 176, in get_new_connection”, " connection = Database.connect(**conn_params)“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/psycopg2/init.py", line 130, in connect”, " conn = _connect(dsn, connection_factory=connection_factory, **kwasync)", “django.db.utils.OperationalError: SCRAM authentication requires libpq version 10 or above”, “”, “command terminated with exit code 1”], “stdout”: “”, “stdout_lines”: }
…

we have Postgresql 10 with Openshift 3.10.

Any idea?

thank you!

2

The problem was the password encrypted in SCRAM instead of md5.

Recrypt the password to md5 and all is perfect.