Problem with virtual domain.

Hi,

I get the following log if I try to send a message to a specific local
domain (all others are working OK) :
2009-04-14 18:10:06 lowest numbered MX record points to local host:
marylenepro.com (while verifying <[email protected]> from host
adijon-154-1-20-204.w90-6.abo.wanadoo.fr ([192.168.1.57]) [90.6.91.204])
2009-04-14 18:10:06 H=adijon-154-1-20-204.w90-6.abo.wanadoo.fr
([192.168.1.57]) [90.6.91.204] F=<[email protected]> temporarily
rejected RCPT <[email protected]>: lowest numbered MX record
points to local host
2009-04-14 18:10:11 lowest numbered MX record points to local host:
marylenepro.com (while verifying <[email protected]> from host
adijon-154-1-20-204.w90-6.abo.wanadoo.fr ([192.168.1.57]) [90.6.91.204])
2009-04-14 18:10:11 H=adijon-154-1-20-204.w90-6.abo.wanadoo.fr
([192.168.1.57]) [90.6.91.204] F=<[email protected]> temporarily
rejected RCPT <[email protected]>: lowest numbered MX record points
to local host

Now, i looked very well at my exim config, the vexim db etc. and I
cannot find any errors.
So, I tried this :
sd46:/etc/exim # exim -d+route -bt [email protected]

and the result is :

Exim version 4.69 uid=0 gid=0 pid=6607 D=fbb95cfd
Berkeley DB: Berkeley DB 4.5.20: (September 21, 2007)
Support for: crypteq iconv() IPv6 OpenSSL move_frozen_messages
Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz dnsdb
dsearch ldap ldapdn ldapm mysql nis nis0 passwd
Authenticators: cram_md5 dovecot plaintext
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Size of off_t: 8
changed uid/gid: forcing real = effective
  uid=0 gid=0 pid=6607
  auxiliary group list: <none>
configuration file is /etc/exim/exim.conf
log selectors = 00000ffc 00212001
trusted user
admin user
seeking password data for user "mailman": cache not available
getpwnam() succeeded uid=72 gid=67
originator: uid=0 gid=0 login=root name=root
sender address = [email protected]
Address testing: uid=0 gid=12 euid=0 egid=12
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Testing [email protected]
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering [email protected]
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
routing [email protected]
--------> mailman_router router <--------
local_part=marylene domain=marylenepro.com
checking domains
marylenepro.com in "la-france.net"? no (end of list)
marylenepro.com in "+mm_domains"? no (end of list)
mailman_router router skipped: domains mismatch
--------> dnslookup router <--------
local_part=marylene domain=marylenepro.com
checking domains
search_open: mysql "NULL"
search_find: file="NULL"
  key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND
enabled = '1' AND domain = 'marylenepro.com'" partial=-1 affix=NULL
starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="SELECT DISTINCT domain FROM domains WHERE type =
'local' AND enabled = '1' AND domain = 'marylenepro.com'"
database lookup required for SELECT DISTINCT domain FROM domains WHERE
type = 'local' AND enabled = '1' AND domain = 'marylenepro.com'
MySQL query: SELECT DISTINCT domain FROM domains WHERE type = 'local'
AND enabled = '1' AND domain = 'marylenepro.com'
MYSQL new connection: host=localhost port=0
socket=/var/lib/mysql/mysql.sock database=vexim user=vexim
lookup yielded: marylenepro.com
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="SELECT DISTINCT alias FROM domainalias WHERE alias =
'marylenepro.com'" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="SELECT DISTINCT alias FROM domainalias WHERE alias =
'marylenepro.com'"
database lookup required for SELECT DISTINCT alias FROM domainalias
WHERE alias = 'marylenepro.com'
MySQL query: SELECT DISTINCT alias FROM domainalias WHERE alias =
'marylenepro.com'
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
marylenepro.com in "marylenepro.com : revimmo.com : tout-bien.com :
libosan.nl : la-france.net : sd46.sivit.org : marylenepro.com : "?
yes(matched "marylenepro.com")
marylenepro.com in "! +local_domains"? no (matched "! +local_domains")
dnslookup router skipped: domains mismatch
--------> ditch_maxmsgsize router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select users.maxmsgsize from users,domains where localpart =
'marylene' and domain = 'marylenepro.com' and users.maxmsgsize > 0
andusers.domain_id=domains.domain_id " partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select users.maxmsgsize from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
users.maxmsgsize > 0 and users.domain_id=domains.domain_id "
database lookup required for select users.maxmsgsize from users,domains
where localpart = 'marylene' and domain = 'marylenepro.com' and
users.maxmsgsize > 0 and users.domain_id=domains.domain_id
MySQL query: select users.maxmsgsize from users,domains where localpart
= 'marylene' and domain = 'marylenepro.com' and users.maxmsgsize >0 and
users.domain_id=domains.domain_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
ditch_maxmsgsize router skipped: condition failure
--------> ditch_malware router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
ditch_malware router skipped: condition failure
--------> ditch_spam router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select users.sa_refuse * 10 from users,domains where localpart =
'marylene' and domain = 'marylenepro.com' and users.on_spamassassin =
'1' and users.domain_id=domains.domain_id and users.sa_refuse > 0 "
partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select users.sa_refuse * 10 from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_spamassassin = '1' and users.domain_id=domains.domain_id and
users.sa_refuse > 0 "
database lookup required for select users.sa_refuse * 10 from
users,domains where localpart = 'marylene' and domain =
'marylenepro.com' and users.on_spamassassin = '1' and
users.domain_id=domains.domain_id and users.sa_refuse > 0
MySQL query: select users.sa_refuse * 10 from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_spamassassin = '1' and users.domain_id=domains.domain_id and
users.sa_refuse > 0
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: 50
ditch_spam router skipped: condition failure
--------> ditch_hdrmailer router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id"
database lookup required for select count(*) from
blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and
blocklists.blockval = '' and users.localpart = 'marylene' and
domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrmailer router skipped: condition failure
--------> ditch_hdrto router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'to' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'to' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id"
database lookup required for select count(*) from
blocklists,users,domains where blocklists.blockhdr = 'to' and
blocklists.blockval = '' and users.localpart = 'marylene' and
domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'to' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrto router skipped: condition failure
--------> ditch_hdrfrom router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'from' and blocklists.blockval = '' and
users.localpart ='marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'from' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id"
database lookup required for select count(*) from
blocklists,users,domains where blocklists.blockhdr = 'from' and
blocklists.blockval = ''and users.localpart = 'marylene' and
domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'from' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrfrom router skipped: condition failure
--------> ditch_hdrsubject router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'subject' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'subject' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id"
database lookup required for select count(*) from
blocklists,users,domains where blocklists.blockhdr = 'subject' and
blocklists.blockval ='' and users.localpart = 'marylene' and
domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where
blocklists.blockhdr = 'subject' and blocklists.blockval = '' and
users.localpart = 'marylene' and domains.domain = 'marylenepro.com' and
domains.domain_id=blocklists.domain_id and
users.user_id=blocklists.user_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrsubject router skipped: condition failure
--------> virtual_vacation router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select users.on_vacation from users,domains where localpart =
'marylene' and domain = 'marylenepro.com' and users.on_vacation = '1'and
users.domain_id=domains.domain_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select users.on_vacation from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_vacation = '1' and users.domain_id=domains.domain_id"
database lookup required for select users.on_vacation from users,domains
where localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_vacation = '1' and users.domain_id=domains.domain_id
MySQL query: select users.on_vacation from users,domains where localpart
= 'marylene' and domain = 'marylenepro.com' and users.on_vacation= '1'
and users.domain_id=domains.domain_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
virtual_vacation router skipped: condition failure
--------> virtual_forward router <--------
local_part=marylene domain=marylenepro.com
checking "condition"
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select users.on_forward from users,domains where localpart =
'marylene' and domain = 'marylenepro.com' and users.on_forward = '1' and
users.domain_id=domains.domain_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select users.on_forward from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_forward = '1' and users.domain_id=domains.domain_id"
database lookup required for select users.on_forward from users,domains
where localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_forward = '1' and users.domain_id=domains.domain_id
MySQL query: select users.on_forward from users,domains where localpart
= 'marylene' and domain = 'marylenepro.com' and users.on_forward ='1'
and users.domain_id=domains.domain_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
virtual_forward router skipped: condition failure
--------> virtual_domains router <--------
local_part=marylene domain=marylenepro.com
calling virtual_domains router
rda_interpret (string): ${lookup mysql{select smtp from users,domains
where localpart = '${quote_mysql:$local_part}' and domain =
'${quote_mysql:$domain}' and domains.enabled = '1' and users.enabled =
'1' and users.domain_id = domains.domain_id}}
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select smtp from users,domains where localpart = 'marylene' and
domain = 'marylenepro.com' and domains.enabled = '1' and users.enabled =
'1' and users.domain_id = domains.domain_id" partial=-1 affix=NULL
starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select smtp from users,domains where localpart =
'marylene' and domain = 'marylenepro.com' and domains.enabled = '1'
andusers.enabled = '1' and users.domain_id = domains.domain_id"
database lookup required for select smtp from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
domains.enabled = '1' and users.enabled = '1' and users.domain_id =
domains.domain_id
MySQL query: select smtp from users,domains where localpart = 'marylene'
and domain = 'marylenepro.com' and domains.enabled = '1' and
users.enabled = '1' and users.domain_id = domains.domain_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: /var/spool/mail/marylenepro.com/marylene/Maildir
expanded: /var/spool/mail/marylenepro.com/marylene/Maildir
file is not a filter file
parse_forward_list: /var/spool/mail/marylenepro.com/marylene/Maildir
extract item: /var/spool/mail/marylenepro.com/marylene/Maildir
search_open: mysql "NULL"
  cached open
search_find: file="NULL"
  key="select users.sa_tag * 10 from users,domains where localpart =
'marylene' and domain = 'marylenepro.com' and users.on_spamassassin ='1'
and users.domain_id=domains.domain_id " partial=-1 affix=NULL
starflags=0
LRU list:
internal_search_find: file="NULL"
  type=mysql key="select users.sa_tag * 10 from users,domains where
localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_spamassassin = '1' and users.domain_id=domains.domain_id "
database lookup required for select users.sa_tag * 10 from users,domains
where localpart = 'marylene' and domain = 'marylenepro.com' and
users.on_spamassassin = '1' and users.domain_id=domains.domain_id
MySQL query: select users.sa_tag * 10 from users,domains where localpart
= 'marylene' and domain = 'marylenepro.com' and users.on_spamassassin =
'1' and users.domain_id=domains.domain_id
MYSQL using cached connection for
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
lookup yielded: 20
set transport virtual_delivery
virtual_domains router
generated /var/spool/mail/marylenepro.com/marylene/Maildir
  pipe, file, or autoreply
  errors_to=NULL transport=virtual_delivery
  uid=unset gid=unset home=NULL
routed by virtual_domains router
  envelope to: [email protected]
  transport: <none>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering /var/spool/mail/marylenepro.com/marylene/Maildir
[email protected]
-> /var/spool/mail/marylenepro.com/marylene/Maildir
  transport = virtual_delivery
search_tidyup called
close MYSQL connection:
localhost:(/var/lib/mysql/mysql.sock)/vexim/vexim
>>>>>>>>>>>>>>>> Exim pid=6607 terminating with rc=0 >>>>>>>>>>>>>>>>


So, You can see, no error there

Any ideas ?

Steven

_______________________________________________
Vexim mailing list
[email protected]
http://silverwraith.com/mailman/listinfo/vexim