Re: [JAWmail-devel] How to install the Spamassassin plugin?

[Rudi B. <ru...@ja...>]

On Friday, June 27, 2003, 2:07:12 PM, L. D. James wrote:

>      When I installed the package (jawmail) I answered the question on username 
> and password.  It created the default jawmail database and links to it okay.

>      I thought this plugin was somewhat automatic and would use the same 
> prompted configuration.

Nope.

>      I had already went into the plugins/mail_spamassassin_sql and modified the 
> conf.php in that area to add a password to 
> the 'mysql://root:password@localhost/spamassassin' line.

Correct.

> It still errored. The error message when I modify this config.php
> file is:

> db_error: message="DB Error: no such table" code=-18 mode=callback 
> callback=pear_error_callback_handler prefix="" info="SELECT * FROM userpref 
> WHERE jaw_uid='lj...@ap...:143' OR jaw_uid='GLOBAL' [nativecode=1146 ** 
> Table 'spamassassin.userpref' doesn't exist]"]

>      Can you tell me the steps you used in adding this plugin?

As the error message says, the SQL table is missing. The table is in
plugins/mail_spamassassin_sql/mysql.sql and you have configured it to
use the database "spamassassin" ...

Oh, and I hope that you do know that this plugin only provides
preferences for SA and no actual filtering... that's up to SA (you'll
have to configure it to use MySQL DB for prefs, of course).

-- 

Rudi Benkovic           ru...@ja...