On 09/05/2015 07:33 PM, Hoggins! wrote:
Hi list !
Just after un upgrade, I happen to have an issue with Spamassassin that
would refuse to start, giving a segmentation fault.
My belief is that it is caused by a broken support of my bayes_sql
configuration, because when I start it with "spamd -D", it gives :
Sep 5 19:13:00.382 [18756] dbg: plugin:
Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x34d3918) implements
'finish_parsing_end', priority 0
Sep 5 19:13:00.383 [18756] dbg: plugin:
Mail::SpamAssassin::Plugin::FreeMail=HASH(0x29a5e10) implements
'finish_parsing_end', priority 0
Sep 5 19:13:00.383 [18756] dbg: replacetags: replacing tags
Sep 5 19:13:00.398 [18756] dbg: replacetags: done replacing tags
Sep 5 19:13:00.398 [18756] dbg: FreeMail: loaded freemail_domains
entries: 2532 normal, 31 wildcard
Sep 5 19:13:00.401 [18756] dbg: plugin:
Mail::SpamAssassin::Plugin::Bayes=HASH(0x35bac68) implements
'learner_new', priority 0
Sep 5 19:13:00.401 [18756] dbg: bayes: learner_new
self=Mail::SpamAssassin::Plugin::Bayes=HASH(0x35bac68),
bayes_store_module=Mail::SpamAssassin::BayesStore::SQL
Sep 5 19:13:00.422 [18756] dbg: bayes: using username: sa-milt
Sep 5 19:13:00.423 [18756] dbg: bayes: learner_new: got
store=Mail::SpamAssassin::BayesStore::SQL=HASH(0x3f24b48)
Sep 5 19:13:00.423 [18756] dbg: plugin:
Mail::SpamAssassin::Plugin::Bayes=HASH(0x35bac68) implements
'learner_is_scan_available', priority 0
Erreur de segmentation (core dumped)
My config in local.cf is as follows :
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:mysql:spamassassin:localhost
bayes_sql_username spamassassin
bayes_sql_password XXXXXX
bayes_sql_override_username sa-milt
user_scores_dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username spamassassin
user_scores_sql_password XXXXXX
user_scores_sql_custom_query SELECT preference, value FROM
_TABLE_ WHERE username = _USERNAME_ OR username = '$GLOBAL' OR
username = CONCAT('%',_DOMAIN_) ORDER BY username ASC
Does it ring a bell to anyone ?
no bells - have you tried:
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL