Sorry, using NULL indeed works correctly. My previous test with NULL was little bit flawed.
Thanks for help!
Ain
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
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?
namespace default { inbox = yes list = yes prefix = separator = . type = private }
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux)
iQEVAwUBVCVjsXz1H7kL/d9rAQL9GggAuK7ad919SVY/7YV0EDEtiZW6psgHclqs P/oI5o6ycX2C/MkREo9QeDuo68S12jt7H4fvewJ+MgVkUS7FtO8KUeKj5QD6FzKZ bi5mDwnamO8+4fgmO74iGPv2u1pp2E+SS8wPreiVxyZWU/zcM4BrlMJf0JFVk+f7 f5CGrM91hCjWAFr8WSpYlb1m9gY4RG3crogs9c2kntmDY2kwEHcsDvElwf6rwGHk VW1mjxdLUY3wgXXSr8OBEvmWYBIIpTu8XHf3nOh5STbZXRMkdSRWPkftKTzPTmH4 13/xsKzmG6zWuwYHdROinXfCg/hmFg1l+6zsqU/jMAlDiAV6S3B71A== =6ewJ -----END PGP SIGNATURE-----