[RISOLTO] Problema di Windows Update

Condividi qui i tuoi suggerimenti o problemi riguardanti la console WAPT o l'agente WAPT
Regole del forum
Regole del forum della community
* Supporto in inglese su www.reddit.com/r/wapt
* Supporto della community in francese disponibile su questo forum
* Si prega di anteporre [RISOLTO] al titolo dell'argomento se è stato risolto.
* Si prega di non modificare un argomento contrassegnato con [RISOLTO]. Aprire un nuovo argomento facendo riferimento a quello precedente.
* Specificare la versione di WAPT installata, la versione completa e il numero di build (2.2.1.11957 / 2.2.2.12337 / ecc.) nonché l'edizione Enterprise/Discovery.
* Le versioni 1.8.2 e precedenti non sono più supportate. Le uniche domande accettate relative alla versione 1.8.2 riguardano l'aggiornamento a una versione supportata (2.1, 2.2, ecc.).
* Specificare il sistema operativo del server (Linux/Windows) e la versione (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specificare il sistema operativo della macchina di amministrazione/creazione dei pacchetti e della macchina con l'agente problematico, se applicabile (Windows 7/10/11/Debian 11/ecc.).
* Evitare di porre più domande quando si apre una discussione, altrimenti potrebbe essere ignorata. Se ci sono più discussioni, aprirle separatamente, preferibilmente una dopo l'altra e non tutte contemporaneamente (ovvero, non intasare il forum).
* Includere frammenti di codice, screenshot e altre immagini direttamente nel post. I link a Pastebin, Bitly e altri siti di terze parti verranno sistematicamente rimossi.
* Come in qualsiasi forum della community, il supporto è fornito volontariamente dai membri. Se si necessita di supporto commerciale, è possibile contattare il reparto vendite di Tranquil IT al numero 02.40.97.57.55
Bloccato
Maxslg
Messaggi: 4
Registrazione: 22 giugno 2023 - 08:59

10 luglio 2023 - 10:10

Buongiorno,
Ho un problema con Windows Update di WAPT che non funziona.
Inizialmente ho provato a utilizzare un pacchetto wsus per sbloccare gli aggiornamenti, ma non ha funzionato.
Successivamente, ho eseguito il comando "wapt-get waptwa-scan" e ha restituito quanto segue:

Codice: Seleziona tutto

wapt-get waptwua-scan
Using config file: C:\Program Files (x86)\wapt\wapt-get.ini
2023-07-10 09:27:55,696 INFO User Groups:[]
2023-07-10 09:27:55,696 DEBUG Host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt not found, not using it for auth on repo global
2023-07-10 09:27:55,696 INFO WAPT base directory : C:\Program Files (x86)\wapt
2023-07-10 09:27:55,696 INFO Package cache dir : C:\Program Files (x86)\wapt\cache
2023-07-10 09:27:55,696 INFO WAPT DB Structure version: 20210420
2023-07-10 09:27:55,696 CRITICAL Bad persistent dir for package Maj windows
2023-07-10 09:27:55,696 CRITICAL Bad persistent dir for package wsus-all
Ensure wuauserv Auto Update option is disabled
Scanning with windows updates rules:
{
 "direct_download":false,
 "default_allow":false,
 "include_potentially_superseded_updates":false,
 "filter":"Type='Software' or Type='Driver'",
 "download_scheduling":"1d",
 "install_scheduling":"2h",
 "install_delay":"None",
 "postboot_delay":"10m"
}
2023-07-10 09:27:56,228 DEBUG Host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt not found, not using it for auth on repo wapt
2023-07-10 09:27:56,228 INFO Main repository: https://SRV-WAPT.mairie.mdm/wapt
2023-07-10 09:27:56,228 DEBUG Unable to get or create host key: [WinError 5] Accès refusé: 'C:\\Program Files (x86)\\wapt\\private\\03000200-0400-0500-0006-000700080009.pem'
2023-07-10 09:27:56,228 DEBUG Host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt not found, not using it for auth on repo wapt-host
2023-07-10 09:27:56,228 DEBUG Host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt not found, not using it for auth on repo waptwua
2023-07-10 09:27:56,228 INFO WAPTWUA repository: https://SRV-WAPT.mairie.mdm/wapt
2023-07-10 09:27:56,235 DEBUG Starting new HTTPS connection (1): srv-wapt.mairie.mdm:443
2023-07-10 09:27:56,281 DEBUG https://srv-wapt.mairie.mdm:443 "HEAD /waptwua/wsusscn2.cab HTTP/1.1" 200 0
2023-07-10 09:27:56,281 DEBUG New wsusscn2cab.cab date : 2023-06-13T04:25:13+00:00
Windows updates rules have been changed
2023-07-10 09:27:56,281 DEBUG Scanning installed / not installed Updates
2023-07-10 09:27:56,281 DEBUG DB Start transaction
2023-07-10 09:27:56,281 DEBUG DB rollback
2023-07-10 09:27:56,297 DEBUG Error at DB exit attempt to write a readonly database, rollbacking
['  File "C:\\Program Files (x86)\\wapt\\common.py", line 335, in set_param\n    self.execute(\'insert or replace into wapt_params(name,value,create_date,ptype) values (?,?,?,?)\', (name, value, datetime2isodate(), ptype))\n', '  File "C:\\Program Files (x86)\\wapt\\common.py", line 385, in execute\n    return self.db.execute(query, args)\n']
re-enabling wuauserv previous state: 2
FATAL ERROR : AttributeError: __enter__
Traceback (most recent call last):
  File "<string>", line 1495, in main
  File "C:\Program Files (x86)\wapt\waptwua\client.py", line 914, in scan_updates_status
    for update in self.updates():
  File "C:\Program Files (x86)\wapt\waptwua\client.py", line 801, in updates
    self.wapt.write_param('waptwua.status', 'SCANNING')
  File "C:\Program Files (x86)\wapt\common.py", line 8123, in write_param
    self.waptdb.set_param(name, value)
  File "C:\Program Files (x86)\wapt\common.py", line 335, in set_param
    self.execute('insert or replace into wapt_params(name,value,create_date,ptype) values (?,?,?,?)', (name, value, datetime2isodate(), ptype))
  File "C:\Program Files (x86)\wapt\common.py", line 385, in execute
    return self.db.execute(query, args)
sqlite3.OperationalError: attempt to write a readonly database

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<string>", line 1677, in <module>
  File "<string>", line 1496, in main
  File "C:\Program Files (x86)\wapt\setuphelpers_windows.py", line 2534, in __exit__
    registry_set(HKEY_LOCAL_MACHINE, r'SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update', 'AUOptions', self.old_au_options)
  File "C:\Program Files (x86)\wapt\setuphelpers_windows.py", line 3542, in registry_set
    with reg_openkey_noredir(root, path, sam=KEY_WRITE, create_if_missing=True) as key:
AttributeError: __enter__
Exception at 005B3BE5: EPyAttributeError:
AttributeError: __enter__. 

Sembra che gli errori siano questi:

Codice: Seleziona tutto

DEBUG Host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt not found, not using it for auth on repo wapt

Unable to get or create host key: [WinError 5] Accès refusé: 'C:\\Program Files (x86)\\wapt\\private\\03000200-0400-0500-0006-000700080009.pem'

DEBUG Error at DB exit attempt to write a readonly database, rollbacking

sqlite3.OperationalError: attempt to write a readonly database
Ho cercato sul forum e su internet ma non ho trovato nulla.
Mi potete aiutare?
GRAZIE.
Avatar utente
sfontenau
Esperto WAPT
Messaggi: 2312
Registrato: 10 luglio 2014 - 23:52
Contatto:

10 luglio 2023 - 10:31

Hai eseguito il comando wapt-get waptwa-scan come amministratore?

a priori, se guardiamo i messaggi:

Codice: Seleziona tutto

sqlite3.OperationalError: attempt to write a readonly database 
E

Codice: Seleziona tutto

[WinError 5] Accès refusé: 'C:\\Program Files (x86)\\wapt\\private\\03000200-0400-0500-0006-000700080009.pem'
Sembrerebbe che non sia così
Maxslg
Messaggi: 4
Registrazione: 22 giugno 2023 - 08:59

10 luglio 2023 - 10:56

Ecco infatti il ​​nuovo risultato:

Codice: Seleziona tutto

wapt-get waptwua-scan
Using config file: C:\Program Files (x86)\wapt\wapt-get.ini
2023-07-10 10:41:08,407 INFO User Groups:[]
2023-07-10 10:41:08,439 DEBUG Using host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.pem for repo global auth
2023-07-10 10:41:08,439 INFO WAPT base directory : C:\Program Files (x86)\wapt
2023-07-10 10:41:08,439 INFO Package cache dir : C:\Program Files (x86)\wapt\cache
2023-07-10 10:41:08,439 INFO WAPT DB Structure version: 20210420
Ensure wuauserv Auto Update option is disabled
Scanning with windows updates rules:
{
 "direct_download":false,
 "default_allow":false,
 "include_potentially_superseded_updates":false,
 "filter":"Type='Software' or Type='Driver'",
 "download_scheduling":"1d",
 "install_scheduling":"2h",
 "install_delay":"None",
 "postboot_delay":"10m"
}
2023-07-10 10:41:08,909 DEBUG Using host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.pem for repo wapt auth
2023-07-10 10:41:08,909 INFO Main repository: https://SRV-WAPT.mairie.mdm/wapt
2023-07-10 10:41:08,909 DEBUG Using host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.pem for repo wapt-host auth
2023-07-10 10:41:08,909 DEBUG Using host certificate C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.pem for repo waptwua auth
2023-07-10 10:41:08,909 INFO WAPTWUA repository: https://SRV-WAPT.mairie.mdm/wapt
2023-07-10 10:41:08,909 DEBUG Loading ssl context with cert C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt and key C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.pem
2023-07-10 10:41:08,924 DEBUG Starting new HTTPS connection (1): srv-wapt.mairie.mdm:443
2023-07-10 10:41:08,956 DEBUG https://srv-wapt.mairie.mdm:443 "HEAD /waptwua/wsusscn2.cab HTTP/1.1" 200 0
2023-07-10 10:41:08,971 DEBUG New wsusscn2cab.cab date : 2023-06-13T04:25:13+00:00
   Connecting to local update searcher using offline wsusscn2 file...
   Offline Update searcher ready...
Some windows updates have been installed/uninstalled since last scan
2023-07-10 10:41:37,501 DEBUG Scanning installed / not installed Updates
2023-07-10 10:41:37,501 DEBUG DB Start transaction
2023-07-10 10:41:37,501 DEBUG DB commit
Looking for updates with filter: Type='Software' or Type='Driver'
Waiting for WUA search to complete
Done searching
2023-07-10 10:48:10,619 DEBUG DB Start transaction
2023-07-10 10:48:10,619 DEBUG DB commit
WUA Search completed !
2023-07-10 10:48:10,666 DEBUG DB Start transaction
2023-07-10 10:48:10,666 DEBUG DB commit
Updates scan done.
2023-07-10 10:48:10,666 DEBUG DB Start transaction
2023-07-10 10:48:10,666 DEBUG DB commit
2023-07-10 10:48:10,681 DEBUG Already installed 07609d43-d518-4e77-856e-d1b316d1b8a8 : Mise à jour de sécurité de MSXML 6.0 RTM (925673)
2023-07-10 10:48:10,681 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,697 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,697 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,703 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,703 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,703 DEBUG DB Start transaction
2023-07-10 10:48:10,703 DEBUG DB commit
2023-07-10 10:48:10,797 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,797 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,804 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,804 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,804 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,804 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,819 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,819 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,819 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,835 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,835 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:10,835 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
Writing status in local wapt DB
2023-07-10 10:48:10,851 DEBUG DB Start transaction
2023-07-10 10:48:10,851 DEBUG DB commit
2023-07-10 10:48:10,851 DEBUG DB Start transaction
2023-07-10 10:48:10,851 DEBUG DB commit
2023-07-10 10:48:10,851 DEBUG DB Start transaction
2023-07-10 10:48:10,851 DEBUG DB commit
2023-07-10 10:48:10,866 DEBUG DB Start transaction
2023-07-10 10:48:10,866 DEBUG DB commit
2023-07-10 10:48:12,624 DEBUG DB Start transaction
2023-07-10 10:48:12,624 DEBUG DB commit
2023-07-10 10:48:12,624 DEBUG DB Start transaction
2023-07-10 10:48:12,624 DEBUG DB commit
2023-07-10 10:48:12,640 DEBUG DB Start transaction
2023-07-10 10:48:12,640 DEBUG DB commit
2023-07-10 10:48:12,640 DEBUG DB Start transaction
2023-07-10 10:48:12,640 DEBUG DB commit
2023-07-10 10:48:12,640 DEBUG DB Start transaction
2023-07-10 10:48:12,640 DEBUG DB commit
2023-07-10 10:48:12,640 DEBUG Updating workstation status on remote wapt server
2023-07-10 10:48:12,655 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:12,655 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:12,655 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:12,655 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:12,671 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:12,671 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:12,671 CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")
2023-07-10 10:48:13,172 DEBUG DB Start transaction
2023-07-10 10:48:13,172 DEBUG DB commit
2023-07-10 10:48:13,172 DEBUG Loading ssl context with cert C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.crt and key C:\Program Files (x86)\wapt\private\03000200-0400-0500-0006-000700080009.pem
2023-07-10 10:48:13,172 DEBUG Starting new HTTPS connection (1): srv-wapt.mairie.mdm:443
2023-07-10 10:48:13,210 DEBUG https://srv-wapt.mairie.mdm:443 "HEAD /ping HTTP/1.1" 200 0
2023-07-10 10:48:13,310 DEBUG host_info timing: 0.0846402645111084 s
2023-07-10 10:48:13,411 DEBUG host_networking timing: 0.08461189270019531 s
2023-07-10 10:48:13,426 DEBUG host_capabilities timing: 0.01563549041748047 s
2023-07-10 10:48:13,527 DEBUG host_metrics timing: 0.10027432441711426 s
2023-07-10 10:48:13,527 DEBUG Stores cert chain check in cache
2023-07-10 10:48:13,527 DEBUG wapt_status timing: 0.0 s
2023-07-10 10:48:13,542 DEBUG installed_softwares timing: 0.015625 s
2023-07-10 10:48:13,542 DEBUG installed_packages timing: 0.0 s
2023-07-10 10:48:13,542 DEBUG packages_audit_status timing: 0.0 s
2023-07-10 10:48:13,542 DEBUG last_update_status timing: 0.0 s
2023-07-10 10:48:13,542 DEBUG authorized_certificates timing: 0.0 s
2023-07-10 10:48:13,558 DEBUG configurations timing: 0.015624523162841797 s
2023-07-10 10:48:13,558 DEBUG wuauserv_status timing: 0.0 s
2023-07-10 10:48:13,558 DEBUG waptwua_status timing: 0.0 s
2023-07-10 10:48:13,558 DEBUG waptwua_updates timing: 0.0 s
2023-07-10 10:48:13,558 DEBUG waptwua_updates_localstatus timing: 0.0 s
2023-07-10 10:48:13,558 DEBUG waptwua_updates_localstatus timing: 0.0 s
2023-07-10 10:48:13,558 INFO Updated data keys : ['host_info', 'host_metrics', 'packages_audit_status', 'last_update_status', 'wuauserv_status', 'waptwua_status']
2023-07-10 10:48:13,558 INFO Supplied data keys : ['uuid', 'computer_fqdn', 'status_revision', 'host_info', 'host_metrics', 'packages_audit_status', 'last_update_status', 'wuauserv_status', 'waptwua_status', 'status_hashes']
2023-07-10 10:48:13,589 DEBUG Starting new HTTPS connection (1): srv-wapt.mairie.mdm:443
2023-07-10 10:48:13,674 DEBUG https://srv-wapt.mairie.mdm:443 "POST /update_host HTTP/1.1" 200 1347
2023-07-10 10:48:13,674 DEBUG DB Start transaction
2023-07-10 10:48:13,674 DEBUG DB commit
2023-07-10 10:48:13,674 DEBUG DB Start transaction
2023-07-10 10:48:13,674 DEBUG DB commit
2023-07-10 10:48:13,674 DEBUG DB Start transaction
2023-07-10 10:48:13,674 DEBUG DB commit
2023-07-10 10:48:13,674 DEBUG DB Start transaction
2023-07-10 10:48:13,689 DEBUG DB commit
2023-07-10 10:48:13,689 DEBUG DB Start transaction
2023-07-10 10:48:13,689 DEBUG DB commit
2023-07-10 10:48:13,689 INFO Status on server https://SRV-WAPT.mairie.mdm updated properly
2023-07-10 10:48:13,689 INFO update_server_status successful (data size 9292)
(1, False, 5)
None
re-enabling wuauserv previous state: 2 
Entrambi gli errori sono scomparsi, ma questo errore

Codice: Seleziona tutto

"CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")" 
è apparso 7 volte
Avatar utente
sfontenau
Esperto WAPT
Messaggi: 2312
Registrato: 10 luglio 2014 - 23:52
Contatto:

10 luglio 2023 - 11:04

Quale valore hai utilizzato per install_delay?
Maxslg
Messaggi: 4
Registrazione: 22 giugno 2023 - 08:59

10 luglio 2023 - 11:32

In effetti, me ne sono reso conto rileggendo l'errore. Ho modificato il valore in "1d" e ora gli aggiornamenti funzionano e il pacchetto wsus è attivo.

Grazie per la pronta risposta, buona giornata.
Bloccato