source: Klonkt/src/server.js@ 9465a0d

main
Last change on this file since 9465a0d was ff08153, checked in by roboburr <roboburr@…>, 3 months ago

Update feature: Admin -> Updates (git-based v1, per instance)

Admin panel shows app version + current vs. latest commit (from .klonkt-version
vs. bare repo) + an 'Update now' button. POST spawns a detached update script
that checks out the latest main, runs npm ci on lock changes, writes
.klonkt-version, and pm2 reloads. God-only. Signed release feed for external
self-hosters = v2.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@…>

  • Property mode set to 100644
File size: 16.7 KB
Line 
1/**
2 * Klonkt Hub Beta — server bootstrap
3 *
4 * Persoonlijk multi-site platform forked van PrutCMS v9 (PHP, file-based).
5 * Stack: Express + better-sqlite3 + EJS + htmx + ws.
6 */
7
8import 'dotenv/config';
9import express from 'express';
10import helmet from 'helmet';
11import session from 'express-session';
12import bodyParser from 'body-parser';
13import path from 'path';
14import fs from 'fs';
15import { fileURLToPath } from 'url';
16import http from 'http';
17import db, { initializeDatabase } from './config/database.js';
18import { SqliteSessionStore } from './services/SqliteSessionStore.js';
19import PrutterService from './services/PrutterService.js';
20import { WebSocketServer } from 'ws';
21
22import { resolveSite, loadAudioTracks, loadTheme } from './middleware/site.js';
23import { isViewer } from './middleware/auth.js';
24import { renderPage } from './middleware/render.js';
25import authRoutes from './routes/auth.js';
26import accountRoutes from './routes/account.js';
27import adminRoutes from './routes/admin.js';
28import adminAudioRoutes from './routes/admin-audio.js';
29import adminPlaylistsRoutes from './routes/admin-playlists.js';
30import adminSitesRoutes from './routes/admin-sites.js';
31import adminUsersRoutes from './routes/admin-users.js';
32import adminCommentsRoutes from './routes/admin-comments.js';
33import adminSettingsRoutes from './routes/admin-settings.js';
34import prutterRoutes from './routes/prutter.js';
35import audioRoutes from './routes/audio.js';
36import searchRoutes from './routes/search.js';
37import commentsRoutes from './routes/comments.js';
38import tagsRoutes from './routes/tags.js';
39import typesRoutes from './routes/types.js';
40import usersRoutes from './routes/users.js';
41import feedRoutes from './routes/feed.js';
42import hubRoutes from './routes/hub.js';
43import artistsRoutes from './routes/artists.js';
44import postsRoutes from './routes/posts.js';
45import federationRoutes from './routes/federation.js';
46import { startCircleSyncLoop } from './services/CircleService.js';
47import adminCircleRoutes from './routes/admin-circle.js';
48import adminUpdatesRoutes from './routes/admin-updates.js';
49import circleRoutes from './routes/circle.js';
50
51if (!process.env.SESSION_SECRET) {
52 console.error('❌ FATAL: SESSION_SECRET is required');
53 process.exit(1);
54}
55
56if (process.env.NODE_ENV === 'production' && process.env.SESSION_SECRET.length < 32) {
57 console.error('❌ FATAL: SESSION_SECRET too weak for production');
58 process.exit(1);
59}
60
61const __dirname = path.dirname(fileURLToPath(import.meta.url));
62const PORT = process.env.PORT || 3000;
63const isDev = process.env.NODE_ENV !== 'production';
64
65const app = express();
66const server = http.createServer(app);
67
68app.use(helmet({
69 contentSecurityPolicy: {
70 directives: {
71 defaultSrc: ["'self'"],
72 scriptSrc: [
73 "'self'",
74 "'unsafe-inline'",
75 // Eigen custom-embeds (embed-player.js) laden de OFFICIELE player-API's
76 // van deze hosts. Zonder deze whitelist blokkeert de CSP ze stil (alleen
77 // een console-fout) en faalt de embed-speler.
78 "https://www.youtube.com", // YouTube IFrame Player API (+ www-widgetapi.js)
79 "https://s.ytimg.com", // YouTube player-assets
80 "https://w.soundcloud.com", // SoundCloud Widget API (api.js)
81 "https://open.spotify.com", // Spotify iFrame API
82 ],
83 // Helmet's default zet script-src-attr op 'none', wat ALLE inline event-
84 // handlers (onchange/onclick/onsubmit) blokkeert — daardoor deed o.a. de
85 // avatar-upload (<input onchange="this.form.submit()">) en de rol-dropdown
86 // niets. We staan inline handlers expliciet toe, consistent met de al
87 // toegestane inline <script> hierboven.
88 scriptSrcAttr: ["'unsafe-inline'"],
89 styleSrc: ["'self'", "'unsafe-inline'"],
90 imgSrc: ["'self'", "data:", "https:"],
91 connectSrc: ["'self'", "wss:", "ws:"],
92 // blob: is required for the audio player — it fetch()es track bytes and
93 // plays from a blob: object URL (Spotify-style). Without blob: here the
94 // CSP silently blocks <audio>.src = blob:… → the player fires 'error' and
95 // auto-skips every track. 'self'/https: do NOT imply blob:.
96 mediaSrc: ["'self'", "https:", "blob:"],
97 fontSrc: ["'self'"],
98 frameSrc: [
99 "'self'",
100 "https://open.spotify.com",
101 "https://w.soundcloud.com",
102 "https://bandcamp.com",
103 "https://embed.music.apple.com",
104 "https://www.youtube-nocookie.com",
105 "https://www.youtube.com", // YouTube IFrame API maakt soms een www.youtube.com-iframe
106 "https://player.vimeo.com",
107 ],
108 },
109 },
110 hsts: { maxAge: 31536000, includeSubDomains: true, preload: true },
111 frameguard: { action: 'sameorigin' },
112 referrerPolicy: { policy: 'no-referrer-when-downgrade' },
113}));
114
115app.set('view engine', 'ejs');
116app.set('views', path.join(__dirname, 'views'));
117
118app.use(bodyParser.urlencoded({ extended: true, limit: '10mb' }));
119app.use(bodyParser.json({ limit: '10mb' }));
120
121// Trust one upstream proxy in production. NPM (or Caddy / nginx) terminates
122// HTTPS and forwards to us over plain HTTP, setting X-Forwarded-Proto: https.
123// Without this, Express sees req.protocol === 'http' and won't issue secure
124// cookies — sessions never persist past the redirect after login.
125if (!isDev) app.set('trust proxy', 1);
126
127// Session middleware extracted into a variable so the WebSocket upgrade
128// handler can reuse it (it needs req.session to authenticate sockets).
129const sessionMiddleware = session({
130 store: new SqliteSessionStore(),
131 secret: process.env.SESSION_SECRET,
132 resave: false,
133 saveUninitialized: false,
134 name: 'pcms.sid',
135 cookie: {
136 httpOnly: true,
137 secure: !isDev,
138 sameSite: 'lax',
139 maxAge: 30 * 24 * 60 * 60 * 1000,
140 },
141});
142app.use(sessionMiddleware);
143
144app.use('/assets', express.static(path.join(__dirname, 'assets'), { maxAge: isDev ? 0 : '1y' }));
145app.use('/media', express.static(process.env.MEDIA_PATH || './storage/media'));
146
147// (Verwijderd) TWA / digital-asset-links — alleen nodig voor de APK/TWA-variant.
148// Klonkt is PWA-only; geen assetlinks.json meer.
149
150initializeDatabase();
151
152// Cirkels: periodieke achtergrond-sync van remote instances (no-op tenzij tenancy='circle').
153startCircleSyncLoop();
154
155// Bundle HTMX: copy from node_modules into our own assets dir so we can serve
156// it locally (no third-party CDN). Idempotent — only copies if size differs.
157(function ensureLocalHtmx() {
158 const src = path.join(__dirname, '..', 'node_modules', 'htmx.org', 'dist', 'htmx.min.js');
159 const dest = path.join(__dirname, 'assets', 'js', 'htmx.min.js');
160 try {
161 const srcStat = fs.statSync(src);
162 const destStat = fs.existsSync(dest) ? fs.statSync(dest) : null;
163 if (!destStat || destStat.size !== srcStat.size) {
164 fs.copyFileSync(src, dest);
165 console.log(`📦 HTMX bundled locally: ${srcStat.size} bytes`);
166 }
167 } catch (e) {
168 console.warn('⚠️ Could not bundle HTMX:', e.message, '— run `npm install`');
169 }
170})();
171
172// Singleton PrutterService — routes get it via req.app.locals.prutter.
173const prutter = new PrutterService(db);
174app.locals.prutter = prutter;
175
176// Cirkels-federatie: publieke, site-agnostische endpoints (/.klonkt/*).
177// Vóór resolveSite/theme — ze hebben geen site-context nodig.
178app.use(federationRoutes);
179
180app.use(resolveSite);
181app.use(loadAudioTracks);
182app.use(loadTheme);
183
184// Lichtgewicht CSRF-defense: weiger cross-origin state-wijzigende requests.
185// Same-origin forms + HTMX sturen een matchende Origin; ontbreekt Origin dan
186// laten we door (non-browser clients). sameSite:'lax' op de sessiecookie is de
187// tweede laag. (Geldt niet voor GET/HEAD/OPTIONS.)
188app.use((req, res, next) => {
189 if (req.method === 'GET' || req.method === 'HEAD' || req.method === 'OPTIONS') return next();
190 const origin = req.get('origin');
191 if (!origin) return next(); // geen Origin -> geen browser-CSRF-vector
192 let originHost;
193 try { originHost = new URL(origin).host; } catch { return res.status(403).send('Ongeldige origin'); }
194 if (originHost !== req.get('host')) return res.status(403).send('Cross-origin request geweigerd');
195 next();
196});
197
198// Kijker-accounts: alles bekijken mag (incl. Beheer), niets wijzigen. Dit is de
199// ENIGE schrijf-blokkade — fail-closed, vóór alle route-handlers. Elke state-
200// wijzigende methode wordt geweigerd (de login-POST zet de sessie pas ná deze
201// guard, dus die valt er niet onder). I.p.v. rauwe 403-tekst tonen we een nette
202// pagina (of, bij HTMX, een ingeswapte melding).
203app.use((req, res, next) => {
204 const mutating = req.method !== 'GET' && req.method !== 'HEAD' && req.method !== 'OPTIONS';
205 if (mutating && isViewer(req.session?.user)) {
206 if (req.headers['hx-request'] === 'true') {
207 // htmx swapt niet op 4xx; stuur 200 + retarget zodat de melding in #pcms-main verschijnt.
208 res.setHeader('HX-Retarget', '#pcms-main');
209 res.setHeader('HX-Reswap', 'innerHTML');
210 res.status(200);
211 } else {
212 res.status(403);
213 }
214 return renderPage(req, res, 'pages/viewer-blocked', {
215 pageTitle: 'Kijker-modus',
216 bodyClass: 'on-special',
217 });
218 }
219 next();
220});
221
222app.use('/auth', authRoutes);
223app.use('/account', accountRoutes);
224app.use('/admin/audio', adminAudioRoutes);
225app.use('/admin/playlists', adminPlaylistsRoutes);
226app.use('/admin/sites', adminSitesRoutes);
227app.use('/admin/users', adminUsersRoutes);
228app.use('/admin/comments', adminCommentsRoutes);
229app.use('/admin/settings', adminSettingsRoutes);
230app.use('/admin/circle', adminCircleRoutes);
231app.use('/admin/updates', adminUpdatesRoutes);
232app.use('/admin', adminRoutes);
233app.use('/prutter', prutterRoutes);
234app.use('/audio', audioRoutes);
235app.use('/search', searchRoutes);
236app.use('/comments', commentsRoutes);
237app.use('/tag', tagsRoutes);
238app.use('/type', typesRoutes);
239app.use('/users', usersRoutes);
240// Feed/sitemap routes are mounted at root because they're at well-known paths
241app.use('/', feedRoutes);
242app.use('/leden', artistsRoutes); // doorzoekbare leden-directory (alleen hub; solo: next())
243app.get('/artiesten', (req, res) => res.redirect(301, req.originalUrl.replace(/^\/artiesten/, '/leden'))); // oude URL -> /leden
244app.use('/', hubRoutes); // hub-overview op '/' (solo: next() -> postsRoutes)
245app.use('/', circleRoutes); // /cirkel-feed (solo/hub: next() -> postsRoutes)
246app.use('/', postsRoutes);
247
248app.get('/manifest.webmanifest', (req, res) => {
249 const site = res.locals.site;
250
251 // PWA scope: confines installed apps to ONE site. If a user is in the
252 // bedrijf1 PWA and clicks a link to /sites/bedrijf2/..., the browser will
253 // open it in a regular tab (out-of-scope) instead of within the PWA.
254 // Same applies to APK packaging — the WebView is locked to this scope.
255 //
256 // For path-mounted sites: scope = /sites/<slug>/
257 // For root/subdomain sites: scope = /
258 const base = res.locals.siteUrlBase || ''; // '' or '/sites/<slug>'
259 const scope = (base || '') + '/';
260 const startUrl = (base || '') + '/?source=pwa';
261
262 // A stable identity per site so installs don't collide (Chromium uses `id`)
263 const idBase = site?.slug ? `prutfolio-${site.slug}` : 'prutfolio';
264
265 res.set('Cache-Control', 'no-cache');
266 res.json({
267 id: idBase,
268 name: site?.title || 'Klonkt Hub Beta',
269 short_name: (site?.title || 'Klonkt').slice(0, 12),
270 description: site?.description || site?.tagline || '',
271 scope,
272 start_url: startUrl,
273 display: 'standalone',
274 display_override: ['standalone', 'minimal-ui'],
275 orientation: 'any',
276 background_color: '#1a1a17',
277 theme_color: site?.accent || '#c2410c',
278 lang: site?.language || 'nl',
279 icons: [
280 { src: '/favicon.svg', sizes: 'any', type: 'image/svg+xml' },
281 { src: '/favicon.ico', sizes: '64x64', type: 'image/x-icon' },
282 ],
283 // Hint to capable browsers: capture all in-scope links inside the PWA
284 capture_links: 'existing-client-navigate',
285 });
286});
287
288// Favicon — served as SVG so it picks up the site's accent color dynamically.
289// Browsers also request /favicon.ico by convention; we serve the same SVG
290// content there with a forgiving content-type since modern browsers accept it.
291function _renderFavicon(res, accent) {
292 const safeAccent = /^#[0-9a-fA-F]{3,8}$/.test(accent) ? accent : '#c2410c';
293 // Site mark: rounded square in the site accent + bold white 'K' (Klonkt)
294 const svg = `<?xml version="1.0" encoding="UTF-8"?>
295<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64">
296 <rect width="64" height="64" rx="14" fill="${safeAccent}"/>
297 <text x="50%" y="50%" dy="0.35em" text-anchor="middle"
298 font-family="Arial, Helvetica, sans-serif"
299 font-size="42" font-weight="800" fill="#fff">K</text>
300</svg>`;
301 res.set('Content-Type', 'image/svg+xml');
302 res.set('Cache-Control', 'public, max-age=86400');
303 res.send(svg);
304}
305
306app.get('/favicon.svg', (req, res) => {
307 _renderFavicon(res, res.locals.site?.accent);
308});
309app.get('/favicon.ico', (req, res) => {
310 // Browsers requesting .ico will accept SVG content; chrome/firefox both fine.
311 // Keeping the route prevents 404 spam in the console.
312 _renderFavicon(res, res.locals.site?.accent);
313});
314
315app.get('/sw.js', (req, res) => {
316 res.set('Content-Type', 'application/javascript');
317 res.set('Cache-Control', 'no-cache');
318 res.send(`
319const CACHE_VERSION = 'pcms-v10-' + new Date().toISOString().split('T')[0];
320self.addEventListener('install', e => {
321 e.waitUntil(caches.open(CACHE_VERSION).then(c => c.addAll(['/'])));
322 self.skipWaiting();
323});
324self.addEventListener('activate', e => {
325 e.waitUntil(caches.keys().then(keys => Promise.all(
326 keys.filter(k => k !== CACHE_VERSION).map(k => caches.delete(k))
327 )));
328 self.clients.claim();
329});
330self.addEventListener('fetch', e => {
331 if (e.request.method !== 'GET') return;
332 e.respondWith(fetch(e.request).catch(() => caches.match(e.request)));
333});
334 `);
335});
336
337process.on('unhandledRejection', (reason) => {
338 console.error('⚠️ Unhandled Rejection:', reason);
339});
340
341app.use((err, req, res, next) => {
342 console.error('❌ Error:', err);
343 res.status(err.status || 500).send(
344 isDev ? `<pre>${err.stack || err.message}</pre>` : 'Internal Server Error'
345 );
346});
347
348app.use((req, res) => {
349 res.status(404).send(`
350 <div style="font-family:system-ui;max-width:500px;margin:4rem auto;text-align:center;padding:2rem;">
351 <h1 style="font-size:5rem;margin:0;color:#c33;">404</h1>
352 <p>Not found</p>
353 <a href="/" style="color:#c2410c;">← Home</a>
354 </div>
355 `);
356});
357
358// ==================== WebSocket: Prutter real-time ====================
359// Authenticate via the existing session cookie. We reuse sessionMiddleware
360// during the HTTP upgrade so req.session is populated; if no user, abort.
361const wss = new WebSocketServer({ noServer: true });
362
363server.on('upgrade', (req, socket, head) => {
364 if (req.url !== '/ws/prutter') {
365 socket.destroy();
366 return;
367 }
368 // Run session middleware on the upgrade request.
369 // (Express's middleware accepts (req, res, next); we pass a stub res.)
370 const stubRes = { setHeader: () => {}, getHeader: () => undefined, on: () => {}, end: () => {} };
371 sessionMiddleware(req, stubRes, () => {
372 if (!req.session?.user) {
373 socket.write('HTTP/1.1 401 Unauthorized\r\n\r\n');
374 socket.destroy();
375 return;
376 }
377 // Kijker-accounts zijn alleen-lezen: weiger de WS-upgrade. De HTTP-guard
378 // dekt geen WS, dus dit is de plek om schrijven via een (toekomstige)
379 // message-handler te voorkomen.
380 if (isViewer(req.session.user)) {
381 socket.write('HTTP/1.1 403 Forbidden\r\n\r\n');
382 socket.destroy();
383 return;
384 }
385 wss.handleUpgrade(req, socket, head, (ws) => {
386 ws.userId = req.session.user.id;
387 wss.emit('connection', ws, req);
388 });
389 });
390});
391
392wss.on('connection', (ws) => {
393 prutter.addConnection(ws.userId, ws);
394 ws.on('close', () => prutter.removeConnection(ws.userId, ws));
395 ws.on('error', () => prutter.removeConnection(ws.userId, ws));
396 // Optional: ping every 30s to keep connections alive through proxies
397 ws.isAlive = true;
398 ws.on('pong', () => { ws.isAlive = true; });
399});
400const wsPing = setInterval(() => {
401 for (const ws of wss.clients) {
402 if (ws.isAlive === false) { ws.terminate(); continue; }
403 ws.isAlive = false;
404 try { ws.ping(); } catch {}
405 }
406}, 30000);
407if (wsPing.unref) wsPing.unref();
408
409server.listen(PORT, () => {
410 console.log('');
411 console.log('🪶 Klonkt Hub Beta');
412 console.log(` http://localhost:${PORT}`);
413 console.log('');
414 console.log(` ✓ Security: Helmet, CSP, secure sessions`);
415 console.log(` ✓ Privacy: Self-hosted fonts, no third-party requests`);
416 console.log(` ✓ Layout: v9 editorial feel (top nav, profile header)`);
417 console.log(` ✓ Auth: wachtwoord (beheer) + Google (luisteraars) / logout`);
418 console.log(` ✓ Posts: create / edit / view / archive`);
419 console.log(` ✓ Realtime: WebSocket server ready (Prutter)`);
420 console.log('');
421 console.log(` Mode: ${isDev ? 'development' : 'PRODUCTION'}`);
422 console.log('');
423});
424
425export default app;
Note: See TracBrowser for help on using the repository browser.