Pre-launch — Gluecron is in final validation. Public signups and git hosting for non-owner users open after launch review.
CodeIssuesDiscussionsWikiPull RequestsProjectsCommitsActionsReleasesContributorsPulse● GatesSecuritySettingsDeploymentsPipelineInsightsAgents✨ Explain✨ Ask AI✨ Workspace✨ Spec✨ Tests▓ Debt Map✨ NL Search🏛 Archaeology
claude/adoring-hopper-5x74bqclaude/affectionate-feynman-ykrf1hclaude/architecture-audit-design-wxprenclaude/build-status-update-3MXsfclaude/charming-meitner-mllb5rclaude/compare-gate-gluecron-s4mFQclaude/confident-faraday-tikcwbclaude/continue-work-XMTlIclaude/crontech-gluecron-deploy-7MIECclaude/crontech-platform-setup-SeKfwclaude/design-2026claude/ecstatic-ptolemy-jMdigclaude/enhance-github-integration-QNHdGclaude/fix-aa-loop-issue-PonMQclaude/fix-actions-and-processclaude/fix-desktop-errors-XqoW8claude/fix-red-workflowsclaude/fix-website-access-6FKJNclaude/gatetest-integration-hardeningclaude/github-audit-improvements-bDFr9claude/gluecron-launch-status-FoMRlclaude/hopeful-lamport-olfCTclaude/issue-to-pr-and-protectionsclaude/jolly-heisenberg-2sg1Qclaude/launch-preparation-QmTb6claude/new-session-xk1l7claude/plan-platform-architecture-kkN4yclaude/platform-analysis-roadmap-1nUGLclaude/platform-launch-assessment-8dWV8claude/polish-platform-release-AeDrUclaude/resume-previous-work-KzyLwclaude/review-crontech-handoff-qYEVqclaude/review-project-completeness-lHhS2claude/review-readme-docs-ulqPKclaude/serene-edison-rj87weclaude/setup-multi-repo-dev-BCwNQclaude/ship-fixes-and-tests-Jvz1cclaude/site-audit-competitive-pctlwgclaude/site-migration-vercel-XstpKclaude/standalone-product-repos-XHFTDcopilot/feat-smart-empty-states-keyboard-first-enhancementcopilot/feat-smart-morning-digest-review-context-restorecopilot/fix-and-process-workflowscopilot/update-ai-powered-code-reviewfeat/debt-mapfeat/push-policy-codeowners-hardeningfeat/smart-digest-contextfeat/stage-impactfeat/t1-secret-migrationfeat/u-polishfeat/w-self-hostfeat/w2-claude-configfix/agent-journey-orphan-sweepgatetest/auto-fix-1776586424172gatetest/auto-fix-1776586534814gatetest/auto-fix-1776590685143gatetest/auto-fix-1776590808199mainops/redeploy-retriggerstyle/dxt-cta-themeworktree-agent-a3377aad30d55da26worktree-agent-a7ef607b7ee1d6c74
sso.ts13.1 KB · 453 lines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
/**
 * Block I10 — Enterprise SSO via OpenID Connect.
 *
 * We chose OIDC over SAML because every modern IdP (Okta, Azure AD, Auth0,
 * Google Workspace, Keycloak, Okta-on-prem) speaks OIDC natively, and OIDC
 * only requires HTTP JSON / redirect flows — no XML signature verification.
 *
 * Flow:
 *   1. User clicks "Sign in with SSO" → GET /login/sso
 *   2. We redirect to the IdP's `authorization_endpoint` with a `state` +
 *      `nonce` cookie-bound to the browser session.
 *   3. IdP sends the user back to /login/sso/callback?code=...&state=...
 *   4. We exchange the code for an access_token + id_token at
 *      `token_endpoint`, then hit `userinfo_endpoint` to fetch the claims.
 *   5. Find (or auto-create, if enabled) a local user by `sub`, create a
 *      session cookie, and redirect home.
 *
 * Admin configures the provider at /admin/sso. There is a single site-wide
 * provider identified by `id = 'default'`; we don't do multi-tenant IdP.
 */

import { eq } from "drizzle-orm";
import { db } from "../db";
import {
  ssoConfig,
  ssoUserLinks,
  users,
  sessions,
  type SsoConfig,
  type SsoUserLink,
  type User,
} from "../db/schema";
import {
  generateSessionToken,
  sessionExpiry,
} from "./auth";
import { config } from "./config";

// ----------------------------------------------------------------------------
// Types
// ----------------------------------------------------------------------------

export interface SsoConfigInput {
  enabled: boolean;
  providerName: string;
  issuer: string;
  authorizationEndpoint: string;
  tokenEndpoint: string;
  userinfoEndpoint: string;
  clientId: string;
  clientSecret: string;
  scopes: string;
  allowedEmailDomains: string | null;
  autoCreateUsers: boolean;
}

export interface OidcClaims {
  sub: string;
  email?: string;
  email_verified?: boolean;
  name?: string;
  preferred_username?: string;
  given_name?: string;
  family_name?: string;
}

export interface TokenResponse {
  access_token: string;
  id_token?: string;
  token_type?: string;
  expires_in?: number;
  refresh_token?: string;
  scope?: string;
}

// ----------------------------------------------------------------------------
// Config CRUD
// ----------------------------------------------------------------------------

const SSO_CONFIG_ID = "default";

/** Returns the singleton SSO config, or null if never configured. */
export async function getSsoConfig(): Promise<SsoConfig | null> {
  try {
    const [row] = await db
      .select()
      .from(ssoConfig)
      .where(eq(ssoConfig.id, SSO_CONFIG_ID))
      .limit(1);
    return row || null;
  } catch {
    return null;
  }
}

/** Upsert config. Empty strings become nulls so partial configs are visible. */
export async function upsertSsoConfig(
  input: Partial<SsoConfigInput>
): Promise<{ ok: true } | { ok: false; error: string }> {
  try {
    const now = new Date();
    const values = {
      id: SSO_CONFIG_ID,
      enabled: !!input.enabled,
      providerName: (input.providerName || "SSO").slice(0, 120),
      issuer: emptyToNull(input.issuer),
      authorizationEndpoint: emptyToNull(input.authorizationEndpoint),
      tokenEndpoint: emptyToNull(input.tokenEndpoint),
      userinfoEndpoint: emptyToNull(input.userinfoEndpoint),
      clientId: emptyToNull(input.clientId),
      clientSecret: emptyToNull(input.clientSecret),
      scopes: (input.scopes || "openid profile email").slice(0, 256),
      allowedEmailDomains: emptyToNull(input.allowedEmailDomains),
      autoCreateUsers: input.autoCreateUsers !== false,
      updatedAt: now,
    };
    await db
      .insert(ssoConfig)
      .values(values)
      .onConflictDoUpdate({
        target: ssoConfig.id,
        set: {
          enabled: values.enabled,
          providerName: values.providerName,
          issuer: values.issuer,
          authorizationEndpoint: values.authorizationEndpoint,
          tokenEndpoint: values.tokenEndpoint,
          userinfoEndpoint: values.userinfoEndpoint,
          clientId: values.clientId,
          clientSecret: values.clientSecret,
          scopes: values.scopes,
          allowedEmailDomains: values.allowedEmailDomains,
          autoCreateUsers: values.autoCreateUsers,
          updatedAt: values.updatedAt,
        },
      });
    return { ok: true };
  } catch (err) {
    return {
      ok: false,
      error: err instanceof Error ? err.message : "Failed to save config",
    };
  }
}

function emptyToNull(v: string | null | undefined): string | null {
  if (v == null) return null;
  const s = String(v).trim();
  return s.length === 0 ? null : s;
}

// ----------------------------------------------------------------------------
// OIDC flow helpers (pure, no DB)
// ----------------------------------------------------------------------------

/**
 * Build the authorization-endpoint URL the browser should be redirected to.
 * Adds client_id, redirect_uri, response_type=code, scope, state, nonce.
 */
export function buildAuthorizeUrl(
  cfg: Pick<SsoConfig, "authorizationEndpoint" | "clientId" | "scopes">,
  state: string,
  nonce: string,
  redirectUri: string
): string {
  if (!cfg.authorizationEndpoint || !cfg.clientId) {
    throw new Error("SSO config missing authorization_endpoint or client_id");
  }
  const u = new URL(cfg.authorizationEndpoint);
  u.searchParams.set("client_id", cfg.clientId);
  u.searchParams.set("redirect_uri", redirectUri);
  u.searchParams.set("response_type", "code");
  u.searchParams.set("scope", cfg.scopes || "openid profile email");
  u.searchParams.set("state", state);
  u.searchParams.set("nonce", nonce);
  return u.toString();
}

/** Crypto-random hex string for state + nonce + link-subject-collision retries. */
export function randomToken(bytes = 16): string {
  const arr = crypto.getRandomValues(new Uint8Array(bytes));
  return Array.from(arr)
    .map((b) => b.toString(16).padStart(2, "0"))
    .join("");
}

/**
 * Exchange the authorization code for tokens. IdP is trusted; we don't
 * verify the id_token signature here because we immediately turn around
 * and hit userinfo over HTTPS with the access_token, which has the same
 * integrity guarantee.
 */
export async function exchangeCode(
  cfg: Pick<SsoConfig, "tokenEndpoint" | "clientId" | "clientSecret">,
  code: string,
  redirectUri: string
): Promise<TokenResponse> {
  if (!cfg.tokenEndpoint || !cfg.clientId || !cfg.clientSecret) {
    throw new Error("SSO config missing token_endpoint or client credentials");
  }
  const body = new URLSearchParams({
    grant_type: "authorization_code",
    code,
    redirect_uri: redirectUri,
    client_id: cfg.clientId,
    client_secret: cfg.clientSecret,
  });
  const res = await fetch(cfg.tokenEndpoint, {
    method: "POST",
    headers: {
      "content-type": "application/x-www-form-urlencoded",
      accept: "application/json",
    },
    body: body.toString(),
  });
  if (!res.ok) {
    const text = await res.text().catch(() => "");
    throw new Error(
      `token_endpoint ${res.status}: ${text.slice(0, 200) || "no body"}`
    );
  }
  const json = (await res.json()) as TokenResponse;
  if (!json.access_token) {
    throw new Error("token_endpoint response missing access_token");
  }
  return json;
}

/** Fetch userinfo claims using the access_token. */
export async function fetchUserinfo(
  cfg: Pick<SsoConfig, "userinfoEndpoint">,
  accessToken: string
): Promise<OidcClaims> {
  if (!cfg.userinfoEndpoint) {
    throw new Error("SSO config missing userinfo_endpoint");
  }
  const res = await fetch(cfg.userinfoEndpoint, {
    headers: {
      authorization: `Bearer ${accessToken}`,
      accept: "application/json",
    },
  });
  if (!res.ok) {
    const text = await res.text().catch(() => "");
    throw new Error(
      `userinfo_endpoint ${res.status}: ${text.slice(0, 200) || "no body"}`
    );
  }
  const claims = (await res.json()) as OidcClaims;
  if (!claims.sub) {
    throw new Error("userinfo response missing sub claim");
  }
  return claims;
}

/**
 * Check whether the given email is allowed by the admin's domain restriction.
 * `allowed` is a comma-separated list of domains (e.g. "example.com,acme.io").
 * null or empty = allow any.
 */
export function emailDomainAllowed(
  email: string | undefined | null,
  allowed: string | null | undefined
): boolean {
  if (!allowed || !allowed.trim()) return true;
  if (!email) return false;
  const domain = email.split("@")[1]?.toLowerCase().trim();
  if (!domain) return false;
  const list = allowed
    .split(",")
    .map((d) => d.trim().toLowerCase())
    .filter(Boolean);
  return list.includes(domain);
}

// ----------------------------------------------------------------------------
// User linkage + provisioning
// ----------------------------------------------------------------------------

export async function findSsoLinkBySubject(
  subject: string
): Promise<SsoUserLink | null> {
  try {
    const [row] = await db
      .select()
      .from(ssoUserLinks)
      .where(eq(ssoUserLinks.subject, subject))
      .limit(1);
    return row || null;
  } catch {
    return null;
  }
}

/**
 * Given OIDC claims, find the linked local user, or auto-create one when
 * the admin has enabled `autoCreateUsers`. Returns the User row, or null if
 * no match and auto-creation is off.
 *
 * This also creates an `sso_user_links` row on first sign-in so subsequent
 * logins short-circuit on the `sub` lookup.
 */
export async function findOrCreateUserFromSso(
  claims: OidcClaims,
  cfg: SsoConfig
): Promise<
  | { ok: true; user: User }
  | { ok: false; error: string }
> {
  // 1. Existing link by subject
  const link = await findSsoLinkBySubject(claims.sub);
  if (link) {
    const [user] = await db
      .select()
      .from(users)
      .where(eq(users.id, link.userId))
      .limit(1);
    if (user) return { ok: true, user };
    // Orphaned link (user deleted) — drop it and fall through.
    await db
      .delete(ssoUserLinks)
      .where(eq(ssoUserLinks.subject, claims.sub))
      .catch(() => {});
  }

  // 2. Domain gate
  if (!emailDomainAllowed(claims.email, cfg.allowedEmailDomains)) {
    return {
      ok: false,
      error: "Your email domain is not permitted for SSO sign-in.",
    };
  }

  // 3. Match by email when present
  if (claims.email) {
    const [existing] = await db
      .select()
      .from(users)
      .where(eq(users.email, claims.email))
      .limit(1);
    if (existing) {
      await db
        .insert(ssoUserLinks)
        .values({
          userId: existing.id,
          subject: claims.sub,
          emailAtLink: claims.email,
        })
        .onConflictDoNothing();
      return { ok: true, user: existing };
    }
  }

  // 4. Auto-create
  if (!cfg.autoCreateUsers) {
    return {
      ok: false,
      error:
        "No matching account, and the administrator has disabled SSO account creation.",
    };
  }

  const email = claims.email;
  if (!email) {
    return {
      ok: false,
      error: "SSO provider did not return an email claim.",
    };
  }

  const username = await pickAvailableUsername(
    claims.preferred_username || claims.name || email.split("@")[0] || "user"
  );

  // SSO users don't have a local password — store a random unusable hash.
  // The login form requires a password match against bcrypt so random bytes
  // here mean the account is SSO-only unless they set a password later.
  const fakeHash = "sso-only:" + randomToken(32);

  const [user] = await db
    .insert(users)
    .values({
      username,
      email,
      passwordHash: fakeHash,
    })
    .returning();

  await db
    .insert(ssoUserLinks)
    .values({
      userId: user.id,
      subject: claims.sub,
      emailAtLink: email,
    })
    .onConflictDoNothing();

  return { ok: true, user };
}

/** Normalize an IdP-provided name into a valid gluecron username. */
export function normalizeUsername(raw: string): string {
  const base = raw
    .toLowerCase()
    .replace(/[^a-z0-9_-]+/g, "-")
    .replace(/^-+|-+$/g, "")
    .slice(0, 32);
  return base || "user";
}

/** Pick a username not already taken. Appends a random suffix on collision. */
async function pickAvailableUsername(raw: string): Promise<string> {
  const base = normalizeUsername(raw);
  for (let i = 0; i < 5; i++) {
    const candidate = i === 0 ? base : `${base}-${randomToken(3)}`;
    try {
      const [row] = await db
        .select({ id: users.id })
        .from(users)
        .where(eq(users.username, candidate))
        .limit(1);
      if (!row) return candidate;
    } catch {
      return `${base}-${randomToken(3)}`;
    }
  }
  return `${base}-${randomToken(4)}`;
}

/** Issue a session cookie token for a user. Caller sets the cookie. */
export async function issueSsoSession(userId: string): Promise<string> {
  const token = generateSessionToken();
  await db.insert(sessions).values({
    userId,
    token,
    expiresAt: sessionExpiry(),
  });
  return token;
}

/** Compute the fully-qualified OIDC redirect URI for this deployment. */
export function ssoRedirectUri(): string {
  return `${config.appBaseUrl}/login/sso/callback`;
}

// ----------------------------------------------------------------------------
// Test-only exports
// ----------------------------------------------------------------------------

export const __internal = {
  emptyToNull,
  normalizeUsername,
};