Here is a reply I got earlier on similar question on MySql, thanks to Grayhat and Jeroen,
> I am not exactly sure what the mysql backend is used for to keep white/red lists, penalty box data and in general a bunch of infos using a common mysql backend allows you to have a number of ASSP boxes filtering in a "uniform" way (since all of them will have the same data); the bayesian database, on the other hand, isn't kept inside the DB, in this latter case you'll have to define a "master" ASSP on which you'll run the rebuildspamdb, and then you'll need to copy the generated files to the other ASSPs so that they'll all be in "sync;" not doing so you will face some issues, like addresses being whitelisted on one ASSP and NOT whitelisted on another one, delaying not properly working due to the fact that a given message was delayed by an ASSP and when a second one sees the *same* message, it will delay it again.. and some more; so, when using multiple ASSPs, it's better to set them up to be in-sync and using a common MySQL backend helps a lot HTH Scott Haneda <[email protected]> wrote: > I am looking for some info on MySql support in ASSP 1.x >branch? I > have looked in the wiki and can not find any info. I >searched the > mail list, and while support is mentioned, I am not sure >what it is for. > > I assume this is to lookup users for user not known >features? I know > I can use plain text files for this, or LDAP, but how if >I wanted to, > would I use mysql? > > If I am using postfix as a pretty standard MTA, is there >a way to tell > ASSP directly to just talk to postfix for local users, >or must I use > LDAP or text files? > > If anyone can point me to docs, or just tell me >specifically what the > DBI and MySql stuff is all about, I would appreciate it, >then I can > decide which is best for my setup. > > Thanks. > -- > Scott > > * If you contact me off list replace talklists@ with >scott@ * > > > > > > > ------------------------------------------------------------------------------ > > Open Source Business Conference (OSBC), March 24-25, >2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open >Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open >source participation > -Receive a $600 discount off the registration fee with >the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > _______________________________________________ > Assp-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/assp-user ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Assp-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-user
