[exim] one more condition

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Chris Knipe
Dátum:  
Címzett: exim-users
Tárgy: [exim] one more condition
Hi,

Just one more quicky that's giving me grief. From the debug, it seems the
if eq refuses to match, and therefore doesn't return anything....

Debug:
>>> processing "deny"
>>> check condition = ${if eq {${lookup mysql{SELECT LocalPart FROM 
>>> Exim_Recipient_Map LEFT JOIN Exim_DomainList ON 
>>> Exim_Recipient_Map.DomainID=Exim_DomainList.EntryID LEFT JOIN 
>>> Exim_ACLList ON Exim_Recipient_Map.DomainID=Exim_ACLList.DomainID WHERE 
>>> Exim_DomainList.isActive='y' AND Exim_ACLList.reqReciptVerify='y' AND 
>>> Exim_Recipient_Map.LocalPart='${quote_mysql:$local_part}' AND 
>>> Exim_DomainList.DomainName='${quote_mysql:$domain}' LIMIT 
>>> 1}}}{${local_part} {yes}{no}}
>>>                 =
>>> deny: condition test failed


Config:
  # MySQL Condition: Recipient Address Verification
  deny    condition     = ${if eq {${lookup mysql{SELECT LocalPart FROM 
Exim_Recipient_Map LEFT JOIN Exim_DomainList ON 
Exim_Recipient_Map.DomainID=Exim_DomainList.EntryID LEFT JOIN Exim_ACLList 
ON Exim_Recipient_Map.DomainID=Exim_ACLList.DomainID WHERE 
Exim_DomainList.isActive='y' AND Exim_ACLList.reqReciptVerify='y' AND 
Exim_Recipient_Map.LocalPart='${quote_mysql:$local_part}' AND 
Exim_DomainList.DomainName='${quote_mysql:$domain}' LIMIT 1}}}{${local_part} 
{yes}{no}}
          message       = Cannot verify ${local_part}@${domain}


The query itself works, and returns correct data as expected....

Basic idea... Verify recipient address from a mysql database.... It's
supposed to be for recipient address maps on domains I intend to *relay*
mail for (and therefore, I believe I cannot use verify = recipient)... If
the recipient exist, the SQL returns the address of the user. If the user
does not exist, a empty string is returned. Hence, I'm trying to match the
result from the SQL, to the address given for rcpt to:

The basic idea here is to stop a lot of frozen messages because I accept the
message for relaying, but the server I relay to, refuses to accept because
the recipient is invalid.


Thanks as always,
Chris