[Dbmail] SQL question

2006-12-18 Thread Michael Monnerie
(this mail is easier to read with a fixed charset) Hi, I have a question to the SQL gurus on this list. I've extended the domains table to resolve the n:m relation customer <-> domaingroups: CREATE TABLE zmi_domains ( domain_idnr BIGSERIAL UNIQUE, --- domain id domain

Re: [Dbmail] Re: alias mapping

2006-12-18 Thread Michael Monnerie
On Montag, 18. Dezember 2006 10:59 Aaron Stone wrote: >Each time a dbmail- binary is executed, a new connection to the > database is created. I see and understand. > Why they didn't just use VRFY I do not know -- then it could have hit > the same LMTP server it would next hit to do the actual del

Re: [Dbmail] Maybe interesting idea

2006-12-18 Thread tom
On Dec 17, 2006, at 2:11 PM, Jorge Bastos wrote: Hi, Aaron/Paul and other developers, Before read this, i'm not asking nothing, this is just something that came to my mind. How about to have a antivirus integration in dbmail-lmtpd ? something like make the email get scanned by a shell scri

Re: [Dbmail] Re: alias mapping

2006-12-18 Thread Aaron Stone
On Mon, 2006-12-18 at 09:19 +0100, Michael Monnerie wrote: > > Perhaps a solution is to have a 'dbmail-checkaddr' that returns 0 or > > 1 depending on whether or not the given address can be delivered at > > all? Bad news is that this would have horrible scalability issues > > unless it were a dae

Re: [Dbmail] imapsync issues from cyrus to dbmail

2006-12-18 Thread Paul J Stevens
Michael Monnerie wrote: > > Yes, it did then. Maybe that would be worth a Wiki entry? Should I? Can > I? I think more (accurate) documentation would be nice. Please do. -- Paul Stevens p

Re: [Dbmail] imapsync issues from cyrus to dbmail

2006-12-18 Thread Michael Monnerie
On Montag, 18. Dezember 2006 09:23 Paul J Stevens wrote: > > Problem 1: > > dbmail creates a header like > > X-DBMail-PhysMessage-ID:94348 > > on messages. > > That's a feature added because of popular request. Yes, and I find it good. It's just good-to-know with imapsync. > Those are both gmime

Re: [Dbmail] imapsync issues from cyrus to dbmail

2006-12-18 Thread Paul J Stevens
Michael Monnerie wrote: > Hello list, maybe somebody ever wants to sync via imapsync from cyrus. > I've fiddled with it these last 2 days, and found this to be useful: > > imapsync --host1 cyrushost --user1 u1 --password1 p1 \ > --host2 dbmailhost --user2 u2 --password2 p2 \ > --authmech1 LOGI

Re: [Dbmail] Non existing user in alias domain

2006-12-18 Thread Michael Monnerie
On Montag, 18. Dezember 2006 06:08 Aaron Stone wrote: > Patience, patience. Nobody's in a rush to overhaul the way we resolve > deliveries. Even if it's only a couple hours of coding, it's tens or > hundreds of hours of thinking it through. Of course. I didn't want the solution right now, but the

Re: [Dbmail] Re: alias mapping

2006-12-18 Thread Michael Monnerie
On Montag, 18. Dezember 2006 06:02 Aaron Stone wrote: > > Why not throw the address as received from the MTA into dbmail, and > > the "rewriting" is done there? It makes sense to do it there: > > So DBMail does the rewrite before delivery. Yes, but the MTA doesn't have to care about anymore, which