On 20 Sep 2008 at 5:21, J.J. Day wrote: > > 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.
Hi, To me it looks like there is a spurious equals sign in your config: > (DBI:mysql:sa_data:localhost) : Can't connect to local MySQL server > through socket '/var/run/mysql/socket=' (2) If this is not the case then check if the MySQL server is running. Can you connect to it using the credentials you supplied to spamd with the mysql command line client? If server is running, is the socket file present? It may help to look at the MySQL log files as well. Regards Ian -- > > 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/
