- dovecot - dovecot.org

[Dovecot] auth with kerberos
by Renaud Allard 16 Jul '06

16 Jul '06

Hello, I am running dovecot 1.0RC2 and I'd like to know if there is a way to make dovecot provide PLAIN, LOGIN, CRAM-MD5, NTLM authentications from a kerberos database. GSSAPI works great, but I currently have to have two password databases, one for GSSAPI and one for all the others. What I'd like is to have only one password database (namely kerberos). I know that cyrus-sasl (which most of you don't like I think ;)) can provide such authentications, but I haven't found the way to configure dovecot to do the same. Any input welcome.

2 2

Re: [Dovecot] TLS Issues - Plain Text login?
by Timothy White 15 Jul '06

15 Jul '06

Thanks Marcus and Thomas. I should have checked it in another client ;-) Tim -- Linux Counter user #273956 Don't email joeblogs(a)scouts.org.au

1 0

Re: [Dovecot] Deliever in RC2 incorretly outputs "saved mail to INBOX"
by Alex Pimperton 14 Jul '06

14 Jul '06

Hi All, I've recently upgraded to RC2 (debian package) and now I get the following message in syslog all the time: Jul 14 15:51:04 server01 deliver(alex): saved mail to INBOX This seems to happen for every mail, despite some being filtered into different folders. It goes like this: Mail arrives from Ubuntu mailing list: Jul 14 15:53:49 server01 postfix/qmgr[19023]: D51A95C023: from=<ubuntu-users-bounces(a)lists.ubuntu.com>, size=4319, nrcpt=1 (queue active) I get this message: Jul 14 15:53:51 server01 deliver(alex): saved mail to INBOX Postfix sends to deliver: Jul 14 15:53:51 server01 postfix/local[29843]: D51A95C023: to=<alex(a)placet.co.uk>, relay=local, delay=29, status=sent (delivered to command: /usr/lib/dovecot/deliver) ...and a few seconds later it shows up in my Ubuntu-Users folder, exactly where my sieve rule sends it. Is this a bug? Alex -- This message has been scanned for viruses and dangerous content by the MailScanner at Placet.co.uk, and is believed to be clean.

1 0

[Dovecot] Backing up mail
by Davide Bolcioni 14 Jul '06

14 Jul '06

Greetings, in backing up mail stored according to default_mail_env = mbox:~/mail/:INBOX=/var/mail/%u is it safe *not* to backup the .imap subdirectory ? I am currently using dovecot-0.99.13-3.FC3. When restoring, I guess the safe option would be to zap the contents of .imap so that it gets rebuilt, correct ? Thank you for your consideration, Davide Bolcioni -- Paranoia is a survival asset.

1 0

[Dovecot] TLS Issues - Plain Text login?
by Timothy White 14 Jul '06

14 Jul '06

I'm trying to setup IMAP, so that it works via secure connections. I have it working fine over SSL, now I wish to get TLS to work. I have set imap and imaps to both listen on *, and have disable_plaintext_auth = yes, which according to the docs, Disable LOGIN command and all other plaintext authentications unless SSL/TLS is used (LOGINDISABLED capability). So the problem is now, that TLS doesn't work. Trying it with thunderbird, I get a message about login being disabled, and to check my settings and such. The port is correct (imap, not imaps), and I have it to always use TLS. I see the following in my logs Jul 14 16:35:46 mafeking dovecot: imap-login: Aborted login: rip=58.7.136.163, lip=203.30.47.34, TLS Any ideas? To me it appears to be using TLS, so why doesn't thunderbird work? Is it the LOGINDISABLED capa keyword? Is it dovecot telling Thunderbird the wrong capa when using TLS? It all works fine with SSL, and the port (in thunderbird) set to the imaps port. The logs show lines like below when using SSL. Jul 14 16:36:32 mafeking dovecot: imap-login: Login: user=<joeblogs>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Any ideas? Or should I just force SSL? Thanks Tim (using RC2) -- Linux Counter user #273956 Don't email joeblogs(a)scouts.org.au

3 2

[Dovecot] How to create rules?
by Romeo Theriault 14 Jul '06

14 Jul '06

Hi, I have dovecot installed and working fine. I would like (server side) a rule runs on all messages and if it finds certain words in the message it will run a script which will send a new email. How can I create these rules? Do I need another piece of software? Thank you, Romeo

7 12

Re: [Dovecot] Squirrelmail Change Dovecot Password Plugin
by Cecil S. Nutakor 14 Jul '06

14 Jul '06

Having a plugin that allows squirrelmail to change Dovecot's password would depend entirely on how you have your Dovecot passwords stored. Peter your right, My Dovecot passwords are stored in /etc/dovecot/passwd and Dovecot users stored in /etc/dovecot/users Thanks > On 7/13/2006 07:42, Cecil S. Nutakor seems to have typed: >> After a moment i noticed that i could make the users change their own >> passwords using squirrelmail, but unfortunatly for me after googling >> around the Internet and also visiting squirrelmail plugin page i could >> not >> find a change Dovecot password plugin for squirrelmail. > > If your Dovecot passwords are stored as system passwords, then you would > have to allow PHP (squirrelmail) to change system passwords. Currently, > I have SQL store my Dovecot passwords (which are actually used for > a lot of different authentication purposes), so it was trivial to write > a page that allows users to change the password in the SQL database and > would be easy to add this to squirrelmail if you wanted, but given how > many ways that Dovecot can use for authentication, a generic plugin that > works for all of them would be extraordinarily difficult (and a security > risk for some of the password storage methods - you don't want PHP to > be able to edit your /etc/passwd if you are using *BSD/*nix) > Office Of The SYSTEMS ARCHITECT DISCOVERYTEL GH

1 0

[Dovecot] dovecot 1.00 RC2 bugs
by Alexander Zagrebin 14 Jul '06

14 Jul '06

imho, dovecot 1.00 RC2 has two bugs at the maildir quota implementation 1. Incorrect calculation of used storage and count of messages When calculating, dovecot counts "." and ".." directory entries. So, if there are no subdirs and messages in maildir, maildirsize still shows 4 messages and some used storage. My workaround is --- src/plugins/quota/quota-maildir.c.orig Sun Jun 11 21:36:24 2006 +++ src/plugins/quota/quota-maildir.c Thu Jul 13 11:33:58 2006 ======================================================== @@ -82,6 +82,8 @@ len = str_len(path); while ((dp = readdir(dirp)) != NULL) { + if (!strcmp(dp->d_name, ".")) continue; + if (!strcmp(dp->d_name, "..")) continue; p = strstr(dp->d_name, ",S="); num = (uoff_t)-1; if (p != NULL) { ======================================================== This patch skips special directory entries. 2. Under some condition maildirsize contains invalid data Consider a such situation 1. User begins pop3 session 2. dovecot calls this sequence of procedures maildir_quota_transaction_begin -> maildirquota_refresh -> maildirsize_read While reading maildirsize's data, may be situation when mailbox size must be recalculated (maildirsize greater 5120, quotas was changed...). In this case dovecot closes maildirsize's file descriptor (root->fd) and assigns it "-1". After that code calls maildirsize_recalculate -> maildirsize_write So maildirsize is rewritten and contains valid data. BUT file descriptor (root->fd) still contains "-1" 3. User retrieves and deletes some messages, then quits. So maildirsize must be updated. 4. Code calls maildir_quota_transaction_commit, but root->fd equals "-1", so maildirsize_update doesn't calls and maildirsize contains incorrect (obsolete) data My workaround is ======================================================== --- src/plugins/quota/quota-maildir.c.orig Sun Jun 11 21:36:24 2006 +++ src/plugins/quota/quota-maildir.c Thu Jul 13 11:33:58 2006 @@ -246,11 +248,12 @@ return -1; } - if (file_dotlock_replace(&dotlock, 0) < 0) { + if (file_dotlock_replace(&dotlock, DOTLOCK_REPLACE_FLAG_DONT_CLOSE_FD) < 0) { mail_storage_set_critical(storage, "file_dotlock_replace(%s) failed: %m", path); return -1; } + root->fd = fd; return 0; } ======================================================== This patch preserves fd after writing recalculated maildirsize file, and when maildir_quota_transaction_commit is called, root->fd contains valid file descriptor. -- Alexander Zagrebin

1 0

[Dovecot] pop3s Authentication Issues, Continued
by Bruce Lane 14 Jul '06

14 Jul '06

Fellow Dovecot'ers. I tried something tonight that I should have done a while back: Turned on verbose logging in the authentication section. I'm still unable to get the mail client I'm experimenting with (Pegasus) to complete a pop3s connection, in that I still get an indication of a failed password. However, at least I'm a little closer to understanding the failure itself. Please note what came up in /var/log/maillog. Jul 13 22:41:25 featherweb dovecot: auth(default): client in: AUTH 1 PLAIN service=POP3 secured lip=192.168.42.130 rip=192.168.42.40 resp=AGt5cnJpbgBocDIxZHZlbTc= Jul 13 22:41:25 featherweb dovecot: auth(default): cache(kyrrin(a)bluefeathertech.com,192.168.42.40): User unknown Jul 13 22:41:26 featherweb dovecot: auth(default): client out: FAIL 1 user=kyrrin(a)bluefeathertech.com More specifically: Take a good hard look at the end of the second line. Why in the Multiverse would the thing consider me an unknown user? Unless it's not really checking /etc/passwd at all...? Excerpt from dovecot.conf follows. -=-=-=-=-=-=-=-=- auth default { # Space separated list of wanted authentication mechanisms: # plain login digest-md5 cram-md5 ntlm rpa apop anonymous gssapi mechanisms = plain login passdb passwd { } userdb passwd { } socket listen { client { path = /var/spool/postfix/private/auth mode = 0660 user = postfix group = postfix } } } As a point of interest, SENDING mail via a secure connection (SMTP AUTH via STARTTLS) is working quite well. I'm beginning to think that the OpenSSL installation isn't authenticating properly...? Insights welcome. Thanks much. -=-=-=-=-=-=-=-=-=-=-=- Bruce Lane, Owner & Head Hardware Heavy, Blue Feather Technologies -- http://www.bluefeathertech.com kyrrin (at) bluefeathertech do/t c=o=m "If Salvador Dali had owned a computer, would it have been equipped with surreal ports?"

2 1

[Dovecot] [Fwd: [PATCH] Dovecot-1.0rc2 MANAGESIEVE]
by Timo Sirainen 14 Jul '06

14 Jul '06

3 6

Re: [Dovecot] Error: imap-login: Can't connect to auth server at default: Resource temporarily unavailable
by Matt Roman 13 Jul '06

13 Jul '06

It appears the problem is in this function: int net_connect_unix(const char *path) { struct sockaddr_un sa; int fd, ret; memset(&sa, 0, sizeof(sa)); sa.sun_family = AF_UNIX; if (strocpy(sa.sun_path, path, sizeof(sa.sun_path)) < 0) { /* too long path */ errno = EINVAL; return -1; } /* create the socket */ fd = socket(PF_UNIX, SOCK_STREAM, 0); if (fd == -1) { i_error("socket(%s) failed: %m", path); return -1; } net_set_nonblock(fd, TRUE); /* connect */ ret = connect(fd, (void *)&sa, sizeof(sa)); if (ret < 0 && errno != EINPROGRESS) { close_keep_errno(fd); return -1; } return fd; } This function is returning -1 and the server is crashing - Most likely because of a socket error. The error message from the socket is "Resource temporarily unavailable" If anybody knows why that would happen, I might be able figure out a solution. Thanks!

1 0

[Dovecot] maildir++ quota bug...
by Joseph W. Breu 13 Jul '06

13 Jul '06

Running RC2 with maildrop and MDA: dovecot writes a positive quota count, then the negative quota count on messages delivered with maildrop. For example, message #1 arrives via maildrop: 4488236 1 message is deleted via dovecot: 4488236 1 -4488236 -1 This does not happen when the user accesses the message, only when it is deleted. The user never gets credit for deleting the file and their quota continues to grow. I did not notice this behaviour until now, but I just tested with rc1 and it is present there as well. Thanks, --------------------------------------------------------- Joseph W. Breu, CCNA phone : +1.319.268.5228 Senior Network Administrator fax : +1.319.266.8158 Cedar Falls Utilities cell : +1.319.493.1686 support: +1.319.268.5221 url : http://www.cfu.net

2 2

[Dovecot] proxy load-testing
by Vincent Fox 13 Jul '06

13 Jul '06

I found the proxy performance page in the Wiki. It's interesting to see such good performance for the proxy! However, I was trying to duplicate the tests and am not clear how. Anyone know what a typical test setup would look like? I need to document/test that I can setup a proxy able to handle 100-200 sessions per second which the folks around here are skeptical of. I emailed Tomi directly but got a vacation reply. I tried a quick test of my own with rabid and results seem questionable. Probably I am not using the right options on the command-line. I used a single client to generate the load and while I specified 20,000 per minute when I checked the maillog on my IMAP server it was authentication more like 300 per minute. I get a number of "Re-auth failure" messages even with 3720 accounts. I think this is due to the randomness being literal sometimes you hit again the same account name while a first attempt of it is still connected. Also not sure how Tomi generated those statistics, from the logs, from the rabid output? Since rabid doesn't do POP-mark numbers or anything I guess you just ramp up the load until the proxy slows down and call that your performance number?

1 0

[Dovecot] Squirrelmail Change Dovecot Password Plugin
by Cecil S. Nutakor 13 Jul '06

13 Jul '06

Hi Let me introduce myself, My name is Cecil, and i am a system architect by proferssion working currently on contracts with serveral companies in Ghana and Nigeria. I recently built a Corporate Mail Server for a Company using Postfix, Dovecot and Squirrelmail, running on Ubuntu. Thanks to the Dovecot community everything is working well. After a moment i noticed that i could make the users change their own passwords using squirrelmail, but unfortunatly for me after googling around the Internet and also visiting squirrelmail plugin page i could not find a change Dovecot password plugin for squirrelmail. I want to throw this challenge to the Dovecot community to start a project on developing a change Dovecot password plugin for squirrelmail if none exis t as at now. I am ready to voluntee towards the development of the plugin. I will like to know from others especially the list administrators if the project can take off on the mailling list with any problems. Thank You. Office Of The SYSTEMS ARCHITECT DISCOVERYTEL GH

2 1

Re: [Dovecot] Authentication by certificats (a bug or my misconfiguration)
by HenkJan Wolthuis 13 Jul '06

13 Jul '06

Hi Alexander, > > Thanks for the quick reply; rearranging the certs didn't seem to do > much for the setup; I guess I'm getting one thing wrong, which was the > cause for my followup. How can I make dovecot only rely on cert and no > furhter authentication for giving access to the user, when making > dovecot lift the user ID from the client cert? Hmm, i don't think that's the reason for the "invalid certificate" error. Another question: are the clientcertificates and the servercertificate signed by the same CA? In case you want the ssl-verify error in the logfiles: in src/logincommon/ssl-proxy-openssl.c, line 607 change: i_info("Invalid certificate: %s", buf); to: i_info("Invalid certificate: %s: %s, X509_verify_cert_error_string(ctx->error) ,buf); should help, (tested on beta8) (don't forget to recompile, install, restart ;-)) success! -- groeten, HenkJan Wolthuis

2 2

[Dovecot] Error logged while deleting folder
by Luigi Rosa 13 Jul '06

13 Jul '06

Scenario: Dovecot 1.0.rc2 server (fedora 5) Thunderbird 1.5.0.4 WinXP IMAP client Steps to reproduce the warning message whith Thunderbird client: * create a folder with Thunderbird * copy a message in that folder * delete the folder * empty trash Warning logged: Jul 13 06:27:25 mail dovecot: IMAP(lrosa): stat(/var/spool/mail2/lrosa/.Trash.zzz/new) failed: No such file or directory Jul 13 06:27:25 mail dovecot: IMAP(lrosa): inotify_rm_watch() failed: Invalid argument Does not happen with SquirrelMail 1.4.7 IMAP client Question: Is it Thunderburd bug or a Dovecot bug? Ciao, luigi -- / +--[Luigi Rosa]-- \ All general statements are false (including this one).

1 0

Re: [Dovecot] Quota over 2GB supported?
by Bill Boebel 13 Jul '06

13 Jul '06

On Tue, July 11, 2006 9:27 pm, ssoo(a)siliconfile.com said: > I'm using Courier-imap and gonna change to dovecot. > Courier-imap supports quota over 2GB size. > Does dovecot's Maildir++ quota support over 2GB? Yes, we are enforcing a 5GB per user quota using Dovecot's maildir++ quota support. This works with both 32-bit kernels and 64-bit. I know courier took some patching to make work with 32-bit kernels, but Dovecot supports it out of the box. The only caveat is the quota is only enforceable within one namespace, so make sure your Inbox and folders all use the same namespace. Bill

2 1

[Dovecot] Quota over 2GB supported?
by ssoo＠siliconfile.com 12 Jul '06

12 Jul '06

I'm using Courier-imap and gonna change to dovecot. Courier-imap supports quota over 2GB size. Does dovecot's Maildir++ quota support over 2GB?

7 8

[Dovecot] Corrupted index cache
by Joseph W. Breu 12 Jul '06

12 Jul '06

Upgraded from rc1 to rc2 and I am still getting the Corrupted index cache file warnings in syslog Jul 12 10:10:19 pop1.cfu.net dovecot: IMAP(breu(a)cfu.net): Corrupted index cache file /var/spool/mail/filer/storage//cfu.net/b/r/breu/dovecot.index.cache: invalid record size Is this something to be worried about? Is the cache just rebuilt upon notification of corruption? Thanks, --------------------------------------------------------- Joseph W. Breu, CCNA phone : +1.319.268.5228 Senior Network Administrator fax : +1.319.266.8158 Cedar Falls Utilities cell : +1.319.493.1686 support: +1.319.268.5221 url : http://www.cfu.net

1 0

[Dovecot] passwd authentication issues (ATTN: Petar)
by Bruce Lane 12 Jul '06

12 Jul '06

Hi, Petar, For whatever reason, I didn't see your most recent reply until I checked the web archives. To answer your questions... Is my dovecot running chrooted? Not that I know of. However, the option to (apparently) decide this is confusing at best. Here is what I have entered. # chroot login process to the login_dir. Only reason not to do this is if you # wish to run the whole Dovecot without roots. # http://wiki.dovecot.org/Rootless login_chroot = yes Now, my guts tell me that this WILL make it run chrooted. However, reading the material at this link... http://wiki.dovecot.org/Rootless ...says otherwise, and that setting this to 'no' would be making it run chrooted. For reference, this is the process line from ps -aux|grep dovecot root 3182 0.0 1.4 256 876 ? Ss Sun08PM 10:10.06 /usr/local/sbin/dovecot Also, something else just turned up in the process list that I'm not sure I understand. Specifically... root 1817 0.0 1.6 324 1056 ? S 8:53PM 0:00.19 dovecot-auth dovecot 2191 0.0 3.0 256 1940 ? S 8:53PM 0:00.97 imap-login root 3182 0.0 1.4 256 876 ? Ss Sun08PM 10:11.78 /usr/local/sbin/dovecot dovecot 6333 0.0 3.0 256 1940 ? S 8:53PM 0:00.93 imap-login dovecot 8133 0.0 3.0 256 1940 ? S 8:53PM 0:00.97 imap-login dovecot 8397 0.0 3.0 256 1940 ? S 8:53PM 0:00.96 imap-login dovecot 16144 0.0 3.0 256 1940 ? S 8:53PM 0:00.92 imap-login This has me deeply confused. I'm not running IMAP, I'm not interested in running IMAP, I don't want anything to do with IMAP. However, there's five processes for imap-login. What gives? On to your second question: Are /etc/pwd.db and /etc/spwd.db available? Yes, both are listed in the directory of /etc as follows. -rw-r--r-- 1 root wheel 40960 Jul 9 09:56 /etc/pwd.db -rw------- 1 root wheel 40960 Jul 9 09:56 /etc/spwd.db featherweb: {41} How "available" this makes them (I don't know what context you were asking in), I'm not sure. Just for giggles, I tried chaning the permissions on spwd.db so that it was world-readable. Doing so had no effect. I still get password failure errors when I try to authenticate a pop3s connection from the client program. One other question: Pegasus (the mail client) has two options for secure POP connections besides apop (which I've shelved for the moment): STLS and direct SSL connection. I've got it set to direct SSL at the moment. Does this sound right? Looking forward to the next set of replies. Thanks much. -=-=-=-=-=-=-=-=-=-=-=- Bruce Lane, Owner & Head Hardware Heavy, Blue Feather Technologies -- http://www.bluefeathertech.com kyrrin (at) bluefeathertech do/t c=o=m "If Salvador Dali had owned a computer, would it have been equipped with surreal ports?"

3 4

[Dovecot] Problems with deliver (LDA)
by Claus Alboege 12 Jul '06

12 Jul '06

Hi, I'm using Dovecot's (1.0.rc2) 'deliver' (no sieve) as LDA - calling it from a .qmail file. It seems that 'deliver' destroys "message/rfc822" attachments (forward as attachment). My .qmail file looks like this, and use qmail to deliver a copy directly to my Maildir, and 'deliver' to deliver a second copy of the same message to the same Maildir: % cat .qmail ./Maildir/ |preline /usr/libexec/dovecot/deliver After forwarding a message (as attachment) to my account, I get the following 2 files in my Maildir. Check the difference in size: % ls -l Maildir/new -rw------- 1 csa csa 2818 2006-07-06 09:29 1152170973.7420.silver -rw------- 1 csa csa 1372 2006-07-06 09:29 1152170973.P7422Q0M136220.silver Grepping for ^Content-* in the 2 mails show that a part is missing. % cd Maildir/new % grep ^Content * 1152170973.7420.silver:23:Content-Type: multipart/mixed; 1152170973.7420.silver:28:Content-Type: text/plain; charset = "iso-8859-1" 1152170973.7420.silver:29:Content-Transfer-Encoding: quoted-printable 1152170973.7420.silver:34:Content-Type: message/rfc822; name="Testing" 1152170973.7420.silver:35:Content-Transfer-Encoding: 7bit 1152170973.7420.silver:36:Content-Disposition: attachment; filename="Testing" 1152170973.7420.silver:64:Content-Transfer-Encoding: quoted-printable 1152170973.7420.silver:65:Content-Type: text/plain; charset="iso-8859-1" 1152170973.P7422Q0M136220.silver:24:Content-Type: multipart/mixed; 1152170973.P7422Q0M136220.silver:29:Content-Type: text/plain; charset = "iso-8859-1" 1152170973.P7422Q0M136220.silver:30:Content-Transfer-Encoding: quoted-printable 1152170973.P7422Q0M136220.silver:35:Content-Type: message/rfc822; name="Testing" 1152170973.P7422Q0M136220.silver:36:Content-Transfer-Encoding: 7bit 1152170973.P7422Q0M136220.silver:37:Content-Disposition: attachment; filename="Testing" (sorry for the long lines) The offset in linenumbers is caused the the From line added by 'deliver'. So, am I missing something here (execpt from the attachment) - is there anything in 'deliver' that could cause this behaviour? Please let me know if you need further information or details. Regards /Claus A

1 1

[Dovecot] Shared folders not woking for me
by Nagy László 12 Jul '06

12 Jul '06

Hello, I'm new to dovecot, please forgive me my silly questions. :-) My OS is FreeBSD 6.1. I just installed dovecot 1.0.beta9. I have created a public namespace this way: namespace public { separator = / prefix = Public/ location = maildir:/var/mail/public } namespace private { separator = / prefix = location = maildir:/home/%u/Maildir inbox = yes } Then I created a new group and added a user to it: pw groupadd das pw usermod testuser -g das Then I created some files in /var/mail/public: drwxrwx--- 2 testuser das 512 Jul 11 19:22 Tasks drwx------ 2 testuser mail 512 Jul 11 19:20 cur drwxrwx--- 2 testuser das 512 Jul 11 19:24 dovecot-shared drwx------ 2 testuser mail 512 Jul 11 19:20 new drwx------ 2 testuser mail 512 Jul 11 19:20 tmp Then I restarted dovecot, and I tried to subscribe to 'Tasks', but my email client (Thunderbird 1.5) does not allow it. My other problem is about the "inbox = yes" setting. The private namespace does have an inbox, and it shows up in thunderbird. But it does not show my e-mails. I know that I have emails, I can read them with the 'mail' command. Please help me. Laszlo

3 7

Re: [Dovecot] Dovecot and MySQL auth - initial setup issues
by James Bowling 11 Jul '06

11 Jul '06

If you setup is in a virtual mailbox setup then your query should look something like this: user_query = SELECT maildir, 500 AS uid, 500 AS gid FROM users WHERE id = '%u' Try that out, replacing the 500's with the appropriate uid and gid and let me know what you see then. Regards, James Bowling On Tue, 11 Jul 2006 17:01:41 +0100, Andrew Hearn <andrew(a)aa.nu> wrote: > James Bowling wrote: >> Are you using a password encryption scheme for your user passwords in >> the mysql db? You might want to enable the following to help debug the >> issue more in your dovecot.conf: >> >> auth_verbose = yes >> auth_debug = yes >> auth_debug_passwords = yes >> >> Restart Dovecot and then try logging in. This will spit out alot more >> information about the process and might give us a better look into your >> issue. >> > > > Thanks James, > > I'm using plain at the moment whilst testing and getting this working, > the database has a plain password, and > under auth default { I've now set: > mechanisms = plain > > > The log I now get is: > > dovecot: Jul 11 17:01:21 Info: auth(default): client in: AUTH 1 > PLAIN service=IMAP lip=::ffff:81.187.11.54 rip=::ffff:81.187.11.8 > resp=AGFuZHJld0BtYWlsLXRlc3QuYWFpc3AubmV0LnVrADIzNzQyNg== > dovecot: Jul 11 17:01:21 Info: auth-worker(default): > sql(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): query: SELECT > password FROM users WHERE id = 'andrew(a)mail-test.aaisp.net.uk' > dovecot: Jul 11 17:01:21 Info: auth(default): client out: OK 1 > user=andrew(a)mail-test.aaisp.net.uk > dovecot: Jul 11 17:01:21 Info: auth(default): master in: REQUEST > 4 17643 1 > dovecot: Jul 11 17:01:21 Info: auth-worker(default): > sql(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): SELECT maildir > FROM users WHERE id = 'andrew(a)mail-test.aaisp.net.uk' > dovecot: Jul 11 17:01:21 Error: auth-worker(default): > sql(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): Password query > didn't return uid, or it was NULL > dovecot: Jul 11 17:01:21 Info: auth(default): > passwd(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): unknown user > dovecot: Jul 11 17:01:21 Error: auth(default): > userdb(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): user not found > from userdb > dovecot: Jul 11 17:01:21 Info: auth(default): master out: NOTFOUND 4 > dovecot: Jul 11 17:01:21 Info: imap-login: Internal login failure: > user=<andrew(a)mail-test.aaisp.net.uk>, method=PLAIN, > rip=::ffff:81.187.11.8, lip=::ffff:81.187.11.54 > > > > I'm not sure why it's saying "Password query didn't return uid", that > that seems the issue. > > > I'll carry on playing... Andrew

1 0

Re: [Dovecot] Dovecot and MySQL auth - initial setup issues
by Andrew Hearn 11 Jul '06

11 Jul '06

James Bowling wrote: > Are you using a password encryption scheme for your user passwords in > the mysql db? You might want to enable the following to help debug the > issue more in your dovecot.conf: > > auth_verbose = yes > auth_debug = yes > auth_debug_passwords = yes > > Restart Dovecot and then try logging in. This will spit out alot more > information about the process and might give us a better look into your > issue. > Thanks James, I'm using plain at the moment whilst testing and getting this working, the database has a plain password, and under auth default { I've now set: mechanisms = plain The log I now get is: dovecot: Jul 11 17:01:21 Info: auth(default): client in: AUTH 1 PLAIN service=IMAP lip=::ffff:81.187.11.54 rip=::ffff:81.187.11.8 resp=AGFuZHJld0BtYWlsLXRlc3QuYWFpc3AubmV0LnVrADIzNzQyNg== dovecot: Jul 11 17:01:21 Info: auth-worker(default): sql(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): query: SELECT password FROM users WHERE id = 'andrew(a)mail-test.aaisp.net.uk' dovecot: Jul 11 17:01:21 Info: auth(default): client out: OK 1 user=andrew(a)mail-test.aaisp.net.uk dovecot: Jul 11 17:01:21 Info: auth(default): master in: REQUEST 4 17643 1 dovecot: Jul 11 17:01:21 Info: auth-worker(default): sql(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): SELECT maildir FROM users WHERE id = 'andrew(a)mail-test.aaisp.net.uk' dovecot: Jul 11 17:01:21 Error: auth-worker(default): sql(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): Password query didn't return uid, or it was NULL dovecot: Jul 11 17:01:21 Info: auth(default): passwd(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): unknown user dovecot: Jul 11 17:01:21 Error: auth(default): userdb(andrew@mail-test.aaisp.net.uk,::ffff:81.187.11.8): user not found from userdb dovecot: Jul 11 17:01:21 Info: auth(default): master out: NOTFOUND 4 dovecot: Jul 11 17:01:21 Info: imap-login: Internal login failure: user=<andrew(a)mail-test.aaisp.net.uk>, method=PLAIN, rip=::ffff:81.187.11.8, lip=::ffff:81.187.11.54 I'm not sure why it's saying "Password query didn't return uid", that that seems the issue. I'll carry on playing... Andrew

2 1

[Dovecot] Dovecot and MySQL auth - initial setup issues
by Andrew Hearn 11 Jul '06

11 Jul '06

Hello, I'm just setting up a new server and wanting to use MySQL for user authentication. Here is what I have: Fedora Core 5: 2.6.17-1.2145_FC5 Dovecot v1.0.rc2 (RPM install from atrpms.net) MySQL v5.0.22 SquirrelMail v 1.4.6-7.fc5 ...Running on a Dual XEON machine I've added the following to dovecot.conf: auth default { passdb sql { args = /etc/dovecot-mysql.conf } userdb sql { args = /etc/dovecot-mysql.conf } The rest of dovecot.conf is standard. /etc/dovecot-mysql.conf has: driver=mysql connect = host=127.0.0.1 port=3306 dbname=maildb user=root client_flags=0 password_query = SELECT password FROM users WHERE id = '%u' user_query = SELECT maildir FROM users WHERE id = '%u' (I've run the SQL queries within mysql and they give the right results) When I start Dovecot the log shows: dovecot: Jul 11 12:47:25 Info: Dovecot v1.0.rc2 starting up dovecot: Jul 11 12:47:27 Info: auth-worker(default): mysql: Connected to 127.0.0.1 (maildb) When I try to log in using SquirrelMail, it takes about 3 seconds, then I get dovecot: Jul 11 12:48:00 Info: imap-login: Aborted login: user=<andrew(a)mail-test.aaisp.net.uk>, method=PLAIN, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured ...So, no log of it trying MySQL... And SquirrelMail then says: Unknown user or password incorrect Any ideas of what I'm missing? Thanks! Andrew.

1 0