Hi,
I nstalled Sendmail 8.14.2, MIMEDefang-2.63, SpamAssassin 3.2.4, and MySQL
5.0.51a on FreeBSD 6.3. Normal messages (including sample-spam.txt and
sample-nospam.txt) are processed properly and everything appears to work
properly until I try to implement per-user settings with MySQL. When I test
MySQL using spamd I get the following message:
Tue Sep 2 20:47:57 2008 [41521] dbg: auto-whitelist: sql-based unable to
connect to database (DBI:mysql:sa_data:localhost) : Can't connect to local
MySQL server through socket '/var/run/mysql/socket=' (2)
Does anyone recogize this problem and have a solution? (All of the remedies
suggested by a Google search for the error message have not helped.)
J.J.
Possibly relevant additional information:
1- MIMEDefang was stopped before running spamd, MySQL is running
The MySQL configuration from /etc/my.cnf:
<>
# The following options will be passed to all MySQL clients
[client]
port = 3306
socket = /var/run/mysql/socket
# The MySQL server
[mysqld]
port = 3306
socket = /var/run/mysql/socket
pid-file =/var/run/mysql/mysql-server.pid
skip-networking
<>
A "ps" shows MySQL runnng. An "ls" shows the socket established.
srwxrwxrwx 1 mysql mysql 0 Jun 1 08:42 socket=
2 - from /usr/local/etc/mail/spamassassin/local.cf:
# auto-whitelisting
#
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn DBI:mysql:sa_data:localhost
user_awl_sql_username spamassassin
user_awl_sql_password spam_admin
user_awl_sql_table awl
user scores and Bayesean processing are also specified.
3 - A manual execution of MySQL specifying the identical instance, username and
PW connects properly and allows all of (and only) the functionality specified
by the grants.
_________________________________________________________________
See how Windows connects the people, information, and fun that are part of your
life.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
