Namespace configuration over SQL

[Ain]

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-----
>