> The configuration looks fine to me and the same config works here.
> Can you give aus some debugoutput?
Here is the debug run. I never see the home options being expanded anywhere
tho?
waldorf-ng:~# exim -bt -d
Exim version 4.12 uid=0 gid=0 pid=14870 D=fddcaefd
Berkeley DB: Sleepycat Software: Berkeley DB 2.7.7: (08/20/99)
Support for: OpenSSL
Authenticators: cram_md5 plaintext spa
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir/mbx autoreply pipe smtp
changed uid/gid: forcing real = effective
uid=0 gid=0 pid=14870
auxiliary group list: <none>
configuration file is /etc/exim/exim.conf
log selector = 0106ccd8
trusted user
admin user
finduser used cached passwd data for nobody
finduser used cached passwd data for mail
originator: uid=0 gid=0 login=root name=root
sender address = root@???
Address testing: uid=0 gid=8 euid=0 egid=8
> j@
syntax error: domain missing or malformed
> j2@???
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Testing j2@???
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering j2@???
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
routing j2@???
--------> xams_aliases router <--------
local_part=j2 domain=eriksmaskiner.com
checking domains
search_open: cdb "/etc/xams/localdomains.cdb"
search_find: file="/etc/xams/localdomains.cdb"
key="eriksmaskiner.com" partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="/etc/xams/localdomains.cdb"
type=cdb key="eriksmaskiner.com"
file lookup required for eriksmaskiner.com
in /etc/xams/localdomains.cdb
lookup yielded: 1
eriksmaskiner.com in "@:cdb;/etc/xams/localdomains.cdb:waldorf-ng.mupp.net"?
yes (matched "cdb;/etc/xams/localdomains.cdb")
eriksmaskiner.com in "+local_domains"? yes (matched "+local_domains")
data from lookup saved for cache
calling xams_aliases router
rda_interpret (string): ${lookup mysql {SELECT a.RightPart FROM pm_domains
d, pm_sites s, pm_aliases a WHERE '$local_part' != '*' AND s.ID = d.SiteID
AND a.SiteID = s.ID AND a.LeftPart = '$local_part' AND d.Name= '$domain' AND
s.SiteState != 'locked_bounce'}}
search_open: mysql "NULL"
search_find: file="NULL"
key="SELECT a.RightPart FROM pm_domains d, pm_sites s, pm_aliases a WHERE
'j2' != '*' AND s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = 'j2'
AND d.Name= 'eriksmaskiner.com' AND s.SiteState != 'locked_bounce'"
partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT a.RightPart FROM pm_domains d, pm_sites s,
pm_aliases a WHERE 'j2' != '*' AND s.ID = d.SiteID AND a.SiteID = s.ID AND
a.LeftPart = 'j2' AND d.Name= 'eriksmaskiner.com' AND s.SiteState !=
'locked_bounce'"
database lookup required for SELECT a.RightPart FROM pm_domains d, pm_sites
s, pm_aliases a WHERE 'j2' != '*' AND s.ID = d.SiteID AND a.SiteID = s.ID
AND a.LeftPart = 'j2' AND d.Name= 'eriksmaskiner.com' AND s.SiteState !=
'locked_bounce'
MYSQL query: SELECT a.RightPart FROM pm_domains d, pm_sites s, pm_aliases a
WHERE 'j2' != '*' AND s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart =
'j2' AND d.Name= 'eriksmaskiner.com' AND s.SiteState != 'locked_bounce'
MYSQL new connection: host=localhost port=0 socket=NULL database=xams
user=xams
MYSQL: no data found
lookup failed
expanded:
file is not a filter file
parse_forward_list:
xams_aliases router declined for j2@???
--------> xams_forward router <--------
local_part=j2 domain=eriksmaskiner.com
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID = d.SiteID AND
d.Name = 'eriksmaskiner.com'" partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID =
d.SiteID AND d.Name = 'eriksmaskiner.com'"
database lookup required for SELECT s.Name FROM pm_domains d, pm_sites s
WHERE s.ID = d.SiteID AND d.Name = 'eriksmaskiner.com'
MYSQL query: SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID =
d.SiteID AND d.Name = 'eriksmaskiner.com'
MYSQL using cached connection for localhost/xams/xams
lookup yielded: Eriks Maskiner
calling xams_forward router
rda_interpret (string): ${lookup mysql{SELECT f.Filter FROM pm_exim_filters
f, pm_domains d, pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name =
'$domain' AND u.Name = '$local_part' AND u.ID = f.UserID AND u.SiteID = s.ID
AND s.SiteState != 'locked_bounce' AND u.AccountState != 'locked_bounce' AND
f.Active='true'}{${value}}}
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT f.Filter FROM pm_exim_filters f, pm_domains d, pm_sites s,
pm_users u WHERE s.ID = d.SiteID AND d.Name = 'eriksmaskiner.com' AND u.Name
= 'j2' AND u.ID = f.UserID AND u.SiteID = s.ID AND s.SiteState !=
'locked_bounce' AND u.AccountState != 'locked_bounce' AND f.Active='true'"
partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT f.Filter FROM pm_exim_filters f, pm_domains d,
pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name =
'eriksmaskiner.com' AND u.Name = 'j2' AND u.ID = f.UserID AND u.SiteID =
s.ID AND s.SiteState != 'locked_bounce' AND u.AccountState !=
'locked_bounce' AND f.Active='true'"
database lookup required for SELECT f.Filter FROM pm_exim_filters f,
pm_domains d, pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name =
'eriksmaskiner.com' AND u.Name = 'j2' AND u.ID = f.UserID AND u.SiteID =
s.ID AND s.SiteState != 'locked_bounce' AND u.AccountState !=
'locked_bounce' AND f.Active='true'
MYSQL query: SELECT f.Filter FROM pm_exim_filters f, pm_domains d, pm_sites
s, pm_users u WHERE s.ID = d.SiteID AND d.Name = 'eriksmaskiner.com' AND
u.Name = 'j2' AND u.ID = f.UserID AND u.SiteID = s.ID AND s.SiteState !=
'locked_bounce' AND u.AccountState != 'locked_bounce' AND f.Active='true'
MYSQL using cached connection for localhost/xams/xams
lookup yielded: # Exim filter
unseen deliver j2@???
save /tmp/crap
expanded: # Exim filter
unseen deliver j2@???
save /tmp/crap
changed uid/gid: xams_forward router (recipient is j2@???)
uid=8 gid=8 pid=14872
auxiliary group list: <none>
data is a filter program
Filter: start of processing
Filter: end of processing
rda_interpret: subprocess yield=0 error=NULL
set transport address_file
xams_forward router generated /tmp/crap
pipe, file, or autoreply
errors_to=NULL transport=address_file
uid=8 gid=8 home=/var/mail/${lookup mysql {SELECT s.Name FROM pm_domains
d, pm_sites s WHERE s.ID = d.SiteID AND d.Name =
'$domain'}{${value}}}/$local_part
xams_forward router generated j2@???
errors_to=NULL transport=NULL
uid=unset gid=unset home=NULL
routed by xams_forward router
envelope to: j2@???
transport: <none>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering j2@???
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
routing j2@???
--------> xams_aliases router <--------
local_part=j2 domain=mupp.net
checking domains
search_open: cdb "/etc/xams/localdomains.cdb"
cached open
search_find: file="/etc/xams/localdomains.cdb"
key="mupp.net" partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="/etc/xams/localdomains.cdb"
type=cdb key="mupp.net"
file lookup required for mupp.net
in /etc/xams/localdomains.cdb
lookup failed
mupp.net in "@:cdb;/etc/xams/localdomains.cdb:waldorf-ng.mupp.net"? no (end
of list)
mupp.net in "+local_domains"? no (end of list)
cached lookup data = NULL
xams_aliases router skipped: domains mismatch
--------> xams_forward router <--------
local_part=j2 domain=mupp.net
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID = d.SiteID AND
d.Name = 'mupp.net'" partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID =
d.SiteID AND d.Name = 'mupp.net'"
database lookup required for SELECT s.Name FROM pm_domains d, pm_sites s
WHERE s.ID = d.SiteID AND d.Name = 'mupp.net'
MYSQL query: SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID =
d.SiteID AND d.Name = 'mupp.net'
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
calling xams_forward router
rda_interpret (string): ${lookup mysql{SELECT f.Filter FROM pm_exim_filters
f, pm_domains d, pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name =
'$domain' AND u.Name = '$local_part' AND u.ID = f.UserID AND u.SiteID = s.ID
AND s.SiteState != 'locked_bounce' AND u.AccountState != 'locked_bounce' AND
f.Active='true'}{${value}}}
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT f.Filter FROM pm_exim_filters f, pm_domains d, pm_sites s,
pm_users u WHERE s.ID = d.SiteID AND d.Name = 'mupp.net' AND u.Name = 'j2'
AND u.ID = f.UserID AND u.SiteID = s.ID AND s.SiteState != 'locked_bounce'
AND u.AccountState != 'locked_bounce' AND f.Active='true'" partial=-1
affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT f.Filter FROM pm_exim_filters f, pm_domains d,
pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name = 'mupp.net' AND
u.Name = 'j2' AND u.ID = f.UserID AND u.SiteID = s.ID AND s.SiteState !=
'locked_bounce' AND u.AccountState != 'locked_bounce' AND f.Active='true'"
database lookup required for SELECT f.Filter FROM pm_exim_filters f,
pm_domains d, pm_sites s, pm_users u WHERE s.ID = d.SiteID AND d.Name =
'mupp.net' AND u.Name = 'j2' AND u.ID = f.UserID AND u.SiteID = s.ID AND
s.SiteState != 'locked_bounce' AND u.AccountState != 'locked_bounce' AND
f.Active='true'
MYSQL query: SELECT f.Filter FROM pm_exim_filters f, pm_domains d, pm_sites
s, pm_users u WHERE s.ID = d.SiteID AND d.Name = 'mupp.net' AND u.Name =
'j2' AND u.ID = f.UserID AND u.SiteID = s.ID AND s.SiteState !=
'locked_bounce' AND u.AccountState != 'locked_bounce' AND f.Active='true'
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
expanded:
file is not a filter file
parse_forward_list:
xams_forward router declined for j2@???
--------> xams_lock router <--------
local_part=j2 domain=mupp.net
checking local_parts
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key=" SELECT u.Quota FROM pm_domains d, pm_sites s, pm_users u WHERE s.ID
= d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND d.Name = 'mupp.net' AND
( s.SiteState = 'locked_bounce' OR u.AccountState = 'locked_bounce' )"
partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key=" SELECT u.Quota FROM pm_domains d, pm_sites s, pm_users u
WHERE s.ID = d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND d.Name =
'mupp.net' AND ( s.SiteState = 'locked_bounce' OR u.AccountState =
'locked_bounce' )"
database lookup required for SELECT u.Quota FROM pm_domains d, pm_sites s,
pm_users u WHERE s.ID = d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND
d.Name = 'mupp.net' AND ( s.SiteState = 'locked_bounce' OR u.AccountState =
'locked_bounce' )
MYSQL query: SELECT u.Quota FROM pm_domains d, pm_sites s, pm_users u WHERE
s.ID = d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND d.Name =
'mupp.net' AND ( s.SiteState = 'locked_bounce' OR u.AccountState =
'locked_bounce' )
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
j2 in ""? no (end of list)
xams_lock router skipped: local_parts mismatch
--------> xams_users router <--------
local_part=j2 domain=mupp.net
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID = d.SiteID AND
d.Name = 'mupp.net'" partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID =
d.SiteID AND d.Name = 'mupp.net'"
database lookup required for SELECT s.Name FROM pm_domains d, pm_sites s
WHERE s.ID = d.SiteID AND d.Name = 'mupp.net'
MYSQL query: SELECT s.Name FROM pm_domains d, pm_sites s WHERE s.ID =
d.SiteID AND d.Name = 'mupp.net'
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT u.Quota FROM pm_domains d, pm_sites s, pm_users u WHERE s.ID =
d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND d.Name = 'mupp.net' AND
s.SiteState != 'locked_bounce' AND u.AccountState != 'locked_bounce'"
partial=-1 affix=NULL starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT u.Quota FROM pm_domains d, pm_sites s, pm_users u
WHERE s.ID = d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND d.Name =
'mupp.net' AND s.SiteState != 'locked_bounce' AND u.AccountState !=
'locked_bounce'"
database lookup required for SELECT u.Quota FROM pm_domains d, pm_sites s,
pm_users u WHERE s.ID = d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND
d.Name = 'mupp.net' AND s.SiteState != 'locked_bounce' AND u.AccountState !=
'locked_bounce'
MYSQL query: SELECT u.Quota FROM pm_domains d, pm_sites s, pm_users u WHERE
s.ID = d.SiteID AND u.SiteID = s.ID AND u.Name = 'j2' AND d.Name =
'mupp.net' AND s.SiteState != 'locked_bounce' AND u.AccountState !=
'locked_bounce'
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
xams_users router skipped: condition failure
--------> xams_aliases_bounceforward router <--------
local_part=j2 domain=mupp.net
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT a.BounceForward FROM pm_domains d, pm_sites s, pm_aliases a
WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = '*' AND d.Name =
'mupp.net' AND s.SiteState != 'locked_bounce'" partial=-1 affix=NULL
starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT a.BounceForward FROM pm_domains d, pm_sites s,
pm_aliases a WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = '*'
AND d.Name = 'mupp.net' AND s.SiteState != 'locked_bounce'"
database lookup required for SELECT a.BounceForward FROM pm_domains d,
pm_sites s, pm_aliases a WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND
a.LeftPart = '*' AND d.Name = 'mupp.net' AND s.SiteState != 'locked_bounce'
MYSQL query: SELECT a.BounceForward FROM pm_domains d, pm_sites s,
pm_aliases a WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = '*'
AND d.Name = 'mupp.net' AND s.SiteState != 'locked_bounce'
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
xams_aliases_bounceforward router skipped: condition failure
--------> xams_aliases_default_bounce router <--------
local_part=j2 domain=mupp.net
calling xams_aliases_default_bounce router
rda_interpret (string): ${lookup mysql {SELECT a.RightPart FROM pm_domains
d, pm_sites s, pm_aliases a WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND
a.LeftPart = '*' AND d.Name = '$domain' AND s.SiteState != 'locked_bounce'}}
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT a.RightPart FROM pm_domains d, pm_sites s, pm_aliases a WHERE
s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = '*' AND d.Name =
'mupp.net' AND s.SiteState != 'locked_bounce'" partial=-1 affix=NULL
starflags=0
LRU list:
0/etc/xams/localdomains.cdb
End
internal_search_find: file="NULL"
type=mysql key="SELECT a.RightPart FROM pm_domains d, pm_sites s,
pm_aliases a WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = '*'
AND d.Name = 'mupp.net' AND s.SiteState != 'locked_bounce'"
database lookup required for SELECT a.RightPart FROM pm_domains d, pm_sites
s, pm_aliases a WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart =
'*' AND d.Name = 'mupp.net' AND s.SiteState != 'locked_bounce'
MYSQL query: SELECT a.RightPart FROM pm_domains d, pm_sites s, pm_aliases a
WHERE s.ID = d.SiteID AND a.SiteID = s.ID AND a.LeftPart = '*' AND d.Name =
'mupp.net' AND s.SiteState != 'locked_bounce'
MYSQL using cached connection for localhost/xams/xams
MYSQL: no data found
lookup failed
expanded:
file is not a filter file
parse_forward_list:
xams_aliases_default_bounce router declined for j2@???
--------> dnslookup router <--------
local_part=j2 domain=mupp.net
checking domains
cached no match for +local_domains
mupp.net in "! +local_domains"? yes (end of list)
cached lookup data = NULL
calling dnslookup router
dnslookup router called for j2@???
domain = mupp.net
DNS lookup of mupp.net (MX) succeeded
130.241.25.165 in "0.0.0.0 : 127.0.0.0/8"? no (end of list)
fully qualified name = mupp.net
host_find_bydns yield = HOST_FOUND (2); returned hosts:
statler.mupp.net 130.241.25.165 10
set transport remote_smtp
queued for remote_smtp transport: local_part = j2
domain = mupp.net
errors_to=NULL
domain_data=NULL localpart_data=NULL
routed by dnslookup router
envelope to: j2@???
transport: remote_smtp
host statler.mupp.net [130.241.25.165] MX=10
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering /tmp/crap
j2@??? -> /tmp/crap
transport = address_file
j2@???
<-- j2@???
router = dnslookup, transport = remote_smtp
host statler.mupp.net [130.241.25.165] MX=10
>
