User Portal Mail Log Doesn't Match Mail Manager

Anyone?

Hi, Dave, and welcome to the UTM Community!

Please insert pictures of a User Portal and Mail Manager that are not in sync.

Cheers - Bob

Hi Bob!

Here is the Mail Manager filtered on the user@ourdomain.com email address

2016-03-30 10:30 1.2.3.4 sender@some.org user@ourdomain.com Delivered -> 10.192.0.50)   7kB 7 s RE: Summary Rpt

2016-03-30 10:26 5.6.7.8 legitsender@domain.com user@ourdomain.com Rejected: Spam   20kB   Re: Response to Employment Opportunity

2016-03-30 10:23 5.6.5.6 legitsender@domain.com user@ourdomain.com Rejected: Spam   20kB   Re: Response to Employment Opportunity

2016-03-30 10:13 1.2.3.4 sender@some.org user@ourdomain.com Delivered -> 10.192.0.50   19kB 3 s RE: Stategy Session

2016-03-30 09:48 10.192.0.50 user@ourdomain.com someuser@yahoo.com Delivered -> 66.196.118.35 (mta7.am0.yahoodns.net)   5kB 13 s Some Subjectt

2016-03-30 09:45 74.3.160.8 junksender@junkdomain.com user@ourdomain.com Rejected: RBL (b.barracudacentral.org)   1kB

Here is the mail log when user@ourdomain.com signs into the portal. Note the two SPAM messages from legitsender@domain.com do not appear to the user

Thanks!

Whoa! I would be tempted to rebuild the PostgreSQL data bases - that does delete all of the data and graphs though.  You might still be able to rebuild only the SMTP databases, and that causes no loss:

/var/mdw/scripts/smtp stop
dropdb -U postgres smtp
createdb -U postgres smtp
/var/mdw/scripts/smtp start

If that doesn't work and after Up2Dating to 9.355, you still have this problem, please report it to Sophos Support as a bug.

Cheers - Bob

Thanks for the tips Bob. I will try this over the weekend.

Hi Bob,

I applied all of the updates up to 9.355-1 two weekends ago and the issue remains. I have not tried the command you gave me, though. If I drop the smtp db will it get recreated from the smtp logs or something?

Thanks!

Yes, Dave, the underlying spool database will be recreated from the list of items in the spool directory. As I recall, the SMTP Log tab is not destroyed by a rebuild, but I also haven't heard of this problem before, so now I wonder if it is not based on a PostgreSQL database and so would be unaffected by a rebuild...

The PostgreSQL databases are not repaired by Up2Dates, so the fact that you still have the problem does indicate the SMTP database is "broken" and in need of regeneration.

If that doesn't work, rebuilding all of the databases should work - it does delete all of your graphs and reporting, but not the log files. I would get Sophos Support involved first and let them do this if they fell necessary.

Cheers - Bob