Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 5th May 2012, 16:26
matiasCU matiasCU is offline
Join Date: Apr 2007
Posts: 57
Thanks: 5
Thanked 2 Times in 2 Posts
Default 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/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem

Could help me with this? Tks
Reply With Quote
Sponsored Links
Old 6th May 2012, 12:44
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts

What's in /etc/postfix/mysql-virtual_domains.cf?
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Old 7th May 2012, 03:49
matiasCU matiasCU is offline
Join Date: Apr 2007
Posts: 57
Thanks: 5
Thanked 2 Times in 2 Posts

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

Reply With Quote
Old 1st February 2014, 23:58
holykim holykim is offline
Join Date: Jan 2009
Posts: 56
Thanks: 17
Thanked 5 Times in 4 Posts

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

Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Email problem 'Cannot set my user or group id.' (using ISPConfig 3 + OpenSuSE 11.2) urosm Installation/Configuration 5 19th June 2010 23:41
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 09:04
Help. Apache don't start payne Server Operation 3 17th August 2007 16:57
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37

All times are GMT +2. The time now is 12:10.

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