Config大杂烩

Here for recording the configuration of my patch hodgepodge with a default environmentUbuntu 22.04.

n8n

Docker Deployment

Note:

• use pg

#!/bin/bash
docker run -d --name n8n --network n8n -p 5678:5678 \
  -e DB_TYPE=postgresdb \
  -e DB_POSTGRESDB_HOST=pg \
  -e DB_POSTGRESDB_PORT=5432 \
  -e DB_POSTGRESDB_DATABASE=v1 \
  -e DB_POSTGRESDB_USER=v1 \
  -e DB_POSTGRESDB_PASSWORD=v1 \
  -e N8N_RUNNERS_ENABLED=true \
  -e N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true \
  -e GENERIC_TIMEZONE="Europe/Berlin" \
  -e TZ="Europe/Berlin" \
  -e N8N_SECURE_COOKIE=false \
  -e N8N_LOG_LEVEL=debug \
  -e N8N_LOG_OUTPUT="console,file" \
  -e N8N_LOG_FILE_LOCATION="/home/node/.n8n/logs/n8n.log" \
  -e N8N_LOG_FILE_SIZE_MAX=16 \
  -e N8N_LOG_FILE_COUNT_MAX=100 \
  -v n8n_data:/home/node/.n8n \
  --user node \
  n8nio/n8n

Postgres

Docker Deployment

#!/bin/bash
docker run -d --name pg --network n8n \
  -e POSTGRES_USER=v1 \
  -e POSTGRES_PASSWORD=v1 \
  -e POSTGRES_DB=v1 \
  -p 5432:5432 \
  -v pgdata:/var/lib/postgresql/data \
  postgres:15

MySQL

Docker Deployment

#!/bin/bash
docker run 
--name mysql 
-e MYSQL_ROOT_PASSWORD=123456
-p 3306:3306 
-v /my/local/mysql-data:/var/lib/mysql 
-d mysql:latest

SSH

sudo apt install openssh-server openssh-client

which sshd

sudo systemctl start ssh
sudo systemctl enable ssh

sudo systemctl status ssh

ssh -V

VS Code using SSH connection

VS Code Config

• install Remote - SSH in VS Code

Host Config

• install SSH in host

• ensure the expected login is not locked

  sudo passwd -S [username]
  # L means it is locked, P means unlocked
  root L 09/11/2024 0 99999 7 -1
  # unlock the login
  sudo passwd -u p[username]