On Jul 16, 2004, at 9:58 PM, David Grimberg wrote:
Niles,<snip>
�
My first guess is that you are attempting to use the DB_BARE_APPEND variable inapropriatly.
�
Long story short try using a SELECT query with your to-sql filter rule.
�
Dave
Thanks for the reply Dave. I corrected my to-sql filter rule from:
to-sql -addr_column=preference "${DB_BARE_APPEND}" bare
to:
to-sql -addr_column=preference "${SQL_WHITELIST}" bare
and it solved that particular problem.
More importantly, I now understand what I did and why I was confused into making that error.
After making this correction, I ran into a couple other problems that I may or may have not solved
the right way.
tmda-ofmipd was placing my unix username & hostname in place of my
virtualusername & virtualhostname into my database. My confirmations
get logged properly into the db, which is probably attributable to the environmental
variables I defined in exim for the tmda transport.
To fix this, I made a small modification to tmda-ofmipd in the VdomainProxy class.
I added:
login_auth = os.environ['LOGIN'].split('@', 1)
os.environ['HOST'] = login_auth[1]
os.environ['USER'] = login_auth[0]
and made a catch all virtualdomains file that contained:
I also had a problem with the confirmation e-mails. Each confirmation send displayed
exim's unix userid instead of the users e-mail address. I don't think this is desired
behavior, and I could not find a configuration variable to change this behavior.
To change this behavior for my mtda setup, I made the following modification in AutoResponse.py:
# self.mimemsg[k] = formataddr((name, addr))
self.mimemsg[k] = formataddr((addr, addr))
I now have tmda working to my satisfaction, but I don't know if I took the best approach
by modifying tmda-ofmipd & AutoResponse.py. I just attributed my hurdles to the fact that
exim virtualdomains are not supported by tmda (like qmail), but It's more likely that I simply setup my
configuration incorrectly and patched inappropriately.
If anyone reading this list finds fault with my "solutions", then please guide me in the right direction.
Thanks
Niles Ingalls
# self.mimemsg[k] = formataddr((name, addr))
self.mimemsg[k] = formataddr((addr, addr))
to-sql -addr_column=preference "${DB_BARE_APPEND}" bare
_____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
