Re: [Exim] Exim MySQL Problems

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Nico Erfurth
日付:  
To: Florian Schicker [Nessus Office], Exim-Users (E-mail)
題目: Re: [Exim] Exim MySQL Problems
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