Le 23 juil. 2013 à 02:41, Cedric a écrit :
> Hi,
>
> Ok thank for the interpretation, we used sendmail the last 16 years and I'm
> trying to migrate a old linuxconf/imapd setup here.
> [...]
> Below i provided two differents sql attempt, your input on how to make
> dovecot lda understand it should deliver the mail to the correct file are
> welcome
> [...]
> There's a new debug output fixing the domain entry
>
> The querry i pasted seem to be wrong for a previous configuration there's the
> correct one :
>
> [...]
> *************************** 1. row ***************************
> user: cedr...@mail.vdl
> username: cedrict
> domain: mail.vdl
> home: /vhome/mail.vdl/home/cedrict
> index: /vhome/mail.vdl/home/cedrict/mail/index
> control: /vhome/mail.vdl/home/cedrict/mail/control
> inbox: /var/spool/vmail/mail.vdl/cedrict
> layout: maildir++
> uid: 60001
> gid: 231
>
> [...]
> *************************** 1. row ***************************
> user: cedr...@mail.vdl
> inbox: /var/spool/vmail/mail.vdl/cedrict
> home: /vhome/mail.vdl/home/cedrict
> uid: 60001
> gid: 231
> 1 row in set (0,54 sec)
>
> [...]
Hello Cédric,
In both cases, your queries provide sufficient info for overriding or for
providing a full substitute to mail_home (left empty in your dovecot.conf), but
fail to do the same for mail_location.
Perhaps could you try something like this:
SELECT
concat(
s_courriel_utilisateur.utilisateur,
'@',
s_courriel_domaine.nom
) AS user,
concat(
'mbox:~/mail:LAYOUT=maildir++:INDEX=MEMORY:CONTROL=~/mail/control:INBOX=/var/spool/vmail/',
s_courriel_domaine.nom,
'/',
s_courriel_utilisateur.utilisateur
) AS mail,
concat(
"/vhome/",
s_courriel_domaine.nom,
"/home/",
s_courriel_utilisateur.utilisateur
) AS home,
s_courriel_utilisateur.uid AS uid,
s_courriel_domaine.gid AS gid
FROM
[...]
Not sure whether you still need the "AS user" part, but it should not hurt with
such a query.
More info at:
http://wiki2.dovecot.org/UserDatabase
http://wiki2.dovecot.org/AuthDatabase/SQL
HTH,
Axel
