Re: SpamAssassin, One Baye for a lot of SpamAssassin server
Am 22.01.2010 21:40, schrieb Alex: > Hi, > >> if you do not use MySQL for bayes, migrate. > > How do you determine whether the administrative overhead (downtime for > maintenance, etc) is necessary or a simple periodic rsync would do the > trick? > > How long can the bayes databases be out of sync before it becomes a > problem? I suppose that question can't really be answered other than > "the sooner, the better", but is the info really changing that > frequently than syncing more than, say, every hour would be a problem? > > Mariusz Kruk wrote: >> bayes_file_mode 0666 > > That's a really bad idea. At least put your users in a group so it's > not world-writable, but I would also think there's some suid program > you could use in place (although they have problems of their own)? > > Thanks, > Alex > h "mysqlstudent" asks if its necessary to move to MySQL ;-) I personally prefer using a database instead of mounting filesystems via NFS or rsyncing files. for me it is less effort
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
Am 22.01.2010 18:31, schrieb d.h...@yournetplus.com: > Quoting LuKreme : > >> On 22-Jan-2010, at 02:07, Ralph Bornefeld-Ettmann wrote: >>> bayes_store_module Mail::SpamAssassin::BayesStore::SQL >>> bayes_sql_dsn DBI:mysql:mailscanner::3306 >>> bayes_sql_username >>> bayes_sql_password >>> bayes_sql_override_username >> >> >> Where do you specify the name of the database to use? > > In the above, 'mailscanner' would be the database. > > oops, sorry, forgot to replace that ...
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
Hi, > if you do not use MySQL for bayes, migrate. How do you determine whether the administrative overhead (downtime for maintenance, etc) is necessary or a simple periodic rsync would do the trick? How long can the bayes databases be out of sync before it becomes a problem? I suppose that question can't really be answered other than "the sooner, the better", but is the info really changing that frequently than syncing more than, say, every hour would be a problem? Mariusz Kruk wrote: > bayes_file_mode 0666 That's a really bad idea. At least put your users in a group so it's not world-writable, but I would also think there's some suid program you could use in place (although they have problems of their own)? Thanks, Alex
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
LuKreme wrote on Fri, 22 Jan 2010 09:30:28 -0700: > Where do you specify the name of the database to use? bayes_sql_dsn why not check documentation? Kai -- Get your web at Conactive Internet Services: http://www.conactive.com
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
Quoting LuKreme : On 22-Jan-2010, at 02:07, Ralph Bornefeld-Ettmann wrote: bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:mailscanner::3306 bayes_sql_username bayes_sql_password bayes_sql_override_username Where do you specify the name of the database to use? In the above, 'mailscanner' would be the database.
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
On 22-Jan-2010, at 02:07, Ralph Bornefeld-Ettmann wrote: > bayes_store_module Mail::SpamAssassin::BayesStore::SQL > bayes_sql_dsn DBI:mysql:mailscanner::3306 > bayes_sql_username > bayes_sql_password > bayes_sql_override_username Where do you specify the name of the database to use? -- "Whose motorcycle is this?" "It's chopper, baby." "Whose chopper is this?" "It's Zed's." "Who's Zed?" "Zed' dead, baby. Zed's dead."
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
On Fri, 22 Jan 2010, Mariusz Kruk wrote: On Fri, 2010-01-22 at 19:47 +1100, Jean-Yves Avenard wrote: In a previous post, i have request a information, can i use one central bayes database for a lot of SpamAssassin Server. I have received a answer: Yes But what is the process ? I use a common bayes database for all users ; The original question was not about central database for all users on one host (which is a trivial solution), but for a central database for multiple servers. I suppose you could share common directory between servers via NFS and use the file database but I'm pretty sure you'd quickly run into problems with file locking and such stuff so you'd probablw want to go for MySQL solution. If you're not doing autolearn you can have a central training database that is replicated out to the SA servers after a manual training run. But if you're going to use autolearn and multiple servers, the only way to stay sane is with a central SQL database. -- John Hardin KA7OHZhttp://www.impsec.org/~jhardin/ jhar...@impsec.orgFALaholic #11174 pgpk -a jhar...@impsec.org key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 --- Rights can only ever be individual, which means that you cannot gain a right by joining a mob, no matter how shiny the issued badges are, or how many of your neighbors are part of it. -- Marko --- Tomorrow: John Moses Browning's 155th Birthday
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
On 22.1.2010 10:53, Mariusz Kruk wrote: > On Fri, 2010-01-22 at 19:47 +1100, Jean-Yves Avenard wrote: >>> In a previous post, i have request a information, can i use one >>> central bayes database >>> for a lot of SpamAssassin Server. >>> >>> I have received a answer: Yes >>> >>> But what is the process ? >> >> I use a common bayes database for all users ; >> I added : >> use_bayes 1 >> bayes_path /usr/local/etc/mail/bayes/bayes >> bayes_file_mode 0666 >> >> to local.cf > > The original question was not about central database for all users on > one host (which is a trivial solution), but for a central database for > multiple servers. > I suppose you could share common directory between servers via NFS and > use the file database but I'm pretty sure you'd quickly run into > problems with file locking and such stuff so you'd probablw want to go > for MySQL solution. > Check out this article for example: > http://www.starbridge.org/spip/spip.php?article15&lang=fr > (It uses debian as the base instalation but I don't think it's that > different in other systems) > I use a MySQL solution shared with Debian Lenny and Red Hat 7.3 hosts. I share the /etc/spamassassin via NFS, and the local.cf there defines the SQL bayes parameters. Works fine, and no special host specific settings are needed. -- http://www.iki.fi/jarif/ You attempt things that you do not even plan because of your extreme stupidity. signature.asc Description: OpenPGP digital signature
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
Am 22.01.2010 09:41, schrieb Stephane MAGAND: > Hello, > > In a previous post, i have request a information, can i use one > central bayes database > for a lot of SpamAssassin Server. > > I have received a answer: Yes > > But what is the process ? > > for > one spamassassin, we use obligatory a MySQL Server ? > If yes, the performence are not decreased ? > > Thanks for your help > Stephane > if you do not use MySQL for bayes, migrate. in local.cf : bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:mailscanner::3306 bayes_sql_username bayes_sql_password bayes_sql_override_username the performance question depends on so many facts and figures it is hard to answer (network, hardware, traffic) but using one central bayes db gives you the security that each SA server adds the same score for bayes (there is no warranty it will be the same with dedicated local databases) but bear in mind that if anyone is able to poison your central db it is poisoned for all SA servers. ;-) hth Ralph
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
On Fri, 2010-01-22 at 19:47 +1100, Jean-Yves Avenard wrote: > > In a previous post, i have request a information, can i use one > > central bayes database > > for a lot of SpamAssassin Server. > > > > I have received a answer: Yes > > > > But what is the process ? > > I use a common bayes database for all users ; > I added : > use_bayes 1 > bayes_path /usr/local/etc/mail/bayes/bayes > bayes_file_mode 0666 > > to local.cf The original question was not about central database for all users on one host (which is a trivial solution), but for a central database for multiple servers. I suppose you could share common directory between servers via NFS and use the file database but I'm pretty sure you'd quickly run into problems with file locking and such stuff so you'd probablw want to go for MySQL solution. Check out this article for example: http://www.starbridge.org/spip/spip.php?article15&lang=fr (It uses debian as the base instalation but I don't think it's that different in other systems) -- \/ | k...@epsilon.eu.org | | http://epsilon.eu.org/ | /\
Re: SpamAssassin, One Baye for a lot of SpamAssassin server
Hi 2010/1/22 Stephane MAGAND : > Hello, > > In a previous post, i have request a information, can i use one > central bayes database > for a lot of SpamAssassin Server. > > I have received a answer: Yes > > But what is the process ? I use a common bayes database for all users ; I added : use_bayes 1 bayes_path /usr/local/etc/mail/bayes/bayes bayes_file_mode 0666 to local.cf make sure the username spamd runs under has write access to the folder. That's it. Same thing with the auto whitelist