Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
On Wed, Jul 18, 2007 at 12:28:08AM +0200, Oliver Peter wrote: > ... > Serious: > I had a little problem with dbmail and pgsql: > http://www.mail-archive.com/[EMAIL PROTECTED]/msg11640.html > > I haven't tried the new version yet. I would like to add: Today I updated dbmail from 2.2.4 to 2.2.5. Certainly the error above has been fixed. -- Oliver PETER, email: [EMAIL PROTECTED], ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." pgpdexqhRLAr8.pgp Description: PGP signature
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
On Wed, Jul 18, 2007 at 11:35:26AM +0100, Feargal Reilly wrote: > On Wed, 18 Jul 2007 00:28:08 +0200 > Oliver Peter <[EMAIL PROTECTED]> wrote: > > > I think one main 'problem' with dbmail will be that if your db > > crashes or stops working EVERYTHING is lost. You don't have > > these problems in this dimension with a filesystem based > > mailsystem. Primarily you will have to find a good > > backup/failover solution for your database - regardless of > > what system you will use (pgsql, mysql, oracle, mssql... > > SQLlite ...) > > > > This is a bit unfair to dbmail - the exact same applies to > filesystem based mail systems. If you do not have a good > backup/failover solution, and your filesystem crashes or stops > working, EVERYTHING is lost. Of course you're right. But when you use a database based mail solution your database can crash and your filesystem can crash. When you use a filesystem based system you don't have the additional db-crash-factor. Personally I trust my filesystem skills more than my database skills :) -- Oliver PETER, email: [EMAIL PROTECTED], ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." pgp09omjweeyn.pgp Description: PGP signature
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
On Wed, Jul 18, 2007 at 03:56:45AM +0300, Bazy wrote: > Oliver Peter wrote: > ... > I'm using it with MySQL, my database is only 900MB with 15000 mails and > it works fine. > > How did you integrate clamav with postfix? Clamav doesn't talk to postfix directly - Amavisd-new will call Clamav. Dunno if this is the best way. Indeed it's very slow on my pentium3. -- Oliver PETER, email: [EMAIL PROTECTED], ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." pgpMQXiT8bEp7.pgp Description: PGP signature
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
Tek Bahadur Limbu wrote: 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 2 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... You should also consider that DSPAM, fully trained, can grow very large. I use a single username for a dozen email boxes, and the database is 3.5GB. Though you can trim it by dropping tokens that aren't as accurate, or aren't as frequently used, it could still become big, especially with a lot of users. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
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. > > 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*). > > If you would like I can show you my configuration files and table > structures. > > I'm using it with MySQL, my database is only 900MB with 15000 mails and it works fine. How did you integrate clamav with postfix? I think through milter is the fastest solution, and if the milter crashes, the mail won't just get scanned, but if a "smtpd_proxy_filter" crashes, the mail will wait in queue and will not be delivered to dbmail. # clamav-milter smtpd_milters = unix:/var/run/clamav/clmilter.sock ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
On Wed, 18 Jul 2007 00:28:08 +0200 Oliver Peter <[EMAIL PROTECTED]> wrote: > I think one main 'problem' with dbmail will be that if your db > crashes or stops working EVERYTHING is lost. You don't have > these problems in this dimension with a filesystem based > mailsystem. Primarily you will have to find a good > backup/failover solution for your database - regardless of > what system you will use (pgsql, mysql, oracle, mssql... > SQLlite ...) > This is a bit unfair to dbmail - the exact same applies to filesystem based mail systems. If you do not have a good backup/failover solution, and your filesystem crashes or stops working, EVERYTHING is lost. -- Feargal Reilly, Chief Techie, FBI. PGP Key: 0xBD252C01 (expires: 2006-11-30) Web: http://www.fbi.ie/ | Tel: +353.14988588 | Fax: +353.14988489 Communications House, 11 Sallymount Avenue, Ranelagh, Dublin 6. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
On Wed, Jul 18, 2007 at 01:22:34AM +0545, Tek Bahadur Limbu wrote: > Oliver Peter wrote: > ... > >On Sun, Jul 15, 2007 at 05:21:49PM +0545, Tek Bahadur Limbu wrote: > >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. Personally I prefer PostgreSQL. It works great for me. In my opinion MySQL is to Postgres like Linux to FreeBSD :) Serious: I had a little problem with dbmail and pgsql: http://www.mail-archive.com/[EMAIL PROTECTED]/msg11640.html I haven't tried the new version yet. > 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? Since I'm the only active user of my dbmail setup it's too oversized for this purpose. I think I can live with a small filesystem based postfix setup, too. Of course it will be more flexible in the long run but I have only a 1,2ghz machine as my main mailserver - simply it is too slow. > >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. Hehe, no problem. You will get them tomorrow. Promised. > 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 2 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!! w00t - as you can see I'm just a little sysadmin managing his very own small mailserver. I never thought about thousands of user - I never thought about to have more than 10 user. Hehe. Well, if you will have such a huge load Postgres would be the best choice for you. As far as -> I <- know it has better methods regarding failover, master- and slaveserver and of course db clusters. I think one main 'problem' with dbmail will be that if your db crashes or stops working EVERYTHING is lost. You don't have these problems in this dimension with a filesystem based mailsystem. Primarily you will have to find a good backup/failover solution for your database - regardless of what system you will use (pgsql, mysql, oracle, mssql... SQLlite ...) > Thanking you... Let's see if my small setup will help you tomorrow. I will get in touch with you. -- Oliver PETER, email: [EMAIL PROTECTED], ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." pgpg3ccAguB4y.pgp Description: PGP signature
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
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 2 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail
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. 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*). If you would like I can show you my configuration files and table structures. -- Oliver PETER, email: [EMAIL PROTECTED], ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." pgpojaTwg1X57.pgp Description: PGP signature