[postfix-es] postfix mysql
troxlinux
xserverlinux en gmail.com
Jue Mayo 16 20:05:06 CEST 2013
estimados saludos , despues de tanto batallar encontre la solucion al
problema en este link
http://www.dovecot.org/list/dovecot/2012-May/065607.html
el problema era el nginx que me estaba dando palo
ahora he resuelto el problema , gracias a todos por el apoyo prestado.
sldss
2013/5/13 Manel Gimeno Zaragozá <magiza83 en hotmail.com>
> 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
>
--
rickygm
http://gnuforever.homelinux.com
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://lists.wl0.org/pipermail/postfix-es/attachments/20130516/d81c2d3d/attachment-0001.html>
Más información sobre la lista de distribución postfix-es