Re: [afnog] exim configuration file syntax.

[Patrick Okui <pokui at one2net.co.ug>]

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