HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Postfox problem setting MySQL skip-name-resolve (http://www.howtoforge.com/forums/showthread.php?t=57192)

matiasCU 5th May 2012 16:26

Postfox problem setting MySQL skip-name-resolve
 
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 6th May 2012 12:44

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

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 = 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

holykim 1st February 2014 23:58

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

Thanks


All times are GMT +2. The time now is 17:59.

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