On Thu 23 Feb 06 20:04, "Jeff Peng" <[EMAIL PROTECTED]> wrote: > Hi, > That seems your Perl installation lack the DBI module,which is needed > for accessing mysql in Perl.You should install the DBI and DBD::Mysql > modules by hand.Certainly,you could go to http://search.cpan.org and > get them.
In FreeBSD, most of the time you install from ports. I do have these modules installed. Actually, I found the problem. The default install of p5-DBI was upgraded to 1.50 in ports, and it didn't work with the 4.1 mysql installation. I had to similarly upgrade mysql, but it works now. - jt > HTH > > -- Joshua Tinnin <[EMAIL PROTECTED]> wrote: > Using FreeBSD 6.0-RELEASE-p4, mysql 4.1.18, > p5-Mail-SpamAssassin-3.1.0_6 > > Using the debug flag, I get: > > [25618] dbg: bayes: unable to connect to database: DBI module not > available: No such file or directory > [25618] dbg: bayes: using username: krinklyfig > > Now, I don't know why it would be using that username, as I > specifically entered in to /usr/local/etc/mail/spamassassin/local.cf > (sa_user* is just the generic example): > > clear_report_template > report_safe 0 > lock_method flock > dns_available yes > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > bayes_sql_dsn DBI:mysql:sa_bayes:localhost > bayes_sql_username sa_user > bayes_sql_password sa_user_password > > auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList > user_awl_dsn DBI:mysql:sa_bayes:localhost > user_awl_sql_username sa_user > user_awl_sql_password sa_user_password > > > Mysql is running, and the error log doesn't show any errors. I can > log into mysql just fine manually with the username and password I > assigned. This worked up until very recently. What could be causing > this problem? > > - jt
