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!