Chris Malton <chrism@...> writes: 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
HI, I had same issue and I simply removed the port from the DSN line as below : DB DSN = DBI:Pg:database=baruwa;host=127.0.0.1 Cheers Cedric _______________________________________________ http://pledgie.com/campaigns/12056
