Koozali.org: home of the SME Server

Mailsorting Question

Offline wifipilot

  • *
  • 14
  • +0/-0
Mailsorting Question
« on: October 14, 2024, 10:49:34 PM »
guys please can you explain the following

Mailsorting - https://wiki.koozali.org/Mailsorting

I am using SME 10.1 in Server-Only Mode

I want to know if i install the mailsorting contrib and issue the following

# db configuration setprop qmail FilterType maildrop
# signal-event mailsorting-conf

Then

# db processmail setprop maildrop deldups yes
# signal-event mailsorting-conf

Would that help to DELETE Duplicate Mail for All Users?

All users are using Outlook 2016 and Outlook 2019

Any help greatly appreciated
« Last Edit: October 15, 2024, 07:58:10 AM by wifipilot »

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Mailsorting Question
« Reply #1 on: October 15, 2024, 09:51:27 AM »
first question: how is configure outlook? POP3 or IMAP?
please be aware that IMAP support in outlook simply su**s

the second one: are you sure you've duplicate email? do you see them duplicate in webmail?

you'd take a look ad imapsync; IIRC, it can do whato you're asking for

Offline wifipilot

  • *
  • 14
  • +0/-0
Re: Mailsorting Question
« Reply #2 on: October 15, 2024, 11:05:48 AM »
Stefano thank you for your time and support

first question: how is configure outlook? POP3 or IMAP? - POP3 AND POP3S [ Port forward is in place for EXTERNAL Users ]
please be aware that IMAP support in outlook simply su**s - ABSOLUTELY AGREE!!

the second one: are you sure you've duplicate email? do you see them duplicate in webmail? - Will Check

you'd take a look ad imapsync; IIRC, it can do whato you're asking for - Will investigate

Is there Log File that will show " maildrop deldups " ?

Also i am finding that me Remote Users Cannot use Port 995 on Outlook to Receive any email. The Remote Users Outlook setting needs to be Port 110 to receive maul. Could this be due to an SSL Issue?

Thank you again

Offline ReetP

  • *
  • 3,940
  • +6/-0
Re: Mailsorting Question
« Reply #3 on: October 15, 2024, 12:05:55 PM »
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Mailsorting Question
« Reply #4 on: October 15, 2024, 12:13:00 PM »

POP3 AND POP3S [ Port forward is in place for EXTERNAL Users ]


well.. first of all check if you really have duplicated emails via webmail.. I suspect outlook is having issues (strange, isn't it?)

other question: how do you get your mail on your server? smtp? fetchmail?

Offline ReetP

  • *
  • 3,940
  • +6/-0
Re: Mailsorting Question
« Reply #5 on: October 15, 2024, 07:54:42 PM »
outlook is having issues (strange, isn't it?)

Cynic.... :lol:

I'll get my coat....
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline wifipilot

  • *
  • 14
  • +0/-0
Re: Mailsorting Question
« Reply #6 on: October 16, 2024, 07:42:19 AM »
Stefano thank you for your help

 first of all check if you really have duplicated emails via webmail. YES There is Duplicate Emails on the Webamail Interface for a few Users

other question: how do you get your mail on your server? smtp? fetchmail? - I collect all email via a Hetzner CATCHALL Account using SMTP. Using Multidrop to Distribute the email

BTW is there a way to collect mail from the CATCHALL Account every 3 Minutes instead of the 5 Minute interval?

Any help greatly appreciated

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Mailsorting Question
« Reply #7 on: October 16, 2024, 08:47:44 AM »
I collect all email via a Hetzner CATCHALL Account using SMTP. Using Multidrop to Distribute the email

well. before starting deleting emails, I'd start checking why your email are collected twice
Quote
BTW is there a way to collect mail from the CATCHALL Account every 3 Minutes instead of the 5 Minute interval?

believe me, you don't want it

Offline wifipilot

  • *
  • 14
  • +0/-0
Re: Mailsorting Question
« Reply #8 on: October 16, 2024, 02:01:38 PM »
Stefano thank you for your reply

well. before starting deleting emails, I'd start checking why your email are collected twice - For some reason the Local and Remote Outlook Users cannot authenticate using Port 25 and Auto Encryption for SMTP. Outlook config Keeps saying: None of the Authentication methods supported by this client are supported by your server
I have to set Outlook to 465 and SSL Authentication for Both Local and Remote Users


The SME 10.1 Server Outgoing Delivery of ALL Mail via SMTP Server set to SMTP2GO.COM as the Mail Delivery agent

I have noticed that if i setup Outlook on the Remote Users to use the Same SMTP2GO Account then duplicate emails are received especially if a User Sends a message to say 8+ members in the company.


BTW is there a way to collect mail from the CATCHALL Account every 3 Minutes instead of the 5 Minute interval?

i'm doing something wrong here.

I am thinking of changing the SMTP Delivery Agent to Hetzner on the server

believe me, you don't want it - UNDERSTOOD

Any help greatly appreciated
« Last Edit: October 16, 2024, 02:03:24 PM by wifipilot »

Offline ReetP

  • *
  • 3,940
  • +6/-0
Re: Mailsorting Question
« Reply #9 on: October 16, 2024, 02:29:27 PM »
Don't use port 25 authenticating. Use the correct secure ports - 465 (and on v11 587 will be available as well)

Have a read around as to why.

So you use smtp2go to send and Hetzner to receive.

It will simplify things for you if ALL your users ONLY connect to your SME server. Do not let them send or receive via the upstream systems - I'd imagine that is where your issues lie.

Then you can change upstream providers whenever you want.

You can also see all connections in and out which will simplify debugging if it still occurs.

Quote
BTW is there a way to collect mail from the CATCHALL Account every 3 Minutes instead of the 5 Minute interval?

Quote
believe me, you don't want it

Quote
UNDERSTOOD

First, a couple of minutes won't make any material difference unless your users are literally glued to their devices every second of the day.

It will probably cause more problems than it solves, especially when someone tries to send you a 200Mb attachment and it clogs up your mail server.

The real solution is to dump the whole POP3 kludge and use your server as a full SMTP server to receive mail, and the clients to use IMAP.

(you can still use an upstream service to send mail - I do that myself)




...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline wifipilot

  • *
  • 14
  • +0/-0
Re: Mailsorting Question
« Reply #10 on: October 16, 2024, 02:52:36 PM »
Reetp WOW man what can i say

Thank you for taking your time to explain, much appreciated

I will use Hetzner for the SMTP Server Delivery Agent

I will use port 465 for delivery and 110 for receiving on the Local and Remote Outlook clients

Thank you again guys for your support

Offline Jean-Philippe Pialasse

  • *
  • 2,907
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Mailsorting Question
« Reply #11 on: October 16, 2024, 04:02:10 PM »
drop POP3.
as stated earlier clearly IMAP support on outlook sucks.
but what has been stated through the different posts , maybe less clearly, is that POP3 sucks more.

Most of your duplicates on client side are probably due to usage of POP3.

Offline ReetP

  • *
  • 3,940
  • +6/-0
Re: Mailsorting Question
« Reply #12 on: October 16, 2024, 04:21:19 PM »
Reetp WOW man what can i say

Thank you for taking your time to explain, much appreciated

No worries

Quote
I will use Hetzner for the SMTP Server Delivery Agent

Yup  - fine.

Quote
I will use port 465 for delivery

Yup - fine.

Quote
and 110 for receiving on the Local and Remote Outlook clients

Nope - terrble idea. Use IMAP because as mentioned POP3 sucks and should be burned in the fiery pits of hell.

Use IMAP. End of.

In Outlook you used to need a 'post send' action to move the sent mail from the local Sent to the IMAP Sent folder (becuase Outlook also sucks)

Please check.

But scrap POP3 as completely as soon as possible.


...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation