Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I have a Debian server with Postfix and would like to know if it's possible to create some "manual" filters, move/reject mails if the body contains something, if the header does and if it's sent to a specific person etc? Maybe coupling it with mysql
I have a Debian server with Postfix and would like to know if it's possible to create some "manual" filters, move/reject mails if the body contains something, if the header does and if it's sent to a specific person etc? Maybe coupling it with mysql
Thanks. I've configured Spamassassin now (without MySQL for now), but I'm facing some issues which restricts me from sending and receiving mails:
Code:
Oct 5 10:15:39 *** postfix/smtpd[20357]: fatal: open database /etc/postfix/access_client.db: No such file or directory
Oct 5 10:15:40 *** postfix/master[20259]: warning: process /usr/lib/postfix/smtpd pid 20357 exit status 1
Oct 5 10:15:40 *** postfix/master[20259]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
It looks like it doesn't look up for the right account, and just uses spamd system user?
Code:
Oct 5 11:45:50.601 [21443] dbg: config: Conf::SQL: executing SQL: select preference, value from userpref where username = 'spamd' or username = '@GLOBAL' order by username asc
to start spamd i use
Code:
-q -x -u spamd -D
-- That's for sure the problem! It works when I use @GLOBAL or spamd as account, how do I combine these rules with virtual SQL users?
Maybe user should be ${recipient} in postfix?My conclusion: No!
I've read that I should use a custom query for my purpose in /etc/spamassassin/local.cf, so I used this one as the documentation said, but without any luck:
Code:
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '@GLOBAL' ORDER BY username ASC
It's important to have -u ${recipient}
Thanks for the links to get started, TB0ne. Hope someone some day can use my thoughts here.
No problems..glad it helped. And thanks to your following up on what you've done and how, you've already helped quite a few folks with the same issue/question.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.