On Sat, 2007-09-08 at 12:35 -0500, Lindsay Haisley wrote:
> On Sat, 2007-09-08 at 12:49 -0400, Sam Varshavchik wrote:
> > >> The only suspicious thing I see in your log entry is:
> > >>
> > >> …/tcdp.org/alias!!,addr=<.iS>
> > >>
> > >> I have no idea where the ".iS" recipient address comes from.
>
> I have a hunch here, and I'm going to research it. I'm using a pretty
> complex query of the MySQL database which contains my virtual mail data
> in , and I have things set up so that the query will return a valid
> account for either "[EMAIL PROTECTED]" or "user.domain.name". I'll bet I
> need to revisit this query and possibly refine it. My guess is that it
> may be returning some kind of a result if the username is null.
>
> MYSQL_SELECT_CLAUSE select CONCAT(id,"@",domain_name) as
> idd,crypt,clear,uid,gid,home,maildir,quota,name,"" from courier.passwd
> where (id=lower("$(local_part)") and domain_name=lower("$(domain)")) or
> CONCAT(lower(id),".",lower(domain_name))="$(local_part)"
>
> if "$local_part == "" we still have a valid query, say, for @fmp.com:
>
> select CONCAT(id,"@",domain_name) as
> idd,crypt,clear,uid,gid,home,maildir,quota,name,"" from courier.passwd
> where (id=lower("") and domain_name=lower("fmp.com")) or
> CONCAT(lower(id),".",lower(domain_name))=""
>
> This returns an empty set if I do this manually, but if I turn on MySQL
> logging I may see some informative results from courier's queries.
No, no luck here. Just as if I supplied a non-null username, an attempt
to send email to "@fmp.com" first does the query noted above, and gets
an empty set, so next it looks up "[EMAIL PROTECTED]". The logs look
proper, and much the same as if I supplied a username supported by
a .courier-xxx file in the alias directory.
Sam, when you could not confirm this bug, what version of Courier were
you using? I'm using 0.55.1-r1 ("r1" = Gentoo Linux revision number).
You mentioned that there have been some extensive revisions to the code
supporting alias accounts. Did you test on this version, or on one that
contains changes to courierlocal which might affect this problem?
--
Lindsay Haisley | "In an open world, | PGP public key
FMP Computer Services | who needs Windows | available at
512-259-1190 | or Gates" | http://pubkeys.fmp.com
http://www.fmp.com | |
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
