[postfix-es] postfix mysql

Manuel Viscencio mviscencio en gmail.com
Sab Mayo 11 00:06:05 CEST 2013


Teclea este comando:


 postconf   | grep mysql


Y te debe  de dar algo similar a esto:

transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf,
mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf

Si algo falta, es por ese lado...
Saludos cordiales



2013/5/10 troxlinux <xserverlinux en gmail.com>

> 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
>
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://lists.wl0.org/pipermail/postfix-es/attachments/20130510/ca3906de/attachment.html>


Más información sobre la lista de distribución postfix-es