"stefan dorn" <[EMAIL PROTECTED]> writes:

> i setup the ~/.tmda/config like the first example on
> http://www.tmda.net/config-vars.html#DB_CONFIRM_APPEND
>
> this causes the following error in ~/.tmda/logs/debug:
> File "/usr/local/tmda-0.92/TMDA/Util.py", line 752, in db_insert
>   DatabaseError = getattr(dbmodule, 'DatabaseError')
>   AttributeError: 'module' object has no attribute 'DatabaseError'

What version of MySQLdb are you using?

> next problem (not important...)
>
> ~/.tmda/filters/incoming:
>
> from-sql -addr_column=address "SELECT address FROM tmda_whitelist WHERE
> user_email = %(recipient)s" AND %(criteria)s LIMIT 1" accept
>
> this works fine, but when i put this sql into the ~/.tmda/config and
> include it in the incoming filter, it doesn't.
>
> example:
>
> ~/.tmda/config:
> SQL_WHITELIST = """SELECT address FROM tmda_whitelist WHERE user_email =
> %(recipient)s" AND %(criteria)s LIMIT 1"""
>
> ~/.tmda/filters/incoming:
> from-sql -addr_column=object_email "$(SQL_WHITELIST)" accept

Use braces, not parentheses; i.e., "${SQL_WHITELIST}".


Tim

_____________________________________________
tmda-users mailing list ([EMAIL PROTECTED])
http://tmda.net/lists/listinfo/tmda-users

Reply via email to