Re: Fwd: Load balancer for dovecot servers - Not able to send emails

2020-04-23 Thread John Stoffel


Kishore> Thank you for the reply.  Actually it was setup like this by
Kishore> another member, who left the team/ company recently. Now it
Kishore> came to me to handle that responsibility. That's how I got in
Kishore> to this. At present I am not able to migrate/upgrade
Kishore> immediately. Because it sends emails around 100K+ emails
Kishore> everyday and I do not want to disturb that.

Dovecot doesn't do *any* mailing, that's handled by postfix or
sendmail or qmail.  I think postfix is the best.  You can run your
outgoing email on a seperate server without any problems.

Kishore> Coming back to your question, Actually the connection is : 

Kishore> O365/Outlook >> SMTP Gateway Server >> testing.test.com >> 2 POP3 
servers.

Why are you running POP3 in this day and age?  Wait, don't answer
that.  :-)

Kishore> Actually "testing.test.com", that is FQDN  name set in F5
Kishore> load balancer, where it is having the 2 POP3 servers to route
Kishore> the emails. 

By POP3, I assume you mean the two dovecot servers?

Kishore> When the email was sent from Outlook/O365, first it goes to
Kishore> SMTP Gateway Server. Now the SMTP Gateway server has the
Kishore> postfix rule to send it to "testing.test.com". In this
Kishore> location, I am getting the error in SMTP Gateway Server,
Kishore> where it is not able connect ( lost connection with 
Kishore> testing.test.com [xxx.xxx.xxx.xxx] while receiving the
Kishore> initial server greeting). 

What is the gateway server and how is it configured to deliver the
mail to the backend servers?  

Kishore> In SMTP Gateway server, instead of "testing.test.com", if i
Kishore> give the name/ip of any POP3 server, then email delivery is
Kishore> happening successfully to that POP3 server. The above error
Kishore> is coming only when i use the fqdn "testing.test.com",
Kishore> instead of direct POP3 server. 

This is because your two backend servers probably don't know how to
accept email for the testing.test.com domain IP/name.  Again, this
sounds like a mailing problem, not a dovecot problem.  

You need to provide lots of details here.  And ideally the logs from
both the SMTP gateway, and the two backend servers, along with full
details of how they are configured.

But from what I see here, this is a mail configuration problem, not a
dovecot issue.  But you don't give enough details.  


Kishore> Please let me know if you need any more details. Could you please help 
me here.



Kishore> On Thu, Apr 23, 2020 at 7:13 PM John Stoffel  wrote:

>> "Kishore" == Kishore Potnuru  writes:
   
Kishore> I have the dovecot version 2.0.9 installed on RHEL linux 6.10
Kishore> version. It's a single/standalone Live server. 
   
Kishore> You should really upgradr your setup. 
   
Kishore> Now I have created another server with the same configuration
Kishore> for the resilince purpose. I also tested and I am able to
Kishore> send the emails to both of the dovecot servers
Kishore> separately/individually.  They are working fine.
   
Kishore> Dovecot doesn't do the mailing between systems, so i assume you've 
got
Kishore> postfix configured?  And do you have shared storage behind your two
Kishore> dovecot instances so that your users don't have to login to 
multiple
Kishore> systems to get emails?
   
Kishore> Did you read the docs at:
   
Kishore>   
https://doc.dovecot.org/admin_manual/dovecot_cluster_architecture/ 
   
Kishore> Now I have added those two servers under a F5 load balancer
Kishore> and created a FQDN (example: testing.test.com). I changed the
Kishore> rules to send the traffic to FQDN "testing.test.com", where
Kishore> it should redirect the email to one of those 2 servers.
   
Kishore> So how is your F5 configured to work when one server is down? 
   
Kishore> When I sent the email to FQDN "testing.test.com", I am getting the 
below error.
   
Kishore> pf1_inbd/smtp[30292]: 66A5F5F6: to=,
Kishore> relay=testing.test.com[xxx.xxx.xxx.xxx]:25, delay=13,
Kishore> delays=0.09/0.08/13/0, dsn=4.4.2, status=deferred (lost
Kishore> connection with testing.test.com [xxx.xxx.xxx.xxx] while
Kishore> receiving the initial server greeting)
   
Kishore> Could you please let me know how to fix this issue? It's a great help 
for me.
   
Kishore> Sounds like you haven't actually setup your system correctly.  But
Kishore> we're not going to be able to help until you provide more details.
Kishore> It's also not clear from the about log file *which* server gave you
Kishore> this error.
   
Kishore> It would be smarted to start from scratch with an upto date 
install of
Kishore> dovecot (and postfix in my opinion) according to the Dovecot docs
Kishore> above, and test that out in a test environment.  Then you would use
Kishore> 'doveadm' sync to migrate user accounts over to the new system.
   
Kishore> John



Batching quota clone updates

2020-04-23 Thread micah anderson


Hi,

I like the quota count+clone configuration. However, I'm wondering if
the cloning process could batch its updates into chunks, or spread them
out over time?

The clone updates happen whenever the quota is updated, typically this
is fine, but when a tsunami of spam comes resulting in delivery to every
user on the system, then can be quite overwhelming for a sql server to
do an update for every user.

Thanks!

-- 
micah


Re: Fwd: Load balancer for dovecot servers - Not able to send emails

2020-04-23 Thread Kishore Potnuru
Hi John,

Thank you for the reply.  Actually it was setup like this by another
member, who left the team/company recently. Now it came to me to handle
that responsibility. That's how I got in to this. At present I am not able
to migrate/upgrade immediately. Because it sends emails around 100K+ emails
everyday and I do not want to disturb that.

Coming back to your question, Actually the connection is :

O365/Outlook >> SMTP Gateway Server >> testing.test.com >> 2 POP3 servers.

Actually "testing.test.com", that is FQDN  name set in F5 load balancer,
where it is having the 2 POP3 servers to route the emails.
When the email was sent from Outlook/O365, first it goes to SMTP Gateway
Server. Now the SMTP Gateway server has the postfix rule to send it to "
testing.test.com". In this location, I am getting the error in SMTP Gateway
Server, where it is not able connect ( lost connection with
testing.test.com [xxx.xxx.xxx.xxx]
while receiving the initial server greeting).

In SMTP Gateway server, instead of "testing.test.com", if i give the
name/ip of any POP3 server, then email delivery is happening successfully
to that POP3 server. The above error is coming only when i use the fqdn "
testing.test.com", instead of direct POP3 server.

Please let me know if you need any more details. Could you please help me
here.

Thanks,
Kishore Potnuru

On Thu, Apr 23, 2020 at 7:13 PM John Stoffel  wrote:

> > "Kishore" == Kishore Potnuru  writes:
>
> Kishore> I have the dovecot version 2.0.9 installed on RHEL linux 6.10
> Kishore> version. It's a single/standalone Live server.
>
> You should really upgradr your setup.
>
> Kishore> Now I have created another server with the same configuration
> Kishore> for the resilince purpose. I also tested and I am able to
> Kishore> send the emails to both of the dovecot servers
> Kishore> separately/individually.  They are working fine.
>
> Dovecot doesn't do the mailing between systems, so i assume you've got
> postfix configured?  And do you have shared storage behind your two
> dovecot instances so that your users don't have to login to multiple
> systems to get emails?
>
> Did you read the docs at:
>
>   https://doc.dovecot.org/admin_manual/dovecot_cluster_architecture/
>
> Kishore> Now I have added those two servers under a F5 load balancer
> Kishore> and created a FQDN (example: testing.test.com). I changed the
> Kishore> rules to send the traffic to FQDN "testing.test.com", where
> Kishore> it should redirect the email to one of those 2 servers.
>
> So how is your F5 configured to work when one server is down?
>
> Kishore> When I sent the email to FQDN "testing.test.com", I am getting
> the below error.
>
> Kishore> pf1_inbd/smtp[30292]: 66A5F5F6: to=,
> Kishore> relay=testing.test.com[xxx.xxx.xxx.xxx]:25, delay=13,
> Kishore> delays=0.09/0.08/13/0, dsn=4.4.2, status=deferred (lost
> Kishore> connection with testing.test.com [xxx.xxx.xxx.xxx] while
> Kishore> receiving the initial server greeting)
>
> Kishore> Could you please let me know how to fix this issue? It's a great
> help for me.
>
> Sounds like you haven't actually setup your system correctly.  But
> we're not going to be able to help until you provide more details.
> It's also not clear from the about log file *which* server gave you
> this error.
>
> It would be smarted to start from scratch with an upto date install of
> dovecot (and postfix in my opinion) according to the Dovecot docs
> above, and test that out in a test environment.  Then you would use
> 'doveadm' sync to migrate user accounts over to the new system.
>
> John
>
>
>


Re: Fwd: Load balancer for dovecot servers - Not able to send emails

2020-04-23 Thread John Stoffel
> "Kishore" == Kishore Potnuru  writes:

Kishore> I have the dovecot version 2.0.9 installed on RHEL linux 6.10
Kishore> version. It's a single/standalone Live server. 

You should really upgradr your setup.  

Kishore> Now I have created another server with the same configuration
Kishore> for the resilince purpose. I also tested and I am able to
Kishore> send the emails to both of the dovecot servers
Kishore> separately/individually.  They are working fine.

Dovecot doesn't do the mailing between systems, so i assume you've got
postfix configured?  And do you have shared storage behind your two
dovecot instances so that your users don't have to login to multiple
systems to get emails?

Did you read the docs at:

  https://doc.dovecot.org/admin_manual/dovecot_cluster_architecture/  

Kishore> Now I have added those two servers under a F5 load balancer
Kishore> and created a FQDN (example: testing.test.com). I changed the
Kishore> rules to send the traffic to FQDN "testing.test.com", where
Kishore> it should redirect the email to one of those 2 servers.

So how is your F5 configured to work when one server is down?  

Kishore> When I sent the email to FQDN "testing.test.com", I am getting the 
below error.

Kishore> pf1_inbd/smtp[30292]: 66A5F5F6: to=,
Kishore> relay=testing.test.com[xxx.xxx.xxx.xxx]:25, delay=13,
Kishore> delays=0.09/0.08/13/0, dsn=4.4.2, status=deferred (lost
Kishore> connection with testing.test.com [xxx.xxx.xxx.xxx] while
Kishore> receiving the initial server greeting)

Kishore> Could you please let me know how to fix this issue? It's a great help 
for me.

Sounds like you haven't actually setup your system correctly.  But
we're not going to be able to help until you provide more details.
It's also not clear from the about log file *which* server gave you
this error.

It would be smarted to start from scratch with an upto date install of
dovecot (and postfix in my opinion) according to the Dovecot docs
above, and test that out in a test environment.  Then you would use
'doveadm' sync to migrate user accounts over to the new system.

John




Help with Shared Mailboxes

2020-04-23 Thread Alan Stevens
dovecot version = 2.2..27
I have a running debian server ( jessie-backports ) supporting email for three 
different domains. It is working fine.
My boss has asked me to look into using Shared folders/mailboxes - for 
instance, he wants selected users of Domain-A to be able to see the shared 
Inbox of the user "support" who is also in Domain-A. 
Sorry if my questions are basic, but here goes:-
1. Can I simply change the relevant dovecot configuration files and introduce 
Shared mailboxes into an already running system? 
  Very basically, add the imap-acl plugin, the shared namespace, the dict file 
and restart dovecot?
2. If I can do this, would it wipe out the tens of thousands of existing emails 
I have on the system now?   i.e. Does Sharing have to be introduced when new 
email server is being brought up? Can it be added on-the-fly to my working 
server?
Would the emails in /var/mail/vmail/Domain-A/alan/mail seemlessly populate 
/var/mail/vmail/Domain-A/Shared/alan/mail after making such changes?
3. If adding the Sharing to my running system is possible, can I add it on only 
one of my three domains? I have a test domain with one user.   My principle 
domain ( Domain-A ) has many users, and as I stated previously, very very many 
stored emails. Emails I absolutely cannot afford to lose.
Any insights are appreciated.
Alan Stevens

---||---
alanrstev...@yahoo.com
https://www.linkedin.com/in/alanrstevens




Fwd: Load balancer for dovecot servers - Not able to send emails

2020-04-23 Thread Kishore Potnuru
Hi All,

I need your help on one of the issue in Dovecot.

I have the dovecot version 2.0.9 installed on RHEL linux 6.10 version. It's
a single/standalone Live server.

Now I have created another server with the same configuration for the
resilince purpose. I also tested and I am able to send the emails to both
of the dovecot servers separately/individually. They are working fine.

Now I have added those two servers under a F5 load balancer and created a
FQDN (example: testing.test.com). I changed the rules to send the traffic
to FQDN "testing.test.com", where it should redirect the email to one of
those 2 servers.

When I sent the email to FQDN "testing.test.com", I am getting the below
error.

pf1_inbd/smtp[30292]: 66A5F5F6: to=,
relay=testing.test.com[xxx.xxx.xxx.xxx]:25,
delay=13, delays=0.09/0.08/13/0, dsn=4.4.2, status=deferred (lost
connection with testing.test.com [xxx.xxx.xxx.xxx] while receiving the
initial server greeting)

Could you please let me know how to fix this issue? It's a great help for
me.

Thanks & Regards,
Kishore Potnuru

>


Re: Testing COI

2020-04-23 Thread lists
Am 23.04.2020 um 17:15 schrieb Aki Tuomi :
> 
> 
>> On 23/04/2020 18:12 li...@mlserv.org wrote:
>> 
>> 
>> Hi,
>> 
>> I am playing around with the COI plugin and try to get things working.
>> 
>> I followed the Dovecot docs and also got the source from Github 
>> (dovecot/coi).
>> 
>> I have compiled and installed coi successfully.
>> 
>> IMAP seems to be fine, but LMTP has some errors in the logs, so I removed 
>> imap_coi for the moment:
>> 
>> Apr 23 17:05:16 mx dovecot: lmtp(10752): Fatal: Couldn't load required 
>> plugin /usr/lib64/dovecot/lib11_imap_coi_plugin.so: dlopen() failed: 
>> /usr/lib64/dovecot/lib11_imap_coi_plugin.so: undefined symbol: 
>> client_add_capability
>> 
>> I am running Dovecot 2.3.10 and coi at the same version.
>> 
>> Am I missing something here?
>> 
>> Thanks in advance
>> 
>> Christian
>> --
>> Rößner-Network-Solutions
>> Karl-Bröger-Str. 10, 36304 Alsfeld
>> Fax: +49 6631 78823409, Mobil: +49 171 9905345
>> USt-IdNr.: DE225643613, https://roessner.website
>> PGP fingerprint: 658D 1342 B762 F484 2DDF 1E88 38A5 4346 D727 94E5
> imap_coi_plugin can only be loaded for imap.
> 
> 
> protocol imap {
>   mail_plugins = $mail_plugins imap_coi
> }
> 
> protocol lmtp {
>   mail_plugins = $mail_plugins lmtp_coi

*plonk* Many thanks. That solved my problems

Christian

> }
> ---
> Aki Tuomi
> 

--
Rößner-Network-Solutions
Karl-Bröger-Str. 10, 36304 Alsfeld
Fax: +49 6631 78823409, Mobil: +49 171 9905345
USt-IdNr.: DE225643613, https://roessner.website
PGP fingerprint: 658D 1342 B762 F484 2DDF 1E88 38A5 4346 D727 94E5



signature.asc
Description: Message signed with OpenPGP


Re: Testing COI

2020-04-23 Thread Aki Tuomi


 
 
  
   
  
  
   
On 23/04/2020 18:12 
li...@mlserv.org wrote:
   
   

   
   

   
   
Hi,
   
   

   
   
I am playing around with the COI plugin and try to get things working.
   
   

   
   
I followed the Dovecot docs and also got the source from Github (dovecot/coi).
   
   

   
   
I have compiled and installed coi successfully.
   
   

   
   
IMAP seems to be fine, but LMTP has some errors in the logs, so I removed imap_coi for the moment:
   
   

   
   
Apr 23 17:05:16 mx dovecot: lmtp(10752): Fatal: Couldn't load required plugin /usr/lib64/dovecot/lib11_imap_coi_plugin.so: dlopen() failed: /usr/lib64/dovecot/lib11_imap_coi_plugin.so: undefined symbol: client_add_capability
   
   

   
   
I am running Dovecot 2.3.10 and coi at the same version.
   
   

   
   
Am I missing something here?
   
   

   
   
Thanks in advance
   
   

   
   
Christian
   
   
--
   
   
Rößner-Network-Solutions
   
   
Karl-Bröger-Str. 10, 36304 Alsfeld
   
   
Fax: +49 6631 78823409, Mobil: +49 171 9905345
   
   
USt-IdNr.: DE225643613, 
https://roessner.website
   
   
PGP fingerprint: 658D 1342 B762 F484 2DDF 1E88 38A5 4346 D727 94E5
   
  
  
   imap_coi_plugin can only be loaded for imap.
  
  
   
  
  
   
  
  
   protocol imap {
  
  
     mail_plugins = $mail_plugins imap_coi
  
  
   }
  
  
   
  
  
   
protocol lmtp {
   
   
  mail_plugins = $mail_plugins lmtp_coi
   
   
}
   
  
  
   ---
Aki Tuomi
   
 



Testing COI

2020-04-23 Thread lists
Hi,

I am playing around with the COI plugin and try to get things working.

I followed the Dovecot docs and also got the source from Github (dovecot/coi).

I have compiled and installed coi successfully.

IMAP seems to be fine, but LMTP has some errors in the logs, so I removed 
imap_coi for the moment:

Apr 23 17:05:16 mx dovecot: lmtp(10752): Fatal: Couldn't load required plugin 
/usr/lib64/dovecot/lib11_imap_coi_plugin.so: dlopen() failed: 
/usr/lib64/dovecot/lib11_imap_coi_plugin.so: undefined symbol: 
client_add_capability

I am running Dovecot 2.3.10 and coi at the same version.

Am I missing something here?

Thanks in advance

Christian
-- 
Rößner-Network-Solutions
Karl-Bröger-Str. 10, 36304 Alsfeld
Fax: +49 6631 78823409, Mobil: +49 171 9905345
USt-IdNr.: DE225643613, https://roessner.website
PGP fingerprint: 658D 1342 B762 F484 2DDF 1E88 38A5 4346 D727 94E5 



Re-to-archived-thread: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2020-04-23 Thread lists
Hi,

I have tried to implement last_login with PostgreSQL and I found an old thread 
from June 2019. I have found a simple solution that I want to share with you:

I followed the instructions on how to set up a last_login on the official 
documentation. Therefor I creates a very simple table having userid and 
last_login fields. Added plugin and dict information.

I received the duplicate key errors and I did this trick for now, which seems 
to solve this issue:

CREATE OR REPLACE RULE insert_to_update AS
ON INSERT
TO users WHERE EXISTS (SELECT userid FROM users WHERE userid = 
NEW.userid)
DO INSTEAD
UPDATE users SET last_login = NEW.last_login WHERE userid = NEW.userid

With this rule in place, INSERTs are changed to UPDATEs, if a userid entry 
already exists. No ned to patch code.

Feel free to comment :-)

Christian

Thread online: https://www.dovecot.org/list/dovecot/2019-May/115921.html
-- 
Rößner-Network-Solutions
Karl-Bröger-Str. 10, 36304 Alsfeld
Fax: +49 6631 78823409, Mobil: +49 171 9905345
USt-IdNr.: DE225643613, https://roessner.website
PGP fingerprint: 658D 1342 B762 F484 2DDF 1E88 38A5 4346 D727 94E5