Repository Public
1package audit_test23import (4 "context"5 "net/netip"6 "sync"7 "testing"89 "github.com/google/uuid"1011 "clustr.spboucher.ai/mcc/internal/audit"12 "clustr.spboucher.ai/mcc/internal/testdb"13)1415func TestChainAppendVerifyAndTamperDetection(t *testing.T) {16 pool, _ := testdb.New(t)17 ctx := context.Background()18 ip := netip.MustParseAddr("192.0.2.7")19 actor := uuid.New()2021 // Concurrent writers must still produce one consistent chain.22 var wg sync.WaitGroup23 for i := 0; i < 24; i++ {24 wg.Add(1)25 go func(i int) {26 defer wg.Done()27 _, err := audit.Append(ctx, pool, audit.Entry{ActorKind: "user", ActorID: &actor, ActorLabel: "tester", IP: &ip,28 Action: "test.event", TargetKind: "node", TargetID: "n1", Outcome: audit.Success,29 Params: map[string]any{"i": i, "nested": map[string]any{"refresh_token": "abc", "b": 1.5}, "password": "hunter2"}})30 if err != nil {31 t.Errorf("append: %v", err)32 }33 }(i)34 }35 wg.Wait()3637 res, err := audit.Verify(ctx, pool)38 if err != nil || !res.OK || res.Entries != 24 {39 t.Fatalf("verify: %+v err=%v", res, err)40 }4142 // Secrets never reach the table.43 var leaked int44 pool.QueryRow(ctx, `select count(*) from audit_log where params::text like '%hunter2%' or params::text like '%"abc"%'`).Scan(&leaked)45 if leaked != 0 {46 t.Fatalf("%d entries leaked a secret-looking value", leaked)47 }4849 // The table refuses modification through normal SQL.50 if _, err := pool.Exec(ctx, `update audit_log set detail='x' where seq=3`); err == nil {51 t.Fatal("update must be refused")52 }53 if _, err := pool.Exec(ctx, `delete from audit_log where seq=3`); err == nil {54 t.Fatal("delete must be refused")55 }56 if _, err := pool.Exec(ctx, `truncate audit_log`); err == nil {57 t.Fatal("truncate must be refused")58 }5960 // A privileged attacker who disables the trigger is still detected by the chain.61 if _, err := pool.Exec(ctx, `alter table audit_log disable trigger audit_no_update`); err != nil {62 t.Fatal(err)63 }64 if _, err := pool.Exec(ctx, `update audit_log set outcome='denied' where seq=5`); err != nil {65 t.Fatal(err)66 }67 res, _ = audit.Verify(ctx, pool)68 if res.OK || res.BrokenSeq != 5 {69 t.Fatalf("tampering not detected: %+v", res)70 }71 pool.Exec(ctx, `update audit_log set outcome='success' where seq=5`)72 if res, _ = audit.Verify(ctx, pool); !res.OK {73 t.Fatalf("restored chain should verify: %+v", res)74 }75 if _, err := pool.Exec(ctx, `delete from audit_log where seq=7`); err != nil {76 t.Fatal(err)77 }78 if res, _ = audit.Verify(ctx, pool); res.OK || res.BrokenSeq != 8 {79 t.Fatalf("deletion not detected: %+v", res)80 }81}82