SpamAssasin database connection error

**Dylan** · May 8th 2017

Hi,

I installed SpamAssasin on my system, but I have the some problem, what was in this topic:
SpamAssassin

OS: Debian Jessie
i-MSCP v ersion: 1.4.4
Plugin version: 1.1.1

When I run command: service spamassassin status command, result is:

Code

spamassassin.service - Perl-based spam filter using text analysis
Loaded: loaded (/lib/systemd/system/spamassassin.service; enabled)
Active: active (running) since cs 2017-05-04 20:15:33 CEST; 3 days ago
Main PID: 10152 (/usr/sbin/spamd)
CGroup: /system.slice/spamassassin.service
├─10152 /usr/sbin/spamd -d --pidfile=/var/run/spamassassin.pid --max-children=5 --sql-config --nouser-config --username=debian-spamd --port=783 --helper-home-dir=/var/lib/s...
├─25923 spamd child
└─32130 spamd child
máj 08 09:55:40 admin spamd[25923]: spamd: service unavailable: Error fetching user preferences via SQL
máj 08 09:55:40 admin spamd[10152]: prefork: child states: II
máj 08 09:55:51 admin spamd[25923]: spamd: connection from admin.__.hu.local [127.0.0.1]:51452 to port 783, fd 5
máj 08 09:55:51 admin spamd[25923]: config: failed to load user (***@gmail.com) scores from SQL database: config: SQL error: Access denied for user 'sa_user'@'local...ssword: YES)
máj 08 09:55:51 admin spamd[25923]: spamd: service unavailable: Error fetching user preferences via SQL
máj 08 09:55:51 admin spamd[10152]: prefork: child states: II
máj 08 09:55:52 admin spamd[25923]: spamd: connection from admin.__.hu.local [127.0.0.1]:51454 to port 783, fd 5
máj 08 09:55:52 admin spamd[25923]: config: failed to load user (***@hotmail.co.uk) scores from SQL database: config: SQL error: Access denied for user 'sa_us...ssword: YES)
máj 08 09:55:52 admin spamd[25923]: spamd: service unavailable: Error fetching user preferences via SQL
máj 08 09:55:52 admin spamd[10152]: prefork: child states: II
Hint: Some lines were ellipsized, use -l to show in full.

Display More

Tried to deactivate / reactivate plugin, but not helped.

**kess** · May 8th 2017

Edit the file : /etc/spamassassin/00_imscp.cf

There you'll find the password used by the user sa_user to connect to your MySQL.

Set the MySQL password for sa_user in this file in order to reflect the password setup for the sa_user in your MySQL

**Dylan** · May 8th 2017

Thank you, but the base problem is, there are no sa_user in database...
I can create this by manualy, but what privilages must I give to this user?

**Dylan** · May 8th 2017

Problem solved.

Solution:
- Deactivate plugin
- Remove plugin
- Install plugin

After this step, there are an error message in i-MSCP panel:

Code

Plugin :: SpamAssassin :: _ setSpamassassinUserprefs: Error while executing statement: Duplicate entry $ GLOBAL- use_pyzor -1 ' for key ' user_pref

Now I saw around in DB, and found imscp_spamassasin database a userpref table.
Truncate it, and after it, I can install plugin, and it's working!

BUT!

After this install, the userpref table still empty, so I must deactivate, and remove full plugin, and reupload, reinstall it.
Now, table contain some rows, and work as expected.

**Nuxwin** · May 9th 2017

@Dylan

When you deinstalled the plugin, the table was not removed?

**Dylan** · May 9th 2017

@Nuxwin

No, still exists after full remove.

**Nuxwin** · Jul 3rd 2017

Fixed in latest v2.0.0
Thread closed.

SpamAssasin database connection error

Share

Daily visitors