Hi all,
Got a slightly interesting problem with our (now production) setup of
MailScanner/Baruwa.
For some reason MailScanner is not connecting to the baruwa database for
configuration, and I have no idea why. I've grepped the logs, and the
only reference to SQL is references to "BaruwaSQL" (which works great!)
and not "SQLConfig", which I'd expect.
In our MS config file we have the following:
DB DSN = DBI:Pg:database=baruwa;host=127.0.0.1;port=5432
DB Username = baruwa
DB Password = ********
Always Looked Up Last = &BaruwaLog
Notify Senders = no
SQL Serial Number = SELECT MAX(value) AS confserialnumber FROM
configurations WHERE internal='confserialnumber'
SQL Quick Peek = SELECT value FROM quickpeek WHERE external = ? AND
(hostname = ? OR hostname='default') LIMIT 1
SQL Config = SELECT internal, value, hostname FROM quickpeek WHERE
hostname=? OR hostname='default'
SQL Ruleset = SELECT row_number, ruleset AS rule FROM msrulesets WHERE
name=?
SQL SpamAssassin Config =
SQL Debug = yes
As I understand it this should be enough to enable SQL config, right?
However, it doesn't seem to work. There's no SQL errors in the log,
nothing.
Anyone able to shed some light on this?
Regards,
Chris
_______________________________________________
http://pledgie.com/campaigns/12056
