Error connecting to custom database

Help
, ,
1

I am trying to connect a custom postgresql database which is hosted on heroku to Auth0 for authentication. Upon editing the postgresql ‘Create’ action script with the required URI of the heroku database and trying to save and test the functionality I am receiving the error - “[Error] ECONNREFUSED - connect ECONNREFUSED 127.0.0.1:5432”.

This issue appears to be similar to Custom Database Issue however I do not understand how to implement the solution which was 'changed the IP addresses.
I have a multitude of different things to get it to work including doing away with the URI and specifying the user, host, password and database inside the object when trying to create the variable that .connect() will be used on.

3

Hi @william.brace20,

Welcome to the Auth0 Community!

Are you using a 127.0.0.1 IP when trying to connect to the DB from Auth0? That is a loopback IP. It is used by a machine to connect to itself.

You should be using a publicly available IP/URL, something like ec***.compute-1.amazonaws.com or 172.217.22.14

This resource might be helpful:

4

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.