Much welcome .. I did not configure clam/clamd/clamav on the install. That is left up to the user. You will not get any Bayes until you have 200 messages in your database. Make sure you are not getting the dbg: bayes: _get_db_version 0
error anymore, if it shows version 3 .. you should be good to go. You'll just have to wait till 200 have been checked. -- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 On Feb 15, 2013, at 11:23 AM, Rod Avery <[email protected]<mailto:[email protected]>> wrote: Hi Jeremy, Thanks for the install script by the way - its what I have used to build the system. How do you populate the database? I have imported the sql code from http://svn.apache.org/repos/asf/spamassassin/trunk/sql/bayes_mysql.sql into a mysql database using: mysql -u sa_user -p sa_bayes < bayes_mysql.sql (Following the guide on how-to forge http://www.howtoforge.com/the-perfect-spamsnake-ubuntu-jeos-12.04-lts-precise-pangolin-p2) Then I ran sa-learn --sync There is data in the database now. What else do you recommend? By the way with regards to your script, I had to amend the MailScanner.conf setting Incoming Work Group = clamav ... was = clam so that Mailscanner --lint did not have an error. Was this the right thing to do? A further issue I am having with the script install is that any mail in or out with an attachment is flagged as 'infected' Cheers, Rod. On 15 February 2013 10:32, Jeremy McSpadden <[email protected]<mailto:[email protected]>> wrote: Looks like you need to populate the SQL database. -- Jeremy McSpadden Flux Labs | Endless Solutions Cell : 850-890-2543 | Fax : 850-254-2955 On Feb 15, 2013, at 3:47 AM, "Rod Avery" <[email protected]<mailto:[email protected]>> wrote: Feb 15 09:34:45.916 [24793] dbg: bayes: _get_db_version: SQL error: ERROR: permission denied for relation bayes_global_vars Feb 15 09:34:45.916 [247 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
