From owner-freebsd-questions@FreeBSD.ORG Tue Jul 17 19:38:11 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 7A7B616A405 for ; Tue, 17 Jul 2007 19:38:11 +0000 (UTC) (envelope-from teklimbu@wlink.com.np) Received: from smtp5.wlink.com.np (smtp5.wlink.com.np [202.79.32.52]) by mx1.freebsd.org (Postfix) with SMTP id 443F713C481 for ; Tue, 17 Jul 2007 19:38:05 +0000 (UTC) (envelope-from teklimbu@wlink.com.np) Received: (qmail 8600 invoked from network); 17 Jul 2007 19:37:57 -0000 Received: from unknown (HELO smtp1.wlink.com.np) (202.79.32.76) by 0 with SMTP; 17 Jul 2007 19:37:57 -0000 Received: (qmail 25532 invoked by uid 98); 17 Jul 2007 19:37:57 -0000 Received: from 202.79.38.68 by smtp1.wlink.com.np (envelope-from , uid 1009) with qmail-scanner-1.25 (clamdscan: 0.88.4/2205. Clear:RC:1(202.79.38.68):. Processed in 0.047061 secs); 17 Jul 2007 19:37:57 -0000 X-Qmail-Scanner-Mail-From: teklimbu@wlink.com.np via smtp1.wlink.com.np X-Qmail-Scanner: 1.25 (Clear:RC:1(202.79.38.68):. Processed in 0.047061 secs) Received: from [202.79.38.68] (HELO [202.79.38.68]) by smtp1.wlink.com.np (qmail-smtpd) with SMTP; 17 Jul 2007 19:37:51 -0000 (Wed, 18 Jul 2007 01:22:51 +0545) Message-ID: <469D1A7E.6030906@wlink.com.np> Date: Wed, 18 Jul 2007 01:22:34 +0545 From: Tek Bahadur Limbu User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: Oliver Peter References: <469A06D1.4030601@wlink.com.np> <20070717155834.GK46587@nemesis.frida.mouhaha.de> In-Reply-To: <20070717155834.GK46587@nemesis.frida.mouhaha.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Check-By: smtp1.wlink.com.np Spam: No ; 0.3 / 7.0 X-Spam-Status-WL: No, hits=0.3 required=7.0 Cc: freebsd-questions@freebsd.org Subject: Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 17 Jul 2007 19:38:11 -0000 Oliver Peter wrote: > On Sun, Jul 15, 2007 at 05:21:49PM +0545, Tek Bahadur Limbu wrote: >> Hi All, >> >> I was wondering if anybody on this list has successfully implemented the >> following setup on a FreeBSD machine? >> >> Postfix + Amavisd-new + Clamav + DSpam + DBmail (PostgreSQL) >> >> Can I use the following diagram for this? >> >> Postfix --> Amavisd-new --> Clamav --> Amavisd-new --> DSpam --> Postfix >> --> DBmail-lmtpd --> DBmail-Database? >> >> Is this the correct or optimal setup? >> >> Being relatively new to the world of MTAs, please forgive me for any >> naive questions. >> >> >> Any pointers, suggestions and tips will be highly appreciated. > > I'm using FreeBSD 6.2-RELEASE-p2 with Postfix, Cyrus-SASL2, amavisd-new, clamav > and dbmail (only IMAP with stunnel) with a pgsql backend. Hi Oliver, Thanks alot for your reply. I was lost on this one! > > I would like to switch back to a filesystem based e-mail backend > (maybe dovecot) - feels better to me. Furthermore I think that dbmail > has no good pgsql support (it has some bugs with IMAP) - > maybe you would like to try mysql instead (*hirgs*). I think that I may have to switch back to Mysql then. I heard that PostgreSQL is more scalable than Mysql. But I am not an experienced database user, so, please forgive my little knowledge. Why do you want to switch back to to a filesystem based e-mail backend? I suppose storing emails in a database should be more scalable and flexible in the long run? > > If you would like I can show you my configuration files and table > structures. Of course, I would like to see your configuration files. In fact, I am dying to see it. I am planning my current setup to be used for a long term basis in a production environment for a very large user base. Me and my team are currently just designing and testing it out. It might take some time before we can put this server in production. Since I am very new to database terminology, how scalable is a database in terms of the data storage size. I mean suppose, we have 20000 users each with a quota of 1 GB. What will eventually happen if they all used up their quotas. That will be about 20 TB in size!! Thanking you... > -- With best regards and good wishes, Yours sincerely, Tek Bahadur Limbu (TAG/TDG Group) Jwl Systems Department Worldlink Communications Pvt. Ltd. Jawalakhel, Nepal http://www.wlink.com.np