[EMAIL PROTECTED] wrote: > Hi, > > Since upgrading our mail relay to solaris 10 and all the latest gratest > spamassassin / mimedefang / sendmail versions, i'm faced with curious > bayes db corruption happening after approx. 1 day: > > i've got these parameters set: in sa-mimedefang.cf: > > use_bayes 1 > bayes_auto_learn 1 > bayes_path /var/spool/MIMEDefang-bayes/bayes > bayes_file_mode 0666 > You want 0777, not 0666 here. This can be used to create directories and SA needs the "x" bit on those. Also, this isn't really a mode specifier, it's a mask, so the database files themselves will still be created 666.
(Check the docs, note the default is 0700 not 0600.) > > This is the contents of the bayes directory: > > -bash-3.00# ls -la /var/spool/MIMEDefang-bayes/ > total 37588 > drwxr-xr-x 2 defang defang 512 Oct 10 09:38 . > drwxr-xr-x 15 root bin 512 Sep 19 07:55 .. > -rw-rw-rw- 1 defang defang 114608 Oct 10 04:56 bayes_journal > -rw-rw-rw- 1 defang defang 2613248 Oct 10 05:08 bayes_seen > -rw-rw-rw- 1 defang defang 20946944 Oct 10 09:38 bayes_toks > Your problem appears to be that the MIMEDefang-bayes directory is 755 permisions, not 777. > > Does anyone use an sql backend instead of the berkely flat file db ? Is it > faster / slower ? > The SQL backend is significantly faster. http://wiki.apache.org/spamassassin/BayesBenchmarkResults Note that SDBM is also faster than berkely, and I use that myself. My only problem with it was some minor issues with the dump/restore process that forced me to rename a file to make it work properly.