Re: [exim] Strange problem with MySql lookup

Chris Lightfoot wrote:

> On Tue, Oct 03, 2006 at 05:31:50PM +0200, Wolfgang.Fuertbauer@??? wrote:
>
>>Hi all,
>>
>>i have a strange problem with an MySQL lookup;
>>many, many lookups work without any problem then I get errormessages like
>>
>>2006-10-03 17:02:39 H=horn02.intern.ebewe.at (horn.intern.ebewe.at)
>>[172.16.5.102] sender verify defer for <removed_by_me!>: condition check
>>lookup defer
>>2006-10-03 17:02:39 H=horn02.intern.ebewe.at (horn.intern.ebewe.at)
>>[172.16.5.102] F=<removed_by_me!> temporarily rejected RCPT
>><angiola.aloisio@???>: MYSQL connection failed: Unknown MySQL Server
>>Host 'saxophon' (1)
>
>
> Is that hostname (saxophon) being looked up in DNS? If so,
> it's possible that you're seeing some sort of transient
> DNS problem. See if putting an /etc/hosts entry in for the
> host, or specifying its address numerically in the exim
> config, helps.
>

Are you able to use a unix socket instead of IP with MySQL?

- gets around one whole set of issues.

Can you check logs to see if you have exhausted permitted connection count?

(not sure if MySQL even *has* a limit, but we have had circumstances where we
hit that wall with PostgreSQL's 'default' limits.

OTOH, the Exim logs showed that specifically...

HTH,

Bill