Hi, I'm using dovecot 1.2.5 with mysql backend and seems in this new version I have issues when loggin in, especially if there are mails in Inbox folder.
NOTE: version 1.2.4 worked perfectly and mysql was updated to version 5.0.86 from source code.
Here is my configuration and core dump:
/applications/dovecot-mail/sbin/dovecot --version 1.2.5
/applications/dovecot-mail/sbin/dovecot -n # 1.2.5: /applications/dovecot-mail/conf/dovecot.conf # OS: Linux 2.6.18-164.el5 i686 CentOS release 5.3 (Final) ext3 base_dir: /var/run/dovecot/ log_path: /var/log/dovecot.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3s login_dir: /var/run/dovecot/login login_executable(default): /applications/dovecot-mail/libexec/dovecot/imap-login login_executable(imap): /applications/dovecot-mail/libexec/dovecot/imap-login login_executable(pop3): /applications/dovecot-mail/libexec/dovecot/pop3-login login_greeting: Hi buddy, got an account? login_processes_count: 4 login_max_processes_count: 64 max_mail_processes: 1024 last_valid_uid: 10005 mail_privileged_group: mail mail_location: mbox:/srv/mail/vmail/%d/%n mail_debug: yes maildir_copy_preserve_filename: yes mbox_read_locks: dotlock fcntl mail_drop_priv_before_exec: yes mail_executable(default): /applications/dovecot-mail/libexec/dovecot/imap mail_executable(imap): /applications/dovecot-mail/libexec/dovecot/imap mail_executable(pop3): /applications/dovecot-mail/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /applications/dovecot-mail/lib/dovecot/imap mail_plugin_dir(imap): /applications/dovecot-mail/lib/dovecot/imap mail_plugin_dir(pop3): /applications/dovecot-mail/lib/dovecot/pop3 imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep imap_client_workarounds(pop3): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh auth default: mechanisms: plain login cache_size: 10240 cache_ttl: 1800 passdb: driver: pam args: cache_key=%u%r%l dovecot passdb: driver: sql args: /applications/dovecot-mail/conf/dovecot-mysql.conf userdb: driver: sql args: /applications/dovecot-mail/conf/dovecot-mysql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 432 user: dovecot group: mail
grep -v '^ *\(#.*\)\?$' /applications/dovecot-mail/conf/dovecot-mysql.conf
driver = mysql default_pass_scheme = PLAIN-MD5 connect = host=localhost dbname=mail user=mail password=XXXXXXX password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT '/srv/mail/vmail/%d/%n' as home, 'maildir:/srv/mail/vmail/%d/%n' as mail, 10005 AS uid, 12 AS gid, concat('dirsize:storage=',quota) AS quota FROM mailbox WHERE username ='%u' AND active ='1'
gdb /applications/dovecot-mail/libexec/dovecot/imap
pwd/core.20557 GNU gdb Fedora (6.8-27.el5) Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "i386-redhat-linux-gnu"... (no debugging symbols found)
warning: Can't read pathname for load map: Input/output error. Reading symbols from /lib/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/librt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/librt.so.1 Reading symbols from /lib/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/ld-linux.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/libpthread.so.0...(no debugging symbols found)...done. Loaded symbols for /lib/libpthread.so.0 Reading symbols from /applications/dovecot-mail/lib/dovecot/imap/lib10_quota_plugin.so... (no debugging symbols found)...done. Loaded symbols for /applications/dovecot-mail/lib/dovecot/imap/lib10_quota_plugin.so Reading symbols from /applications/dovecot-mail/lib/dovecot/imap/lib11_imap_quota_plugin.so...(no debugging symbols found)...done. Loaded symbols for /applications/dovecot-mail/lib/dovecot/imap/lib11_imap_quota_plugin.so Reading symbols from /usr/lib/gconv/ISO8859-1.so...(no debugging symbols found)...done. Loaded symbols for /usr/lib/gconv/ISO8859-1.so (no debugging symbols found) Core was generated by `imap'. Program terminated with signal 11, Segmentation fault. [New process 20557] #0 0x00000000 in ?? () (gdb) backtrace #0 0x00000000 in ?? () (gdb) quit