today I played with n8n workflow automation:
It's a nice tool and still meets my expectations in the area I was planning to use it. If it helps you, I am attaching a functional compose (I will tune final secure version):
It contains everything necessary, including ENV for the type of security levels (system usr/psw).
System is running as expected and first workflows were tested. Useful tool.
At the end:
It's a nice tool and still meets my expectations in the area I was planning to use it. If it helps you, I am attaching a functional compose (I will tune final secure version):
YAML:
version: '3.1'
services:
n8n:
image: n8nio/n8n
restart: always
volumes:
- ./n8n:/home/node/
ports:
- <port>:5678
environment:
DB_TYPE: mysqldb
DB_MYSQLDB_DATABASE: <scheme name>
DB_MYSQLDB_HOST: <host>
DB_MYSQLDB_PORT: <db port>
DB_MYSQLDB_USER: <scheme user>
DB_MYSQLDB_PASSWORD: <scheme psw>
N8N_BASIC_AUTH_ACTIVE: "true"
N8N_BASIC_AUTH_USER: <up to you>
# this is system user. You will be prompted to create App user, when sys will run
N8N_BASIC_AUTH_PASSWORD: <up to you>
command: /bin/sh -c "n8n start"
It contains everything necessary, including ENV for the type of security levels (system usr/psw).
System is running as expected and first workflows were tested. Useful tool.
At the end:
- this is deployment with external MySQL DB
- you can use simple version based on SQLite, but … I like more control about the environment
- there is also possible use Maria and Postgres … more here