Spaces:
Sleeping
Sleeping
| # n8n-activate.sh | |
| # This script manually flips the 'active' bit in the n8n SQLite database. | |
| DB_PATH="/data/.n8n/database.sqlite" | |
| if [ ! -f "$DB_PATH" ]; then | |
| echo "Error: Database not found at $DB_PATH" | |
| exit 1 | |
| fi | |
| echo "Surgically activating all production workflows..." | |
| # Set all workflows with 'PRODUCTION' in the name to active | |
| sqlite3 "$DB_PATH" "UPDATE workflow_entity SET active = 1 WHERE name LIKE '%PRODUCTION%';" | |
| # Also ensure the webhook_entity table is populated for the handler | |
| # We use a subquery to get the ID of the handler | |
| WORKFLOW_ID=$(sqlite3 "$DB_PATH" "SELECT id FROM workflow_entity WHERE name = 'Stripe Webhook Handler - PRODUCTION' LIMIT 1;") | |
| if [ -n "$WORKFLOW_ID" ]; then | |
| echo "Registering webhook route for $WORKFLOW_ID..." | |
| sqlite3 "$DB_PATH" "INSERT OR REPLACE INTO webhook_entity (workflowId, webhookPath, method, node, webhookId, pathLength) VALUES ('$WORKFLOW_ID', 'stripe-webhook', 'POST', 'webhook-node', 'stripe-webhook', 15);" | |
| else | |
| echo "Error: Stripe Webhook Handler not found in database." | |
| fi | |
| echo "Activation complete. Restarting n8n for routing refresh..." | |