On Thu, Jan 15, 2009 at 05:17:07AM -0000, jeff_homeip wrote:
> > There's the problem. Now test the table as Noel suggested.
> >
> > $ echo katie.prev...@... |
> > postmap -q - mysql:/etc/postfix/mysql_smtpd_sender_login_maps.cf
>
> I just tested again with this result:
>
> % /etc/postfix : postmap -q [email protected]
> mysql:/etc/postfix/mysql_smtpd_sender_login_maps.cf
> % /etc/postfix :
Please use the suggested:
echo <lookup-key> | postmap -q - <table>
form. Also as documented, "smtpd_sender_login_maps" uses additional
lookup keys:
http://www.postfix.org/postconf.5.html#smtpd_sender_login_maps
smtpd_sender_login_maps (default: empty)
Optional lookup table with the SASL login names that own sender
(MAIL FROM) addresses.
Specify zero or more "type:table" lookup tables. With lookups from
indexed files such as DB or DBM, or from networked tables such as
NIS, LDAP or SQL, the following search operations are done with a
sender address of u...@domain:
1) u...@domain
This table lookup is always done and has the highest precedence.
2) user
This table lookup is done only when the domain part of the sender
address matches $myorigin, $mydestination, $inet_interfaces
or $proxy_interfaces.
3) @domain
This table lookup is done last and has the lowest precedence.
In all cases the result of table lookup must be either "not found"
or a list of SASL login names separated by comma and/or whitespace.
You need to tset the full set of lookup keys (sh, ksh or bash, not csh):
(
echo morris.com |
postmap -q - mysql:/etc/postfix/mysql_mydestination_maps.cf >&2 &&
echo katie.prevost
sleep 1
echo [email protected]
echo @morris.com
) | postmap -q - mysql:/etc/postfix/mysql_smtpd_sender_login_maps.cf
All this assumes that the sender address in question is unmodified...
--
Viktor.
Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the "Reply-To" header.
To unsubscribe from the postfix-users list, visit
http://www.postfix.org/lists.html or click the link below:
<mailto:[email protected]?body=unsubscribe%20postfix-users>
If my response solves your problem, the best way to thank me is to not
send an "it worked, thanks" follow-up. If you must respond, please put
"It worked, thanks" in the "Subject" so I can delete these quickly.
