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@psw.ro): Error: namespace configuration error: inbox=yes namespace missing IMAP(arthur@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!