On Sunday 13 October 2002 05:46 am, Eelco van Beek - IC&S wrote: > > Hrmm.. That I did not know. But it's also a matter of letting my MTA > > handle > > forwards directly, instead of passing it to dbmail-smtp to handle it, > > though, > > I guess with a decent PgSQL view, I could make it work just the same > > based on > > the aliases, and users tables where aliases.deliver_to doesn't link to > > a > > users.user_idnr. :) > > dbmail-smtp handles that without any problems or without much overhead. > The aliases table can also have forwards to external programs or to > e-mail addresses which are stored in the aliases table itself. It is > the most easy approach to have dbmail-smtp handle this.
Well, I'm not looking for easy. I'm looking for thorough. If a user doesn't exist on my system, a bounce message shouldn't be issued, because it may just be spam trying to send mail to a bocus account and thus, it'll be caught up in my frozen queue for a week. I check the RCTP TO before even giving it a routing point to deliver, so it can deny the invalid user message, and return it to the smtp server trying to send it. > > Hrmm. Everytime I used dbmail-maintenance -cifdp, it runs through, but > > does > > nothing, no matter how many times I run it, and knowing there's been > > mail > > deleted, an example of the results: > > > > *** dbmail-maintenance *** > > Opening connection to the database... Ok. Connected > > Deleting messages with DELETE status... Ok. [0] messages deleted. > > Setting DELETE status for deleted messages... Ok. [0] messages set for > > deletion. > > Now checking DBMAIL messageblocks integrity.. Ok. Found 0 unconnected > > messageblks. > > --- checking block integrity took 1 seconds > > --- checking block integrity took 1 seconds > > Now checking DBMAIL message integrity.. Ok. Found 0 unconnected > > messages. > > --- checking message integrity took 0 seconds > > --- checking message integrity took 0 seconds > > Now checking DBMAIL mailbox integrity.. Ok. Found 0 unconnected > > mailboxes. > > --- checking mailbox integrity took 0 seconds > > --- checking mailbox integrity took 0 seconds > > Cleaning up database structure... Ok. Database cleaned up. > > Maintenance done. > > > > This is /after/ almost 24 hours the dbmail server's been up and in > > use, and I > > have KMail checking email every 10 minutes, deleting POP3 mail once > > it's out > > of there. > > This is weird, it should at least set DELETE status for those deleted > messages. > What db are you using? What version of dbmail? PostgreSQL 7.2.2, and dbmail 1.0 RC4, and it does set DELETE status. Question is, but then doesn't delete them, until the next run. I'm almost beginning to think an hourly cron job to set deletes, and purges are in order, and a nightly clean and fix. > > Well, CRAM-MD5, and DIGEST-MD5, are their own encryption in their own > > ways. > > Both use a challenge & response approach. And both require a plaintext > > password to be stored for AUTH because they both use unreversable > > encryption > > algorithms to test against a plaintext password. > > These are not yet supported. First we're going to implement some > improvements to both pop and imap server (shared folders, better > command parser, better child-parent relationsships ;) How about FOLDER delivery to dbmail-smtp? :) That would be handy, for server-side filtering. Along that, since IMAP is multi-foldered, but also usually left on the server, instead of downloaded for anything more than a cached, a login, for POP3 to fetch mail from another folder would be useful. ;) Something like LOGIN+FOLDER, so userid's like "psi-jack" could fetch from folder Spam, by logging in POP3 as psi-jack+Spam, or another example, userid [EMAIL PROTECTED] in the same context, [EMAIL PROTECTED] > > That was another one on my list. SSL. Is there a way to get SSL/TLS > > with > > dbmail at this time, or will that require stunnelling (if possible?) > > Stunnel works fine for this purpose. Both for pop and imap. Excelent! Good deal. Now I just need to figure out how to actually finally USE stunnel. This would be the first opportunity I'd actually have gotten to use it. ;) Eric
