Re: [exim] Maildir, mysql database, and creating home dirs

Top Page
Delete this message
Reply to this message
Author: Bertrand CHERRIER
Date:  
To: exim-users
Subject: Re: [exim] Maildir, mysql database, and creating home dirs
Ooops I didn't read the subject ... so here it is for mysql ...

virtual_delivery:
  driver = appendfile
  envelope_to_add
  return_path_add
  mode = 0600
  maildir_format = true
  create_directory = true
  directory = ${lookup mysql{select smtp from users,domains \
                where localpart = '${quote_mysql:$local_part}' \
                and domain = '${quote_mysql:$domain}' \
                and users.domain_id = domains.domain_id}}
  user = ${lookup mysql{select users.uid  from users,domains \
                where localpart = '${quote_mysql:$local_part}' \
                and domain = '${quote_mysql:$domain}' \
                and users.domain_id = domains.domain_id}}
  group = ${lookup mysql{select users.gid from users,domains \
                where localpart = '${quote_mysql:$local_part}' \
                and domain = '${quote_mysql:$domain}' \
                and users.domain_id = domains.domain_id}}
  quota = ${lookup mysql{select users.quota from users,domains \
                where localpart = '${quote_mysql:$local_part}' \
                and domain = '${quote_mysql:$domain}' \
                and users.domain_id = domains.domain_id}{${value}M}}
  quota_is_inclusive = false
  quota_size_regex = ,S=(\d+)
  quota_warn_threshold = 90%
  maildir_use_size_file = true





Derrick MacPherson a écrit :

> Our exim config does not contain the create_directory for the
> appendfile driver yet I'm seeing in the debug out:
>
> ensuring maildir directories exist in /home/dlm/Maildir/
> created directory /home/dlm/Maildir/
> created directory /home/dlm/Maildir//tmp
> created directory /home/dlm/Maildir//new
> created directory /home/dlm/Maildir//cur
>
>
> 2 questions, how is this being created? It's being created with 700
> perms on the home dir, so the first mail gets delivered, but any mail
> after fails. I will try when the servers not so busy the
> directory_mode, I assume that will fix it, ya? If needed I'll post the
> config to people off list.
>


--
Bertrand CHERRIER
b.cherrier@???

MICRO LOGIC SYSTEMS
http://www.mls.nc
Vente & maintenance réseaux Informatique
Fournisseur de Sensations Internet
Service clientèle au 36.67.76 (58Frs/mn)

begin:vcard
fn:Bertrand CHERRIER
n:;Bertrand CHERRIER
org:Micro Logic Systems
adr;quoted-printable;quoted-printable:;;28, rue Felix Broche;Noum=C3=A9a;;98800;Nouvelle Cal=C3=A9donie
email;internet:b.cherrier@???
tel;work:249924
tel;fax:240990
note:Fournisseur de Sensations Internet
url:http://www.mls.nc
version:2.1
end:vcard