Home / user-151797

Emil Hemdal's questions

Martin Hope
Emil Hemdal
Asked: 2014-05-02 13:38:38 +0800 CST
  • 2

We're trying to use PostFix to check whether the sender email-address is permitted to send to a specific email-address.

Another way to describe it would be that I want specific e-mailaddresses to only allow incoming messages (not SMTP logins) from specific e-mailaddresses.

Will something like this work? main.cf:

smtpd_recipient_restrictions =
    [other restrictions here]
    check_sender_access
        mysql:/etc/postfix/restricted_senders_to_recipents.cf

restricted_senders_to_recipents.cf:

user = uname
password = pword
hosts = 127.0.0.1
dbname = dbname
#!!!PSEUDOCODE!!!
query = SELECT allowed FROM members WHERE sender = %sender AND recipent = %recipent;

Is this possible? If then how?

I know that aliases with MySQL works this way since we're already using it. (http://www.postfix.org/mysql_table.5.html)

mysql
Martin Hope
Emil Hemdal
Asked: 2014-03-31 14:59:12 +0800 CST
  • 1

I have a somewhat complex SQL query that I'm using to get alias forwarding e-mail in Postfix. The problem is that Postfix uses %s as it's insert of alias mark in the SQL query. I think this causes the query to fail for Postfix while it works when inserting it directly to MySQL (replacing the %s with a test alias)

SELECT email FROM members JOIN groups ON mgroup_others LIKE CONCAT('%,', g_id, ',%') OR member_group_id = g_id WHERE g_title LIKE CONCAT('%[', '%s', ']%');

The Postfix error:

postfix/smtpd[9585]: fatal: db_common_parse: /etc/postfix/mysql-aliases.cf: Invalid query template: SELECT email FROM members JOIN groups ON mgroup_others LIKE CONCAT('%,', g_id, ',%') OR member_group_id = g_id WHERE g_title LIKE CONCAT('%[', '%s', ']%');

Are my guess at the error right and/or how do I fix it?

mysql