Why am I getting the error "SSL error: certificate verify failed" when I install the Ansible automation controller or private Automation Hub using Amazon RDS as an external database with TLS enabled?

Solution Verified - Updated -

Issue

  • Why am I getting the error "SSL error: certificate verify failed" when I install the Ansible automation controller or private Automation Hub using Amazon RDS as an external database with TLS enabled?

    TASK [pulp.pulp_installer.pulp_database_config : Run database migrations] ******
    fatal: [10.0.0.xxx]: FAILED! => {"changed": true, "cmd": ["/usr/bin/pulpcore-manager", "migrate", "--no-input"], "delta": "0:00:02.830710", "end": "2022-11-30 01:58:00.087830", "msg": "non-zero return code", "rc": 1, "start": "2022-11-30 01:57:57.257120", "stderr": "Traceback (most recent call last):\n  File \"/usr/lib/python3.9/site-packages/django/db/backends/base/base.py\", line 219, in ensure_connection\n    self.connect()\n  File \"/usr/lib/python3.9/site-packages/django/utils/asyncio.py\", line 33, in inner\n    return func(*args, **kwargs)\n  File 
    ...
    \"/usr/lib/python3.9/site-packages/django/db/backends/postgresql/base.py\", line 187, in get_new_connection", "    connection = Database.connect(**conn_params)", "  File \"/usr/lib64/python3.9/site-packages/psycopg2/__init__.py\", line 122, in connect", "    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)", "django.db.utils.OperationalError: SSL error: certificate verify failed"], "stdout": "", "stdout_lines": []}
    

Environment

  • Red Hat Ansible Tower >= 3.8
  • Red Hat Ansible Automation Platform >= 1.2, >= 2.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content