Help me with deployment to heroku - PostgreSQL self signed certificate error?. -- 2
Budget: $2 – $8 USD
Hello, freelancers!
Please help me with deploy to heroku. It is the react node.js based application working perfectly on local machine but I have an issue after deploy. Deploy process is successfully done.
But the issue I get is graphql query doesn't work runtime when sends a query request from client app to graphql server, which is hosted by postgraphile.
The app makes a use of postgraphile as an independent child process for graphql server in node.js based serverside script - index.ts. It doesn't throw any error during heroku deploy process.
So I think it's not a graphql issue. Seems that heroku postgresql has some policy to deal with.
To figure out the issue, I tried running below command on my machine.
I got such an error.
Command executed:
postgraphile --connection postgres://<user>:<password>@ec2-52-212-228-71.eu-west-1.compute.amazonaws.com/<db_name>?sslmode=require --schema app_public --watch --cors
Error: Like attached image.
As the error describes, it doesn't seem to be related to graphql or postgraphile. Maybe PostgreSQL has ssl privacy or something else to allow access from others.. But please note that I successfully migrated the data into heroku postgresql via Flyway. First I failed because I didn't put sslmode=require in url. But after sslmode=require attached to the url, it just started working correct.
Any idea to solve this issue? Please send me if you already faced such an issue or have solution for it.
p.s.:
Command without sslmode=require:
postgraphile --connection postgres://whilpvecvuavfb:28e6b0f3ca8aa57d36ac79fdaa68bf5a3ad6c3c582212fc46d5c081a1c36b36a@<hostname>/d3um81ot2lldbi --schema app_public --watch --cors
Error I get:
error: no pg_hba.conf entry for host "45.126.3.246", user "<username>", database "<password>", no encryption
at Parser.parseErrorMessage (C:\Users\ABCz\AppData\Roaming\npm\node_modules\postgraphile\node_modules\pg-protocol\dist\parser.js:287:98)
Please help me with deploy to heroku. It is the react node.js based application working perfectly on local machine but I have an issue after deploy. Deploy process is successfully done.
But the issue I get is graphql query doesn't work runtime when sends a query request from client app to graphql server, which is hosted by postgraphile.
The app makes a use of postgraphile as an independent child process for graphql server in node.js based serverside script - index.ts. It doesn't throw any error during heroku deploy process.
So I think it's not a graphql issue. Seems that heroku postgresql has some policy to deal with.
To figure out the issue, I tried running below command on my machine.
I got such an error.
Command executed:
postgraphile --connection postgres://<user>:<password>@ec2-52-212-228-71.eu-west-1.compute.amazonaws.com/<db_name>?sslmode=require --schema app_public --watch --cors
Error: Like attached image.
As the error describes, it doesn't seem to be related to graphql or postgraphile. Maybe PostgreSQL has ssl privacy or something else to allow access from others.. But please note that I successfully migrated the data into heroku postgresql via Flyway. First I failed because I didn't put sslmode=require in url. But after sslmode=require attached to the url, it just started working correct.
Any idea to solve this issue? Please send me if you already faced such an issue or have solution for it.
p.s.:
Command without sslmode=require:
postgraphile --connection postgres://whilpvecvuavfb:28e6b0f3ca8aa57d36ac79fdaa68bf5a3ad6c3c582212fc46d5c081a1c36b36a@<hostname>/d3um81ot2lldbi --schema app_public --watch --cors
Error I get:
error: no pg_hba.conf entry for host "45.126.3.246", user "<username>", database "<password>", no encryption
at Parser.parseErrorMessage (C:\Users\ABCz\AppData\Roaming\npm\node_modules\postgraphile\node_modules\pg-protocol\dist\parser.js:287:98)