It work's just fine before the changes suggested by Jeremy, apart from the AV scanning of course!
On 22 May 2013 05:07, yongli.dang <[email protected]> wrote: > maybe baruwa have not populated the database,check db account and password > , and try to to repopulate necceccery dbs. > > 发自我的 iPhone > > 在 2013-5-21，21:19，Mark Adams <[email protected]> 写道： > > 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 > > > _______________________________________________ > http://pledgie.com/campaigns/12056 >
_______________________________________________ http://pledgie.com/campaigns/12056
