[postfix-es] postfix mysql
troxlinux
xserverlinux en gmail.com
Sab Mayo 11 00:50:40 CEST 2013
postconf | grep mysql
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
postconf: warning: /etc/postfix/main.cf: unused parameter:
program_directory=/usr/lib/postfix
2013/5/10 Manuel Viscencio <mviscencio en gmail.com>
> 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
>>
>
>
--
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/bae5f61e/attachment-0001.html>
Más información sobre la lista de distribución postfix-es