can't log in Webadmin

[Sycoriorz]

Dear,

i got this same issue.

Fresh installation but restored out of an Backup.
This backup was created from an old 5.1 Server which was updated till 7.0.
After finished update i create an Backup and has done an fresh install with restore

regards

[grolon]

Hi all,
I think i have the same problem

My test server is a zentyal 6.2 upgraded to 7.0

Error inserting data: INSERT INTO audit_sessions ( `timestamp`, `event`, `username`, `ip`) VALUES ( ?, ?, ?, ?) Values: $VAR1 = [ '2021-9-20 10:47:40', 'expired', 'administrador', 3232235777 ]; at /usr/share/perl5/EBox/MyDBEngine.pm line 289

I think this is related to logging msg to/from MySQL

I have disabled LOG in zentyal, for a couple of days, NO errors.

Today i have enabled them again, an got this error

DBD::mysql::st execute failed: The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior. at /usr/share/perl5/EBox/MyDBEngine.pm line 281

Any help will be welcomed

[turalyon]

In my case, I have created a cronjob that restarts the webadmin module each 6 hours. This 'fix' the behaviour for me. Below my cronjob code:

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

[grolon]

Nice tip, thanks

[fvarga]

Unfortunately same thing here.
When I access from server, everything is ok.

But when I try from another PC which is on domain I always get this msg.

400 Bad Request
The plain HTTP request was sent to HTTPS port
nginx

command -> sudo zs webadmin restart doesn't help...

Anyone know what to do ?

Thank you in advance.

[modsuper]

Thank you for the information, we are working in the solution.

[fvarga]

Hi,

any news ?

[GIELUB]

Hi all,

I have the same problem on a newly installed V7.0 system.
The error does not occur on all systems.

Sometimes I ran the updates in the terminal.
I think the error occurred for the first time after an update with 'apt update' 'apt upgrade' ...

Is that a possible cause?

[Laurent Dinclaux]

It sometimes happens to me too on some 7.0.4 boxes. Mysql is running, restarting webadmin as a workaround.

[tamuin]

Same issue here, just upgraded from 6.2

Error inserting data: INSERT INTO audit_sessions ( `username`, `timestamp`, `ip`, `event`) VALUES ( ?, ?, ?, ?) Values: $VAR1 = [ 'zadmin', '2022-2-6 12:40:41', 168430183, 'fail' ]; at /usr/share/perl5/EBox/MyDBEngine.pm line 289