userdb username change ignored when using (My)SQL was: Re: userdb username changed

[Péter Márton]

Hi!

Can someone please tell me what is the difference between "auth" and
"auth-worker"? I mean the entries in the log.
For me it looks like "auth" would be a master process for authdb and
userdb lookups. But quota-status, and even lmtp are calling
auth-worker directly. Or?

Imap auth with mysql:
Apr 22 12:35:16 imap21 dovecot: auth-worker(21529): Debug:
sql(ppp at example.net,195.202.128.25): username changed ppp at example.net
-> uppp
Apr 22 12:35:16 imap21 dovecot: auth: Debug:
sql(ppp at example.net,195.202.128.25,<jp8LuE0UXADDyoAZ>): username
changed ppp at example.net -> uppp
Both processes(?) loop through the returned variables (with request.c
auth_request_set_userdb_field) , but only "auth" sets the "username"
successfully.

Imap auth with ldap:
Apr 22 13:17:55 imap21 dovecot: auth: Debug:
ldap(m2500j6,127.0.0.1,<WYiTUE4UngB/AAAB>): username changed m2500j6
-> uppp
Apr 22 13:17:55 imap21 dovecot: auth: Debug:
ldap(uppp,127.0.0.1,<WYiTUE4UngB/AAAB>): result: gidNumber=168
homeDirectory=/tmp mailHost=uppp
Only "auth", and username is successfully changed.

quota-status with mysql:
Apr 22 12:35:59 imap21 dovecot: auth-worker(21529): Debug:
sql(ppp at kabsi.at): username changed ppp at kabsi.at -> uppp
Apr 22 12:35:59 imap21 dovecot: auth: Debug: userdb out:
USER#0111#011ppp at kabsi.at#011home=/home/ppp#011uid=500#011gid=500#011quota_rule=*:storage=3100b:messages=1024#011login_user=uppp
Apr 22 12:35:59 imap21 dovecot: quota-status(ppp at kabsi.at): Debug:
auth input: ppp at kabsi.at home=/home/ppp uid=500 gid=500
quota_rule=*:storage=3100b:messages=1024 login_user=uppp
Only auth-worker is looping through the returned fields (single
"username changed" entry), and the username isn't changed.

quota-status with ldap:
Apr 22 13:25:14 imap21 dovecot: auth: Debug: ldap(m2500j6): user
search: base=ou=Users,ou=Mail,dc=bnet,dc=at scope=subtree
filter=(uid=m2500j6) fields=mailHost,gidNumber,homeDirectory
Apr 22 13:25:14 imap21 dovecot: auth: Debug: ldap(m2500j6): result:
gidNumber=168 homeDirectory=/tmp mailHost=uppp;
homeDirectory,mailHost,gidNumber unused
Apr 22 13:25:14 imap21 dovecot: auth: Debug: ldap(m2500j6): username
changed m2500j6 -> uppp
Apr 22 13:25:14 imap21 dovecot: auth: Debug: ldap(localhost): result:
gidNumber=168 homeDirectory=/tmp mailHost=uppp
Apr 22 13:25:14 imap21 dovecot: auth: Debug: userdb out:
USER#0111#011localhost#011gid=168#011home=/tmp
Apr 22 13:25:14 imap21 dovecot: quota-status(m2500j6): Debug: auth
input: uppp gid=168 home=/tmp
Apr 22 13:25:14 imap21 dovecot: quota-status(m2500j6): Debug: changed
username to uppp

Again! Only "auth", but username is changed. Even quota-status logs
the username change.


Thanks!

Peter