Per-user quota (passwd)

[Aki Tuomi]

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