Hi,
although I upgraded spamassassin to version 3.2.3 I am still experiencing that spamd is invoked 3 times.

Here is my mysql-log:

070817 14:48:57      90 Connect     [EMAIL PROTECTED] on spamassassin
                     90 Query       set autocommit=1
90 Query SELECT preference, value FROM userpref WHERE username = '[EMAIL PROTECTED]' OR username = '$GLOBAL' OR username = CONCAT('%','xxxxxx.net') ORDER BY username ASC
                     90 Quit
91 Connect [EMAIL PROTECTED] on spamassassin
                     91 Query       set autocommit=1
91 Query SELECT value FROM bayes_global_vars WHERE variable = 'VERSION' 91 Query SELECT id FROM bayes_vars WHERE username = '[EMAIL PROTECTED]' 91 Query SELECT max(runtime) from bayes_expire WHERE id = '21' 91 Query SELECT spam_count, ham_count, token_count, last_expire, last_atime_delta, last_expire_reduce, oldest_token_age,
                    newest_token_age
               FROM bayes_vars
              WHERE id = '21'
                     91 Quit
92 Connect [EMAIL PROTECTED] on spamassassin
                     92 Query       set autocommit=1
92 Query SELECT value FROM bayes_global_vars WHERE variable = 'VERSION' 92 Query SELECT id FROM bayes_vars WHERE username = 'nobody' 92 Query SELECT max(runtime) from bayes_expire WHERE id = '25' 92 Query SELECT spam_count, ham_count, token_count, last_expire, last_atime_delta, last_expire_reduce, oldest_token_age,
                    newest_token_age
               FROM bayes_vars
              WHERE id = '25'
                     92 Quit
93 Connect [EMAIL PROTECTED] on spamassassin
                     93 Query       set autocommit=1
93 Query SELECT id FROM bayes_vars WHERE username = 'nobody' 93 Query SELECT max(runtime) from bayes_expire WHERE id = '25' 93 Query SELECT spam_count, ham_count, token_count, last_expire, last_atime_delta, last_expire_reduce, oldest_token_age,
                    newest_token_age
               FROM bayes_vars
              WHERE id = '25'
                     93 Quit

When I try to call spamd with -Q I get an error:


[94402] info: spamd: connection from xxxxx.net [xxx.xxx.xxx.xxx] at port 61404
[94402] info: spamd: handle_user unable to find user: [EMAIL PROTECTED]
[94402] warn: spamd: service unavailable: Error fetching user preferences via SQL at /usr/local/bin/spamd line 1990, <GEN10> line 2.
[94402] dbg: config: copying current conf from backup
[94402] dbg: prefork: sysread(8) not ready, wait max 300 secs


Can anybody please help ? I am trying for days now to get spamassassin to do per user-learning...

THANKS

Reply via email to