Re: Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Jeff Weinberger
On Jan 6, 2009, at 5:59 PM, Wietse Venema wrote: Jeff Weinberger: I then added the line: smtpd_sender_login_maps=hash:/path/to/map to my main.cf and send a few messages. Postfix correctly allowed and rejected all of the test messaages, and the logs showed the correct reason for the rejection,

Re: Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Wietse Venema
Jeff Weinberger: > I then added the line: > > smtpd_sender_login_maps=hash:/path/to/map > > to my main.cf and send a few messages. Postfix correctly allowed and > rejected all of the test messaages, and the logs showed the correct > reason for the rejection, and no log entries showing a succe

Re: Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Jeff Weinberger
On Tue Jan 6, 2009 2:42 pm Victor Duchovni wrote: > I know that it is not a good model for the way postfix requires the > query, More stronly, an SQL schema in which multiple data items are stored concatenated in a single table element is a poor schema regardless of the application. This violat

Re: Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Victor Duchovni
On Tue, Jan 06, 2009 at 12:16:00PM -0800, Jeff Weinberger wrote: > Hi: > > I would very much appreciate any help, advice, pointers, etc. to > resolve an issue I am encountering. > > I am having a challenge trying to use a mysql table for > smtpd_sender_login_maps. Right now I have: > > In m

Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Jeff Weinberger
Hi: I would very much appreciate any help, advice, pointers, etc. to resolve an issue I am encountering. I am having a challenge trying to use a mysql table for smtpd_sender_login_maps. Right now I have: In main.cf: smtpd_sender_login_maps=mysql:/path/to/map.cf smtpd_sender_restrict