Problem: AWS RDS Postgres connection not working

[ssutharAFS]

Issue

services:
semaphore:
container_name: semaphore
image: semaphoreui/semaphore:latest
ports:
- 3000:3000
environment:
SEMAPHORE_DB_DIALECT: postgres
SEMAPHORE_DB_HOST: semaphore.abc.us-east-3.rds.amazonaws.com
SEMAPHORE_DB_NAME: semaphore
SEMAPHORE_DB_USER: semaphore
SEMAPHORE_DB_PASS: abcd
SEMAPHORE_ADMIN: admin
SEMAPHORE_ADMIN_PASSWORD: abcd
SEMAPHORE_ADMIN_NAME:
SEMAPHORE_ADMIN_EMAIL: [email protected]
SEMAPHORE_EMAIL_ALERT: False
SEMAPHORE_SLACK_ALERT: True
SEMAPHORE_SLACK_URL:
ANSIBLE_HOST_KEY_CHECKING: False
volumes:
- /data/semaphore/semaphore_data:/var/lib/semaphore:rw
- /data/semaphore/semaphore_config:/etc/semaphore:rw
- /data/semaphore/semaphore_tmp:/tmp/semaphore:rw
networks:
- net
restart: on-failure
networks:
net:

and getting the following errors

Hello! You will now be guided through a setup to:

1. Set up configuration for a MySQL/MariaDB database
2. Set up a path for your playbooks (auto-created)
3. Run database Migrations
4. Set up initial semaphore user & password

What database to use:
1 - MySQL
2 - BoltDB
3 - PostgreSQL
(default 1):
db Hostname (default 127.0.0.1:5432):
db User (default root):
db Password:
db Name (default semaphore):
Playbook path (default /tmp/semaphore):
Public URL (optional, example: https://example.com/semaphore):
Enable email alerts? (yes/no) (default no):
Enable telegram alerts? (yes/no) (default no):
Enable slack alerts? (yes/no) (default no):
Enable Rocket.Chat alerts? (yes/no) (default no):
Enable Microsoft Team Channel alerts? (yes/no) (default no):
Enable LDAP authentication? (yes/no) (default no):
Config output directory (default /home/semaphore):
Running: mkdir -p /etc/semaphore..
panic: open /etc/semaphore/config.json: permission denied

Impact

Configuration, Database, Docker

Installation method

Docker

Database

Postgres

Browser

Chrome

Semaphore Version

latest

Ansible Version

No response

Logs & errors

Hello! You will now be guided through a setup to:

1. Set up configuration for a MySQL/MariaDB database
2. Set up a path for your playbooks (auto-created)
3. Run database Migrations
4. Set up initial semaphore user & password

What database to use:
1 - MySQL
2 - BoltDB
3 - PostgreSQL
(default 1):
db Hostname (default 127.0.0.1:5432):
db User (default root):
db Password:
db Name (default semaphore):
Playbook path (default /tmp/semaphore):
Public URL (optional, example: https://example.com/semaphore):
Enable email alerts? (yes/no) (default no):
Enable telegram alerts? (yes/no) (default no):
Enable slack alerts? (yes/no) (default no):
Enable Rocket.Chat alerts? (yes/no) (default no):
Enable Microsoft Team Channel alerts? (yes/no) (default no):
Enable LDAP authentication? (yes/no) (default no):
Config output directory (default /home/semaphore):
Running: mkdir -p /etc/semaphore..
panic: open /etc/semaphore/config.json: permission denied

Manual installation - system information

No response

Configuration

No response

Additional information

No response