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?
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.