URL: https://www.opennet.ru/cgi-bin/openforum/vsluhboard.cgi
Форум: vsluhforumID13
Нить номер: 967
[ Назад ]

Исходное сообщение
"postfixadmin+dovecot"

Отправлено Alessandro1991 , 15-Фев-18 23:59 
здравствуйте!
помогите плиз.
по этой ссылки делал настройку квот, пока без оповещения.
https://kamaok.org.ua/?p=2189
по итогу -
doveadm quota get -u test2@test.ru
Quota name Type    Value Limit                                                                     %
User quota STORAGE 13482     -                                                                     0
User quota MESSAGE    13     -                                                                     0
лимиты не работают.
может там что не правильно?
это норм?

user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 5000 AS uid, 8 AS gid, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE u$
password_query = SELECT username as user, password, '/var/vmail/%d/%n' as userdb_home,'maildir:/var/vmail/%d/%n' as userdb_mail, 5000 as userdb_uid, 8 as userdb_gid FR$


Содержание

Сообщения в этом обсуждении
"postfixadmin+dovecot"
Отправлено Alessandro1991 , 18-Фев-18 18:12 
auth: Warning: sql: Ignoring changed user_query in /etc/dovecot/dovecot-sql.conf, because userdb sql not used
такая ошибка

такие настройки
password_query = SELECT username as user, password FROM mailbox WHERE username = '%u'
user_query = SELECT '/var/vmail/%d/%n' AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1'


"postfixadmin+dovecot"
Отправлено Alessandro1991 , 18-Фев-18 19:00 
> auth: Warning: sql: Ignoring changed user_query in /etc/dovecot/dovecot-sql.conf, because
> userdb sql not used
> такая ошибка
> такие настройки
> password_query = SELECT username as user, password FROM mailbox WHERE username =
> '%u'
> user_query = SELECT '/var/vmail/%d/%n' AS home, 5000 AS uid, 5000 AS gid,
> CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE username =
> '%u' AND active = '1'

решил.
userdb {
#  driver = static
#  args = uid=vmail gid=vmail home=/var/vmail/%d/%n
driver = sql
args = /etc/dovecot/dovecot-sql.conf
       }
то что закомментил, сменил на это.