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 | 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
