While trying to install nodebb on Heroku i am having problems to connect to postgres databases provided by Heroku add-ons - "Standard 0" and up. Connecting to lower performance Heroku postgres add-ons, like "Hobby dev" and "Hobby basic", works.
I found the recommendation to add a ssl param to the connection string when connecting to postgres via node.js apps but did not found the right place in the nodebb code to add an additional param (https://devcenter.heroku.com/articles/connecting-to-heroku-postgres-databases-from-outside-of-heroku).
Can anyone give me a hint?
@jimmyc2018 maybe your server restarted without you knowing and mongo and nodebb didn't automatically start back up?
Have you tried starting the mongod service and then starting nodebb?
Btw, you shouldn't run NodeBB with root or sudo. That may also be causing the problem.
SOLVED
In case anyone else has this problem, here's where I found what I needed.
File: /nodebb/src/controllers/helpers.js
Methods: buildCategoryBreadcrumbs and buildBreadcrumbs
Editing those allowed me to get the behavior I was looking for. Although, I would be curious to know if there is a better way to do this without changing the source code.
