Em 4/15/2011 4:53 PM, Renato Botelho escreveu:
> 2011/4/15 Daniel<daniel2...@r7.com>:
>> Em 4/14/2011 9:39 PM, irado furioso com tudo escreveu:
>>> Em Thu, 14 Apr 2011 19:01:34 -0300
>>> Daniel<daniel2...@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 = *x...@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)
-------------------------
Histórico: http://www.fug.com.br/historico/html/freebsd/
Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd
