* fix(camera): fix camera stream not displaying — CSP frame-ancestors and HTTP SSRF block - next.config.ts: add path-scoped header override for /api/camera/proxy/:path* setting frame-ancestors 'self' and X-Frame-Options SAMEORIGIN so proxy iframe responses are not blocked by the global frame-ancestors 'none' policy - ssrf.ts: extend validateOrigin to accept http:// URLs; the stream proxy is a server-side bridge that must fetch plain-HTTP camera feeds before re-serving them over HTTPS to the browser to avoid mixed-content blocks - ssrf.spec.ts: update validateOrigin tests to match new HTTP-allowed behaviour; add explicit rejection tests for ftp://, file://, data://, javascript:// - scripts/boot-db.mjs: create .env from .env.example in worktrees when missing so DATABASE_URL injection block is never silently skipped * fix(camera): sandbox proxied iframes and unblock external stylesheets The CSP override for /api/camera/proxy/:path* still inherited the app's restrictive style-src/script-src, which blocked external stylesheets and scripts inside proxied iframes (YouTube, third-party players, etc). Relax proxy CSP to default-src * while keeping frame-ancestors 'self'. Because the proxy iframe is same-origin with the host app, this widened CSP would have let upstream HTML reach window.parent.localStorage / DOM. Add sandbox="allow-scripts allow-popups allow-presentation" (no allow-same-origin) to proxied iframes so they run in an opaque origin and cannot touch the host app. Major-platform iframes (YouTube/Twitch/ Vimeo) bypass the proxy and remain unsandboxed since the browser already isolates them via cross-origin. - next.config.ts: proxy CSP -> default-src * 'unsafe-inline' 'unsafe-eval' data: blob:; frame-ancestors 'self' - CameraStream.tsx: add sandbox attribute to proxied (non-major-platform) iframes
165 lines
5.4 KiB
JavaScript
165 lines
5.4 KiB
JavaScript
/**
|
|
* @file boot-db.mjs
|
|
* @description Database bootstrapping utility.
|
|
* Automates the startup of the local PostgreSQL container via Docker Compose
|
|
* and ensures the environment is ready for Prisma migrations.
|
|
* @module scripts
|
|
*/
|
|
|
|
import { execSync } from 'child_process';
|
|
import fs from 'fs';
|
|
import path from 'path';
|
|
import crypto from 'crypto';
|
|
|
|
// Load environment variables manually since dotenv might not be installed globally
|
|
/**
|
|
* @function loadEnv
|
|
* @description Manually parses a .env file into process.env to avoid
|
|
* external dependencies like 'dotenv' during early boot.
|
|
*/
|
|
const loadEnv = (file) => {
|
|
try {
|
|
if (fs.existsSync(file)) {
|
|
const content = fs.readFileSync(file, 'utf8');
|
|
content.split('\n').forEach(line => {
|
|
const match = line.match(/^\s*([\w.-]+)\s*=\s*(.*)?\s*$/);
|
|
if (match) {
|
|
const key = match[1];
|
|
let value = match[2] || '';
|
|
// Remove quotes
|
|
if (value.startsWith('"') && value.endsWith('"')) value = value.slice(1, -1);
|
|
if (value.startsWith("'") && value.endsWith("'")) value = value.slice(1, -1);
|
|
process.env[key] = value;
|
|
}
|
|
});
|
|
}
|
|
} catch (e) {
|
|
// Ignore read errors
|
|
}
|
|
};
|
|
|
|
loadEnv('.env');
|
|
|
|
const skipLocalDb = process.env.WWV_SKIP_LOCAL_DB === 'true' || process.env.WWV_SKIP_LOCAL_DB === '1';
|
|
|
|
if (skipLocalDb) {
|
|
console.log('⏭️ Skipping local PostgreSQL startup (WWV_SKIP_LOCAL_DB is set).');
|
|
process.exit(0);
|
|
}
|
|
|
|
// Deterministic Port Assignment
|
|
const cwd = process.cwd();
|
|
const folderName = path.basename(cwd);
|
|
let port = 5432; // Default for main repo
|
|
|
|
if (folderName !== 'worldwideview') {
|
|
const hash = crypto.createHash('sha256').update(cwd).digest('hex');
|
|
const portOffset = parseInt(hash.substring(0, 4), 16) % 1000;
|
|
port = 5433 + portOffset;
|
|
}
|
|
|
|
process.env.WWV_DB_PORT = port.toString();
|
|
console.log(`🔌 Assigned deterministic database port: ${port}`);
|
|
|
|
// Robust rewrite of DATABASE_URL in .env
|
|
const envPath = path.resolve(cwd, '.env');
|
|
|
|
// Ensure .env exists — worktrees only have .env.local, not .env.
|
|
// Without this, the DATABASE_URL injection block below is silently skipped
|
|
// and safe-db-push.mjs fails with "DATABASE_URL is missing".
|
|
if (!fs.existsSync(envPath)) {
|
|
const examplePath = path.resolve(cwd, '.env.example');
|
|
if (fs.existsSync(examplePath)) {
|
|
fs.copyFileSync(examplePath, envPath);
|
|
console.log('📄 Created .env from .env.example (worktree first-run).');
|
|
} else {
|
|
fs.writeFileSync(envPath, '');
|
|
console.log('📄 Created empty .env (worktree first-run).');
|
|
}
|
|
}
|
|
|
|
{
|
|
const envContent = fs.readFileSync(envPath, 'utf8');
|
|
const lines = envContent.split(/\r?\n/);
|
|
|
|
const targetUrl = `DATABASE_URL="postgresql://postgres:[email protected]:${port}/worldwideview?schema=public"`;
|
|
let foundTargetActive = false;
|
|
let linesModified = false;
|
|
|
|
const newLines = lines.map(line => {
|
|
// Check if line is an active DATABASE_URL
|
|
if (/^\s*DATABASE_URL\s*=/.test(line)) {
|
|
if (line.trim() === targetUrl) {
|
|
foundTargetActive = true;
|
|
return line;
|
|
} else {
|
|
console.warn(`⚠️ [Telemetry] Commenting out conflicting DATABASE_URL: ${line.trim()}`);
|
|
linesModified = true;
|
|
return `# ${line}`;
|
|
}
|
|
}
|
|
return line;
|
|
});
|
|
|
|
if (!foundTargetActive) {
|
|
console.log(`🔌 [Telemetry] Injecting correct local DATABASE_URL for port ${port}.`);
|
|
newLines.push(``);
|
|
newLines.push(`# Dynamically injected by boot-db.mjs for worktree`);
|
|
newLines.push(targetUrl);
|
|
linesModified = true;
|
|
}
|
|
|
|
if (linesModified) {
|
|
const newContent = newLines.join('\n');
|
|
|
|
// File write with retries and telemetry
|
|
const maxRetries = 3;
|
|
let attempt = 0;
|
|
while (attempt < maxRetries) {
|
|
try {
|
|
fs.writeFileSync(envPath, newContent, 'utf8');
|
|
break; // Success
|
|
} catch (err) {
|
|
attempt++;
|
|
if (err.code === 'EBUSY' || err.code === 'EPERM' || err.message.includes('os error 32')) {
|
|
console.warn(`⚠️ [Telemetry] File lock encountered on .env (attempt ${attempt}/${maxRetries}). Retrying in 100ms...`);
|
|
if (attempt >= maxRetries) {
|
|
console.error('❌ Failed to write .env after multiple attempts due to file locks.');
|
|
throw err;
|
|
}
|
|
// Synchronous sleep since boot-db.mjs isn't currently inside an async IIFE
|
|
const start = Date.now();
|
|
while (Date.now() - start < 100) {}
|
|
} else {
|
|
throw err;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
} // end DATABASE_URL injection block
|
|
|
|
|
|
console.log('🚀 Checking local PostgreSQL database...');
|
|
|
|
try {
|
|
// Check if docker is installed
|
|
try {
|
|
execSync('docker --version', { stdio: 'ignore' });
|
|
} catch (e) {
|
|
console.log('⚠️ Docker is not installed or not in PATH. Skipping local database startup.');
|
|
console.log('💡 If you want to run a local database automatically, please install Docker Desktop.');
|
|
process.exit(0);
|
|
}
|
|
|
|
// Start the db service and wait for it to be healthy
|
|
console.log('📦 Starting PostgreSQL via Docker Compose...');
|
|
execSync('docker compose up -d --wait db', { stdio: 'inherit' });
|
|
|
|
console.log('✅ Local PostgreSQL database is ready!');
|
|
|
|
} catch (error) {
|
|
console.error('❌ Failed to start local database:', error.message);
|
|
console.log('💡 Ensure that docker is running and try again');
|
|
console.log('💡 You may need to start it manually or set WWV_SKIP_LOCAL_DB=true to use an external database.');
|
|
}
|