1 (edited by ronaldst 2021-04-18 16:44:30)

Topic: Connection errors in MySQL -logs after clean install of 1.4.0

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.4.0
- Deployed with iRedMail Easy or the downloadable installer? Downloadable installer
- Linux/BSD distribution name and version: Ubuntu 20.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL/MariaDB
- 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.
====

I've completed a fresh install of iRedMail 1.4.0 on Ubuntu 20.04 LTS and am seeing some errors that worries me.

Out of the box I did add a LE SSL and set it up according to documentation on this site and added a few e-mail accounts. Other than that, it's untouched.

/var/log/mysql/error.log
2021-04-18  9:02:05 661 [Warning] Aborted connection 661 to db: 'iredapd' user: 'iredapd' host: 'localhost' (Got an error reading communication packets)
2021-04-18  9:15:23 675 [Warning] Aborted connection 675 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
2021-04-18  9:45:22 708 [Warning] Aborted connection 708 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
2021-04-18  9:45:23 707 [Warning] Aborted connection 707 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
2021-04-18 10:01:01 726 [Warning] Aborted connection 726 to db: 'iredadmin' user: 'iredadmin' host: 'localhost' (Got an error reading communication packets)
2021-04-18 10:01:01 727 [Warning] Aborted connection 727 to db: 'iredapd' user: 'iredapd' host: 'localhost' (Got an error reading communication packets)
2021-04-18 10:01:01 728 [Warning] Aborted connection 728 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
2021-04-18 10:02:05 730 [Warning] Aborted connection 730 to db: 'iredapd' user: 'iredapd' host: 'localhost' (Got an error reading communication packets)
2021-04-18 10:15:23 751 [Warning] Aborted connection 751 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)
2021-04-18 10:15:24 750 [Warning] Aborted connection 750 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)

On Ubuntu systems running MariaDB 10.3, the root MariaDB user is set to authenticate using the unix_socket plugin by default rather than with a password. Is that the issue here?


Thank you.

----

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

2

Re: Connection errors in MySQL -logs after clean install of 1.4.0

Hi.

The server is virtualized?

3

Re: Connection errors in MySQL -logs after clean install of 1.4.0

falvarez wrote:

Hi.

The server is virtualized?

Yes.

How is that related?

4

Re: Connection errors in MySQL -logs after clean install of 1.4.0

ronaldst wrote:

2021-04-18 10:15:24 750 [Warning] Aborted connection 750 to db: 'vmail' user: 'vmailadmin' host: 'localhost' (Got an error reading communication packets)

This is a "mysterious" issue i didn't figure out the cause yet. It's been a long time. sad
Some system has this issue, but not all, looks LIKE randomly happened, but i doubt.

5 (edited by ronaldst 2021-04-19 16:19:12)

Re: Connection errors in MySQL -logs after clean install of 1.4.0

I have been monitoring the server for a day now and have not seen any of these errors appear again. ClamAV is complaining it's outdated, but other than that, everything seems fine.

I have planned to reboot the server tonight and will report back any errors that might occur.

Thank you.