Hi,
Thank you,it fixed the issue i had.
Regards Cedric
Le 2013-07-23 03:49, Axel Luttgens a écrit :
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:cedrict@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:cedrict@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