1 Topic by maretodoric

  • maretodoric
  • Member
  • Offline
  • Registered: 2019-09-24
  • Posts: 6

Topic: Timing out on logging in to iredadmin and MySQL errors follow it

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.1 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer? Downloadable Installer
- Linux/BSD distribution name and version: CentOS Linux release 8.2.2004 (Core)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Jul 29 12:49:14 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:49:14 171 [Warning] Aborted connection 171 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:49:15 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:49:15 173 [Warning] Aborted connection 173 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:49:26 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:49:26 175 [Warning] Aborted connection 175 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:49:26 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:49:26 176 [Warning] Aborted connection 176 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:50:41 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:50:41 195 [Warning] Aborted connection 195 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:50:41 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:50:41 197 [Warning] Aborted connection 197 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:50:42 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:50:42 198 [Warning] Aborted connection 198 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:50:48 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:50:48 199 [Warning] Aborted connection 199 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:50:49 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:50:49 201 [Warning] Aborted connection 201 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
Jul 29 12:53:05 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:53:05 140 [Warning] Aborted connection 140 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)

I'm not really sure how to troubleshoot this.
When i use roundcube client or iredadmin to do pretty much anything. It will either not allow me to login and display following error message:

Error: Session expired, please re-login.

Or will soon timeout  (in a matter of seconds) and display the same message again.

I've checked iredadmin.sessions table when troubleshooting iredadmin connections and in cases where it will not even log me in, it did not even create a session in MySQL.
At that time i turned to MySQL for possible reasons and found the above errors in mysql (mariadb) logs (Got an error reading communication packets).

Got advice how to troubleshoot this?
Connections are on localhost as noted in the error message so not sure what communication issues there may be.

----

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: Timing out on logging in to iredadmin and MySQL errors follow it

maretodoric wrote:

Jul 29 12:49:26 node1.bulletproof.rs mysqld[326601]: 2021-07-29 12:49:26 176 [Warning] Aborted connection 176 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)

In MySQL my.cnf, add a new parameter under the "[mysqld]" section:

[mysqld]
log_warnings = 1

Then restart mysql service and it should be fixed.

3 Reply by maretodoric

  • maretodoric
  • Member
  • Offline
  • Registered: 2019-09-24
  • Posts: 6

Re: Timing out on logging in to iredadmin and MySQL errors follow it

ZhangHuangbin wrote:

In MySQL my.cnf, add a new parameter under the "[mysqld]" section:

[mysqld]
log_warnings = 1

Then restart mysql service and it should be fixed.

Well... The errors are supressed but the issue still lies.
It logs me out with incredible speed or even doesn't even log me in and displays a message

Error: Session expired, please re-login.

4 Reply by ZhangHuangbin

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

Re: Timing out on logging in to iredadmin and MySQL errors follow it

maretodoric wrote:

Well... The errors are supressed but the issue still lies.

Not just "supressed".

According to MariaDB document (https://mariadb.com/kb/en/server-system … g_warnings), with `log_warnings=1`, "Connections aborted or closed due to errors or timeouts" error are not logged and the counter in SQL db are not increased too. This avoid reaching the max errors and cause MariaDB blocks connections from this bad client (127.0.0.1).