Re: [Exim] SQL Error...

More info :-)


[root@example log]# /usr/exim/bin/exim -v -d 11 -bt mitch
Exim version 3.13 debug level 12 uid=0 gid=0
probably Berkeley DB version 1.8x (native mode)
Caller is an admin user
Caller is a trusted user
sender address = root@???
Address testing: uid=0 gid=0 euid=1006 egid=6
>>>>>>>>>>>>>>>>>>>>>>>>
Testing mitch@???
search_open: mysql "NULL"
search_find: file="NULL"
key="SELECT DISTINCT domain FROM domains WHERE domain='example.com'"
partial=-1
LRU list:
internal_search_find: file="NULL"
type=mysql key="SELECT DISTINCT domain FROM domains WHERE
domain='example.com'"
database lookup required for SELECT DISTINCT domain FROM domains WHERE
domain='example.com'
MYSQL query: SELECT DISTINCT domain FROM domains WHERE domain='example.com'
lookup deferred
LOG: 0 MAIN PANIC DIE
lookup of "shell.huntsvilleal.com" in "mysql;SELECT DISTINCT domain FROM
domains WHERE domain='$key'" failed to complete
[root@example log]#


I see a "lookup deferred" there, is the the MySQL lookup, DNS lookup or
what?..

Thanks for any and all help!!

- Mitch

----- Original Message -----
From: Jon Knight <J.P.Knight@???>
To: Mitch Vincent <mitch@???>
Sent: Wednesday, March 08, 2000 4:55 AM
Subject: Re: [Exim] SQL Error...


> On Tue, 7 Mar 2000, Mitch Vincent wrote:
> > ... on my FreeBSD box running the latest MySQL and Exim (as of this
> > morning).. Since the query (cut and pasted into a mysql query program)
> > worked fine, I'm curious as to what else may be the problem.. Any ideas?
>
> I assume that you've checked that the user that Exim is running under is
> permitted to query the database?
>
> Tatty bye,
>
> Jim'll
>