{"id":1004,"date":"2012-05-10T12:34:01","date_gmt":"2012-05-10T12:34:01","guid":{"rendered":"http:\/\/blog.designed79.co.uk\/?p=1004"},"modified":"2012-05-10T12:49:05","modified_gmt":"2012-05-10T12:49:05","slug":"roundcube-dovecot-imap-and-case-sensitive-user-names","status":"publish","type":"post","link":"https:\/\/blog.designed79.co.uk\/?p=1004","title":{"rendered":"Roundcube, Dovecot IMAP and case sensitive user names"},"content":{"rendered":"

Do your mail users like it to use mixed upper\/lower case in user names? So the problem described below may hit you.<\/span><\/h2>\n
\n
\n

Your mail user is known to the system as\u00a0user.name@domain.tld<\/em>. The user itself knows himself asUser Name<\/em>\u00a0so he naturally (it seems) uses\u00a0User.Name@domain.tld<\/em>\u00a0when logging in to the\u00a0Roundcube<\/a>\u00a0webmail page. Roundcube does not care much and saves\u00a0User.Name@domain.tld<\/em>\u00a0to it’s internal data base.<\/p>\n

It tries to connect to the Dovecot IMAP server and gets a\u00a0a001 NO Authentication failed.<\/em>\u00a0back. Dovecot indeed cares about the case. When trying to use the lower case variantuser.name@domain.tld<\/em>\u00a0Roundcube still seems to use the former mixed case variant it already saved for connecting to the IMAP server.<\/p>\n

To make it easy for your users just configure Dovecot to convert user names to lower case before looking it up in the system. Set this variable in\u00a0\/etc\/dovecot\/dovecot.conf<\/em>:<\/p>\n

auth_username_format =\u00a0%Lu<\/div><\/div>\n

And restart Dovecot.<\/p>\n

Note :<\/p>\n

I stumbled upon the same problem in our rc 0.5 installation. Unless
\nyou have some weird imap server that requires case sensitive usernames
\nyou *should* set $rcmail_config[‘login_lc<\/strong>‘] to “true”. If you don’t
\nthen some of your users will use an upper\/lower case combination for
\ntheir username the first time they try to login and then they would
\nhave to stick with it or else will fail to login successfully with an
\nerror message like:<\/p>\n

MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could
\nnot execute statement]
\n[Last executed query: EXECUTE
\nmdb2_statement_mysql_59ee766a0fe6d6645f1d52ec743dc1adb66c4b2e3 USING
\n@0, @1, @2, @3]
\n[Native code: 1062]
\n[Native message: Duplicate entry ‘user10-mail.server.tld’ for key ‘username’]<\/p>\n

After setting\u00a0login_lc<\/strong>\u00a0to true you would probably have to clean up the
\nusers table and make sure that all username entries are in lower case.<\/p>\n

RC developers, consider setting the default value of\u00a0login_lc<\/strong>\u00a0to true
\nor at least add it to the installer page with a proper notice.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Do your mail users like it to use mixed upper\/lower case in user names? So the problem described below may hit you. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1004","post","type-post","status-publish","format-standard","hentry","category-info-on-tech"],"_links":{"self":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1004","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1004"}],"version-history":[{"count":0,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1004\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}