Florian Schicker [Nessus Office] wrote:
> sorry i forgot to say that i dont have smtp_accept_max_per_host set as a db
> lookup.
> outgoing mail or local mail does not exist on this server, it's only a
> manualroute server in front of the
> "real" mailserver. the mysql processes i watched showed all "sleep" state.
>
> the only database lookups are:
>
> hide mysql_servers = localhost/db/user/password
>
> BLOCKEDDOMAINS = ${lookup mysql{SELECT blockeddomains FROM exim}}
> WHITEDOMAINS = ${lookup mysql{SELECT whitedomains FROM exim}}
> RELAY_TO_DOMAINS = ${lookup mysql{SELECT relaydomain FROM exim_hub where
> relaydomain='$domain'}{$value}}
> RELAY_FROM_HOSTS = ${lookup mysql{SELECT relay_from_hosts FROM exim}}
What the hell is this? You're simply querying the "configuration
strings" from the database?
Consider to use one seperate table for everything and use of the
command-style lookups.
i.e for your BLOCKEDDOMAINS
Use a table with just one column, named domain, and use a domainlist like.
domainlist blocked_domains = mysql;select 1 from blockeddomains where \
domain = '${quote_mysql:$sender_domain}'
That's not related to your problem, but you really should change that.
Nico
