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