Seat lifecycle: seats never free — rolling activity window + visible seats + manual release #428
Closed
opened 2026-09-05 02:33:55 +00:00 by Cordy
·
3 comments
No Branch/Tag specified
main
b12v07
b11v07
b10v07
ci-rc-publish
fx15-s3dry
b9v07
b8v07
bench742
b7v07
legal-texts-v0.2
b6v07
b5v07
b4v07
b3v07
sx1139
st742
b2v07
ix1102
fu1098
zp1097
wd1099
tr1100
qf1077
nc1070
ci1
rp1072
lk1073
ab1071
fi1074
si1070
ra1054
wo1056
oc1057
tf1055
sv1063
fg1059
st1058
fs929
mu1039
ls1033
cf975
lf835
dx1023
ml896
a11y2
av1022
r913
r7
r6
r5
r45
r23
r1
b10
b9
fix-b5
fix-b4
fix-b3
fix-b2
fix-b1
fix-922
fix-923
fix-911
fix-343b
batch-a
v0.6.413
v0.6.412
v0.6.411
v0.6.410
v0.6.409
v0.6.408
v0.6.407
v0.6.406
v0.6.405
v0.6.404
v0.6.403
v0.6.402
v0.6.401
v0.6.400
v0.6.399
v0.6.398
v0.6.397
v0.6.396
v0.6.395
v0.6.394
v0.6.393
v0.6.392
v0.6.391
v0.6.390
v0.6.389
v0.6.388
v0.6.387
v0.6.386
v0.6.385
v0.6.384
v0.6.383
v0.6.382
v0.6.381
v0.6.380
v0.6.379
v0.6.378
v0.6.377
v0.6.376
v0.6.375
v0.6.374
v0.6.373
v0.6.372
v0.6.371
v0.6.370
v0.6.369
v0.6.368
v0.6.367
v0.6.366
v0.6.365
v0.6.364
v0.6.363
v0.6.362
v0.6.361
v0.6.360
v0.6.359
v0.6.358
v0.6.357
v0.6.356
v0.6.355
v0.6.354
v0.6.353
v0.6.352
v0.6.351
v0.6.350
v0.6.349
v0.6.348
v0.6.347
v0.6.346
v0.6.345
v0.6.344
v0.6.343
v0.6.342
v0.6.341
v0.6.340
v0.6.339
v0.6.338
v0.6.337
v0.6.336
v0.6.335
v0.6.334
v0.6.333
v0.6.332
v0.6.331
v0.6.330
v0.6.329
v0.6.328
v0.6.327
v0.6.326
v0.6.325
v0.6.324
v0.6.323
v0.6.322
v0.6.321
v0.6.320
v0.6.319
v0.6.318
v0.6.317
v0.6.316
v0.6.315
v0.6.314
v0.6.313
v0.6.312
v0.6.311
v0.6.310
v0.6.309
v0.6.308
v0.6.307
v0.6.306
v0.6.305
v0.6.304
v0.6.303
v0.6.302
v0.6.301
v0.6.300
v0.6.299
v0.6.298
v0.6.297
v0.6.296
v0.6.295
v0.6.294
v0.6.293
v0.6.292
v0.6.291
v0.6.290
v0.6.289
v0.6.288
v0.6.287
v0.6.286
v0.6.285
v0.6.284
v0.6.283
v0.6.282
v0.6.281
v0.6.280
v0.6.279
v0.6.278
v0.6.277
v0.6.276
v0.6.275
v0.6.274
v0.6.273
v0.6.272
v0.6.271
v0.6.270
v0.6.269
v0.6.268
v0.6.267
v0.6.266
v0.6.265
v0.6.264
v0.6.263
v0.6.262
v0.6.261
v0.6.260
v0.6.259
v0.6.258
v0.6.257
v0.6.256
v0.6.255
v0.6.254
v0.6.253
v0.6.252
v0.6.251
v0.6.250
v0.6.249
v0.6.248
v0.6.247
v0.6.246
v0.6.245
v0.6.244
v0.6.243
v0.6.242
v0.6.241
v0.6.240
v0.6.239
v0.6.238
v0.6.237
v0.6.236
v0.6.235
v0.6.234
v0.6.233
v0.6.232
v0.6.231
v0.6.230
v0.6.229
v0.6.228
v0.6.227
v0.6.226
v0.6.225
v0.6.224
v0.6.223
v0.6.222
v0.6.221
v0.6.220
v0.6.219
v0.6.218
v0.6.217
v0.6.216
v0.6.215
v0.6.214
v0.6.213
v0.6.212
v0.6.211
v0.6.210
v0.6.209
v0.6.208
v0.6.207
v0.6.206
v0.6.205
v0.6.204
v0.6.203
v0.6.202
v0.6.201
v0.6.200
v0.6.199
v0.6.198
v0.6.197
v0.6.196
v0.6.195
v0.6.194
v0.6.193
v0.6.192
v0.6.191
v0.6.190
v0.6.189
v0.6.188
v0.6.187
v0.6.186
v0.6.185
v0.6.184
v0.6.183
v0.6.182
v0.6.181
v0.6.180
v0.6.179
v0.6.178
v0.6.177
v0.6.176
v0.6.175
v0.6.174
v0.6.173
v0.6.172
v0.6.171
v0.6.170
v0.6.169
v0.6.168
v0.6.167
v0.6.166
v0.6.165
v0.6.164
v0.6.163
v0.6.162
v0.6.161
v0.6.160
v0.6.159
v0.6.158
v0.6.157
v0.6.156
v0.6.155
v0.6.154
v0.6.153
v0.6.152
v0.6.151
v0.6.150
v0.6.149
v0.6.148
v0.6.147
v0.6.146
v0.6.145
v0.6.144
v0.6.143
v0.6.142
v0.6.141
v0.6.140
v0.6.139
v0.6.138
v0.6.137
v0.6.136
v0.6.135
v0.6.134
v0.6.133
v0.6.132
v0.6.131
v0.6.130
v0.6.129
v0.6.128
v0.6.127
v0.6.126
v0.6.125
v0.6.124
v0.6.123
v0.6.122
v0.6.121
v0.6.120
v0.6.119
v0.6.118
v0.6.117
v0.6.116
v0.6.115
v0.6.114
v0.6.113
v0.6.112
v0.6.111
v0.6.110
v0.6.109
v0.6.108
v0.6.107
v0.6.106
v0.6.105
v0.6.104
v0.6.103
v0.6.102
v0.6.101
v0.6.100
v0.6.99
v0.6.98
v0.6.97
v0.6.96
v0.6.95
v0.6.94
v0.6.93
v0.6.92
v0.6.91
v0.6.90
v0.6.89
v0.6.88
v0.6.87
v0.6.86
v0.6.85
v0.6.84
v0.6.83
v0.6.82
v0.6.81
v0.6.80
v0.6.79
v0.6.78
v0.6.77
v0.6.76
v0.6.75
v0.6.74
v0.6.73
v0.6.72
v0.6.71
v0.6.70
v0.6.69
v0.6.68
v0.6.67
v0.6.66
v0.6.65
v0.6.64
v0.6.63
v0.6.62
v0.6.61
v0.6.60
v0.6.59
v0.6.58
v0.6.57
v0.6.56
v0.6.55
v0.6.54
v0.6.53
v0.6.52
v0.6.51
v0.6.50
v0.6.49
v0.6.48
v0.6.47
v0.6.46
v0.6.45
v0.6.44
v0.6.43
v0.6.42
v0.6.41
v0.6.40
v0.6.39
v0.6.38
v0.6.37
v0.6.36
v0.6.35
v0.6.34
v0.6.33
v0.6.32
v0.6.31
v0.6.30
v0.6.29
v0.6.28
v0.6.25
v0.6.24
v0.6.23
v0.6.22
v0.6.21
v0.6.20
v0.6.19
v0.6.18
v0.6.17
v0.6.16
v0.6.15
v0.6.14
v0.6.12
v0.6.11
v0.6.10
v0.6.9
v0.6.8
v0.6.7
v0.6.6
v0.6.5
v0.6.4
v0.6.3
v0.6.2
v0.6.1
v0.6.0
v0.5.7
v0.5.6
v0.5.5
v0.5.4
v0.5.3
v0.5.2
v0.5.1
v0.5.0
v0.4.12
v0.4.11
v0.4.10
v0.4.9
v0.4.8
v0.4.7
v0.4.6
v0.4.5
v0.4.4
v0.4.3
v0.4.2
v0.4.1
v0.3.30
v0.3.29
v0.3.28
v0.3.27
v0.3.26
v0.3.25
v0.3.24
v0.3.23
v0.3.22
v0.3.21
v0.3.20
v0.3.19
v0.3.18
v0.3.17
v0.3.16
v0.3.15
v0.3.14
v0.3.13
v0.3.12
v0.3.11
v0.3.10
v0.3.9
v0.3.8
v0.3.7
v0.3.6
v0.3.5
v0.3.4
v0.3.3
v0.3.2
v0.3.1
v0.3.0
v0.2.7
v0.2.6
v0.2.5
v0.2.4
v0.2.3
v0.2.2
v0.2.1
v0.2.0
v0.0.3
v0.0.2
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".
No due date set.
Dependencies
No dependencies set.
Reference: Cordy/Cairn#428
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Flagged twice this week (Manuel's licensing question; Nikola 2026-09-05): "how would a seat become free again if a person leaves the company and their user either gets deleted from their OIDC or just stays for multiple months?"
Current behaviour: it never does
license.Manager.SeenUsersis append-only.Admitrecords a username on first sign-in; nothing ever removes one, and the stored timestamp is first-seen — not even refreshed on later sign-ins. A leaver holds their seat forever, whether their IdP account is deleted or just dormant. Cairn cannot observe IdP deletion (no SCIM/webhooks; OIDC only speaks at sign-in). The Overview footnote — "seats are people who have signed in, not accounts" — quietly means ever, which makes it a ratchet.How the competition does it
Direct competitors (self-hosted file sync/share):
ACTIVATE_AFTER_FIRST_LOGINoptionally ties activation to first login)Adjacent industry:
Fit assessment for Cairn: the Seafile/Nextcloud/GitLab model requires the product to own account state — a "disable user" concept. Cairn deliberately has none ("Cairn does not store passwords and cannot create, disable or rename a person"). The only models that fit an IdP-consuming product are ownCloud's activity window (no account state needed, purely observed sign-ins) and a manual release on the seat record (the seat, not the account — Cairn owns the former, never the latter).
Design (completes the existing philosophy instead of replacing it)
Admitrefreshes the user's timestamp on every successful sign-in, throttled to once per ~24h per user so it is not a state write per request. Migration is self-healing: existing first-seen values simply act as stale last-seens; active users blink out at worst once and re-record on next sign-in.Admit, and theseatsUsedreported at check-in all use it — displayed, enforced and billed numbers can never disagree (the Nextcloud bug class dies by construction). Dormant leavers age out automatically; IdP-deleted users age out identically since they can never sign in again.Deliberately rejected: account-state seats (nothing to deactivate in Cairn), SCIM/IdP webhooks (an integration surface far out of scope for the problem), GitLab-style max-seats true-up (renewal surprises; check-in stays a point-in-time honest report), ownCloud's 2-week window (too flappy for a billing definition).
Decisions to bless before building
seatsUsedpayload shape is unchanged.)seat-release— confirm.Verification
Related: #426 (admins now occupy seats — this issue governs how any seat is ever released), the licensing dress rehearsal planned for v0.7.
Decisions blessed (Nikola, 2026-09-05):
seatWindowDaysmetadata field provides nothing to the customer and creates a visible "sends usage data" surface in a product sold on sovereignty and privacy. Seafile and ownCloud send nothing back to their vendors; purchased seat counts are already known on our side from the sale. "Technically no one gains anything, but on the human level we might lose trust before even landing." The upgrade-cliff cost (seatsUsed dropping unexplained at the version boundary, incomparable history) is accepted knowingly.seat-release; released users re-occupy on next sign-in.Open question surfaced by the same reasoning (not blocking this issue): the existing check-in already reports
seatsUsed(#89). The sovereignty argument applies to it identically — dropping it would place Cairn fully in the Seafile/ownCloud no-usage-telemetry camp, leaving check-in as pure licence validation (renewals informed by the customer's own Seats tab instead). Nikola to decide separately.Next: Seats tab UI mockup (house rule: mockup before build), then TDD implementation.
Shipped and live-verified. v0.6.129 (PR #429, TDD run
tdd-428— red evidence in the run log: window-aging assertions, api compile-red, Seats/ReleaseSeat compile-red, all watched before their implementations landed in the same run), plus two layout patches v0.6.130/v0.6.131 (the admin shell's#adminview .uarowtwo-column grid wrapped the kebab; fixed with a two-id three-column rule, verified by live style injection before tagging). Both dogfoods run v0.6.131.What went in:
Admitrefreshes the holder's timestamp (throttled to one write per day); windowed 90-day counting feeds the Seats tile, the admission cap and both check-in paths. Legacy first-seen entries count as last-seen — the migration is doing nothing (verified live: manu-admin holds no seat because his last sign-in predates v0.6.128's admin recording; he claims one at next sign-in).GET /api/v1/license/seats+POST /api/v1/license/seats/release; release appends audit actionseat-release(actor = admin, path = freed holder).#admin/users/seats; licence meter footer restates the 90-day definition ×4 locales and links to the tab.Live verification on the enc dogfood (nikola-test session):
04:39 · nikola-test · seat-release · nikola-test2✓Follow-up nit: the audit query page's Action dropdown doesn't list
seat-release(events appear under "Any action"; the dropdown is a hardcoded list).Still open on this issue: the parked question of dropping
seatsUsedfrom the check-in payload entirely (Nikola's call), and Nikola's own look at the live tab before closing.Closing — every thread resolved:
seatsUseddropped from the check-in payload. v0.6.132 (PR #434, TDD with the red watched on the runner) posts{licenseId}alone; seat usage never leaves the instance. The licence server was verified beforehand to require onlylicenseId. Live-verified: Refresh licence on the enc dogfood at 05:32 — check-in OK against license.swisscairn.ch with the slimmed payload, key intact.FreeSeatscomment (PR #436) — and on cairn-site, including the factually false pricing bullet "at or under 50 users never contact us — not even with a key installed" (cairn-site PR #20). Historical CHANGELOG entries (v0.3.2) carry supersession notes rather than rewrites (PR #435).Full arc: v0.6.129 seat lifecycle (90-day window, last-seen refresh, Seats tab, audited release), v0.6.130/131 layout fixes, v0.6.132 payload slim — all live on both dogfoods, docs coherent across handbook, ARCHITECTURE, site, and wikis.