Boa tarde...
Alguém pra ajudar ai?
( Imagem em anexo )
Obrigado.
Lucas
2011/5/2 drum.lu...@gmail.com <drum.lu...@gmail.com>
> Boa tarde Lista!
> Alguma idéia do que posso fazer a mais?
> Ainda estou com o problema..
>
> Obrigado.
>
> 2011/4/29 drum.lu...@gmail.com <drum.lu...@gmail.com>
>
> Bom dia Julio...
>> Fiz algumas alterações.
>> P.s: Meus e-mails ficam em: /var/vmail/dominio/usuario/ ( cur, new, tmp )
>>
>> ##############################################
>>
>> No meu config.inc.php do postfixadmin está assim:
>> $CONF['quota'] = "YES";
>> $CONF['quota_multiplier'] = 1024000;
>>
>> ##############################################
>>
>> O meu dovecot.conf está assim:
>>
>> base_dir = /var/run/dovecot/
>> protocols = imap pop3
>> listen = *
>> shutdown_clients = yes
>> login_greeting = Bem-Vindo ao servidor Dovecot
>>
>> # LOGs #
>> log_path = /var/log/dovecot.log
>> info_log_path = /var/log/dovecot-deliver.log
>> log_timestamp = “%Y-%m-%d %H:%M:%S ”
>> syslog_facility = mail
>> login_log_format_elements = user=<%u> method=%m rip=%r lip=%l %c
>> login_log_format = %$: %s
>>
>> ## SSL settings
>> ssl_listen = localhost
>> ssl_cert_file = /etc/postfix/mail-cert.pem
>> ssl_key_file = /etc/postfix/mail-key.pem
>> ssl_parameters_regenerate = 168
>> verbose_ssl = no
>>
>> mail_location = maildir:/var/vmail/%d/%u/
>> mail_access_groups = mail
>> mail_debug = no
>> first_valid_uid = 150
>> last_valid_uid = 150
>> maildir_copy_with_hardlinks = yes
>>
>> protocol imap {
>> mail_plugins = quota imap_quota zlib
>> imap_client_workarounds = outlook-idle
>> }
>>
>> protocol pop3 {
>> login_executable = /usr/libexec/dovecot/pop3-login
>> mail_executable = /usr/libexec/dovecot/pop3
>> mail_plugins = quota zlib
>> pop3_no_flag_updates = yes
>> pop3_reuse_xuidl = no
>> pop3_lock_session = no
>> pop3_uidl_format = %08Xu%08Xv
>> pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
>> }
>>
>> protocol lda {
>> postmaster_address = postmas...@exemplo.com.br
>> mail_plugin_dir = /usr/lib/dovecot/lda
>> mail_plugins = quota
>> auth_socket_path = /var/run/dovecot/auth-master
>> sieve_global_path = /var/vmail/sieve/dovecot.sieve
>> syslog_facility = mail
>> quota_full_tempfail = yes
>> }
>>
>> auth_verbose = no
>> auth_debug = no
>> auth default {
>> mechanisms = plain
>> passdb pam {
>> }
>> passdb sql {
>> args = /etc/dovecot-sql.conf
>> }
>>
>> userdb passwd {
>> }
>>
>> userdb sql {
>> args = /etc/dovecot-sql.conf
>> }
>> user = nobody
>> socket listen {
>> master {
>> path = /var/run/dovecot/auth-master
>> mode = 0600
>> user = vmail
>> group = mail
>> }
>> client {
>> path = /var/run/dovecot/auth-client
>> mode = 0660
>> user = vmail
>> group = mail
>> }
>> }
>> }
>>
>> dict {
>> quotadict = mysql:/etc/dovecot-dict-quota.conf
>> }
>>
>> plugin {
>> quota = maildir:User quota
>> quota_rule = *:storage=1000M
>> quota_rule2 = Trash:storage=100M
>> quota_warning = storage=80%% /var/vmail/bin/quota-warning.sh 80
>> quota_warning2 = storage=90%% /var/vmail/bin/quota-warning.sh 90
>> quota_warning3 = storage=100%% /var/vmail/bin/quota-warning.sh 100
>> sieve = /var/vmail/%d/%u/.dovecot.sieve
>> }
>>
>> ##############################################
>>
>> Meu dovecot-sql.conf está assim:
>>
>> driver = mysql
>> connect = host=localhost dbname=mail user=mail password=mail
>> default_pass_scheme = MD5
>> user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'
>> as mail, 150 AS uid, 12 AS gid, CONCAT('dirsize:storage=', ROUND(
>> mailbox.quota / 1024 ) ) AS quota FROM mailbox WHERE username = '%u' AND
>> active = '1'
>> 'maildir:/var/vmail/%d/%n' as userdb_mail, 150 as userdb_uid, 12 as
>> userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
>> password_query = SELECT password FROM mailbox WHERE username = '%u' AND
>> active = '1'
>>
>> #########################################
>> ## Tentei por suas informações no dovecot.conf, porém apresentou os erros
>> à baixo.
>> deliver(di...@exemplo.com.br): 2011-04-29 07:54:49 Fatal: Plugin cmusieve
>> not found from directory /usr/lib/dovecot/lda
>>
>>
>> ## Tentei por suas informações no dovecot-sql.conf, porém apresentou os
>> erros à baixo.
>>
>> dovecot: 2011-04-29 07:53:52 Error: auth-worker(default): sql(
>> lu...@exemplo.com.br,127.0.0.1): User query failed: You have an error in
>> your SQL syntax; check the manual that corresponds to your MySQL server
>> version for the right syntax to use near ') CONCAT('*:bytes=', quota) AS
>> quota_rule FROM mailbox WHERE username='lucas@exe' at line 1
>>
>> Alguma idéia do que fazer?
>>
>> Obrigado.
>>
>> Em 28 de abril de 2011 19:49, Julio Cesar Covolato
>> <ju...@psi.com.br>escreveu:
>>
>> Olá Drum.
>>>
>>> segue as partes relevantes das conf de postfixadmin e dovecot.
>>> Edite-os de acordo com seu sistema.
>>>
>>> No postfixadmin, config.inc.php (ou config.local.php):
>>>
>>> ...
>>> ...
>>> $CONF['quota'] = "YES";
>>> $CONF['quota_multiplier'] = 1024000;
>>> ...
>>> ...
>>>
>>> No Dovecot, dovecot.conf.
>>> ...
>>> ...
>>> ...
>>> plugin {
>>> # Quota warning.
>>> #
>>> # You can find sample script from Dovecot wiki:
>>> #
>>> http://wiki.dovecot.org/Quota/1.1#head-03d8c4f6fb28e2e2f1cb63ec623810b45bec1734
>>> #
>>> # If user suddenly receives a huge mail and the quota jumps from
>>> # 85% to 95%, only the 95% script is executed.
>>> #
>>> quota_warning = storage=85%% /usr/local/bin/dovecot-quota-warning.sh
>>> 85
>>> quota_warning2 = storage=90%% /usr/local/bin/dovecot-quota-warning.sh
>>> 90
>>> quota_warning3 = storage=95%% /usr/local/bin/dovecot-quota-warning.sh
>>> 95
>>> }
>>>
>>> plugin {
>>> quota = maildir:User quota
>>>
>>> # Quota rules. Reference: http://wiki.dovecot.org/Quota/1.1
>>> # The following limit names are supported:
>>> # - storage: Quota limit in kilobytes, 0 means unlimited.
>>> # - bytes: Quota limit in bytes, 0 means unlimited.
>>> # - messages: Quota limit in number of messages, 0 means unlimited.
>>> This probably isn't very useful.
>>> # - backend: Quota backend-specific limit configuration.
>>> # - ignore: Don't include the specified mailbox in quota at all
>>> (v1.1.rc5+).
>>> quota_rule = *:storage=100M
>>> #quota_rule2 = *:messages=0
>>> #quota_rule3 = Trash:storage=1G
>>> #quota_rule4 = Junk:ignore
>>> }
>>>
>>> # LDA: Local Deliver Agent
>>> protocol lda {
>>> postmaster_address = root
>>> auth_socket_path = /var/run/dovecot/auth-master
>>> #mail_plugins = cmusieve quota expire
>>> mail_plugins = cmusieve quota
>>> sieve_global_path = /var/spool/vmail/sieve/dovecot.sieve
>>> #log_path = /var/log/sieve.log
>>> syslog_facility = mail
>>> quota_full_tempfail = yes
>>> }
>>>
>>> # IMAP configuration
>>> protocol imap {
>>> #mail_plugins = quota imap_quota zlib expire
>>> mail_plugins = quota imap_quota zlib
>>>
>>> # number of connections per-user per-IP
>>> #mail_max_userip_connections = 10
>>> }
>>>
>>> # POP3 configuration
>>> protocol pop3 {
>>> #mail_plugins = quota zlib expire
>>> mail_plugins = quota zlib
>>> pop3_uidl_format = %08Xu%08Xv
>>> pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
>>> }
>>> ...
>>> ...
>>> ...
>>>
>>> dovecot-mysql.conf:
>>>
>>> driver = mysql
>>> default_pass_scheme = CRYPT
>>> connect = host=localhost dbname=xxxxxx user=xxxxx password=xxxxxxxxxx
>>> password_query = SELECT password FROM mailbox WHERE username='%u' AND
>>> active='1' AND expired >= NOW()
>>> user_query = SELECT CONCAT(storagebasedirectory, '/', maildir) AS home,
>>> CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username='%u' AND
>>> active='1' AND enable%Ls%Lc='1' AND expired >= NOW()
>>>
>>> -----------------------------
>>> _ Julio Cesar Covolato
>>> 0v0<ju...@psi.com.br>
>>> /(_)\ F: 55-11-3129-3366
>>> ^ ^ PSI INTERNET
>>> -----------------------------
>>>
>>>
>>> Em 28/04/2011 16:24, drum.lu...@gmail.com escreveu:
>>>
>>>> Alguém na lista que possa ajudar?
>>>>
>>>>
>>>> Obrigado!
>>>>
>>>> Lucas
>>>>
>>>> Em 13 de abril de 2011 09:47, drum.lu...@gmail.com
>>>> <drum.lu...@gmail.com>escreveu:
>>>>
>>>> Bom dia !
>>>>> Bom. Vou explicar minha situação. Peço desculpas se não for relacionado
>>>>> ao
>>>>> postfix.
>>>>>
>>>>> Hoje, possuo em funcionamento alguns servidores com:
>>>>> * Postfix
>>>>> * Postfixadmin
>>>>> * MYSQL
>>>>> * SpamAssassin
>>>>> * Clamav
>>>>> * Amavisd-new
>>>>> * Dovecot ( para POP3 e IMAP )
>>>>> * ROUNDCUBEMAIL ( para webmail )
>>>>>
>>>>> Bem. Quando eu logo com algum usuário no webmail, o webmail mostra a
>>>>> porcentagem de quota utilizado. Tudo certo.
>>>>>
>>>>> Porém, no painel do POSTFIXADMIN eu tenho:
>>>>>
>>>>> Cota de Espaço (MB): 0/1000
>>>>>
>>>>> Ou seja, o usuário X está ocupando 0 MB de 1000 que ele tem liberado.
>>>>> Porém, ao logar no webmail estes 0 passam a ser 10 MB.
>>>>>
>>>>> O postfixadmin não está "mostrando" corretamente a porcentagem de quota
>>>>> utilizada das mailboxes.
>>>>>
>>>>> Eu realmente não sei aonde procurar este problema.
>>>>> Não sei de quem é a "culpa" disto estar errado.
>>>>> Alguém poderia ao menos me indicar o caminho?
>>>>>
>>>>> Muito obrigado!
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Atenciosamente;
>>>>>
>>>>> Graciously;
>>>>>
>>>>> *Lucas Possamai
>>>>> *
>>>>>
>>>>> http://psyscrew.posterous.com/
>>>>>
>>>>> "Na palma da tua mão existem sonhos, felicidades e a força que te guia
>>>>> por
>>>>> um caminho, que somente você poderá trilhar, com o olhar tranquilo
>>>>> saberás
>>>>> onde chegar.o fim é apenas mais um ponto para inventar uma nova
>>>>> conquista."
>>>>> **
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>> Postfix-BR mailing list
>>> Postfix-BR@listas.softwarelivre.org
>>> http://listas.softwarelivre.org/mailman/listinfo/postfix-br
>>>
>>
>>
>>
>> --
>>
>> Atenciosamente;
>>
>> Graciously;
>>
>> *Lucas Possamai
>> *
>>
>> http://psyscrew.posterous.com/
>>
>> "Na palma da tua mão existem sonhos, felicidades e a força que te guia por
>> um caminho, que somente você poderá trilhar, com o olhar tranquilo saberás
>> onde chegar.o fim é apenas mais um ponto para inventar uma nova conquista."
>> **
>>
>
>
>
> --
>
> Atenciosamente;
>
> Graciously;
>
> *Lucas Possamai
> *
>
> http://psyscrew.posterous.com/
>
> "Na palma da tua mão existem sonhos, felicidades e a força que te guia por
> um caminho, que somente você poderá trilhar, com o olhar tranquilo saberás
> onde chegar.o fim é apenas mais um ponto para inventar uma nova conquista."
> **
>
--
Atenciosamente;
Graciously;
*Lucas Possamai
*
http://psyscrew.posterous.com/
"Na palma da tua mão existem sonhos, felicidades e a força que te guia por
um caminho, que somente você poderá trilhar, com o olhar tranquilo saberás
onde chegar.o fim é apenas mais um ponto para inventar uma nova conquista."*
*
_______________________________________________
Postfix-BR mailing list
Postfix-BR@listas.softwarelivre.org
http://listas.softwarelivre.org/mailman/listinfo/postfix-br
