My problem:
tmda is giving me a Parsing Error on my incoming filter,
and I have used the from-sql source as depicted in the documentation.
My DB_CONFIRM_APPEND and DB_BARE_APPEND work as
expected, so I'm not having any problems communicating with my database
server.
Any help is greatly appreciated
Niles Ingalls
Traceback (most recent call last):
File "/usr/local/tmda-1.0.3/bin/tmda-filter", line 53, in ?
execfile(os.path.join(execdir, 'tmda-rfilter'))
File "/usr/local/tmda-1.0.3/bin/tmda-rfilter", line 891, in ?
main()
File "/usr/local/tmda-1.0.3/bin/tmda-rfilter", line 825, in main
infilter.read(Defaults.FILTER_INCOMING)
File "./TMDA/FilterParser.py", line 338, in read
File "./TMDA/FilterParser.py", line 385, in __parse
ParsingError: Filter contains parsing errors: /usr/exim/incoming
[line 7]: "from-sql": missing or bogus <action> field
My configuration:
Slackware Linux 9.1
TMDA 1.0.3
Exim 4.34 (using Virtual Domains)
MySQL 3.23.58
courier-imap 3.0.5
Python-2.3.4
Here is my incoming filter:
from-sql --addr_column=whitelist.address "${SQL_WHITELIST}" accept
Here is the relevant info from my /etc/tmdarc file
import MySQLdb
DB_CONNECTION = MySQLdb.connect(db='xxx',
host='mysql.xxx',
user='xxx',
passwd='xxx')
SQL_WHITELIST = """
SELECT whitelist.address
FROM whitelist, users
WHERE users.id = whitelist.user_email
&& users.id = %(recipient)s
&& %(criteria)s LIMIT 1"""
_____________________________________________
tmda-users mailing list ([EMAIL PROTECTED])
http://tmda.net/lists/listinfo/tmda-users
