Nevermind on the postgresql part, found that its still preferred to use
mysql instead.
On 2013-02-19 12:37, Mark Chaney wrote:
Rod,
Did you get things working? Any particular reason why you are using
mysql for bayes versus postgres? I guess I just dont see the benefit
of having to run another *sql server. I have only ran mysql with
bayes
in the past, but it looks like its possible with postgres as well.
On 2013-02-15 11:23, Rod Avery 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
[2] 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
[3])
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 [1]
Links:
------
[1] http://pledgie.com/campaigns/12056
[2]
http://svn.apache.org/repos/asf/spamassassin/trunk/sql/bayes_mysql.sql
[3]
http://www.howtoforge.com/the-perfect-spamsnake-ubuntu-jeos-12.04-lts-precise-pangolin-p2
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
