- Previous message: Warrick FitzGerald: "Re: Force Auth by domain"
- Maybe in reply to: mouss: "Re: Lookups on LHS of access tables?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
|
|
|
From: email builder (no email)
Date: Sat Oct 01 2005 - 15:46:38 EDT
> >Yes, simply put, thank you. However, the point of my question was not how
> to
> >build a restriction class, but how to use something like a mysql lookup or
> >$mydestination so that I do not have to manually maintain what is in your
> >example "/etc/postfix/reject_mydomains" with a list of our domains. No,
> it's
> >not the end of the world if that is the only choice, but if postfix
> already
> >has the domain list in $mydestination or the ability to look them up via
> >mysql, then we'd love it if we didn't have to manage our domain list in
> more
> >than one place. Wietse made it sound like it's not really worth it, but
> >mouss suggested that it is possible to do with a mysql lookup, although
> it's
> >been a while since I looked at the finer intricacies of the mysql lookup
> >mechanism, so I'll go read some docs and try to figure out what mouss was
> >suggesting....
> >
> >
> query = SELECT 'REJECT' FROM Users, Domains where
> Domains.domain = '%d' AND
> Domains.class = 'local' AND
> Users.localpart = '%u' AND
> Users.access='outbound_only'
> limit 1
> will return REJECT for foo at example, whenever 'foo' is set to
Ohhhh I see, the lookup should return the RHS value I was after. Thanks!
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
|
|
|