- dovecot - dovecot.org

[Dovecot] "Not connected to database" MySQL errors
by Cassidy B. Larson 03 Jan '07

03 Jan '07

I've been in the process of moving my pop3 proxy over to the dovecot proxy. I have a ton of users using pop3 still, and am seeing these errors popup within a minute or so of the connection to the database: Password query failed: Not connected to database Eventually the auth-worker will reconnect to the database and things will go on normal for another minute or two, then the same issue occurs. I'm runing MySQL 5.0.22 on FreeBSD 6.1. I upgraded to 5.0.27, however I started getting the: "Password query failed: Commands out of sync; you can't run this command now" error instead. So I downgraded until I could figure out this issue first. I've tried connecting to localhost, /tmp/mysql.sock, and a remote server and all exhibit the same problem. The MySQL idle timeouts shouldnt come into play because I'm constantly having users check their accounts. Any insights will be useful, Thanks! Cassidy ### Part of my dovecot.conf that might be useful: login_process_per_connection = yes login_processes_count = 3 login_max_processes_count = 512 auth_verbose = yes auth_debug = yes auth_debug_passwords =yes auth_worker_max_count = 400 auth mail.infowest.com { mechanisms = plain passdb sql { args = /usr/local/etc/dovecot-sql.conf } userdb static { args = uid=5000 gid=5000 home=/dev/null } user = root # Number of authentication processes to create count = 10 ## dovecot-sql.conf driver = mysql connect = host=/tmp/mysql.sock dbname=iwmailsystem user=imap_proxy password=***** client_flags=65536 default_pass_scheme = MD5 password_query = CALL pop_auth('%u','%l','%r')

2 2

[Dovecot] Dovecot and Mail.app
by Barry Warsaw 03 Jan '07

03 Jan '07

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm trying to convert a courier-imap installation over to using Dovecot, but I'm having some problems with Mail.app on OS X. FTR, we use both Mail.app and Thunderbird. Note that in the Mail.app preferences, I have a blank IMAP Path Prefix. I'm using Dovecot 1.0_rc15 on Gentoo, and Mail.app from OS X 10.4.8, Thunderbird 1.5.0.9. With the old courier setup, in Mail.app I would see a top level Inbox folder, with an inbox icon'd folder underneath that representing the IMAP account. That IMAP account subfolder would be the inbox of that account. Under that, I'd see all the subfolders for that account. Something like: Inbox Account1 Folder1 Folder2 ... Account2 FolderA Outbox Drafts Sent Junk SmartFolder1 SmartFolder2 Note that a straight copy from the courier Maildir leaves me with directories like ~/Maildir/.Folder1 and ~/Maildir/.Folder2 -- IOW, they do not have .INBOX. prefix. I tried adding a "namespace private" section, with separator, prefix, and inbox values as specified in the docs. This gives me the same layout in the Mail.app u/i as with Courier, but there's a big problem: none of the folders under Account1 have any contents. The folders are there, and in the right location, but they have zero messages (even though they certainly have messages in the filesystem). Nothing in the Dovecot log file indicates any problem. But if I hover over say Folder1 in the Mail.app u/i, I see a popup message like: Mail was unable to open this mailbox on the server "imap.example.com". The server error encountered was: Unknown namespace Moving over to Thunderbird though, I see exactly what I want to see. Top level expandable is the account, with Inbox under that, which expands to all my folders. Of course Thunderbird supports subscriptions, which Mail.app does not, so I only see the folders I've subscribed to. Clearly, there's some weird interaction between Mail.app and Dovecot. Next, I tried removing the 'prefix' value from the "namespace private" section, and restarted Dovecot. Now the Mail.app u/i is different, but all the folders have their contents back! The u/i now shows: Inbox Account1 Account2 FolderA Outbox Drafts Sent Junk SmartFolder1 SmartFolder2 Account1 Folder1 Folder2 IOW, all of account1's folders live under a separate expandable section below the top level Inbox expandable (that section has a little world icon instead of the little inbox icon). Account1's inbox lives in a different section from its folders, but it has no subfolders. Looking back at Thunderbird, I notice that all the subscribed folders are now at the same level as the Inbox, just under the account name. I.e. Account1 Inbox Trash Folder1 Folder2 ... I suppose I can live with the Mail.app behavior sans the prefix setting in the namespace section, but it's not ideal. I'd really like to know why Mail.app has a problem with this! Why are the folders there but the contents empty? Is there any way to increase the logging that Dovecot does to understand what the Mail.app client is sending and why Dovecot is sending back that error? Any help would be greatly appreciated! - -Barry P.S. I wasn't able to use courier2dovecot.sh from the wiki (I think others had problems with running it on Linux as well, probably due to the different rename(1) syntax). The courier2dovecot.py file was no longer available, so I wrote my own. I can make that available to folks if there's any interest. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) iQCVAwUBRZC8sXEjvBPtnXfVAQK90gQAjFhEH+vIPh7pnY4MuOTU8ChWfJ57ppIQ g0HvHidiD5nOfd8pfpsfacdD1nC40cRlpnJkR6vcahvqQsLzSUzUMwVlUqP2IDSE jGvZGpGSBpjTHV/ktWbyJhPo9+ehVxiq+qEfbDgfw9iqBtulOXe4M25iUKO8tsuA n2bCHHoUXuk= =hxad -----END PGP SIGNATURE-----

4 8

Re: [Dovecot] dovecot/vpopmail lastauth
by Max A 03 Jan '07

03 Jan '07

> Hi All, > > I have dovecot working wonderfully on a qmail/vpopmail, but I've noticed > my 'lastauth' is never filled in.. If I use vpopmail's pop, and auth to > that, then 'lastauth' is updated. It just seems weird that if dovecot > is using the vpopmail lib, that lastauth wouldn't be updated. > > Has anyone else run into this? If to use the checkpassword interface all works correctly: passdb checkpassword { args = /var/qmail/vpopmail/bin/vchkpw } userdb prefetch { }

1 0

[Dovecot] I can't use sql auth
by Toni Panadès 03 Jan '07

03 Jan '07

I need some help. I have compiled dovecot (1.0-rc15) with --with-mysql option, when I execute the binary with --build-options I get this: Build options: ioloop=poll notify=dnotify ipv6 openssl SQL drivers: Passdb: checkpassword passwd passwd-file shadow Userdb: checkpassword passwd prefetch passwd-file static In this case, when I execute dovecot I get this error: dovecot: Jan 03 03:48:47 Error: auth(default): Unknown userdb driver 'sql' (typo, or Dovecot was built without support for it? Check with dovecot --build-options) Well, now I compile with "--with-mysql --with-sql-drivers" and I get this: Build options: ioloop=poll notify=dnotify ipv6 openssl SQL drivers: Passdb: checkpassword passwd passwd-file shadow sql Userdb: checkpassword passwd prefetch passwd-file sql static And now, the error is: dovecot: Jan 03 03:53:21 Error: auth(default): Unknown database driver 'mysql' My dovecont.conf auth section: --------8<--------8<--------8<--------8<--------8<--------8< auth default { mechanisms = plain userdb static { args = uid=8 gid=12 home=/home/vpopmail/domains/%d/%u/Maildir } passdb sql { args = /usr/local/etc/dovecot-sql.conf } userdb sql { args = /usr/local/etc/dovecot-sql.conf } } --------8<--------8<--------8<--------8<--------8<--------8< My dovecot-sql.conf have: --------8<--------8<--------8<--------8<--------8<--------8< driver = mysql connect = host=localhost dbname=mail user=postfix password=secret default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, crypt as password, maildir as userdb_home, uid as userdb_uid, gid as userdb_gid FROM postfix_users WHERE email = '%u' --------8<--------8<--------8<--------8<--------8<--------8< what's wrong? thanks!

2 2

[Dovecot] Dovecot 1.0-rc15 on Solaris 10
by Steven F Siirila 03 Jan '07

03 Jan '07

We are running Dovecot 1.0-rc15 on Solaris 10 and are starting to ramp up our user count and ran into a file descriptor limit: Jan 1 19:38:54 <hostname> dovecot: IMAP(username): Newly created index file is corrupted: /home/username/.imap/foldername/dovecot.index.tmp Jan 1 19:38:54 <hostname> dovecot: IMAP(username): file mail-index.c: line 1806 (mail_index_move_to_memory): assertion failed: (index->fd == -1) Jan 1 19:38:54 <hostname> dovecot: pipe() failed: Too many open files Jan 1 19:38:54 <hostname> dovecot: Temporary failure in creating login processes, slowing down for now We got around this by calling "ulimit -n 512" and restarting Dovecot. This got us further (upwards of 300 concurrent users), but we are now running into what appears to be a full listen queue (connections are not rejected, but rather slow in being established). What I would like to know is if anyone else out there runs with large numbers of concurrent IMAP sessions via Dovecot and has run into problems. If so, did you have to up your fd limit w/ulimit? Any other issues? -- Steven F. Siirila Office: Lind Hall, Room 130B Internet Services E-mail: sfs(a)umn.edu Office of Information Technology Voice: (612) 626-0244 University of Minnesota Fax: (612) 626-7593

1 1

[Dovecot] dovecot/vpopmail lastauth
by Rick Romero 02 Jan '07

02 Jan '07

Hi All, I have dovecot working wonderfully on a qmail/vpopmail, but I've noticed my 'lastauth' is never filled in.. If I use vpopmail's pop, and auth to that, then 'lastauth' is updated. It just seems weird that if dovecot is using the vpopmail lib, that lastauth wouldn't be updated. Has anyone else run into this? Thanks Rick

1 0

[Dovecot] Dovecot SASL vs. Micro$oft Outlook and Outlook Express
by Tom Kovar 02 Jan '07

02 Jan '07

Hi, I have just started using Dovecot (1.0.10) SASL behind my Postfix (2.3.3). Everything works fine, as long as I send the SMTP AUTH command manually. When using M$ Outlook (2000 and 2003) and Outlook Express 6, authentification always fails. Turning on the Dovecot auth debug on reveals the reason: Dovecot SASL expects, in accordance with the standards, the following format of the SMTP AUTH command (using the PLAIN auth mechanism): AUTH PLAIN base64_encode("username\0username\0password") whereas the M$ clients send as the second argument only base64_encode("username\0password"), which naturally leads to authentification failure. Postfix apparently does not play any role in this game, as it simply passes the received command arguments to dovecot. Before I start hacking the source myself, I just wanted to ask if somebody has a patch for this M$ shortcoming - as the damned M$ clients are very much spread, I would assume this should be the case... Thanx, --- Tom

4 4

[Dovecot] almost there with procmail and dovecot
by M. Fioretti 30 Dec '06

30 Dec '06

Hello, I am running dovecot-1.0-0_34 on Centos 4.4 In dovecot.conf I have: default_mail_env = maildir:/var/spool/mail/vhosts/%n/%d the content of that folder is: drwxrwxr-x 3 vmail vmail 4096 Dec 30 05:23 .. drwx------ 5 vmail vmail 4096 Sep 12 13:55 .Drafts drwx------ 5 vmail vmail 4096 Dec 29 18:26 .Sent drwx------ 5 vmail vmail 4096 Dec 30 03:37 .Trash drwx------ 5 vmail vmail 4096 Dec 30 05:23 INBOX drwx------ 5 vmail vmail 4096 Dec 30 05:10 INBOX.work drwx------ 5 vmail vmail 4096 Dec 30 05:10 INBOX.family drwx------ 2 vmail vmail 8192 Dec 30 03:32 cur -rw------- 1 vmail vmail 681 Dec 30 02:38 dovecot-uidlist -rw------- 1 vmail vmail 144 Dec 30 03:32 dovecot.index -rw------- 1 vmail vmail 21504 Dec 30 03:32 dovecot.index.cache -rw------- 1 vmail vmail 110300 Dec 30 03:32 dovecot.index.log drwx------ 2 vmail vmail 4096 Dec 30 03:25 new -rw-r--r-- 1 root root 18 Dec 30 05:21 subscriptions drwx------ 2 vmail vmail 4096 Dec 30 02:34 tmp and the subscription file contains: Sent Trash Drafts For reasons not really relevant here I need to use procmail as MDA: all the INBOX* Maildir folders are created by procmail with recipes like this: MAILDIR=same as in dovecot default_mail_env :0: * ^From: dad(a)his.isp.com INBOX.family #everything else goes to: :0 * w INBOX/ The problem right now is that procmail delivers all messages correctly but the folders are invisible to squirrelmail. From its interface I can only see Sent, Trash and Drafts. Is this a folder naming problem, a configuration issue or what? How must I name those inboxes and/or reconfigure dovecot to have those folders accessible in squirrelmail? TIA, Marco

2 1

[Dovecot] cross compiling dovecot
by Martin Höfling 29 Dec '06

29 Dec '06

I have the problem that configure can't run the binaries, due to crosscompiling. How can you solve these issues with ./configure? checking whether size_t is signed... configure: error: cannot run test program while cross compiling See `config.log' for more details. I configure with a mipsel cross compiler. Cheers Martin

2 1

[Dovecot] Correct naming scheme for dovecot / squirrelmail subfolders?
by M. Fioretti 28 Dec '06

28 Dec '06

Hello, I am running dovecot 1.0-0_34.rc15 and squirrelmail 1.4.8-2 on a Centos 4 server. Right now all messages are delivered to maildir /var/mail/vhosts/virtual_mail_root/, which has its cur, tmp, new subdirectories. I need to (re) configure postfix, dovecot and squirrelmail so that email is filtered and dovecot serves different boxes to squirrelmail, that is when I log in in squirrelmail I see: Inbox work (5) friends (6) lists (35) Sent Trash Spam that is every subfolder listed under Inbox with the number of unread messages. Now, I do know how to filter incoming email in different folders with postfix. The part still missing, in spite of several online searches, is the correct _naming_ and nesting of all the new mailboxes. In other words, if now everything goes into /var/mail/vhosts/virtual_mail_root/ : 1) what is the currect _name_ to give to the future "work" inbox ?? /var/mail/vhosts/virtual_mail_root/work/ /var/mail/vhosts/virtual_mail_root/INBOX.work/ what else? 2) which parameters must be changed and how in dovecot and/or squirrelmail (or any IMAP client in my home PC) so that folders are recognized and displayed as I wish? Thanks in advance for any feedback, Marco -- The right way to make everybody love Free Standards and Free Software: http://digifreedom.net/node/73

1 0