> On 25 Jul 2021, at 4:13 pm, [email protected] wrote:
>
> Everything in main.cf worked out of the box with proxy:mysql:/
> However when i tried to add it to master.cf for submission i got the error
> you talking about.
>
> 127.0.0.1:submission inet n - n - -
> smtpd
> ...
> -o
> smtpd_sender_login_maps=proxy:mysql:/etc/postfix/mysql_sender_login_matching
When adding a table to proxy_read_maps, make sure to include the default
value explicitly, and then append any additional custom tables to that.
For example:
postconf -e "proxy_read_maps = $(postconf -hd proxy_read_maps)
proxy:mysql:/etc/postfix/mysql_sender_login_matching"
> I checked postconf -d and the map is included,
You should be checking "postconf" not "postconf -d" to determine
what's actually configured on your system.
> but it looks like when running under submission that default isn't
> carrying over.
Rather, smtpd(8) does not use this parameter at all...
> I tried to add it to the submission trying both of
>
> -o proxy_read_maps=$smtpd_sender_login_maps
> -o proxy_read_maps=proxy:mysql:/etc/postfix/mysql_sender_login_matching
Only the last setting applies, there's no cumulative behaviour, the parameter
is used by the proxymap(8) service, setting it for the smtpd(8) entry has no
effect.
> And neither worked. I still got the error saying request unapproved for table.
> What is the correct way when using proxy in a master.cf submission line?
Configure "proxy_read_maps" to include the full list of proxied tables used
in any context in main.cf or master.cf. Set "proxy_read_maps" in main.cf.
--
Viktor.
