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)