Moving to production shows blank page

Help me!
1

This is a template you can use to report issues. You can also drag images, videos and include Preformatted text

Expected behavior

My app works fine when running locally, I’d expect it to be running fine on production.

Actual behavior

I deployed on Heroku, connected to the database and added the provided config variables. I clicked ‘finish’ and the production environment is now listed under the ‘environments’ section of my locally hosted app. I set up a new role and as far as I can tell, the site should be up and running. However, navigating to the URL just shows me a blank page. Am I missing something?

Failure Logs

No errors seem to show in the logs:

2021-08-13T11:08:30.604087+00:00 heroku[web.1]: Restarting

2021-08-13T11:08:30.617112+00:00 heroku[web.1]: State changed from up to starting

2021-08-13T11:08:31.534805+00:00 heroku[web.1]: Stopping all processes with SIGTERM

2021-08-13T11:08:31.661021+00:00 heroku[web.1]: Process exited with status 143

2021-08-13T11:08:32.943063+00:00 heroku[web.1]: Starting process with command npm start

2021-08-13T11:08:34.905502+00:00 app[web.1]:

2021-08-13T11:08:34.905519+00:00 app[web.1]: > care4cf-admin@0.0.1 start /app

2021-08-13T11:08:34.905520+00:00 app[web.1]: > node ./server.js

2021-08-13T11:08:34.905520+00:00 app[web.1]:

2021-08-13T11:08:35.650198+00:00 app[web.1]: Your application is listening on port 40191.

2021-08-13T11:08:35.761695+00:00 app[web.1]: Your admin panel is available here: https://app.forestadmin.com/projects

2021-08-13T11:08:36.663767+00:00 heroku[web.1]: State changed from starting to up

2021-08-13T11:08:52.517372+00:00 heroku[router]: at=info method= GET path="/" host=care4cf-admin.herokuapp.com request_id=158908a1-a869-47f3-ac6a-8dad46ac25ab fwd=“86.152.129.214” dyno=web.1 connect=0ms service=11ms status=304 bytes=292 protocol=https

2021-08-13T11:08:52.516747+00:00 app[web.1]: GET / 304 - - 6.013 ms

2021-08-13T11:08:57.537190+00:00 heroku[router]: at=info method= GET path="/" host=care4cf-admin.herokuapp.com request_id=a5de1fc3-cfdd-487b-a493-c03a160b0296 fwd=“86.152.129.214” dyno=web.1 connect=0ms service=2ms status=304 bytes=292 protocol=https

2021-08-13T11:08:57.535704+00:00 app[web.1]: GET / 304 - - 1.054 ms

Context

Please provide any relevant information about your setup.

  • Express Version: 4.17.1
  • Nodejs Version: 16.5.0
  • Sequelize Version: 5.15.1
  • Database Dialect: MySQL
  • Database Version: 5.7.32-log
  • Project Name: care4cf-admin
2

Hi @JJWS :wave: welcome to our community, Have you got any error logs in your browser console when you try to access this url https://app.forestadmin.com/care4cf-admin/Production/Operations ?

3

Hi @Arnaud_Moncel, thanks for the response. I do indeed see an error:

2021-08-13T13:06:15.573919+00:00 app[web.1]: [forest] :deciduous_tree::deciduous_tree::deciduous_tree: Unexpected error: Client with IP address ‘34.242.89.28’ is not allowed to connect to this MySQL server.
2021-08-13T13:06:15.573926+00:00 app[web.1]: {
2021-08-13T13:06:15.573927+00:00 app[web.1]: “name”: “SequelizeConnectionError”,
2021-08-13T13:06:15.573928+00:00 app[web.1]: “parent”: {
2021-08-13T13:06:15.573928+00:00 app[web.1]: “errno”: 9000,
2021-08-13T13:06:15.573929+00:00 app[web.1]: “sqlState”: “HY000”,
2021-08-13T13:06:15.573930+00:00 app[web.1]: “sqlMessage”: “Client with IP address ‘34.242.89.28’ is not allowed to connect to this MySQL server.”

My database is on an Azure server, it looks like a connection security issue. Are there any suggested fixes that you know of?

4

Hi Arnaud, I amended the connection security on my Azure database. The link you shared is no longer raising any errors, but the deployed site (https://care4cf-admin.herokuapp.com/) is still a blank white page.

5

Hey @JJWS :wave:

It looks like a classic MySQL connection refused error. You can find more info on how to configure this here for example.

Do you have a different error on your backend after amending the connection security in azure?
Also, are you able to see your data in your project on app.forestadmin.com?
Finally, did you edit the default page (views/index.html)? It looks like their is an issue in the HTML response as you can see here
image

1 Like
6

Hi Jeff,

Thanks for the help! I’ve configured MySQL and fixed the HTML. I’m able to access my data on app.forestadmin.com - neither this or the production URL are throwing any errors on the logs.

The production URL (https://care4cf-admin.herokuapp.com/) is now showing a logo with the words ‘Your application is running!’. Should it instead be displaying my app?

7

Hey @JJWS

Your production URL is the one of your forest admin backend. You’ll still need to use https://app.forestadmin.com to access your project. Once you are logged in, you should see your project in the list (Just like you did on Development). Then, on the top left of your screen, you should be able to select the environment you want to use.

Let me know if you are able to access your project :pray:

Hope it helps.

1 Like