Strongloop Heroku Postgres setup SSL error

Question

I am new to the world of Node.js, and have setup an app running on Heroku(free) using StrongLoop. I setup the heroku postgresql addon (free tier), and tried to add the datasource to StrongLoop's arc composer UI. This UI updates the server/datasources.json. When I try connecting to my datasource I get this error:

no pg_hba.conf entry for host "X.X.X.X", user "myUser", database "mydb", SSL off

I understand that the problem must be with setting up SSL on postgres. The closest StrongLoop documentation doesn't quite discuss this: https://strongloop.com/strongblog/postgresql-node-js-apis-loopback-connector/ ... Because I'm using StrongLoop rather than just straight Node.js, Heroku's documentation also left me lacking https://devcenter.heroku.com/articles/heroku-postgresql#connecting-in-node-js. I'm confused as to what I need to do exactly from here.

I have fairly simplistic newsfeed type JSON data that I manipulate with handlebars. So if it's an issue with being on the free tier, I'm open to other free suggestions with my setup. I appreciate your help.

Edit, datasources.json:

{"db":{"name":"db","connector":"memory"},
"mydb":{
"host":"myhost",
"port":####,
"url":"myamazonawsurl:####/mydbname",
"database":"mydbname",
"password":"mypw",
"name":"mydatasourcename",
"ssl":true,
"user":"myuser",
"connector":"postgresql"}}

More error details:

error: no pg_hba.conf entry for host "X.X.X.X", user "myuser", database "mydb", SSL off at 
Connection.parseE (c:\myroot\node_modules\loopback-connector-postgresql\node_modules\pg\lib\connection.js:539:11) at 
Connection.parseMessage (c:\myroot\node_modules\loopback-connector-postgresql\node_modules\pg\lib\connection.js:366:17) at 
Socket.<anonymous> (c:\myroot\node_modules\loopback-connector-postgresql\node_modules\pg\lib\connection.js:105:22) at 
Socket.emit (events.js:107:17) at readableAddChunk (_stream_readable.js:163:16) at 
Socket.Readable.push (_stream_readable.js:126:10)

Madi Anas · Accepted Answer · 2016-06-05 17:52:17Z

5

It should be "?ssl=true" not "?sslmode=require"

"devpostgresql": {
    "url": "postgres://user:[email protected]:5432/dbname?ssl=true",
    "name": "devpostgresql",
    "connector": "postgresql"
  }

answered Jun 5, 2016 at 17:52

Madi Anas

662 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

elithrar · Accepted Answer · 2015-07-15 11:02:49Z

3

Based on the article you've linked, you'll need to modify your datasources.json configuration to suit your Heroku environment.

Get your details from heroku pg:credentials DATABASE_URL which will spit out the below (without the place-holders I've used, of course!):

postgres://user:[email protected]:5432/your-db-name

Paste that into datasources.json:

  "accountDB": {
     "connector": "postgresql",
     "url": "postgres://user:[email protected]:5432/your-db-name?sslmode=require"
  }

The PostgreSQL docs for Loopback provide some further details - http://docs.strongloop.com/display/public/LB/PostgreSQL+connector - but the above should get you started.

edited Jul 15, 2015 at 11:02

answered Jul 15, 2015 at 6:10

elithrar

24.4k11 gold badges91 silver badges107 bronze badges

7 Comments

woodlumhoodlum Over a year ago

I tried that with no luck: {"db":{"name":"db","connector":"memory"},"mydb":{"host":"myhost","port":####,"url":"myamazonawsurl:####/mydbname","database":"mydbname","password":"mypw","name":"mydatasourcename","ssl":true,"user":"myuser","connector":"postgresql"}}

elithrar Over a year ago

Can you update your question with what you put in datasources.json? Comments don't format JSON well. If you can also post the error you get it'll help. Based on what you pasted I don't think you've entered it correctly.

woodlumhoodlum Over a year ago

yeah, sorry about that. Added them. StrongLoop's UI automatically places the connection strings in their fields in the datasources.json. I manually added the "ssl": true to the file.

Raymond Feng Over a year ago

Please note that url property shadows other configuration attributes. You should make them part of the url as query params, for example: "url": "postgres://user:[email protected]:5432/your-db-name?ssl=true",

woodlumhoodlum Over a year ago

right @RaymondFeng I agree it's much cleaner, but beyond adding the ssl key there is still something on heroku side that must need configuring.

|

Lieblingsfarbe · Accepted Answer · 2016-02-14 04:32:33Z

2

Require SSL for Postgres connections by setting the following environment variable in command line:

$ export PGSSLMODE=require

answered Feb 14, 2016 at 4:32

Lieblingsfarbe

212 bronze badges

Comments

gameboyll · Accepted Answer · 2018-08-16 17:05:17Z

1

I ran into similar problem myself and I found this solution to fix it for me. Similar to @Lieblingsfarbe's answer, but this is in Heroku CLI.

Go into Heroku CLI -> your app directory -> issue this command:

heroku config:set PGSSLMODE=require

Reference: Found it here after a few hours of trying and researching (https://stackoverflow.com/a/27732431/7430591)

answered Aug 16, 2018 at 17:05

gameboyll

1391 silver badge7 bronze badges

1 Comment

ohjeeez Over a year ago

This worked!! Thank you so much!! Heroku, if you are on here, please put this in the docs for upgrading DB plans...

sɐunıɔןɐqɐp · Accepted Answer · 2018-10-01 08:20:54Z

0

I tried doing all above options, but in my case I was using wrong driver for postgresql.

After checking my postgresql version, which is 10.4, I had to use the gradle configuration below:

compile group: 'org.postgresql', name: 'postgresql', version: '42.2.5'

edited Oct 1, 2018 at 8:20

sɐunıɔןɐqɐp

3,59516 gold badges41 silver badges43 bronze badges

answered Oct 1, 2018 at 7:13

nimesh makwana

1411 silver badge4 bronze badges

Collectives™ on Stack Overflow

Strongloop Heroku Postgres setup SSL error

5 Answers 5

Comments

7 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

7 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related