[Exim] Exim+Mysql: Frozen message sending mail to root@loca…

Top Page
Delete this message
Reply to this message
Author: prince
Date:  
To: exim-users
Subject: [Exim] Exim+Mysql: Frozen message sending mail to root@localhost from localhost
Hi,

I have some cron jobs sending mails to root which is forwarded to my personal
address. It used to work when I had qmail. I installed exim with mysql
support and has broken something. Now, whatever the messages send by the cron
job is kept in /var/spool/exim/input.

Do I need to have "localhost" in my "domains" table? If I add localhost to
my "domains" table, it seems to be working. [I tried telnetting to smtp and
sending a mail to root@localhost after adding "localhost" to domains and it
worked]

This is part of the exim.conf.
------------------------------

# Domains & Names
primary_hostname = localhost

# Domains
domainlist local_domains = \
  ${lookup mysql {SELECT domain FROM domains \
    WHERE type="local" and domain="${domain}" }}



Frozen message when "localhost" is not in the domains table.
------------------------------------------------------------
cd /var/spool/exim

input/....
===========
1At3vO-0001cA-05-H
mail 8 12
<>
1077019322 0
-ident mail
-received_protocol local
-body_linecount 77
-frozen 1077019322
-localerror
XX
1
root@localhost

130P Received: from mail by localhost with local (Exim 4.30)
        id 1At3vO-0001cA-05
        for root@localhost; Tue, 17 Feb 2004 04:02:02 -0800
036  X-Failed-Recipients: root@localhost
031  Auto-Submitted: auto-generated
053F From: Mail Delivery System <Mailer-Daemon@localhost>
019T To: root@localhost
059  Subject: Mail delivery failed: returning message to sender
042I Message-Id: <E1At3vO-0001cA-05@localhost>
038  Date: Tue, 17 Feb 2004 04:02:02 -0800


msglog/....
===========
2004-02-17 04:02:02 Received from <> R=1At3vN-0001bK-OJ U=mail P=local S=3046
2004-02-17 04:02:02 routing failed for root@localhost: Unrouteable address
*** Frozen (delivery error message)

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

+------+-----------------------------+-----------------------+
| site | root                        | princexxxxx@??? |
| site | root@localhost              | princexxxxx@??? |

+------+-----------------------------+-----------------------+

mysql> select * from domains ;
+---------------------+-------+------------+
| domain              | type  | relay_host |

+---------------------+-------+------------+
| mydomain.com        | local |            |

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


mysql> select id, uid, crypt from users ;
+----------------------------+-----+---------------+
| id                         | uid | crypt         |

+----------------------------+-----+---------------+
| prince@???        |   8 | C8Y9BC2X4jtKw |
| prince2@???       |   8 | B769BR2c7jLAj |

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