[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Anyone running Exim 3.3x + Mysql Virtual users?



On Wed, Jul 02, 2003 at 08:24:32AM -0500, Dustin Douglas wrote:
> Example: 
> This is from an exim 4.x config
> 
> mysqluser:
>   driver = accept
>   condition = ${if eq{} {${lookup mysql {SELECT username FROM users
> WHERE username='$local_part' AND domainname='$domain' AND
> status='1'}}}{no}{yes}} 
>  transport = local_delivery 
>
> What would this look like in Exim 3.x?

I use this:

vuser_forward:
  driver = forwardfile
  check_local_user = false
  check_ancestor
  forbid_file
  forbid_include
  forbid_pipe
  user = mail
  group = mail
  data = ${lookup mysql {SELECT forward FROM vusers WHERE user='${sg {$local_part}{'}{}}' AND forward != '' AND status = '1';} {$value} fail}


virtual_user:
  driver = aliasfile
  file_transport = address_file
  directory_transport = address_directory
  pipe_transport = address_pipe
  search_type = mysql
  query = SELECT CONCAT(maildir, '/') FROM vusers WHERE user = '${sg {$local_part}{'}{}}' AND maildir != '' AND status = '1';
  user = mail
  group = mail


If the query fails the directors don't match and exim goes on to the next.
HTH,

Vinai
-- 
Secure eMail with gnupg: See http://www.gnupg.org/

Please avoid sending me Word, Excel or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html


Attachment: pgp7NeWPjRMYW.pgp
Description: PGP signature


Reply to: