[Exim] exim + mysql : can't send mail from some users. 550-V…

Top Page
Delete this message
Reply to this message
Author: prince
Date:  
To: exim-users
Old-Topics: Re: [Exim] failed to expand condition "${lookup mysql {SELECT home FROM users WHERE
Subject: [Exim] exim + mysql : can't send mail from some users. 550-Verification failed for <root@localhost>
I had send mail installed and was working fine.

Now, I installed exim with mysql.

I used to have the cron jobs sending mails to my personal email address from
root@localhost using send mail. I don't get those mails anymore after
configuring exim as my smtp.


[root@rh9 log]# telnet localhost smtp
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 localhost ESMTP Exim 4.30 Mon, 16 Feb 2004 19:03:54 -0800
mail from: root@localhost
250 OK
rcpt to: princexxx@???
<root@localhost>
550-Unrouteable address
550 Sender verify failed

Also, I get the following error in the
"rejected EHLO from localhost [127.0.0.1]: syntactically invalid argument(s):
(no argument given)", when someone tries to send a mail
to "support@???" which is defined in the aliases. Do Ihave to have
the "id" defined in the "users" table?


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 |

+---------------------+-------+------------+
| site1.domain.com    | local |            |
| site2.domain.com    | local |            |

+---------------------+-------+------------+
2 rows in set (0.00 sec)

mysql> select * from aliases ;
+------+-----------------------------+-----------------------+
| type | email                       | dest                  |

+------+-----------------------------+-----------------------+
| site | root@localhost              | princexxx@???   |
| site | support@???       | princexxx@???   |

+------+-----------------------------+-----------------------+
1 rows in set (0.00 sec)

Thanks,
Prince.