[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [afnog] exim configuration file syntax.
- To: afnog at afnog.org
- Subject: Re: [afnog] exim configuration file syntax.
- From: Patrick Okui <pokui at one2net.co.ug>
- Date: 10 Jul 2003 00:05:25 +0300
- Content-Transfer-Encoding: 7bit
- Content-Type: text/plain
- Delivered-To: afnog-archive at lists.eahd.or.ug
- Delivered-To: afnog at afnog.org
- In-Reply-To: <1057775843.20046.35.camel at delight.one2net.co.ug>
- List-Archive: <http://listserv4.cfi.co.ug/pipermail/afnog>
- List-Help: <mailto:afnog-request at afnog.org?subject=help>
- List-Id: The African Network Operators Group <afnog.afnog.org>
- List-Post: <mailto:afnog at afnog.org>
- List-Subscribe: <http://listserv4.cfi.co.ug/mailman/listinfo/afnog>,<mailto:afnog-request at afnog.org?subject=subscribe>
- List-Unsubscribe: <http://listserv4.cfi.co.ug/mailman/listinfo/afnog>,<mailto:afnog-request at afnog.org?subject=unsubscribe>
- Organization: One2Net (U) Ltd
- References: <1057775843.20046.35.camel at delight.one2net.co.ug>
- Sender: afnog-bounces at afnog.org
On Wed, 2003-07-09 at 21:37, Patrick Okui wrote:
> Hi all,
>
> I was looking at some weird software off
> http://www.ex-parrot.com/~chris/vmail-sql and their configs for exim
> include statements like....
>
> search_type = mysql
> query = "SELECT somestuff FROM somewhere"...
> ...
>
> is this supported in exim 4.x (if anyone has played around with this set
> of scripts).. or should I just go ahead and modify it to something
> like...
>
> data = ${lookup mysql{SELECT somestuff FROM somewhere...}}???
>
Ok, did the modifications, anyway, but I still have issues ... here's
what I have...(sorry for the wrapped lines...)..
-------<>--------------
## VMAIL STUFF
#
# The virtualemail database allows local parts to correspond to remote
# addresses (forwarding), to be aliases for local maildrops, or to be
local
# maildrops. These are expressed in tables forwarder and popbox
# respectively.
# Handle forwarders and aliases (same database table)
virtual_forward:
driver = redirect
data = ${lookup mysql{select remote_name from forwarder left join
domain_alias on domain_alias.domain_name = forwarder.domain_name where
local_part = '${quote_mysql:$local_part}' and (forwarder.domain_name =
'${quote_mysql:$domain}' or alias = '${quote_mysql:$domain}')}}
# Handle delivery; see sample config C009 for what this is based on; it
only
# handles things for the virtual domains, which are listed in the
database.
virtual_localuser:
driver = redirect
data =${lookup mysql{select mbox_name from popbox left join
domain_alias on domain_alias.domain_name = popbox.domain_name where
local_part = '${quote_mysql:$local_part}' and (popbox.domain_name =
'${quote_mysql:$domain}' or alias= '${quote_mysql:$domain}')} }
file_transport = virtual_localdelivery
pipe_transport = virtual_localdelivery
directory_transport = virtual_localdelivery
# deliver any undelivered virtual email according to the _default_
forwarder
virtual_defaultuser:
driver = redirect
data = ${lookup mysql{select remote_name from forwarder left join
domain_alias on domain_alias.domain_name = forwarder.domain_name where
local_part = '_default_' and (forwarder.domain_name =
'${quote_mysql:$domain}' or domain_alias.alias =
'${quote_mysql:$domain}')}}
-------<>--------------
and the transport is as follows...
-------<>--------------
# This transport is to deliver mail going to virtual domains to user
# mailspools in directories under /var/mail/foo/bar; this is
# triggered from a director below.
virtual_localdelivery:
driver = appendfile
maildir_format
create_directory
directory = ${lookup mysql{select path from domain left join
domain_alias on domain_alias.domain_name = domain.domain_name where
domain.domain_name = '${quote_mysql:$domain}' or domain_alias.alias =
'${quote_mysql:$domain}'}{$value}fail}/${lookup mysql{select mbox_name
from popbox left join domain_alias on popbox.domain_name =
domain_alias.domain_name where (popbox.domain_name =
'${quote_mysql:$domain}' or domain_alias.alias =
'${quote_mysql:$domain}') and local_part =
'${quote_mysql:$local_part}'}{$value}fail}/Maildir/
delivery_date_add
envelope_to_add
return_path_add
user = ${lookup mysql{select unix_user from domain left join
domain_alias on domain_alias.domain_name = domain.domain_name where
domain.domain_name = '${quote_mysql:$domain}' or domain_alias.alias =
'${quote_mysql:$domain}'}{$value}fail}
mode = 0660
-------<>--------------
but..
=== root at mail (/dev/ttyp2) /usr/local/etc/exim 23 -> exim -bv -C \
configure.vmail pokui at one2net.co.ug
pokui at one2net.co.ug cannot be resolved at this time:
domains check lookup or other defer
=== root at mail (/dev/ttyp2) /usr/local/etc/exim 24 ->
could someone p'se tell me what that error message means and what I
should check?, ... right now I'm so tired I'm heading straight home...
cheers,
Patrick.
> thanks,
> Patrick.
--
Patrick Okui <pokui at one2net.co.ug>
One2Net (U) Ltd
_______________________________________________
This is the afnog mailing list.
To send a message to this list, e-mail afnog at afnog.org
This list is maintained by owner-afnog at afnog.org