OK, I'll wait an see what happens I don't get the dbg: bayes: _get_db_version 0
Any idea why message with attachments are getting stuck? I get for example: 2013-02-15 17:34:24 1U6PB2-0000hA-8Y <= [email protected]=(anet-exchange01.averynet.local) [192.168.124.31] P=esmtp S=23827 id=02B328199A03E6439CF3C1D17DA362871FA09BECDB@ANet-Exchange01.AveryNet.local 2013-02-15 17:34:24 1U6PB2-0000hA-8Y == [email protected]=message_checks defer (-1): queued for message checks Does not seem to get out of the queue. If I reboot the server the mail will be marked as infected. I need to configure clamav? Regards, Rod. On 15 February 2013 17:28, Jeremy McSpadden <[email protected]> wrote: > 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]> > 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.sqlinto 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]> 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]> >> 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 > >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
