Page 1 sur 1

[RESOLU] Problème Windows update

Posté : 10 juil. 2023 - 10:10
par Maxslg
Bonjour,
Je rencontre un soucis avec le Windows Update de WAPT qui ne fonctionne pas.
J'ai en premier temps tester avec un paquet wsus pour débloquer les mises a jours mais n'a pas fonctionner.
En suite j'ai exécuté la commande "wapt-get waptwa-scan" et elle me renvoie çà:

Code : Tout sélectionner

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__. 

A priori les erreurs sont la :

Code : Tout sélectionner

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
J'ai cherché sur le forum et sur internet et je ne trouve rien.
Pouvez vous m'aider?
merci.

Re: Problème Windows update

Posté : 10 juil. 2023 - 10:31
par sfonteneau
Avez-vous lancer la commande wapt-get waptwa-scan en tant qu'administrateur ?

a priori si on regarde les message :

Code : Tout sélectionner

sqlite3.OperationalError: attempt to write a readonly database 
et

Code : Tout sélectionner

[WinError 5] Accès refusé: 'C:\\Program Files (x86)\\wapt\\private\\03000200-0400-0500-0006-000700080009.pem'
Il semblerai que ce ne soit pas le cas

Re: Problème Windows update

Posté : 10 juil. 2023 - 10:56
par Maxslg
effectivement, voici le nouveau résultat:

Code : Tout sélectionner

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 
Les deux erreurs ont bien disparue mais cette erreure

Code : Tout sélectionner

"CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")" 
est apparue 7 fois

Re: Problème Windows update

Posté : 10 juil. 2023 - 11:04
par sfonteneau
vous avez mis quoi comme valeur pour install_delay ?

Re: Problème Windows update

Posté : 10 juil. 2023 - 11:32
par Maxslg
En effet, je m'en suis rendu compte en relisant l’erreur, j'ai changé la valeur par "1d" et maintenant les mises à jour se font et le paquet wsus fonctionne.

Merci pour votre réactivité, bonne journée.