[SAtalk] Problem in connecting to mysql database from Spamassassin

[swapna ghosh]

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
[EMAIL PROTECTED]> for admin:296.
Aug 22 07:56:35 domain spamd[18342]: processing message <200308221456.h7MEuYM183
[EMAIL PROTECTED]> 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