Deploy with Heroku throws error about n8n-heroku

[fullbright]

@Vadorequest I found a solution. You need to move the version of n8n in the Dockerfile to 0.98.0 and redeploy the application.
Worked for me.

[Vadorequest]

I forked this repository and fixed the Heroku integration following @fullbright trick.

https://github.com/UnlyEd/n8n-heroku-demo

Also made an online version available, hosted on heroku at https://unly-n8n-demo.herokuapp.com

[vongohren]

There seem to be a couple of issues with this heroku deployment?
It cannot handle webhooks, triggers?
I tried with a trello one and got back 403, because it tried registering with a localhost url. Which is strange.
I also updated my heroku instance but ended up having to setup all my triggers all over again, as they we decrypted with a different key than available after the deploy.

Strange stuff

[fullbright]

For the localhost issue, you need to setup an env variable to give the app your public url. Check the doc for the exact variable to add. For the lost configuration, maybe your database has been erased. Can you check these 2 parts ? Le dim. 14 févr. 2021 à 23:37, Snorre Lothar von Gohren Edwin < [email protected]> a écrit :

…

There seem to be a couple of issues with this heroku deployment? It cannot handle webhooks, triggers? I tried with a trello one and got back 403, because it tried registering with a localhost url. Which is strange. I also updated my heroku instance but ended up having to setup all my triggers all over again, as they we decrypted with a different key than available after the deploy. Strange stuff — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#16 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAF476DDNEEO2PNV6ZJNT4TS7BGEBANCNFSM4TDZK2JA> .

[vongohren]

It seems that I found some variables thanks to you guys
Encryption key worked: https://docs.n8n.io/reference/configuration.html#encryption-key. No longer not problem with credentials

Then for webhook, I needed this: https://docs.n8n.io/reference/configuration.html#webhook-url. First thought i needed this: https://docs.n8n.io/reference/configuration.html#publish, but that did not work. So the webhook-url is important.

So all fixed for me now. I had to go via: https://github.com/UnlyEd/n8n-heroku-demo/ to deploy though.

[JulienBardin]

I have the same error

[bellonline]

Me too. I try to use PostgreSQL the It happened.
Could @sarveshpro please explain more about how to use PostgreSQL?

[bellonline]

I find this error log

npm WARN deprecated [email protected]: request-promise-native has been deprecated because it extends the now deprecated request package, see request/request#3142
npm WARN deprecated [email protected]: request has been deprecated, see request/request#3142
npm WARN deprecated [email protected]: this library is no longer supported
/usr/local/bin/n8n -> /usr/local/lib/node_modules/n8n/bin/n8n

[email protected] install /usr/local/lib/node_modules/n8n/node_modules/sqlite3
node-pre-gyp install --fallback-to-build
node-pre-gyp WARN Using request for node-pre-gyp https download
node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-linux-x64.tar.gz
node-pre-gyp WARN Pre-built binaries not found for [email protected] and [email protected] (node-v83 ABI, musl) (falling back to source compile with node-gyp)
make: Entering directory '/usr/local/lib/node_modules/n8n/node_modules/sqlite3/build'
ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c
TOUCH Release/obj.target/deps/action_before_build.stamp
CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3310100/sqlite3.o

[Vadorequest]

Same, I basically clicked on the "Deploy to heroku button" and it got deployed, but I get the following when I go to the app:

Note that I changed the basic auth login/password, but that's it.

Logs:

heroku logs --tail --app=unly-n8n
[...]
2020-12-06T15:29:04.699249+00:00 heroku[web.1]: Starting process with command `/start.sh`
2020-12-06T15:29:06.764250+00:00 app[web.1]: N8N will start on '58444'
2020-12-06T15:29:06.764297+00:00 app[web.1]: postgres://wgenyjymnkdjnm:[e-mail]:5432/d62fc9j92lg1uo
2020-12-06T15:29:06.764300+00:00 app[web.1]: postgre config detected
2020-12-06T15:29:06.765536+00:00 app[web.1]: postgres://wgenyjymnkdjnm:[e-mail]:5432/d62fc9j92lg1uo
2020-12-06T15:29:06.767977+00:00 app[web.1]: indentified DB in use postgreSQL
2020-12-06T15:29:08.144153+00:00 app[web.1]: UserSettings got generated and saved to: /data/.n8n/config
2020-12-06T15:29:09.888779+00:00 heroku[web.1]: Process exited with status 0
2020-12-06T15:29:09.922281+00:00 heroku[web.1]: State changed from starting to crashed
2020-12-06T15:29:09.925661+00:00 heroku[web.1]: State changed from crashed to starting
2020-12-06T15:29:17.682825+00:00 heroku[web.1]: Starting process with command `/start.sh`
2020-12-06T15:29:19.858017+00:00 app[web.1]: N8N will start on '41378'
2020-12-06T15:29:19.858048+00:00 app[web.1]: postgres://wgenyjymnkdjnm:[e-mail]:5432/d62fc9j92lg1uo
2020-12-06T15:29:19.858051+00:00 app[web.1]: postgre config detected
2020-12-06T15:29:19.859350+00:00 app[web.1]: postgres://wgenyjymnkdjnm:[e-mail]:5432/d62fc9j92lg1uo
2020-12-06T15:29:19.861364+00:00 app[web.1]: indentified DB in use postgreSQL
2020-12-06T15:29:21.350517+00:00 app[web.1]: UserSettings got generated and saved to: /data/.n8n/config
2020-12-06T15:29:23.191713+00:00 heroku[web.1]: Process exited with status 0
2020-12-06T15:29:23.224363+00:00 heroku[web.1]: State changed from starting to crashed
2020-12-06T15:29:45.043603+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=unly-n8n.herokuapp.com request_id=f00efeec-d3f8-49fc-8c48-23bf262d6c85 fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https
2020-12-06T15:29:45.047882+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/robots.txt" host=unly-n8n.herokuapp.com request_id=57bb117c-81df-43b2-9253-523bd1b8e46b fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https
2020-12-06T15:29:47.130703+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/favicon.ico" host=unly-n8n.herokuapp.com request_id=bc9751bd-03f7-42dd-9a54-b5fc24db106b fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https
2020-12-06T15:30:39.798149+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=unly-n8n.herokuapp.com request_id=da4f12b0-e005-4ab2-9157-10b3902b47c1 fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https
2020-12-06T15:30:41.422700+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/favicon.ico" host=unly-n8n.herokuapp.com request_id=30d81874-cc95-41d2-907a-11d5e789354d fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https
2020-12-06T15:34:46.662806+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=unly-n8n.herokuapp.com request_id=2e46bad2-0ba9-4bf5-a24f-24fa86ee5679 fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https
2020-12-06T15:34:48.135301+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/favicon.ico" host=unly-n8n.herokuapp.com request_id=875cb88e-01ed-4312-90f3-ca1e3707b158 fwd="176.158.114.162" dyno= connect= service= status=503 bytes= protocol=https

[fullbright]

Same issue here. Did you find a solution?

[Vadorequest]

@fullbright Nope, I haven't search much for one either, basically moved to the Cloud offering.

But it'd be great to have it for free and unlimited using Heroku!

[Vadorequest]

@fullbright Awesome! I never used Heroku, could you share how to edit the Dockerfile?
Do you edit it prior to deploying? Can you change it after you deployed? (and if so, how)

Shouldn't the version be defined as a ENV variable? That might be much easier to update this way. 🤔

[Vadorequest]

Also, I tried using another login/password for a proprietary project and I couldn't authenticate myself. Maybe I made a dumb mistake, but I feel like Basic Auth might have some restrictions like a password max length or so.

[capriciousduck]

@Vadorequest I found a solution. You need to move the version of n8n in the Dockerfile to 0.98.0 and redeploy the application.
Worked for me.

What if the n8n upgrades to a newer version? Then if I make the change in Dockerfile and redeploy, will all the triggers I created wipe off?

[fullbright]

In that case, you need to change the version number in the Dockerfile again (which you need to do anyway with the previous version). Le jeu. 7 janv. 2021 à 07:28, Krishna Chaitanya <[email protected]> a écrit :

…

@Vadorequest <https://github.com/Vadorequest> I found a solution. You need to move the version of n8n in the Dockerfile to 0.98.0 and redeploy the application. Worked for me. What if the n8n upgrades to a newer version? Then if I make the change in Dockerfile and redeploy, will all the triggers I created wipe off? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#16 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAF476CDDWPDXUHU3F7DU4DSYVICNANCNFSM4TDZK2JA> .

[capriciousduck]

@fullbright What about the triggers I created then? Should I re-create the triggers when I deploy a new version of the app?

[fullbright]

The triggers data are stored in the DB that you connect n8n to so I think they will be kept. Don't take my work for granted though, run a quick test with 2 docker containers locally (connected to the same DB) and see if the data is kept).

…

[capriciousduck]

@fullbright What if I create a new trigger in the heroku-hosted ngn instance and then I re-deploy the app, leaving the database add-ons as they are. Would that confirm?

[fullbright]

It should work, but to be sure, it must be tested.

…

[capriciousduck]

@fullbright It's working!. I created a test trigger and re-deployed the app. I could still see the test trigger I created. Thanks!

By the way, how many triggers can I create before reaching the 1Gb database storage limit? Please forgive me if the question sounds silly. I have no knowledge of databases.

And, is 512Mb of RAM enough for ngn? Wouldn't that be a problem in the future after I create many workflows?

[Vadorequest]

@capriciousduck 1GB data storage is huge, you might never reach it. I don't know what's stored in the DB, but if it's only the workflow files, then you could have thousands workflows without issue.

Regarding the RAM, hard to say, but I expect n8n to be really light considering it's a short-live process that only triggers when an event occurs. Basically, it might limit the number of workflows triggering in parallel, but that's it. I don't feel like you'd need more unless you have hundreds of workflows triggering at the same time.

You should probably ask on n8n forum https://community.n8n.io/ then might give you interesting feedback regarding how big your hosting server should be.

[lchanc3]

To solve "Credentials could not be decrypted. The reason is that probably a different", you can refer to the method in this article to set
https://community.n8n.io/t/credentials-error/181/4

[SefaDedeoglu]

I had same error and fixed it with dotenv
Heroku dont allow static ports