SPAM FILTER PLUGIN - Hmailserver 5

[fabiosergio]

Hi!!!

I have:
 RC 0.4b
 Hmailserver 5.3.2-B1769 with Mysql db
 Mysql 5.1.47
 Windows S. 2008 64bits

I have config. the Spamfilter plugin and always give me a error, but wen I clicked save for the 2 time they save..

In hmail Admin I see the rule created but nothing is set in the actions field (move to IMAP folder).

I could verify that doesn't create in the hmailserver db the values in hm_rule_actions table.

The error is because in the setup of the hmailserver the values of the table is set to "Not null".

i have changed the query this:
INSERT INTO hm_rule_actions (actionruleid,actiontype,actionimapfolder,actionsortorder,actionrouteid,actionsubject,actionfromname,actionfromaddress,actionto,actionbody,actionfilename,actionscriptfunction,actionheader,actionvalue)  VALUES('7','4','Spam','0','0','','','','','','','','','')


I could change the Not null value in db but I don't like to modify values in hmail db.


Best regards!!

[rosali]

This bug has been fixed. New version will be released soon.

[fabiosergio]

Hi, again!!

I could see that Spamfilter has been fixed! And works great!

Just lo let you now, If I put in my config file:
// Rule Name
$rcmail_config['spamfilter_rule_name'] = 'X-hMailServer-Reason-Score';
// Spam header field
$rcmail_config['spamfilter_header_field'] = 'X-hMailServer-Reason-Score';

the plugin doesn't work! the rules was created but there's no rules_action and rule criteria.
But if I change the rule name for other one they work!
All I have to say is if you put this 2 fields in the config file doesn't! But I think that not a problem!

Keep the good work!

Best regards!!

[LordNik]

This bug has been fixed. New version will be released soon.

Really, now it's fixed?

Can i say where i can download the new version?

I have the same bug.

Please help me.

Thanks a lot,
Niccolò Patriarchi

P.S. The is another similar plugin which move the spam e-mail to the spam folder?

[rosali]

Could you please post plugin version and lines 24 - 33 of your hmail_spamfilter.php?

Also please post the structure of hmail_rule_actions table (hmailserver database).

Mine is:

  `actionid` int(11) NOT NULL auto_increment,
  `actionruleid` int(11) NOT NULL,
  `actiontype` tinyint(4) NOT NULL,
  `actionimapfolder` varchar(255) NOT NULL,
  `actionsubject` varchar(255) NOT NULL,
  `actionfromname` varchar(255) NOT NULL,
  `actionfromaddress` varchar(255) NOT NULL,
  `actionto` varchar(255) NOT NULL,
  `actionbody` text NOT NULL,
  `actionfilename` varchar(255) NOT NULL,
  `actionsortorder` int(11) NOT NULL,
  `actionscriptfunction` varchar(255) NOT NULL,
  `actionheader` varchar(80) NOT NULL,
  `actionvalue` varchar(255) NOT NULL,
  `actionrouteid` int(11) NOT NULL,


Do you use the change posted by fabiosergio above?

Do you run hMailserver on an external MySQL Database?

[LordNik]

Could you please post plugin version and lines 24 - 33 of your hmail_spamfilter.php?

Also please post the structure of hmail_rule_actions table (hmailserver database).

Mine is:

  `actionid` int(11) NOT NULL auto_increment,
  `actionruleid` int(11) NOT NULL,
  `actiontype` tinyint(4) NOT NULL,
  `actionimapfolder` varchar(255) NOT NULL,
  `actionsubject` varchar(255) NOT NULL,
  `actionfromname` varchar(255) NOT NULL,
  `actionfromaddress` varchar(255) NOT NULL,
  `actionto` varchar(255) NOT NULL,
  `actionbody` text NOT NULL,
  `actionfilename` varchar(255) NOT NULL,
  `actionsortorder` int(11) NOT NULL,
  `actionscriptfunction` varchar(255) NOT NULL,
  `actionheader` varchar(80) NOT NULL,
  `actionvalue` varchar(255) NOT NULL,
  `actionrouteid` int(11) NOT NULL,


Do you use the change posted by fabiosergio above?

Do you run hMailserver on an external MySQL Database?

Ok, no problem. Thanks a lot for the support.

The lines are:

  public $task = 'login|mail|settings';
  private $sql_select_account       = 'SELECT accountid FROM hm_accounts WHERE accountaddress=%u';  
  private $sql_select_rule          = 'SELECT ruleid, ruleaccountid, rulename, ruleactive, ruleuseand, rulesortorder FROM hm_rules WHERE ruleaccountid=%u AND rulename =%r';
  private $sql_select_rule_criteria = 'SELECT criteriamatchvalue FROM hm_rule_criterias WHERE criteriaruleid=%id';
  private $sql_update_rule          = 'UPDATE hm_rules SET ruleactive=%b WHERE ruleid=%id';
  private $sql_update_criteria      = 'UPDATE hm_rule_criterias SET criteriamatchvalue=%v WHERE criteriaruleid=%id';
  private $sql_update_action        = 'UPDATE hm_rule_actions SET actionimapfolder=%f WHERE actionruleid=%id';
  private $sql_insert_rule          = "INSERT INTO hm_rules (ruleaccountid,rulename,ruleactive,ruleuseand,rulesortorder)  VALUES(%id,%r,%b,'1','1')";
  private $sql_insert_rule_criteria = "INSERT INTO hm_rule_criterias (criteriaruleid,criteriausepredefined,criteriapredefinedfield,criteriaheadername,criteriamatchtype,criteriamatchvalue)  VALUES(%id,'0','1',%n,'4',%s)";  
  private $sql_insert_rule_action   = "INSERT INTO hm_rule_actions (actionruleid,actiontype,actionimapfolder,actionsortorder,actionrouteid)  VALUES(%id,'4',%f,'0','0')";

You can find the structure of the database here:

http://www.patriarchi.info/images/hmailserver.jpg

I don't understand what fabiosergio means, please can you explain to me what i must to do?

I've changed in the config file rule_name and the header_field, but it doesn't functions.

I run hmailserver into the same server of the mysql database.

Thank you, Niccolò Patriarchi.

[rosali]

Does hMailserver use an external MySQL database or the built-in one?

[ericpepin]

Thanks Fobiosergio great instruction you have given here. love it, keep it up...!!!

[LordNik]

I've solved modifying this variable, like this:

private $sql_insert_rule_action   = "INSERT INTO hm_rule_actions (actionruleid,actiontype,actionimapfolder,actionsubject,actionfromname,actionfromaddress,actionto,actionbody,actionfilename,actionsortorder,actionscriptfunction,actionheader,actionvalue,actionrouteid)  VALUES(%id,'4',%f,'','','','','','','0','','','','0')";  

Thanks a lot!

Niccolò