Postfox problem setting MySQL skip-name-resolve

[matiasCU]

Estimated,
I need to use the variable skip-name-resolve, to improve connection times remote to my mysql, but when included in /etc/mysql/my.cnf though times get better, it creates a conflict with postfix stops working and throwing the following error:

postfix/trivial-rewrite[7196]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem

Could help me with this? Tks

[falko]

What's in /etc/postfix/mysql-virtual_domains.cf?

[matiasCU]

Falco thank you very much, sorry for the delay.


user = ispconfig
password = thepass
dbname = dbispconfig1
table = mail_domain
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 1
hosts = 127.0.0.1

I was also checking that there are no users using hostnames
http://www.mysqlperformanceblog.com/...-installation/

SELECT user, host
FROM mysql.user
WHERE host <> 'localhost'
AND host
RLIKE '[a-z]'

user host
root server1.domain.tld
ispcsrv2 server2.domain.tld

may be something related to the postfix chroot?

it is my host file:

127.0.0.1 localhost.localdomain localhost
192.168.1.49 server1.domain.tld server1
192.168.1.50 server2.domain.tld server2
# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

Tks