Find the answer to your Linux question:
Results 1 to 2 of 2
Hi All. Working for two days and can't get it work yet. I've installed postfix with mysql. got the folowing error in mail.log. Jan 5 05:51:08 mutlu postfix/cleanup[1575]: warning: connect ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Dec 2006
    Posts
    3

    Postfix - Mysql problem


    Hi All. Working for two days and can't get it work yet.

    I've installed postfix with mysql. got the folowing error in mail.log.

    Jan 5 05:51:08 mutlu postfix/cleanup[1575]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111
    )
    Jan 5 05:51:08 mutlu postfix/cleanup[1575]: warning: 2547D13401F: virtual_alias_maps map lookup problem for root@mutlusoft.com


    /etc/my.inf has
    bind-adress = 127.0.0.1

    Here is the postmap output:

    mutlu:/etc/postfix# postmap -v -q "test" mysql:/etc/postfix/mysql_virtual_alias_maps.cf
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: user = postfix
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: password = postfix
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: dbname = postfix
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: table = alias
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: select_field = goto
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: where_field = address
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: additional_conditions =
    postmap: cfg_get_str: /etc/postfix/mysql_virtual_alias_maps.cf: hosts = 127.0.0.1
    postmap: mysqlname_parse: /etc/postfix/mysql_virtual_alias_maps.cf: adding host '127.0.0.1' to list of mysql server hosts
    postmap: dict_open: mysql:/etc/postfix/mysql_virtual_alias_maps.cf
    postmap: dict_mysql_lookup using sql query: select goto from alias where address = 'test'
    postmap: dict_mysql_get_active: attempting to connect to host 127.0.0.1
    postmap: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)

  2. #2
    Just Joined!
    Join Date
    Dec 2006
    Posts
    3
    and here is the netstat:

    mutlu:/etc/postfix# netstat -a
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address State
    tcp 0 0 localhost.localdom:3308 *:* LISTEN
    tcp 0 0 *:imap2 *:* LISTEN
    tcp 0 0 *:sunrpc *:* LISTEN
    tcp 0 0 *:www *:* LISTEN
    tcp 0 0 *:auth *:* LISTEN
    tcp 0 0 *:smtp *:* LISTEN

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •