No particular reason except I'm clueless with postsql and clueless with mysql but mysql seemed easier to setup. I may move to postsql now that I have it running as I did manage to set the postsql database up on another test VM.
It did start working after I ran sa-learn --sync then left it over night. I'm not so good with Linux but it was suggested by Jeremy that it would be ok once a few emails went through the system. Sorry for the lack of technical input. Rod. On 19 Feb 2013 18:37, "Mark Chaney" <[email protected]> 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<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<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" <rod.james.avery@googlemail.** >>> com <[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<http://pledgie.com/campaigns/12056>[1] >>> >> >> >> >> Links: >> ------ >> [1] http://pledgie.com/campaigns/**12056<http://pledgie.com/campaigns/12056> >> [2] http://svn.apache.org/repos/**asf/spamassassin/trunk/sql/** >> bayes_mysql.sql<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<http://www.howtoforge.com/the-perfect-spamsnake-ubuntu-jeos-12.04-lts-precise-pangolin-p2> >> >> ______________________________**_________________ >> Keep Baruwa FREE - >> http://pledgie.com/campaigns/**12056<http://pledgie.com/campaigns/12056> >> > > ______________________________**_________________ > Keep Baruwa FREE - > http://pledgie.com/campaigns/**12056<http://pledgie.com/campaigns/12056> >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
