Author Topic: can't log in Webadmin  (Read 1721 times)

denis.robel

  • Zen Apprentice
  • *
  • Posts: 42
  • Karma: +3/-0
    • View Profile
can't log in Webadmin
« on: May 21, 2021, 05:08:28 pm »
Hallo,

ich following problem:I can't login into the web admin gui.

<code>
Error inserting data: INSERT INTO audit_sessions ( `username`, `event`, `ip`, `timestamp`) VALUES ( ?, ?, ?, ?)
 
Values: $VAR1 = [
          'administrator',
          'fail',
          1574024078,
          '2021-5-21 17:4:38'
        ];

 at /usr/share/perl5/EBox/MyDBEngine.pm line 289
</code>

What can I do to fix the problem?

Daniel Joven

  • Zentyal Staff
  • Zen Apprentice
  • *****
  • Posts: 31
  • Karma: +19/-0
    • View Profile
Re: can't log in Webadmin
« Reply #1 on: May 21, 2021, 05:48:51 pm »
Hi Denis,

Can you please provide us more details?

* Which Zentyal version are you using?

* Is the service 'mysql' running correctly?
Code: [Select]
sudo systemctl status mysql

* Do you see any error in the following log files?
  • /var/log/mysql/error.log
  • /var/log/syslog

Best regards, Daniel Joven.

Luke

  • Zen Monk
  • **
  • Posts: 69
  • Karma: +2/-0
    • View Profile
Re: can't log in Webadmin
« Reply #2 on: May 22, 2021, 11:46:05 am »
I have same problem! Only in one of our servers, we have two.

Error inserting data: INSERT INTO audit_sessions ( `username`, `event`, `ip`, `timestamp`) VALUES ( ?, ?, ?, ?) Values: $VAR1 = [ 'tom', 'fail', 3232235888, '2021-5-22 11:44:28' ]; at /usr/share/perl5/EBox/MyDBEngine.pm line 289

Quote
Error inserting data: INSERT INTO audit_sessions ( `username`, `event`, `ip`, `timestamp`) VALUES ( ?, ?, ?, ?)
 
Values: $VAR1 = [
          'tom',
          'fail',
          3232235888,
          '2021-5-22 11:44:28'
        ];

 at /usr/share/perl5/EBox/MyDBEngine.pm line 289

in EBox::MyDBEngine::unbufferedInsert at /usr/share/perl5/EBox/MyDBEngine.pm line 289
  286:         EBox::debug ("Values: " . Dumper(\@vals) . "\n");
  287:         throw EBox::Exceptions::Internal("Error inserting data: $sql\n" .
  288:                                          $self->{dbh}->errstr .
  289:                                          " \n" .
  290:                                          "Values: " . Dumper(\@vals) .
  291:                                          "\n");
  292:     }


Mysql is running!

itbungler

  • Zen Apprentice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: can't log in Webadmin
« Reply #3 on: May 22, 2021, 10:08:20 pm »
Do you have restarted the host?
In general this looks like a DB/SQL Issue.
So reboot should fix this anyhow.
Otherwise or if a reboot is not possible I suggest to check mysql service.

my2cents
ITBungler

Luke

  • Zen Monk
  • **
  • Posts: 69
  • Karma: +2/-0
    • View Profile
Re: can't log in Webadmin
« Reply #4 on: May 24, 2021, 09:27:15 am »
I have made several reboots but the problem is still there! I checked the mysql service as suggested above.

Quote
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>
     Active: active (running) since Fri 2021-05-21 17:52:42 CEST; 2 days ago
   Main PID: 930 (mysqld)
     Status: "Server is operational"
      Tasks: 41 (limit: 4653)
     Memory: 419.0M
     CGroup: /system.slice/mysql.service
             └─930 /usr/sbin/mysqld

May 21 17:52:19 domain systemd[1]: Starting MySQL Community Server...
May 21 17:52:42 domain systemd[1]: Started MySQL Community Server.

faceman604

  • Zen Apprentice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: can't log in Webadmin
« Reply #5 on: May 24, 2021, 09:31:38 am »
Hi everybody,

i have exactly the same problem. In my case it helped to restart the module "webadmin" via command line:

Quote
sudo zs webadmin restart

After the restart you can login via WebGUI. Unfortunatly the error reoccurs after approximately a day. Hope somebody finds a real solution.

Thanks in advance!





itbungler

  • Zen Apprentice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: can't log in Webadmin
« Reply #6 on: May 27, 2021, 09:44:56 am »
Hi,

meanwhile I can reproduce the issue.
Workaround is to restart Service zentyal.webadmin-uwsgi
After that you can logon the gui again.

my2cents
ITBungler

Daniel Joven

  • Zentyal Staff
  • Zen Apprentice
  • *****
  • Posts: 31
  • Karma: +19/-0
    • View Profile
Re: can't log in Webadmin
« Reply #7 on: May 28, 2021, 12:17:53 pm »
Hi guys,

We are doing tests in different environments and we couldn't reproduce this issue yet. Could you please send me a private message and provide me the following information?

* Was the Zentyal server 7.0 upgraded from 6.2?
* Which 'domains' do you have enabled in the log module?
* Which version of the Zentyal modules are you using (dpkg -l | grep 'zentyal' )?
* Can you attach me the following log files? We would like to analyze those log files in order to see any trace that help us to identify the issue.
   * /var/log/zentyal/zentyal.log
   * /var/log/zentyal/error.log
   * /var/log/zentyal/uwsgi.log
   * /var/log/syslog
   * /var/log/mysql/error.log

     NOTE1: Ensure that the log files are from the day that you got the issue.
     NOTE2: Tell us the day where you got the issue.

Thank you for your feedback.

Best regards, Daniel Joven.

yochaigal

  • Zen Apprentice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: can't log in Webadmin
« Reply #8 on: May 28, 2021, 04:59:03 pm »
I can also confirm this issue. Next time it appears I'll upload some logs as well.

I get:
Error inserting data: INSERT INTO audit_sessions ( `username`, `timestamp`, `event`, `ip`) VALUES ( ?, ?, ?, ?) Values: $VAR1 = [ 'bfc', '2021-6-2 12:58:10', 'fail', 921502494 ]; at /usr/share/perl5/EBox/MyDBEngine.pm line 289

I then restart the webadmin service and everything comes back.
« Last Edit: June 02, 2021, 07:06:05 pm by yochaigal »

denis.robel

  • Zen Apprentice
  • *
  • Posts: 42
  • Karma: +3/-0
    • View Profile
Re: can't log in Webadmin
« Reply #9 on: June 07, 2021, 02:41:25 pm »
Hallo Daniel

* Was the Zentyal server 7.0 upgraded from 6.2?

yes


* Which 'domains' do you have enabled in the log module?

- Konfigurationsänderungen, Andministarionssitzung   
- E-Mail   
- Samba-Zugriff   
- DHCP   
- Firewall   
- SMTP-Filter   
- VPN   
- HTTP-Proxy   


* Which version of the Zentyal modules are you using (dpkg -l | grep 'zentyal' )?
 dpkg -l | grep 'zentyal'
ii  language-pack-zentyal-de               7.0                                                                all          Zentyal translations for language German
ii  zentyal                                7.0.0ubuntu1                                                       all          Zentyal - Core metapackage
ii  zentyal-antivirus                      7.0.1                                                              all          Zentyal - Antivirus
ii  zentyal-ca                             7.0.1                                                              all          Zentyal - Certification Authority
ii  zentyal-core                           7.0.4                                                              all          Zentyal - Core
ii  zentyal-dhcp                           7.0.2                                                              all          Zentyal - DHCP Server
ii  zentyal-dns                            7.0.2                                                              all          Zentyal - DNS Server
ii  zentyal-firewall                       7.0.0                                                              all          Zentyal - Firewall
ii  zentyal-groupware                      7.0.0ubuntu1                                                       all          Zentyal - Mail and Groupware
ii  zentyal-jabber                         7.0.0                                                              all          Zentyal - Jabber
ii  zentyal-mail                           7.0.1                                                              all          Zentyal - Mail
ii  zentyal-mailfilter                     7.0.0                                                              all          Zentyal - Mail Filter
ii  zentyal-network                        7.0.0                                                              all          Zentyal - Network Configuration
ii  zentyal-ntp                            7.0.0                                                              all          Zentyal - NTP Service
ii  zentyal-openvpn                        7.0.0                                                              all          Zentyal - VPN
rc  zentyal-radius                         6.0.1                                                              all          Zentyal - RADIUS
ii  zentyal-samba                          7.0.1                                                              all          Zentyal - Domain Controller and File Sharing
ii  zentyal-software                       7.0.0                                                              all          Zentyal - Software Management
ii  zentyal-sogo                           7.0.0                                                              all          Zentyal - Web Mail
ii  zentyal-squid                          7.0.2                                                              all          Zentyal - HTTP Proxy



* Can you attach me the following log files? We would like to analyze those log files in order to see any trace that help us to identify the issue.
   * /var/log/zentyal/zentyal.log
   * /var/log/zentyal/error.log
   * /var/log/zentyal/uwsgi.log
   * /var/log/syslog
   * /var/log/mysql/error.log

Daniel Joven

  • Zentyal Staff
  • Zen Apprentice
  • *****
  • Posts: 31
  • Karma: +19/-0
    • View Profile
Re: can't log in Webadmin
« Reply #10 on: June 08, 2021, 01:27:40 pm »
Hi denis.robel,

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

Best regards, Daniel Joven.

oajlopez

  • Zen Apprentice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: can't log in Webadmin
« Reply #11 on: July 28, 2021, 09:46:35 am »
I have the same problem in two server

fjldurodie

  • Zen Apprentice
  • *
  • Posts: 13
  • Karma: +1/-0
    • View Profile
Re: can't log in Webadmin
« Reply #12 on: July 28, 2021, 10:16:20 am »
I also have the same issue for some time now.

This concerns a fresh install of Zentyal 7 (so no upgrade from 6)

I can confirm that restarting webadmin works (and is more convenient than rebooting).

I wanted to attach the technical info that can be found on the page as a pdf (85kB) but I couldn't (attachment too large ?)
F.

Luke

  • Zen Monk
  • **
  • Posts: 69
  • Karma: +2/-0
    • View Profile
Re: can't log in Webadmin
« Reply #13 on: August 03, 2021, 10:26:21 am »
We have this problem in one server of two. As other describe a quick solution is " sudo zs webadmin restart " but after a day or so its back to same problem.

rubicon

  • Zen Apprentice
  • *
  • Posts: 18
  • Karma: +2/-0
    • View Profile
Re: can't log in Webadmin
« Reply #14 on: August 09, 2021, 08:28:59 am »
A similar problem after upgrading from version 6.2 to version 7. sudo zs webadmin restart - but after a day or so its back to same problem.
/usr/share/perl5/EBox/MyDBEngine.pm line 289
« Last Edit: August 09, 2021, 09:30:39 am by rubicon »