Possible bug with last_login plugin and PostgreSQL

2019-04-01 Thread Zhang Huangbin via dovecot
Dear all, I'm trying to get last_login plugin working with PostgreSQL, but seems Dovecot doesn't handle duplicate key while updating last login time (note: same setting works fine with MariaDB). I wonder whether it's a bug of Dovecot or i should handle this with PostgreSQL trigger. OS: OpenBSD 6

Re: Possible bug with last_login plugin and PostgreSQL

2019-04-01 Thread Zhang Huangbin via dovecot
> On Apr 1, 2019, at 6:39 PM, Zhang Huangbin wrote: > > I'm trying to get last_login plugin working with PostgreSQL, but seems Dovecot > doesn't handle duplicate key while updating last login time (note: same > setting > works fine with MariaDB). I wonder whether it's a bug of Dovecot or i sho

Feature request: exclude IP/network in allow_nets extra field

2019-04-29 Thread Zhang Huangbin via dovecot
Dear all, We use `allow_nets`[1] to restrict login clients, it works fine. Recently we need to allow some users to login from everywhere except some IP/networks, how can we accomplish this with "allow_nets"? Tried allow_nets="!a.b.c.d", but Dovecot reports error "allow_nets: Invalid network '!a

Re: Feature request: exclude IP/network in allow_nets extra field

2019-04-29 Thread Zhang Huangbin via dovecot
> On Apr 30, 2019, at 11:21 AM, @lbutlr via dovecot wrote: > > On 29 Apr 2019, at 19:56, Zhang Huangbin via dovecot > wrote: >> Recently we need to allow some users to login from everywhere except some >> IP/networks, > > Can you use firewall rules for

Re: Feature request: exclude IP/network in allow_nets extra field

2019-04-30 Thread Zhang Huangbin via dovecot
> On Apr 30, 2019, at 2:32 PM, Malcolm via dovecot wrote: > > On 4/29/2019 11:20 PM, Zhang Huangbin via dovecot wrote: >> I understand what "allow" means. But it will be very handy to support >> something like "!a.b.c.d" to allow all but just exclud

Re: Feature request: exclude IP/network in allow_nets extra field

2019-04-30 Thread Zhang Huangbin via dovecot
> On Apr 30, 2019, at 2:35 PM, Sami Ketola via dovecot > wrote: > > Just create another passdb for these premium users before the actual passdb > and add skip = authenticated to the actual passdb. Dear Sami, Thank you for the suggestion. Adding more passdb is not ideal at all, if we have

Re: Feature request: exclude IP/network in allow_nets extra field

2019-04-30 Thread Zhang Huangbin via dovecot
> On Apr 30, 2019, at 10:37 PM, andre via dovecot wrote: > > You can easily do this without a new feature in Dovecot. > > - Create a post login script, for instance, in bash. > - install grepcidr on your server. > > Your post login script can use grepcidr to check for white or black list. >

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

2019-05-28 Thread Zhang Huangbin via dovecot
> On May 29, 2019, at 2:01 PM, Aki Tuomi via dovecot > wrote: > > We'll take this under consideration, but no promises. Dear Aki, I reported this issue and request before: https://marc.info/?t=15541153161&r=1&w=2 Hope we can have this feature soon. :) Thank you very much.

Re: LastLogin update

2019-06-22 Thread Zhang Huangbin via dovecot
> On Jun 23, 2019, at 4:43 AM, @lbutlr via dovecot wrote: > >> https://docs.iredmail.org/track.user.last.login.html > > This is cool, but I have a question: > >> For MySQL/MariaDB backends, we create the sql table in database vmail. > > Would this interfere with or confuse postfixadmin? I u