Files
cairnobs/internal/state/agents.go
T
jcoffey-dev db156c4f06
release / release (push) Successful in 7m6s
Cairn OBS
The new Cairn OBS: a self-hosted monitor for networks, hosts and
services. Licensed AGPLv3.
2026-11-14 03:27:09 -07:00

102 lines
2.9 KiB
Go

package state
import (
"database/sql"
"errors"
"time"
)
// Agent certificates: every one obs-beacond's agent CA has signed. An agent
// has at most one live certificate; enrolling again or renewing revokes the
// one before it.
const agentsSchema = `
CREATE TABLE IF NOT EXISTS agent_certs (
serial TEXT PRIMARY KEY,
agent TEXT NOT NULL,
issued INTEGER NOT NULL,
not_after INTEGER NOT NULL,
revoked INTEGER
);
CREATE INDEX IF NOT EXISTS agent_certs_agent ON agent_certs (agent);
`
// metaAgentCA holds the agent CA (certificate and key, PEM), sealed.
const metaAgentCA = "agent_ca"
// AgentCA returns the stored agent CA, unsealed; nil when there is none yet.
func (d *DB) AgentCA() ([]byte, error) {
v := d.Meta(metaAgentCA)
if v == "" {
return nil, nil
}
b, err := d.Unseal(v)
if err != nil {
return nil, errors.New("the agent CA can't be unsealed: is state_key_file the key this database was made with? " +
"If that key is lost, see docs/formats.md (State) to start a new agent CA")
}
return b, nil
}
// SetAgentCA stores the agent CA, sealed.
func (d *DB) SetAgentCA(pem []byte) error { return d.SetMeta(metaAgentCA, d.Seal(pem)) }
// AgentCert is one certificate the CA signed for an agent.
type AgentCert struct {
Serial string
Agent string
Issued time.Time
NotAfter time.Time
Revoked time.Time // zero while live
}
// IssueAgentCert records a new certificate for an agent and revokes every
// other live certificate it has, in one transaction.
func (d *DB) IssueAgentCert(c AgentCert) error {
tx, err := d.begin()
if err != nil {
return err
}
defer func() { _ = tx.Rollback() }()
if _, err := tx.Exec(`UPDATE agent_certs SET revoked = ? WHERE agent = ? AND revoked IS NULL`, c.Issued.Unix(), c.Agent); err != nil {
return err
}
if _, err := tx.Exec(`INSERT INTO agent_certs (serial, agent, issued, not_after) VALUES (?, ?, ?, ?)`,
c.Serial, c.Agent, c.Issued.Unix(), c.NotAfter.Unix()); err != nil {
return err
}
return tx.Commit()
}
// AgentCertLive says whether serial is the agent's live certificate.
func (d *DB) AgentCertLive(serial, agent string) (bool, error) {
var revoked sql.NullInt64
err := d.queryRow(`SELECT revoked FROM agent_certs WHERE serial = ? AND agent = ?`, serial, agent).Scan(&revoked)
if errors.Is(err, sql.ErrNoRows) {
return false, nil
}
if err != nil {
return false, err
}
return !revoked.Valid, nil
}
// LiveAgentCerts lists every agent's live certificate.
func (d *DB) LiveAgentCerts() ([]AgentCert, error) {
rows, err := d.query(`SELECT serial, agent, issued, not_after FROM agent_certs WHERE revoked IS NULL ORDER BY agent`)
if err != nil {
return nil, err
}
defer rows.Close()
out := []AgentCert{}
for rows.Next() {
var c AgentCert
var issued, notAfter int64
if err := rows.Scan(&c.Serial, &c.Agent, &issued, &notAfter); err != nil {
return nil, err
}
c.Issued, c.NotAfter = time.Unix(issued, 0), time.Unix(notAfter, 0)
out = append(out, c)
}
return out, rows.Err()
}