Tunneling with database URLs [Feb 22]

Discord-Discussions
1

:raising_hand_man: Amin Debabeche asked

Hi out there,

I am searching for documentation on database URLs. Indeed I have set-up my Postgres on my own VM but I do not know how to include the tunneling with password in the URL.

2

:person_tipping_hand: o1lab replied

We use knexjs to connect to databases.

See if you can figure the connection params from knexjs. On working, we can make it work for nocodb too

3

:person_tipping_hand: o1lab replied

SQL Query Builder for Javascript | Knex.js

4

:raising_hand_man: Amin Debabeche replied

Do you have an example of JSON file you are using, I find it a bit confusing as the knexjs are usually .js file

5

:person_tipping_hand: o1lab replied

you can specify NC_DB_JSON_FILE in env variable instead of NC_DB

6

:person_tipping_hand: o1lab replied

https://docs.nocodb.com/getting-started/installation#environment-variables

7

:raising_hand_man: Amin Debabeche replied

If not using ssh tunneling, what tech would you be using to connect to a postgres server ?

8

:raising_hand_man: Amin Debabeche replied

Yeah that is the matter with the environnement variable, it’s written to use a JSON file but I see only javascript file out there when used with knexjs

9

:person_tipping_hand: o1lab replied

knexjs takes an object, so the JSON file contents will be translated into an object

10

:person_tipping_hand: o1lab replied

hope it makes sense

11

:raising_hand_man: Amin Debabeche replied

okok

12

:raising_hand_man: Amin Debabeche replied

because it does not seem the simpliest way

13

:person_tipping_hand: o1lab replied

sorry, i didnt get what you mean by tunneling

14

:person_tipping_hand: o1lab replied

like connecting via ssh keys ?

15

:raising_hand_man: Amin Debabeche replied

I do not think that ssh keys are accessible on my side, it seems like we prefer to have it disabled as a security reason.

16

:raising_hand_man: Amin Debabeche replied

because I am hosting my own postgres server but I have some difficulties accessing as not all service (such as NocoDB) offer the possibility to connect via ssh

17

:person_tipping_hand: o1lab replied

SSL metadata DB · nocodb/nocodb · Discussion #838 · GitHub

18

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs