Postfox problem setting MySQL skip-name-resolve

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

  1. matiasCU

    matiasCU Member

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

    falko Super Moderator ISPConfig Developer

    What's in /etc/postfix/
  3. matiasCU

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

    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

  4. holykim

    holykim Member

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


Share This Page