You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Philipp Snizek <ps...@seaan.net> on 2005/03/16 12:18:24 UTC

permission problems? SpamAssassin 3.02 with running with sql

Hi

when running spamd with 'spamd -D -q' the SQL statement 'SELECT
preference,value FROM sa_prefs WHERE username=_USERNAME_ OR
username='$GLOBAL' OR username=CONCAT('%',_USERNAME_) ORDER BY
username ASC' and testing from shell with 'echo -e "From:
user\nTo:user\Subject: Test\n\n" | spamc -u '$GLOBAL'' all works fine.


When starting spamd with 'spamd -D -q -u filter' and try to do the
same thing I get this:

failed to load user ($GLOBAL) scores from SQL database: SQL Error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)

logmsg: service unavailable: Error fetching user preferences via SQL


thanks,
Philipp