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

83 Commits

Author SHA1 Message Date
marco370
1b9df79d56 Add IP geolocation and AS information to detection records 
Integrates IP geolocation and Autonomous System (AS) information into detection records by modifying the frontend to display this data and updating the backend to perform asynchronous batch lookups for efficiency. This enhancement includes database schema updates and the creation of a new IP geolocation service.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: e81fd4a1-b7b0-48d2-ae38-f5905e278343
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/SXFWABi
 2025-11-22 10:59:50 +00:00
Marco Lanzara
3f934b17ec 🚀 Release v1.0.40 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 10:41:13
 2025-11-22 10:41:13 +00:00
Marco Lanzara
06d6f47df1 🚀 Release v1.0.39 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 10:28:05
 2025-11-22 10:28:05 +00:00
Marco Lanzara
88004cb7ec 🚀 Release v1.0.38 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 10:22:46
 2025-11-22 10:22:46 +00:00
Marco Lanzara
83f3d4cf8e 🚀 Release v1.0.37 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 10:15:49
 2025-11-22 10:15:49 +00:00
marco370
e6fb3aefe3 Fix monitoring errors and database inconsistencies on the dashboard 
Fix critical bugs in the Syslog Parser monitoring endpoint fetch and update database schema for network logs.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: a6dcc6ae-9272-494e-a68e-a0a2b865f1c4
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/VDRknFA
 2025-11-22 10:15:19 +00:00
Marco Lanzara
e7afa6dafb 🚀 Release v1.0.36 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 10:03:51
 2025-11-22 10:03:51 +00:00
Marco Lanzara
9458829ebf 🚀 Release v1.0.35 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 09:58:38
 2025-11-22 09:58:38 +00:00
Marco Lanzara
8d4896df76 🚀 Release v1.0.34 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 09:53:48
 2025-11-22 09:53:48 +00:00
Marco Lanzara
58619ff79f 🚀 Release v1.0.33 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 09:34:19
 2025-11-22 09:34:19 +00:00
Marco Lanzara
27f475191e 🚀 Release v1.0.32 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 09:03:03
 2025-11-22 09:03:03 +00:00
marco370
495e845a79 Update log format to include timestamps and filter incoming connections 
Correct the rsyslog template to include timestamps in logs, ensuring compatibility with the Python parser. This change also refactors the log filtering to capture only incoming connections, significantly reducing log volume.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528
Replit-Commit-Checkpoint-Type: full_checkpoint
Replit-Commit-Event-Id: c2f849f9-105f-452a-bdc3-a956d102c54b
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/6ZTQSoP
 2025-11-22 08:54:21 +00:00
Marco Lanzara
5f82419240 🚀 Release v1.0.30 
- Tipo: patch
- Database schema: database-schema/schema.sql (solo struttura)
- Data: 2025-11-22 07:53:02
 2025-11-22 07:53:02 +00:00
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