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.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th May 2012, 15:26
matiasCU matiasCU is offline
Member
 
Join Date: Apr 2007
Posts: 57
Thanks: 5
Thanked 2 Times in 2 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 6th May 2012, 11:44
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

What's in /etc/postfix/mysql-virtual_domains.cf?
__________________
Falko
--
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
  #3  
Old 7th May 2012, 02:49
matiasCU matiasCU is offline
Member
 
Join Date: Apr 2007
Posts: 57
Thanks: 5
Thanked 2 Times in 2 Posts
Default

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
Reply With Quote
  #4  
Old 1st February 2014, 22:58
holykim holykim is offline
Member
 
Join Date: Jan 2009
Posts: 53
Thanks: 15
Thanked 4 Times in 3 Posts
 
Default

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

Thanks
Reply With Quote
Reply

Bookmarks

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 22:41
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 08:04
Help. Apache don't start payne Server Operation 3 17th August 2007 15:57
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 19:40.


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