Postfix+Dovecot не работает квота

Обсуждение настройки и работы сервисов, резервирования, сетевых настроек и вопросов безопасности ОС.

Модераторы: SLEDopit, Модераторы разделов

Аватара пользователя
VIRUS_T
Сообщения: 84

Postfix+Dovecot не работает квота

Сообщение VIRUS_T »

Настроена связка postfix+dovecot+mysql+postfixaddmin, всеработает отлично, пытаюсь прикрутить квоты/чтобы довекот брал и бд мускул/ вроде как выборку делает, а письма всеравно проходят вот конфиги

Код: Выделить всё

dovecot -n
# 1.2.14: /usr/local/etc/dovecot.conf
# OS: FreeBSD 8.0-RELEASE i386  ufs
base_dir: /var/run/dovecot/
log_path: /var/log/dovecot.log
info_log_path: /var/log/dovecot.log
protocols: imap pop3 imaps pop3s
ssl: no
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable(default): /usr/local/libexec/dovecot/imap-login
login_executable(imap): /usr/local/libexec/dovecot/imap-login
login_executable(pop3): /usr/local/libexec/dovecot/pop3-login
verbose_proctitle: yes
first_valid_uid: 1981
last_valid_uid: 1981
first_valid_gid: 1981
last_valid_gid: 1981
mail_privileged_group: mail
mail_location: maildir:/var/spool/mail1/%d/%u
mail_debug: yes
mail_executable(default): /usr/local/libexec/dovecot/imap
mail_executable(imap): /usr/local/libexec/dovecot/imap
mail_executable(pop3): /usr/local/libexec/dovecot/pop3
mail_plugins(default): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(pop3):
mail_plugin_dir(default): /usr/local/lib/dovecot/imap
mail_plugin_dir(imap): /usr/local/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3
imap_client_workarounds(default): delay-newmail netscape-eoh tb-extra-mailbox-sep
imap_client_workarounds(imap): delay-newmail netscape-eoh tb-extra-mailbox-sep
imap_client_workarounds(pop3):
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
lda:
  postmaster_address: adm@telemat13.net
  hostname: mail.telemat13.net
  mail_plugins: quota sieve
  mail_plugin_dir: /usr/local/lib/dovecot/lda
  sendmail_path: /usr/sbin/sendmail
auth default:
  mechanisms: plain login cram-md5
  user: virtual
  username_format: %Lu
  debug: yes
  debug_passwords: yes
  passdb:
    driver: pam
    args: session=yes dovecot
  passdb:
    driver: sql
    args: /usr/local/etc/dovecot-mysql.conf
  userdb:
    driver: passwd
    args: blocking=yes
  userdb:
    driver: sql
    args: /usr/local/etc/dovecot-mysql.conf
  socket:
    type: listen
    client:
      path: /var/spool/postfix/private/dovecot-smtp-auth
      mode: 432
      user: postfix
      group: postfix
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: virtual
      group: virtual
plugin:
  quota: maildir


Код: Выделить всё

cat /usr/local/etc/dovecot-mysql.conf
driver = mysql
connect = host=localhost port=3306 dbname=postfix user=postfix password=postfix
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT maildir, 1981 AS uid, 1981 AS gid, concat('maildir:storage=', quota, 'M') as quota_rule FROM mailbox WHERE username = '%u'


Код: Выделить всё

postconf -n
alias_database = hash:/etc/mail/aliases
alias_maps = hash:/etc/mail/aliases
command_directory = /usr/local/sbin
config_directory = /usr/local/etc/postfix
content_filter = smtp-amavis:[127.0.0.1]:10024
daemon_directory = /usr/local/libexec/postfix
data_directory = /var/db/postfix
debug_peer_level = 2
home_mailbox = Maildir/
html_directory = /usr/local/share/doc/postfix
mail_owner = postfix
mailq_path = /usr/local/bin/mailq
manpage_directory = /usr/local/man
mydestination = $myhostname, localhost.$mydomain, localhost
mydomain = telemat13.net
myhostname = mail.telemat13.net
mynetworks = 127.0.0.0/8
mynetworks_style = host
myorigin = $mydomain
newaliases_path = /usr/local/bin/newaliases
queue_directory = /var/spool/postfix
readme_directory = /usr/local/share/doc/postfix
relay_domains = $mydestination
relayhost = $mydomain
sample_directory = /usr/local/etc/postfix
sendmail_path = /usr/local/sbin/sendmail
setgid_group = maildrop
smtpd_sasl_path = private/dovecot-smtp-auth
smtpd_sasl_type = dovecot
unknown_local_recipient_reject_code = 550
virtual_alias_maps = mysql:/usr/local/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:1981
virtual_mailbox_base = /var/spool/mail1
virtual_mailbox_domains = mysql:/usr/local/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/usr/local/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 1000
virtual_transport = dovecot
virtual_uid_maps = static:1981


выхлоп довекота при отправке видно что выборк делалается, а почему то пропускает с превышенной квотой, подскажите пожалуйста в чем может быть проблема

Код: Выделить всё

  quota_rule=maildir:storage=2048000M
на ящик базе стоит квота 2 мегбайта

Код: Выделить всё

Feb 17 07:38:53 auth(default): Info: client in: AUTH    1       PLAIN   service=imap    lip=192.168.1.118       rip=192.168.1.34        lport=143       rport=49454   resp=AHRlc3QyQHRlbGVtYXQxMy5uZXQAdGVzdDI=
Feb 17 07:38:53 auth-worker(default): Info: pam(test2@telemat13.net,192.168.1.34): lookup service=dovecot
Feb 17 07:38:54 auth(default): Info: new auth connection: pid=1335
Feb 17 07:38:54 auth-worker(default): Info: pam(test2@telemat13.net,192.168.1.34): #1/1 style=1 msg=Password:
Feb 17 07:38:54 auth-worker(default): Info: pam(test2@telemat13.net,192.168.1.34): pam_authenticate() failed: authentication error (password mismatch?) (given password: test2)
Feb 17 07:38:54 auth-worker(default): Info: sql(test2@telemat13.net,192.168.1.34): query: SELECT password FROM mailbox WHERE username = 'test2@telemat13.net'
Feb 17 07:38:54 auth(default): Info: client out: OK     1       user=test2@telemat13.net
Feb 17 07:38:54 auth(default): Info: master in: REQUEST 5       1307    1
Feb 17 07:38:54 auth-worker(default): Info: passwd(test2@telemat13.net,192.168.1.34): lookup
Feb 17 07:38:54 auth-worker(default): Info: passwd(test2@telemat13.net,192.168.1.34): unknown user
Feb 17 07:38:54 auth-worker(default): Info: sql(test2@telemat13.net,192.168.1.34): SELECT maildir, 1981 AS uid, 1981 AS gid, concat('maildir:storage=', quota, 'M') as quota_rule FROM mailbox WHERE username = 'test2@telemat13.net'
Feb 17 07:38:54 auth(default): Info: master out: USER   5       test2@telemat13.net     maildir=test2@telemat13.net/    uid=1981        gid=1981        quota_rule=maildir:storage=2048000M
Feb 17 07:38:54 imap-login: Info: Login: user=<test2@telemat13.net>, method=PLAIN, rip=192.168.1.34, lip=192.168.1.118
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: Loading modules from directory: /usr/local/lib/dovecot/imap
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/imap/lib10_quota_plugin.so
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: Effective uid=1981, gid=1981, home=(none)
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: Quota root: name= backend=maildir args=
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: Quota rule: root= mailbox=maildir bytes=2147483648000 messages=0
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: maildir: data=/var/spool/mail1/telemat13.net/test2@telemat13.net
Feb 17 07:38:54 IMAP(test2@telemat13.net): Info: maildir++: root=/var/spool/mail1/telemat13.net/test2@telemat13.net, index=, control=, inbox=/var/spool/mail1/telemat13.net/test2@telemat13.net
Feb 17 07:38:56 IMAP(test2@telemat13.net): Info: Disconnected: Logged out bytes=4325698/469
Feb 17 07:40:10 deliver(test2@telemat13.net): Info: Loading modules from directory: /usr/local/lib/dovecot/lda
Feb 17 07:40:10 deliver(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/lda/lib10_quota_plugin.so
Feb 17 07:40:10 deliver(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/lda/lib90_sieve_plugin.so
Feb 17 07:40:10 auth(default): Info: master in: USER    1       test2@telemat13.net     service=deliver
Feb 17 07:40:10 auth-worker(default): Info: passwd(test2@telemat13.net): lookup
Feb 17 07:40:10 auth-worker(default): Info: passwd(test2@telemat13.net): unknown user
Feb 17 07:40:10 auth-worker(default): Info: sql(test2@telemat13.net): SELECT maildir, 1981 AS uid, 1981 AS gid, concat('maildir:storage=', quota, 'M') as quota_rule FROM mailbox WHERE username = 'test2@telemat13.net'
Feb 17 07:40:11 auth(default): Info: master out: USER   1       test2@telemat13.net     maildir=test2@telemat13.net/    uid=1981        gid=1981        quota_rule=maildir:storage=2048000M
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: auth input: maildir=test2@telemat13.net/
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: auth input: uid=1981
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: auth input: gid=1981
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: auth input: quota_rule=maildir:storage=2048000M
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: Quota root: name= backend=maildir args=
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: Quota rule: root= mailbox=maildir bytes=2147483648000 messages=0
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: maildir: data=/var/spool/mail1/telemat13.net/test2@telemat13.net
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: maildir++: root=/var/spool/mail1/telemat13.net/test2@telemat13.net, index=, control=, inbox=/var/spool/mail1/telemat13.net/test2@telemat13.net
Feb 17 07:40:11 deliver(test2@telemat13.net): Error: sieve: path to user's main active personal script is unknown. See http://wiki.dovecot.org/LDA/Sieve/Dovecot#configuration
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: sieve: user has no valid personal script
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: sieve: no scripts to execute: reverting to default delivery.
Feb 17 07:40:11 deliver(test2@telemat13.net): Info: Namespace : Using permissions from /var/spool/mail1/telemat13.net/test2@telemat13.net: mode=0700 gid=-1
Feb 17 07:40:14 deliver(test2@telemat13.net): Info: msgid=<56646BD426CD4B299EC92BB5FB1EAD4E@1>: saved mail to INBOX

заране спасибо
МУСИ ПУСИ OPENSUSE
Спасибо сказали:
Аватара пользователя
sash-kan
Администратор
Сообщения: 13939
Статус: oel ngati kameie
ОС: GNU

Re: Postfix+Dovecot не работает квота

Сообщение sash-kan »

VIRUS_T писал(а):
17.02.2011 19:10
на ящик базе стоит квота 2 мегбайта
возможно, я ошибаюсь, но тут:
VIRUS_T писал(а):
17.02.2011 19:10
quota_rule=maildir:storage=2048000M
написано два терабайта.
Писать безграмотно - значит посягать на время людей, к которым мы адресуемся, а потому совершенно недопустимо в правильно организованном обществе. © Щерба Л. В., 1957
при сбоях форума см.блог
Спасибо сказали:
Аватара пользователя
VIRUS_T
Сообщения: 84

Re: Postfix+Dovecot не работает квота

Сообщение VIRUS_T »

я там уже и 20 ставил, всеравно пропускает :crazy:
МУСИ ПУСИ OPENSUSE
Спасибо сказали:
Аватара пользователя
sash-kan
Администратор
Сообщения: 13939
Статус: oel ngati kameie
ОС: GNU

Re: Postfix+Dovecot не работает квота

Сообщение sash-kan »

VIRUS_T
2048000M — это два терабайта.
если вы хотите два мегабайта, то так и напишите:
Писать безграмотно - значит посягать на время людей, к которым мы адресуемся, а потому совершенно недопустимо в правильно организованном обществе. © Щерба Л. В., 1957
при сбоях форума см.блог
Спасибо сказали:
Аватара пользователя
VIRUS_T
Сообщения: 84

Re: Postfix+Dovecot не работает квота

Сообщение VIRUS_T »

а так? и 2м и пропускает всеравно или я что то не допонимаю?

Код: Выделить всё

Mar 25 20:07:52 imap-login: Info: Login: user=<test2@telemat13.net>, method=PLAIN, rip=192.168.1.34, lip=192.168.1.118
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Loading modules from directory: /usr/local/lib/dovecot/imap
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/imap/lib10_quota_plugin.so
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Effective uid=1981, gid=1981, home=(none)
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Quota root: name= backend=maildir args=
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Quota rule: root= mailbox=maildir bytes=2097152 messages=0
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: maildir: data=/var/spool/mail1/telemat13.net/test2@telemat13.net
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: maildir++: root=/var/spool/mail1/telemat13.net/test2@telemat13.net, index=, control=, inbox=/var/spool/mail1/telemat13.net/test2@telemat13.net
Mar 25 20:07:52 IMAP(test2@telemat13.net): Info: Disconnected: Logged out bytes=2357/468
Mar 25 20:07:53 auth(default): Info: new auth connection: pid=2185
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: Loading modules from directory: /usr/local/lib/dovecot/lda
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/lda/lib10_quota_plugin.so
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: Module loaded: /usr/local/lib/dovecot/lda/lib90_sieve_plugin.so
Mar 25 20:08:35 auth(default): Info: master in: USER    1       test2@telemat13.net     service=deliver
Mar 25 20:08:35 auth-worker(default): Info: passwd(test2@telemat13.net): lookup
Mar 25 20:08:35 auth-worker(default): Info: passwd(test2@telemat13.net): unknown user
Mar 25 20:08:35 auth-worker(default): Info: sql(test2@telemat13.net): SELECT maildir, 1981 AS uid, 1981 AS gid, concat('maildir:storage=', quota, 'M') as quota_rule FROM mailbox WHERE username = 'test2@telemat13.net'
Mar 25 20:08:35 auth(default): Info: master out: USER   1       test2@telemat13.net     maildir=test2@telemat13.net/    uid=1981        gid=1981        quota_rule=maildir:storage=2M
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: auth input: maildir=test2@telemat13.net/
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: auth input: uid=1981
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: auth input: gid=1981
Mar 25 20:08:35 deliver(test2@telemat13.net): Info: auth input: quota_rule=maildir:storage=2M
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: Quota root: name= backend=maildir args=
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: Quota rule: root= mailbox=maildir bytes=2097152 messages=0
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: maildir: data=/var/spool/mail1/telemat13.net/test2@telemat13.net
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: maildir++: root=/var/spool/mail1/telemat13.net/test2@telemat13.net, index=, control=, inbox=/var/spool/mail1/telemat13.net/test2@telemat13.net
Mar 25 20:08:36 deliver(test2@telemat13.net): Error: sieve: path to user's main active personal script is unknown. See http://wiki.dovecot.org/LDA/Sieve/Dovecot#configuration
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: sieve: user has no valid personal script
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: sieve: no scripts to execute: reverting to default delivery.
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: Namespace : Using permissions from /var/spool/mail1/telemat13.net/test2@telemat13.net: mode=0700 gid=-1
Mar 25 20:08:36 deliver(test2@telemat13.net): Info: msgid=<0C54A5402EE44E8E8E5914AA7230F76C@1>: saved mail to INBOX

Код: Выделить всё

Mar 25 20:08:35 deliver(test2@telemat13.net): Info: auth input: quota_rule=maildir:storage=2M
МУСИ ПУСИ OPENSUSE
Спасибо сказали: