Clearly, the "real" hostname of the machine I'm playing with this on is
shell.huntsvilleal.com, I didn't change all the instances of that to
example.com in my debug output here.
Sorry about that, I'm an idiot sometimes...
- Mitch
----- Original Message -----
From: Mitch Vincent <mitch@???>
To: Jon Knight <J.P.Knight@???>
Cc: <exim-users@???>
Sent: Wednesday, March 08, 2000 10:01 AM
Subject: 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
> >
>
>
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
>
