Trying to figure out the syntax to set a mail_location for SQL. This
doesn't work:
userdb {
driver = sql
args = /etc/dovecot/master-combined-sql.conf
override_fields =
mail_location=maildir:/fakedir/%d/%n:INBOX=/fakedir:LAYOUT=fs
}
Does anyone know the proper syntax?
Thanks in advance
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, 19 May 2014, Marc Perkel wrote:> Trying to figure out the syntax to set a mail_location for SQL. This doesn't > work: > > userdb { > driver = sql > args = /etc/dovecot/master-combined-sql.conf > override_fields = > mail_location=maildir:/fakedir/%d/%n:INBOX=/fakedir:LAYOUT=fs > } > > Does anyone know the proper syntax?http://wiki2.dovecot.org/AuthDatabase/SQL#User_database_lookups It's the "mail" field. You configured the reverse case: http://wiki2.dovecot.org/UserDatabase?highlight=%28override_fields%29 - -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQEVAwUBU3r553z1H7kL/d9rAQL87gf/b7+5vsp3eHcmqbqwrpSQXn8OElg3rpb+ wa/ym3NOBv3neiDFIW+VuOuYvuS8pddjvmpf+SLSDfuqPbDnLZ6WD1dJ9e6RMLT+ FCqw720HUrKJ2gra0i9yQZcskXEOIL23pz8p+9jf4vibHsTUJ47VKFPjV15mSB7Z TKmXG960cKdXcdeP1SndxwF735ZC6QVlJ2fQWdwsLOA0gQUFsfO+UQY/cfJiWLKZ omt0nIj2RduXZUDJoG9s+5UtXRJck4SC0oqXdmAebPYnJB+1H+vpdY1tscItD7GN EuQCouev2L0m4LIGpvrhyOoZy2/Xsh/U+wQDB6tJYrBZlZom1L3pOA==oXX4 -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, 19 May 2014, Marc Perkel wrote:> Trying to figure out the syntax to set a mail_location for SQL. This doesn't > work: > > userdb { > driver = sql > args = /etc/dovecot/master-combined-sql.conf > override_fields = > mail_location=maildir:/fakedir/%d/%n:INBOX=/fakedir:LAYOUT=fs > } > > Does anyone know the proper syntax?http://wiki2.dovecot.org/AuthDatabase/SQL#User_database_lookups It's the "mail" field. You configured the reverse case: http://wiki2.dovecot.org/UserDatabase?highlight=%28override_fields%29 - -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQEVAwUBU3r553z1H7kL/d9rAQL87gf/b7+5vsp3eHcmqbqwrpSQXn8OElg3rpb+ wa/ym3NOBv3neiDFIW+VuOuYvuS8pddjvmpf+SLSDfuqPbDnLZ6WD1dJ9e6RMLT+ FCqw720HUrKJ2gra0i9yQZcskXEOIL23pz8p+9jf4vibHsTUJ47VKFPjV15mSB7Z TKmXG960cKdXcdeP1SndxwF735ZC6QVlJ2fQWdwsLOA0gQUFsfO+UQY/cfJiWLKZ omt0nIj2RduXZUDJoG9s+5UtXRJck4SC0oqXdmAebPYnJB+1H+vpdY1tscItD7GN EuQCouev2L0m4LIGpvrhyOoZy2/Xsh/U+wQDB6tJYrBZlZom1L3pOA==oXX4 -----END PGP SIGNATURE-----
Is there any way to do it without modifying the MySQL database? I want to force it it maildir:/fakedir/%d/%n for this userdb only. Other userdb has a different value. On 5/19/2014 11:44 PM, Steffen Kaiser wrote:> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Mon, 19 May 2014, Marc Perkel wrote: > >> Trying to figure out the syntax to set a mail_location for SQL. This >> doesn't work: >> >> userdb { >> driver = sql >> args = /etc/dovecot/master-combined-sql.conf >> override_fields = >> mail_location=maildir:/fakedir/%d/%n:INBOX=/fakedir:LAYOUT=fs >> } >> >> Does anyone know the proper syntax? > > http://wiki2.dovecot.org/AuthDatabase/SQL#User_database_lookups > It's the "mail" field. You configured the reverse case: > http://wiki2.dovecot.org/UserDatabase?highlight=%28override_fields%29 > > - -- Steffen Kaiser > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iQEVAwUBU3r553z1H7kL/d9rAQL87gf/b7+5vsp3eHcmqbqwrpSQXn8OElg3rpb+ > wa/ym3NOBv3neiDFIW+VuOuYvuS8pddjvmpf+SLSDfuqPbDnLZ6WD1dJ9e6RMLT+ > FCqw720HUrKJ2gra0i9yQZcskXEOIL23pz8p+9jf4vibHsTUJ47VKFPjV15mSB7Z > TKmXG960cKdXcdeP1SndxwF735ZC6QVlJ2fQWdwsLOA0gQUFsfO+UQY/cfJiWLKZ > omt0nIj2RduXZUDJoG9s+5UtXRJck4SC0oqXdmAebPYnJB+1H+vpdY1tscItD7GN > EuQCouev2L0m4LIGpvrhyOoZy2/Xsh/U+wQDB6tJYrBZlZom1L3pOA=> =oXX4 > -----END PGP SIGNATURE----- > > >