Repository Public
1// SP Mail Next — exploitation : forme de /api/admin/health, alerte levée puis résolue par une condition pilotable (fichier d'état de la2// sauvegarde), une seule alerte et une seule notification par condition, message INTERNE réellement déposé dans la boîte de3// l'administrateur (aucun envoi), acquittement, anomalie d'authentification, appareils et révocation sous réauthentification, tendances.4import assert from "node:assert/strict"5import fs from "node:fs"6import os from "node:os"7import path from "node:path"8import { after, before, test } from "node:test"9import { ApiError, Client, ORIGIN, RUN, cli, reauth, sleep, sql, startServerWith, stopServer, tokenOf, until } from "../harness"10import { mkMailbox, purgeAll, setupAdmin, type Box } from "./v1-helpers"1112const statusFile = path.join(os.tmpdir(), `spmail-backup-status-${process.pid}.json`)13const backup = (hoursAgo: number, ok = true, error = "") => fs.writeFileSync(statusFile, JSON.stringify({ at: new Date(Date.now() - hoursAgo * 3600_000).toISOString(), ok, file: "edge.tar.zst.enc", bytes: 1, copies: 7, error }))14let admin: Client, member: Client15let M: Box16let acct = ""1718async function rejects(p: Promise<unknown>, status: number, code?: string) {19 await assert.rejects(p, (e: unknown) => e instanceof ApiError && e.status === status && (!code || e.code === code), `attendu ${status} ${code ?? ""}`)20}21/** Messages d'alerte présents dans la boîte de l'administrateur (lus par JMAP, comme le ferait le webmail). */22async function alertMails(): Promise<any[]> {23 const r = await admin.jmap(M.id, [["Email/query", { accountId: acct, limit: 200 }, "q"], ["Email/get", { accountId: acct, "#ids": { resultOf: "q", name: "Email/query", path: "/ids" },24 properties: ["subject", "from", "to", "mailboxIds", "keywords", "preview", "header:Auto-Submitted:asText", "header:X-SPMail-Alert:asText"] }, "g"]])25 return (r[1][1].list as any[]).filter((e) => e["header:X-SPMail-Alert:asText"])26}27const backupMails = async () => (await alertMails()).filter((e) => e["header:X-SPMail-Alert:asText"].trim() === "backup")28const alerts = async (state = "open") => (await admin.call("GET", `/api/admin/alerts?state=${state}`)).data as any[]29const backupAlert = async (state = "open") => (await alerts(state)).find((a) => a.key === "backup")3031before(async () => {32 backup(1)33 // moniteur à la seconde ; seuil disque neutralisé (l'espace libre du poste de test n'est pas l'objet de la suite)34 await startServerWith({ SPMAIL_BACKUP_STATUS: statusFile, SPMAIL_OPS_MONITOR_INTERVAL_MS: "1000", SPMAIL_OPS_DISK_WARN_PCT: "0", SPMAIL_OPS_DISK_FAIL_PCT: "0" })35 admin = await setupAdmin()36 member = new Client("web")37 await member.enroll(tokenOf(await cli("invite")), "membre", "Membre")38 M = await mkMailbox(admin, "ops-admin")39 acct = (await admin.call("GET", `/api/jmap/${M.id}/session`)).primaryAccounts["urn:ietf:params:jmap:mail"]40})41after(async () => {42 await purgeAll(admin).catch((e) => console.error(e))43 await stopServer()44 fs.rmSync(statusFile, { force: true })45})4647test("santé : chaque contrôle rend { status, detail, checked_at } ; réservé aux administrateurs", async () => {48 // un premier tour de chaque travailleur Next (le premier tour du moniteur attend le délai STARTTLS du contrôle de certificat)49 const h = await until(async () => { const x = await admin.call("GET", "/api/admin/health?fresh=1"); return x.checks.workers.data.workers.some((w: any) => w.name === "ops monitor") ? x : null }, "battements des travailleurs")50 assert.deepEqual(Object.keys(h.checks).sort(), ["backups", "certificates", "database", "disk", "dns", "mail_server", "push", "queue", "webhooks", "workers"])51 for (const [name, c] of Object.entries<any>(h.checks)) {52 assert.ok(["ok", "warn", "fail", "unknown"].includes(c.status), `${name}: ${c.status}`)53 assert.ok(typeof c.detail === "string" && c.detail.length > 0, name)54 assert.ok(Math.abs(Date.now() - Date.parse(c.checked_at)) < 60_000, name)55 }56 assert.ok(["ok", "warn", "fail"].includes(h.status))57 assert.ok(Math.abs(Date.now() - Date.parse(h.generated_at)) < 10_000)58 // valeurs réelles : serveur de courrier joint, disque du nœud, sauvegarde fraîche, file lue, travailleurs vivants59 assert.equal(h.checks.database.status, "ok")60 assert.equal(h.checks.mail_server.status, "ok")61 assert.ok(h.checks.mail_server.data.latency_ms >= 0 && h.checks.mail_server.data.domains >= 1)62 assert.ok(h.checks.disk.data.free_pct > 0 && h.checks.disk.data.free_pct < 100 && h.checks.disk.data.total_bytes > h.checks.disk.data.free_bytes)63 assert.equal(h.checks.backups.status, "ok")64 assert.ok(h.checks.backups.data.age_hours >= 0.9 && h.checks.backups.data.age_hours <= 1.2)65 assert.ok(["ok", "warn", "fail"].includes(h.checks.queue.status) && h.checks.queue.data.size >= 0)66 assert.equal(h.checks.workers.data.enabled, true)67 const names = h.checks.workers.data.workers.map((w: any) => w.name)68 for (const w of ["ops monitor", "rules engine", "semantic indexer"]) assert.ok(names.includes(w), `battement de « ${w} » (${names})`)69 assert.ok(h.checks.workers.data.workers.every((w: any) => !w.stale))70 assert.deepEqual(h.checks.webhooks.data, { failed_24h: 0, backlog: 0 })71 // certificats : celui du serveur de courrier (lu dans Stalwart) a une échéance réelle ; l'origine de test n'est pas en https → « unknown », pas « fail »72 const certs = h.checks.certificates.data.certificates as any[]73 const stalwart = certs.find((c) => c.name.startsWith("stalwart:"))74 assert.ok(stalwart && stalwart.days > 0 && Date.parse(stalwart.expires_at) > Date.now(), JSON.stringify(certs))75 assert.equal(certs.find((c) => c.name.startsWith("web:")).status, "unknown")76 assert.ok(["ok", "warn", "unknown"].includes(certs.find((c) => c.name.startsWith("smtp:")).status), "STARTTLS injoignable d'ici = unknown, jamais fail")77 assert.notEqual(h.checks.certificates.status, "fail")78 assert.ok(["ok", "warn"].includes(h.checks.dns.status))79 // le cache sert la lecture suivante (mêmes horodatages), `fresh=1` relit80 const again = await admin.call("GET", "/api/admin/health")81 assert.equal(again.checks.dns.checked_at, h.checks.dns.checked_at)82 await rejects(member.call("GET", "/api/admin/health"), 403, "forbidden")83 assert.equal((await fetch(`${ORIGIN}/api/admin/health`)).status, 401)84 for (const u of ["/api/admin/alerts", "/api/admin/devices", "/api/admin/trends", "/api/admin/security-events"]) await rejects(member.call("GET", u), 403, "forbidden")85})8687test("alerte de sauvegarde : levée une fois, notifiée une fois (message interne dans la boîte de l'administrateur), aggravée, acquittée, résolue, relevée", async () => {88 assert.equal(await backupAlert(), undefined)89 assert.deepEqual(await backupMails(), [])90 // 1. la sauvegarde devient trop vieille (40 h > 36 h)91 backup(40)92 const a1 = await until(backupAlert, "alerte de sauvegarde levée")93 assert.deepEqual([a1.severity, a1.state, a1.title], ["warn", "open", "Backup failed or is too old"])94 assert.match(a1.detail, /40 h old \(limit 36 h\)/)95 const [mail] = await until(async () => { const l = await backupMails(); return l.length ? l : null }, "message d'alerte dans la boîte de l'administrateur")96 assert.equal(mail.subject, "[SP Mail] Warning: Backup failed or is too old")97 assert.deepEqual([mail.from[0].email, mail.to[0].email], [M.address, M.address], "message interne : de la boîte à elle-même")98 assert.equal(mail["header:Auto-Submitted:asText"].trim(), "auto-generated")99 assert.match(mail.preview, /WARN — Backup failed or is too old/)100 const inbox = (await admin.jmap(M.id, [["Mailbox/get", { accountId: acct, properties: ["role"] }, "m"]]))[0][1].list.find((f: any) => f.role === "inbox").id101 assert.deepEqual(Object.keys(mail.mailboxIds), [inbox])102 assert.ok(!mail.keywords.$seen, "non lu")103 // 2. plusieurs tours du moniteur : toujours UNE alerte ouverte, UN message, UNE notification consignée104 await sleep(4500)105 const a2 = await backupAlert()106 assert.equal(a2.id, a1.id)107 assert.ok(a2.count >= a1.count + 2 && Date.parse(a2.last_seen) > Date.parse(a1.last_seen), `le compteur avance (${a1.count} → ${a2.count})`)108 assert.equal(a2.first_seen, a1.first_seen)109 assert.equal((await sql`select count(*)::int as n from alerts where key = 'backup'`)[0].n, 1)110 assert.equal((await backupMails()).length, 1)111 const notes = await sql`select meta from audit_log where action = 'alert.notified' and target = 'backup'`112 assert.equal(notes.length, 1)113 assert.deepEqual([notes[0].meta.alert, notes[0].meta.admins, notes[0].meta.messages], [a1.id, 1, 1])114 // 3. aucune trace d'envoi : ni ligne d'envoi, ni soumission JMAP115 assert.equal((await sql`select count(*)::int as n from outbound_messages`)[0].n, 0)116 assert.deepEqual((await admin.jmap(M.id, [["EmailSubmission/query", { accountId: acct }, "s"]]))[0][1].ids, [])117 // 4. la sauvegarde échoue : même alerte, gravité relevée — sans nouveau message avant 12 h118 backup(0.1, false, "disk full on backup node")119 const a3 = await until(async () => { const a = await backupAlert(); return a?.severity === "fail" ? a : null }, "gravité relevée")120 assert.equal(a3.id, a1.id)121 assert.match(a3.detail, /last backup failed: disk full on backup node/)122 await sleep(2500)123 assert.equal((await backupMails()).length, 1)124 // 5. rappel après 12 h tant que l'alerte reste ouverte (échéance simulée en vieillissant la dernière notification)125 await sql`update alerts set notified_at = now() - interval '13 hours' where id = ${a1.id}`126 const two = await until(async () => { const l = await backupMails(); return l.length === 2 ? l : null }, "rappel après 12 h")127 assert.ok(two.some((m) => m.subject === "[SP Mail] ALERT: Backup failed or is too old"))128 // 6. acquittement : réservé aux administrateurs ; une alerte acquittée ne rappelle plus129 await rejects(member.call("POST", `/api/admin/alerts/${a1.id}/ack`, {}), 403, "forbidden")130 const acked = await admin.call("POST", `/api/admin/alerts/${a1.id}/ack`, {})131 assert.equal(acked.state, "acked")132 await rejects(admin.call("POST", `/api/admin/alerts/${a1.id}/ack`, {}), 409, "not_open")133 await rejects(admin.call("POST", "/api/admin/alerts/3f2b8c1e-9a4d-4e6f-8b7a-1c2d3e4f5a6b/ack", {}), 404, "not_found")134 await sql`update alerts set notified_at = now() - interval '13 hours' where id = ${a1.id}`135 await sleep(3000)136 assert.equal((await backupMails()).length, 2, "pas de rappel pour une alerte acquittée")137 const listed = await backupAlert()138 assert.deepEqual([listed.state, listed.acked_by_handle], ["acked", "owner"])139 // 7. la sauvegarde repasse : l'alerte se résout seule et quitte la liste ouverte140 backup(0.2)141 await until(async () => !(await backupAlert()), "alerte résolue")142 const resolved = (await alerts("all")).find((a) => a.id === a1.id)143 assert.equal(resolved.state, "resolved")144 assert.ok(resolved.resolved_at)145 assert.equal((await sql`select count(*)::int as n from audit_log where action = 'alert.resolved' and target = 'backup'`)[0].n, 1)146 // 8. la condition revient : NOUVELLE alerte, nouvelle notification147 backup(50)148 const b1 = await until(backupAlert, "nouvelle alerte")149 assert.notEqual(b1.id, a1.id)150 assert.equal(b1.state, "open")151 await until(async () => (await backupMails()).length === 3, "notification de la nouvelle alerte")152 backup(0.1)153 await until(async () => !(await backupAlert()), "seconde alerte résolue")154 assert.equal((await sql`select count(*)::int as n from alerts where key = 'backup' and state <> 'resolved'`)[0].n, 0)155 assert.equal((await sql`select count(*)::int as n from outbound_messages`)[0].n, 0)156})157158test("anomalie d'authentification : dix échecs en dix minutes lèvent l'alerte ; elle se résout quand la fenêtre se vide", async () => {159 for (let i = 0; i < 9; i++) await sql`insert into audit_log (action, target, ip) values ('login.failed', 'essai', '203.0.113.9')`160 await sleep(2500)161 assert.equal((await alerts()).find((a) => a.key === "auth_anomaly"), undefined, "neuf échecs : sous le seuil")162 await sql`insert into audit_log (action, target, ip) values ('reauth.failed', 'essai', '203.0.113.9')`163 const a = await until(async () => (await alerts()).find((x) => x.key === "auth_anomaly"), "alerte d'authentification")164 assert.deepEqual([a.severity, a.title], ["warn", "Authentication anomaly"])165 assert.match(a.detail, /10 failed passkey verifications in the last 10 minutes/)166 await until(async () => (await alertMails()).some((m) => m["header:X-SPMail-Alert:asText"].trim() === "auth_anomaly"), "message interne de l'anomalie")167 const ev = await admin.call("GET", "/api/admin/security-events?action=login.failed")168 assert.equal(ev.data.length, 9)169 assert.deepEqual(ev.failed_24h, { login_failed: 9, reauth_failed: 1 })170 await sql`update audit_log set at = now() - interval '11 minutes' where action in ('login.failed', 'reauth.failed')`171 await until(async () => !(await alerts()).some((x) => x.key === "auth_anomaly"), "anomalie résolue")172})173174test("appareils : sessions et jetons de push de tous les utilisateurs ; révoquer la session d'autrui exige une réauthentification, consignée", async () => {175 const [ms] = await sql`select s.id, s.user_id from sessions s join users u on u.id = s.user_id where u.handle = 'membre'`176 const [dev] = await sql`insert into push_devices (session_id, user_id, apns_token, bundle_id, environment) values (${ms.id}, ${ms.user_id}, ${"ab".repeat(29) + "c0ffee"}, 'ai.spboucher.spmail.ios', 'sandbox') returning id`177 const d = await admin.call("GET", "/api/admin/devices")178 assert.deepEqual(d.sessions.map((s: any) => s.handle).sort(), ["membre", "owner"])179 assert.deepEqual(d.sessions.filter((s: any) => s.current).map((s: any) => s.handle), ["owner"])180 assert.deepEqual(Object.keys(d.sessions[0]).sort(), ["created_at", "current", "device_name", "expires_at", "handle", "id", "ip", "kind", "last_seen_at", "platform", "user_agent", "user_id"])181 assert.equal(d.push_devices.length, 1)182 assert.deepEqual([d.push_devices[0].id, d.push_devices[0].handle, d.push_devices[0].token_tail, d.push_devices[0].bundle_id, d.push_devices[0].session_id], [dev.id, "membre", "c0ffee", "ai.spboucher.spmail.ios", ms.id])183 assert.ok(!JSON.stringify(d).includes("abababab"), "le jeton APNs entier ne sort jamais")184 assert.ok(!("apns_token" in d.push_devices[0]) && !JSON.stringify(d).includes("token_hash"))185 // révocation : administrateur ET réauthentifié186 await sql`update sessions set reauth_at = null`187 await rejects(admin.call("DELETE", `/api/admin/devices/sessions/${ms.id}`), 403, "reauth_required")188 await rejects(admin.call("DELETE", `/api/admin/devices/push/${dev.id}`), 403, "reauth_required")189 await rejects(member.call("DELETE", `/api/admin/devices/sessions/${ms.id}`), 403, "forbidden")190 await member.call("GET", "/api/next/capabilities")191 assert.equal((await member.raw("GET", "/api/next/rules")).status, 200, "la session du membre vit encore")192 await reauth(admin)193 await rejects(admin.call("DELETE", "/api/admin/devices/sessions/3f2b8c1e-9a4d-4e6f-8b7a-1c2d3e4f5a6b"), 404, "not_found")194 assert.deepEqual(await admin.call("DELETE", `/api/admin/devices/sessions/${ms.id}`), { ok: true })195 assert.equal((await member.raw("GET", "/api/next/rules")).status, 401, "session révoquée sur-le-champ")196 assert.equal((await sql`select count(*)::int as n from push_devices`)[0].n, 0, "ses jetons de push partent avec elle")197 const [log] = await sql`select actor, target, meta from audit_log where action = 'admin.session.revoke'`198 assert.deepEqual([log.target, log.meta.user], [ms.id, ms.user_id])199 await rejects(admin.call("DELETE", `/api/admin/devices/sessions/${ms.id}`), 404, "not_found")200 assert.deepEqual((await admin.call("GET", "/api/admin/devices")).sessions.map((s: any) => s.handle), ["owner"])201})202203test("tendances et événements de sécurité", async () => {204 const today = new Date().toISOString().slice(0, 10)205 const st = await admin.call("GET", "/api/admin/trends?metric=storage&days=7")206 assert.deepEqual([st.metric, st.days], ["storage", 7])207 const day = st.data.find((d: any) => d.day === today)208 assert.ok(day, JSON.stringify(st.data))209 assert.deepEqual(day.mailboxes.map((m: any) => m.address), [M.address])210 assert.ok(typeof day.mailboxes[0].used_bytes === "number" && day.used_bytes === day.mailboxes[0].used_bytes, "espace réellement lu sur le serveur de courrier")211 const dl = await admin.call("GET", "/api/admin/trends?metric=deliveries&refresh=1")212 const dd = dl.data.find((d: any) => d.day === today)213 assert.deepEqual([dd.sent, dd.delivered, dd.bounced, dd.failed], [0, 0, 0, 0])214 assert.ok(dd.received >= 4, `les messages d'alerte déposés comptent comme reçus (${dd.received})`)215 const api = await admin.call("GET", "/api/admin/trends?metric=api")216 assert.ok(Array.isArray(api.data))217 await rejects(admin.call("GET", "/api/admin/trends?metric=secrets"), 400, "invalid_request")218 assert.equal((await sql`select count(*)::int as n from usage_snapshots where day = ${today}`)[0].n, 1)219 // événements de sécurité : authentification, sessions, alertes — pas le reste du journal220 const ev = await admin.call("GET", "/api/admin/security-events?limit=500")221 const actions = new Set(ev.data.map((e: any) => e.action))222 for (const a of ["enroll", "reauth", "login.failed", "reauth.failed", "alert.notified", "alert.ack", "alert.resolved", "admin.session.revoke"]) assert.ok(actions.has(a), a)223 assert.ok(!actions.has("mailbox.create") && [...actions].every((a) => /^(login|reauth|enroll|passkey\.|session\.|admin\.|apikey\.|alert\.)/.test(String(a))), [...actions].join(", "))224 assert.ok(ev.data.every((e: any, i: number) => i === 0 || e.id < ev.data[i - 1].id), "du plus récent au plus ancien")225 const only = await admin.call("GET", "/api/admin/security-events?action=alert&limit=2")226 assert.ok(only.data.length === 2 && only.data.every((e: any) => e.action.startsWith("alert.")))227 const next = await admin.call("GET", `/api/admin/security-events?action=alert&limit=2&before=${only.next_before}`)228 assert.ok(next.data.length >= 1 && next.data.every((e: any) => e.id < only.next_before))229 await rejects(admin.call("GET", "/api/admin/security-events?action=DROP%20TABLE"), 400, "invalid_request")230})231232test("compléments de la console : remises à problème (réponse SMTP, jamais le contenu) et état par boîte ; réservés aux administrateurs", async () => {233 // (la session du premier membre a été révoquée plus haut : un second membre, session valide, rôle insuffisant)234 const other = new Client("web")235 await other.enroll(tokenOf(await cli("invite")), "membre2", "Membre 2")236 for (const u of ["/api/admin/deliveries/problems", "/api/admin/mailboxes/status"]) await rejects(other.call("GET", u), 403, "forbidden")237 // trois envois suivis : un livré (hors liste), un rebondi récent, un échoué trop ancien pour la fenêtre demandée238 const row = (id: string, status: string, age: string, recipients: unknown[]) => sql`insert into outbound_messages (id, from_address, mailbox_id, recipients, status, attempts, last_error, submitted_at, updated_at)239 values (${id}, ${M.address}, ${M.id}, ${sql.json(recipients as never)}, ${status}, 2, ${status === "delivered" ? null : "remote refused"}, now() - ${age}::interval, now() - ${age}::interval)`240 await row("out_ops_ok", "delivered", "1 hour", [{ address: "ok@example.org", status: "delivered", smtp_reply: "250 ok" }])241 await row("out_ops_bounced", "bounced", "2 hours", [{ address: "nobody@example.org", status: "bounced", smtp_reply: "550 5.1.1 User unknown" }])242 await row("out_ops_old", "failed", "40 days", [{ address: "old@example.org", status: "failed" }])243 const p = await admin.call("GET", "/api/admin/deliveries/problems?days=14")244 assert.deepEqual(p.data.map((o: any) => o.id), ["out_ops_bounced"])245 assert.deepEqual(p.data[0].recipients, [{ address: "nobody@example.org", status: "bounced", smtp_reply: "550 5.1.1 User unknown" }])246 assert.deepEqual([p.data[0].from, p.data[0].status, p.data[0].attempts, p.data[0].last_error], [M.address, "bounced", 2, "remote refused"])247 assert.deepEqual(Object.keys(p.data[0]).sort(), ["attempts", "created_at", "external", "final_at", "from", "id", "last_error", "recipients", "status", "updated_at"], "enveloppe seulement")248 assert.deepEqual((await admin.call("GET", "/api/admin/deliveries/problems?days=90")).data.map((o: any) => o.id), ["out_ops_bounced", "out_ops_old"], "du plus récent au plus ancien")249 await rejects(admin.call("GET", "/api/admin/deliveries/problems?limit=0"), 400, "invalid_request")250251 const s = await admin.call("GET", "/api/admin/mailboxes/status")252 assert.equal(s.workers, true)253 const box = s.data.find((b: any) => b.mailbox_id === M.id)254 assert.ok(box, JSON.stringify(s.data))255 assert.deepEqual([box.address, box.handle], [M.address, "owner"])256 assert.ok(typeof box.used_bytes === "number", "espace lu sur le serveur de courrier")257 assert.ok(box.last_received_at && Math.abs(Date.now() - Date.parse(box.last_received_at)) < 3600_000, "les messages d'alerte déposés plus haut ont été vus par le veilleur")258 assert.ok(box.last_sent_at && Date.now() - Date.parse(box.last_sent_at) > 30 * 60_000, "dernier envoi soumis")259 assert.ok(box.owner_sessions >= 1)260 assert.deepEqual([box.watcher.state, box.watcher.failures, box.watcher.error], ["ok", 0, null])261 assert.ok(box.watcher.updated_at)262 assert.ok(!JSON.stringify(s).includes("secret"), "aucun secret de boîte dans la réponse")263 await sql`delete from outbound_messages where id like 'out_ops_%'`264})265266// En dernier : c'est le seul envoi réel de la suite (les essais précédents comptent les envois et les messages de la boîte).267test("veilleur de réception : une vraie remise est suivie (watched_messages) et aucune propriété demandée n'est refusée par le serveur de courrier", async () => {268 // Le veilleur lit chaque arrivée avec sa liste complète de propriétés (en-têtes de liste compris) : si le serveur en refuse une seule,269 // Email/get échoue, rien n'est suivi (ni push, ni règles, ni webhooks) et l'échec est compté pour la boîte.270 const subject = `Veilleur ${RUN}`271 const sent = await admin.raw("POST", "/api/v1/messages/send", { from: M.address, to: [M.address], subject, text: "Remise réelle pour le veilleur." })272 assert.ok([200, 202].includes(sent.status), `envoi accepté (${sent.status})`)273 const mine = async () => ((await admin.jmap(M.id, [["Email/query", { accountId: acct, filter: { subject }, limit: 10 }, "q"], ["Email/get", { accountId: acct, "#ids": { resultOf: "q", name: "Email/query", path: "/ids" }, properties: ["mailboxIds", "keywords"] }, "g"]]))[1][1].list as any[]).filter((e) => !e.keywords?.$draft)274 const failures = async () => (await admin.call("GET", "/api/admin/health?fresh=1")).checks.workers.data.watcher_failures as any[]275 const row = await until(async () => {276 const ids = (await mine()).map((e) => e.id)277 const [w] = ids.length ? await sql`select email_id, address from watched_messages where mailbox_id = ${M.id} and email_id = any(${ids})` : []278 if (!w) { const f = await failures(); assert.deepEqual(f, [], `le veilleur échoue : ${JSON.stringify(f)}`) }279 return w280 }, "ligne watched_messages après la remise", 60_000)281 assert.equal(row.address, M.address)282 assert.deepEqual(await failures(), [], "aucun échec du veilleur")283 const h = await admin.call("GET", "/api/admin/health?fresh=1")284 assert.deepEqual(h.checks.workers.data.watcher_stalled, [])285 // la boîte a bien un état de synchronisation enregistré (le veilleur a tourné sur elle)286 const [sync] = await sql`select email_state, resyncs from mailbox_sync where mailbox_id = ${M.id}`287 assert.ok(sync?.email_state)288})289