[BlueOnyx:19462] Re: Email Traffic Monitor 5209R

[Michael Stauber]

Hi Colin,

> Swatch throws this error:
> 
> Can't connect to data source '' because I can't work out what 
> driver to use (it doesn't seem to contain a 'dbi:driver:'
> prefix and the DBI_DRIVER env var is not set) at
> /usr/sausalito/swatch/bin/am_emailtraffic.pl line 70

Um ... that's the standard perl-DBI driver that lots of other software
on BlueOnyx uses as well. It's pre-installed as one of the GUI
requirements, too.

So check with "yum install perl-DBI" and it's probably already there.

The MySQL connection details are the same as for Spamassassin, so it
pulls them out of this config: /etc/mail/spamassassin/sql.cf

Thinking about it: This might be the problem. So please do this:

Please go to "Network Services" / "AV-SPAM" and check the "SpamAssassin"
tab. At the bottom of it make sure the checkboxes for "Use AWL" and "Use
Bayes" are ticked. Then check the "GeoIP" tab on the same GUI page. At a
total minimum you should have "Protect SMTP-Auth" ticked. Lastly and
still on the same GUI page go to the "MySQL" tab. Confirm that "Use
MySQL" is ticked. Then: Save the changes.

That should do it.

-- 
With best regards

Michael Stauber