dspam and mysql

Ryan Simpkins plug at ryansimpkins.com
Wed Aug 23 16:34:09 MDT 2006

On Wed, August 23, 2006 14:05, Michael L Torrie wrote:
> On Wed, 2006-08-23 at 13:52 -0600, Michael L Torrie wrote:
>> >
>> >        --enable-preferences-extension
>> >        MySQL supports the preferences extension, which stores user preferences
>> >        in mysql instead of flat files (the built-in method)
>> Good to know. I'll see about activating this.  I definitely want this.
>> Unfortunately, this isn't my main problem.  The problem is the webui
>> isn't seeing any of the historical data in the sql database.  So the web
>> interface cannot be used to get statistics or even retrain the filter.
>> It's looking for the tokens and hashes in the data directory, but dspam
>> is putting these things in SQL.  I am probably missing something obvious
>> here.
> I enabled the extension and the command line utilities work with it
> fine.  However the webui does not refer to SQL at all; still the flat
> file.  /me goes to read the README again, and check the perl source
> code...

Yeah, I think it uses suexec to call the binaries that call the SQL. (/me hears the
jeers.) Have you checked to see if there is any ouput in /var/log/httpd/suexec.log
that might be helpful?

More information about the PLUG mailing list