[cobalt-users] Unable to connect to mysql db from Spamassassin

[Swapana Ghosh <swapana_ghosh@xxxxxxxxx>]

Hi 

    In our server Cobalt raq4r Spamassassin 2.55 is
running  smoothly with spamc/spamd with
sendmail/procmail.

     Yesterday we configured it with *mysql*
database..Now  i am seeing that database is unable to
connect. But database is running in a different server
and it has no problem to connect from this server to
db server...

     I have mentioned the database connection scripts
under
/etc/mail/spamassassin/local.cf file as follows:

__________________________________________________
user_scores_dsn                
DBI:mysql:spamassassin:<full database host name>
user_scores_sql_username        myuser
user_scores_sql_password        mypasswd
user_scores_sql_table           userpref
__________________________________________________
I did not mention any port here .....


Here is the log file showing the messages. I have
mentioned here first few lines... 

___________________________________________________
Aug 22 07:56:35 domain spamd[18324]: server started on
port 783 (running version
 2.55)
Aug 22 07:56:35 domain spamd[18324]: logmsg:
connection from localhost [127.0.0.
1] at port 3369
Aug 22 07:56:35 domain spamd[18324]: connection from
localhost [127.0.0.1] at po
rt 3369
Aug 22 07:56:35 domain spamd[18342]: debug: No DSN
defined; skipping sql
Aug 22 07:56:35 domain spamd[18342]: logmsg:
processing message <200308221456.h7
MEuYM18330@xxxxxxxxxxxxxxx> for admin:296.
Aug 22 07:56:35 domain spamd[18342]: processing
message <200308221456.h7MEuYM183
30@xxxxxxxxxxxxxxx> for admin:296.
Aug 22 07:56:36 domain spamd[18342]: debug: bayes: no
dbs present, cannot scan:
/home/sites/home/users/spamall/.spamassassin/bayes_toks
Aug 22 07:56:36 domain spamd[18342]: debug: running
header regexp tests; score s
o far=0
Aug 22 07:56:36 domain spamd[18342]: debug: running
body-text per-line regexp te
sts; score so far=1.5
___________________________________________________

Here is the *spamd* script i am showing here how i
have  started the spamd...
___________________________________________________
# Check that networking is up.
[ ${NETWORKING} = "no" ] && exit 0

# Source spamd configuration.
if [ -f /etc/sysconfig/spamd ] ; then
        . /etc/sysconfig/spamd
else
        OPTIONS="-d -a -x -q -u spamall -D"
___________________________________________________

What i am missing? If anybody wants any further info i
will provide...

Thanks in advance
-Swapna

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com