ids.alfacom.it/attached_assets
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
..
IDF_1762852265179.zip Initial commit 2025-11-11 09:12:13 +00:00
IDF_1762852276874.zip Initial commit 2025-11-11 09:12:13 +00:00
Pasted-5-34-05-PM-express-POST-api-ml-train-200-in-6ms-message-Training-avviato-in-background-m-1763742923159_1763742923159.txt Fix error when fetching router and stats information 2025-11-21 16:35:52 +00:00
Pasted--5-37-12-PM-express-POST-api-ml-train-200-in-5ms-message-Training-avviato-in-background-1763743249260_1763743249260.txt Fix database connection errors and schema issues 2025-11-21 16:41:55 +00:00
Pasted--crontab-u-ids-l-SISTEMA-IDS-CONFIGURAZIONE-AUT-1763454150778_1763454150778.txt Add automated training and detection jobs to the system 2025-11-18 08:24:09 +00:00
Pasted--fix-postgresql-auth-sh-PostgreSQL-Authentic-1763396674149_1763396674149.txt Fix PostgreSQL authentication issues for user access 2025-11-17 16:25:32 +00:00
Pasted--Fri-Nov-21-16-46-54-CET-2025-Frontend-Node-NON-attivo-riavvio-Fri-Nov-21-16-46-56-CET-2025-1763740277999_1763740277999.txt Fix frontend startup to correctly load environment variables 2025-11-21 15:52:15 +00:00
Pasted--INFO-Processate-16200-righe-salvate-0-log-INFO-Processate-16300-righe-salvate-0-log-INFO-Pro-1763400819071_1763400819072.txt Update logs to show processing progress 2025-11-17 17:34:04 +00:00
Pasted--ls-la-opt-ids-env-rw-r-r-1-ids-ids-351-Nov-17-17-23-opt-ids-env-root-ids-python-ml-cat-1763397713887_1763397713887.txt Update system to correctly process log files with proper permissions 2025-11-17 16:42:42 +00:00
Pasted--python3-11-main-py-8-60594-root-ids-python-ml-Starting-IDS-API-on-http-0-0-0-0-8000-Do-1763402969617_1763402969617.txt Improve log processing and add automated tasks 2025-11-17 18:11:49 +00:00
Pasted--sudo-u-postgres-psql-c-ALTER-SYSTEM-SET-password-encryption-scram-sha-256-ALTER-SYSTEM-ro-1763396856799_1763396856799.txt Configure database user and password for secure access 2025-11-17 16:28:10 +00:00
Pasted--update-from-git-sh-db-AGGIORNAMENTO-SI-1763735466753_1763735466754.txt Update system to apply database changes and synchronize dependencies 2025-11-21 14:31:40 +00:00
Pasted--VERIFICA-SISTEMA-Log-backend-tail-f-var-log-ids-backend-log-Log-frontend-tail-f--1763740954834_1763740954834.txt Adapt database connection for local and cloud environments 2025-11-21 16:09:48 +00:00
Pasted-cat-cron-log-mkdir-cannot-create-directory-var-run-ids-Permission-denied-opt-ids-deployment-ch-1763454557321_1763454557321.txt Improve system stability by fixing cron job and process monitoring 2025-11-18 08:33:05 +00:00
Pasted-cat-opt-ids-env-grep-DATABASE-URL-DATABASE-URL-postgresql-ids-user-TestPassword123-127-0-0-1-5-1763740601496_1763740601496.txt Improve how the application starts to ensure environment variables are loaded correctly 2025-11-21 15:58:17 +00:00
Pasted-cat-training-log-Traceback-most-recent-call-last-File-string-line-1-in-module-ModuleNot-1763454497801_1763454497801.txt Improve system stability by fixing cron job and process monitoring 2025-11-18 08:33:05 +00:00
Pasted-curl-http-localhost-8000-stats-2-1-logs-total-139583988-last-hour-7497648-detections--1763450777277_1763450777277.txt Add ability to detect and block malicious network traffic based on risk 2025-11-18 07:31:39 +00:00
Pasted-head-20-var-log-mikrotik-raw-log-Nov-17-16-52-16-FIBRA-forward-in-sfp-sfpplus1-VS-FTTO-out-sfp-sf-1763400878278_1763400878278.txt Update log parsing to better identify network traffic and DDoS events 2025-11-17 17:35:37 +00:00
Pasted-pkill-f-syslog-parser-root-ids-python-ml-sudo-u-ids-nohup-python3-11-syslog-parser-py-var-lo-1763401177900_1763401177900.txt Fix error when saving network logs to the database 2025-11-17 17:40:22 +00:00
Pasted-psql-DATABASE-URL-EOF-Conta-record-in-ogni-tabella-SELECT-network-logs-as-table-name-COU-1763743634660_1763743634660.txt Implement automatic database cleanup and schema updates 2025-11-21 16:49:13 +00:00
Pasted-psql-h-127-0-0-1-U-ids-user-d-ids-database-c-SELECT-COUNT-AS-totale-log-FROM-network-logs--1763401984485_1763401984485.txt Improve intrusion detection system with functional updates and database fixes 2025-11-17 17:54:18 +00:00
Pasted-sudo-cp-var-lib-pgsql-data-pg-hba-conf-var-lib-pgsql-data-pg-hba-conf-backup-manual-root-ids-pyth-1763397517711_1763397517711.txt Improve database connection security and restart log parser 2025-11-17 16:39:09 +00:00
Pasted-tail-30-var-log-ids-frontend-log-5-16-03-PM-express-GET-api-ml-stats-304-in-15ms-logs-t-1763742178598_1763742178598.txt Fix database connection errors and improve logging 2025-11-21 16:25:32 +00:00
Pasted-tail-50-var-log-cron-Nov-18-08-50-01-ids-CROND-78427-ids-CMD-cd-opt-ids-python-ml-usr-bi-1763454586967_1763454586967.txt Improve system stability by fixing cron job and process monitoring 2025-11-18 08:33:05 +00:00