Skip to content

postfix/main.cf: missing proxy: prefix on some mysql lookup tables

short description

because some of the mysql lookup tables are not prefixed with "proxy:" in /etc/postfix/main.cf there can are many (sleeping) mysql processes, some idling almost forever, they will block db access if the server reaches max_connections.

correct behaviour

the recommended configuration is to use postfix proxymap servers for mysql lookup tables, sharing connections, it will reduce mysql connections to a minimum.

environment

debian buster - ISPConfig 3.1.15p2

proposed fix

add proxy: to all mysql lookup tables, and adjust proxy_read_maps

screenshots

on a Server with "untouched" postfix/main.cf Bildschirmfoto_von_2019-12-02_15-21-59

on a Server where i added proxy: to all mysql tables and adjusted proxy_read_maps: Bildschirmfoto_von_2019-12-02_15-23-29

after the change the processes which sleep at most, are the two from amavis (one for IPv4, one for IPv6), they sleep until there is a mail incoming, all other connections seem to be terminated within less than a minute.