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
*
***********************************************************
