By creating this pull request, I grant the project maintainers an unlimited,
perpetual license to use, modify, and redistribute these contributions under any terms they
choose, including both the AGPLv3 and the Fossorial Commercial license terms. I
represent that I have the right to grant this license for all contributed content.
Description
Adds logging to the database and tables to show and export request logs, access logs, and action logs
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.
## 📋 Pull Request Information
**Original PR:** https://github.com/fosrl/pangolin/pull/1755
**Author:** [@oschwartz10612](https://github.com/oschwartz10612)
**Created:** 10/27/2025
**Status:** ✅ Merged
**Merged:** 10/27/2025
**Merged by:** [@oschwartz10612](https://github.com/oschwartz10612)
**Base:** `dev` ← **Head:** `audit-logs`
---
### 📝 Commits (10+)
- [`dce84b9`](https://github.com/fosrl/pangolin/commit/dce84b9b092bf87b4bda66741cdbf29e39d321e1) Add action audit middleware and tables
- [`1f50bc3`](https://github.com/fosrl/pangolin/commit/1f50bc3752d355c07f80ac9e7f90c09ccdb7f6f0) Add logActionAudit and query endpoint
- [`9a52d53`](https://github.com/fosrl/pangolin/commit/9a52d5387dbffedeced3fa740098c34dcce2d1e2) Merge branch 'dev' into audit-logs
- [`bc94123`](https://github.com/fosrl/pangolin/commit/bc941239ecc16c89ebd4ca804ae2696571845147) Fix the indexes
- [`1ee52ad`](https://github.com/fosrl/pangolin/commit/1ee52ad86b76c3e6a0e140e46294997db9301d00) Add headers
- [`58443ef`](https://github.com/fosrl/pangolin/commit/58443ef53fadfa3a7c5fca6ef98e05753cf681cd) Reorder log middleware
- [`f3149e4`](https://github.com/fosrl/pangolin/commit/f3149e46cd9d63cb8e3f8b4b3384a6751402d3f9) Starting to create frontend
- [`65364d6`](https://github.com/fosrl/pangolin/commit/65364d6b0ff7afe154b749daede0ac210b301114) Merge branch 'dev' into audit-logs
- [`9a64f45`](https://github.com/fosrl/pangolin/commit/9a64f458150b3932e588c6eb36f34897ae34f116) Basic log table there
- [`bdc3b24`](https://github.com/fosrl/pangolin/commit/bdc3b2425b52305e724959aa38b80dd3f346f892) Basic table working
### 📊 Changes
**59 files changed** (+6540 additions, -220 deletions)
<details>
<summary>View changed files</summary>
📝 `messages/en-US.json` (+52 -0)
📝 `package-lock.json` (+76 -1)
📝 `package.json` (+2 -0)
📝 `server/auth/actions.ts` (+3 -1)
📝 `server/db/pg/schema/privateSchema.ts` (+41 -1)
📝 `server/db/pg/schema/schema.ts` (+52 -2)
📝 `server/db/sqlite/schema/privateSchema.ts` (+42 -1)
📝 `server/db/sqlite/schema/schema.ts` (+61 -5)
📝 `server/index.ts` (+9 -6)
📝 `server/lib/billing/getOrgTierData.ts` (+2 -2)
➕ `server/lib/cleanupLogs.ts` (+62 -0)
📝 `server/lib/geoip.ts` (+1 -1)
📝 `server/middlewares/index.ts` (+1 -0)
➕ `server/middlewares/logActionAudit.ts` (+12 -0)
➕ `server/private/lib/logAccessAudit.ts` (+157 -0)
📝 `server/private/lib/traefik/getTraefikConfig.ts` (+1 -1)
📝 `server/private/middlewares/index.ts` (+2 -1)
➕ `server/private/middlewares/logActionAudit.ts` (+145 -0)
➕ `server/private/middlewares/verifySubscription.ts` (+50 -0)
➕ `server/private/routers/auditLogs/exportAccessAuditLog.ts` (+81 -0)
_...and 39 more files_
</details>
### 📄 Description
## Community Contribution License Agreement
By creating this pull request, I grant the project maintainers an unlimited,
perpetual license to use, modify, and redistribute these contributions under any terms they
choose, including both the AGPLv3 and the Fossorial Commercial license terms. I
represent that I have the right to grant this license for all contributed content.
## Description
Adds logging to the database and tables to show and export request logs, access logs, and action logs
---
<sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/fosrl/pangolin/pull/1755
Author: @oschwartz10612
Created: 10/27/2025
Status: ✅ Merged
Merged: 10/27/2025
Merged by: @oschwartz10612
Base:
dev← Head:audit-logs📝 Commits (10+)
dce84b9Add action audit middleware and tables1f50bc3Add logActionAudit and query endpoint9a52d53Merge branch 'dev' into audit-logsbc94123Fix the indexes1ee52adAdd headers58443efReorder log middlewaref3149e4Starting to create frontend65364d6Merge branch 'dev' into audit-logs9a64f45Basic log table therebdc3b24Basic table working📊 Changes
59 files changed (+6540 additions, -220 deletions)
View changed files
📝
messages/en-US.json(+52 -0)📝
package-lock.json(+76 -1)📝
package.json(+2 -0)📝
server/auth/actions.ts(+3 -1)📝
server/db/pg/schema/privateSchema.ts(+41 -1)📝
server/db/pg/schema/schema.ts(+52 -2)📝
server/db/sqlite/schema/privateSchema.ts(+42 -1)📝
server/db/sqlite/schema/schema.ts(+61 -5)📝
server/index.ts(+9 -6)📝
server/lib/billing/getOrgTierData.ts(+2 -2)➕
server/lib/cleanupLogs.ts(+62 -0)📝
server/lib/geoip.ts(+1 -1)📝
server/middlewares/index.ts(+1 -0)➕
server/middlewares/logActionAudit.ts(+12 -0)➕
server/private/lib/logAccessAudit.ts(+157 -0)📝
server/private/lib/traefik/getTraefikConfig.ts(+1 -1)📝
server/private/middlewares/index.ts(+2 -1)➕
server/private/middlewares/logActionAudit.ts(+145 -0)➕
server/private/middlewares/verifySubscription.ts(+50 -0)➕
server/private/routers/auditLogs/exportAccessAuditLog.ts(+81 -0)...and 39 more files
📄 Description
Community Contribution License Agreement
By creating this pull request, I grant the project maintainers an unlimited,
perpetual license to use, modify, and redistribute these contributions under any terms they
choose, including both the AGPLv3 and the Fossorial Commercial license terms. I
represent that I have the right to grant this license for all contributed content.
Description
Adds logging to the database and tables to show and export request logs, access logs, and action logs
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.