[Postfix-es] table lookup problem

[Anton Rodriguez Yuste]

Hola a todos,

Monte hace un par de meses un servidor postfix con cuentas virtuales
sobre mysql en una Freebsd. Me costo lo mio, pero al final conseguí
que funcionara, y, realmente, estoy muy contento con él.

El caso es que ayer tuve que recompilar Mysql para añadir algunas
funcionalidades (LinuxTreathds). El tema se hizo rápido y ahora mi
servidor Mysql funciona a las mil maravillas, pero mi servidor de
correo ha dejado de enviar mails, aunque si puedo recibirlos.

Os pongo un extracto del maillog a ver si sabeis decirme que puede ser:


Jan  7 11:59:18 shareadictos postfix/smtpd[24050]: connect from
21.Red-80-24-105.pooles.rima-tde.net[80.24.105.21]
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24072]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24072]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24074]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24074]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24076]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/cleanup[20857]: 84F8F51A29:
message-id=<20050107013104.84F8F51A29 en shareadictos.com>
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24076]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24078]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24078]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/cleanup[20857]: warning: connect
to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/cleanup[20857]: warning:
84F8F51A29: virtual_alias_maps map lookup problem for
mastermind_mind en hotmail.com
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24081]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/pickup[17937]: warning:
maildrop/A5915519D6: Error writing message file
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24081]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24081]: fatal:
mysql:/usr/local/etc/postfix/cnf/virtual_alias_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24084]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24084]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24084]: fatal:
mysql:/usr/local/etc/postfix/cnf/virtual_alias_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24087]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24087]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24090]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24090]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24092]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24092]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24094]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24094]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24094]: fatal:
mysql:/usr/local/etc/postfix/cnf/virtual_alias_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24096]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24096]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24096]: fatal:
mysql:/usr/local/etc/postfix/cnf/virtual_alias_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24099]: warning:
connect to mysql server localhost: Bad handshake
Jan  7 11:59:34 shareadictos postfix/trivial-rewrite[24099]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table
lookup problem
Jan  7 11:59:35 shareadictos postfix/smtpd[23132]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[22436]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[22436]: warning: problem
talking to service rewrite: Unknown error: 0
Jan  7 11:59:35 shareadictos postfix/master[17936]: warning: process
/usr/local/libexec/postfix/trivial-rewrite pid 24072 exit status 1
Jan  7 11:59:35 shareadictos postfix/master[17936]: warning:
/usr/local/libexec/postfix/trivial-rewrite: bad command startup --
throttling
Jan  7 11:59:35 shareadictos postfix/smtpd[23132]: warning: problem
talking to service rewrite: Unknown error: 0
Jan  7 11:59:35 shareadictos postfix/smtpd[22665]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[22544]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[22544]: warning: problem
talking to service rewrite: Unknown error: 0
Jan  7 11:59:35 shareadictos postfix/master[17936]: warning: process
/usr/local/libexec/postfix/trivial-rewrite pid 24074 exit status 1
Jan  7 11:59:35 shareadictos postfix/smtpd[22665]: warning: problem
talking to service rewrite: Unknown error: 0
Jan  7 11:59:35 shareadictos postfix/smtpd[19769]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[22732]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[22732]: warning: problem
talking to service rewrite: Unknown error: 0
Jan  7 11:59:35 shareadictos postfix/master[17936]: warning: process
/usr/local/libexec/postfix/trivial-rewrite pid 24076 exit status 1
Jan  7 11:59:35 shareadictos postfix/smtpd[19769]: warning: problem
talking to service rewrite: Unknown error: 0
Jan  7 11:59:35 shareadictos postfix/smtpd[19356]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[18582]: warning: premature
end-of-input on private/rewrite socket while reading input attribute
name
Jan  7 11:59:35 shareadictos postfix/smtpd[18582]: warning: problem
talking to service rewrite: Unknown error: 0



Obviamente me parecio un problema de Mysql, asï que he estado mirando.
He realizado las mismas consultas que postfix desde el cliente de
mysql de la shell y curiosamente devuelven bien los datos. El
phpMyAdmin sin embargo fallaba, pero lo arrelgle cambiando el
'collation' de las tablas a utf8_spanish y ahora ya no.

¿Alguna idea?