1 Topic by amvincere

  • amvincere
  • Member
  • Offline
  • Registered: 2019-01-16
  • Posts: 3

Topic: iRedmail Fresh install : Mysql err message

Hi, i got err in mysql log, can someone help how to fix it...

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

log:

tail -f /var/db/mysql/***example.com***.err
2019-01-18T10:12:00.424674Z 329 [Note] Aborted connection 329 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:12:00.799136Z 330 [Note] Aborted connection 330 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:13:00.474212Z 331 [Note] Aborted connection 331 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:13:00.840838Z 332 [Note] Aborted connection 332 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:14:00.478348Z 333 [Note] Aborted connection 333 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:14:00.852645Z 334 [Note] Aborted connection 334 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:15:00.515246Z 335 [Note] Aborted connection 335 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:15:00.889532Z 336 [Note] Aborted connection 336 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:16:00.477192Z 337 [Note] Aborted connection 337 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2019-01-18T10:16:00.847309Z 338 [Note] Aborted connection 338 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)

All works, but i got this err... it is critical or can be ignored?

----

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,091

Re: iRedmail Fresh install : Mysql err message

We had this issue on clients' servers, also some users reported this issue in this forum. All relevant to FreeBSD 12.
Not sure whether it's a FreeBSD-relevant issue, or iRedMail issue. sorry. sad

3 Reply by amvincere (edited by amvincere 2019-01-29 20:57:01)

  • amvincere
  • Member
  • Offline
  • Registered: 2019-01-16
  • Posts: 3

Re: iRedmail Fresh install : Mysql err message

ZhangHuangbin wrote:

We had this issue on clients' servers, also some users reported this issue in this forum. All relevant to FreeBSD 12.
Not sure whether it's a FreeBSD-relevant issue, or iRedMail issue. sorry. sad

Can i migrate from Mysql to Postgresql to avoid this issue? It is possible?
Mysql-stop every day. only can fix it by restart service...

4 Reply by ZhangHuangbin

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

Re: iRedmail Fresh install : Mysql err message

amvincere wrote:

Can i migrate from Mysql to Postgresql to avoid this issue? It is possible?

Sure. Setup a new server with PGSQL, then migrate the SQL database, also copy the mailboxes.

5 Reply by ZhangHuangbin

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

Re: iRedmail Fresh install : Mysql err message

Hi @amvincere,

I reported this issue to SOGo team, you can monitor the issue below, and please help push SOGo team to fix it:
https://sogo.nu/bugs/view.php?id=4684

As a temporary solution, you can disable sogo cron jobs as mentioned in this forum post:
https://forum.iredmail.org/post67762.html#p67762