[Dovecot] mysql query prepending
Marcus Rueckert
rueckert at informatik.uni-rostock.de
Sat Aug 5 04:40:05 EEST 2006
On 2006-08-04 13:57:44 -0700, Chris Cappuccio wrote:
> In postgresql you can do something like
>
> select 'maildir:' || maildir as mail, uid, ...
>
> through dovecot-sql.conf
>
> Is there a mysql equivalent for adding 'maildir:' as a prefix to the 'mail'
> location ?
[[[
user_query = SELECT concat('/some/path/', maildir) as home, concat('maildir:/some/other/path/', maildir) as mail, 12345 AS uid, 12345 AS gid FROM mailbox WHERE username = '%u'
]]]
darix
--
openSUSE - SUSE Linux is my linux
openSUSE is good for you
www.opensuse.org
More information about the dovecot
mailing list