marco/ids.alfacom.it
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
208 Commits 1 Branch 100 Tags 9.2 MiB
v1.0.73
Commit Graph

70 Commits

Author SHA1 Message Date
marco370
7b85fcc020 Implement a database versioning system to speed up updates 
Add a database versioning system that tracks applied migrations and only runs new ones, significantly improving update speed.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: ab56b852-52de-4cd1-a489-5cf48f3a2965
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/myJmPIa
 2025-11-22 07:51:56 +00:00
Marco Lanzara
79a37639e0 🚀 Release v1.0.29 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 07:41:57
 2025-11-22 07:41:57 +00:00
Marco Lanzara
39536b4f7a 🚀 Release v1.0.28 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 17:29:35
 2025-11-21 17:29:35 +00:00
Marco Lanzara
e957556af2 🚀 Release v1.0.27 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 16:58:21
 2025-11-21 16:58:21 +00:00
marco370
3e9b9f110a Improve environment variable loading for deployment scripts 
Update `apply_migrations.sh`, `cleanup_database.sh`, and `debug_system.sh` to robustly load environment variables from the `.env` file, ensuring correct `DATABASE_URL` availability and improving script execution reliability.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: b9098694-dc08-42d0-9fe9-48515e4e82a0
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/4LjHWWz
 2025-11-21 16:57:55 +00:00
Marco Lanzara
07f1895bbd 🚀 Release v1.0.26 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 16:50:22
 2025-11-21 16:50:22 +00:00
marco370
661e945f57 Implement automatic database cleanup and schema updates 
Adds scripts for automatic database log cleanup, schema migration application, and cron job setup. Modifies the update script to apply SQL migrations before pushing Drizzle schema.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: 9a659f15-d68a-4b7d-99f8-3eccc59afebe
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/4LjHWWz
 2025-11-21 16:49:13 +00:00
Marco Lanzara
dccfb4032a 🚀 Release v1.0.25 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 16:19:57
 2025-11-21 16:19:57 +00:00
Marco Lanzara
3076c7946b 🚀 Release v1.0.24 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 15:58:39
 2025-11-21 15:58:39 +00:00
Marco Lanzara
2041d3926f 🚀 Release v1.0.23 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 15:45:57
 2025-11-21 15:45:57 +00:00
Marco Lanzara
b158b56645 🚀 Release v1.0.22 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 15:37:36
 2025-11-21 15:37:36 +00:00
Marco Lanzara
40990d4ed7 🚀 Release v1.0.21 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 10:41:50
 2025-11-21 10:41:50 +00:00
Marco Lanzara
b9be5834dd 🚀 Release v1.0.20 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 09:14:18
 2025-11-21 09:14:18 +00:00
Marco Lanzara
84320a3c6f 🚀 Release v1.0.19 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-21 08:23:16
 2025-11-21 08:23:16 +00:00
Marco Lanzara
4c8872c1ef 🚀 Release v1.0.17 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-17 18:26:12
 2025-11-17 18:26:12 +00:00
marco370
253df0e6bc Add table for managing MikroTik router configurations 
Create a new SQL table named 'routers' to store MikroTik router configuration details, including IP addresses, credentials, and status, with example data.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: 4b47610c-d428-476f-95dd-d18864bbda27
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/1P26v7M
 2025-11-17 18:26:01 +00:00
marco370
0ab5e45413 Add database tables for storing detection, training, and whitelist information 
Create SQL schemas for `detections`, `training_history`, and `whitelist` tables to manage IDS data, model training logs, and trusted IPs.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: f93295bb-74e9-4b67-b3d7-05437cb8c23f
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/MkBJZ0L
 2025-11-17 18:03:30 +00:00
marco370
369c268bc1 Update deployment instructions and network log schema 
Refactor `replit.md` to include `./push-gitlab.sh` deployment. Update `shared/schema.ts` and `database-schema/create_network_logs.sql` to change `routerId` to `routerName` in `networkLogs`, remove the relation, and update fields like `destIp` to `destinationIp`, `bytes`/`packets` to `packetLength`, and add `rawMessage`.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: d2b716bd-04d1-48e8-b4e3-1e6d950d8a15
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/MkBJZ0L
 2025-11-17 17:42:17 +00:00
Marco Lanzara
c2dcb7bb79 🚀 Release v1.0.8 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-17 17:10:48
 2025-11-17 17:10:48 +00:00
marco370
3dc1397f20 Add ability to export database schema structure to Git 
Modify deploy-to-gitlab.sh to export database schema DDL to database-schema/schema.sql, update commit messages, and adjust versioning.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: 8bc17630-4554-4a5a-bac3-2cb45209a6fa
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/CGAMfXu
 2025-11-17 17:07:31 +00:00