1 Topic by loudking

  • loudking
  • Member
  • Offline
  • Registered: 2015-04-22
  • Posts: 41

Topic: postmaster inbox is full because sogo gropuware is not installed

==== Required information ====
- iRedMail version: 0.9.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):
- Linux/BSD distribution name and version: CentOS 6.6
- Related log if you're reporting an issue: NO
====



HI there,

My postmaster inbox is filled with emails with subject 'Undelivered Mail Returned to Sender'

Original mail is: Cron <sogo@mail> /usr/sbin/sogo-tool expire-sessions 30'

2015-04-19 01:09:05.783 sogo-tool[5874] Table 'sogo.sogo_sessions_folder' doesn't exist
/usr/sbin/sogo-tool: Uncaught exception ExecutionFailed, reason: Table 'sogo.sogo_sessions_folder' doesn't exist

I do see there is a similar issue on 2015-01-06 on this forum and the post says this bug is fixed. But I am still encountering this problem because sogo service is not installed. Due to the fact that our server resource is restricted I am not planning to install this service at all. Would you please tell me if it is possible to configure iredmail not requiring sogo? Thanks in advance.

----

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

Re: postmaster inbox is full because sogo gropuware is not installed

Sorry about this trouble. Please update root's cron job, comment out (or remove) sogo related cron jobs.

3 Reply by loudking

  • loudking
  • Member
  • Offline
  • Registered: 2015-04-22
  • Posts: 41

Re: postmaster inbox is full because sogo gropuware is not installed

Thanks for your quick reply. but I didn't find any sogo related crontab jobs.

Do you know which of the 5 jobs below is about sogo? Thanks.

[root@mail ~]# crontab -l
# iRedMail: Backup MySQL databases on 03:30 AM
30   3   *   *   *   /bin/bash /home/loudking/vmail/backup/backup_mysql.sh

# iRedMail: Cleanup Cluebringer database
1   3   *   *   *   /usr/sbin/cbpadmin --config=/etc/policyd/cluebringer.conf --cleanup >/dev/null

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

# iRedMail: update Awstats statistics for web
1   */1   *   *   *   perl /usr/share/awstats/wwwroot/cgi-bin/awstats.pl -config=web -update >/dev/null

# iRedMail: update Awstats statistics for smtp
1   */1   *   *   *   perl /usr/share/awstats/wwwroot/cgi-bin/awstats.pl -config=smtp -update >/dev/null

[root@mail ~]# grep -i sogo /home/loudking/vmail/backup/backup_mysql.sh
[root@mail ~]# grep -i sogo /var/www/iredadmin/tools/cleanup_amavisd_db.py
[root@mail ~]# grep -i sogo /usr/share/awstats/wwwroot/cgi-bin/awstats.pl
[root@mail ~]# grep -i sogo /usr/share/awstats/wwwroot/cgi-bin/awstats.pl
[root@mail ~]# grep -i sogo /etc/policyd/cluebringer.conf


ZhangHuangbin wrote:

Sorry about this trouble. Please update root's cron job, comment out (or remove) sogo related cron jobs.

4 Reply by ZhangHuangbin

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

Re: postmaster inbox is full because sogo gropuware is not installed

Check SOGo user's cron job.

# crontab -l -u sogo

5 Reply by loudking

  • loudking
  • Member
  • Offline
  • Registered: 2015-04-22
  • Posts: 41

Re: postmaster inbox is full because sogo gropuware is not installed

Thanks. Problem solved.

May I ask one more question please - How to change the receipt's address of logwatcher from root@localhost to someone else?

ZhangHuangbin wrote:

Check SOGo user's cron job.

# crontab -l -u sogo

6 Reply by 7t3chguy

  • 7t3chguy
  • 7t3chguy
  • Forum Moderator
  • Offline
  • From: United Kingdom
  • Registered: 2015-01-08
  • Posts: 713

Re: postmaster inbox is full because sogo gropuware is not installed

Change the command from
{whatever the command is}
to
{whatever the command is} |sendmail user@recipientdomain.com

7t3chguy's Website

7 Reply by ZhangHuangbin

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

Re: postmaster inbox is full because sogo gropuware is not installed

loudking wrote:

May I ask one more question please - How to change the receipt's address of logwatcher from root@localhost to someone else?

Logwatch sends to root user by default, you can change the alias in /etc/postfix/aliases.

8 Reply by 7t3chguy

  • 7t3chguy
  • 7t3chguy
  • Forum Moderator
  • Offline
  • From: United Kingdom
  • Registered: 2015-01-08
  • Posts: 713

Re: postmaster inbox is full because sogo gropuware is not installed

Zhang, if you change it in aliases then everything sent to root will be sent to the alternate one. My way would only send the LogWatch stuff to the alternate user.

7t3chguy's Website

9 Reply by mathieu (edited by mathieu 2016-05-04 22:51:31)

  • mathieu
  • mathieu
  • Member
  • Offline
  • From: Quebec, Canada
  • Registered: 2016-05-04
  • Posts: 7

Re: postmaster inbox is full because sogo gropuware is not installed

Just in case this is still an issue for anyone...

run as root (add sudo if not..):

list cron tabs for sogo user

# crontab -l -u sogo

remove cron tabs for sogo user

# crontab -r -u sogo

mathieu's Website

10 Reply by ZhangHuangbin

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

Re: postmaster inbox is full because sogo gropuware is not installed

mathieu wrote:

remove cron tabs for sogo user

Removing cron jobs is not right. We need those cron jobs.