Commit Graph

  • 983552a442 fix(qualys/agents): message d'echec specifique selon cause reelle (DNS/TCP timeout/TCP refused/SSH auth) - plus de 'agent installe? OS supporte?' generique Admin MPCZ 2026-04-28 02:00:21 +0200
  • 532549072d fix(qualys/agents): lien fiche serveur 404 - remplace par recherche Qualys du host Admin MPCZ 2026-04-28 01:55:25 +0200
  • 767b33095a feat(qualys/agents): bloque troubleshooting pour Windows (route + bouton 'Non gere' dans table) Admin MPCZ 2026-04-28 01:48:32 +0200
  • eecb61c720 fix(qualys/agents): check service multi-format - SysV init francais (en cours d'execution / (pid X)) en plus de systemd active (running) Admin MPCZ 2026-04-28 01:45:48 +0200
  • f0043eb481 ui(qualys/agents): separation RHEL5 (early exit, decom) vs RHEL6 (agent legacy ok, CA bundle a jour) Admin MPCZ 2026-04-28 01:33:10 +0200
  • 4db0cf6a56 ui(qualys/agents): si OS EOL (RHEL 5/6) - affiche seule entree 'agent legacy, decom prevu', pas de warnings redondants Admin MPCZ 2026-04-28 01:31:25 +0200
  • b6a602e848 ui(qualys/agents): wording diag prudent (constat/hypothese/proposition vers ticket support, pas affirmer) Admin MPCZ 2026-04-28 01:27:42 +0200
  • 67bd3a02d6 ui(qualys/agents): bloc Etat checklist OK/KO en tete (connectivite/disque/service/install) + log systeme 10 lignes Admin MPCZ 2026-04-28 01:24:57 +0200
  • 7f8c2c710b ui(qualys/agents): renomme 'Suggestions' en 'Diagnostic' + reformulation orientee constat (pas de cmds shell, oriente vers ticket support) Admin MPCZ 2026-04-28 01:23:56 +0200
  • 5abc474805 perf(qualys/agents): combine toutes les cmds en 1 seul channel SSH avec markers - evite Timeout opening channel sur PSMP Admin MPCZ 2026-04-28 01:18:59 +0200
  • d4205fb8f8 fix(qualys/agents): retry avec reconnect SSH si Timeout opening channel (limite channels PSMP) Admin MPCZ 2026-04-28 01:14:03 +0200
  • fc480b4376 ui(qualys/agents): retire bloc Configuration proxy agent (inutile car SANEF prod sort en direct, pas via proxy) Admin MPCZ 2026-04-28 01:13:18 +0200
  • 49c700c5d1 fix(qualys/agents): procedure reinstall reelle SANEF (rpm -ivh /root/QualysCloudAgent.rpm) Admin MPCZ 2026-04-28 00:58:45 +0200
  • 79cff850d3 feat(qualys/agents): suggestion auto pour install cassee (core dump + package absent RPM/DPKG) Admin MPCZ 2026-04-28 00:57:06 +0200
  • fb448257a1 ui(qualys/agents): connectivite minimale - HTTP code recu = OK, diag detaille seulement si KO Admin MPCZ 2026-04-28 00:52:17 +0200
  • c54ec0ba0c fix(qualys/agents): test connectivite DIRECT vers qagpublic.qg1.apps.qualys.eu (pod EU1 SANEF) - pas de proxy car agent sort en direct Admin MPCZ 2026-04-28 00:26:29 +0200
  • 9d312f43a3 feat(qualys/agents): check conf proxy agent (qagent-proxy.conf, drop-in systemd, sysconfig, /etc/environment) + suggestion config proxy Admin MPCZ 2026-04-28 00:20:56 +0200
  • 191c167423 fix(qualys/agents): snapshot vCenter (pas LVM) pour rollback avant extend FS Admin MPCZ 2026-04-28 00:15:12 +0200
  • 640292c1ce feat(qualys/agents): checks LVM + logrotate + suggestions extend FS / cleanup / fix logrotate avec snapshot LVM obligatoire Admin MPCZ 2026-04-28 00:11:45 +0200
  • b81343d5ca fix(qualys/agents): test connectivite via proxy SANEF (proxy.sanef.fr:8080, fallback IP 10.40.10.225) + suggestion conf agent Admin MPCZ 2026-04-28 00:06:32 +0200
  • 71a2927e15 ui(qualys/agents): highlight rouge >=90% / orange >=75% sur lignes df dans bloc disque Admin MPCZ 2026-04-28 00:01:46 +0200
  • a877589cf3 feat(qualys/agents): suggestions auto resolution selon patterns logs (disque sature, crash loop, conn KO, service masked, agent obsolete) Admin MPCZ 2026-04-28 00:01:14 +0200
  • 54a2a59991 ui(qualys/agents): renomme bouton Check en Troubleshooting Admin MPCZ 2026-04-27 23:54:29 +0200
  • 437b1ed172 feat(qualys/agents): ajout checks espace disque + connectivite console Qualys (qualysagent/qualysguard.qualys.eu) Admin MPCZ 2026-04-27 23:53:15 +0200
  • d9be39a037 fix(qualys/agents): sudo -n explicite pour lire logs Qualys (fichiers root-only) + fallback messages 'existe mais non lisible' Admin MPCZ 2026-04-27 23:39:53 +0200
  • cdcb85917d feat(qualys/agents): audit en background thread + page d'attente auto-refresh (fix ERR_CONNECTION_RESET sur audits longs) Admin MPCZ 2026-04-27 23:25:50 +0200
  • 26e05d63ac fix(qualys/agents): commandes audit adaptees multi-OS (RHEL5 SysV init, journalctl absent, chemins log Qualys multiples) Admin MPCZ 2026-04-27 23:15:50 +0200
  • 03229d4d08 feat(qualys/agents): bouton Check + page audit cible Qualys agent (status + version + logs agent/systeme via SSH) Admin MPCZ 2026-04-27 23:09:05 +0200
  • dc9c197274 fix(qualys/dashboard): timeout 120s->300s + log erreurs sur _fetch_asset_ids_by_tag (manque ENV-PRD/REC sur gros tags) Admin MPCZ 2026-04-27 23:00:58 +0200
  • 5ec5271232 perf(qualys/dashboard): parallelise fetch vulns par batch IPs (8 workers, ~18min -> ~3min) Admin MPCZ 2026-04-27 17:15:44 +0200
  • ad630eba99 feat(qualys/agents): tri click-to-sort sur toutes les tables (hostname, OS, check-in, etc.) Admin MPCZ 2026-04-27 16:57:56 +0200
  • f32c247bf4 migrate: ajout GRANT + ALTER DEFAULT PRIVILEGES pour user patchcenter (idempotent) Admin MPCZ 2026-04-27 13:44:45 +0000
  • 19ab837e12 migrate: 7 tables manquantes pour sync DB locale dev (chassis, hypervisors, qualys_missing_servers, qualys_vuln_snapshot*, secops_duty, server_databases) Admin MPCZ 2026-04-27 12:40:01 +0000
  • a3f1aaea63 migrate: ajout DDL tables qualys_vuln_dashboard (alignement sync SANEF) Admin MPCZ 2026-04-27 09:19:12 +0000
  • 4bc9d6cc61 docs(qualys/duplicates): message bandeau ~1200 serveurs Admin MPCZ 2026-04-25 19:56:51 +0000
  • 0d4ce6dfc2 feat(qualys/duplicates): scan filtre Linux+Windows Server uniquement (~1200 vs 6244) Admin MPCZ 2026-04-25 19:56:23 +0000
  • 2c5c0df355 docs(qualys/duplicates): clarifie message bandeau (6000 scan total, 1300 serveurs filtres) Admin MPCZ 2026-04-25 11:05:36 +0000
  • 6c52d05393 fix(qualys/duplicates): renomme cle items -> groups (conflit Jinja avec dict.items) Admin MPCZ 2026-04-25 10:49:53 +0000
  • cc550c2d84 fix(qualys/duplicates): scan async (background thread) + bandeau scan en cours - evite 503 HAProxy Admin MPCZ 2026-04-25 10:31:07 +0000
  • e832381b68 feat(qualys/duplicates): filtre serveurs uniquement (exclut Win 10/11/7/8/XP postes) Admin MPCZ 2026-04-25 10:23:14 +0000
  • 3d043af194 feat(qualys): page doublons + suppression API Qualys 1-clic Admin MPCZ 2026-04-25 10:17:40 +0000
  • 8f406f211d feat(qualys/dashboard): compute v2 - interroge API Qualys par tag (DB locale qualys_asset_tags souvent obsolete) Admin MPCZ 2026-04-25 00:42:29 +0000
  • 54c10d90de fix(qualys/dashboard): bandeau plus voyant (gradient cyan + glow) Admin MPCZ 2026-04-25 00:27:01 +0000
  • 66558c4b46 fix(qualys/dashboard): compteur base sur running_since DB (survit aux auto-refresh) Admin MPCZ 2026-04-25 00:16:44 +0000
  • 0ab4f2d8fa fix(qualys/dashboard): vire flag in-memory + safety net thread + flex layout 6 KPI Admin MPCZ 2026-04-25 00:13:22 +0000
  • 34cca6f77b fix(qualys/dashboard): user est un dict, utiliser user.get(sub) au lieu de .username Admin MPCZ 2026-04-25 00:09:15 +0000
  • 9a7f446637 fix(qualys/dashboard): insert pending row dans la route avant spawn thread (no race) Admin MPCZ 2026-04-25 00:07:22 +0000
  • daf87891a7 feat(qualys/dashboard): is_running base sur DB (multi-worker safe) + bouton Annuler Admin MPCZ 2026-04-25 00:05:49 +0000
  • 17f508c1d1 feat(qualys/dashboard): bandeau spinner persistant + auto-refresh pendant recalcul Admin MPCZ 2026-04-24 23:55:24 +0000
  • 8f8e8c4d8f feat(qualys): dashboard vulnerabilites avec KPI + historique Admin MPCZ 2026-04-24 23:49:46 +0000
  • b06aedfc3b fix(qualys): force vuln cache refresh on bulk resync redirect Admin MPCZ 2026-04-24 22:51:11 +0000
  • 392c8f4fe5 fix(qualys/search): KPI vuln_map est dict total/severityN, pas int Admin MPCZ 2026-04-24 22:34:16 +0000
  • 3c00f05263 feat(qualys/agents): colonne Version OS dans table sans-agent Admin MPCZ 2026-04-24 22:30:39 +0000
  • c57ef61adb feat(qualys/search): KPI total/avec-vuln/sans-vuln + filtre vuln_filter Admin MPCZ 2026-04-24 22:27:55 +0000
  • 5d421dcd28 docs: move DEPLOY/PROCESS to docs/, enrich README, fix generate_ppt.py output path Admin MPCZ 2026-04-24 14:12:27 +0200
  • c258d6091a fix(qualys): resync_all_tags HTTP 400 - limitResults 10000 trop grand, capper a 1000 Admin MPCZ 2026-04-23 12:19:31 +0000
  • 5fedfb5f80 Add page Tour de garde SecOps : import xlsx + table + vue hebdo + competences Admin MPCZ 2026-04-17 23:39:11 +0000
  • 803016458d Doc: algorithme detaille processus patching SANEF (12 sections) Admin MPCZ 2026-04-17 23:32:04 +0000
  • 9a72fa7eb7 Optim: fix N+1 queries itop_service (pre-load batch) + macros Jinja2 badges Admin MPCZ 2026-04-17 23:23:32 +0000
  • a0f90cd719 Optim: logging structure + query_helpers.py + fix exceptions silencieuses routers Admin MPCZ 2026-04-17 23:19:18 +0000
  • 9097872e57 Secu: verif permissions can_view/can_edit sur endpoints HTMX detail/edit Admin MPCZ 2026-04-17 23:15:04 +0000
  • 89f069ddcc import_plan_patching: skip lignes avec date future (cellules coloriees a l avance) Admin MPCZ 2026-04-17 12:44:27 +0000
  • 2bf2fa5042 patch_history: tolere parametres vides dans les filtres (week=, source=, etc.) Admin MPCZ 2026-04-17 12:42:58 +0000
  • 402ed36407 import_ldap_group_users : ne reactive plus les users desactives manuellement Admin MPCZ 2026-04-17 12:32:46 +0000
  • 81227833c1 Add link_patch_history_intervenants : lie patch_history.intervenant_name -> users.id (FK) Admin MPCZ 2026-04-17 12:31:40 +0000
  • 7ec7c49c34 import_ldap_group_users : fallback UPN/sam@sanef.com si mail absent, inclut comptes admin sans mail Admin MPCZ 2026-04-17 12:26:12 +0000
  • 2a4c785535 Add import_ldap_group_users + FK users.contact_id + contacts.ldap_dn Admin MPCZ 2026-04-17 12:16:24 +0000
  • 2ab2ceabba Historique patching : filtres OS/zone/domaine/intervenant + colonnes table Admin MPCZ 2026-04-17 12:10:45 +0000
  • 14f809335e Add tool import_plan_patching_xlsx : historique 2025+2026 (vert = patche) Admin MPCZ 2026-04-17 11:56:32 +0000
  • cfb9cf865c Register patch_history router in main.py Admin MPCZ 2026-04-17 09:41:14 +0000
  • 4b1794d4d1 Add page Historique patching : vue unifiee import xlsx + campagnes + quickwin Admin MPCZ 2026-04-17 08:47:25 +0000
  • c9890a274f Add tools/import_planning_xlsx.py : import patch_planning depuis xlsx Ayoub Admin MPCZ 2026-04-17 08:32:56 +0000
  • e2fb34f115 Sync SANEF : audit_service + schema.sql + data deploy + gitignore sql-db-snapshot-20260417 db-snapshot-20260417 MOUTAOUAKIL-ext Khalid 2026-04-17 09:20:57 +0200
  • 1c661e2dc5 qualys_tags: respect qualys_bypass_proxy flag Admin MPCZ 2026-04-17 00:28:57 +0200
  • 617bf94e31 Qualys agents sync: optims perf majeures (~3-5x plus rapide) Admin MPCZ 2026-04-16 23:34:51 +0200
  • 55cd35eaf1 import_applications_ioda: gestion conflits nom_court (UNIQUE existant) Admin MPCZ 2026-04-16 14:21:37 +0200
  • 34c8025b56 import_applications_ioda: cast str() pour cellules non-string (int) Admin MPCZ 2026-04-16 14:19:29 +0200
  • b55e8d4e26 Import IODA applications + table qualys_missing_servers Admin MPCZ 2026-04-16 13:59:53 +0200
  • f1a1ca9c7b Qualys Tags V3: unescape entites XML dans ruleText/name Admin MPCZ 2026-04-15 15:40:04 +0200
  • 79a2cc896e Qualys diff: format ISO sans microsec YYYY-MM-DDTHH:MM:SSZ (compat API QPS) Admin MPCZ 2026-04-15 14:28:57 +0200
  • 7924e64616 Qualys diff: filtre 'updated' (searchable) au lieu de 'lastCheckedIn' (non recunu API) Admin MPCZ 2026-04-15 14:06:27 +0200
  • 8b212df7a1 Qualys 'sans agent': match via server_id (couvre alias hostname Qualys != iTop) Admin MPCZ 2026-04-15 13:54:07 +0200
  • 245777fd46 Qualys agents: exclut Win10/11/Workstation de la liste 'Sans agent' Admin MPCZ 2026-04-15 13:49:05 +0200
  • 4a5a1f6716 Qualys: bouton Sync complete vert (#22c55e) bien visible Admin MPCZ 2026-04-15 13:42:58 +0200
  • 6824fee081 Qualys deploy UI: ActivationId/CustomerId masques (type password) + toggle œil Admin MPCZ 2026-04-15 13:37:15 +0200
  • a3a1ec7e6d Qualys deploy: bouton 'Sauvegarder ces valeurs' (ActivationId/Customer/Uri persistes) Admin MPCZ 2026-04-15 13:34:24 +0200
  • 0ebf72d789 Qualys diff sync: sauve le timestamp DES LE DEBUT (resilient si annulation) Admin MPCZ 2026-04-15 13:29:36 +0200
  • 5b6e113792 Qualys deploy: filtre s.os_family=linux + retire dropdown OS du UI Admin MPCZ 2026-04-15 13:18:09 +0200
  • 206cc813f6 Qualys deploy: simplifie UI = ActivationId Linux uniquement (Windows hidden, persiste backend) Admin MPCZ 2026-04-15 13:14:23 +0200
  • 55d08921f9 Qualys deploy: persiste activation_ids/customer/uri en secrets + selection auto Linux/Windows Admin MPCZ 2026-04-15 13:12:15 +0200
  • f59c6dcbdb Qualys deploy: 2 dropdowns ActivationId Linux et Windows (separes) Admin MPCZ 2026-04-15 13:04:34 +0200
  • 0095f7914f Qualys deploy: POD SANEF = QG1 par defaut (pas QG2) Admin MPCZ 2026-04-15 13:00:45 +0200
  • 2972baca1f Qualys deploy: dropdown ActivationId depuis API + ServerUri auto-deduit URL Qualys Admin MPCZ 2026-04-15 12:53:18 +0200
  • 935c8003b4 Qualys sync: retry 3x avec backoff sur erreurs transitoires proxy/reseau Admin MPCZ 2026-04-15 12:44:49 +0200
  • 9e03fd84c0 Qualys tags page: bandeau sync en cours + bouton Resync API disable Admin MPCZ 2026-04-15 12:39:40 +0200
  • 48249d1c82 Qualys agents page: bandeau sync en cours + boutons sync desactives + bouton Annuler Admin MPCZ 2026-04-15 12:37:49 +0200
  • 1dc7560f44 Qualys tags resync: message clair si busy + erreur API detaillee Admin MPCZ 2026-04-15 12:35:34 +0200
  • a62f9a4146 Qualys sync dual mode: diff (rapide, lastCheckedIn) + full (complet) Admin MPCZ 2026-04-15 12:33:48 +0200
  • 55f81de986 Qualys sync: fallback matching par IP integrer si hostname ne match pas Admin MPCZ 2026-04-15 12:25:27 +0200
  • 36c638c8ce Add link_qualys_by_ip: lie qualys_assets a servers via IP quand hostname mismatch (cas node3->vdameasxt3) Admin MPCZ 2026-04-15 12:22:04 +0200