Information on your n8n setup
- n8n version: 1.75.1
- Database (default: SQLite): Cloud SQL (Postgres)
- n8n EXECUTIONS_PROCESS setting (default: own, main): not set
- Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud run
- Operating system:
Hey,
I’m trying to run n8n on Cloud Run with Cloud SQL connected via Cloud SQL connection, using VPC serverless connector and Unix socket for database. I’ve tried running some simple app which would connect to database and it works fine with same Cloud Run settings. However in n8n service I see the following error:
User settings loaded from: /home/node/.n8n/config
(node:9) Warning: TypeError
module: @oclif/[email protected]
task: findCommand (audit)
plugin: n8n
root: /usr/local/lib/node_modules/n8n
message: Cannot read properties of undefined (reading 'database')
See more details with DEBUG=*
› Error: command start not found
Container called exit(2).
Env vars I have set:
DB_POSTGRESDB_DATABASE=n8n
DB_POSTGRESDB_PASSWORD=yyy
DB_POSTGRESDB_PORT=5432
DB_TYPE=postgres
N8N_TEMPLATES_ENABLED=true
DB_POSTGRESDB_USER=n8n
N8N_ENCRYPTION_KEY=yyy
GENERIC_TIMEZONE=Europe/Berlin
N8N_PROXY_HOPS=1
N8N_LOG_LEVEL=debug
N8N_EDITOR_BASE_URL=https://n8n.domain.com
DB_POSTGRESDB_SCHEMA=public
N8N_HOST=n8n.domain.com
N8N_ENFORCE_SETTINGS_FILE_PERMISSION=ture
DB_POSTGRESDB_HOST=/cloudsql/project:europe-west1:n8n/.s.PGSQL.5432
Changing db host to IP doesn’t help either. Any ideas where to start digging?