1 Topic by llamberto

  • llamberto
  • Member
  • Offline
  • Registered: 2020-09-26
  • Posts: 15

Topic: mysqld [Warning] Aborted connection

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check 1.3.1 MARIADB edition. ):
- Deployed with iRedMail Easy or the downloadable installer? downloadable
- Linux/BSD distribution name and version: centos 8  4.18.0-193.19.1.el8_2.x86_64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
hi,
i have a fresh iredamil installation on centos
all  good bu i see in logs this one
Oct 15 15:24:17 mail2 mysqld[1163]: 2020-10-15 15:24:17 5936 [Warning] Aborted connection 5936 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
Oct 15 15:27:18 mail2 mysqld[1163]: 2020-10-15 15:27:18 6180 [Warning] Aborted connection 6180 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
Oct 15 15:27:19 mail2 mysqld[1163]: 2020-10-15 15:27:19 5695 [Warning] Aborted connection 5695 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
Oct 15 15:34:06 mail2 mysqld[1163]: 2020-10-15 15:34:06 6168 [Warning] Aborted connection 6168 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)

i read a post about this problem and the suggestion is use a linux compatible versio
now i have centos8  and i have installed iredamil exactly as instruction
is this warning know? is a problem ?

----

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: mysqld [Warning] Aborted connection

It's a known issue but i cannot figure out why it happened. sad

3 Reply by llamberto

  • llamberto
  • Member
  • Offline
  • Registered: 2020-09-26
  • Posts: 15

Re: mysqld [Warning] Aborted connection

tks

4 Reply by ZhangHuangbin

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

Re: mysqld [Warning] Aborted connection

hi @liamberto,

Do you still have this issue? If yes, please try steps below to fix it:

- Login to MariaDB server as root user
- Run SQL command below:

show global variables like '%log_warnings%';

If the value is 2 or larger number, please set it to 1 with SQL command below:

set global log_warnings=1;

- Keep watching MariaDB log file , if no more such "Got an error reading communication packets" error, then add setting "log_warnings = 1" in my.cnf and restart mariadb service.

5 Reply by llamberto

  • llamberto
  • Member
  • Offline
  • Registered: 2020-09-26
  • Posts: 15

Re: mysqld [Warning] Aborted connection

thanks!
no more such "Got an error reading communication packets"