dohertj2/mxaccessgw
1
0
Fork 0
Code Issues Pull Requests 1 Actions Packages Projects Releases Wiki Activity

Implement SQLite Auth Store And Migrations #5

New Issue
Closed
opened 2026-04-26 15:22:28 -04:00 by dohertj2 · 2 comments
dohertj2 commented 2026-04-26 15:22:28 -04:00
Owner
Copy Link
Copy Source

Source: $file
Milestone: $currentMilestone

Labels: area:auth, type:feature, priority:p0

Deliverables:

  • SQLite schema for schema_version, api_keys, and api_key_audit,
  • idempotent startup migrations,
  • newer-schema startup block,
  • key lookup and audit services.

Acceptance criteria:

  • empty DB initializes,
  • existing DB migrates,
  • newer DB version blocks startup,
  • revoked keys cannot authenticate.

Tests:

  • temp SQLite migration tests,
  • key lookup tests,
  • revoked key tests.
Source: $file Milestone: $currentMilestone Labels: `area:auth`, `type:feature`, `priority:p0` Deliverables: - SQLite schema for `schema_version`, `api_keys`, and `api_key_audit`, - idempotent startup migrations, - newer-schema startup block, - key lookup and audit services. Acceptance criteria: - empty DB initializes, - existing DB migrates, - newer DB version blocks startup, - revoked keys cannot authenticate. Tests: - temp SQLite migration tests, - key lookup tests, - revoked key tests.
dohertj2 added this to the gateway-auth milestone 2026-04-26 15:22:28 -04:00
dohertj2 added the area:authtype:featurepriority:p0 labels 2026-04-26 15:22:28 -04:00
dohertj2 added a new dependency 2026-04-26 15:28:32 -04:00
#1 Scaffold Gateway Solution And Projects
dohertj2 added a new dependency 2026-04-26 15:28:32 -04:00
#3 Add Gateway Configuration And Validation
dohertj2 added a new dependency 2026-04-26 15:28:32 -04:00
#6 Implement API Key Hashing And Verification
dohertj2 added a new dependency 2026-04-26 15:28:33 -04:00
#7 Implement Local API Key Admin CLI
dohertj2 added a new dependency 2026-04-26 15:28:33 -04:00
#8 Add gRPC Authentication And Scope Authorization
dohertj2 commented 2026-04-26 16:20:58 -04:00
Author
Owner
Copy Link
Copy Source

Worker 2 is taking this issue.

Branch: agent-2/issue-5-implement-sqlite-auth-store-and-migrations
Worktree: C:\Users\dohertj2\Desktop\mxaccessgw-agent-2

Worker 2 is taking this issue. Branch: agent-2/issue-5-implement-sqlite-auth-store-and-migrations Worktree: C:\Users\dohertj2\Desktop\mxaccessgw-agent-2
dohertj2 commented 2026-04-26 16:34:52 -04:00
Author
Owner
Copy Link
Copy Source

Implemented and merged via PR #56: #56

Commit: ec1155d
Merge commit on main: 420a813967
Branch: agent-2/issue-5-implement-sqlite-auth-store-and-migrations

Verification:

  • dotnet build src\MxGateway.sln passed with 0 warnings and 0 errors.
  • dotnet test src\MxGateway.sln passed: 49 total tests.

Acceptance criteria verified: empty DB initialization, migrations, newer-schema startup block, API key lookup, revoked key behavior, and audit persistence are covered by focused tests.

Implemented and merged via PR #56: https://gitea.dohertylan.com/dohertj2/mxaccessgw/pulls/56 Commit: ec1155d Merge commit on main: 420a8139679113eef5691565db7bb824dac25863 Branch: agent-2/issue-5-implement-sqlite-auth-store-and-migrations Verification: - dotnet build src\\MxGateway.sln passed with 0 warnings and 0 errors. - dotnet test src\\MxGateway.sln passed: 49 total tests. Acceptance criteria verified: empty DB initialization, migrations, newer-schema startup block, API key lookup, revoked key behavior, and audit persistence are covered by focused tests.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
area:auth
Authentication and authorization
 area:client-dotnet
.NET client library
 area:client-go
Go client library
 area:client-java
Java client library
 area:client-python
Python client library
 area:client-rust
Rust client library
 area:contracts
Protocol and generated contract work
 area:dashboard
Blazor dashboard work
 area:docs
Documentation
 area:gateway
Gateway server work
 area:tests
Automated and live tests
 area:worker
MXAccess worker process work
 blocked
Blocked by dependency
 priority:p0
Must-have / blocking
 priority:p1
High priority
 priority:p2
Normal priority
 type:docs
Documentation work
 type:feature
Feature implementation
 type:infra
Infrastructure and scaffolding
 type:test
Test work
No Label area:auth priority:p0 type:feature
Milestone
No items
No Milestone gateway-auth
Projects
Clear projects
No project
Assignees
Clear assignees
dohertj2 (dohertj2)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Blocks
#6 Implement API Key Hashing And Verification
dohertj2/mxaccessgw
#7 Implement Local API Key Admin CLI
dohertj2/mxaccessgw
#8 Add gRPC Authentication And Scope Authorization
dohertj2/mxaccessgw
Depends on
#1 Scaffold Gateway Solution And Projects
dohertj2/mxaccessgw
#3 Add Gateway Configuration And Validation
dohertj2/mxaccessgw
Reference: dohertj2/mxaccessgw#5
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?