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
pgp00000.pgp
Description: PGP signature