[exim] Unrouteable address ERROR-3

トップ ページ
このメッセージを削除
このメッセージに返信
著者: oleg
日付:  
To: exim-users
題目: [exim] Unrouteable address ERROR-3
---------------------------- Original Message ----------------------------
Subject: Re: [exim] Unrouteable address ERROR]
From:    "Magnus Holmgren" <holmgren@???>
Date:    Thu, May 4, 2006 5:59 pm
To:      exim-users@???
--------------------------------------------------------------------------


Thursday 04 May 2006 16:29 skrev oleg@???:
> Well Magnus, i wish i can test all by myself, but it is a working

server, and my users will kill me, if i startt testing. I just tried to
make union queries in mysql and it didnt work, i guess some syntax
errors ..How do a join 2 lookups with exim not with mysql, i tried as
from an example, joining by "/"
>
> data = ${lookup mysql{SELECT sendto FROM aliases \
>           WHERE (username='$local_part' AND domainname='$domain') \ OR

(username='*' AND domainname='$domain')}}/
>         ${lookup mysql{ SELECT id FROM users \
>          WHERE id='${quote_mysql:${local_part}@${domain}}' }}

>
> but it gives an error( option setting expected). Searched in exim manual

dindn't find a single hint.

If that's copied exactly from your configuration, then the error message
is due to the fact that you didn't end the third line with "\".

However, items in the redirection data must be separated by commas or
newlines, as stated in section 22.4 of the spec.

I was thinking more along the lines of

virtual_user_or_alias:
  driver = redirect
  allow_fail
  allow_defer
  data = ${lookup mysql{ SELECT maildir FROM users \
          WHERE id='${quote_mysql:${local_part}@${domain}}' }} \n\
         ${lookup mysql{SELECT sendto FROM aliases \
          WHERE (username='$local_part' AND domainname='$domain') \ OR
(username='*' AND domainname='$domain')}}
  file_transport = address_file
  pipe_transport = address_pipe
  directory_transport = address_directory


but I don't know what Exim would say about empty lines. This data setting
could also work (assuming MySQL 4.0 or later):

  data = ${lookup mysql{ SELECT maildir FROM users \
          WHERE id='${quote_mysql:$local_part@$domain}'  \
          UNION SELECT sendto FROM aliases \
          WHERE (username='${quote_mysql:$local_part}' AND \
          domainname='${quote_mysql:$domain}') \
          OR (username='*' AND domainname='${quote_mysql:$domain}')}}
---------------------------------------
Well what can i say, it works!! thanks a lot. I managed the aliases to
generate also the real addresses like in one of the options you said.
Something like that:


mysql_aliases:
  driver = redirect
  file_transport = address_file
  pipe_transport = address_pipe
  data = ${lookup mysql{SELECT sendto FROM aliases \
          WHERE (username='$local_part' AND domainname='$domain') \
          OR (username='*' AND domainname='$domain')}}\n \
          ${lookup mysql{ SELECT id FROM users \
          WHERE id='${quote_mysql:${local_part}@${domain}}' }}


virtual_user:
  driver = redirect
  allow_fail
  allow_defer
  data = ${lookup mysql{ SELECT maildir FROM users \
          WHERE id='${quote_mysql:${local_part}@${domain}}' }}
  directory_transport = address_directory


Actually i think it doesn't make sens to make the second
search(mysql_aliases) it is obviously the ${local_part}@${domain}} answer.
Maybe i can append it somehow,

  data = ${lookup mysql{SELECT sendto FROM aliases \
          WHERE (username='$local_part' AND domainname='$domain') \
          OR (username='*' AND domainname='$domain')}}\n \
          :${local_part}@${domain}}
???
anyway it works..thanks !!


Oleg R.