SPB Git

Repository Public

audit_test.go 2.5 KB 82 lines go

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
Files main
Menu

Theme