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

Top Page
Delete this message
Reply to this message
Author: Konrad Michels
Date:  
To: prince
CC: exim-users
Subject: Re: [Exim] failed to expand condition "${lookup mysql {SELECT home FROM users WHERE
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
*
***********************************************************