# AWX Deployment does not connect to RDS Database

**URL:** <https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [April 28, 2021, 10:49pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079 "2021-04-28T22:49:37Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adrian\_Cortinas](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Adrian\_Cortinas](https://forum.ansible.com/u/Adrian_Cortinas)\
**Post date:** [April 28, 2021, 10:49pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/1 "2021-04-28T22:49:37Z")

</div>

Hi Team.

My Environment:  
Amazon EKS 1.19 w/Managed hosts

Amazon RDS Postgres 12.5R1  
AWX Operator 0.8.0

AWX deployment yml file:  
##File.yml##

> **(attachments)**
>
> [awx-42821-1.log](https://forum.ansible.com/uploads/short-url/1XVnJE1fXCed9JplmghuzbAqaNQ.log) (1.46 MB)

---

<div class="post-metadata">

**Author:** ![Adrian\_Cortinas](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Adrian\_Cortinas](https://forum.ansible.com/u/Adrian_Cortinas)\
**Post date:** [May 4, 2021, 2:56pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/2 "2021-05-04T14:56:12Z")

</div>

well… operator 0.9.0 made the trick, that version fixes connectivity to external (unmanaged) PostgreSQL databases.

---

<div class="post-metadata">

**Author:** ![Aaron\_Spiller](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@Aaron\_Spiller](https://forum.ansible.com/u/Aaron_Spiller)\
**Post date:** [May 6, 2021, 2:00pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/3 "2021-05-06T14:00:34Z")

</div>

I’m having similar issues, but have upgraded to 0.9.0 with no success:

Amazon RDS Postgres 12.5R1  
minikube 1.12.1 (but will be running on rancher in production)  
AWX Operator 0.9.0

After the awx deploy, I see the following in the logs:

django.db.utils.OperationalError: SSL error: certificate verify failed  
FATAL: no pg\_hba.conf entry for host “x.x.x.x”, user “user\_i\_created”, database “awx”, SSL off

where x.x.x.x is the IP of the host I am not and not the DB. I have used this RDS instance for my existing (16.0.0) implementation so the host/user/db/password are all correct.  
Not sure where else I can look or what I can set to get this working

---

<div class="post-metadata">

**Author:** ![Adrian\_Cortinas](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Adrian\_Cortinas](https://forum.ansible.com/u/Adrian_Cortinas)\
**Post date:** [May 6, 2021, 5:33pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/4 "2021-05-06T17:33:58Z")

</div>

I didn’t have that particular issue, in my case it wouldn’t even try to connect to the database. For the new operator version to work I made some changes to my yaml file, in bold below. Did you try those? I also made sure that the security group in RDS accepts connections from the k8s cluster network.

---

<div class="post-metadata">

**Author:** ![Aaron\_Spiller](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@Aaron\_Spiller](https://forum.ansible.com/u/Aaron_Spiller)\
**Post date:** [May 6, 2021, 6:57pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/5 "2021-05-06T18:57:02Z")

</div>

Yes, I have been using those options in bold and they don’t help.  
I can connect just fine via psql and awx-manage dbshell, that’s what is confusing me.

---

<div class="post-metadata">

**Author:** ![Juan\_C](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@Juan\_C](https://forum.ansible.com/u/Juan_C)\
**Post date:** [December 21, 2021, 2:54pm UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/6 "2021-12-21T14:54:08Z")

</div>

Did you create the database in RDS?

I had the same issue, then I found out the awx-\* containers were trying to connect to a database that didn’t exist in the RDS host.

---

<div class="post-metadata">

**Author:** ![Sai\_Krishna1](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@Sai\_Krishna1](https://forum.ansible.com/u/Sai_Krishna1)\
**Post date:** [February 16, 2023, 11:54am UTC](https://forum.ansible.com/t/awx-deployment-does-not-connect-to-rds-database/35079/7 "2023-02-16T11:54:52Z")

</div>

Hi folks,

I am trying to create AWX tower in EKS fargate and would like to use the external rds database connection.

And following the below GitHub documentation  
[https://github.com/ansible/awx-operator](https://github.com/ansible/awx-operator)

As was able to successfully run the awx-operator control manager.

But when I tried to deploy the AWX yaml file it creates a awx-postgres pod which will be in pending state with pod doesn’t support fargate and when I deep dive into it it’s looking for persistantvolume and persistent volume claim.

Questions here:  
When I am trying to say to use external db, why it’s again deploying db pod.

If it’s mandatory that even after mentioning to use external db, it needs the and db pod running.

Please help me out here i struggling to find the information
