Cloudron Forum

@girish thanks for the guidance, that's exactly what I was looking for

@girish Indeed it's in the context of Baserow, but my use case is general. I was trying to connect to the app's database with a program like DataGrip.

I was trying to connect to the database of an application installed in Cloudron and visualize the database with a program like DataGrip.

I hadn't realised that the db credentials of each app can be accessed in the environment of the app with PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE}

The problem I faced ended up being that once DataGrip was connected to the Cloudron server with an SSH tunnel, it was expecting to be able to connect to the database in a local port. However, the postgresql container run by Cloudron doesn't expose the 5432 port, so there was no way to connect to it through a simple ssh tunnel. I ended up using a bit of a hack solution to expose the database port 5432 by running a docker container that does only that.

docker run -d --rm --network=cloudron --name sql_redirect --link postgresql:postgresql -p 5432:1234 alpine/socat TCP-LISTEN:1234,reuseaddr,fork TCP:postgresql:5432

@bram Baserow looks really promising! I just took it for a spin using Cloudron. I am would like to connect to the postgres database, but I really can't seem to find it. When I connect to the app by the terminal, there is no Postgres process running. Similarly, in the supervisor file I see no mention of postgres. Yet in all evidence, baserow is running smoothly so surely the database is running somewhere, I just can't seem to find where. Some help would be greatly appreciated.

Hello,

I created a Cloudron Droplet in Digital Ocean. Now I am trying to access the Postgresql database of Cloudron, but I don't know which are the default settings.

In the documentation, it is implied that we need to know the username, password, host and database, however all these where created by default during the installation of Cloudron, and the marketplace page doesn't have any info about those variables.

I would be gratefull if you could point me out how I can find the necessary info to access Cloudron's database.