Skip to content
1,038 linesCodeBlameRaw
1//! The identity service: accounts, sessions, SSH keys and access tokens.
2//!
3//! Reached only through service bindings; see `g1t_contracts::identity` for
4//! the methods and their arguments.
5
6mod access;
7mod admin;
8mod aliases;
9mod avatars;
10mod crypto;
11mod deletion;
12mod device;
13mod directory;
14mod email;
15mod emails;
16mod github;
17mod invites;
18mod members;
19mod oauth;
20mod paid;
21mod profiles;
22mod rename;
23mod run_credentials;
24mod security;
25mod teams;
26mod throttle;
27mod tokens;
28mod two_factor;
29mod workspaces;
30
31use g1t_contracts::identity::*;
32use g1t_contracts::time::{SQL_NOW, rfc3339, sql_after};
33use g1t_contracts::{FailureCode, Outcome, User, Viewer, claimable_namespace, new_id};
34use g1t_kit::{args, now_ms, reply, rpc_method};
35use serde::Deserialize;
36use tokens::TOKEN_PREFIX;
37use worker::wasm_bindgen::JsValue;
38use worker::{Context, D1Database, Env, Request, Response, Result, ScheduleContext, ScheduledEvent, event};
39
40const SESSION_TTL_SECONDS: u64 = 30 * 24 * 60 * 60;
41const VERIFY_TTL_SECONDS: u64 = 24 * 60 * 60;
42const RESET_TTL_SECONDS: u64 = 60 * 60;
43const MIN_PASSWORD_LENGTH: usize = 10;
44const PASSWORD_TOO_SHORT: &str = "Use a password of at least 10 characters.";
45
46/// A user as selected from the database; `verified` arrives as 0 or 1.
47#[derive(Deserialize)]
48struct Account {
49 id: String,
50 username: String,
51 verified: u8,
52 /// Selected only where the person is being shown to themselves.
53 #[serde(default)]
54 avatar: Option<String>,
55}
56
57impl From<Account> for User {
58 fn from(row: Account) -> Self {
59 User {
60 id: row.id,
61 username: row.username,
62 verified: row.verified != 0,
63 avatar: row.avatar,
64 ..User::default()
65 }
66 }
67}
68
69#[derive(Deserialize)]
70struct UserRow {
71 id: String,
72 username: String,
73 password_hash: String,
74 verified: u8,
75}
76
77/// The owner of an emailed token.
78#[derive(Deserialize)]
79struct TokenOwner {
80 id: String,
81 username: String,
82 /// The address a link was sent to; null on links from before accounts
83 /// had several, which are for the primary.
84 #[serde(default)]
85 email_id: Option<String>,
86}
87
88#[derive(Deserialize)]
89struct KeyRow {
90 id: String,
91 title: String,
92 fingerprint: String,
93 created_at: String,
94}
95
96impl From<KeyRow> for SshKey {
97 fn from(row: KeyRow) -> Self {
98 SshKey {
99 id: row.id,
100 title: row.title,
101 fingerprint: row.fingerprint,
102 created_at: row.created_at,
103 }
104 }
105}
106
107struct Identity {
108 db: D1Database,
109 env: Env,
110}
111
112impl Identity {
113 /// Runs a query that returns at most one user, for showing to others:
114 /// without their workspaces.
115 async fn find_public_user(&self, sql: &str, param: &str) -> Result<Viewer> {
116 Ok(self
117 .db
118 .prepare(sql)
119 .bind(&[JsValue::from(param)])?
120 .first::<Account>(None)
121 .await?
122 .map(User::from))
123 }
124
125 /// Attaches the workspaces a user belongs to, so that any service can
126 /// authorize them without asking again.
127 async fn with_workspaces(&self, user: Viewer) -> Result<Viewer> {
128 let Some(mut user) = user else {
129 return Ok(None);
130 };
131 let memberships = self.memberships_and_policies(&user.id).await?;
132 // Roles on single repositories, under the same policy (access.rs).
133 let grants = self.grants_of(&user.id).await?;
134 // Access to a workspace is used only within its policy; see security.rs.
135 let within = self.within_policy(&user.id, memberships, grants).await?;
136 user.workspaces = within.memberships;
137 user.grants = within.grants;
138 user.held = within.held;
139 Ok(Some(user))
140 }
141
142 /// Runs a query that resolves credentials to at most one user.
143 async fn find_user(&self, sql: &str, param: &str) -> Result<Viewer> {
144 let user = self.find_public_user(sql, param).await?;
145 self.with_workspaces(user).await
146 }
147
148 /// Stores a one-time token of `kind` for the user and returns it.
149 async fn issue_email_token(&self, user_id: &str, kind: &str, ttl: u64) -> Result<String> {
150 let token = crypto::random_hex(32);
151 self.db
152 .prepare(format!(
153 "INSERT INTO email_tokens (id, user_id, kind, expires_at)
154 VALUES (?, ?, ?, {})",
155 sql_after(ttl)
156 ))
157 .bind(&[
158 crypto::sha256_hex(&token).into(),
159 user_id.into(),
160 kind.into(),
161 ])?
162 .run()
163 .await?;
164 Ok(token)
165 }
166
167 /// Consumes a token of `kind`, returning its owner if it was valid.
168 async fn redeem_email_token(&self, token: &str, kind: &str) -> Result<Option<TokenOwner>> {
169 let id = crypto::sha256_hex(token);
170 let owner = self
171 .db
172 .prepare(format!(
173 "SELECT users.id, users.username, email_tokens.email_id FROM email_tokens
174 JOIN users ON users.id = email_tokens.user_id
175 WHERE email_tokens.id = ? AND email_tokens.kind = ?
176 AND email_tokens.expires_at > {SQL_NOW}"
177 ))
178 .bind(&[id.as_str().into(), kind.into()])?
179 .first::<TokenOwner>(None)
180 .await?;
181 if let Some(owner) = &owner {
182 // Every outstanding token of this kind dies with the one used:
183 // every reset link, and every confirmation link for the same
184 // address (another address's links still work).
185 self.db
186 .prepare(
187 "DELETE FROM email_tokens WHERE user_id = ?1 AND kind = ?2
188 AND (?2 = 'reset' OR email_id IS ?3)",
189 )
190 .bind(&[
191 owner.id.as_str().into(),
192 kind.into(),
193 owner.email_id.as_deref().map_or(JsValue::NULL, Into::into),
194 ])?
195 .run()
196 .await?;
197 }
198 Ok(owner)
199 }
200
201 async fn send_verification(&self, user: &User, email: &str) -> Result<()> {
202 let token = self
203 .issue_email_token(&user.id, "verify", VERIFY_TTL_SECONDS)
204 .await?;
205 email::send_verification(&self.env, email, &user.username, &token).await
206 }
207
208 async fn resend_verification(&self, a: UserArgs) -> Result<Outcome<bool>> {
209 if !self.allow(throttle::CONFIRM_ACCOUNT, &a.user.id).await? {
210 return Ok(Outcome::fail(FailureCode::Conflict, "Too many confirmation emails this hour. Check your inbox, or try again later."));
211 }
212 self.resend_primary(&a.user).await
213 }
214
215 async fn verify_email(&self, a: EmailTokenArgs) -> Result<Outcome<User>> {
216 let Some(owner) = self.redeem_email_token(&a.token, "verify").await? else {
217 return Ok(Outcome::fail(
218 FailureCode::Invalid,
219 "This confirmation link is not valid or has expired.",
220 ));
221 };
222 if let Outcome::Fail(failure) = self.confirm_address(&owner.id, owner.email_id.as_deref()).await? {
223 return Ok(Outcome::Fail(failure));
224 }
225 // Whether the account is confirmed: whether its primary is.
226 let verified = self
227 .find_public_user(
228 "SELECT id, username, email_verified_at IS NOT NULL AS verified FROM users WHERE id = ?",
229 &owner.id,
230 )
231 .await?
232 .is_some_and(|user| user.verified);
233 Ok(Outcome::Ok(User {
234 id: owner.id,
235 username: owner.username,
236 verified,
237 ..User::default()
238 }))
239 }
240
241 /// Any confirmed address of an account can ask for a reset; so can the
242 /// unconfirmed address a new account signed up with. See emails.rs.
243 async fn request_password_reset(&self, a: EmailArgs) -> Result<bool> {
244 let allowed = self.allow(throttle::RESET_EMAIL, &a.email).await?
245 && match a.client.as_deref() {
246 Some(client) => self.allow(throttle::RESET_CLIENT, client).await?,
247 None => true,
248 };
249 if allowed && let Some(target) = self.reset_target(&a.email).await? {
250 // A failure from here on happens only for a real account, so it
251 // is logged, never answered: the reply below stays the same.
252 if let Err(error) = self.send_reset(&target).await {
253 worker::console_error!("password reset for a known address failed: {error}");
254 }
255 }
256 // The same answer either way, so addresses cannot be probed.
257 Ok(true)
258 }
259
260 /// Saves a reset link for `target` and mails it, telling the account's
261 /// other addresses.
262 async fn send_reset(&self, target: &emails::ResetTarget) -> Result<()> {
263 {
264 let token = crypto::random_hex(32);
265 self.db
266 .prepare(format!(
267 "INSERT INTO email_tokens (id, user_id, kind, expires_at, email_id)
268 VALUES (?, ?, 'reset', {}, ?)",
269 sql_after(RESET_TTL_SECONDS)
270 ))
271 .bind(&[
272 crypto::sha256_hex(&token).into(),
273 target.user_id.as_str().into(),
274 target.email_id.as_str().into(),
275 ])?
276 .run()
277 .await?;
278 email::send_password_reset(&self.env, &target.display, &target.username, &token).await?;
279 // The primary and the backup hear of it when it went elsewhere.
280 let elsewhere = self.notice_recipients(&target.user_id, false).await?;
281 for address in elsewhere.iter().filter(|address| !address.eq_ignore_ascii_case(&target.display)) {
282 let change = format!("A password reset was asked for through {}", target.display);
283 if let Err(error) = email::send_security_notice(&self.env, address, &target.username, &change).await {
284 worker::console_error!("security notice failed: {error}");
285 }
286 }
287 }
288 Ok(())
289 }
290
291 async fn reset_password(&self, a: ResetPasswordArgs) -> Result<Outcome<User>> {
292 if a.password.chars().count() < MIN_PASSWORD_LENGTH {
293 return Ok(Outcome::fail(FailureCode::Invalid, PASSWORD_TOO_SHORT));
294 }
295 let Some(owner) = self.redeem_email_token(&a.token, "reset").await? else {
296 return Ok(Outcome::fail(
297 FailureCode::Invalid,
298 "This reset link is not valid or has expired.",
299 ));
300 };
301 self.db
302 .prepare("UPDATE users SET password_hash = ? WHERE id = ?")
303 .bind(&[
304 crypto::hash_password(&a.password).into(),
305 owner.id.as_str().into(),
306 ])?
307 .run()
308 .await?;
309 // Following an emailed link also proves the address it went to
310 // (unless another account confirmed it first).
311 let _ = self.confirm_address(&owner.id, owner.email_id.as_deref()).await?;
312 // Anyone signed in with the old password is signed out, and nobody
313 // stays locked out by the wrong guesses before it.
314 self.db
315 .prepare("DELETE FROM sessions WHERE user_id = ?")
316 .bind(&[owner.id.as_str().into()])?
317 .run()
318 .await?;
319 self.clear(&throttle::key(throttle::PASSWORD_ACCOUNT, &owner.id)).await?;
320 self.log_security(&owner.id, "password_changed", None, None).await;
321 self.tell_primary_and_backup(&owner.id, &owner.username, "Your password was changed").await;
322 let verified = self
323 .find_public_user(
324 "SELECT id, username, email_verified_at IS NOT NULL AS verified FROM users WHERE id = ?",
325 &owner.id,
326 )
327 .await?
328 .is_some_and(|user| user.verified);
329 Ok(Outcome::Ok(User {
330 id: owner.id,
331 username: owner.username,
332 verified,
333 ..User::default()
334 }))
335 }
336
337 /// The account a login names: a username, or any confirmed address.
338 async fn password_row(&self, login: &str) -> Result<Option<UserRow>> {
339 let login = login.trim().to_lowercase();
340 let (column, value) = if login.contains('@') {
341 match self.user_with_verified_email(&login).await? {
342 Some(id) => ("id", id),
343 None => return Ok(None),
344 }
345 } else {
346 ("username", login)
347 };
348 self.db
349 .prepare(format!(
350 "SELECT id, username, password_hash, email_verified_at IS NOT NULL AS verified FROM users WHERE {column} = ?"
351 ))
352 .bind(&[JsValue::from(value)])?
353 .first::<UserRow>(None)
354 .await
355 }
356
357 /// Checks a password for a login, throttled (see throttle.rs). The
358 /// refusal is one of two messages, the same for every account.
359 async fn checked_password(
360 &self,
361 login: &str,
362 password: &str,
363 client: Option<&str>,
364 ) -> Result<std::result::Result<User, &'static str>> {
365 let row = self.password_row(login).await?;
366 let subject = row.as_ref().map_or_else(|| login.trim().to_lowercase(), |row| row.id.clone());
367 let (account_key, client_key) = Identity::password_keys(&subject, client);
368 if self.password_locked(&account_key, client_key.as_deref()).await? {
369 return Ok(Err(throttle::THROTTLED));
370 }
371 let owner = row.as_ref().map(|row| (row.id.clone(), row.username.clone()));
372 match row.filter(|row| !row.password_hash.is_empty() && crypto::verify_password(password, &row.password_hash)) {
373 Some(row) => {
374 self.clear(&account_key).await?;
375 Ok(Ok(User {
376 id: row.id,
377 username: row.username,
378 verified: row.verified != 0,
379 ..User::default()
380 }))
381 }
382 None => {
383 let owner = owner.as_ref().map(|(id, name)| (id.as_str(), name.as_str()));
384 self.password_failed(&account_key, client_key.as_deref(), owner).await?;
385 Ok(Err("Incorrect username or password."))
386 }
387 }
388 }
389
390 /// Git over HTTPS with the account's password. With two-factor
391 /// authentication on, a password alone is never enough: use an access
392 /// token (two_factor.rs).
393 async fn user_for_password(&self, login: &str, password: &str) -> Result<Viewer> {
394 let user = self.checked_password(login, password, None).await?.ok();
395 if let Some(user) = &user
396 && self.two_factor_enabled(&user.id).await?
397 {
398 return Ok(None);
399 }
400 self.with_workspaces(user).await
401 }
402
403 async fn register(&self, a: RegisterArgs) -> Result<Outcome<SignedIn>> {
404 let username = a.username.trim().to_lowercase();
405 let claimable = claimable_namespace(&username).is_some();
406 let email = a.email.trim().to_lowercase();
407 let invalid = |message: &str| Ok(Outcome::fail(FailureCode::Invalid, message));
408 let invite_code = a.invite_code.as_deref().map(str::trim).filter(|code| !code.is_empty());
409 // The invite first: without one, nothing else on the form matters.
410 if self.invites_required() && invite_code.is_none() {
411 return Ok(Outcome::fail(FailureCode::Forbidden, invites::MISSING));
412 }
413 if !claimable {
414 return invalid(
415 "Usernames use lowercase letters, digits and single hyphens, up to 39 characters, and cannot be a reserved word.",
416 );
417 }
418 let well_formed_email = email
419 .split_once('@')
420 .is_some_and(|(local, domain)| !local.is_empty() && domain.contains('.'))
421 && !email.contains(char::is_whitespace);
422 if !well_formed_email {
423 return invalid("Enter a valid email address.");
424 }
425 if a.password.chars().count() < MIN_PASSWORD_LENGTH {
426 return invalid(PASSWORD_TOO_SHORT);
427 }
428 let taken = self
429 .db
430 // Usernames and workspaces share one namespace, so that a name
431 // means the same thing wherever it appears.
432 // An address is taken once an account has confirmed it; an
433 // unconfirmed one goes to whoever confirms it first (emails.rs).
434 .prepare(
435 "SELECT username FROM users WHERE username = ?
436 UNION ALL SELECT email FROM user_emails WHERE email = ? AND verified_at IS NOT NULL
437 UNION ALL SELECT slug FROM workspaces WHERE slug = ?",
438 )
439 .bind(&[
440 username.as_str().into(),
441 email.as_str().into(),
442 username.as_str().into(),
443 ])?
444 .first::<serde_json::Value>(None)
445 .await?;
446 // A renamed workspace's old slug stays reserved for it a while, and
447 // a deleted workspace's for good.
448 if taken.is_some() || self.slug_held(&username).await? || self.slug_deleted(&username).await? {
449 return Ok(Outcome::fail(
450 FailureCode::Conflict,
451 "That username or email is already registered.",
452 ));
453 }
454 let password_hash = crypto::hash_password(&a.password);
455 let user = match self
456 .create_account(invites::NewAccount {
457 username: &username,
458 email: &email,
459 password_hash: &password_hash,
460 verified: false,
461 invite_code,
462 client: a.client.as_deref(),
463 })
464 .await?
465 {
466 Outcome::Ok(user) => user,
467 Outcome::Fail(failure) => return Ok(Outcome::Fail(failure)),
468 };
469 // The account exists either way; the email can be sent again later.
470 // An invite sent to this address confirmed it already (invites.rs).
471 if !user.verified
472 && let Err(error) = self.send_verification(&user, &email).await
473 {
474 worker::console_error!("verification email failed: {error}");
475 }
476 self.start_session(user).await
477 }
478
479 async fn sign_in(&self, a: SignInArgs) -> Result<Outcome<SignedIn>> {
480 let user = match self.checked_password(&a.username, &a.password, a.client.as_deref()).await? {
481 Ok(user) => user,
482 Err(message) => return Ok(Outcome::fail(FailureCode::Unauthenticated, message)),
483 };
484 let user = self.with_workspaces(Some(user)).await?.unwrap_or_default();
485 self.start_session(user).await
486 }
487
488 /// Starts a session for someone who just proved their password (or
489 /// GitHub account). With two-factor authentication on, it starts none:
490 /// it returns a challenge for `two_factor_sign_in` (two_factor.rs).
491 async fn start_session(&self, user: User) -> Result<Outcome<SignedIn>> {
492 if self.two_factor_enabled(&user.id).await? {
493 let challenge = self.issue_challenge(&user.id).await?;
494 return Ok(Outcome::Ok(SignedIn {
495 user: User { workspaces: Vec::new(), grants: Vec::new(), held: Vec::new(), ..user },
496 session_token: String::new(),
497 two_factor_challenge: Some(challenge),
498 }));
499 }
500 self.session_for(user).await
501 }
502
503 /// A new session for `user`, who has proved who they are in full.
504 async fn session_for(&self, user: User) -> Result<Outcome<SignedIn>> {
505 let session_token = crypto::random_hex(32);
506 self.db
507 .prepare(format!(
508 // Signing in is proof it is the person: see security.rs.
509 "INSERT INTO sessions (id, user_id, expires_at, authenticated_at) VALUES (?, ?, {}, {SQL_NOW})",
510 sql_after(SESSION_TTL_SECONDS)
511 ))
512 .bind(&[
513 crypto::sha256_hex(&session_token).into(),
514 user.id.as_str().into(),
515 ])?
516 .run()
517 .await?;
518 Ok(Outcome::Ok(SignedIn {
519 user,
520 session_token,
521 two_factor_challenge: None,
522 }))
523 }
524
525 async fn sign_out(&self, a: SessionArgs) -> Result<()> {
526 self.db
527 .prepare("DELETE FROM sessions WHERE id = ?")
528 .bind(&[crypto::sha256_hex(&a.session_token).into()])?
529 .run()
530 .await?;
531 Ok(())
532 }
533
534 async fn user_for_session(&self, a: SessionArgs) -> Result<Viewer> {
535 self.find_user(
536 &format!(
537 "SELECT users.id, users.username, users.email_verified_at IS NOT NULL AS verified,
538 users.avatar
539 FROM sessions JOIN users ON users.id = sessions.user_id
540 WHERE sessions.id = ? AND sessions.expires_at > {SQL_NOW}"
541 ),
542 &crypto::sha256_hex(&a.session_token),
543 )
544 .await
545 }
546
547 async fn user_for_git_credentials(&self, a: GitCredentialsArgs) -> Result<Viewer> {
548 // Like GitHub, a token alone identifies its user.
549 if a.secret.starts_with(TOKEN_PREFIX) {
550 self.user_for_access_token(&a.secret).await
551 } else {
552 self.user_for_password(&a.username, &a.secret).await
553 }
554 }
555
556 async fn user_for_ssh_key(&self, a: FingerprintArgs) -> Result<Viewer> {
557 self.find_user(
558 "SELECT users.id, users.username, users.email_verified_at IS NOT NULL AS verified FROM ssh_keys
559 JOIN users ON users.id = ssh_keys.user_id
560 WHERE fingerprint = ?",
561 &a.fingerprint,
562 )
563 .await
564 }
565
566 async fn user_by_username(&self, a: UsernameArgs) -> Result<Viewer> {
567 self.find_public_user(
568 "SELECT id, username, email_verified_at IS NOT NULL AS verified FROM users WHERE username = ?",
569 &a.username.to_lowercase(),
570 )
571 .await
572 }
573
574 /// `notify_by_email`: an inbox item, emailed to the person it is for,
575 /// only at a confirmed address and only while they can still read the
576 /// repository it is about. Returns whether it was sent.
577 async fn notify_by_email(&self, a: g1t_contracts::inbox::NotifyByEmailArgs) -> Result<bool> {
578 #[derive(Deserialize)]
579 struct Address {
580 email: Option<String>,
581 }
582 let user = self
583 .find_user(
584 "SELECT id, username, email_verified_at IS NOT NULL AS verified FROM users WHERE username = ?",
585 &a.username.to_lowercase(),
586 )
587 .await?;
588 let Some(user) = user.filter(|user| user.verified) else {
589 return Ok(false);
590 };
591 let readable: Vec<g1t_contracts::repos::Repo> = g1t_kit::call(
592 &self.env.service("REPOS")?,
593 "readable",
594 &g1t_contracts::repos::ReadableArgs {
595 ids: vec![a.repo_id.clone()],
596 viewer: Some(user.clone()),
597 },
598 )
599 .await?;
600 if readable.is_empty() {
601 return Ok(false);
602 }
603 let address = self
604 .db
605 .prepare("SELECT email FROM users WHERE id = ?")
606 .bind(&[user.id.as_str().into()])?
607 .first::<Address>(None)
608 .await?
609 .and_then(|row| row.email)
610 .filter(|email| !email.trim().is_empty());
611 let Some(address) = address else {
612 return Ok(false);
613 };
614 email::send_notification(&self.env, &address, &a).await?;
615 Ok(true)
616 }
617
618 async fn usernames(&self, a: UsernamesArgs) -> Result<std::collections::HashMap<String, String>> {
619 #[derive(serde::Deserialize)]
620 struct Named {
621 id: String,
622 name: String,
623 }
624 let ids: Vec<String> = a.ids.into_iter().take(200).collect();
625 let mut names = std::collections::HashMap::new();
626 if ids.is_empty() {
627 return Ok(names);
628 }
629 let marks = vec!["?"; ids.len()].join(", ");
630 let bind: Vec<worker::wasm_bindgen::JsValue> = ids.iter().map(|id| id.as_str().into()).collect();
631 for sql in [
632 format!("SELECT id, username AS name FROM users WHERE id IN ({marks})"),
633 format!("SELECT id, slug AS name FROM workspaces WHERE id IN ({marks})"),
634 ] {
635 for row in self.db.prepare(sql).bind(&bind)?.all().await?.results::<Named>()? {
636 names.insert(row.id, row.name);
637 }
638 }
639 Ok(names)
640 }
641
642 /// `accounts`: the accounts behind these ids (at most 200), each with
643 /// its username and avatar, for lists that keep ids, such as who
644 /// starred a repository. Ids of no account are left out.
645 async fn accounts(&self, a: UsernamesArgs) -> Result<std::collections::HashMap<String, g1t_contracts::accounts::EmailOwner>> {
646 #[derive(serde::Deserialize)]
647 struct Row {
648 id: String,
649 username: String,
650 avatar: Option<String>,
651 }
652 let ids: Vec<String> = a.ids.into_iter().take(200).collect();
653 let mut found = std::collections::HashMap::new();
654 if ids.is_empty() {
655 return Ok(found);
656 }
657 let marks = vec!["?"; ids.len()].join(", ");
658 let bind: Vec<worker::wasm_bindgen::JsValue> = ids.iter().map(|id| id.as_str().into()).collect();
659 let rows = self
660 .db
661 .prepare(format!("SELECT id, username, avatar FROM users WHERE id IN ({marks})"))
662 .bind(&bind)?
663 .all()
664 .await?
665 .results::<Row>()?;
666 for row in rows {
667 found.insert(row.id.clone(), g1t_contracts::accounts::EmailOwner { id: row.id, username: row.username, avatar: row.avatar });
668 }
669 Ok(found)
670 }
671
672 async fn list_ssh_keys(&self, a: UserArgs) -> Result<Vec<SshKey>> {
673 let rows = self
674 .db
675 .prepare("SELECT id, title, fingerprint, created_at FROM ssh_keys WHERE user_id = ? ORDER BY id")
676 .bind(&[a.user.id.into()])?
677 .all()
678 .await?
679 .results::<KeyRow>()?;
680 Ok(rows.into_iter().map(SshKey::from).collect())
681 }
682
683 /// The account (user id) that registered each key, by fingerprint
684 /// (`SHA256:…`). At most 100; unknown keys are left out.
685 async fn ssh_key_owners(&self, a: SshKeyOwnersArgs) -> Result<std::collections::HashMap<String, String>> {
686 #[derive(serde::Deserialize)]
687 struct Row {
688 fingerprint: String,
689 user_id: String,
690 }
691 let fingerprints: Vec<&String> = a.fingerprints.iter().take(100).collect();
692 if fingerprints.is_empty() {
693 return Ok(std::collections::HashMap::new());
694 }
695 let marks = vec!["?"; fingerprints.len()].join(", ");
696 let binds: Vec<JsValue> = fingerprints.iter().map(|fingerprint| fingerprint.as_str().into()).collect();
697 Ok(self
698 .db
699 .prepare(format!("SELECT fingerprint, user_id FROM ssh_keys WHERE fingerprint IN ({marks})"))
700 .bind(&binds)?
701 .all()
702 .await?
703 .results::<Row>()?
704 .into_iter()
705 .map(|row| (row.fingerprint, row.user_id))
706 .collect())
707 }
708
709 async fn add_ssh_key(&self, a: AddSshKeyArgs) -> Result<Outcome<SshKey>> {
710 let Some(key) = crypto::parse_ssh_key(&a.public_key) else {
711 return Ok(Outcome::fail(
712 FailureCode::Invalid,
713 "That is not a valid OpenSSH public key.",
714 ));
715 };
716 let taken = self
717 .db
718 .prepare("SELECT id FROM ssh_keys WHERE fingerprint = ?")
719 .bind(&[key.fingerprint.as_str().into()])?
720 .first::<serde_json::Value>(None)
721 .await?;
722 if taken.is_some() {
723 return Ok(Outcome::fail(
724 FailureCode::Conflict,
725 "That key is already registered.",
726 ));
727 }
728 let now = now_ms();
729 let title = [a.title.trim(), key.comment.as_str(), "SSH key"]
730 .into_iter()
731 .find(|candidate| !candidate.is_empty())
732 .unwrap_or_default()
733 .to_owned();
734 let row = KeyRow {
735 id: new_id("key", now),
736 title,
737 fingerprint: key.fingerprint,
738 created_at: rfc3339(now),
739 };
740 self.db
741 .prepare(
742 "INSERT INTO ssh_keys (id, user_id, title, public_key, fingerprint, created_at)
743 VALUES (?, ?, ?, ?, ?, ?)",
744 )
745 .bind(&[
746 row.id.as_str().into(),
747 a.user.id.as_str().into(),
748 row.title.as_str().into(),
749 key.public_key.into(),
750 row.fingerprint.as_str().into(),
751 row.created_at.as_str().into(),
752 ])?
753 .run()
754 .await?;
755 let shown = format!("{} ({})", row.title, row.fingerprint);
756 self.log_security(&a.user.id, "ssh_key_added", Some(&shown), None).await;
757 self.audit_account(&a.user, "ssh_key.added", &format!("Added SSH key {shown}")).await;
758 Ok(Outcome::Ok(row.into()))
759 }
760
761 /// Deletes one of the person's SSH keys.
762 async fn remove_ssh_key(&self, a: RemoveArgs) -> Result<()> {
763 #[derive(Deserialize)]
764 struct Removed {
765 title: String,
766 fingerprint: String,
767 }
768 let removed = self
769 .db
770 .prepare("DELETE FROM ssh_keys WHERE id = ? AND user_id = ? RETURNING title, fingerprint")
771 .bind(&[a.id.as_str().into(), a.user.id.as_str().into()])?
772 .first::<Removed>(None)
773 .await?;
774 if let Some(removed) = removed {
775 let shown = format!("{} ({})", removed.title, removed.fingerprint);
776 self.log_security(&a.user.id, "ssh_key_removed", Some(&shown), None).await;
777 self.audit_account(&a.user, "ssh_key.removed", &format!("Removed SSH key {shown}")).await;
778 }
779 Ok(())
780 }
781}
782
783/// Every 15 minutes: staff hear about waitlist requests that arrived while
784/// the last summary's window was still open, so none waits on a later one;
785/// and deleted workspaces past their restore window are purged
786/// (deletion.rs).
787#[event(scheduled)]
788async fn scheduled(_event: ScheduledEvent, env: Env, _ctx: ScheduleContext) {
789 let Ok(db) = env.d1("DB") else { return };
790 let identity = Identity { db, env };
791 if let Err(error) = identity.notify_staff_of_requests().await {
792 worker::console_error!("waitlist summary: {error}");
793 }
794 if let Err(error) = identity.purge_due_workspaces().await {
795 worker::console_error!("workspace purge: {error}");
796 }
797 // Once: creators of repositories made before they got Admin (members.rs).
798 if let Err(error) = identity.backfill_creator_grants().await {
799 worker::console_error!("creator grants: {error}");
800 }
801}
802
803#[event(fetch)]
804async fn fetch(mut request: Request, env: Env, _ctx: Context) -> Result<Response> {
805 let Some(method) = rpc_method(&request) else {
806 return Response::error("Not found", 404);
807 };
808 // A replica near the caller when it asks for one (crates/kit/src/d1.rs).
809 let (db, served) = g1t_kit::d1::open(&env, "DB", &request)?;
810 let body: serde_json::Value = request.json().await?;
811 let identity = Identity { db, env };
812
813 let answered = match method.as_str() {
814 "register" => {
815 let outcome = identity.register(args(body)?).await?;
816 if let Outcome::Ok(signed_in) = &outcome {
817 identity.announce_user(&signed_in.user.username, Some(&signed_in.user.id)).await;
818 }
819 reply(&outcome)
820 }
821 "sign_in" => reply(&identity.sign_in(args(body)?).await?),
822 "create_workspace" => {
823 let outcome = identity.create_workspace(args(body)?).await?;
824 if let Outcome::Ok(workspace) = &outcome {
825 identity.announce_workspace(&workspace.id, &workspace.slug, None).await;
826 }
827 reply(&outcome)
828 }
829 "get_workspace" => reply(&identity.get_workspace(args(body)?).await?),
830 "list_members" => reply(&identity.list_members(args(body)?).await?),
831 "add_member" => reply(&identity.add_member(args(body)?).await?),
832 "remove_member" => reply(&identity.remove_member(args(body)?).await?),
833 // Owners, roles, leaving and member privileges; see members.rs.
834 "update_member" => reply(&identity.update_member(args(body)?).await?),
835 "transfer_ownership" => reply(&identity.transfer_ownership(args(body)?).await?),
836 "leave_workspace" => reply(&identity.leave_workspace(args(body)?).await?),
837 "set_member_privileges" => reply(&identity.set_member_privileges(args(body)?).await?),
838 "set_two_factor_requirement" => reply(&identity.set_two_factor_requirement(args(body)?).await?),
839 "grant_creator" => reply(&identity.grant_creator(args(body)?).await?),
840 "update_workspace" => {
841 let outcome = identity.update_workspace(args(body)?).await?;
842 if let Outcome::Ok(workspace) = &outcome {
843 identity.announce_workspace(&workspace.id, &workspace.slug, None).await;
844 }
845 reply(&outcome)
846 }
847 "rename_workspace" => reply(&identity.rename_workspace(args(body)?).await?),
848 "check_workspace_rename" => reply(&identity.check_workspace_rename(args(body)?).await?),
849 "resolve_slug" => reply(&identity.resolve_slug(args(body)?).await?),
850 "resolve_alias" => reply(&identity.resolve_alias(args(body)?).await?),
851 "check_workspace_deletion" => reply(&identity.check_workspace_deletion(args(body)?).await?),
852 "delete_workspace" => reply(&identity.delete_workspace(args(body)?).await?),
853 "transfer_repo_scopes" => reply(&identity.transfer_repo_scopes(args(body)?).await?),
854 "set_workspace_avatar" => {
855 let outcome = identity.set_workspace_avatar(args(body)?).await?;
856 if let Outcome::Ok(workspace) = &outcome {
857 identity.announce_workspace(&workspace.id, &workspace.slug, None).await;
858 }
859 reply(&outcome)
860 }
861 "set_user_avatar" => {
862 let a: SetUserAvatarArgs = args(body)?;
863 let (username, id) = (a.user.username.clone(), a.user.id.clone());
864 let outcome = identity.set_user_avatar(a).await?;
865 if matches!(outcome, Outcome::Ok(_)) {
866 identity.announce_user(&username, Some(&id)).await;
867 }
868 reply(&outcome)
869 }
870 "list_workspace_tokens" => reply(&identity.list_workspace_tokens(args(body)?).await?),
871 "create_workspace_token" => reply(&identity.create_workspace_token(args(body)?).await?),
872 "remove_workspace_token" => reply(&identity.remove_workspace_token(args(body)?).await?),
873 // Signing in with GitHub; see github.rs.
874 "github_enabled" => reply(&identity.github_enabled()),
875 "github_start" => reply(&identity.github_start(args(body)?).await?),
876 "github_finish" => reply(&identity.github_finish(args(body)?).await?),
877 "github_pending" => reply(&identity.github_pending(args(body)?).await?),
878 "github_sign_up" => reply(&identity.github_sign_up(args(body)?).await?),
879 "github_claim" => reply(&identity.github_claim(args(body)?).await?),
880 "github_account" => reply(&identity.github_account(args(body)?).await?),
881 "github_unlink" => reply(&identity.github_unlink(args(body)?).await?),
882 "github_user_token" => reply(&identity.github_user_token(args(body)?).await?),
883 "github_revoked" => reply(&identity.github_revoked(args(body)?).await?),
884 "github_usernames" => reply(&identity.github_usernames(args(body)?).await?),
885 "oauth_authorize" => reply(&identity.oauth_authorize(args(body)?).await?),
886 "oauth_exchange" => reply(&identity.oauth_exchange(args(body)?).await?),
887 "oauth_refresh" => reply(&identity.oauth_refresh(args(body)?).await?),
888 "list_oauth_grants" => reply(&identity.list_oauth_grants(args(body)?).await?),
889 "revoke_oauth_grant" => reply(&identity.revoke_oauth_grant(args(body)?).await?),
890 "update_oauth_grant" => reply(&identity.update_oauth_grant(args(body)?).await?),
891 "device_start" => reply(&identity.device_start(args(body)?).await?),
892 "device_lookup" => reply(&identity.device_lookup(args(body)?).await?),
893 "device_resolve" => reply(&identity.device_resolve(args(body)?).await?),
894 "device_claim" => reply(&identity.device_claim(args(body)?).await?),
895 "resend_verification" => reply(&identity.resend_verification(args(body)?).await?),
896 "verify_email" => reply(&identity.verify_email(args(body)?).await?),
897 "request_password_reset" => reply(&identity.request_password_reset(args(body)?).await?),
898 "reset_password" => reply(&identity.reset_password(args(body)?).await?),
899 // A person's email addresses; see emails.rs and security.rs.
900 "list_emails" => reply(&identity.list_emails(args(body)?).await?),
901 "add_email" => reply(&identity.add_email(args(body)?).await?),
902 "remove_email" => reply(&identity.remove_email(args(body)?).await?),
903 "resend_email_verification" => reply(&identity.resend_email_verification(args(body)?).await?),
904 "update_email_settings" => reply(&identity.update_email_settings(args(body)?).await?),
905 "reauthenticate" => reply(&identity.reauthenticate(args(body)?).await?),
906 // Two-factor authentication; see two_factor.rs.
907 "two_factor_status" => reply(&identity.two_factor_status(args(body)?).await?),
908 "two_factor_start" => reply(&identity.two_factor_start(args(body)?).await?),
909 "two_factor_enable" => reply(&identity.two_factor_enable(args(body)?).await?),
910 "two_factor_disable" => reply(&identity.two_factor_disable(args(body)?).await?),
911 "two_factor_recovery_codes" => reply(&identity.two_factor_recovery_codes(args(body)?).await?),
912 "two_factor_sign_in" => reply(&identity.two_factor_sign_in(args(body)?).await?),
913 "security_log" => reply(&identity.security_log(args(body)?).await?),
914 "email_owners" => reply(&identity.email_owners(args(body)?).await?),
915 "commit_identity" => reply(&identity.commit_identity(args(body)?).await?),
916 "push_email_guard" => reply(&identity.push_email_guard(args(body)?).await?),
917 "admin_user" => reply(&identity.admin_user(args(body)?).await?),
918 "admin_remove_email" => reply(&identity.admin_remove_email(args(body)?).await?),
919 "sign_out" => reply(&identity.sign_out(args(body)?).await?),
920 "user_for_session" => reply(&identity.user_for_session(args(body)?).await?),
921 "user_for_git_credentials" => reply(&identity.user_for_git_credentials(args(body)?).await?),
922 "user_for_access_token" => {
923 let a: TokenArgs = args(body)?;
924 reply(&identity.user_for_access_token(&a.token).await?)
925 }
926 "user_for_ssh_key" => reply(&identity.user_for_ssh_key(args(body)?).await?),
927 "user_by_username" => reply(&identity.user_by_username(args(body)?).await?),
928 "usernames" => reply(&identity.usernames(args(body)?).await?),
929 "accounts" => reply(&identity.accounts(args(body)?).await?),
930 "notify_by_email" => reply(&identity.notify_by_email(args(body)?).await?),
931 "profile" => reply(&identity.profile(args(body)?).await?),
932 "update_profile" => {
933 let outcome = identity.update_profile(args(body)?).await?;
934 if let Outcome::Ok(profile) = &outcome {
935 identity.announce_user(&profile.username, None).await;
936 }
937 reply(&outcome)
938 }
939 "directory" => reply(&identity.directory(args(body)?).await?),
940 "profile_workspaces" => reply(&identity.profile_workspaces(args(body)?).await?),
941 "list_ssh_keys" => reply(&identity.list_ssh_keys(args(body)?).await?),
942 // Services only: who registered each key, for verifying commit
943 // signatures (repos' signatures.rs).
944 "ssh_key_owners" => reply(&identity.ssh_key_owners(args(body)?).await?),
945 "add_ssh_key" => reply(&identity.add_ssh_key(args(body)?).await?),
946 "remove_ssh_key" => reply(&identity.remove_ssh_key(args(body)?).await?),
947 "list_access_tokens" => reply(&identity.list_access_tokens(args(body)?).await?),
948 "create_access_token" => reply(&identity.create_access_token(args(body)?).await?),
949 "update_access_token" => reply(&identity.update_access_token(args(body)?).await?),
950 "create_agent_token" => reply(&identity.create_agent_token(args(body)?).await?),
951 "agent_scope" => reply(&identity.agent_scope(args(body)?).await?),
952 "create_run_credential" => reply(&identity.create_run_credential(args(body)?).await?),
953 "bind_run_credentials" => reply(&identity.bind_run_credentials(args(body)?).await?),
954 "revoke_run_credentials" => reply(&identity.revoke_run_credentials(args(body)?).await?),
955 "remove_access_token" => reply(&identity.remove_access_token(args(body)?).await?),
956 // Invites and the waitlist; see invites.rs.
957 "registration" => reply(&identity.registration_mode()),
958 "list_invites" => reply(&identity.list_invites(args(body)?).await?),
959 "create_invite" => reply(&identity.create_invite(args(body)?).await?),
960 "revoke_invite" => reply(&identity.revoke_invite(args(body)?).await?),
961 "check_invite" => reply(&identity.check_invite(args(body)?).await?),
962 "accept_invite" => reply(&identity.accept_invite(args(body)?).await?),
963 "invite_member" => reply(&identity.invite_member(args(body)?).await?),
964 "workspace_invites" => reply(&identity.workspace_invites(args(body)?).await?),
965 "revoke_workspace_invite" => reply(&identity.revoke_workspace_invite(args(body)?).await?),
966 "request_access" => reply(&identity.request_access(args(body)?).await?),
967 // Who has access to a repository; see access.rs.
968 "repo_access" => reply(&identity.repo_access(args(body)?).await?),
969 "add_collaborator" => reply(&identity.add_collaborator(args(body)?).await?),
970 "set_collaborator_role" => reply(&identity.set_collaborator_role(args(body)?).await?),
971 "remove_collaborator" => reply(&identity.remove_collaborator(args(body)?).await?),
972 "collaborator_permission" => reply(&identity.collaborator_permission(args(body)?).await?),
973 "my_repo_invitations" => reply(&identity.my_repo_invitations(args(body)?).await?),
974 "respond_repo_invitation" => reply(&identity.respond_repo_invitation(args(body)?).await?),
975 "revoke_repo_invitation" => reply(&identity.revoke_repo_invitation(args(body)?).await?),
976 "set_base_permission" => reply(&identity.set_base_permission(args(body)?).await?),
977 // Where a workspace keeps its repositories' git data (EU residency).
978 "workspace_residency" => reply(&identity.workspace_residency(args(body)?).await?),
979 "set_workspace_residency" => reply(&identity.set_workspace_residency(args(body)?).await?),
980 "outside_collaborators" => reply(&identity.outside_collaborators(args(body)?).await?),
981 "forget_repo_access" => reply(&identity.forget_repo_access(args(body)?).await?),
982 // Teams (teams.rs).
983 "list_teams" => reply(&identity.list_teams(args(body)?).await?),
984 "get_team" => reply(&identity.get_team(args(body)?).await?),
985 "create_team" => reply(&identity.create_team(args(body)?).await?),
986 "set_team_creation" => reply(&identity.set_team_creation(args(body)?).await?),
987 "update_team" => reply(&identity.update_team(args(body)?).await?),
988 "delete_team" => reply(&identity.delete_team(args(body)?).await?),
989 "team_members" => reply(&identity.team_members(args(body)?).await?),
990 "set_team_member" => reply(&identity.set_team_member(args(body)?).await?),
991 "remove_team_member" => reply(&identity.remove_team_member(args(body)?).await?),
992 "child_teams" => reply(&identity.child_teams(args(body)?).await?),
993 "team_repos" => reply(&identity.team_repos(args(body)?).await?),
994 "set_team_repo" => reply(&identity.set_team_repo(args(body)?).await?),
995 "remove_team_repo" => reply(&identity.remove_team_repo(args(body)?).await?),
996 "user_teams" => reply(&identity.user_teams(args(body)?).await?),
997 "team_memberships" => reply(&identity.team_memberships(args(body)?).await?),
998 "resolve_teams" => reply(&identity.resolve_teams(args(body)?).await?),
999 "resolve_owners" => reply(&identity.resolve_owners(args(body)?).await?),
1000 // Staff only: sudo.g1t.sh, over its service binding. See admin.rs.
1001 "notify_owners" => reply(&identity.notify_owners(args(body)?).await?),
1002 "admin_workspaces" => reply(&identity.admin_workspaces(args(body)?).await?),
1003 "admin_workspace" => reply(&identity.admin_workspace(args(body)?).await?),
1004 "admin_waitlist" => reply(&identity.admin_waitlist(args(body)?).await?),
1005 "admin_decide_waitlist" => reply(&identity.admin_decide_waitlist(args(body)?).await?),
1006 "admin_waitlist_pending" => reply(&identity.admin_waitlist_pending().await?),
1007 "admin_invites" => reply(&identity.admin_invites(args(body)?).await?),
1008 "admin_revoke_invite" => reply(&identity.admin_revoke_invite(args(body)?).await?),
1009 "admin_mint_invite" => reply(&identity.admin_mint_invite(args(body)?).await?),
1010 "admin_grant_invites" => reply(&identity.admin_grant_invites(args(body)?).await?),
1011 "admin_invite_tree" => reply(&identity.admin_invite_tree(args(body)?).await?),
1012 "admin_workspace_invites" => reply(&identity.admin_workspace_invites(args(body)?).await?),
1013 // Deleted workspaces, restored or purged by staff; see deletion.rs.
1014 "admin_deleted_workspaces" => reply(&identity.admin_deleted_workspaces().await?),
1015 "admin_restore_workspace" => reply(&identity.admin_restore_workspace(args(body)?).await?),
1016 "admin_purge_workspace" => reply(&identity.admin_purge_workspace(args(body)?).await?),
1017 // Workspace aliases, set by staff only; see aliases.rs.
1018 "admin_aliases" => reply(&identity.admin_aliases().await?),
1019 "admin_set_alias" => reply(&identity.admin_set_alias(args(body)?).await?),
1020 "admin_remove_alias" => reply(&identity.admin_remove_alias(args(body)?).await?),
1021 _ => Response::error("Unknown method", 404),
1022 };
1023 served.finish(answered)
1024}
1025
1026#[cfg(test)]
1027mod register_tests {
1028 use super::*;
1029
1030 #[test]
1031 fn nobody_registers_as_g1t() {
1032 // What register checks the username with, whatever its case.
1033 for username in ["g1t", "G1T", "g1t-agent", "G1t-Agent"] {
1034 assert_eq!(claimable_namespace(username), None, "{username}");
1035 }
1036 assert_eq!(claimable_namespace("ana").as_deref(), Some("ana"));
1037 }
1038}