coinos-server.git/scripts, branch master

analytics-geo: read rotated request log chunks

2026-10-08T19:03:38Z

Co-Authored-By: Claude Opus 5.5

scripts: stubborn peer-force LN payer + boltz stuck-swap recovery

2026-08-27T22:19:52Z

Add scripts/pay-hard.ts: a payment helper for well-connected but inbound-scarce destinations (exchange nodes) that cost-first payers (xpay/renepay) can't reach. When the normal xpay attempt fails, it enumerates the destination's peers, keeps the ones we can reach (preferring peers we already channel with enough outbound), and for each builds a route forced through peer->dest with the invoice's correct final CLTV, probes it with an unclaimable random hash, and pays through the first path that reaches the destination. Probe-before-send, refuses to start with a payment already pending, and stops rather than risk a second in-flight payment. Works against either the main node (cl) or the boltz node (bcln). Add scripts/boltz-recover-stuck.ts: a cron watcher that finds submarine swaps stuck at invoice.pending (lockup confirmed, invoice unexpired, idle past a threshold) and runs pay-hard against bcln to complete them, then lets boltz reconcile (restarting it only if it hasn't picked up the preimage within a grace period). Co-Authored-By: Claude Opus 4.8 Claude-Session: https://claude.ai/code/session_01DKkev76U4YRnRAqM6jqbae

scripts: add lightning-backlog audit + kvrocks archive merge tooling

2026-08-22T15:46:47Z

audit-lightning-backlog.ts walks settled invoices from the stored pay_index to surface receives the listener may have missed crediting (companion to the listener backlog probe). merge-kvrocks-archives.ts overlays one Kvrocks/Redis archive onto a base without materializing keys in memory (raw SCAN to survive cursors beyond JS safe-integer range), with kvrocks-merge-lowmem.conf as the low-memory server config for the merge. All parameterized via CLI flags; no embedded hosts or secrets. Co-Authored-By: Claude Opus 4.8 Claude-Session: https://claude.ai/code/session_01XiwgmQKwKnRxUmVDd4xSf7

scripts: add dedup-invoices cleanup for already-duplicated :invoices

2026-06-18T15:27:11Z

The source fix (LPOS guard in generate()) stops NEW duplicate entries but doesn't remove the ones already accumulated. This one-time script scrubs them: scans every :invoices list and removes duplicate ids, keeping each id's original creation-order position. Dry-run by default; pass --apply to write. Idempotent. Co-Authored-By: Claude Opus 4.8 (1M context)

scripts: add wiped-history audit and rebalance-economics model

2026-06-13T21:21:53Z

audit-wiped-history.ts (read-only) finds accounts whose :payments index was wiped by the changeid bug — balance>0 with empty history in both db and arc. rebalance-economics.ts models whether the lightning->liquid bridge throughput is fee-positive against on-chain rebalance cost. Co-Authored-By: Claude Opus 4.8 (1M context)

analytics: missing-history audit + lightning->liquid arb finder

2026-06-04T19:14:15Z

audit-missing-history.ts: read-only audit classifying every user's payment history as clean / recoverable (record in arc not db) / lost (gone from both). Full-scan finding: of 6,330 users with history, 77% are "arc-only" which is the NORMAL archived state — the payments route reads via gf() (archive fallback) so those render fine in the app. True loss is 58 users / 59 records (0.02%). So there is no widespread history loss; "missing history" reports are almost always either dropped receive-callbacks (record never written, like apk403's 1100 sats) or one of the rare 59. ln-liquid-arb.ts: finds users funding via lightning and withdrawing via liquid (the pattern draining the liquid hot wallet / forcing threshold cuts). Reports per-user through-flow + net liquid drainers. Co-Authored-By: Claude Opus 4.8 (1M context)

analytics: --csv flag for month-over-month trend tracking

2026-06-04T07:42:15Z

Appends one metrics row per run to a CSV (header written if file is new): date, users, MAU/WAU, payments, volume, custody, fee revenue, bolt12 recipients, and per-type volume/txn columns. Notice goes to stderr so it doesn't pollute the saved stdout report or --json output. Drives the new monthly snapshot cron (~/scripts/analytics-cron.sh). Co-Authored-By: Claude Opus 4.8 (1M context)

analytics: monthly insight reports + signup instrumentation

2026-06-04T06:10:20Z

scripts/analytics.ts — streams live db (SCAN, never KEYS) and reports for a trailing window (default 30d): MAU/WAU, new users, custody total + top holders, network volume by type (lightning/liquid/bitcoin/internal/bolt12/ fund), most-active and highest-volume users, and bolt12 recipients with a "regular" flag for the Ocean mining-reward stream. scripts/analytics-geo.ts — top countries from the request log. Counts only /login + /register events tied to a username (raw cf-ipcountry volume is dominated by datacenter/nostr traffic). Surfaces a distinct-IP-per-country column so proxy/VPN egress is visible, and filters a known credential-test bot IP. Honest result: US #1, then GB/CA/JP/DE/ES/BR. lib/register.ts — stamp `created` (ms epoch) and store `country` (CF/ ipregistry code) on new users, so future reports get real signup timing and geography from the db directly instead of log archaeology. Existing users predate this; backfill is out of scope. Co-Authored-By: Claude Opus 4.8 (1M context)

catch reverse errors

2026-03-17T05:53:11Z

adjust ln minfee

2026-03-15T22:49:17Z