HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   Installation/Configuration (
-   -   Postfox problem setting MySQL skip-name-resolve (

matiasCU 5th May 2012 16:26

Postfox problem setting MySQL skip-name-resolve
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/,lock|fold_fix): table lookup problem

Could help me with this? Tks

falko 6th May 2012 12:44

What's in /etc/postfix/

matiasCU 7th May 2012 03:49

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 =

I was also checking that there are no users using hostnames

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: localhost.localdomain localhost server1.domain.tld server1 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


holykim 1st February 2014 23:58

I just have the same problem. Do you have any update?


All times are GMT +2. The time now is 06:50.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.