Re: [Dbmail] Questions about initial DBmail setup

2008-06-26 Thread Paul J Stevens
Josh Berkus wrote: Hmmm. If you're storing stuff as MIME, you could actually put it in a TEXT field in PostgreSQL. Mind you, that just makes replication easier, it doesn't help otherwise -- both are stored using TOAST regardless. That won't work afaik. Using TEXT would mean forcing the

Re: [Dbmail] Questions about initial DBmail setup

2008-06-26 Thread Naz Gassiep
Perhaps there's something I don't understand, but I thought that messages (including attachments) were all represented using text, i.e., UTF7. Is that not the case? (If this is a n00b question feel free to refer me to an RFC, those things don't scare me). - Naz. Paul J Stevens wrote: Josh

Re: [Dbmail] Questions about initial DBmail setup

2008-06-26 Thread Paul J Stevens
Naz Gassiep wrote: Perhaps there's something I don't understand, but I thought that messages (including attachments) were all represented using text, i.e., UTF7. Is that not the case? (If this is a n00b question feel free to refer me to an RFC, those things don't scare me). If everyone

RE: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Jorge Bastos
From my experience if you want to hear about: 1) How unstable is 2.3.3? I'd like to try out some of the new features. I'm only using it on testing and seams OK, with some problem I think with IDLE. 2) If I run queries against the mail in the backend database, and update or delete

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Paul J Stevens
Josh Berkus wrote: DBMail folks, I'm setting up DB mail for my personal server (this account). I've a number of questions; forgive me that I don't know much at all about adminning mailservers. I know a lot about databases, though. 1) How unstable is 2.3.3? I'd like to try out some of

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Josh Berkus
Paul, Don't use it for anything other than testing. There are still some pretty fundamental issues to iron out. Thanks for the warning. 2.2 it is. Now, if only Ubuntu would update the $%@ packages ... 2) If I run queries against the mail in the backend database, and update or delete

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Aaron Stone
On Jun 25, 2008, at 10:16 AM, Josh Berkus wrote: Paul, Don't use it for anything other than testing. There are still some pretty fundamental issues to iron out. Thanks for the warning. 2.2 it is. Now, if only Ubuntu would update the $%@ packages ... 2) If I run queries against the

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Josh Berkus
Aaron Stone wrote: On Jun 25, 2008, at 10:16 AM, Josh Berkus wrote: Paul, Don't use it for anything other than testing. There are still some pretty fundamental issues to iron out. Thanks for the warning. 2.2 it is. Now, if only Ubuntu would update the $%@ packages ... 2) If I run

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Naz Gassiep
Hi Josh :) Greetings from pg-hackers :) - Naz. Josh Berkus wrote: Aaron Stone wrote: On Jun 25, 2008, at 10:16 AM, Josh Berkus wrote: Paul, Don't use it for anything other than testing. There are still some pretty fundamental issues to iron out. Thanks for the warning. 2.2 it is.

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Curtis Maurand
I've been running it on Ubuntu for a couple of years. I've got 2.2 running on Ubuntu Server 6.10 LTS and it compiles from source perfectly. Curtis Josh Berkus wrote: Paul, Don't use it for anything other than testing. There are still some pretty fundamental issues to iron out. Thanks

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Paul J Stevens
Josh Berkus wrote: Keen! Hopefully I'll be able to do a write up on replicated e-mail with dbmail ... On postgresql perhaps? Where do attachments go? Depends. In 2.2 everything is chopped up into 500k blocks and stuffed in blobs that are simply concatened on retrieval. So attachments are

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Josh Berkus
Paul, Keen! Hopefully I'll be able to do a write up on replicated e-mail with dbmail ... On postgresql perhaps? What, like I'd use something else? ;-) In 2.3+ attachments are indeed stored as atomic blobs in the mimeparts table. The rfc822 header part of the complete message, and the

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Paul J Stevens
Josh Berkus wrote: Paul, Keen! Hopefully I'll be able to do a write up on replicated e-mail with dbmail ... On postgresql perhaps? What, like I'd use something else? ;-) THing is people talk a lot about pros and cons of running dbmail on a mysql-replication setup. But I havent heard

[Dbmail] Questions about initial DBmail setup

2008-06-24 Thread Josh Berkus
DBMail folks, I'm setting up DB mail for my personal server (this account). I've a number of questions; forgive me that I don't know much at all about adminning mailservers. I know a lot about databases, though. 1) How unstable is 2.3.3? I'd like to try out some of the new features. 2) If

Re: [Dbmail] Questions

2006-01-30 Thread Andy Savage
to put myDNS administration and proftpd all togheter in the same application, so any pre existing tool will not work for me. Jorge - Original Message - From: Tommi Lätti [EMAIL PROTECTED] To: DBMail mailinglist dbmail@dbmail.org Sent: Monday, January 30, 2006 2:35 AM Subject: Re: [Dbmail

Re: [Dbmail] Questions

2006-01-30 Thread Curtis Maurand
what I'm working on a multi-user (meaning support staff) managment system. Its a complete management system written in PHP. If you're looking for something that you can deploy easily and quickly, you should look at dbmail administrator. Its not the greates interface in the world, but it works.

Re: [Dbmail] Questions

2006-01-29 Thread zamri
On 1/28/06, Curtis Maurand [EMAIL PROTECTED] wrote: The user_idnr is an auto-increment number. The database assigns that integer automatically. Then you use that number to create the rest of what you need. I had a perl script at one point to do this which would give you the queries that

Re: [Dbmail] Questions

2006-01-29 Thread Bradley Giesbrecht
Me too. -Brad On Jan 29, 2006, at 4:31 AM, zamri wrote: On 1/28/06, Curtis Maurand [EMAIL PROTECTED] wrote: The user_idnr is an auto-increment number. The database assigns that integer automatically. Then you use that number to create the rest of what you need. I had a perl script at

[Dbmail] Questions on DBMail IMAP server

2005-03-29 Thread gopalakrishnan kamalanathan
Hi, I have a few question on the IMAP implementation. 1) What is the memory footprint of the DBMail IMAP. 2) What is the maximum number of simultaneous connections that the DBMail IMAP server can handle. 3) How many threads does the DBMail imap server create? Does it have a fixed pool of

Re: [Dbmail] Questions on DBMail IMAP server

2005-03-29 Thread Paul J Stevens
gopalakrishnan kamalanathan wrote: Hi, I have a few question on the IMAP implementation. 1) What is the memory footprint of the DBMail IMAP. Mmm, my main inhouse mailserver (5 heavy users with many very large mailboxes) running dbmail2-mysql-ldap (trunk-snapshot): [EMAIL PROTECTED]:~#

[Dbmail] DBMail questions

2004-05-21 Thread Kelv
Hello everyone, I recently installed DBMail 1.2.7 on a test system with MySQL 4 Exim 4 and think DBMail is very good! I hope to deploy it on a production system soon, and while the DBMail list archive was useful in providing some answers to my questions, it also created new questions! :)

Re: [Dbmail] DBMail questions

2004-05-21 Thread Blake Mitchell
I've been running dbmail 2.x rc/cvs (Postfix 2 MTA) as my sole mail repository for some months now. I have a few gigs of mail stored, but only a handful of users. I had a few delivery chain issues about a month ago that required me to go into the database and fix some mail, but I haven't lost

[Dbmail] Questions

2003-11-11 Thread Tim Gurney
Ok, after a further dig into the setup, i am happy that the mail is handling the virtualdomains correctly, if i send an email to tim, it goes into the logs as dbmail-tim, this sahould then go via the .qmail in the dbmail home dir and pass it to dbmail-smtp, but i am fairly sure that this is not

Re: [Dbmail] Questions

2003-11-11 Thread Simon Gray
after a further dig into the setup, i am happy that the mail is handling the virtualdomains correctly, if i send an email to tim, it goes into the logs as dbmail-tim, this sahould then go via the .qmail in the dbmail home dir and pass it to dbmail-smtp, but i am fairly sure that this is not

Re: [Dbmail] Questions

2003-11-11 Thread Tim Gurney
snip Have you followed the qmail install info? (see below) if you've placed the 'domain:user' reference within /var/qmail/control/virtualdomains qmail should forward all email from that domain to the specificied user. In your case the dbmail user. also don't forget to tell qmail to accept