mirror of
https://github.com/vas3k/TaxHacker.git
synced 2026-07-03 10:52:28 +08:00
* feat: initial email impl * feat: IMAP email ingest (builds on the scaffold) (#100) * chore: add imap-simple, mailparser, vitest * feat: AES-256-GCM helpers for email credentials * feat: extract ingestUnsortedFile helper, reuse in upload action * chore: gitignore .worktrees/ * feat: email-sync types and pure attachment/search filters * feat: imap-simple + mailparser client wrapper * feat: email sync orchestration with UID watermark + status persistence * feat: encrypt email credentials at rest, add UID/addedAt fields * feat: real IMAP test-connection, scoped sync-now, thin cron entry * docs: update email app README to match real IMAP/encryption/UID behavior * fix: nest SINCE search criteria and guard missing addedAt for first-run sync * fix: show last-sync time and error detail from sync in server card * fix: skip storage recompute when no attachments ingested Avoids an ENOENT crash on first sync when the user's uploads dir does not exist yet and nothing was ingested; this was also masking the real per-server error. Adds regression tests for the guard. * feat: configurable initial-grab window (fetch-since date) First sync is bounded by a user-chosen 'Fetch emails since' date instead of the server's addedAt; blank = entire mailbox (IMAP ALL). The UID watermark takes over after the first run. * fix: add missing @langchain/core dependency @langchain/core is only a peer dep of the @langchain/* packages and was not installed on a clean npm install, breaking the build (e.g. /unsorted via ai/analyze). * fix: harden email sync — UID dedup guard, locked status write, graceful decrypt, scrypt memo Addresses review findings: skip messages at/below the UID watermark (defends against the IMAP `n:*` re-fetch quirk); lock the app_data row with SELECT FOR UPDATE so concurrent cron/manual syncs can't clobber each other; return a friendly error when a stored password can't be decrypted (e.g. after BETTER_AUTH_SECRET rotation) and document the coupling; memoize the scrypt-derived key. * feat: enforce per-server syncInterval on cron; skip non-Buffer attachments The cron now honors each server's syncInterval (manual Sync Now bypasses the throttle), so the configured interval is no longer ignored. Attachments whose parsed content is not a Buffer are skipped instead of throwing on .length. Adds throttle regression tests. * refactor: remove dead lastProcessedMessageId field; clarify cron throttle in README lastProcessedMessageId was superseded by the lastProcessedUid watermark and never read; dropped from the type and form state. README now describes the per-server interval as an app-level throttle (manual Sync Now bypasses). * feat(email): UI-selectable sync frequency + working cron heartbeat Replace the per-server sync-interval number input with a dropdown of presets (15m/30m/hourly/6h/12h/daily). Switch the stored unit from hours to minutes and update the throttle accordingly. Make the cron actually run: heartbeat now fires every 5 minutes as the resolution floor while each mailbox's UI frequency gates real fetches. Propagate env into cron jobs via /etc/cron.env (cron strips the environment) and add BETTER_AUTH_SECRET to the email-sync service in the dev/build compose files so stored passwords can be decrypted. * fix(email): reset Add Server dialog to provider selection on close Radix's onOpenChange only toggled isOpen, so closing the dialog via Esc, overlay click, or the X left the step/selectedProvider state intact. Reopening then jumped straight to the previous provider's config form instead of the provider-selection screen. Route every close through handleClose() to reset the step. --------- Co-authored-by: Evgenii Burmakin <Freika@users.noreply.github.com>
41 lines
1.5 KiB
TypeScript
41 lines
1.5 KiB
TypeScript
import { createCipheriv, createDecipheriv, randomBytes, scryptSync } from "crypto"
|
|
|
|
const PREFIX = "v1"
|
|
const ALGO = "aes-256-gcm"
|
|
|
|
let cachedKey: { secret: string; key: Buffer } | undefined
|
|
|
|
function getKey(): Buffer {
|
|
const secret = process.env.BETTER_AUTH_SECRET
|
|
if (!secret) {
|
|
throw new Error("BETTER_AUTH_SECRET is required to encrypt/decrypt email credentials")
|
|
}
|
|
// scrypt is intentionally slow; memoize per secret so a batch sync derives the key once.
|
|
if (cachedKey?.secret !== secret) {
|
|
cachedKey = { secret, key: scryptSync(secret, "taxhacker-email-credentials", 32) }
|
|
}
|
|
return cachedKey.key
|
|
}
|
|
|
|
export function isEncrypted(value: string): boolean {
|
|
return typeof value === "string" && value.startsWith(`${PREFIX}:`)
|
|
}
|
|
|
|
export function encryptSecret(plaintext: string): string {
|
|
const iv = randomBytes(12)
|
|
const cipher = createCipheriv(ALGO, getKey(), iv)
|
|
const ciphertext = Buffer.concat([cipher.update(plaintext, "utf8"), cipher.final()])
|
|
const authTag = cipher.getAuthTag()
|
|
return [PREFIX, iv.toString("base64"), authTag.toString("base64"), ciphertext.toString("base64")].join(":")
|
|
}
|
|
|
|
export function decryptSecret(stored: string): string {
|
|
if (!isEncrypted(stored)) {
|
|
return stored
|
|
}
|
|
const [, ivB64, tagB64, dataB64] = stored.split(":")
|
|
const decipher = createDecipheriv(ALGO, getKey(), Buffer.from(ivB64, "base64"))
|
|
decipher.setAuthTag(Buffer.from(tagB64, "base64"))
|
|
return Buffer.concat([decipher.update(Buffer.from(dataB64, "base64")), decipher.final()]).toString("utf8")
|
|
}
|