flask-session-auth.md 2.52 KB

Flask Session Auth Pattern

Minimal login system for Flask apps exposed via Cloudflare Tunnel.

Database (SQLite)

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', '<sha256 hash>');

Store SHA-256 hash of password, not plaintext.

Flask App

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.