Sponsoring: n8n

[thetomester13]

@atrilahiji I came across a few things, wondering if you have some input on these:

• I'm not able to simply 'run' workflows. Trying to 'Execute' results in an endless spinning of a wheel. When trying to hit 'Stop' to stop the execution, this shows up in the logs:

Apr 27 13:51:02 Error: The execution id "6" could not be found.
Apr 27 13:51:02 at /usr/local/node-12.16.3/lib/node_modules/n8n/dist/src/Server.js:1142:27
Apr 27 13:51:02 at runMicrotasks (<anonymous>)
Apr 27 13:51:02 at processTicksAndRejections (internal/process/task_queues.js:97:5)
Apr 27 13:51:02 at async /usr/local/node-12.16.3/lib/node_modules/n8n/dist/src/ResponseHelper.js:76:26

• I can switch over a workflow to a webhook, and then properly trigger the workflow, which is awesome! However, to test this out, I'm doing a simple 'send email' using my Cloudron SMTP credentials. This node fails on the workflow with the following error: ERROR: 140532647925632:error:1408F10B:SSL routines:ssl3_get_record:wrong version number:../deps/openssl/openssl/ssl/record/ssl3_record.c:332:

I know this is very much a work in progress, just wanted to record these in case anyone has some input.

[A Former User]

@thetomester13 huh openssl errors??? O_O

Yeah not immediately sure why but I'll do some digging.

I'm also just going to do some cleaning up of the package

[thetomester13]

@atrilahiji upon further investigation , it seems as if it's just a problem with the Send Email node (or maybe my credentials? Though IMAP is confirmed working). I'm able to create other workflows with other triggers that run properly! Very awesome stuff!

[A Former User]

@thetomester13 Yeah seems to be a weird upstream issue. I also just disabled SSL for SMTP and it worked. Still using port 587

[A Former User]

@thetomester13 I also bumped both the N8N and Node versions

[girish]

@thetomester13 said in Sponsoring: n8n:

@atrilahiji upon further investigation , it seems as if it's just a problem with the Send Email node (or maybe my credentials? Though IMAP is confirmed working). I'm able to create other workflows with other triggers that run properly! Very awesome stuff!

There seems to a bug with the cert renewal logic which I am just investigating. If you go to Services -> Mail -> Restart it copies over the fresh cert.

[girish]

@atrilahiji @thetomester13 so, should i just go ahead and push that as unstable?

[thetomester13]

@atrilahiji said in Sponsoring: n8n:

@thetomester13 I also bumped both the N8N and Node versions

I'm still not able to get my SMTP Send Email node to work for some reason, even with the refresh of Mail certs and Ignoring SSL Errors. shrug not a huge deal for now, I'll play around with it some more coming up.

@girish said in Sponsoring: n8n:

@atrilahiji @thetomester13 so, should i just go ahead and push that as unstable?

I think that should be fine!

[A Former User]

@girish It seems stable enough to be unstable. FYI the most up to date package is here https://git.atrilahiji.dev/atrilahiji/cloudron-n8n-app

[thetomester13]

@atrilahiji ooooookay. You said you turned off SSL, not SSL Errors. Yes, turning that off in the credentials themselves worked!

[A Former User]

@thetomester13 Yep! Gmail seemed to think it was secured with TLS anyways so IDK? IMAP seems to work anyways.

[girish]

@atrilahiji do you think you can add a LICENSE file and I can then put the repo in git.cloudron.io. Thanks!

[A Former User]

@girish Done

[girish]

@atrilahiji Thanks! Here - https://git.cloudron.io/cloudron/n8n-app . you and @thetomester13 should have push access. I am just building the unstable package.

[girish]

OK, this is published as unstable now. I haven't really looked into the package code itself but I will take a look when I find the time this week. I created a n8n app category, so please continue discussing there.

[marcusquinn]

Awesome work - thank you kindly! Will give it a good test, and see if we can contribute connectors for EspoCRM too.

[girish]

@marcusquinn Yes, as a heads up, it doesn't work in firefox, only in chrome. Some nginx/event source issue - https://forum.cloudron.io/topic/4980/cannot-reach-backend-server

[marcusquinn]

@girish Cool - got it. I guess that means all/most Chromiums.

As an aside; I have ended up reviewing Edge in the last couple of days by chance - it's surprisingly nice, and certainly better than the trojan horse that is Google Chrome.

[micmc]

@atrilahiji said in Sponsoring: n8n:
@girish Done KUDOS !
@marcusquinn
Great stuff mates!
Meanwhile my last post and I come back there's been a few discussion and work done.

• I'd been able to successfully install the 'unstable' version from the std repo
• It's my intention to much test it, specifically with Mautic but much more as incidentally this app connect with several of the FOSS we have on Cloudron apps repo.
• I'd have the 'Connection lost' message as well and got it temporarily 'fixed' using a chromium based browser (I use brave, but I'm quite allergic to 'googoo' chromie sh..., heuu I mean, stuff lol) (that should / must work with Firefox based as well, not sure if the glitch is due to UI from the devs or else, something to look deeper). At moment of writing the app seems to work well with Brave browser (chromium based).
• @marcusquinn Marcus, bro I agree with your sayings about apps that should be prioritized, as business apps i.e., above the fun and entertainment apps. Not that they're not appreciated and fun, and not that they're not adding value. They are! Business people too, have fun (sometimes lol) and families and all cool apps are always an added value and appreciated. However, I too believe that this, Cloudron, i$ mainly a $olution for making ($$) it easier to conduct digital business for every level, whether entrepreneur (non-techie), and nerds as well, and even beginners for any kind of new business in 2021 (I firmly believe this, I'm building some specific training for this, we can help a lot, a huge amount, of people to recover and start new careers, literally, starting with a Cloud Box as Cloudron actual offer. As there's plenty of kanban, notes taking, and music players, and the like, I personally believe we're still greatly lacking of a few, let's say MAJOR apps, that MUST be part of a 'business online apps suite'.
  As business online perspective, on the major apps side which are a must fro business we have:
  • Email server
  • Website hosting (WP, Ghost and more, w redis)
  • Email marketing lists server w automation
  • Marketing Automation
  • Powerful Surveys (marketing tool)
  • Full Analytics Stats server
  • Full Invoicing and Payment UI
  • Full Help Desk Online Support System
  • Project Management
  • Business and Workflow Management
  • Team Communication
  • Team Collaboration
  • Office Online suite (w collaboration)
  • Audio - Video Conferencing (still small scale though)
  • Powerful granulated Files Sharing System
  • Video and Audio Hosting and sharing platform
  • Audio and Video Streaming Podcast
  • WIKI Platforms as docs and knowledge base
  • Powerful Online Education and Training Platform

And there's even so much more, but I'll keep it for like I said the major apps that should more or less be used by "a business".

IMHO, what's still missing is:

• SEO tools (I've proposed "SEO Panel" it's the best available as FOSS and it's SaaS ready, there's a thread here in wish list)
• Social Media (marketing n management tools) I think there's a few suggestions in the wish list already but that should also be looked for.
• More stable, easier (or simpler) to manage and/or implement, video conferencing / webinar platform.

I've recently went through the apps wish list and there seems to be a whole a lot more pretty much interesting apps waiting to be added. Indeed, it seems we've reached to a point where there's more demand than the capacity to handle them exists. So, yeah, for the moment, I'd agree to say let's focus on the most important ones, work them push them, increase CR sales and all make money and then hire more devs to keep going to the next level.

TTYL all
Andy

[marcusquinn]

@micmc We're on the same page. It's all a puzzle but going in the right direction.
If I may, a couple of recommendations I think you'll like:

1. Vivaldi browser - I like it a lot.
2. EspoCRM - I also like it a lot, and have a large amount of work invested in it now and happy to share under that post.