Connecting to AWS hosted PostgreSQL with Metabase Docker

I have latest version of Metabase in use and postgresQL as metabase db. the Dockerfile for the app is

FROM metabase/metabase:v0.46.7
COPY config.yml /app/config.yml
ENV MB_DB_TYPE=postgres
ENV MB_DB_DBNAME=XXXX
ENV MB_DB_PORT=5432
ENV MB_DB_USER=XXXXXX
ENV MB_DB_PASS=XXXXXXX
ENV MB_DB_HOST=abc.xyz.rds.amazonaws.com
ENV MB_CONFIG_FILE_PATH /app/config.yml

CONFIG FILE
version: 1
config:
settings:
config-from-file-sync-databases: true
users:
- first_name: Prashanta
last_name: Paudel
password: xxxxx
email: abc@xyz.com
is_superuser: true
databases:
- name: metabase (Postgres)
engine: postgres
details:
host: abc.eu-west-1.rds.amazonaws.com
port: 5432
password: "XXXXXX"
dbname: XXXX

  1. metabase loads ok but neither i can see config.tml users in core_user table( its empty)
  2. Cannot login with users in config.yml

TROUBLESHOOT
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.20+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.20",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.20+8",
"os.name": "Linux",
"os.version": "5.4.228-132.418.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.11"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.1"
}
},
"run-mode": "prod",
"version": {
"date": "2023-08-06",
"tag": "v0.46.7",
"branch": "release-x.46.x",
"hash": "cfdf23b"
},
"settings": {
"report-timezone": null
}
}
}


Send the logs when Metabase initializes