Re: [Exim] failed to expand condition "${lookup mysql {SELEC…

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Konrad Michels
日付:  
To: prince
CC: exim-users
題目: Re: [Exim] failed to expand condition "${lookup mysql {SELECT home FROM users WHERE
If you're not seeing anything in the mysql log then either logging isn't
on for mysql or exim ain't talkin to the database.

Mind you, re-reading your mail now - it looks more like a syntax problem
than anything else . . .

I'm by far the least qualified to correct your syntax here, but
shouldn't it read something like:

"${lookup mysql{SELECT home FROM users WHERE
id='${quote_mysql:$local_part} . . . .

Just a wild guess . . someone else more experienced with the syntax
will be able to assist more I'm sure.

On Fri, 2004-01-23 at 19:46, prince wrote:
> Thanks for the response. Do I have to have some kind of logging enabled for
> this? If so, do you know how I can accomplish this?
>
> I don't see anything strange in the mysqld.log.
>
> Thanks,
> Prince.
>
> On Fri, 23 Jan 2004 19:39:46 +0000, Konrad Michels wrote
> > A mysql log might tell you what is or isn't being got from the database
> > . . .
> >
> > On Fri, 2004-01-23 at 19:33, prince wrote:
> > > I am trying to test the exim installation. I get "unknown error" when I
> try
> > > the mail user defined on the mysql table "users".
> > >
> > > telnet localhost smtp
> > > Trying 127.0.0.1...
> > > Connected to localhost.
> > > Escape character is '^]'.
> > > 220 localhost ESMTP Exim 4.30 Fri, 23 Jan 2004 11:26:35 -0800
> > > mail from: prince@???
> > > 250 OK
> > > rcpt to: prince@???
> > > 550 unknown user
> > > quit
> > > 221 localhost closing connection
> > > Connection closed by foreign host.
> > >
> > >
> > > maillog has the following entry.
> > >
> > > failed to expand condition "${lookup mysql {SELECT home FROM users WHERE
> > > id='${$local_part}@${$domain}'}}" for mysql_user router: letter or digit
> > > expected after ${
> > > H=localhost [127.0.0.1] F=<prince@???> rejected RCPT
> > > prince@???: Unrouteable address
> > >
> > > Could anyone help me to identify and correct the issue, please?
> > >
> > > mysql> describe users ;
> > > +---------+------------------+------+-----+---------+-------+
> > > | Field   | Type             | Null | Key | Default | Extra |
> > > +---------+------------------+------+-----+---------+-------+
> > > | id      | char(128)        |      | MUL |         |       |
> > > | crypt   | char(128)        |      |     |         |       |
> > > | clear   | char(128)        |      |     |         |       |
> > > | name    | char(128)        |      |     |         |       |
> > > | uid     | int(10) unsigned |      |65534|         |       |
> > > | gid     | int(10) unsigned |      |65534|         |       |
> > > | home    | char(255)        |      |     |         |       |
> > > | maildir | char(255)        |      |     |         |       |
> > > | quota   | char(255)        |      |     |         |       |
> > > +---------+------------------+------+-----+---------+-------+
> > > 9 rows in set (0.00 sec)

> > >
> > > mysql> select * from users ;
> > > +-------------------+------+--------+-----+-----+--------------+----------
> ----
> > > ---+
> > > | id                 xxx  |name     uid | gid | home         |
> > > maildir         |
> > > +--------------------------+--------+-----+-----+--------------+----------
> ----
> > > ---+

> > >
> > > +-------------------+-----+--------+-----+-----+--------------+-----------
> ----
> > > --+
> > > | prince@??? | xxx | Prince | 8 | 12
> > > | /home/dom/yyy.com/users/prince | /home/dom/yyy.com/users/prince/Maildir/
> > > +-------------------+-----+--------+-----+-----+--------------+-----------
> ----
> > > --+
> > >
> > > mysql> select * from domains ;
> > > +---------+-------+------------+
> > > | domain type relay_host |
> > > +---------+-------+------------+
> > > | yyy.com | local |
> > > +---------+-------+------------+
> > >
> > > Thanks,
> > > Prince.
> > >
> > >
> > > --
> > >
> > > ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
> details at http://www.exim.org/ ##
> > --
> > ***********************************************************
> > * Konrad Michels
> > * IT Manager
> > * Surfkitchen Limited
> > * +441189298079
> > *
> > ***********************************************************
>
>
>
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##

--
***********************************************************
* Konrad Michels
* IT Manager
* Surfkitchen Limited
* +441189298079
*
***********************************************************