From: Philipp Snizek (mailinglistsbelfin.ch)
Date: Wed Mar 02 2005 - 05:29:04 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi

I'm trying to have the /etc/postfix/transport in a sql db.

the table looks like this:

create table postfix_transport (
  id int not null primary key auto_increment,
  forward_to varchar(80) not null,
  domain varchar(80) unique not null
) type=myisam;

/etc/postfix/mysql-transport:

user = dbuser
password = mypassword
dbname = postfix
table = postfix_transport
select_field = `domain`,`forward_to`
where_field = domain
hosts = 127.0.0.1

I know, I've got the problem because of the "," (see ^^^ below).
select_field = `domain`,`forward_to`
                      ^^^
And thus, the log sais:
warning: connect to transport mydomain.com,193.201.146.10: No such
file or directory

Although I could solve this already once I can't remember the
solution.

What's the correct syntax in mysql-transport?

Please help

thank you
Philipp

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]