[Dovecot] Change mail_location for one user?

[Steffen]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Charles Marcus wrote:
> On 2013-09-13 2:40 AM, Steffen Kaiser
> <skdovecot at smail.inf.fh-brs.de> wrote:
>> Because Dovecot supports multiple userdb's, you could add a 
>> passwd-file userdb _before_ passwd userdb, copy the line of sarah
>> from /etc/passwd into that new file and add the extra fields
>> there. See http://wiki2.dovecot.org/AuthDatabase/PasswdFile
>> 
>> userdb { driver = passwd-file args = username_format=%n
>> /etc/dovecot/imap.passwd } userdb { driver = passwd }
> 
> This looks very interesting to me...
> 
> I've been contemplating slowly converting users (one at a time)
> over to SIS storage - looks like this would work for doing that
> too?
> 
> The main thing holding me back is/was the MySQL DB I use for
> userdb doesn't natively/easily support extra fields - so, with this
> method, I could add a passwd-file userdb with the extra field(s)
> *before* my passwd userdb, then add the users to convert one by
> one, then once all are converted, change the main config and
> eliminate the temporary userdb... ?

You can do so. Dovecot really does not care where the user data comes
from.

But, I wonder why you would need the extra DB with mySQL.

a) You can add new fields to the DB on the fly at runtime and adjust
the query in Dovecot and reload.

b) http://wiki2.dovecot.org/UserDatabase/ExtraFields; make use of
"userdb_import" - generic field with <TAB> delimited settings.

- -- 
Steffen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQEVAwUBUjNptV3r2wJMiz2NAQJkhwf+N/nOtUb+9UtwvtF4evMvnHkfv1Ciw6c8
QLKgJV/+QoOpUiM+YVbzFCAWfofL4sTOqoV+G/s9c5RKDbCwDn/MbgP1hQ+TRx0h
vE+lL0RbTTdkRGUCoOkuA6BIggPdfp4VmNZLlOsXldfjnhZ8r76NNKko5wzRdp7K
oSdt3XEE2wg9+hrCq4IYLSG2rN8rnklaY0v1A38oO75Xx0i3XDxQnkxvtlsvFJ8k
X4L829hIrZ7+MIo4M6qFd01Ef7xP/oBYFEMW7ByEZs92ERJiM8WrB2h31U5VhFEY
iBYwiabjcXAhNheK98RZvKiIH7DYzOZXvfd7GGLdGEsZ1qfcLOt8Aw==
=oRmK
-----END PGP SIGNATURE-----