Dear users ! I`m using exim + spamd + user_prefs in mysql. All works fine.
But I found a bug, when I`m using whitelist, and header rcpt to: have address with character description, whitelist failed to catch it in database. For example: 1st message: spamd: clean message (-91.7/10.0) for t...@localdomain.com:501 in 8.2 seconds, 13522829 bytes. 2nd message: spamd: identified spam (9.2/5.0) for some text <t...@localdomain.com>:501 in 8.3 seconds, 14874071 bytes. Where "some text" for example User Name in address book of senders mail agent. Mysql userpref struct: username | preference | value | prefid ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ test | whitelist_from | sen...@hidden.com | 1 Mysql database query in sql.cf: user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE username IN (_USERNAME_, '$GLOBAL', CONCAT(_MAILBOX_, '@' , _DOMAIN_),SUBSTRING_INDEX(_USERNAME_, '@', 1)) ORDER BY username ASC All works fine, when address of recipient in incoming letter is canonical like t...@localdomain.com How can I fix this ? Thanks. Wbr, Steve