1 Topic by jsmith (edited by jsmith 2015-04-17 01:21:30)

  • jsmith
  • Member
  • Offline
  • Registered: 2015-04-11
  • Posts: 32

Topic: Cannot "store.spamassassin.bayes.in.sql"

======== Required information ====
- iRedMail version: 0.90.
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: Debian 7
- Related log if you're reporting an issue:
====

Good afternoon,

This is my first post, so thanks very much for this incredible project. I have begun migrating away from Exchange and it has been pleasantly painless.

I am trying to follow the instructions here - http://www.iredmail.org/docs/store.spam … n.sql.html

From the screenshots you can see the file I downloaded and the version of SpamAssassin used (I only began using iRedMail at the weekend so everything should be latest versions per the installer). Have I missed something or is there an issue with this? I apologise in advance, I have only a little experience with Linux and almost none with SQL.

Post's attachments

bayes.png
bayes.png 20.86 kb, file has never been downloaded. 

bayes2.png
bayes2.png 4.22 kb, 1 downloads since 2015-04-16 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot "store.spamassassin.bayes.in.sql"

Did you try the one under http://svn.apache.org/repos/asf/spamass … _3_2/sql/?

3 Reply by jsmith

  • jsmith
  • Member
  • Offline
  • Registered: 2015-04-11
  • Posts: 32

Re: Cannot "store.spamassassin.bayes.in.sql"

ZhangHuangbin wrote:

Did you try the one under http://svn.apache.org/repos/asf/spamass … _3_2/sql/?


Hi ZhangHuanbin,

Thank you for pointing that out, I am sorry I had missed that. I have tried it with the one you suggested but I am still getting an error. Should I be concerned that when I download the file, it says "scheme missing" ?

Post's attachments

bayes3.png
bayes3.png 13.97 kb, file has never been downloaded. 

bayes4.png
bayes4.png 15.54 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot "store.spamassassin.bayes.in.sql"

I think you can replace all 'TYPE=MyISAM' by 'ENGINE=MyISAM' and try again.
New MySQL server doesn't support 'TYPE=' anymore.

5 Reply by jsmith

  • jsmith
  • Member
  • Offline
  • Registered: 2015-04-11
  • Posts: 32

Re: Cannot "store.spamassassin.bayes.in.sql"

Thank you for this, I have edited the file as you suggested and it has now created the database.

I am now stuck on these steps:

# /etc/init.d/amavisd stop
# amavisd -c /etc/amavisd/amavisd.conf debug 2>&1 | grep -i 'bayes'

In the first command it does stop the service with ../amavis (no "d" at the end).

I do not have /etc/amavisd, but I do have /etc/amavis. Within this ls shows I have conf.d, en_US and README.l10n so I do not know how to proceed. Could you advise? Thank you.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot "store.spamassassin.bayes.in.sql"

Check this document to understand which file you should use on different Linux/BSD:
http://www.iredmail.org/docs/file.locat … ml#amavisd