[Dovecot] Virtual plugin and user_query

[Arthur Titeica]

Hello,

As per a previous reply regarding POP3 I'm now trying to configure the
virtual plugin.

However I don't really understand how to modify the sql user_query to
properly indicate inbox=yes.

I created 3 namespaces as per wiki instructions and I've modified the
password and user queries as bellow:

password_query = \
    SELECT email, password, login , concat('*:bytes=', quota) \
    AS userdb_quota_rule, \
    CASE '%s' WHEN 'pop3' THEN NULL ELSE 'yes' \
    END AS namespace_1_inbox, \
    CASE '%s' WHEN 'pop3' THEN 'yes' ELSE NULL \
    END AS namespace_2_inbox \
    FROM users \
    WHERE email = '%u' AND login = 'active'

user_query = SELECT \
    concat('*:bytes=', quota) AS quota_rule, \
    CASE '%s' WHEN 'pop3' THEN NULL ELSE 'yes' \
    END AS namespace_1_inbox, \
    CASE '%s' WHEN 'pop3' THEN 'yes' ELSE NULL \
    END AS namespace_2_inbox \
    FROM users \
    WHERE email = '%u'

After that all I get in the logs is:

IMAP(arthur at psw.ro): Error: namespace configuration error: inbox=yes
namespace missing
IMAP(arthur at psw.ro): Fatal: Namespace initialization failed

As I don't really understand those case sql queries is there something I
should add in the mysql tables?

Any thoughts will be greatly appreciated.

Thanks!