[exim] limiting database lookups

Góra strony
Delete this message
Reply to this message
Autor: Viljoen Danie
Data:  
Dla: 'exim-users@exim.org'
Temat: [exim] limiting database lookups


We currently do lookups from the database to determine if a user is valid,
and then use the same lookup to do the actual delivery:



Router:



virtual_domains:

driver = accept

transport = virtual_delivery

domains = lsearch;/usr/exim/virtual_domains

condition = ${lookup pgsql{select maildir from email_account where
id='$local_part@$domain'}{$value}fail}

cannot_route_message = No such user here

no_more



Transport:



virtual_delivery:

driver = appendfile

maildir_format

create_directory

mode = 0600

user = popuser

directory = ${lookup pgsql{select maildir from email_account where
id='$local_part@$domain'}{$value}fail}

delivery_date_add = true

envelope_to_add = true



Is there any way to use a single lookup to accomplish the same thing ?





This communication and any attachments thereto are intended solely for the
addressee/s and may be legally privileged and/or confidential. If you are
not the intended recipient, any form of reproduction, dissemination,
copying, disclosure, modification, distribution and / or publication of, or
any unauthorised action taken in regard to this message or its attachments
is prohibited and unlawful. If you have received this communication in error
please notify us immediately and kindly destroy the original communication
and any attachment thereto. Whilst all reasonable steps are taken to ensure
the integrity and accuracy of information and data transmitted
electronically, no liability or responsibility whatsoever is accepted if
information or data is, for whatever reason corrupted or does not reach its
intended destination.