Re: [Exim] MYSQL: no data found

Pàgina inicial
Delete this message
Reply to this message
Autor: David Saez
Data:  
A: Nico Erfurth
CC: exim-users
Assumpte: Re: [Exim] MYSQL: no data found
Hi !!

> > I have some entries like this on my logs:
> >
> > 2003-05-17 23:35:58 19H9LC-00044r-M6 H=su00fw01-1.ufjbank.co.jp
> > [211.120.52.199] F=<root@???> temporarily rejected
> > after DATA: MYSQL: no data found
>
>          ^^^^


Evident ... but I have to mysql queries in data acl ...

> > How can I know which acl statment is causing this ?
>
> It's either in your data-acl or maybe in some
> exiscan/whatever-kind-of-localscan option.
>
> do you try to use $local_part/$domain somewhere in this acl/options?


No I only use ${domain:$h_from:}, but i just realized tha both queries
are similar so in that case it has little sense to know exactly which
one is givin no data. But maybe it would be a good idea to log some
extra info that could be useful to locate the error in case somebody
use more than one query in the same acl.

Nevertheless I do not understand why exim is logging that, the queries
are used on a 'condition' statment like this:

condition = ${lookup mysql{MYSQL_LDOMAIN}{yes}{no}}

where MYSQL_LDOMAIN is a SELECT DISTINCT ... query. I supose that the
fact that the query returns no data is not an error an should not be
logged, but maybe a query that does SELECT COUNT(*) will make exim
happy and avoid logging 'no data found'

--
Thanx & best regards ...

Why do they put Braille dots on the keypad of the drive-up ATM?

----------------------------------------------------------------
   David Saez Padros                http://www.ols.es
   On-Line Services 2000 S.L.       e-mail  david@???
   Pintor Vayreda 1                 telf    +34 902 50 29 75
   08184 Palau-Solita i Plegamans   movil   +34 670 35 27 53
----------------------------------------------------------------