1 Topic by gilles.quenot

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Topic: How to properly disable sogo and keep mail part

- iRedMail version: 1.0-beta2 MARIADB edition
- Deployed with  downloadable installer
- Linux/BSD distribution name and version: debian10
- Store mail accounts in MySQL backend
- Web server: Nginx

Hi,

due to too many issues, I migrated to a better known software: owncloud instead of sogo.

So I ran :

systemctl stop sogo
systemctl disable sogo

But after running 'mysqltunner.pl', I saw that I have errors in MySQL logs :

2020-01-08  0:37:03 138645 [Warning] Aborted connection 138645 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)

What is trying to call sogo db ?
How can I disable properly sogo ?

Regards

----

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: 30,768

Re: How to properly disable sogo and keep mail part

SOGo daemon user has 2 cron jobs, you need to disable them too.

3 Reply by gilles.quenot

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Re: How to properly disable sogo and keep mail part

Ah, good catch, thanks !

4 Reply by gilles.quenot

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Re: How to properly disable sogo and keep mail part

But I see only one line in root crontab for backup, and in /etc/cron* nothing to connect to MySQL.

My crontab :

# Defaults to keep for 2 days, controlled by Roundcube parameter $config['temp_dir_ttl'].
2 2 * * * php /opt/www/roundcubemail/bin/gc.sh >/dev/null

# iRedAdmin: Clean up sql database.
1   *   *   *   *   /usr/bin/python /opt/www/iredadmin/tools/cleanup_db.py &>/dev/null
# iRedAdmin: Remove mailboxes which are scheduled to be removed.
1   3   *   *   *   /usr/bin/python /opt/www/iredadmin/tools/delete_mailboxes.py

# iRedMail: Backup MySQL databases on 03:30 AM
30   3   *   *   *   /bin/bash /var/vmail/backup/backup_mysql.sh

# iRedAPD: Clean up expired tracking records hourly.
1   *   *   *   *   python /opt/iredapd/tools/cleanup_db.py >/dev/null

# iRedAPD: Convert SPF DNS record of specified domain names to IP
#          addresses/networks hourly.
2   *   *   *   *   python /opt/iredapd/tools/spf_to_greylist_whitelists.py >/dev/null

# iRedMail: Cleanup Amavisd database
1   2   *   *   *   python /opt/www/iredadmin/tools/cleanup_amavisd_db.py >/dev/null

# iRedAdmin: Clean up sql database.
1   *   *   *   *   python /opt/www/iredadmin/tools/cleanup_db.py >/dev/null 2>&1

# iRedAdmin: Delete mailboxes on file system which belong to removed accounts.
1   *   *   *   *   python /opt/www/iredadmin/tools/delete_mailboxes.py
# iRedMail: Cleanup Roundcube SQL database
2   2   *   *   *   /usr/bin/php /opt/www/roundcubemail/bin/cleandb.sh >/dev/null

# iRedMail: Cleanup Roundcube temporary files under 'temp/' directory
2   2   *   *   *   /usr/bin/php /opt/www/roundcubemail/bin/gc.sh >/dev/null
# iRedMail: Backup SOGo data databases on 04:01AM
#1   4   *   *   *   /bin/bash /var/vmail/backup/backup_sogo.sh

I still have tons of errors in MySQL logs 2 times, every minutes :

2020-01-10 14:41:03 50495 [Warning] Aborted connection 50495 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication 
packets)
2020-01-10 14:41:04 50496 [Warning] Aborted connection 50496 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:42:03 50505 [Warning] Aborted connection 50505 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:42:04 50506 [Warning] Aborted connection 50506 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:43:02 50513 [Warning] Aborted connection 50513 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:43:03 50514 [Warning] Aborted connection 50514 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:44:03 50522 [Warning] Aborted connection 50522 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:44:04 50523 [Warning] Aborted connection 50523 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:45:03 50532 [Warning] Aborted connection 50532 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:45:04 50533 [Warning] Aborted connection 50533 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:46:03 50541 [Warning] Aborted connection 50541 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:46:04 50542 [Warning] Aborted connection 50542 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:47:02 50596 [Warning] Aborted connection 50596 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:47:03 50597 [Warning] Aborted connection 50597 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets)
2020-01-10 14:48:03 50617 [Warning] Aborted connection 50617 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,768

Re: How to properly disable sogo and keep mail part

I said "SOGo daemon user" has the cron job, not root user.
You should run "crontab -l -u sogo" to check it.

6 Reply by gilles.quenot

  • gilles.quenot
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 61

Re: How to properly disable sogo and keep mail part

Oh, thanks !