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