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 ...
- 01-05-2007 #1Just 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)
- 01-05-2007 #2Just 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


Reply With Quote