[Dovecot] %d empty even though username has @domain
hello,
Sorry to jump straight in with a question, but I've searched the
archive[0] and I'm pretty sure the answer's not there.
I'm using dovecot to replace courier imap, so authentication is by
vpopmail and the Maildirs are stored in the usual domains/domain/user/
Maildir. Everything seems to work very well, and setting it up has
been easy, so thank you very much for that.
I have only one problem left: %d is empty when interpolated into
default_mail_env. I expect there's something obvious I'm doing wrong,
but it's hard to tell because the wiki isn't always up to date (i'd
be happy to update the vpopmail sections once this is working):
Config has this [1]:
default_mail_env = maildir:/home/vpopmail/domains/%d/%n/Maildirand i log in over imaps with the account i'm using for testing:
username: sysadmin@spanner.org
password: ...Authentication seems to work perfectly, but then the logs show:
dovecot: Dec 05 12:24:59 Info: imap(sysadmin): maildir: root=/home/ vpopmail/domains//sysadmin/Maildir, index=/home/vpopmail/domains// sysadmin/Maildir, control=, inbox=
any suggestions, please?
thank you,
will
[0] This has come up before: http://dovecot.org/list/dovecot/2005- June/007530.html
[1] the rest of dovecot.conf, less comments:
base_dir = /var/run/dovecot protocols = imaps log_path = /var/log/dovecot mail_debug = yes
protocol imap { } protocol pop3 { }
auth_verbose = yes auth default { mechanisms = plain passdb vpopmail { args = } userdb vpopmail { } userdb prefetch { } user = root }
namespace private { separator = . prefix = INBOX. inbox = yes }
default_mail_env = maildir:/home/vpopmail/domains/%d/%n/Maildir pop3_uidl_format = %v-%u ssl_cert_file = /usr/local/ssl/certs/dovecot.pem ssl_key_file = /usr/local/ssl/private/dovecot.pem
On 5 Dec 2005, at 13:18, Jakob Hirsch wrote:
William Ross wrote:
userdb vpopmail { } userdb prefetch { }
I'm not using vpopmail, but I don't think prefetch ist needed for
it, so you should probably remove it.
Thank you. I wondered about that and was pleased to take it out.
Doesn't fix the problem with the missing domain, though.
will
William Ross wrote:
hello,
Sorry to jump straight in with a question, but I've searched the
archive[0] and I'm pretty sure the answer's not there.I'm using dovecot to replace courier imap, so authentication is by
vpopmail and the Maildirs are stored in the usual domains/domain/user/ Maildir. Everything seems to work very well, and setting it up has been easy, so thank you very much for that.I have only one problem left: %d is empty when interpolated into
default_mail_env. I expect there's something obvious I'm doing wrong,
but it's hard to tell because the wiki isn't always up to date (i'd be happy to update the vpopmail sections once this is working):Config has this [1]:
default_mail_env = maildir:/home/vpopmail/domains/%d/%n/Maildirand i log in over imaps with the account i'm using for testing:
username: sysadmin@spanner.org password: ...Authentication seems to work perfectly, but then the logs show:
dovecot: Dec 05 12:24:59 Info: imap(sysadmin): maildir: root=/home/ vpopmail/domains//sysadmin/Maildir, index=/home/vpopmail/domains// sysadmin/Maildir, control=, inbox=
any suggestions, please?
thank you,
will
Will, Timo,
[CCed to Timo as he implemented a solution to a related problem].
Digging this up from the archives - I have the same problem and can't find the solution. However: I've traced the problem through my mail logs:
Mar 22 18:16:43 tg1 dovecot: auth(default): client in: AUTH 1 PLAIN service=IMAP lip=xxx.xxx.35.122 rip=xxx.xxx.32.85 resp=AGRhbkBhbHVtaW5hdGkubmV0AHBhc3Mx Mar 22 18:16:43 tg1 dovecot: auth-worker(default): sql(dan@domain.net,xxx.xxx.32.85): query: SELECT username as user, password, mailenv as userdb_mail, uid as userdb_uid, gid as userdb_gid FROM users WHERE username = 'dan' AND domain = 'domain.net' Mar 22 18:16:43 tg1 dovecot: auth-worker(default): auth(dan@domain.net,xxx.xxx.32.85): username changed dan@domain.net -> dan Mar 22 18:16:43 tg1 dovecot: auth(default): auth(dan@domain.net,xxx.xxx.32.85): username changed dan@domain.net -> dan Mar 22 18:16:43 tg1 dovecot: auth(default): client out: OK 1 user=dan Mar 22 18:16:43 tg1 dovecot: auth(default): master in: REQUEST 1 24736 1
The line to look for says:
username changed dan@domain.net -> dan
After this point %d is empty which is a problem if you use it in any configuration settings (which I'm trying to do).
The login now works because I use the prefetch to fetch the mail and home directory informatin out of the database (rather than dynamically work it out) but there are some other settings (ie namespaces) where I wan to use %d.
Can anyone suggest how to maintain the information in %d? Particularly why does it shorten the username to "dan"?
Daniel
Daniel Watts wrote:
William Ross wrote:
hello,
Sorry to jump straight in with a question, but I've searched the archive[0] and I'm pretty sure the answer's not there.
I'm using dovecot to replace courier imap, so authentication is by vpopmail and the Maildirs are stored in the usual domains/domain/user/ Maildir. Everything seems to work very well, and setting it up has been easy, so thank you very much for that.
I have only one problem left: %d is empty when interpolated into default_mail_env. I expect there's something obvious I'm doing wrong, but it's hard to tell because the wiki isn't always up to date (i'd be happy to update the vpopmail sections once this is working):
Config has this [1]:
default_mail_env = maildir:/home/vpopmail/domains/%d/%n/Maildirand i log in over imaps with the account i'm using for testing:
username: sysadmin@spanner.org password: ...Authentication seems to work perfectly, but then the logs show:
dovecot: Dec 05 12:24:59 Info: imap(sysadmin): maildir: root=/home/ vpopmail/domains//sysadmin/Maildir, index=/home/vpopmail/domains// sysadmin/Maildir, control=, inbox=
any suggestions, please?
thank you,
will
Will, Timo,
[CCed to Timo as he implemented a solution to a related problem].
Digging this up from the archives - I have the same problem and can't find the solution. However: I've traced the problem through my mail logs:
Mar 22 18:16:43 tg1 dovecot: auth(default): client in: AUTH 1 PLAIN service=IMAP lip=xxx.xxx.35.122 rip=xxx.xxx.32.85 resp=AGRhbkBhbHVtaW5hdGkubmV0AHBhc3Mx Mar 22 18:16:43 tg1 dovecot: auth-worker(default): sql(dan@domain.net,xxx.xxx.32.85): query: SELECT username as user, password, mailenv as userdb_mail, uid as userdb_uid, gid as userdb_gid FROM users WHERE username = 'dan' AND domain = 'domain.net' Mar 22 18:16:43 tg1 dovecot: auth-worker(default): auth(dan@domain.net,xxx.xxx.32.85): username changed dan@domain.net -> dan Mar 22 18:16:43 tg1 dovecot: auth(default): auth(dan@domain.net,xxx.xxx.32.85): username changed dan@domain.net -> dan Mar 22 18:16:43 tg1 dovecot: auth(default): client out: OK 1 user=dan Mar 22 18:16:43 tg1 dovecot: auth(default): master in: REQUEST 1 24736 1
The line to look for says:
username changed dan@domain.net -> dan
After this point %d is empty which is a problem if you use it in any configuration settings (which I'm trying to do).
The login now works because I use the prefetch to fetch the mail and home directory informatin out of the database (rather than dynamically work it out) but there are some other settings (ie namespaces) where I wan to use %d.
Can anyone suggest how to maintain the information in %d? Particularly why does it shorten the username to "dan"?
Daniel
Your SQL query is not returning the domain part in the "user" field. The name returned in the "user" field replaces the IMAP username for all future stuff. Change your SQL query like this (assuming MySQL):
SELECT CONCAT(username, '@', domain) as user, password, mailenv as userdb_mail, uid as userdb_uid, gid as userdb_gid FROM users WHERE username = 'dan' AND domain = 'domain.net';
This same issue tripped me up for quite a while until I finally figured it out. Virtual users with a user part that matched a local username were accessing the local user's e-mail, not their own. This was because the SQL passdb was authenticating them but the passwd userdb was returning the home directory.
Hope this helps!
dovecot-ri wrote:
Daniel Watts wrote:
William Ross wrote:
hello,
Sorry to jump straight in with a question, but I've searched the archive[0] and I'm pretty sure the answer's not there.
I'm using dovecot to replace courier imap, so authentication is by vpopmail and the Maildirs are stored in the usual domains/domain/user/ Maildir. Everything seems to work very well, and setting it up has been easy, so thank you very much for that.
I have only one problem left: %d is empty when interpolated into default_mail_env. I expect there's something obvious I'm doing wrong, but it's hard to tell because the wiki isn't always up to date (i'd be happy to update the vpopmail sections once this is working):
Config has this [1]:
default_mail_env = maildir:/home/vpopmail/domains/%d/%n/Maildirand i log in over imaps with the account i'm using for testing:
username: sysadmin@spanner.org password: ...Authentication seems to work perfectly, but then the logs show:
dovecot: Dec 05 12:24:59 Info: imap(sysadmin): maildir: root=/home/ vpopmail/domains//sysadmin/Maildir, index=/home/vpopmail/domains// sysadmin/Maildir, control=, inbox=
any suggestions, please?
thank you,
will
Will, Timo,
[CCed to Timo as he implemented a solution to a related problem].
Digging this up from the archives - I have the same problem and can't find the solution. However: I've traced the problem through my mail logs:
Mar 22 18:16:43 tg1 dovecot: auth(default): client in: AUTH 1 PLAIN service=IMAP lip=xxx.xxx.35.122 rip=xxx.xxx.32.85 resp=AGRhbkBhbHVtaW5hdGkubmV0AHBhc3Mx Mar 22 18:16:43 tg1 dovecot: auth-worker(default): sql(dan@domain.net,xxx.xxx.32.85): query: SELECT username as user, password, mailenv as userdb_mail, uid as userdb_uid, gid as userdb_gid FROM users WHERE username = 'dan' AND domain = 'domain.net' Mar 22 18:16:43 tg1 dovecot: auth-worker(default): auth(dan@domain.net,xxx.xxx.32.85): username changed dan@domain.net -> dan Mar 22 18:16:43 tg1 dovecot: auth(default): auth(dan@domain.net,xxx.xxx.32.85): username changed dan@domain.net -> dan Mar 22 18:16:43 tg1 dovecot: auth(default): client out: OK 1 user=dan Mar 22 18:16:43 tg1 dovecot: auth(default): master in: REQUEST 1 24736 1
The line to look for says:
username changed dan@domain.net -> dan
After this point %d is empty which is a problem if you use it in any configuration settings (which I'm trying to do).
The login now works because I use the prefetch to fetch the mail and home directory informatin out of the database (rather than dynamically work it out) but there are some other settings (ie namespaces) where I wan to use %d.
Can anyone suggest how to maintain the information in %d? Particularly why does it shorten the username to "dan"?
Daniel
Your SQL query is not returning the domain part in the "user" field. The name returned in the "user" field replaces the IMAP username for all future stuff. Change your SQL query like this (assuming MySQL):
SELECT CONCAT(username, '@', domain) as user, password, mailenv as userdb_mail, uid as userdb_uid, gid as userdb_gid FROM users WHERE username = 'dan' AND domain = 'domain.net';
This same issue tripped me up for quite a while until I finally figured it out. Virtual users with a user part that matched a local username were accessing the local user's e-mail, not their own. This was because the SQL passdb was authenticating them but the passwd userdb was returning the home directory.
Hope this helps!
Many thanks! Timo came back with the same answer and it worked perfectly then. A little clarification/warning in the dovecot-sql.conf file would probably be a good idea to avoid other people being caught out. If it can happen twice it *will* happen again! Daniel
participants (4)
-
Daniel Watts
-
dovecot-ri
-
Jakob Hirsch
-
William Ross