[Dovecot] Setting mail location in SQL?
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-----
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-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Tue, 20 May 2014, Marc Perkel wrote:
Please do not top post.
On 5/19/2014 11:44 PM, Steffen Kaiser wrote:
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
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.
The field is named "mail", not "mail_location".
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux)
iQEVAwUBU3xFX3z1H7kL/d9rAQLqNQf/WMVSkyGbpZRrOWsgDUkdX6rcQVQCbfwN roOlUygF8p30nYpDGqKSbvFxnYHH/Exar0vda5TFkxktgkgSPQuTgVmlxZl07ne3 oXN+B40U0+X62lqnB5NWZzlCxk3p81RUXzZpIKJNjBtGbm/5mmctbTn19ndcNDa3 PkQI5a7OoUJ0MmytYTrVZWWqGAgxS07M4Uwg2kYT5W81dT5aam1OhqRjgZkfrHfc +QOODcbw1j7EUNRSs3H6semtGb5Bylp5XqwY5O4pHhVH+v4DZehRNKhIg8Obqu6x Ia1CljCDkQaTmYlZXr5JE5JVggvlbmJD6g7A5Uo06SR6nAWf11bLPA== =2P4F -----END PGP SIGNATURE-----
participants (2)
-
Marc Perkel
-
Steffen Kaiser