Le 05/09/2015 20:15, Axb a écrit :
> 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
Thanks.
Now I have. No luck :(
Sep 6 01:08:20.663 [19945] dbg: bayes: learner_new
self=Mail::SpamAssassin::Plugin::Bayes=HASH(0x3d861a0),
bayes_store_module=Mail::SpamAssassin::BayesStore::MySQL
Sep 6 01:08:20.713 [19945] dbg: bayes: using username: sa-milt
Sep 6 01:08:20.713 [19945] dbg: bayes: learner_new: got
store=Mail::SpamAssassin::BayesStore::MySQL=HASH(0x334aeb8)
Sep 6 01:08:20.713 [19945] dbg: plugin:
Mail::SpamAssassin::Plugin::Bayes=HASH(0x3d861a0) implements
'learner_is_scan_available', priority 0
Erreur de segmentation (core dumped)
I'm trying to "debug" with the -D option. Is there another level of info
I could display ?
One thing is sure : if I comment out the bayes_* and user_scores_sql_*
lines, everything is fine again, so my problem seems to be related to
*SQL support.
Cheers !
signature.asc
Description: OpenPGP digital signature
