Author Topic: Error al Ver los Registros en Zentyal 7.0  (Read 1829 times)

Marcelo_roig

  • Zen Apprentice
  • *
  • Posts: 3
  • Karma: +1/-0
    • View Profile
Error al Ver los Registros en Zentyal 7.0
« on: May 28, 2021, 04:00:08 pm »
Buenas, tengo el siguiente problema:

Al querer revisar los Registros, cualquier registro da el siguiente Error:

Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
 at /usr/share/perl5/EBox/CGI/Run.pm line 105

Intente Forzar la Purga de los registros y tambien me da otro Error:

Error doing statement: DELETE FROM firewall WHERE timestamp < STR_TO_DATE('Fri May 28 08:49:37 2021','%a %b %e %T %Y') , at /usr/share/perl5/EBox/MyDBEngine.pm line 572

Adjunto el Log del error: Lo siento no me sube el log... es muy grande...

Installed packages
------------------

ii language-pack-zentyal-es: 7.0
ii zentyal: 7.0.0ubuntu1
ii zentyal-antivirus: 7.0.1
ii zentyal-ca: 7.0.1
ii zentyal-core: 7.0.4
ii zentyal-dhcp: 7.0.2
ii zentyal-dns: 7.0.2
ii zentyal-firewall: 7.0.0
ii zentyal-ftp: 7.0.0
ii zentyal-ips: 7.0.0
ii zentyal-network: 7.0.0
rc zentyal-ntp: 7.0.0
ii zentyal-openvpn: 7.0.0
rc zentyal-samba: 7.0.1
ii zentyal-software: 7.0.0
ii zentyal-squid: 7.0.2


/etc/resolv.conf
----------------

# Dynamic resolv.conf(5) file for glibc resolver(3) generated by resolvconf(8)
# and managed by Zentyal.
#
#     DO NOT EDIT THIS FILE BY HAND -- YOUR CHANGES WILL BE OVERWRITTEN
#
nameserver 127.0.0.1
search enlacesystem.local

Esto es el final del log:
2021/05/28 08:22:52 INFO> GlobalImpl.pm:715 EBox::GlobalImpl::saveAllModules - Changes saved successfully
2021/05/28 08:26:28 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::st execute warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 478.
2021/05/28 08:26:28 ERROR> Run.pm:97 EBox::CGI::Run::run - Exception trying to access Logs/Index: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
2021/05/28 08:30:02 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::st execute warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 478.
2021/05/28 08:30:02 ERROR> Run.pm:97 EBox::CGI::Run::run - Exception trying to access Logs/Index: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
2021/05/28 09:09:37 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::st execute warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 478.
2021/05/28 09:09:37 ERROR> Run.pm:97 EBox::CGI::Run::run - Exception trying to access Logs/Index: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
2021/05/28 09:09:50 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::st execute warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 478.
2021/05/28 09:09:50 ERROR> Run.pm:97 EBox::CGI::Run::run - Exception trying to access Logs/Index: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
2021/05/28 09:13:26 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::db do warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 569.
2021/05/28 09:13:26 ERROR> MyDBEngine.pm:572 EBox::MyDBEngine::do - Error doing statement: DELETE FROM firewall WHERE timestamp < STR_TO_DATE('Fri May 28 08:13:26 2021','%a %b %e %T %Y') ,
2021/05/28 09:18:39 ERROR> Run.pm:92 EBox::CGI::Run::run - malformed JSON string, neither tag, array, object, number, string or atom, at character offset 0 (before "Can't connect to bug...") at /usr/share/perl5/JSON/RPC/Legacy/Client.pm line 180.
2021/05/28 09:26:18 ERROR> Run.pm:92 EBox::CGI::Run::run - malformed JSON string, neither tag, array, object, number, string or atom, at character offset 0 (before "Can't connect to bug...") at /usr/share/perl5/JSON/RPC/Legacy/Client.pm line 180.
2021/05/28 09:31:56 INFO> GlobalImpl.pm:617 EBox::GlobalImpl::saveAllModules - Saving config and restarting services: firewall ips logs
2021/05/28 09:31:57 INFO> Base.pm:231 EBox::Module::Base::save - Restarting service for module: firewall
2021/05/28 09:31:57 INFO> Base.pm:231 EBox::Module::Base::save - Restarting service for module: ips
2021/05/28 09:32:01 INFO> Base.pm:231 EBox::Module::Base::save - Restarting service for module: logs
2021/05/28 09:32:01 INFO> GlobalImpl.pm:715 EBox::GlobalImpl::saveAllModules - Changes saved successfully
2021/05/28 09:32:23 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::st execute warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 478.
2021/05/28 09:32:23 ERROR> Run.pm:97 EBox::CGI::Run::run - Exception trying to access Logs/Index: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
2021/05/28 09:32:48 ERROR> Run.pm:92 EBox::CGI::Run::run - malformed JSON string, neither tag, array, object, number, string or atom, at character offset 0 (before "Can't connect to bug...") at /usr/share/perl5/JSON/RPC/Legacy/Client.pm line 180.
2021/05/28 09:44:48 WARN> zentyal.psgi:43 Plack::Sandbox::_2fusr_2fshare_2fzentyal_2fpsgi_2fzentyal_2epsgi::__ANON__ - DBD::mysql::st execute warning:  at /usr/share/perl5/EBox/MyDBEngine.pm line 478.
2021/05/28 09:44:48 ERROR> Run.pm:97 EBox::CGI::Run::run - Exception trying to access Logs/Index: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.30/DBI.pm line 2086.
   ...propagated at /usr/share/perl5/EBox/CGI/Base.pm line 321.
2021/05/28 09:45:55 ERROR> Run.pm:92 EBox::CGI::Run::run - malformed JSON string, neither tag, array, object, number, string or atom, at character offset 0 (before "Can't connect to bug...") at /usr/share/perl5/JSON/RPC/Legacy/Client.pm line 180.
« Last Edit: May 28, 2021, 04:01:59 pm by Marcelo_roig »

Marcelo_roig

  • Zen Apprentice
  • *
  • Posts: 3
  • Karma: +1/-0
    • View Profile
Re: Error al Ver los Registros en Zentyal 7.0
« Reply #1 on: June 01, 2021, 01:30:43 pm »
Les cuento que he solucionado el error, simplemente al volver a activar el modulo de RADIUS, no se porque al desactivarlo Ya no se pueden visualizar ningún registro. Pienso que podría faltar algún ajuste ahí. Pero por el momento simplemente con activar el Modulo que había desactivado antes volvió a funcionar. Por si a alguien le pasa....

Marcelo_roig

  • Zen Apprentice
  • *
  • Posts: 3
  • Karma: +1/-0
    • View Profile
Re: Error al Ver los Registros en Zentyal 7.0
« Reply #2 on: June 09, 2021, 05:33:51 pm »
Les comento que continuo con el problema, no entiendo que pasa, a veces logro ver los registros y otras veces me sale el mismo Error... porfavor si alguien encontró alguna solución.

Ret

  • Zen Apprentice
  • *
  • Posts: 35
  • Karma: +1/-0
    • View Profile
Re: Error al Ver los Registros en Zentyal 7.0
« Reply #3 on: December 06, 2021, 09:24:55 pm »
Es este bug?.
https://github.com/zentyal/zentyal/issues/2082
Aparentemente es provocado porque caduca el tiempo de sesion de webadmin

provisoriamente se arregla reiniciando el modulo webadmin "sudo zs weabadmin restart"

turalyon

  • Zen Warrior
  • ***
  • Posts: 197
  • Karma: +15/-0
    • View Profile
Re: Error al Ver los Registros en Zentyal 7.0
« Reply #4 on: December 07, 2021, 03:33:38 pm »
Hola,

Efectivamente, este comportamiento es un bug. Tal y como indiqué en otro hilo, un workaround temporal es crear una tarea de cron que reinicie el módulo de Webadmin cada X horas. A continuación un ejemplo de la tarea programada que me funciona ami:

Code: [Select]
## Workaround
## Added on: 15-09-2021
## Bug: https://github.com/zentyal/zentyal/issues/2055
0 */6 * * * /usr/bin/zs webadmin restart >/dev/null 2>&1

---
“This world is ours, and by the Holy Light we will keep it safe, now and forever".