-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Fri, 26 Sep 2014, Ain wrote:
There seems to be no way, in order to override a non-empty namespace/default/prefix with an empty value. My test system is Dovecot v2.2.13 (35c3194900b7), the current hg version.
See below for an example with SQL. Returning an empty string '' using SQL results into namespace/default/prefix=yes, the boolean string "yes" does replace the empty string returned by SQL. Using a NULL value, you can work around this, but in this the default value must be empty.
The applies to LDAP as well, I assume.
It definitly applies to userdb_import returned by LDAP, too: http://wiki2.dovecot.org/UserDatabase/ExtraFields?highlight=%28userdb_import...
The string:
namespace/default/prefix=<TAB>namespace/inbox/prefix
sets both namespace/default/prefix and namespace/inbox/prefix to 'yes'. The '=' does not matter.
====
Sorry, using NULL indeed works correctly. My previous test with NULL was little bit flawed.
On Thu, 25 Sep 2014, Ain wrote:
I had working setup, where namespace settings (including prefix) was queried over SQL. Now, after installing new Dovecot to new server (using same configuration), this is not working anymore.
Log shows following error:
""" Initialization failed: namespace configuration error: list=yes requires prefix=yes to end with separator """
relevant part from dovecot-sql.conf.ext: """ user_query =
SELECT
1002 AS uid
, 1003 AS gid
, CONCAT('/www/home/vmail/domains/', SUBSTRING(d.name, 1, 1), '/', d.name, '/', u.username) AS home
, namespace_prefix AS 'namespace/default/prefix'
, 'yes' AS 'namespace/default/inbox'
, '%s' AS 'mail_service'
FROM vm_domain d
INNER JOIN vm_user u ON u.vm_domain_id = d.id
WHERE d.name = '%d' AND u.username = '%n' AND u.active = 1 AND d.active = 1 """what do you return as namespace_prefix, NULL vs. '' ? Could you try the other value?
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux)
iQEVAwUBVCV13nz1H7kL/d9rAQLOUwgAneROV2VCx6kbckPo5+pP5VBh2CX6ns7B WD0QVb4/DdP+VcsGCYsKrNmrRA7UA+QMRzjEmpPD4M6UonhfzyrjfatUeTHvQFxC I96+9EPNImCSEujfEp7IvH/S9jebfxYCv23XbY4OQniw+CYHDqVucQ9uV/AEaAe2 OEBJwxP+RPnlVNxo4A9Pt4/GOpNcViCu8FeP74MoyGLyHpWrCqNocse8P1tKRSni gYTB7q2i29UhUfF/WFaaK1pR7sLG0TT1QJ0ZCOLtQMfQPQd8fPwRuxodCsVUDSU4 +IOzWFwQZU7LszSNN4mKetY/jMwW45eVggTIU0ThMuGP8kf4AQWD5w== =L1Qz -----END PGP SIGNATURE-----