ansible / eda-server

Event Driven Ansible for AAP
Apache License 2.0
64 stars 41 forks source link

enable ssl postgres #907

Closed msmagnanijr closed 3 months ago

msmagnanijr commented 3 months ago

How to Test it?

Open your terminal and start the EDA environment with the specific Docker Compose file:

docker-compose -f docker-compose-dev-redis-tls.yaml up -d

After ensuring that the EDA is up, open a shell session in the PostgreSQL container:

docker exec -u 0 -it eda-postgres-1 sh Inside the container, connect to the PostgreSQL database using psql:

psql -U postgres -d eda

Once connected to the database, execute the following SQL query to verify the SSL status:

show SSL;

ssl 
-----
 on
(1 row)

SELECT * FROM pg_stat_ssl;

The output of the query will provide details on SSL connections. Look for the ssl column to see if it is t (true), there is a connection using SSL along with other SSL-related information such as ssl_cipher, ssl_client_dn, etc.

In this case, it will show f (false) since we do not yet have SSL e2e working in EDA.