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!