thr3ads.net - dovecot - Per-user quota (passwd) [Sep 2017]

If this information is useful, please help other people find it:
Share via:

Aki Tuomi

2017-Jun-29 11:40 UTC

Per-user quota (passwd)

Oh you have multiple db's, I missed that.

Remove auth_username_format, and instead

userdb {
  args = /etc/imap.passwd username_format=%Ln
  driver = passwd-file
  override_fields = home=/var/vmail/glu_vrem/%u
}

On 29.06.2017 14:35, Evgeniy Korneechev wrote:> with auth_username_format = %Ln:
>
> Jun 28 14:43:41 auth: Debug: master in: USER    1    iivanov.ia at
example.com   service=lda
> Jun 28 14:43:41 auth-worker(18369): Debug: passwd(iivanov.ia): lookup
> Jun 28 14:43:41 auth-worker(18369): Info: passwd(iivanov.ia): unknown user 
- trying the next userdb
> Jun 28 14:43:41 auth-worker(18369): Debug: sql(iivanov.ia): SELECT email as
user, maildir as home, CONCAT('maildir:', maildir, '/Maildir')
as mail, uid, gid, \
>      CONCAT('*:storage=', quota, 'B') AS quota_rule,
CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login =
'iivanov.ia' OR email = 'iivanov.ia')
> Jun 28 14:43:41 auth-worker(18369): Info: sql(iivanov.ia): unknown user
>
> Maybe %Lu?
>
> ----- ???????? ????????? -----
>> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
>> ????: "dovecot" <dovecot at dovecot.org>
>> ????????????: ???????, 29 ???? 2017 ? 14:10:07
>> ????: Re: Per-user quota (passwd)
>> Yes.
>>
>> Aki
>>
>> On 29.06.2017 14:07, Evgeniy Korneechev wrote:
>>> And if such a user:
>>> email (from AD) = ivanov.ia at example.com
>>> login (from AD), %n = iivanov
>>> %d = DOM
>>> %u = iivanov at DOM
>>>
>>> ?
>>>
>>> ----- ???????? ????????? -----
>>>> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
>>>> ????: "dovecot" <dovecot at dovecot.org>
>>>> ????????????: ???????, 29 ???? 2017 ? 13:59:05
>>>> ????: Re: Per-user quota (passwd)
>>>> or use, as I indicated before, auth_username_format = %Ln
>>>>
>>>> Aki
>>>>
>>>>
>>>> On 29.06.2017 13:58, Evgeniy Korneechev wrote:
>>>>> Hi!
>>>>> workaround:
>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>> administrator at
email.dom:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>
>>>>> But this is not a solution for 1000 users ...
>>>>> Maybe is there extra field "userdb_mail=administrator
at email.dom" for email to
>>>>> passwd-file?
>>>>>
>>>>> ----- ???????? ????????? -----
>>>>>> ??: "Aki Tuomi" <aki.tuomi at
dovecot.fi>
>>>>>> ????: "dovecot" <dovecot at
dovecot.org>
>>>>>> ????????????: ?????, 28 ???? 2017 ? 12:40:48
>>>>>> ????: Re: Per-user quota (passwd)
>>>>>> On 28.06.2017 12:36, Aki Tuomi wrote:
>>>>>>> On 28.06.2017 12:25, Evgeniy Korneechev wrote:
>>>>>>>> Hello!
>>>>>>>> We have passwd=pam, userdb=passwd.
>>>>>>>> passdb {
>>>>>>>>   driver = pam #server was entered domain
Active Directory
>>>>>>>> }
>>>>>>>> userdb {
>>>>>>>>   driver = passwd
>>>>>>>>   override_fields = home=/var/vmail/glu_vrem/%u
>>>>>>>> }
>>>>>>>>
>>>>>>>> How can i use per-user quota? Only passwd-file?
>>>>>>>>
>>>>>>>> I tried:
>>>>>>>> userdb {
>>>>>>>>   args = /etc/imap.passwd
>>>>>>>>   driver = passwd-file
>>>>>>>>   override_fields = home=/var/vmail/glu_vrem/%u
>>>>>>>> }
>>>>>>>> /etc/imap.passwd:
>>>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>>
>>>>>>>> Authentication and quota - now OK. But
doesn't work sending and receiving
>>>>>>>> mail...
>>>>>>>> postfix say 'Unknown user'...
>>>>>>>>
>>>>>>>>
>>>>>>>> Turn on auth_debug and auth_verbose and see
what it says.
>>>>>>>>
>>>>>>>> Aki
>>>>>> Also you can set auth_username_format = %Ln to force
usernames into
>>>>>> lowercase without domain.
>>>>>>
>>>>>> Aki

Evgeniy Korneechev

2017-Jun-30 07:39 UTC

head link

Per-user quota (passwd)

Our solution:
userdb {
  args = /etc/imap.passwd
  driver = passwd-file
  override_fields = home=/var/vmail/glu_vrem/%u
}
userdb {
  driver = passwd
  override_fields = home=/var/vmail/glu_vrem/%u
}

Users with non-standard quota in passwd-file:>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>> administrator at
email.dom:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
Others from passwd.

Its works! Thanks.


----- ???????? ????????? -----> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
> ????: "dovecot" <dovecot at dovecot.org>
> ????????????: ???????, 29 ???? 2017 ? 14:40:44
> ????: Re: Per-user quota (passwd)
> Oh you have multiple db's, I missed that.
> 
> Remove auth_username_format, and instead
> 
> userdb {
>  args = /etc/imap.passwd username_format=%Ln
>  driver = passwd-file
>  override_fields = home=/var/vmail/glu_vrem/%u
> }
> 
> On 29.06.2017 14:35, Evgeniy Korneechev wrote:
>> with auth_username_format = %Ln:
>>
>> Jun 28 14:43:41 auth: Debug: master in: USER    1    iivanov.ia at
example.com
>> service=lda
>> Jun 28 14:43:41 auth-worker(18369): Debug: passwd(iivanov.ia): lookup
>> Jun 28 14:43:41 auth-worker(18369): Info: passwd(iivanov.ia): unknown
user  -
>> trying the next userdb
>> Jun 28 14:43:41 auth-worker(18369): Debug: sql(iivanov.ia): SELECT
email as
>> user, maildir as home, CONCAT('maildir:', maildir,
'/Maildir') as mail, uid,
>> gid, \
>>      CONCAT('*:storage=', quota, 'B') AS quota_rule,
CONCAT(maildir, '/.sieve') as
>>      sieve FROM mail_user WHERE (login = 'iivanov.ia' OR email
= 'iivanov.ia')
>> Jun 28 14:43:41 auth-worker(18369): Info: sql(iivanov.ia): unknown user
>>
>> Maybe %Lu?
>>
>> ----- ???????? ????????? -----
>>> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
>>> ????: "dovecot" <dovecot at dovecot.org>
>>> ????????????: ???????, 29 ???? 2017 ? 14:10:07
>>> ????: Re: Per-user quota (passwd)
>>> Yes.
>>>
>>> Aki
>>>
>>> On 29.06.2017 14:07, Evgeniy Korneechev wrote:
>>>> And if such a user:
>>>> email (from AD) = ivanov.ia at example.com
>>>> login (from AD), %n = iivanov
>>>> %d = DOM
>>>> %u = iivanov at DOM
>>>>
>>>> ?
>>>>
>>>> ----- ???????? ????????? -----
>>>>> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
>>>>> ????: "dovecot" <dovecot at dovecot.org>
>>>>> ????????????: ???????, 29 ???? 2017 ? 13:59:05
>>>>> ????: Re: Per-user quota (passwd)
>>>>> or use, as I indicated before, auth_username_format = %Ln
>>>>>
>>>>> Aki
>>>>>
>>>>>
>>>>> On 29.06.2017 13:58, Evgeniy Korneechev wrote:
>>>>>> Hi!
>>>>>> workaround:
>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>> administrator at
email.dom:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>>
>>>>>> But this is not a solution for 1000 users ...
>>>>>> Maybe is there extra field
"userdb_mail=administrator at email.dom" for email to
>>>>>> passwd-file?
>>>>>>
>>>>>> ----- ???????? ????????? -----
>>>>>>> ??: "Aki Tuomi" <aki.tuomi at
dovecot.fi>
>>>>>>> ????: "dovecot" <dovecot at
dovecot.org>
>>>>>>> ????????????: ?????, 28 ???? 2017 ? 12:40:48
>>>>>>> ????: Re: Per-user quota (passwd)
>>>>>>> On 28.06.2017 12:36, Aki Tuomi wrote:
>>>>>>>> On 28.06.2017 12:25, Evgeniy Korneechev wrote:
>>>>>>>>> Hello!
>>>>>>>>> We have passwd=pam, userdb=passwd.
>>>>>>>>> passdb {
>>>>>>>>>   driver = pam #server was entered domain
Active Directory
>>>>>>>>> }
>>>>>>>>> userdb {
>>>>>>>>>   driver = passwd
>>>>>>>>>   override_fields =
home=/var/vmail/glu_vrem/%u
>>>>>>>>> }
>>>>>>>>>
>>>>>>>>> How can i use per-user quota? Only
passwd-file?
>>>>>>>>>
>>>>>>>>> I tried:
>>>>>>>>> userdb {
>>>>>>>>>   args = /etc/imap.passwd
>>>>>>>>>   driver = passwd-file
>>>>>>>>>   override_fields =
home=/var/vmail/glu_vrem/%u
>>>>>>>>> }
>>>>>>>>> /etc/imap.passwd:
>>>>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>>>
>>>>>>>>> Authentication and quota - now OK. But
doesn't work sending and receiving
>>>>>>>>> mail...
>>>>>>>>> postfix say 'Unknown user'...
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Turn on auth_debug and auth_verbose and see
what it says.
>>>>>>>>>
>>>>>>>>> Aki
>>>>>>> Also you can set auth_username_format = %Ln to
force usernames into
>>>>>>> lowercase without domain.
>>>>>>>
> >>>>>> Aki
-- 
WBR, Korneechev Evgeniy
BaseALT/ALTLinux Team

Evgeniy Korneechev

2017-Sep-11 11:48 UTC

head link

Per-user quota (passwd)

Hi.
But there is one problem...

protocol lda {
  mail_plugins = " quota autocreate  sieve quota"
  plugin {
    quota = dict:user::file:/var/vmail/glu_vrem/%u/.quotausage
  }
}
protocol imap {
  mail_plugins = " quota autocreate autocreate imap_quota"
  plugin {
    autocreate = INBOX
    autocreate2 = Sent
    autocreate3 = Trash
    autocreate4 = Drafts
    autocreate5 = Junk
    autosubscribe = INBOX
    autosubscribe2 = Sent
    autosubscribe3 = Trash
    autosubscribe4 = Drafts
    autosubscribe5 = Junk
    quota = dict:user::file:/var/vmail/glu_vrem/%u/.quotausage
  }
}
> Users with non-standard quota in passwd-file:
>>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>>> administrator at
email.dom:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
> 
> Others from passwd.


Files ".quotausage" are created in different directories:
/var/vmail/glu_vrem/administrator\DOM/.quotausage
/var/vmail/glu_vrem/administrator at email.dom/.quotausage
And must in the folder "/var/vmail/glu_vrem/administrator"

How fix it?


----- ???????? ????????? -----> ??: "Evgeniy Korneechev" <ekorneechev at altlinux.org>
> ????: "Aki Tuomi" <aki.tuomi at dovecot.fi>
> ?????: "dovecot" <dovecot at dovecot.org>
> ????????????: ???????, 30 ???? 2017 ? 10:39:16
> ????: Re: Per-user quota (passwd)
> Our solution:
> userdb {
>  args = /etc/imap.passwd
>  driver = passwd-file
>  override_fields = home=/var/vmail/glu_vrem/%u
> }
> userdb {
>  driver = passwd
>  override_fields = home=/var/vmail/glu_vrem/%u
> }
> 
> Users with non-standard quota in passwd-file:
>>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>>> administrator at
email.dom:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
> 
> Others from passwd.
> 
> Its works! Thanks.
> 
> 
> ----- ???????? ????????? -----
>> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
>> ????: "dovecot" <dovecot at dovecot.org>
>> ????????????: ???????, 29 ???? 2017 ? 14:40:44
>> ????: Re: Per-user quota (passwd)
> 
>> Oh you have multiple db's, I missed that.
>> 
>> Remove auth_username_format, and instead
>> 
>> userdb {
>>  args = /etc/imap.passwd username_format=%Ln
>>  driver = passwd-file
>>  override_fields = home=/var/vmail/glu_vrem/%u
>> }
>> 
>> On 29.06.2017 14:35, Evgeniy Korneechev wrote:
>>> with auth_username_format = %Ln:
>>>
>>> Jun 28 14:43:41 auth: Debug: master in: USER    1    iivanov.ia at
example.com
>>> service=lda
>>> Jun 28 14:43:41 auth-worker(18369): Debug: passwd(iivanov.ia):
lookup
>>> Jun 28 14:43:41 auth-worker(18369): Info: passwd(iivanov.ia):
unknown user  -
>>> trying the next userdb
>>> Jun 28 14:43:41 auth-worker(18369): Debug: sql(iivanov.ia): SELECT
email as
>>> user, maildir as home, CONCAT('maildir:', maildir,
'/Maildir') as mail, uid,
>>> gid, \
>>>      CONCAT('*:storage=', quota, 'B') AS
quota_rule, CONCAT(maildir, '/.sieve') as
>>>      sieve FROM mail_user WHERE (login = 'iivanov.ia' OR
email = 'iivanov.ia')
>>> Jun 28 14:43:41 auth-worker(18369): Info: sql(iivanov.ia): unknown
user
>>>
>>> Maybe %Lu?
>>>
>>> ----- ???????? ????????? -----
>>>> ??: "Aki Tuomi" <aki.tuomi at dovecot.fi>
>>>> ????: "dovecot" <dovecot at dovecot.org>
>>>> ????????????: ???????, 29 ???? 2017 ? 14:10:07
>>>> ????: Re: Per-user quota (passwd)
>>>> Yes.
>>>>
>>>> Aki
>>>>
>>>> On 29.06.2017 14:07, Evgeniy Korneechev wrote:
>>>>> And if such a user:
>>>>> email (from AD) = ivanov.ia at example.com
>>>>> login (from AD), %n = iivanov
>>>>> %d = DOM
>>>>> %u = iivanov at DOM
>>>>>
>>>>> ?
>>>>>
>>>>> ----- ???????? ????????? -----
>>>>>> ??: "Aki Tuomi" <aki.tuomi at
dovecot.fi>
>>>>>> ????: "dovecot" <dovecot at
dovecot.org>
>>>>>> ????????????: ???????, 29 ???? 2017 ? 13:59:05
>>>>>> ????: Re: Per-user quota (passwd)
>>>>>> or use, as I indicated before, auth_username_format =
%Ln
>>>>>>
>>>>>> Aki
>>>>>>
>>>>>>
>>>>>> On 29.06.2017 13:58, Evgeniy Korneechev wrote:
>>>>>>> Hi!
>>>>>>> workaround:
>>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>>> administrator at
email.dom:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>
userdb_mail=maildir:/var/vmail/glu_vrem/administrator/Maildir
>>>>>>>
>>>>>>> But this is not a solution for 1000 users ...
>>>>>>> Maybe is there extra field
"userdb_mail=administrator at email.dom" for email to
>>>>>>> passwd-file?
>>>>>>>
>>>>>>> ----- ???????? ????????? -----
>>>>>>>> ??: "Aki Tuomi" <aki.tuomi at
dovecot.fi>
>>>>>>>> ????: "dovecot" <dovecot at
dovecot.org>
>>>>>>>> ????????????: ?????, 28 ???? 2017 ? 12:40:48
>>>>>>>> ????: Re: Per-user quota (passwd)
>>>>>>>> On 28.06.2017 12:36, Aki Tuomi wrote:
>>>>>>>>> On 28.06.2017 12:25, Evgeniy Korneechev
wrote:
>>>>>>>>>> Hello!
>>>>>>>>>> We have passwd=pam, userdb=passwd.
>>>>>>>>>> passdb {
>>>>>>>>>>   driver = pam #server was entered
domain Active Directory
>>>>>>>>>> }
>>>>>>>>>> userdb {
>>>>>>>>>>   driver = passwd
>>>>>>>>>>   override_fields =
home=/var/vmail/glu_vrem/%u
>>>>>>>>>> }
>>>>>>>>>>
>>>>>>>>>> How can i use per-user quota? Only
passwd-file?
>>>>>>>>>>
>>>>>>>>>> I tried:
>>>>>>>>>> userdb {
>>>>>>>>>>   args = /etc/imap.passwd
>>>>>>>>>>   driver = passwd-file
>>>>>>>>>>   override_fields =
home=/var/vmail/glu_vrem/%u
>>>>>>>>>> }
>>>>>>>>>> /etc/imap.passwd:
>>>>>>>>>>
administrator:*:95400500:95400513:Administrator:/home/DOM/administrator:/bin/bash::userdb_quota_rule=*:bytes=10G
>>>>>>>>>>
>>>>>>>>>> Authentication and quota - now OK. But
doesn't work sending and receiving
>>>>>>>>>> mail...
>>>>>>>>>> postfix say 'Unknown user'...
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Turn on auth_debug and auth_verbose and
see what it says.
>>>>>>>>>>
>>>>>>>>>> Aki
>>>>>>>> Also you can set auth_username_format = %Ln to
force usernames into
>>>>>>>> lowercase without domain.
>>>>>>>>
>> >>>>>> Aki
> 
> --
> WBR, Korneechev Evgeniy
> BaseALT/ALTLinux Team
-- 
WBR, Korneechev Evgeniy
BaseALT/ALTLinux Team

Maybe Matching Threads

Search for more possibly parallel threads

dovecot - Sep 2017 - Per-user quota (passwd)

Per-user quota (passwd)

Per-user quota (passwd)

Per-user quota (passwd)

Maybe Matching Threads