Re: Frequent Out of Memory for service(config)

2019-05-19 Thread Tom Sommer via dovecot
On 2019-05-13 21:56, Root Kev via dovecot wrote: Hello Group, We have dovecot deployed as solely a Pop3 service that is used by our applications to pass mail from one application to another internally. We have roughly 4 applications that connect to the Pop3 service every 2 seconds, to

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 16:25, John Fawcett via dovecot wrote: > INSERT INTO last_logins (last_login,username,domain) VALUES > (1558273000,'u...@domain.tld','domain.tld') I don't have PostgresSql, would you be able to verify if this syntax would work: INSERT INTO last_logins (last_login,username,domain)

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread mabi via dovecot
‐‐‐ Original Message ‐‐‐ On Sunday, May 19, 2019 4:44 PM, John Fawcett via dovecot wrote: > I don't have PostgresSql, would you be able to verify if this syntax would > work: INSERT INTO last_logins (last_login,username,domain) VALUES > (1558273000,'u...@domain.tld','domain.tld') ON

Re: Repo for RHEL8

2019-05-19 Thread TG Servers via dovecot
On 19/05/2019 18:55, Aki Tuomi via dovecot wrote: On 19 May 2019 19:02 TG Servers via dovecot wrote: Hi, will there be a repo provided underhttps://repo.dovecot.org/ for RHEL8? Or CentOS8 at least then when it's out? Would be

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 22:37, John Fawcett via dovecot wrote: > On 19/05/2019 20:31, mabi via dovecot wrote: >> >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, May 19, 2019 7:36 PM, John Fawcett via dovecot >> wrote: >>> >>> Attached is a tentative patch. I've verified no regression for >>> mysql. There

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 22:45, John Fawcett via dovecot wrote: > On 19/05/2019 22:37, John Fawcett via dovecot wrote: >> On 19/05/2019 20:31, mabi via dovecot wrote: >>> >>> ‐‐‐ Original Message ‐‐‐ >>> On Sunday, May 19, 2019 7:36 PM, John Fawcett via dovecot >>> wrote: Attached is a

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 17:08, mabi via dovecot wrote: > ‐‐‐ Original Message ‐‐‐ > On Sunday, May 19, 2019 4:44 PM, John Fawcett via dovecot > wrote: > >> I don't have PostgresSql, would you be able to verify if this syntax >> would work: INSERT INTO last_logins (last_login,username,domain) >>

Re: Repo for RHEL8

2019-05-19 Thread Aki Tuomi via dovecot
> On 19 May 2019 19:02 TG Servers via dovecot wrote: > > > Hi, > > will there be a repo provided underhttps://repo.dovecot.org/ for RHEL8? > Or CentOS8 at least then when it's out? Would be appreciated as we always > try to use latest versions in RHEL for some apps like dovecot. > >

Permission denied

2019-05-19 Thread @lbutlr via dovecot
mail dovecot: lda(user@domain)<955>: msgid=<4562sm6yyyzv...@mail.covisp.net>: save failed to INBOX: Mailbox INBOX: open(/usr/local/virtual/user@domain/tmp/1558293345.M130062P955.mail.covisp.net) failed: Permission denied The permissions on /usr/local/virual have not changed and are still owed

Repo for RHEL8

2019-05-19 Thread TG Servers via dovecot
Hi, will there be a repo provided under https://repo.dovecot.org/ for RHEL8? Or CentOS8 at least then when it's out? Would be appreciated as we always try to use latest versions in RHEL for some apps like dovecot. Thanks.

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread mabi via dovecot
‐‐‐ Original Message ‐‐‐ On Sunday, May 19, 2019 7:36 PM, John Fawcett via dovecot wrote: > Attached is a tentative patch. I've verified no regression for mysql. There > should be no regression for sqlite as the code path is identical. > > Are you able to test for pgsql? As mentioned

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 20:31, mabi via dovecot wrote: > > ‐‐‐ Original Message ‐‐‐ > On Sunday, May 19, 2019 7:36 PM, John Fawcett via dovecot > wrote: >> >> Attached is a tentative patch. I've verified no regression for mysql. >> There should be no regression for sqlite as the code path is

Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread mabi via dovecot
Hello, I am trying to setup the last_login plugin on Dovecot 2.3 in order to log a user's last IMAP login into a separate PostgreSQL table called last_login. I am actually following that guide: https://docs.iredmail.org/track.user.last.login.html with the exception that I use PostgreSQL

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread mabi via dovecot
‐‐‐ Original Message ‐‐‐ On Sunday, May 19, 2019 2:58 PM, John Fawcett via dovecot wrote: > I guess it is not supported for PostgreSQL or Sqlite, since they don't > have "ON DUPLICATE KEY UPDATE" statement which is what is being used in > MySQL. That's it, PostgreSQL does not have "ON

RE: Merging existing mailboxes to aliases

2019-05-19 Thread Marc Roos via dovecot
The alias plugin does not work properly afaik, I have been trying to use it on a default centos6/7 release. If I remember correctly it messes up with sub folders. Check mailing list archive. -Original Message- From: Lefteris Tsintjelis via dovecot [mailto:dovecot@dovecot.org] Sent:

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread mabi via dovecot
‐‐‐ Original Message ‐‐‐ On Sunday, May 19, 2019 3:57 PM, Aki Tuomi wrote: > It would be a feature request, also note that it's only available since > version 9.5, so it really won't help anyone before that. Would opening an issue as feature request on GitHub on the dovecot/core

Re: Merging existing mailboxes to aliases

2019-05-19 Thread Lefteris Tsintjelis via dovecot
On 19/5/2019 16:04, Sami Ketola via dovecot wrote: Why do you want to do this? Thunderbird does obey special_use flags. https://wiki.dovecot.org/MailboxSettings Do you have other clients then that do not honor those? Sami Thunderbird was just a test client nothing more than that and it

Re: Merging existing mailboxes to aliases

2019-05-19 Thread Lefteris Tsintjelis via dovecot
I have just tested an account with Thunderbird as client and had a couple of problems. I also wonder if you have to apply sieve rules in each alias separately. That would complicate things even more but the concept is good though. On 19/5/2019 11:43, Marc Roos via dovecot wrote: The alias

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 15:42, mabi via dovecot wrote: > ‐‐‐ Original Message ‐‐‐ > On Sunday, May 19, 2019 2:58 PM, John Fawcett via dovecot > wrote: > >> I guess it is not supported for PostgreSQL or Sqlite, since they don't >> have "ON DUPLICATE KEY UPDATE" statement which is what is being used

Re: Merging existing mailboxes to aliases

2019-05-19 Thread Sami Ketola via dovecot
> On 19 May 2019, at 7.08, Lefteris Tsintjelis via dovecot > wrote: > > I am trying to merge all, existing or not, different mailboxes in one with > the mailbox alias plugin. If I add the following lines, will the existing > mailboxes automatically merge in one mailbox and corresponding

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread John Fawcett via dovecot
On 19/05/2019 12:52, mabi via dovecot wrote: > Hello, > > I am trying to setup the last_login plugin on Dovecot 2.3 in order to log a > user's last IMAP login into a separate PostgreSQL table called last_login. I > am actually following that guide: >

Re: Dict issue with PostgreSQL for last_login plugin (duplicate key)

2019-05-19 Thread Aki Tuomi via dovecot
> On 19 May 2019 16:42 mabi via dovecot wrote: > > > ‐‐‐ Original Message ‐‐‐ > On Sunday, May 19, 2019 2:58 PM, John Fawcett via dovecot > wrote: > > > I guess it is not supported for PostgreSQL or Sqlite, since they don't > > have "ON DUPLICATE KEY UPDATE" statement which is

Plugins/Mailcrypt: mail_crypt_private_password not assigned by password_query

2019-05-19 Thread Max Kostikov via dovecot
I try to use Mailcrypt encrypted user keys with conjustion with dbsync replication(Dovecot 2.3.6 in FreeBSD 12.0 enviroment) but was unsuccessful. If I provide a password in mail_crypt_private_password variable directly in Dovecot config all things works as expected plugin {

Create a malicious directory

2019-05-19 Thread lty via dovecot
Use scripts to create some malicious directories. Here is my creation process. How can I prevent the creation of these directories? I used the python imapclient script to create a directory. There may be no big threat to dovecot, but it is dangerous for doveadm.

Directory name have some malicious characters.

2019-05-19 Thread hfh via dovecot
Directory name have some malicious characters, is it safe?How can I exclude some characters,thanks!