wiki: Plugins/Virtual: SQL error?

[Larry Rosenman]

Is one of these supposed to be imap?

Note that none of the namespaces have inbox=yes. This is because for IMAP
users you want the inbox namespace to have inbox=yes, but for POP3 users
you want the virtual namespace to have inbox=yes. This requires setting the
inbox=yes in userdb extra fields
<http://wiki2.dovecot.org/UserDatabase/ExtraFields>. For example with MySQL
you can can do this like:

user_query = SELECT ..., \  CASE '%s' WHEN 'pop3' THEN NULL ELSE 'yes'
END AS 'namespace/inbox/inbox', \  CASE '%s' WHEN 'pop3' THEN 'yes'
ELSE NULL END AS 'namespace/virtual/inbox' \  WHERE ...


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640 (c)     E-Mail: larryrtx at gmail.com
US Mail: 17716 Limpia Crk, Round Rock, TX 78664-7281