1 Topic by 77

  • 77
  • Member
  • Offline
  • Registered: 2016-04-08
  • Posts: 46

Topic: iRedAdmin Pro Session extremely short.

==== Required information ====
- iRedMail version (check /etc/iredmail-release): latest as of today
- Linux/BSD distribution name and version: 16 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx): apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

I keep getting logged out of iredadmin pro with extremely quick sessions (few seconds long)
I get this error:  OperationalError(1292, "Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastlogindate' at row 1")

This is happening after I migrated to a new server
Please advise.

Thanks

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iRedAdmin Pro Session extremely short.

77 wrote:

I get this error:  OperationalError(1292, "Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastlogindate' at row 1")

Try this SQL structure fix:
http://www.iredmail.org/docs/upgrade.ir … l-database

3 Reply by 77 (edited by 77 2017-09-13 17:11:17)

  • 77
  • Member
  • Offline
  • Registered: 2016-04-08
  • Posts: 46

Re: iRedAdmin Pro Session extremely short.

Better, but its still logging me out very quickly. But now it seems random.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iRedAdmin Pro Session extremely short.

*) Any error in MySQL server log file?
*) Any error in Apache log file?

5 Reply by 77

  • 77
  • Member
  • Offline
  • Registered: 2016-04-08
  • Posts: 46

Re: iRedAdmin Pro Session extremely short.

Yes,

Mysql:

2017-09-14T03:34:01.443615Z 28815 [Note] Aborted connection 28815 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)

I am getting this error every minute.

Apache (this is everything in the error.log file):
[Thu Sep 14 01:54:58.031923 2017] [wsgi:warn] [pid 1382] mod_wsgi: Compiled for Python/2.7.11.
[Thu Sep 14 01:54:58.031985 2017] [wsgi:warn] [pid 1382] mod_wsgi: Runtime using Python/2.7.12.
[Thu Sep 14 01:54:58.033058 2017] [mpm_prefork:notice] [pid 1382] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g mod_wsgi/4.3.0 Python/2.7.12 configured -- resuming normal operations
[Thu Sep 14 01:54:58.033078 2017] [core:notice] [pid 1382] AH00094: Command line: '/usr/sbin/apache2'

There are a lot of these in the error.log.1 file:

[Wed Sep 13 09:16:04.552293 2017] [proxy_http:error] [pid 20124] (70007)The timeout specified has expired: [client 13.92.188.116:60726] AH01102: error reading status line from remote server 127.0.0.1:20000
[Wed Sep 13 09:16:04.552365 2017] [proxy:error] [pid 20124] [client 13.92.188.116:60726] AH00898: Error reading from remote server returned by /Microsoft-Server-ActiveSync

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iRedAdmin Pro Session extremely short.

77 wrote:

2017-09-14T03:34:01.443615Z 28815 [Note] Aborted connection 28815 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)

Did this error occur frequently?

Also, did you modify any MySQL and SOGo config files?

7 Reply by 77

  • 77
  • Member
  • Offline
  • Registered: 2016-04-08
  • Posts: 46

Re: iRedAdmin Pro Session extremely short.

Yes it occurs every minute.

No i did not modify the config files.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iRedAdmin Pro Session extremely short.

Try this: Add setting "SESSION_IGNORE_CHANGE_IP = True" (without quotes) in iRedAdmin-Pro config file (/opt/www/iredadmin/settings.py), then restart Apache service and try again.

9 Reply by 77

  • 77
  • Member
  • Offline
  • Registered: 2016-04-08
  • Posts: 46

Re: iRedAdmin Pro Session extremely short.

Thank you! Its working now.  It seems I was behind a load balancer that kept changing my IP.  Thanks for your help.

Kind Regards,