[FUG-BR] Servidor de Email erro na hora de autenticar

[Daniel]

Em 4/15/2011 4:53 PM, Renato Botelho escreveu:
> 2011/4/15 Daniel<daniel2099 em r7.com>:
>> Em 4/14/2011 9:39 PM, irado furioso com tudo escreveu:
>>> Em Thu, 14 Apr 2011 19:01:34 -0300
>>> Daniel<daniel2099 em r7.com>, conhecido consumidor/usuário de drogas
>>> (Windows e BigMac com Coke) escreveu:
>>>
>>>> Apr 14 18:57:53 catedral3 dovecot: auth-worker(default): mysql:
>>>> Connect failed to localhost (postfix): Access denied for user
>>>> 'postfix'@'localhost' (using password: YES) - waitin
>>>> g for 1 seconds before retry
>>> seu usuário (na configuração do dovecot) não tem autorização para
>>> acessar o mysql, vc esqueceu UMA das etapas da instalação/configuração.
>>> Nada demais, já fiz isso - rs.
>>>
>> O erro ainda persiste ,mexi no banco no dovecot!
>> Apr 15 15:41:56 catedral3 newsyslog[506]: logfile first created
>> Apr 15 15:42:08 catedral3 dovecot: Dovecot v1.2.16 starting up
>> Apr 15 15:42:09 catedral3 dovecot: auth-worker(default): mysql: Connect
>> failed to localhost (postfix): Access denied for user
>> 'postfix'@'localhost' (using password: YES) - waiting for 1 seconds
>> before retry
>> Apr 15 15:42:09 catedral3 postfix/postfix-script[1261]: starting the
>> Postfix mail system
>> Apr 15 15:42:09 catedral3 postfix/master[1262]: daemon started --
>> version 2.7.2, configuration /usr/local/etc/postfix
>>
>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> protocols = *imap imaps pop3 pop3s*
>> ssl_cert_file = */etc/ssl/dovecot/cert.pem*
>> ssl_key_file = */etc/ssl/dovecot/key.pem*
>> login_greeting = *ISP Mail Server Ready.*
>> mail_location = *maildir:/usr/local/virtual/%d/%n*
>> first_valid_uid = *125*
>> last_valid_uid = *125*
>> first_valid_gid = *125*
>> last_valid_gid = *125*
>> protocol imap {
>> mail_plugins = *quota imap_quota*
>> }
>> protocol pop3 {
>> mail_plugins = *quota*
>> }
>> protocol lda {
>> postmaster_address = *xxxx em xxxx.com*
>> }
>> auth default {
>> *#* passdb pam {
>> *#* }
>> passdb sql {
>> args = */usr/local/etc/dovecot-sql.conf*
>> }
>> *#* userdb passwd {
>> *#* }
>> userdb sql {
>> args = */usr/local/etc/dovecot-sql.conf*
>> }
>> client {
>> path = */var/spool/postfix/private/auth*
>> mode = *0660*
>> *user = postfix*
>> *group = postfix*
>> }
>> }
>> }
>> -------------------------
>> Histórico: http://www.fug.com.br/historico/html/freebsd/
>> Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd
>>
> Se você tenta acessar o MySQL pelo shell dele, funciona?
> Usando as mesmas credenciais?
>
> # mysql -h localhost -u postfix -pSENHA postfix
>
> []s
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf 
/usr/local/etc/mysql/my.cnf ~/.my.cnf
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash                       TRUE
auto-vertical-output              FALSE
character-sets-dir                (No default value)
column-type-info                  FALSE
comments                          FALSE
compress                          FALSE
debug-check                       FALSE
debug-info                        FALSE
database                          (No default value)
default-character-set             auto
delimiter                         ;
vertical                          FALSE
force                             FALSE
named-commands                    FALSE
ignore-spaces                     FALSE
init-command                      (No default value)
local-infile                      FALSE
no-beep                           FALSE
host                              localhost
html                              FALSE
xml                               FALSE
line-numbers                      TRUE
unbuffered                        FALSE
column-names                      TRUE
sigint-ignore                     FALSE
port                              0
prompt                            mysql>
quick                             FALSE
raw                               FALSE
reconnect                         TRUE
socket                            (No default value)
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
table                             FALSE
user                              postfix
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect-timeout                   0
max-allowed-packet                16777216
net-buffer-length                 16384
select-limit                      1000
max-join-size                     1000000
secure-auth                       FALSE
show-warnings                     FALSE
plugin-dir                        (No default value)
default-auth                      (No default value)