From: Simon (greminngmail.com)
Date: Sun Mar 15 2009 - 17:32:14 CDT

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

Hi There, We are running postfix on debian etch and are using mysql to
store the transport and alias info and having an issue that i need a
little assistance with please. Here is the config:

mydestination = mysql:/etc/postfix/mysql-transport.cf
transport_maps = mysql:/etc/postfix/mysql-transport.cf
virtual_alias_maps=mysql:/etc/postfix/mysql-aliases.cf

Here are the config files:

mail-in1:/etc/postfix# cat mysql-aliases.cf
user = mail-in1
password = password
hosts = 210.xx.xx.xxx
dbname = postfix
table = aliases
select_field = destination_address
where_field = origin_address

mail-in1:/etc/postfix# cat mysql-transport.cf
user = mail-in1
password = password
dbname = postfix
table = transport
hosts = 210.xx.xx.xxx
select_field = transport
where_field = domain

So, in the transport table we have:

domain = testdomain.co.nz
transport = dbmail-lmpt:210.xx.xx.xxx:24

and in the alises table we have:

orgin_address = testtestdomain.co.nz
destination_address = testtestdomain.co.nz

Now - this works fine.. But as soon as i add a pipe to the
destination_address like this:

orgin_address = testtestdomain.co.nz
destination_address = |/usr/local/autoresponder/autoresponder.php

Then we get the following:

Mar 16 11:19:41 mail-in1 amavis[1100]: (01100-07) FWD via SMTP:
<simontestdomain.co.nz> ->
<|/usr/local/autoresponder/autoresponder.phpmail-in1>, 250 2.6.0 Ok,
id=01100-07, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as
3397D482CD
Mar 16 11:19:41 mail-in1 postfix/smtpd[31965]: disconnect from
localhost[127.0.0.1]
Mar 16 11:19:41 mail-in1 postfix/smtpd[31660]: connect from localhost[127.0.0.1]
Mar 16 11:19:41 mail-in1 postfix/smtpd[31660]: 413D048303:
client=localhost[127.0.0.1]
Mar 16 11:19:41 mail-in1 postfix/qmgr[7588]: 3397D482CD:
from=<simontestdomain.co.nz>, size=4776, nrcpt=1 (queue active)
Mar 16 11:19:41 mail-in1 postfix/smtpd[1092]: connect from localhost[127.0.0.1]
Mar 16 11:19:41 mail-in1 postfix/smtpd[1092]: NOQUEUE: reject: RCPT
from localhost[127.0.0.1]: 550 5.1.1
<|/usr/local/autoresponder/autoresponder.phpmail-in1>: Recipient
address rejected: User unknown in local recipient table;
from=<simontestdomain.co.nz>
to=<|/usr/local/autoresponder/autoresponder.phpmail-in1> proto=ESMTP
helo=<mail-in1.newmedia.net.nz>
Mar 16 11:19:41 mail-in1 postfix/smtp[1096]: 3397D482CD:
to=<|/usr/local/autoresponder/autoresponder.phpmail-in1>,
relay=127.0.0.1[127.0.0.1]:587, delay=0.07, delays=0.06/0/0/0.01,
dsn=5.1.1, status=bounced (host 127.0.0.1[127.0.0.1] said: 550 5.1.1
<|/usr/local/autoresponder/autoresponder.phpmail-in1>: Recipient
address rejected: User unknown in local recipient table (in reply to
RCPT TO command))

Can someone please assist with this issue?

Thanks

Simon

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