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.