1 Topic by communque (edited by communque 2024-08-01 00:32:50)

  • communque
  • Member
  • Offline
  • Registered: 2024-04-01
  • Posts: 65

Topic: For the page "SpamAssassin bayes in SQL" is there a postgreSQL version

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version:  iRedMail-1.7.0
- Deployed with downloadable installer
- Linux/BSD distribution name and version: Ubuntu 24.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
====

NoSpamAssassin bayes in SQL is written around MySQL and includes a template.  I built the equivalent in postgreSQL but am so far not having luck with the whole SpamAssassin functionality.

At the moment I'm unable to discern whether the errors are based on mistakes in the 'sa_bayes' database or just mistakes in following instructions in the various settings files.

Wondering if there's an equivalent PG template to help rule out database errors.

----

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: 31,081

Re: For the page "SpamAssassin bayes in SQL" is there a postgreSQL version

You can find the SQL file for PostgreSQL on SpamAssassin website.
for example: http://svn.apache.org/repos/asf/spamass … 4_0_1/sql/