# Flask Session Auth Pattern Minimal login system for Flask apps exposed via Cloudflare Tunnel. ## Database (SQLite) ```sql CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, password_hash TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now','localtime')) ); -- Default admin INSERT OR IGNORE INTO users (username, password_hash) VALUES ('admin', ''); ``` Store SHA-256 hash of password, not plaintext. ## Flask App ```python from flask import Flask, session, redirect, url_for, request, render_template import hashlib, os app = Flask(__name__) app.secret_key = os.urandom(24) # session encryption key AUTH_WHITELIST = {'/login', '/logout', '/static'} @app.before_request def check_auth(): if request.path in AUTH_WHITELIST or request.path.startswith('/static/'): return None if 'user_id' in session: return None return redirect(url_for('login_page', next=request.path)) @app.route('/login', methods=['GET', 'POST']) def login_page(): error = None if request.method == 'POST': username = request.form.get('username', '').strip() password = request.form.get('password', '').strip() if username and password: pw_hash = hashlib.sha256(password.encode()).hexdigest() row = db.execute( "SELECT id FROM users WHERE username=? AND password_hash=?", (username, pw_hash) ).fetchone() if row: session['user_id'] = row['id'] session['username'] = username return redirect(request.args.get('next', '/')) error = '用户名或密码错误' return render_template('login.html', error=error) @app.route('/logout') def logout(): session.clear() return redirect(url_for('login_page')) ``` ## Pitfalls - **`secret_key = os.urandom(24)`** means sessions are invalidated on every process restart. Acceptable for simple use; use a fixed key in env var for persistence. - **Client-side sessions** (Flask default): logout sets a new empty cookie, but old cookie tokens remain valid until they expire. Real security requires server-side session storage. - **API routes ARE protected** by `before_request` — unauthenticated API calls get 302 redirect to login. If you need public API endpoints, add them to `AUTH_WHITELIST`. - **Cloudflare Tunnel + auth**: Make sure the tunnel exposes the same Flask app (not a different unprotected service). Test with `curl` before going live.