Namespace configuration over SQL

[Steffen Kaiser]

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