[RESUELTO] Problema de actualización de Windows

Comparta sus sugerencias o problemas relacionados con la consola WAPT o el agente WAPT aquí
Reglas del foro
Reglas del foro de la comunidad
* Soporte en inglés en www.reddit.com/r/wapt
* El soporte de la comunidad en francés está disponible en este foro
* Por favor, anteponga [RESUELTO] al título del tema si está resuelto.
* Por favor, no edite un tema que esté etiquetado como [RESUELTO]. Abra un nuevo tema haciendo referencia al anterior.
* Especifique la versión de WAPT instalada, la versión completa y el número de compilación (2.2.1.11957 / 2.2.2.12337 / etc.), así como la edición Enterprise/Discovery.
* Las versiones 1.8.2 y anteriores ya no son compatibles. Las únicas preguntas aceptadas sobre la versión 1.8.2 están relacionadas con la actualización a una versión compatible (2.1, 2.2, etc.).
* Especifique el sistema operativo del servidor (Linux/Windows) y la versión (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Especifique el sistema operativo de la máquina de administración/creación de paquetes y de la máquina con el agente problemático, si corresponde (Windows 7/10/11/Debian 11/etc.).
* Evite hacer varias preguntas al abrir un tema, ya que podría ser ignorado. Si hay varios temas, ábralos por separado, preferiblemente uno tras otro y no todos a la vez (es decir, no sature el foro con spam).
* Incluya fragmentos de código, capturas de pantalla y otras imágenes directamente en la publicación. Los enlaces a Pastebin, Bitly y otros sitios de terceros serán eliminados sistemáticamente.
* Como en cualquier foro comunitario, el soporte es proporcionado voluntariamente por los miembros. Si necesita soporte comercial, puede comunicarse con el departamento de ventas de Tranquil IT al 02.40.97.57.55.
Bloqueado
Máximo slg
Mensajes: 4
Inscripción: 22 de junio de 2023 - 08:59

10 de julio de 2023 - 10:10

Buen día,
Estoy experimentando un problema con la actualización de Windows de WAPT que no funciona.
Inicialmente intenté usar un paquete wsus para desbloquear actualizaciones, pero no funcionó.
A continuación, ejecuté el comando "wapt-get waptwa-scan" y me devolvió esto:

Código: Seleccionar todo

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

Los errores, en principio, están aquí:

Código: Seleccionar todo

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
He buscado en el foro y en internet y no encuentro nada.
¿Me puedes ayudar?
GRACIAS.
Avatar de usuario
Sfonteneau
Experto en WAPT
Mensajes: 2312
Registrado: 10 de julio de 2014 - 23:52
Contacto :

10 de julio de 2023 - 10:31

¿Ejecutó el comando wapt-get waptwa-scan como administrador?

A priori, si miramos los mensajes:

Código: Seleccionar todo

sqlite3.OperationalError: attempt to write a readonly database 
Y

Código: Seleccionar todo

[WinError 5] Accès refusé: 'C:\\Program Files (x86)\\wapt\\private\\03000200-0400-0500-0006-000700080009.pem'
Parece que no es así.
Máximo slg
Mensajes: 4
Inscripción: 22 de junio de 2023 - 08:59

10 de julio de 2023 - 10:56

De hecho, aquí está el nuevo resultado:

Código: Seleccionar todo

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 
Ambos errores han desaparecido, pero este error

Código: Seleccionar todo

"CRITICAL Bad time install_delay: None ValueError("could not convert string to float: 'None'")" 
apareció 7 veces
Avatar de usuario
Sfonteneau
Experto en WAPT
Mensajes: 2312
Registrado: 10 de julio de 2014 - 23:52
Contacto :

10 de julio de 2023 - 11:04

¿Qué valor usaste para install_delay?
Máximo slg
Mensajes: 4
Inscripción: 22 de junio de 2023 - 08:59

10 de julio de 2023 - 11:32

De hecho, me di cuenta al releer el error. Cambié el valor a "1d" y ahora las actualizaciones funcionan y el paquete wsus también.

Gracias por su pronta respuesta, que tenga un buen día.
Bloqueado