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.
