Article ID: 122260, created on Jul 6, 2014, last review on Jul 6, 2014

  • Applies to:
  • H-Sphere 3.4

Symptoms

Filed to add AntiSpam for all mailboxes

The following error is present in the H-sphere log file.

    2014-07-06 14:37:39,002 [TP-Processor40] INFO psoft.hsphere.CP - Error initDone
    java.lang.Exception: Can't execute statement: DELETE FROM userpref WHERE username='test@test.com' AND preference='required_hits';INSERT INTO userpref(username,preference,value) VALUES('test@test.com','required_hits', '7');. Error: ERROR 1045 (28000): Access denied for user 'spamassassin'@'localhost' (using password: YES)

Cause

Wrong password in the /hsphere/local/config/mail/spamassassin/local.cf file.

Resolution

Replace password in sections "user_scores_sql_password" and "user_awl_sql_password" with valid MySQL password.

Valid password sould be stored in tne /hsphere/local/config/mail/spamassassin/spamassassin_mysql.sql file.

f90e90e234d2835301363089f6b828e5 6311ae17c1ee52b36e68aaf4ad066387 f213b9fa8759d57bee5d547445806fe7 2e39a5e5b1423cc126cf735bac076008

Email subscription for changes to this article
Save as PDF