[postfix-es] postfix mysql
Manel Gimeno Zaragozá
magiza83 en hotmail.com
Lun Mayo 13 15:54:06 CEST 2013
Hola,
Revisa estos fichero de configuración de sasl. En mi caso los tengo para que autentique contra un LDAP, pero no deberia ser dificil encontrar ejemplos para mysql.
En este fichero debemos especificar como sasl debe buscar el usuario a autenticar
# cat /etc/saslauthd.conf
sql_hostnames: 127.0.0.1
sql_user: {username}
sql_passwd: {password}
sql_database: mail
sql_select: select password from users where email = ‘%u’
En este, defines como sera la autenticación
# cat /etc/sasl2/smtpd.conf
pwcheck_method: saslauthd
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
En este indicas donde estará el socket de conexión y el tipo de autenticación, como antes, debes buscar cual es el de mysql
# cat /etc/sysconfig/saslauthd
SOCKETDIR=/var/run/saslauthd
MECH=mysql
FLAGS=
De todas maneras, haciendo una busqueda "saslauthd mysql postfix" sale bastante información, no puedo asegurar que esta configuración funcione, pero creo que debes investigar sobre como configurar sasls con mysql. en mi caso lo tengo contra LDAP, por lo que mi configuración no es valida.
Saludos y espero que te ayude.
Manel
From: xserverlinux en gmail.com
Date: Fri, 10 May 2013 15:56:32 -0600
To: mviscencio en gmail.com
CC: postfix-es en lists.wl0.org
Subject: Re: [postfix-es] postfix mysql
la he chkeado y no me jala , poniendo en el smtpd.conf el usuario de postfix y password
estos son los paquetes que tengo instalados
cyrus-sasl-sql-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-lib-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-devel-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-plain-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-2.1.23-13.el6_3.1.x86_64
postfix/smtpd[5127]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 15:56:40 shark postfix/smtpd[5127]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
May 10 15:56:41 shark postfix/smtpd[5127]: warning: SASL authentication failure: Password verification failed
May 10 15:56:41 shark postfix/smtpd[5127]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 15:56:42 shark postfix/smtpd[5127]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
2013/5/10 Manuel Viscencio <mviscencio en gmail.com>
"SASL authentication failure: Password verification failed
May 10 09:16:33 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:16:34 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed"
Es claro que SASL no se esta conectando a mysql correctamente, checate la configuracion de sasl , usuario y password del mysql...
Saludos cordiales
2013/5/10 troxlinux <xserverlinux en gmail.com>
postmap -q domain.com mysql:/etc/postfix/mysql_virtual_domains_maps.cf
domain.com
me lo devuelve perfectamente , tambien tengo las librerias de sasl instaladas
cyrus-sasl-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-sql-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-plain-2.1.23-13.el6_3.1.x86_64
cyrus-sasl-md5-2.1.23-13.el6_3.1.x86_64
con el debug activado , no se si lo tengo correcto porque no veo mucha informacion en el log , si no lo tengo correcto corrijanme
#smtp inet n - n - - smtpd
smtp unix - - n - - smtp -v -v
smtp inet n - n - - smtpd -v -v
smtp-amavis unix - - n - 1 lmtp -o lmtp_data_done_timeout=1200 -o lmtp_send_xforward_command=yes
submission inet n - n - - smtpd
# -o smtpd_enforce_tls=yes
-o smtpd_tls_security_level=encrypt
-o smtpd_sasl_auth_enable=yes
-o smtpd_client_restrictions=permit_sasl_authenticated,reject
-o milter_macro_daemon_name=ORIGINATING
smtps inet n - n - - smtpd
-o smtpd_tls_wrappermode=yes
-o smtpd_sasl_auth_enable=yes
-o smtpd_client_restrictions=permit_sasl_authenticated,reject
-o milter_macro_daemon_name=ORIGINATING
debug_peer_level = 2
# The debug_peer_list parameter specifies an optional list of domain
# or network patterns, /file/name patterns or type:name tables. When
# an SMTP client or server host name or address matches a pattern,
# increase the verbose logging level by the amount specified in the
# debug_peer_level parameter.
#
#debug_peer_list = 127.0.0.1
debug_peer_list = domain.com, domain2.com
#### log de postfix ######
May 10 09:11:33 shark postfix/smtpd[4738]: warning: SASL authentication failure: Password verification failed
May 10 09:11:33 shark postfix/smtpd[4738]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:11:34 shark postfix/smtpd[4738]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
May 10 09:11:35 shark postfix/smtpd[4738]: warning: SASL authentication failure: Password verification failed
May 10 09:11:35 shark postfix/smtpd[4738]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:11:35 shark postfix/smtpd[4738]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
May 10 09:11:37 shark postfix/smtpd[4738]: warning: SASL authentication failure: Password verification failed
May 10 09:11:37 shark postfix/smtpd[4738]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:12:18 shark postfix/smtpd[4738]: lost connection after AUTH from unknown[190.X.X.X]
May 10 09:12:18 shark postfix/smtpd[4738]: disconnect from unknown[190.X.X.X]
May 10 09:14:46 shark dovecot: auth: mysql: Connected to 127.0.0.1 (postfix)
May 10 09:14:48 shark dovecot: pop3-login: Login: user=<ricardo en domain.com>, method=PLAIN, rip=190.X.X.X, lip=198.X.X.X, mpid=4764, TLS
May 10 09:14:49 shark dovecot: pop3(ricardo en domain.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/16, size=837793
May 10 09:15:38 shark postfix/anvil[4741]: statistics: max connection rate 1/60s for (submission:190.X.X.X) at May 10 09:11:20
May 10 09:15:38 shark postfix/anvil[4741]: statistics: max connection count 1 for (submission:190.X.X.X) at May 10 09:11:20
May 10 09:15:38 shark postfix/anvil[4741]: statistics: max cache size 1 at May 10 09:11:20
May 10 09:16:07 shark dovecot: auth: mysql: Connected to 127.0.0.1 (postfix)
May 10 09:16:09 shark dovecot: pop3-login: Login: user=<ricardo en domain.com>, method=PLAIN, rip=190.X.X.X, lip=198.X.X.X, mpid=4769, TLS
May 10 09:16:10 shark dovecot: pop3(ricardo en domain.com): Disconnected: Logged out top=0/0, retr=0/0, del=0/16, size=837793
May 10 09:16:24 shark postfix/smtpd[4770]: warning: hostname X-X-X-190.enitel.net.ni does not resolve to address 190.X.X.X: Name or service not known
May 10 09:16:24 shark postfix/smtpd[4770]: connect from unknown[190.X.X.X]
May 10 09:16:24 shark postfix/smtpd[4770]: Anonymous TLS connection established from unknown[190.X.X.X]: TLSv1 with cipher DHE-DSS-CAMELLIA256-SHA (256/256 bits)
May 10 09:16:30 shark postfix/smtpd[4770]: warning: SASL authentication failure: Password verification failed
May 10 09:16:30 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:16:31 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
May 10 09:16:33 shark postfix/smtpd[4770]: warning: SASL authentication failure: Password verification failed
May 10 09:16:33 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:16:34 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
May 10 09:17:05 shark postfix/smtpd[4770]: warning: SASL authentication failure: Password verification failed
May 10 09:17:05 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL PLAIN authentication failed: authentication failure
May 10 09:17:05 shark postfix/smtpd[4770]: warning: unknown[190.X.X.X]: SASL LOGIN authentication failed: authentication failure
El 9 de mayo de 2013 19:41, Roa Jose <joseroa en gmail.com> escribió:
Primero verifica los permisos de el usuario que se conecta a la BD
Luego una pequeña consulta
postmap -q domain.net mysql:/etc/postfix/mysql_virtual_domains_maps.cf
Si te regresa el nombre del dominio es que si esta bien configurado tu postfix+mysql Podrias intentar subir el debug para ver si nos da algun detalle mas.
On Thu, May 9, 2013 at 5:55 PM, troxlinux <xserverlinux en gmail.com> wrote:
señores gusto en saludarles , tengo un problemita con postfix+mysql+sasl
, he cambiado la version por defecto que trae centos 6.4 y he puesto la
2.9x y algo y aun asi me sigue dando problemas
ostfix/smtpd[2926]: sql plugin could not connect to host 127.0.0.1
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin couldn't connect to any host
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin could not connect to host 127.0.0.1
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin couldn't connect to any host
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin could not connect to host 127.0.0.1
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin couldn't connect to any host
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin could not connect to host 127.0.0.1
May 9 16:49:21 shark postfix/smtpd[2926]: sql plugin couldn't connect to any host
cuando me logeo con thunderbird no me deja enviar correos y no me acepta la contraseña , por webmail sin problemas
unknown[190.2]: SASL PLAIN authentication failed: authentication failure
May 9 16:49:21 shark postfix/smtpd[2926]: warning: unknown[190.2: SASL LOGIN authenticatio
alguna idea?
--
rickygm
http://gnuforever.homelinux.com
_______________________________________________
List de correo postfix-es para tratar temas del MTA postfix en español
postfix-es en lists.wl0.org
http://lists.wl0.org/mailman/listinfo/postfix-es
--
rickygm
http://gnuforever.homelinux.com
_______________________________________________
List de correo postfix-es para tratar temas del MTA postfix en español
postfix-es en lists.wl0.org
http://lists.wl0.org/mailman/listinfo/postfix-es
--
rickygm
http://gnuforever.homelinux.com
_______________________________________________
List de correo postfix-es para tratar temas del MTA postfix en espa�ol
postfix-es en lists.wl0.org
http://lists.wl0.org/mailman/listinfo/postfix-es
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://lists.wl0.org/pipermail/postfix-es/attachments/20130513/a0eeaffd/attachment-0001.html>
Más información sobre la lista de distribución postfix-es