You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "Dan Mahoney, System Admin" <da...@prime.gushi.org> on 2006/03/09 01:41:32 UTC
SQL config lines failing to parse
Hey all,
I recently tried to turn on SQL on my SA 3.1.0 installation.
Apparently user prefs are okay, but the lines that are supposed to turn on
the other two modules don't want to load.
I copied the config lines almost verbatim from an existing (working) SA
3.1 server, into local.cf:
Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line, skipping:
user_awl_dsn DBI:mysql:spamassassin:localhost
Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line, skipping:
user_awl_sql_username spamassassin
Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line, skipping:
user_awl_sql_password somepass
Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line, skipping:
user_bayes_dsn DBI:mysql:spamassassin:localhost
Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line, skipping:
user_bayes_sql_username spamassassin
Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line, skipping:
user_bayes_sql_password somepass
Mar 8 19:10:11 s1 spamd[7532]: config: failed to parse line, skipping:
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
--
"Oh, and we just recently got an invoice..."
"Congratulations!"
-JC and DM, regarding Unpredictable Billing, 8/18/2001
--------Dan Mahoney--------
Techie, Sysadmin, WebGeek
Gushi on efnet/undernet IRC
ICQ: 13735144 AIM: LarpGM
Site: http://www.gushi.org
---------------------------
Re: SQL config lines failing to parse
Posted by "Dan Mahoney, System Admin" <da...@prime.gushi.org>.
On Wed, 8 Mar 2006, Matt Kettler wrote:
That fixed half of it.
> Dan Mahoney, System Admin wrote:
>> Hey all,
>>
>> I recently tried to turn on SQL on my SA 3.1.0 installation.
>>
>> Apparently user prefs are okay, but the lines that are supposed to
>> turn on the other two modules don't want to load.
>>
>> I copied the config lines almost verbatim from an existing (working)
>> SA 3.1 server, into local.cf:
>>
>> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
>> skipping: user_awl_dsn DBI:mysql:spamassassin:localhost
>> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
>> skipping: user_awl_sql_username spamassassin
>> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
>> skipping: user_awl_sql_password somepass
>
> do you have the following in your v310.pre:
>
> loadplugin Mail::SpamAssassin::Plugin::AWL
>
> v310.pre Should be installed by default in /etc/mail/spamassassin (or whatever your site_rules dir is) if you installed from source, however many distribution built packages screw up and don't install the .pre files correctly. If it's not there at all, download the file directly from the website:
>
> http://spamassassin.apache.org/full/3.1.x/dist/rules/
>
> grab both v310.pre and init.pre as needed.
>
>
>
>> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
>> skipping: user_bayes_dsn DBI:mysql:spamassassin:localhost
> Erm, did you mean bayes_sql_dsn instead of user_bayes_dsn? That, AFAIK,
> has *never* been a valid option to SA.
DOH! I'm an idiot. Thanks. Only thing that confuses me is why this
isn't warning in my other system.
All good, many MANY thanks.
>> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
>> skipping: user_bayes_sql_username spamassassin
>> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
>> skipping: user_bayes_sql_password somepass
> Ditto bayes_sql_username and bayes_sql_password.
>
>> Mar 8 19:10:11 s1 spamd[7532]: config: failed to parse line,
>> skipping: auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
> Ditto on the loadplugin command.
>
--
"Why are you wearing TWO grounding straps?"
-John Evans, Ezzi Computers August 23, 2001
--------Dan Mahoney--------
Techie, Sysadmin, WebGeek
Gushi on efnet/undernet IRC
ICQ: 13735144 AIM: LarpGM
Site: http://www.gushi.org
---------------------------
Re: SQL config lines failing to parse
Posted by Matt Kettler <mk...@comcast.net>.
Dan Mahoney, System Admin wrote:
> Hey all,
>
> I recently tried to turn on SQL on my SA 3.1.0 installation.
>
> Apparently user prefs are okay, but the lines that are supposed to
> turn on the other two modules don't want to load.
>
> I copied the config lines almost verbatim from an existing (working)
> SA 3.1 server, into local.cf:
>
> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
> skipping: user_awl_dsn DBI:mysql:spamassassin:localhost
> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
> skipping: user_awl_sql_username spamassassin
> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
> skipping: user_awl_sql_password somepass
do you have the following in your v310.pre:
loadplugin Mail::SpamAssassin::Plugin::AWL
v310.pre Should be installed by default in /etc/mail/spamassassin (or whatever your site_rules dir is) if you installed from source, however many distribution built packages screw up and don't install the .pre files correctly. If it's not there at all, download the file directly from the website:
http://spamassassin.apache.org/full/3.1.x/dist/rules/
grab both v310.pre and init.pre as needed.
> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
> skipping: user_bayes_dsn DBI:mysql:spamassassin:localhost
Erm, did you mean bayes_sql_dsn instead of user_bayes_dsn? That, AFAIK,
has *never* been a valid option to SA.
> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
> skipping: user_bayes_sql_username spamassassin
> Mar 8 18:35:11 s1 spamd[4556]: config: failed to parse line,
> skipping: user_bayes_sql_password somepass
Ditto bayes_sql_username and bayes_sql_password.
> Mar 8 19:10:11 s1 spamd[7532]: config: failed to parse line,
> skipping: auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
Ditto on the loadplugin command.