Philip Hazel schrieb:
>
> On Mon, 24 Dec 2001, Torsten Mueller wrote:
>
> > but:
> > mail to infó@domain.de goes to the spoolfile
> > /var/spool/mail/domain.de/infó
> >
> > note: there doesn't exists an account infó (don't know if
> > you can see the "ó", it's
> > an french o i think).
>
> You didn't post your director configuration. Or the output of a -d9 Exim
> test. Either of those might have given us more information as to why
> Exim was accepting the message.
>
> What is the output of
>
> exim -d9 -bt infó@domain.de
Sorry, here is the output:
exim -d9 -bt infó@bloopark.de
Exim version 3.31 debug level 9 uid=0 gid=0
Berkeley DB: Sleepycat Software: DB 2.4.14: (6/2/98)
Caller is an admin user
Caller is a trusted user
originator: uid=0 gid=0 login=root name=root
sender address = root@???
Address testing: uid=0 gid=0 euid=502 egid=102
>>>>>>>>>>>>>>>>>>>>>>>>
Testing infó@bloopark.de
search_open: mysql "NULL"
search_find: file="NULL"
key="SELECT DISTINCT domain FROM mail WHERE
domain='bloopark.de'" partial=-1
LRU list:
internal_search_find: file="NULL"
type=mysql key="SELECT DISTINCT domain FROM mail WHERE
domain='bloopark.de'"
database lookup required for SELECT DISTINCT domain FROM
mail WHERE domain='bloopark.de'
MYSQL query: SELECT DISTINCT domain FROM mail WHERE
domain='bloopark.de'
MYSQL new connection: host=localhost port=0
database=popaccounts user=xxxxxx password=xxxxxx
lookup yielded: bloopark.de
bloopark.de in local_domains? yes (matched mysql;SELECT
DISTINCT domain FROM mail WHERE domain='$key')
bloopark.de in percent_hack_domains? no (end of list)
address infó@bloopark.de
local_part=infó domain=bloopark.de
domain is local
>>>>>>>>>>>>>>>>>>>>>>>>
directing infó@bloopark.de
bloopark.de in "essenjetzt.de"? no (end of list)
essenjetztnewservicebouncer director skipped: domain
mismatch
bloopark.de in "essenjetzt.de"? no (end of list)
essenjetztempfehlungsmailbouncer director skipped: domain
mismatch
bloopark.de in "gratisdns.de"? no (end of list)
gratisdnsanmeldungsbouncer director skipped: domain mismatch
bloopark.de in "localhost"? no (end of list)
system_aliases director skipped: domain mismatch
bloopark.de in "localhost"? no (end of list)
userforward director skipped: domain mismatch
bloopark.de in "localhost"? no (end of list)
localuser director skipped: domain mismatch
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT DISTINCT domain FROM mail WHERE domain LIKE
'bloopark.de' AND username LIKE 'infó' AND is_alias='no'"
partial=-1
LRU list:
internal_search_find: file="NULL"
type=mysql key="SELECT DISTINCT domain FROM mail WHERE
domain LIKE 'bloopark.de' AND username LIKE 'infó' AND
is_alias='no'"
database lookup required for SELECT DISTINCT domain FROM
mail WHERE domain LIKE 'bloopark.de' AND username LIKE
'infó' AND is_alias='no'
MYSQL query: SELECT DISTINCT domain FROM mail WHERE domain
LIKE 'bloopark.de' AND username LIKE 'infó' AND
is_alias='no'
MYSQL using cached connection for
localhost/popaccounts/xxxxxxxx/xxxxxxxxxx
lookup yielded: bloopark.de
bloopark.de in "bloopark.de"? yes (matched bloopark.de)
calling virtual_local_user director
virtual_local_user director called for infó@bloopark.de
queued for virtual_delivery transport: local_part=infó
domain=bloopark.de
errors_to=NULL
domain_data=NULL local_part_data=NULL
virtual_local_user director succeeded for infó
infó@bloopark.de
deliver to infó in domain bloopark.de
director = virtual_local_user, transport =
virtual_delivery
search_tidyup called
close MYSQL connection:
localhost/popaccounts/xxxxxxxx/xxxxxxxxx
TRANSPORTS CONFIGURATION:
virtual_delivery:
driver = appendfile
file =
/var/spool/mail/virtual_mail/${domain}/${local_part}
user = exim
group = exim
mode = 0660
DIRECTORS CONFIGURATION:
# Check if user is a real user in mysql database
virtual_local_user:
domains = ${lookup mysql {MYSQL_USER}{$value}}
driver = smartuser
transport = virtual_delivery
# Check if user is an alias in mysql database
virtual_aliases:
driver = aliasfile
search_type = mysql
query = MYSQL_ALIAS
include_domain = true
# Check for wild card match '@'@domain in mysql database
virtual_all_alias:
driver = aliasfile
search_type = mysql
query = MYSQL_ALL_ALIAS
include_domain = true
> > In my opinion it's a mysql problem, cause mysql should say :
> > user infó doesn't exist.
>
> But your Exim configuration needs to be able to recognize that. Without
> seeing it, we can't say if it should accept the message or not.
>
> > The mysql part in configure looks like this:
> >
> > MYSQL_ALIAS = SELECT MYSQL_ALIASFIELD FROM MYSQL_AUTHTABLE
> > WHERE MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND
> > MYSQL_USERNAMEFIELD LIKE '${quote_mysql:$local_part}' AND
> > MYSQL_ISALIASFIELD='yes'
> > MYSQL_ALL_ALIAS = SELECT MYSQL_ALIASFIELD FROM
> > MYSQL_AUTHTABLE WHERE
> > MYSQL_DOMAINFIELD='${quote_mysql:$domain}' AND
> > MYSQL_USERNAMEFIELD='@' AND MYSQL_ISALIASFIELD='yes'
> > MYSQL_USER = SELECT DISTINCT MYSQL_DOMAINFIELD FROM
> > MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD LIKE
> > '${quote_mysql:$domain}' AND MYSQL_USERNAMEFIELD LIKE
> > '${quote_mysql:$local_part}' AND MYSQL_ISALIASFIELD='no'
> > MYSQL_DOMAIN = SELECT DISTINCT MYSQL_DOMAINFIELD FROM
> > MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD='$key'
>
> That's no help without the details of how those values are used.
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
