On Sun, 2013-03-31 at 17:40 +0300, Timo Sirainen wrote:>> >
>> >
namespace/inbox/mailbox=hallohallo^Atnamespace/inbox/mailbox/hallohallo/auto=subscribe
>> >
>> > same line occurs when querying ...userdb_import as
userdb_import... in
>> > place of ...userdb_import as userdb_userdb_import.
>>
>> http://hg.dovecot.org/dovecot-2.1/rev/cd919c490ea6 makes
>> userdb_userdb_import work.
> Ugh. Not really. OK, latest v2.1 hg has passdb_import, userdb_import and
> userdb_userdb_import and they all work. In addition, here's a list of
> settings that are required for adding two new mailboxes without them
> being in the configuration:
> /usr/local/libexec/dovecot/imap -o 'namespace/inbox/mailbox=foo
bar' -o
> namespace/inbox/mailbox/foo/name=foo -o
> namespace/inbox/mailbox/bar/name=bar -o
> namespace/inbox/mailbox/foo/auto=create -o
> namespace/inbox/mailbox/bar/auto=create -o
> namespace/inbox/mailbox/foo/special_use=\\sent -o
> namespace/inbox/mailbox/bar/special_use=\\drafts
> That way you can easily test them. They work just the same (without -o
> parameter of course) in userdb_import.
thanks, this is working. now it is possible to let the single user choose
his favorite foldernames if client is not very helpful. it results in some
more configuration, but is helpful in some situations.
but i only achieved this without userdb prefetching. latest patch i added
latest patch http://hg.dovecot.org/dovecot-2.1/rev/cd919c490ea6 is included
this is the old combined query:
password_query = SELECT `inbox` as `user`, `password`, `home` as
userdb_home, `uid` AS userdb_uid, `gid` AS userdb_gid,userdb_import AS
userdb_userdb_import FROM `mail_users` WHERE `login` = '%u' AND
`active`='Y'
i had to edit the conf and split this query into user and pwd query to make
it work
password_query = SELECT `inbox` as `user`, `password` FROM `mail_users`
WHERE `login` = '%u' AND `active`='Y'
user_query = SELECT `inbox` as `user`, `password`, `home`, `uid`, `gid`,
userdb_import FROM `mail_users` WHERE `login` = '%u' AND
`active`='Y'
i would like to save one query at loginprocess, but its not existentially
needed.
Thanks,
Hajo