I'm receiving an error from tmda-ofmipd, related to my
DB_BARE_APPEND sql query.
Here's the relevant information from /etc/tmdarc
DB_BARE_APPEND = """INSERT INTO tmda VALUES( %(sender)s, %(recipient), 'ok', '')"""
Here's my output filter:
to-sql -addr_column=preference "${DB_BARE_APPEND}" bare
Here's the error from tmda-ofmipd when run:
/usr/local/tmda-1.0.3/bin/tmda-ofmipd -d -f -S /usr/exim/exim_outgoing.php -R imap localhost
Error: failure delivering message to command "['/usr/local/tmda-1.0.3/bin/tmda-inject', '[EMAIL PROTECTED]']" (command "['/usr/local/tmda-1.0.3/bin/tmda-inject', '[EMAIL PROTECTED]']" exited 1 (Traceback (most recent call last):
File "/usr/local/tmda-1.0.3/bin/tmda-inject", line 457, in ?
main()
File "/usr/local/tmda-1.0.3/bin/tmda-inject", line 431, in main
[from_address])
File "./TMDA/FilterParser.py", line 1030, in firstmatch
File "./TMDA/FilterParser.py", line 845, in __search_sql
File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 95, in execute
return self._execute(query, args)
File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 114, in _execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
raise errorclass, errorvalue
KeyError: 'sender'))
error: uncaptured python exception, closing channel <__main__.SMTPChannel connected 66.17.219.194:51152 at 0x4033feec> (exceptions.IOError:tmda-inject failed! [/usr/lib/python2.3/asyncore.py|read|69] [/usr/lib/python2.3/asyncore.py|handle_read_event|390] [/usr/lib/python2.3/asynchat.py|handle_read|136] [./tmda-ofmipd|found_terminator|837] [./tmda-ofmipd|process_message|1132])
tmda-ofmipd is crashing on any substituted variables,
(username, hostname, sender, fromheaders) but the sql
query runs file if I hard-code the sender & recipient
address & my other SQL queries run fine when accessed from
tmda-filter.
Any help is greatly appreciated
Niles Ingalls
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
Spamassassin-2.63
Amavis</x-tad-bigger>
_____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
