[Dovecot] Per user Namespaces From SQL

[Robert Schetterer]

Am 26.05.2011 00:44, schrieb Henrique Fernandes:
> Hello folks, i am lookign in the wiki, but did not find anything very clear
> about what i want.
> 
> I need to have namespace for each user from mysql. But like, i need all
> configruation comming from mysql, not only the location.
> 
> Is that possible?
> 
> here: http://wiki2.dovecot.org/Namespaces
> at section:
> Per-user Namespace Location From SQLI can set the location, is there an way
> to make everything ? Like the name of namespace, and etc ?
> 
> Thanks to all!
> 
> []'sf.rique
> 

there is a example with sql and virtual plugin namespace
perhaps you can use as starting point to modify to your needs

http://wiki2.dovecot.org/Plugins/Virtual

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

-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria