[Postfix-br] RES: RES: Postfix otimizado para envio de mala direta

[vic]

Em 2012-07-18 12:01, Bruno Menoli escreveu:
> Abaixo a mensagem de erro:
>
> Jul 18 11:56:58 SERVIDOR dovecot: auth: Debug:
> sql(bruno at xxxxxxxxx,IP): query: SELECT password FROM mailbox WHERE
> username = ‘bruno at xxxxxxxxxxx’ AND active = ’1′ user_query = SELECT
> maildir, 89 AS uid, 89 AS gid FROM mailbox WHERE username =
> ‘bruno at xxxxxxxxx’ AND active = ’1′
> Jul 18 11:56:58 SERVIDOR dovecot: auth: Error: mysql: Query failed,
> retrying: 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 '��bruno at XXXXXX’ AND active = ’1′ user_query = S' at line 1
> Jul 18 11:56:58 SERVIDOR dovecot: auth: Error:
> sql(bruno at xxxxxxxx,IP): Password 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 '��bruno at xxxxxxxxx’
> AND active = ’1′ user_query = S' at line 1
> Jul 18 11:57:00 SERVIDOR dovecot: auth: Debug: client out:
> FAIL#0111#011user=bruno at xxxxxxxxx#011temp
>
>
>
> Abaixo o arquivo de conexão com o MYSQL:
>
> dovecot-mysql.conf
>
> driver = mysql
> #Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5,
> and CRYPT. default_pass_scheme = CRYPT
> connect = host=localhost dbname=XXXXX user=XXXXXX password=XXXXXXX
> password_query = SELECT password FROM mailbox WHERE username = ‘%u’
> AND active = ’1′ user_query = SELECT maildir, 89 AS uid, 89 AS gid
> FROM mailbox WHERE username = ‘%u’ AND active = ’1′
>
> Já consigo receber a mensagem no servidor e enviar, com base nos
> dados do postfixadmin. Problema agora é baixar via POP.
>
>
> Obrigado.
>

Seu select está errado. Ou melhor ainda, sua configuração está errada.

Falta um ENTER entre a configuração pasword_query e a configuração 
user_query:

password_query = SELECT password FROM mailbox WHERE username = ‘%u’
  AND active = ’1′ ****** DAR UM ENTER AQUI *** user_query = SELECT 
maildir, 89 AS uid, 89 AS gid
  FROM mailbox WHERE username = ‘%u’ AND active = ’1′

Você está precisando de café para manter os olhos abertos :P

-- 
vic
http://choppnerd.com
http://donttrack.us   |   http://dontbubble.us