philip
July 11, 2021, 9:02pm
1
Hi there,
[Newbie question] I’m new to Forest Admin - it looks like a great tool!
I’m currently at the last configuration step: Set your environment variables.
I added all of the requested env variables through the Heroku interface - double checked twice if everything was correct.
Currently my url https://spokebase.herokuapp.com/ returns " Your application is running!" which is great… but I’m still faced with the following error from forest:
Waiting for your environment variables to be correctly set. If this error persists, please check your server logs.
What am I doing wrong? Any idea what I should do?
Hi @philip ,
Thanks you for your interest in Forest.
What is your project name?
Regards
philip
July 12, 2021, 9:04am
4
I created a new project from scratch and deleted the old one. I’m now capable of completing the configuration, but i have a new porblem:
2021-07-12T08:53:54.945728+00:00 app[web.1]: [forest]
Any idea how to solve it?
Ok,
Can you please share the entire log, and also provide all the possible details about your stack, etc.
Regards
philip
July 12, 2021, 9:07am
6
2021-07-12T08:53:54.941858+00:00 app[web.1]: [forest]
I’m using Heroku / Postgres. I configured the tables through Hasura
It’s an issue in database connection configuration.
Regards
philip
July 12, 2021, 9:24am
8
I can connect fine with SQLPro for Postgres with the same credentials
philip
July 12, 2021, 9:52am
9
Hi @Sliman_Medini ,
First of all: thank you for helping me
I found an previous post about a similar issue: Struggling to set up Forest with my Heroku-deployed Postgres DB
Do you think it’s related? I checked in config > databases.js and the code seems to already be correct:
if (process.env.DATABASE_SSL && JSON.parse(process.env.DATABASE_SSL.toLowerCase())) {
Hi @philip ,
Did you have a try with DATABASE_REJECT_UNAUTHORIZED=false ?
Regards
philip
July 12, 2021, 10:16am
11
Just tried, same problem unfortunately.
philip
July 12, 2021, 11:56am
12
@Sliman_Medini ,
do you have any ideas I should try? Do you think it makes sense to again try to set up everything from scratch?
Thanks for your help
Hi @philip ,
Do you have DATABASE_SSL=true in conjunction with DATABASE_REJECT_UNAUTHORIZED=false ?
philip
July 12, 2021, 12:06pm
14
const path = require('path');
const databaseOptions = {
logging: !process.env.NODE_ENV || process.env.NODE_ENV === 'development' ? console.log : false,
pool: { maxConnections: 10, minConnections: 1 },
dialectOptions: {},
};
if (process.env.DATABASE_SSL=true && JSON.parse(process.env.DATABASE_SSL.toLowerCase())) {
const rejectUnauthorized = process.env.DATABASE_REJECT_UNAUTHORIZED=false;
if (rejectUnauthorized && (JSON.parse(rejectUnauthorized.toLowerCase()) === false)) {
databaseOptions.dialectOptions.ssl = { rejectUnauthorized: false };
} else {
databaseOptions.dialectOptions.ssl = true;
}
}
module.exports = [{
name: 'default',
modelsDir: path.resolve(__dirname, '../models'),
connection: {
url: process.env.DATABASE_URL,
options: { ...databaseOptions },
},
}];
You mean like this? If I add =true, the app crashes
There is no need to change the code, you can just add this to your .env file:
DATABASE_SSL=true
DATABASE_REJECT_UNAUTHORIZED=false
1 Like
philip
July 12, 2021, 12:21pm
16
It works! Merci beaucoup @Sliman_Medini !
1 Like
I really appreciate it.