| 1 | import express from 'express';
|
|---|
| 2 | import crypto from 'crypto';
|
|---|
| 3 | import bcrypt from 'bcryptjs';
|
|---|
| 4 | import { v4 as uuid } from 'uuid';
|
|---|
| 5 | import db from '../config/database.js';
|
|---|
| 6 | import { renderPage } from '../middleware/render.js';
|
|---|
| 7 | import { loginLimiter, registerLimiter } from '../middleware/rate-limit.js';
|
|---|
| 8 | import { safeNext } from '../middleware/auth.js';
|
|---|
| 9 | import { googleConfigured, authorizeUrl, exchangeCode, fetchUserinfo } from '../config/google.js';
|
|---|
| 10 | import { premiumUnlocked } from '../services/PatreonService.js';
|
|---|
| 11 |
|
|---|
| 12 | // Fan-login (luisteraars inloggen met Google om te reageren) is een premium-
|
|---|
| 13 | // feature: beschikbaar als Google is ingesteld ÉN de premium-laag ontgrendeld is
|
|---|
| 14 | // (premium uit = vrij; aan = Patreon vereist).
|
|---|
| 15 | function fanLoginReady() {
|
|---|
| 16 | return googleConfigured() && premiumUnlocked();
|
|---|
| 17 | }
|
|---|
| 18 | import { mailerConfigured, sendMail } from '../config/mailer.js';
|
|---|
| 19 |
|
|---|
| 20 | const router = express.Router();
|
|---|
| 21 |
|
|---|
| 22 | // Vaste dummy-hash: zo draait login altijd één bcrypt-vergelijking, ook als de
|
|---|
| 23 | // user niet bestaat of geen wachtwoord heeft — geen timing-oracle voor enumeratie.
|
|---|
| 24 | const DUMMY_HASH = bcrypt.hashSync('constant-time-login-guard', 10);
|
|---|
| 25 |
|
|---|
| 26 | // Canonieke basis-URL voor links in e-mails (reset). Uit headers bouwen is
|
|---|
| 27 | // spoofbaar (X-Forwarded-Host); een vaste config sluit dat uit.
|
|---|
| 28 | function publicBaseUrl(req) {
|
|---|
| 29 | const cfg = (process.env.PUBLIC_BASE_URL || '').replace(/\/$/, '');
|
|---|
| 30 | if (cfg) return cfg;
|
|---|
| 31 | // Fallback (dev): trust-proxy-gesaneerde protocol + Host-header (NIET de rauwe
|
|---|
| 32 | // X-Forwarded-Host).
|
|---|
| 33 | return `${req.protocol}://${req.get('host')}`;
|
|---|
| 34 | }
|
|---|
| 35 |
|
|---|
| 36 | function hashToken(raw) {
|
|---|
| 37 | return crypto.createHash('sha256').update(String(raw)).digest('hex');
|
|---|
| 38 | }
|
|---|
| 39 |
|
|---|
| 40 | // Eerste-keer-setup? Pas zolang er nog geen enkele gebruiker is mag /register een
|
|---|
| 41 | // beheerder aanmaken. Daarna is registratie dicht (luisteraars komen via Google).
|
|---|
| 42 | function isSetupMode() {
|
|---|
| 43 | return db.prepare('SELECT COUNT(*) AS c FROM users').get().c === 0;
|
|---|
| 44 | }
|
|---|
| 45 |
|
|---|
| 46 | // ==================== LOGIN (beheerder = wachtwoord) ====================
|
|---|
| 47 | router.get('/login', (req, res) => {
|
|---|
| 48 | const next = safeNext(req.query.next) || '';
|
|---|
| 49 | if (req.session.user) return res.redirect(next || '/');
|
|---|
| 50 | if (isSetupMode()) return res.redirect('/auth/register' + (next ? '?next=' + encodeURIComponent(next) : ''));
|
|---|
| 51 | renderPage(req, res, 'pages/auth-login', {
|
|---|
| 52 | pageTitle: 'Inloggen',
|
|---|
| 53 | bodyClass: 'on-special on-auth',
|
|---|
| 54 | error: null,
|
|---|
| 55 | success: req.query.success || null,
|
|---|
| 56 | username: '',
|
|---|
| 57 | googleReady: fanLoginReady(),
|
|---|
| 58 | next,
|
|---|
| 59 | });
|
|---|
| 60 | });
|
|---|
| 61 |
|
|---|
| 62 | router.post('/login', loginLimiter, (req, res) => {
|
|---|
| 63 | const { username, password } = req.body;
|
|---|
| 64 | const next = safeNext(req.body.next) || '';
|
|---|
| 65 |
|
|---|
| 66 | const renderErr = (error, status = 400) => {
|
|---|
| 67 | res.status(status);
|
|---|
| 68 | return renderPage(req, res, 'pages/auth-login', {
|
|---|
| 69 | pageTitle: 'Inloggen', bodyClass: 'on-special',
|
|---|
| 70 | error, success: null, username: username || '', googleReady: fanLoginReady(), next,
|
|---|
| 71 | });
|
|---|
| 72 | };
|
|---|
| 73 |
|
|---|
| 74 | if (!username || !password) return renderErr('Gebruikersnaam en wachtwoord vereist');
|
|---|
| 75 |
|
|---|
| 76 | const user = db.prepare('SELECT * FROM users WHERE username = ? OR email = ?').get(username, username);
|
|---|
| 77 | // Altijd één bcrypt-vergelijking (dummy als de user geen bruikbaar wachtwoord
|
|---|
| 78 | // heeft) zodat de responstijd niets over het bestaan van een account verraadt.
|
|---|
| 79 | const usable = !!(user && user.password_hash && user.password_hash !== '!google-oauth');
|
|---|
| 80 | const ok = bcrypt.compareSync(password, usable ? user.password_hash : DUMMY_HASH);
|
|---|
| 81 | if (!usable || !ok) return renderErr('Ongeldige inloggegevens', 401);
|
|---|
| 82 |
|
|---|
| 83 | req.session.user = {
|
|---|
| 84 | id: user.id, username: user.username, email: user.email, role: user.role,
|
|---|
| 85 | avatar_url: user.avatar_url, palette: user.palette, theme: user.theme,
|
|---|
| 86 | readonly: !!user.readonly,
|
|---|
| 87 | };
|
|---|
| 88 | res.redirect(next || '/');
|
|---|
| 89 | });
|
|---|
| 90 |
|
|---|
| 91 | // ==================== EERSTE-KEER-SETUP (beheerder aanmaken) ====================
|
|---|
| 92 | router.get('/register', (req, res) => {
|
|---|
| 93 | const next = safeNext(req.query.next) || '';
|
|---|
| 94 | if (req.session.user) return res.redirect(next || '/');
|
|---|
| 95 | // Geen publieke registratie: alleen de allereerste beheerder mag hier aangemaakt.
|
|---|
| 96 | if (!isSetupMode()) return res.redirect('/auth/login' + (next ? '?next=' + encodeURIComponent(next) : ''));
|
|---|
| 97 | renderPage(req, res, 'pages/auth-register', {
|
|---|
| 98 | pageTitle: 'Beheerder aanmaken', bodyClass: 'on-special',
|
|---|
| 99 | error: null, username: '', email: '', next,
|
|---|
| 100 | });
|
|---|
| 101 | });
|
|---|
| 102 |
|
|---|
| 103 | router.post('/register', registerLimiter, (req, res) => {
|
|---|
| 104 | const { username, email, password } = req.body;
|
|---|
| 105 | const next = safeNext(req.body.next) || '';
|
|---|
| 106 | const renderErr = (error) => renderPage(req, res, 'pages/auth-register', {
|
|---|
| 107 | pageTitle: 'Beheerder aanmaken', bodyClass: 'on-special',
|
|---|
| 108 | error, username: username || '', email: email || '', next,
|
|---|
| 109 | });
|
|---|
| 110 |
|
|---|
| 111 | // Hard gesloten zodra er een gebruiker is — voorkomt een tweede "admin" via deze route.
|
|---|
| 112 | if (!isSetupMode()) return res.redirect('/auth/login');
|
|---|
| 113 |
|
|---|
| 114 | if (!username || !email || !password) return renderErr('Alle velden zijn verplicht');
|
|---|
| 115 | if (!/^[a-z0-9_-]{3,32}$/i.test(username)) {
|
|---|
| 116 | return renderErr('Gebruikersnaam: 3-32 tekens, letters/cijfers/_/- alleen');
|
|---|
| 117 | }
|
|---|
| 118 | if (password.length < 8) return renderErr('Wachtwoord moet minstens 8 tekens zijn');
|
|---|
| 119 |
|
|---|
| 120 | const userId = uuid();
|
|---|
| 121 | const hash = bcrypt.hashSync(password, 10);
|
|---|
| 122 | // De allereerste gebruiker is de beheerder (god).
|
|---|
| 123 | db.prepare(`
|
|---|
| 124 | INSERT INTO users (id, username, email, password_hash, role, theme, palette)
|
|---|
| 125 | VALUES (?, ?, ?, ?, 'god', 'dark', 'sage')
|
|---|
| 126 | `).run(userId, username, email, hash);
|
|---|
| 127 |
|
|---|
| 128 | // Persoonlijke site auto-aanmaken (single-tenant-ombouw volgt later).
|
|---|
| 129 | if (!db.prepare('SELECT 1 FROM sites LIMIT 1').get()) {
|
|---|
| 130 | const siteId = uuid();
|
|---|
| 131 | db.prepare(`
|
|---|
| 132 | INSERT INTO sites (id, slug, title, description, owner_id, palette, accent, language)
|
|---|
| 133 | VALUES (?, ?, ?, ?, ?, 'sage', '#c2410c', 'nl')
|
|---|
| 134 | `).run(siteId, username.toLowerCase(), username + "'s Site", 'Welkom', userId);
|
|---|
| 135 | db.prepare(`INSERT INTO site_members (site_id, user_id, role) VALUES (?, ?, 'admin')`).run(siteId, userId);
|
|---|
| 136 | }
|
|---|
| 137 |
|
|---|
| 138 | req.session.user = { id: userId, username, email, role: 'god', palette: 'sage', theme: 'dark' };
|
|---|
| 139 | res.redirect(next || '/');
|
|---|
| 140 | });
|
|---|
| 141 |
|
|---|
| 142 | // ==================== WACHTWOORD VERGETEN (aanvraag) ====================
|
|---|
| 143 | router.get('/reset-request', (req, res) => {
|
|---|
| 144 | if (req.session.user) return res.redirect('/');
|
|---|
| 145 | renderPage(req, res, 'pages/auth-reset-request', {
|
|---|
| 146 | pageTitle: 'Wachtwoord resetten', bodyClass: 'on-special',
|
|---|
| 147 | error: null, sent: false, devResetUrl: null, mailer: mailerConfigured(),
|
|---|
| 148 | });
|
|---|
| 149 | });
|
|---|
| 150 |
|
|---|
| 151 | router.post('/reset-request', registerLimiter, async (req, res) => {
|
|---|
| 152 | const email = (req.body.email || '').trim().toLowerCase();
|
|---|
| 153 | let devResetUrl = null;
|
|---|
| 154 |
|
|---|
| 155 | if (email) {
|
|---|
| 156 | const user = db.prepare('SELECT id, email FROM users WHERE LOWER(email) = ?').get(email);
|
|---|
| 157 | if (user) {
|
|---|
| 158 | const token = crypto.randomBytes(32).toString('hex'); // ruw: gaat alleen de mail/link in
|
|---|
| 159 | const expires = new Date(Date.now() + 30 * 60 * 1000).toISOString(); // 30 min
|
|---|
| 160 | // Alleen de HASH opslaan: DB-leestoegang levert zo geen bruikbaar token op.
|
|---|
| 161 | db.prepare('UPDATE users SET reset_token = ?, reset_token_expires = ? WHERE id = ?')
|
|---|
| 162 | .run(hashToken(token), expires, user.id);
|
|---|
| 163 |
|
|---|
| 164 | const url = `${publicBaseUrl(req)}/auth/reset/${token}`;
|
|---|
| 165 |
|
|---|
| 166 | if (mailerConfigured()) {
|
|---|
| 167 | try {
|
|---|
| 168 | await sendMail({
|
|---|
| 169 | to: user.email,
|
|---|
| 170 | subject: 'Wachtwoord resetten',
|
|---|
| 171 | text: `Reset je wachtwoord via deze link (30 min geldig):\n\n${url}\n\nNiet aangevraagd? Negeer deze mail.`,
|
|---|
| 172 | html: `<p>Reset je wachtwoord via deze link (30 min geldig):</p><p><a href="${url}">${url}</a></p><p>Niet aangevraagd? Negeer deze mail.</p>`,
|
|---|
| 173 | });
|
|---|
| 174 | } catch (e) {
|
|---|
| 175 | console.error('[reset-request] mail faalde:', e.message);
|
|---|
| 176 | }
|
|---|
| 177 | } else if (process.env.NODE_ENV !== 'production') {
|
|---|
| 178 | // Dev zonder SMTP: link in log + op de pagina tonen.
|
|---|
| 179 | console.log(`[password-reset] ${user.email} -> ${url}`);
|
|---|
| 180 | devResetUrl = url;
|
|---|
| 181 | } else {
|
|---|
| 182 | // Productie zonder SMTP: NOOIT het token loggen. Verwijs naar de CLI break-glass.
|
|---|
| 183 | console.log(`[password-reset] aangevraagd voor ${user.email} (geen SMTP — gebruik 'npm run reset-admin')`);
|
|---|
| 184 | }
|
|---|
| 185 | }
|
|---|
| 186 | }
|
|---|
| 187 |
|
|---|
| 188 | // Anti-enumeratie: zelfde antwoord ongeacht of het adres bestaat.
|
|---|
| 189 | renderPage(req, res, 'pages/auth-reset-request', {
|
|---|
| 190 | pageTitle: 'Wachtwoord resetten', bodyClass: 'on-special',
|
|---|
| 191 | error: null, sent: true, devResetUrl, mailer: mailerConfigured(),
|
|---|
| 192 | });
|
|---|
| 193 | });
|
|---|
| 194 |
|
|---|
| 195 | // ==================== WACHTWOORD RESETTEN (toepassen) ====================
|
|---|
| 196 | router.get('/reset/:token', (req, res) => {
|
|---|
| 197 | const row = db.prepare(`
|
|---|
| 198 | SELECT id, username FROM users
|
|---|
| 199 | WHERE reset_token = ? AND reset_token_expires > datetime('now')
|
|---|
| 200 | `).get(hashToken(req.params.token));
|
|---|
| 201 | renderPage(req, res, 'pages/auth-reset', {
|
|---|
| 202 | pageTitle: 'Wachtwoord resetten', bodyClass: 'on-special',
|
|---|
| 203 | error: row ? null : 'Deze reset-link is ongeldig of verlopen.',
|
|---|
| 204 | token: row ? req.params.token : null,
|
|---|
| 205 | username: row ? row.username : null,
|
|---|
| 206 | });
|
|---|
| 207 | });
|
|---|
| 208 |
|
|---|
| 209 | router.post('/reset/:token', (req, res) => {
|
|---|
| 210 | const { new_password, confirm } = req.body;
|
|---|
| 211 | const row = db.prepare(`
|
|---|
| 212 | SELECT id, username FROM users
|
|---|
| 213 | WHERE reset_token = ? AND reset_token_expires > datetime('now')
|
|---|
| 214 | `).get(hashToken(req.params.token));
|
|---|
| 215 |
|
|---|
| 216 | const renderError = (msg) => renderPage(req, res, 'pages/auth-reset', {
|
|---|
| 217 | pageTitle: 'Wachtwoord resetten', bodyClass: 'on-special',
|
|---|
| 218 | error: msg, token: row ? req.params.token : null, username: row ? row.username : null,
|
|---|
| 219 | });
|
|---|
| 220 |
|
|---|
| 221 | if (!row) return renderError('Deze reset-link is ongeldig of verlopen.');
|
|---|
| 222 | if (!new_password || new_password.length < 8) return renderError('Wachtwoord moet minstens 8 tekens zijn');
|
|---|
| 223 | if (new_password !== confirm) return renderError('Wachtwoorden komen niet overeen');
|
|---|
| 224 |
|
|---|
| 225 | const hash = bcrypt.hashSync(new_password, 10);
|
|---|
| 226 | db.prepare(`
|
|---|
| 227 | UPDATE users SET password_hash = ?, reset_token = NULL, reset_token_expires = NULL,
|
|---|
| 228 | updated_at = CURRENT_TIMESTAMP WHERE id = ?
|
|---|
| 229 | `).run(hash, row.id);
|
|---|
| 230 | res.redirect('/auth/login?success=' + encodeURIComponent('Wachtwoord gereset — log nu in.'));
|
|---|
| 231 | });
|
|---|
| 232 |
|
|---|
| 233 | // ==================== GOOGLE-LOGIN (luisteraars/reageerders) ====================
|
|---|
| 234 | // Per-instance, eigen Google-client. Geeft ALTIJD rol member — nooit beheer.
|
|---|
| 235 | router.get('/google', (req, res) => {
|
|---|
| 236 | if (!fanLoginReady()) {
|
|---|
| 237 | return res.redirect('/auth/login?error=' + encodeURIComponent('Inloggen met Google is op deze site niet beschikbaar.'));
|
|---|
| 238 | }
|
|---|
| 239 | const state = crypto.randomBytes(16).toString('hex');
|
|---|
| 240 | req.session.oauthState = state;
|
|---|
| 241 | req.session.oauthNext = safeNext(req.query.next) || '';
|
|---|
| 242 | res.redirect(authorizeUrl(state));
|
|---|
| 243 | });
|
|---|
| 244 |
|
|---|
| 245 | function uniqueUsername(base) {
|
|---|
| 246 | let u = String(base || 'luisteraar').toLowerCase().replace(/[^a-z0-9_-]/g, '').slice(0, 28);
|
|---|
| 247 | if (u.length < 3) u = 'luisteraar';
|
|---|
| 248 | let candidate = u, n = 1;
|
|---|
| 249 | while (db.prepare('SELECT 1 FROM users WHERE username = ?').get(candidate)) {
|
|---|
| 250 | candidate = (u.slice(0, 26) + n).slice(0, 32);
|
|---|
| 251 | n++;
|
|---|
| 252 | }
|
|---|
| 253 | return candidate;
|
|---|
| 254 | }
|
|---|
| 255 |
|
|---|
| 256 | router.get('/google/callback', async (req, res) => {
|
|---|
| 257 | const fail = (msg) => res.redirect('/auth/login?error=' + encodeURIComponent(msg));
|
|---|
| 258 | if (!fanLoginReady()) return fail('Inloggen met Google is op deze site niet beschikbaar.');
|
|---|
| 259 | try {
|
|---|
| 260 | const { code, state } = req.query;
|
|---|
| 261 | if (!code || !state || state !== req.session.oauthState) return fail('Login afgebroken of ongeldige sessie.');
|
|---|
| 262 | const next = safeNext(req.session.oauthNext) || '';
|
|---|
| 263 | delete req.session.oauthState;
|
|---|
| 264 | delete req.session.oauthNext;
|
|---|
| 265 |
|
|---|
| 266 | const tok = await exchangeCode(String(code));
|
|---|
| 267 | const info = await fetchUserinfo(tok.access_token);
|
|---|
| 268 | const email = (info.email || '').trim().toLowerCase();
|
|---|
| 269 | if (!email || info.email_verified === false) return fail('Geen geverifieerd Google-e-mailadres.');
|
|---|
| 270 |
|
|---|
| 271 | let user = db.prepare('SELECT * FROM users WHERE LOWER(email) = ?').get(email);
|
|---|
| 272 |
|
|---|
| 273 | if (user) {
|
|---|
| 274 | // Strikte scheiding: Google geeft nooit beheer. Hoort dit adres bij een
|
|---|
| 275 | // beheerder, dan moet diegene met wachtwoord inloggen (geen Google-bypass).
|
|---|
| 276 | if (user.role === 'god' || user.role === 'admin') {
|
|---|
| 277 | return fail('Dit adres hoort bij een beheerder — log in met je wachtwoord.');
|
|---|
| 278 | }
|
|---|
| 279 | // Bestaande luisteraar: koppel google_sub/avatar als die ontbreken; weiger
|
|---|
| 280 | // als al aan een ander Google-account gekoppeld.
|
|---|
| 281 | if (user.google_sub && info.sub && user.google_sub !== info.sub) {
|
|---|
| 282 | return fail('Dit e-mailadres is al aan een ander Google-account gekoppeld.');
|
|---|
| 283 | }
|
|---|
| 284 | db.prepare(`
|
|---|
| 285 | UPDATE users SET google_sub = COALESCE(google_sub, ?), avatar_url = COALESCE(avatar_url, ?),
|
|---|
| 286 | updated_at = CURRENT_TIMESTAMP WHERE id = ?
|
|---|
| 287 | `).run(info.sub || null, info.picture || null, user.id);
|
|---|
| 288 | } else {
|
|---|
| 289 | // Nieuwe luisteraar — altijd member.
|
|---|
| 290 | const userId = uuid();
|
|---|
| 291 | const username = uniqueUsername(info.name || email.split('@')[0]);
|
|---|
| 292 | db.prepare(`
|
|---|
| 293 | INSERT INTO users (id, username, email, password_hash, role, avatar_url, theme, palette, google_sub)
|
|---|
| 294 | VALUES (?, ?, ?, '!google-oauth', 'member', ?, 'dark', 'sage', ?)
|
|---|
| 295 | `).run(userId, username, info.email || email, info.picture || null, info.sub || null);
|
|---|
| 296 | user = db.prepare('SELECT * FROM users WHERE id = ?').get(userId);
|
|---|
| 297 | }
|
|---|
| 298 |
|
|---|
| 299 | req.session.user = {
|
|---|
| 300 | id: user.id, username: user.username, email: user.email, role: user.role,
|
|---|
| 301 | avatar_url: user.avatar_url, palette: user.palette, theme: user.theme,
|
|---|
| 302 | readonly: !!user.readonly,
|
|---|
| 303 | };
|
|---|
| 304 | res.redirect(next || '/');
|
|---|
| 305 | } catch (e) {
|
|---|
| 306 | console.error('[auth/google/callback]', e.message);
|
|---|
| 307 | fail('Google-login mislukt. Probeer opnieuw.');
|
|---|
| 308 | }
|
|---|
| 309 | });
|
|---|
| 310 |
|
|---|
| 311 | // ==================== LOGOUT ====================
|
|---|
| 312 | router.get('/logout', (req, res) => { req.session.destroy(() => res.redirect('/')); });
|
|---|
| 313 | router.post('/logout', (req, res) => { req.session.destroy(() => res.redirect('/')); });
|
|---|
| 314 |
|
|---|
| 315 | export default router;
|
|---|