Error when trying to connect a Postgresql database : could not open certificate file "/root/.postgresql/postgresql.crt": Permission denied

[Valexico]

This error occurs with default engine (psycopg2)

(psycopg2.OperationalError) connection to server at "**********" (151.80.10.***), port 5432 failed: could not open certificate file "/root/.postgresql/postgresql.crt": Permission denied

(Background on this error at: https://sqlalche.me/e/14/e3q8)

I think it is a cloudron app issue

You can workaround using sqlalchemy.

[joseph]

@Valexico we need more context here. What are you trying to do and what is this error you have posted?

[Valexico]

@joseph Sorry it was a bit rough but in short

• Install Superset
• Connect to a PostgreSQL database with SSL :

Workaround :
Use SQLalchemy URI

I think the issue is that there is no /root/.postgresql/postgresql.crt inside the container app

[plusone-nick]

pretty sure it has to be via ssh if your app is outside of cloudron
*nvm i now see you're going out from cloudron

[girish]

There is in issue in the library somewhere. See https://github.com/psycopg/psycopg2/issues/1535 and https://gitlab.alpinelinux.org/alpine/aports/-/issues/14565 . I put a workaround to make it work. Should have a new package soon.

[girish]

@Valexico Fixed in latest package. Atleast, I can connect to DO postgres db with the change

[Valexico]

@girish I confirm after update id works