Hi Jeremy, Thanks for your response. I've tried your suggestion however now
I am getting the following error when trying to restart:
Restarting mail spam/virus scanner: MailScannerDBD::Pg::st execute failed:
ERROR: function dbvalue(character varying) does not exist
LINE 1: SELECT dbvalue(value) AS value FROM quickpeek WHERE external...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts. [for Statement "SELECT dbvalue(value) AS
value FROM quickpeek WHERE external = ? AND (hostname = ? OR
hostname='default') LIMIT 1" with ParamValues:
1='mailscannerversionnumber', 2='mail-gw-app-2'] at
/usr/share/MailScanner//MailScanner/ConfigSQL.pm line 134.
DBD::Pg::st execute failed: ERROR: function dbvalue(character varying)
does not exist
LINE 1: SELECT dbvalue(value) AS value FROM quickpeek WHERE external...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts. [for Statement "SELECT dbvalue(value) AS
value FROM quickpeek WHERE external = ? AND (hostname = ? OR
hostname='default') LIMIT 1" with ParamValues:
1='mailscannerversionnumber', 2='mail-gw-app-2'] at
/usr/share/MailScanner//MailScanner/ConfigSQL.pm line 134.
failed!
Regards,
Mark
On 21 May 2013 14:11, Jeremy McSpadden <[email protected]> wrote:
> You need to change your MailScanner.conf to use this
>
> SQL Quick Peek = SELECT dbvalue(value) AS value FROM quickpeek WHERE
> external = ? AND (hostname = ? OR hostname='default') LIMIT 1
> SQL Config = SELECT internal, dbvalue(value) AS value, hostname FROM
> quickpeek WHERE hostname=? OR hostname='default'
>
> --
> Jeremy McSpadden
> Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions
> Office : 850-250-5590x101 <850-250-5590;101> | Cell : 850-890-2543 | Fax
> : 850-254-2955
>
> On May 21, 2013, at 4:49 AM, "Mark Adams" <[email protected]> wrote:
>
> Can anyone help on this? Thanks!
>
>
> On 15 May 2013 17:08, Mark Adams <[email protected]> wrote:
>
>> Hi,
>>
>> After I selected clamav-daemon in the web interface, my AV scanning
>> stopped working, exactly as detailed in the thread here
>>
>> http://markmail.org/message/jm7axl44rv547izc
>>
>> I've made the changes (added {} and added new section in
>> SweepViruses.pm) and now I don't get errors and the logs show it is
>> scanning, but don't detect any viruses as tested with EICAR.
>>
>> Is this working for anyone? Any suggestions?
>>
>> Cheers,
>> Mark
>>
>> _______________________________________________
> http://pledgie.com/campaigns/12056
>
>
> _______________________________________________
> http://pledgie.com/campaigns/12056
>
_______________________________________________
http://pledgie.com/campaigns/12056
