Postfox problem setting MySQL skip-name-resolve

Discussion in 'Installation/Configuration' started by matiasCU, May 5, 2012.

  1. matiasCU

    matiasCU New Member

    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
     
  2. falko

    falko Super Moderator ISPConfig Developer

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

    matiasCU New Member

    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/2008/05/31/dns-achilles-heel-mysql-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
     
  4. holykim

    holykim Member

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

    Thanks
     

Share This Page