Jon Harris wrote: > Hi Brian > > Everything you said makes a great deal of sense - thanks very much. I > have changed the RBL settings, as you advised. > > Yes, the load has gone up considerably, particularly, we are seeing a > massive rise of spam traffic on this box (mainly on one or two of the > domains 30 domains its responsible for) > > However, I have tried putting "proxy:" in front of my mysql maps and it > stopped it being able to receive email. Presumably, I need to enable > proxymap to get proxy maps to work. This is something I don't know how > to do. > > This is what "postconf -d | grep proxy" returns: >
'postconf -d' shows defaults that are used unless you define them in main.cf 'postconf -n' shows what Postfix sees in your main.cf. > There are no lines with proxy in my main.cf, do I need to add in a > "proxy_read_maps"? If so what do I set it to? > You have proxymap enabled according to your OP: > master.cf > --------- > proxymap unix - - n - - proxymap What is the in the log of the error? > Incidently, here is a copy of my "mysql_virtual_mailbox_maps.cf" I did > initially have a few problems getting this working. If I use > proxy:mysql: will I need to change this? > No. Read 'man 8 proxymap' to understand what it does. > user = <postfixuser> > password = <postfixpassword> > hosts = localhost > dbname = postfix > table = mailbox > #select_field = CONCAT(domain,'/',maildir) > select_field = maildir > where_field = username > additional_conditions = and active = '1' > #query = SELECT CONCAT(domain,'/',maildir) FROM mailbox WHERE > username='%s' AND active = '1' > >
