Please revert the changes you did from http://markmail.org/message/jm7axl44rv547izc
-- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955> On May 22, 2013, at 3:06 AM, "Mark Adams" <[email protected]<mailto:[email protected]>> wrote: 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]<mailto:[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]<mailto:[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]<mailto:[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<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955> On May 21, 2013, at 4:49 AM, "Mark Adams" <[email protected]<mailto:[email protected]>> wrote: Can anyone help on this? Thanks! On 15 May 2013 17:08, Mark Adams <[email protected]<mailto:[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
_______________________________________________ http://pledgie.com/campaigns/12056
