Error when trying to connect a Postgresql database : could not open certificate file "/root/.postgresql/postgresql.crt": Permission denied
Solved
Superset
-
wrote on Dec 18, 2024, 2:44 PM last edited by Valexico Dec 18, 2024, 2:45 PM
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.
-
wrote on Dec 18, 2024, 5:08 PM last edited by Valexico Dec 18, 2024, 5:09 PM
@joseph Sorry it was a bit rough but in short
- Install Superset
- Connect to a PostgreSQL database with SSL :
Workaround :
Use SQLalchemy URII think the issue is that there is no
/root/.postgresql/postgresql.crt
inside the container app -
wrote on Dec 18, 2024, 7:05 PM last edited by plusone-nick Dec 18, 2024, 7:10 PM
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 -
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.
-
-