How can I find credentials to directly connect to my Baserow Postgres Database

[bennyv53]

Hello, I just installed Cloudron on Digital Ocean and have installed the Baserow App. I am wondering how I can get a connection string to connect directly to the databse. In addition to Baserow, we plan to use a separate app builder that will be connected to the database.

Thanks for any guidance!

[bennyv53]

Update, so I found these instructions on how to connect directly to the databse, but am not having any luck. In addition to Baserow, we plan to use a separate app builder that will be connected to the database, so need to be able to access it.

This is the setup I've done, but figure I'm doing something wrong. The guide only had an image of a connectiojn to DBeaver for the SSH connection so just tried copying that.

Thanks for any guidance!

[matix131997]

@bennyv53
Change host "postgresql" to "172.18.30.2"

[bennyv53]

@matix131997 unfortunately I'm getting the same error message.

Any other ideas? Thanks so much!

[joseph]

@bennyv53 which tool are you using? Per the error message, there is an issue with the SSH connection. Maybe the key is wrong? Are you using password based SSH or key based SSH ?

[bennyv53]

@joseph I am using Glide. To be honest, I'm not sure. I tried following the documentation here: https://docs.cloudron.io/guides/connect-postgresql/, but the SSH instructions only show a screenshot of setup in DBeaver, and I am probably missing some steps.

When you say the key, where would I be getting the key from, and where would I be entering it?

I used the postgres credentials for the database, database user and password.

Thank you!!

[joseph]

@bennyv53 said in How can I find credentials to directly connect to my Baserow Postgres Database:

When you say the key, where would I be getting the key from, and where would I be entering it?

This is the SSH key to login to the server.

[bennyv53]

@joseph Got it, and how do I access that key? Sorry, this is new for me so trying to learn!

[joseph]

@bennyv53 the SSH key is the key to login to your server. How do you ssh into your server? There are two common modes to auth with ssh - with a password or via key . For example, ssh root@my.tee.digital . Do you enter a password here ? Or does it automatically log you in without a password (most likely ssh key based if that's the case).