Hello,
Also i edited the password_query (i use userdb prefetch)
password_query = SELECT
inbox
asuser
,password
,home
as userdb_home,uid
AS userdb_uid,gid
AS userdb_gid, userdb_import as userdb_userdb_import FROMmail_users
WHERElogin
= '%u' ANDactive
='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