Hello,

if your brave you may try , no idea if that might work

MFCMAPI

http://www.howto-outlook.com/howto/renamedefaultfolders.htm http://www.slipstick.com/outlook/rename-outlooks-default-folders/

thanks, the MFCMAPI way is working, but i'm afraid that only experienced users will have success.

i think about of moving all the special_folders stuff to userdb and let every user decide on its own. 2 reasons.

1: outlook 2013 and may be other clients only work correct if special_folders on server are autocreated (auto=subscribe). Even when adding the special_folders later manually, outlook 2013 would not use them for current account. i had to delete and recreate the account to get it work again. autocreate and subscription seems to be really needed. This folders may be annoying for users who dont use a "special_folders client".

2. if microsoft has choosen to not map local folders to serverfolders, i expect a lot of support effort to explain why folder names are like this. even if i decide to use german names on server, there will be complains by other users who wants to have there own preferred foldernames.

moving all this to a userdb lookup is really not in the purpose of rfc 6154, but seems to be for me the best compromise.

i dont know which way i will go, but already tried the userdb-thing. without suceess. I want to know if this will work from pure technical side and deside later to use or to discard this possibility.

A good way to do this seems to be the userdb_import field: http://wiki2.dovecot.org/UserDatabase/ExtraFields

i reduced the special_folders part in conf file to: namespace inbox { inbox = yes }

then i added text-field to my MySQL Table mail_users and inserted a text like this: namespace/inbox/hallohallo/auto=subscribe<TAB>namespace/inbox/hallohallo/special_use=\Sent

Also i edited the password_query (i use userdb prefetch)

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'

This results in no error but also no effect. Verbose logging did show a line like this:

Mar 25 13:16:49 myhostname dovecot: auth: Debug: master out: USER 3613786113 myuser home=/home/myuser uid=1004 gid=1000 namespace/inbox/hallohallo/auto=subscribe^Atnamespace/inbox/hallohallo/special_use=\Sent Looks not really bad, but is not working. What did i wrong? I would like to get this work to have a plan B.

Thanks, Hajo

Hello,

...

Also i edited the password_query (i use userdb prefetch)

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'

This results in no error but also no effect. Verbose logging did show a line like this:

Mar 25 13:16:49 myhostname dovecot: auth: Debug: master out: USER 3613786113 myuser home=/home/myuser uid=1004 gid=1000

namespace/inbox/hallohallo/auto=subscribe^Atnamespace/inbox/hallohallo/special_use=\Sent Looks not really bad, but is not working. What did i wrong? I would like to get this work to have a plan B.

See if it works without userdb prefetch? Possibly a bug..

Unfortunately not. I edited the sql.conf to:

password_query = SELECT inbox as username, 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'

Maillog says:

Mar 25 14:59:53 myhostname dovecot: auth-worker(16079): Debug: sql(myusername,ip.ip.ip.ip): SELECT inbox as user, password, home, uid, gid , userdb_import FROM mail_users WHERE login = 'myusername' AND active='Y' Mar 25 14:59:53 myhostname dovecot: auth: Debug: master out: USER 778960897 myusername password=<hidden> home=/home/myusername uid=1004 gid=1000 namespace/inbox/hallohallo/auto=subscribe namespace/inbox/hallohallo/special_use=\Sent

looks correct, login and reading mail works, but there is no folder autcreated etc. dovecot is 2.1.7

Thanks, Hajo

On 25.3.2013, at 16.28, Timo Sirainen tss@iki.fi wrote:

Looks like it fixed the TAB problem. So I guess I need to fix userdb_userdb_import.

Could you try if the attached patch fixes it?

Hello,

I also used your suggested userdb_import setting, but seems that i have no luck today. with and without prefetching there are no folders etc. autocreated.

now i have a partially success.

the autocreate works if mailbox hallohallo is basically created in conf file with special_use purpose:

namespace inbox { inbox = yes }

namespace inbox {

mailbox hallohallo { special_use = \Sent auto=no }

}

userdb_import: namespace/inbox/mailbox=hallohallo namespace/inbox/mailbox/hallohallo/auto=subscribe

In this case the settings from userdb_import override this part of conffile and folder hallohallo is autocreated and accepted by outlook 2013. (works only without prefetch) but my goal is to put also the special_use purpose per user to userdb. i reduced conf file to:

namespace inbox { inbox = yes }

now i extended userdb_import to:

namespace/inbox/mailbox=hallohallo namespace/inbox/mailbox/hallohallo/special_use=\Sent namespace/inbox/mailbox/hallohallo/auto=subscribe

At this point nothing happens. there is no folder autocreated and telnet session shows no special_use folder. Is there a possibility to put the complete special_folders config to userdb?

Thanks, Hajo

On 25.3.2013, at 17.14, Hajo Locke hajo.locke@gmx.de wrote:

...

Looks like it fixed the TAB problem. So I guess I need to fix userdb_userdb_import.

...

Could you try if the attached patch fixes it?

i added the patch and did build my packages. sql.conf i switched back to prefetch. Log looks like:

Mar 25 16:01:55 myhostname dovecot: auth: Debug: prefetch(myusername,ip.ip.ip.ip,<Bsf0FcHYGgBVDY8B>): success Mar 25 16:01:55 myhostname dovecot: auth: Debug: master out: USER 3357409281 myusername home=/home/myusername uid=1004 gid=1000 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.

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

Am 25.03.2013 14:36, schrieb Hajo Locke:

Hello,

...

if your brave you may try , no idea if that might work

...

MFCMAPI

...

http://www.howto-outlook.com/howto/renamedefaultfolders.htm http://www.slipstick.com/outlook/rename-outlooks-default-folders/

thanks, the MFCMAPI way is working, but i'm afraid that only experienced users will have success.

however you are "the man" who tried it, thx

i think about of moving all the special_folders stuff to userdb and let every user decide on its own. 2 reasons.

your choice, i would not use outlook at all, its simply not a good internet mail client in fact it is the client of exchange.

Alternative imternet mail clients are "good enough" now, if sombody likes outlook he better should use it with exchange

1: outlook 2013 and may be other clients only work correct if special_folders on server are autocreated (auto=subscribe). Even when adding the special_folders later manually, outlook 2013 would not use them for current account.

yes, you need to setup new profile then, thats how outlook 2013 works

i had to delete and recreate the account to

get it work again. autocreate and subscription seems to be really needed. This folders may be annoying for users who dont use a "special_folders client".

not to my knowledge, most users are on thunderbird, apple mail , k9 etc since yet ,nobody phoned me here *g, after all, most imap clients without "special folders features" still autocreate their meaning of special folder via imap auto by itselves, and that will stay that way until everyone has upgraded to clients with "special folders features" so this means perhaps never *g

2. if microsoft has choosen to not map local folders to serverfolders, i expect a lot of support effort to explain why folder names are like this. even if i decide to use german names on server, there will be complains by other users who wants to have there own preferred foldernames.

Microsoft has choosen to earn money with cloud outlook.com services and on exchange, the have no prime interest in imap

however outlook 2013 does active sync too, as anounced new horde webmail will be full compatible to outlook 2013 active sync version, so for one account minimum you will have mail , kalendar, abook, notes etc in sync , no need for direct imap in outlook 2013 then

moving all this to a userdb lookup is really not in the purpose of rfc 6154, but seems to be for me the best compromise.

i dont know which way i will go, but already tried the userdb-thing. without suceess. I want to know if this will work from pure technical side and deside later to use or to discard this possibility.

A good way to do this seems to be the userdb_import field: http://wiki2.dovecot.org/UserDatabase/ExtraFields

i reduced the special_folders part in conf file to: namespace inbox { inbox = yes }

then i added text-field to my MySQL Table mail_users and inserted a text like this: namespace/inbox/hallohallo/auto=subscribe<TAB>namespace/inbox/hallohallo/special_use=\Sent

Also i edited the password_query (i use userdb prefetch)

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'

This results in no error but also no effect. Verbose logging did show a line like this:

Mar 25 13:16:49 myhostname dovecot: auth: Debug: master out: USER 3613786113 myuser home=/home/myuser uid=1004
gid=1000 namespace/inbox/hallohallo/auto=subscribe^Atnamespace/inbox/hallohallo/special_use=\Sent

Looks not really bad, but is not working. What did i wrong? I would like to get this work to have a plan B.

as Timo wrote perhaps a bug

Thanks, Hajo

Best Regards MfG Robert Schetterer

-- [*] sys4 AG

http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München

Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Joerg Heidrich