-------- Original-Nachricht -------- > Datum: Fri, 7 Aug 2009 00:33:26 +0200 > Von: "Imposit.com - Webmaster" <[email protected]> > An: [email protected] > Betreff: Re: [Dspam-user] DSpam Web Gui outside mail server
> Hi, > > Do not try to share the home directorys by samba or nfs. Theres a mailbox > lickingproblem with networkshares and mailboxes or use maildir but even > here > might be some problems.If you want to go the way to share the users home > you > have to use a common SAN or something like that. > > @Steve what you mean everything is in the backend? Quarantine box and > userstats etc also????? > No. On the backend (in my case MySQL) th user preferences are there and the DSPAM tables. But on the network shared drive I have the quarantine box and the userstats. And yes! It works! Without issues. John did some code to avoid problems. See CHANGELOG: ========================= [20040607.1800] jonz: replaced quarantine locking with fcntl locking replaced quarantine .lock'ing with fcntl locking and also applied it to locking .log files. fcntl should work over NFS. [20030904.0700] jonz: nfs locking modified lock.c to work over nfs mounts, only checking pid when hostname matches. maximum 20-minute stale lock removal. ========================= And I am even more crazy then average DSPAM user. I don't use NFS or SMB or anything in that direction. I use a clustered and distributed filesystem and on top of that the FS does replication. I might in the near future rewrite a part of the DSPAM code to allow me to log into the storage backend. As much as I like MySQL as much I do hate it. It is so damn stupid system. So I am going first to overload the logging mechanism in DSPAM and then later the quarantine part. The quarantine part is the one I don't like to code. The reason is that making one that fits everywhere is not easy to do with MySQL. That damn thing is ultra stupid. Assume you have set the maximum query to be 1MB. Now assume your mail is 5MB. So you have to split it into 1MB chunks. Or you go and add the 5 parts and then concatenate them into one blob. But exactly this is not going to work. If you would say to MySQL something like CONCAT 1 + 2 + 3 + 4 + 5 then MySQL is not going to look at the (pseudo) query "CONCAT 1 + 2 + 3 + 4 + 5" and say: oohh. The whole query is way, way below 1MB. No! It's going to count size of the FIELDS 1, 2, 3,4 and 5 and say: No! The fields together are above 1MB. That's stupid. This is then not max query size but max processing size or something like that. I hate that limitation in MySQL. It's ultra stupid. If I look how others have done it (for example Amavisd-new) then I just hate doing that code part. Amavisd-new btw is splitting at 16KB. Imagine how much records that will be for normal SPAM mails... // Steve > -----Ursprüngliche Nachricht----- > Von: Steve [mailto:[email protected]] > Gesendet: Donnerstag, 06. August 2009 19:07 > An: [email protected] > Betreff: Re: [Dspam-user] DSpam Web Gui outside mail server > > > -------- Original-Nachricht -------- > > Datum: Thu, 6 Aug 2009 17:34:29 +0200 > > Von: "Sebastian Toepfer" <[email protected]> > > An: [email protected] > > Betreff: Re: [Dspam-user] DSpam Web Gui outside mail server > > > Hallo, > > > > -------------------------------------------------- > > From: "Marc Franquesa" <[email protected]> > > Sent: Thursday, August 06, 2009 11:16 AM > > To: <[email protected]> > > Subject: [Dspam-user] DSpam Web Gui outside mail server > > > > > Hi! > > > > > > I'm trying dspam to replace spamassassin installation on my > > > Postfix+Dovecot Server. > > > > > > I have to servers: One is the mail server (Postfix+Dovecot) an another > > > the Web Server (Apache+MysQL with dspam tables) > > > > > > ¿Is possible to use de dspam-cgi in this configuration? IE. having > the > > > dspam-cgi in another server that isn't the mail server? > > > > > > > yes and no. you need on webserver the dspam binary (for retrain and so > on) > > and dspam configure plus access (share) to the dspam home (for stats, > > quarantine) from the mail server. the dspam configuration must sync and > it > > should work, but I'm sure nobody has run this setup before. > > > I do run that. The sync part is not that important. The most important > part > (for me) is that the access to the storage backend is possible. The config > inside DSPAM is not so important for me since I use preference extensions > and all the data for each and every user is anyway in my backend storage. > So > as long as I can access the backend I have no issue in changed DSPAM > configuration on the filtering system. The Web UI is not affected by those > changes. However... the deliver part is important. So that has to be in > sync. > > > > now you can give you self the answer :) > > > > sebastian > > > Steve > > > > And with phpcontrolcenter? > > > > > > Thanks for suggestions > > > > > > > > > ---------------------------------------------------------------------------- > -- > > > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > > > 30-Day > > > trial. Simplify your report design, integration and deployment - and > > focus > > > on > > > what you do best, core application coding. Discover what's new with > > > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > > _______________________________________________ > > > Dspam-user mailing list > > > [email protected] > > > https://lists.sourceforge.net/lists/listinfo/dspam-user > > > > > > > > ---------------------------------------------------------------------------- > -- > > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > > 30-Day > > trial. Simplify your report design, integration and deployment - and > focus > > on > > what you do best, core application coding. Discover what's new with > > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > _______________________________________________ > > Dspam-user mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/dspam-user > > -- > Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 - > sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser > > ---------------------------------------------------------------------------- > -- > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Dspam-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspam-user > > !DSPAM:1005,4a7b0ece170621804284693! > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Dspam-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspam-user -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Dspam-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
