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
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
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