- dovecot - dovecot.org

Re: [Dovecot] MySQL client out of memory error
by Jakob Hirsch 07 Feb '06

07 Feb '06

Alexander Shikoff wrote: >> > Can anybody say is there a bug in dovecot or this this issue is >> > mysql-specific problem? >> There was a memory leak fixed in the mysql driver, so you might want to >> use the CVS current, wait for beta3 (better than use alphax, anyway), or >> fix it yourself (should be not that hard). > Thanks a lot! > /me is going to download one of the latest CVS snapshots. You are welcome. I'd say they are usually quite stable and a good way to check if your problem was fixed, even if you only look into the changelog. PS: Please keep list traffic on the list and honour other people's Reply-To header.

1 0

[Dovecot] auth: out of memory
by Branko F. Gračnar 07 Feb '06

07 Feb '06

Hello :) I just couldn't login to my dovecot imap (1.0-beta2). Dovecot authenticates from mysql database. Feb 6 19:47:33 elfstone dovecot: auth-worker(default_with_listener): sql(damirh(a)noviforum.si): User query failed: MySQL client run out of memory Feb 6 19:47:52 elfstone dovecot: auth-worker(default_with_listener): ^GOut of memory (Needed 8164 bytes) Feb 6 19:47:52 elfstone dovecot: auth-worker(default_with_listener): sql(bfg(a)noviforum.si): User query failed: MySQL client run out of memory Feb 6 19:48:19 elfstone dovecot: auth-worker(default_with_listener): ^GOut of memory (Needed 8164 bytes) Feb 6 19:48:19 elfstone dovecot: auth-worker(default_with_listener): sql(bfg(a)noviforum.si): User query failed: MySQL client run out of memory Feb 6 19:48:19 elfstone dovecot: auth-worker(default_with_listener): ^GOut of memory (Needed 8164 bytes) Restarting dovecot solved the problem. Ofcourse, machine didn't run into memory problems. Slackware 9.1, linux 2.6. Best regards, Brane

2 3

[Dovecot] MySQL client out of memory error
by Alexander Shikoff 07 Feb '06

07 Feb '06

Hi, I'm using Dovecot 1.0-alpha5 as POP3 server with MySQL DB of users. Sometimes clients get an authentication errors. In this time dovecot writes to log file next lines: Feb 7 11:14:30 orion dovecot: auth-worker(default): sql(user(a)mydomain.com.ua,192.168.3.36): Password query failed: MySQL client run out of memory Feb 7 11:14:30 orion dovecot: auth-worker(default): sql(user(a)mydomain.com.ua,192.168.3.36): Password query failed: MySQL client run out of memory Feb 7 11:14:33 orion dovecot: auth-worker(default): sql(user(a)mydomain.com.ua,192.168.3.36): Password query failed: MySQL client run out of memory Feb 7 11:14:33 orion dovecot: auth-worker(default): sql(user(a)mydomain.com.ua,192.168.3.36): Password query failed: MySQL client run out of memory Can anybody say is there a bug in dovecot or this this issue is mysql-specific problem? Thanks in advance, Alexander -- Kind Regards, Alexander Shikoff minotaur(a)crete.org.ua

2 1

[Dovecot] dovecot rpms, .subscriptions file, mbox to maildir
by Saurabh Barve 07 Feb '06

07 Feb '06

Hi, I am running dovecot 0.99-14 on a Fedora Core 2 machine. I had a few questions: 1) I wanted to upgrade to the dovecot-1.0 release. However, I am not sure if that's really required. dovecot-0.99-14 has been running very well for me for quite some time. Is there a real advantage to switching to the latest release. The reason I'm asking this is because: i) I don't have too many users to server - around 15 only. ii) My mail server is a pretty fast machine (~1 GHz, 1 GB RAM) machine, so hardware isn't too much of an issue. iii) I like to install software from rpm's. It's not that I can't install from source, but installing from rpm's makes it much easier for me. Just a personal preference. The version of dovecot that I am running was obtained from Dag Wieers web site. I haven't seen a newer version there. I've googled for rpm's for newer versions, and they are available, but I don't want to install it from some third party source that I don't know/trust. iv) I am also planning to support web mail for my users (probably through Squirrelmail). Are there any advantages/disadvantages to upgrading dovecot for that? v) People use Mozilla Mail, Mail.app, Thunderbird, Outlook, and Opera. Does the 1.0 version provide better integration with different mail clients (even though I understand that sometimes it's a problem with the client implementation). So, are there newer version of dovecot (1.0-stable) available in rpm formats which are guaranteed to be safe and un-trojaned? And is there any really good reason why I should upgrade to 1.0-stable? 2) My second question is about creating the .subscriptions (or subscriptions in 1.0) file. When I moved people over from using pine to using a mail client like Evolution/Thunderbird, I had to create .subscriptions/.mailboxlist file for them so that they could see the folders that they had created in pine. However, people still sometimes access e-mail using pine. They then create new folders in pine, which they are unable to see in their mail client. Is there a way around it? This occurs especially when people check their mail at the start of the month, and pine asks about saving/deleting old sent-mail folders, Trash folders. Is there a way to add these folders automagically to the .subscriptions file? 3) Would I be able to support web mail using mailboxes in mbox format, as I have them now? Or do I have to go for Maildir format? Since our university introduced web mail, they have had two sets of folders - one with capitalization (Sent, Deleted Messages, etc.) and one without (sent-mail, etc. - these were from our pine days). Is this due to web mail? Also, if I do need to convert from mbox to Maildir, what is the standard tool for doing that? I saw at least three different tools/scripts for doing that (mbox2maildir,mb2d,mb2md-2,mb2md.pl, .. ). Which tool (and from where) should I use to convert mailboxes without problems? Any help is greatly appreciated. Thanks in advance, Saurabh. ----- sa(a)atmos.colostate.edu

5 12

[Dovecot] Any change of integrating this patch???
by Tony Kay 07 Feb '06

07 Feb '06

There was a patch posted to fix dotfile folder names in this mail: http://www.dovecot.org/list/dovecot/2005-July/008127.html I have a web mail client (which stores preferences in a dot-file/folder through IMAP) and pine users (address book is a dot-folder in IMAP) that this affects. I can certainly hand-apply the patch, but I'd feel a lot more comfortable if this had some future in the real source. -- Anthony Kay University Computing Center (541) 346-1719 GPG Fingerprint: B0DB D46A 60AF FAE7 A94A 5075 0CB4 4D88 9F4F 7F09 I have earned my disillusionment.

1 0

[Dovecot] Newbie question
by Peter Lindgren 07 Feb '06

07 Feb '06

Hi, Finally I managed to build (as ordinary user in my home dir) 1.0b2. (remember, I had problems with db-ldap.h disappeared after compile) What is the (simplest and) safest way to shut down dovecot on the live server and replace the running 0.99.14? I run OpenBSD 3.7 on Sparc. The last step would be 'make install', of course. To shutdown dovecot the last time I resorted to kill processes but I felt I had missed something... the install page (http://wiki.dovecot.org/BasicInstall) says to kill it, it feels a little crude; no nicer signals to send? Bear with me, please... /Peter -- Peter Lindgren, dataingenjör E-post: peter "at" norrskenkonsult punkt com http://www.norrskenkonsult.com

1 0

[Dovecot] Shared maildirs
by Charles Marcus 06 Feb '06

06 Feb '06

Hi, This is the one thing holding me back from switching to Dovecot... Can anyone give a realistic timeframe for when Shred maildirs will be officially supported? Thanks... other than that missing piece, Dovecot rocks! Charles

6 15

[Dovecot] Panic: key not found from hash
by Hans-Jürgen Mehnert 06 Feb '06

06 Feb '06

Hello, we have about 120 servers doing some million mails per day. Most of them use dovecot for pop and imap. In version 1.0.alpha4 we have dovecot-crashes on one or two of the machines in a week where dovecot log says "Panic: key not found from hash" and dovecot dies. We tried version 1.0.beta2 on some machines but with that we have another problem where log says "Error: auth-worker(default): sql((USER),(IP)): Password query failed: MySQL client run out of memory" and the auth process dies. Couldn't find anything usefull on that on the net so i'll ask the list bevor i'll post a bug report. ==================== /etc/dovecot.conf ==================== # dovecot pop3 + imap config (rpm) # SG PN HJM 2005-09-09 ## Main protocols = imap imaps pop3 pop3s # protocols = pop3 pop3s ssl_disable = no ssl_cert_file = /etc/ssl/cert ssl_key_file = /etc/ssl/key disable_plaintext_auth = no log_path = /var/log/dovecot ## Login processes login_processes_count = 2 login_max_processes_count = 128 login_max_logging_users = 256 # Greeting message for clients. login_greeting = Dovecot ready. ## Mail processes max_mail_processes = 1024 verbose_proctitle = yes verbose_ssl = no first_valid_uid = 500 last_valid_uid = 0 first_valid_gid = 0 last_valid_gid = 0 mail_extra_groups = mail_debug = no #default_mail_env = #mail_save_crlf = no #mmap_disable = no #lock_method = fcntl #maildir_stat_dirs = no #maildir_copy_with_hardlinks = no #mbox_read_locks = fcntl #mbox_write_locks = dotlock fcntl #mbox_lock_timeout = 300 #mbox_dotlock_change_timeout = 30 #mbox_dirty_syncs = yes #mbox_very_dirty_syncs = no #mbox_lazy_writes = yes #umask = 0077 #mail_drop_priv_before_exec = no #mail_process_size = 256 #mail_log_prefix = "%Us(%u): " ## IMAP specific settings protocol imap { imap_max_line_length = 65536 login_greeting_capability = no imap_client_workarounds = outlook-idle mail_use_modules = yes mail_modules = /usr/lib/dovecot/imap } ## POP3 specific settings protocol pop3 { pop3_no_flag_updates = no pop3_enable_last = yes pop3_uidl_format = %08Xu%08Xv pop3_client_workarounds = outlook-no-nuls oe-ns-eoh mail_use_modules = yes mail_modules = /usr/lib/dovecot/pop3 } ## Authentication processes auth_verbose = no auth_debug = no auth_worker_max_count = 30 auth default { mechanisms = plain # SQL database - normal passdb sql { args = /etc/dovecot-sql.conf } # SQL database - normal userdb sql { args = /etc/dovecot-sql.conf } user = root count = 1 } ==================== /etc/dovecot-sql.conf ==================== driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=(DB) user=(DBUSER) password=(DBPWD) default_pass_scheme = CRYPT password_query = SELECT pwhash AS password, user FROM mail_mailboxes WHERE (user = '%n' AND active = 'Y' AND (type != 'smtp') AND (type = 'imap' OR '%s' = 'pop3')) OR (mainuser = '%n' AND user = CONCAT('%n','mail0') AND (type != 'smtp') AND (type = 'imap' OR '%s' = 'pop3')) user_query = SELECT location AS home, uid, gid, user AS system_user FROM mail_mailboxes WHERE (user = '%n') OR (mainuser = '%n' AND user = CONCAT('%n','mail0')) ==================== table structure ==================== CREATE TABLE mail_mailboxes ( mainuser varchar(128) NOT NULL default '', domain varchar(128) NOT NULL default '', user varchar(128) NOT NULL default '', addr varchar(128) NOT NULL default '', type set('pop3','imap','smtp') NOT NULL default 'pop3', active set('Y','N') NOT NULL default 'Y', pwhash varchar(255) NOT NULL default 'unset', quota int(11) NOT NULL default '0', location varchar(255) NOT NULL default 'unset', uid int(11) NOT NULL default '0', gid int(11) NOT NULL default '0', PRIMARY KEY (user) ) TYPE=MyISAM;

2 1

[Dovecot] Mixed IMAP/POP3 environment and message status flags
by Denis Sbragion 06 Feb '06

06 Feb '06

Hello All, I'm trying to migrate from UW Imap to Dovecot (latest 1.0 beta 2). The target is to go from the actual environment (Eudora + POP3) to a web based IMAP environment (IMAP + SquirrelMail). While migrating we will need to keep both environments for some time, with users having both the ability to use Eudora through POP3 while in the office and also the ability to check e-mail using the web based interface from time to time when they are out of office. Everything seems to work pretty well except for one little quirk. Whenever new mail messages are checked on-line through IMAP they are marked with "Status: O" or "Status: RO" in the main INBOX file (which is kept in the old mbox format now, and is one of the many reasons for the Dovecort choice). This is correct following the RFC standards but after that the POP3 server seems to completely ignore any message marked as "O" or "RO", making it impossible to download previously seen/read messages through Eudora. I've checked any available Eudora and Dovecot setting, including the pop3_no_flag_updates flag, but so far nothing worked. Looking at mailing list archives it looks like this behaviour is intentional and has been introduced to work around some problems with Eudora when the "Leave mail on server" option is enabled. Nevertheless it seems there's still something wrong. UW Imap seems to get this right, it lets Eudora download the already read message, which are correctly downloaded already marked as read. I haven't been able to identify the source of the problem, i.e. if it is either an Eudora problem which UW circumvent in some way or a real Dovecot problem. I'd really like to move to Dovecot, which provides many feature which are really useful for our situation, expecially maildir folders, which are fast and much more "differential backup" friendly than single file mailboxes. Unfortunately this IMAP/POP3 interaction problem would be a major showstopper because it will prevent a smooth migration from the old environment to the new one. Any hint about this issue? Anybody faced a similar problem so far? Thanks in advance for any help, and my compliments for the excellent job performed so far. Dovecot seems to be the right tool to fill the gap between the simpler UW and the Cyrus monster. Keep on going! :) Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

1 0

[Dovecot] dovecot-cvs/mysql-5.0.18 OLD/PASSWORD problem
by John Wong 06 Feb '06

06 Feb '06

i use openbsd/i386, dovecot-cvs(today), mysql-5.0.18 today, i change the mysql_dbuser_password form OLD_PASSWORD to PASSWORD then dovecot can't connect to mysql-server shell$> mysql -u root -p mysql$> SET PASSWORD FOR 'db_user'@'localhost' = PASSWORD('db_pw'); now, dovecot CAN NOT connect to mysql-server shell$> mysql -u root -p mysql$> SET PASSWORD FOR 'db_user'@'localhost' = OLD_PASSWORD('db_pw'); now, dovecot CAN connect to mysql-server and everything work fine i patched src/lib-sql/driver-mysql.c to test, use something like: i_error("host(%s), db->user(%s), db->password(%s), db->dbname(%s) ....); before mysql_real_connect(), then see the maillog, the db->user/password/dbname is correct maillog: auth-worker(default): conn->mysql is NOT NULL auth-worker(default): host((null)), db->user(db_user), db->password(db_pw), db->dbname(dbname), db->port(0), unix_socket(/mysql.sock), db->client_flags(0) auth-worker(default): failed: (1) auth-worker(default): mysql: Connect failed to (null) (dbname): Access denied for user 'db_user'@'localhost' (using password: YES) - waiting for 1 seconds before retry i wrote a small c program to test, it can success connect to mysql, use same user/password/dbname, with both OLD_PASSWORD/PASSWORD why dovecot can't to connect to mysql-server with PASSWORD? help please, thank you base_dir = /var/dovecot/ ssl_cert_file = /etc/ssl/certs/mail.crt ssl_key_file = /etc/ssl/private/mail.key disable_plaintext_auth = no login_dir = /var/dovecot/login login_user = _dovecot valid_chroot_dirs = /var/spool/postfix/var default_mail_env = maildir:%h/%u mmap_no_write = yes protocol imap { imap_client_workarounds = delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep } protocol pop3 { pop3_uidl_format = %08Xu%08Xv pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } auth default { mechanisms = plain passdb sql { args = /etc/dovecot-sql.conf } userdb static { args = uid=32765 gid=32765 home=/var/spool/postfix/var/./mail } user = _dovecot-auth chroot = /var/dovecot/auth socket listen { client { path = /var/spool/postfix/private/dovecot-auth mode = 0600 user = _postfix } } } driver = mysql connect = host=/mysql.sock dbname=dbname user=db_user password=db_pw default_pass_scheme = PLAIN-MD5 password_query = SELECT password FROM users WHERE userid = '%n' AND %Ls = '1' AND active = '1' --- src/lib-sql/driver-mysql.c.orig Mon Feb 6 23:07:42 2006 +++ src/lib-sql/driver-mysql.c Mon Feb 6 23:39:36 2006 @@ -112,11 +112,17 @@ } alarm(MYSQL_CONNECT_FAILURE_TIMEOUT); + i_error("conn->mysql is %s NULL", conn->mysql == NULL ? "" : "NOT"); + i_error("host(%s), db->user(%s), db->password(%s), db->dbname(%s), " + "db->port(%u), unix_socket(%s), db->client_flags(%u)", + host, db->user, db->password, db->dbname, db->port, unix_socket, + db->client_flags); failed = mysql_real_connect(conn->mysql, host, db->user, db->password, db->dbname, db->port, unix_socket, db->client_flags) == NULL; alarm(0); if (failed) { + i_error("failed: (%i)", (int)failed); if (conn->connect_failure_count > 0) { /* increase delay between reconnections to this server */

1 0