Stephen Warren <[EMAIL PROTECTED]> writes: [snip IMP/Horde modifications...]
> Two issues, though: > > 1) > > The DB_CONFIRM_APPEND (or DB_BARE_APPEND) INSERT statement don't have > the sender's/recipient's name (parsed out of the to/from header) > available as a variable, hence the newly inserted address book > contacts have nothing in the name field - just an email address. It'd > be nice if we could try and pull this out into the DB too. I'll take this under advisement :) It shouldn't be too difficult to add. > 2) > > I tried to put the whitelist SELECT SQL statement into ~/.tmda/config as: > > ===== > SQL_WHITELIST = """ > SELECT object_email > FROM turba_objects > WHERE owner_id = %(recipient)s > AND %(criteria)s > LIMIT 1""" > ===== > > and use this in ~/.tmda/filters/incoming as: > > ===== > from-sql -addr_column=object_email "$(SQL_WHITELIST)" accept > ===== > > but it didn't appear to expand $(SQL_WHITELIST) at all - it just > attempted to execute that literal text as SQL. Putting the whole SQL > into the filter works fine, but suffers from being a long nasty > looking line! The at http://www.tmda.net/filter-sources.html have an > example setup like this... It looks as if you're using parentheses to surround SQL_WHITELIST. That won't work. The filter parser only understands braces in that context, rather like expanding variables in the shell, only in the filter language the braces are required. Try "${SQL_WHITELIST}" instead. Tim _____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
