I'm currently using TMDA 0.91 and am having some issues getting DB_BARE_APPEND working properly.
Could you have a look at my config and see if I've missed anything obvious ?
For completeness, MySQL table layout:
CREATE TABLE `test_sent` ( `id` smallint(6) NOT NULL auto_increment, `email` varchar(127) NOT NULL default '', `from` varchar(127) default NULL, `lastused` timestamp(14) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY `idx_lastused_email` (`email`,`lastused`) ) TYPE=InnoDB ;
TMDA config:
MAIL_TRANSFER_AGENT = "postfix"
RECIPIENT_DELIMITER = "+"
DELIVERY = "/var/mail/user"
try:
rcptaddr = os.environ['RECIPIENT']
i = rcptaddr.rindex('@')
rcpt, host = rcptaddr[:i], rcptaddr[i+1:]
domain = '.'.join(host.split('.')[-2:])
os.environ['RECIPIENT'] = rcpt + '@' + domain
except KeyError, ValueError:
pass
CONFIRM_APPEND = os.path.expanduser("~/.tmda/lists/confirmed")
BARE_APPEND = os.path.expanduser("~/.tmda/lists/outgoing")
LOGFILE_DEBUG = os.path.expanduser("~/.tmda/logs/debug")
LOGFILE_INCOMING = os.path.expanduser("~/.tmda/logs/incoming")
LOGFILE_OUTGOING = os.path.expanduser("~/.tmda/logs/outgoing")
ACTION_INCOMING = "confirm"
ACTION_OUTGOING = "bare=append"
ACTION_HEADER_INCOMING = 1
HOSTNAME = "my.org"
CGI_URL = "http://www.url.to/tmda.cgi";
FINGERPRINT = ["message-id", "from", "date"]
PENDING_BLACKLIST_APPEND = os.path.expanduser("~/.tmda/lists/blacklist")
PENDING_LIFETIME = "14d"
PENDING_RELEASE_APPEND = os.path.expanduser("~/.tmda/lists/released")
PENDING_WHITELIST_APPEND = os.path.expanduser("~/.tmda/lists/whitelist")
SUMMARY_HEADERS = ['date', 'from', 'to', 'subject', 'x-spam-status']
TEMPLATE_DIR = os.path.expanduser("~/.tmda/templates")
X_TMDA_IN_SUBJECT = 1
PENDING_CACHE = os.path.expanduser("~/.tmda/pending/msgcache.txt")
PENDING_CACHE_LEN = 500
USEVIRTUALDOMAINS = 0
import MySQLdb
DB_CONNECTION = MySQLdb.connect(user="tmda_user",passwd="verysecret",db="tmda")
DB_BARE_APPEND = """ INSERT INTO nivo_sent (email, from, lastused) VALUES (%(recipient)s, %(sender)s, NOW()) """
Relevant filters:
from [EMAIL PROTECTED] bare to [EMAIL PROTECTED] bare to-cdb ~/.tmda/lists/whitelist.cdb bare to-cdb ~/.tmda/lists/outgoing.cdb bare to-file ~/.tmda/lists/whitelist-wildcard bare
For some reason nothing will show up in the table tmda_user, but tmda does not present me with an error message either, not in the outgoing, nor in the debug log. tmda-ofmipd works fine though.
Grtz,
Nils
--
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and dance like no one can see you.
_____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
