source: Klonkt/src/routes/auth.js@ 05a6ca0

main
Last change on this file since 05a6ca0 was 640b39c, checked in by roboburr <roboburr@…>, 3 months ago

auth: read-only view accounts (view everything, modify nothing)

New users.readonly column + readonly in the session. Global guard in server.js
blocks every state-modifying method (POST/PUT/PATCH/DELETE) for read-only
accounts -> no comments, saves, settings, nothing. GET remains free, so they
can view everything (including admin panels). Sticky "read-only demo" banner in
the shell when such an account is logged in.

Co-Authored-By: Claude <noreply@…>

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